[FX.php List] error 958 parameter missing from query

[Michael Ward]

I also had this problem recently... turns out it was a Trademark  
symbol (™) and a copyright symbol (©) that was mucking something up.

I removed those, and everything worked fine.

Regards

Michael Ward
--
Head Honcho
CustoMike Solutions
Associate, Filemaker Solutions Alliance
FileMaker 7 Certified Developer
10 Wandoo Crt
Wheelers Hill, 3150
ph 0414 562 501
headhoncho at customikesolutions.com

On 31/03/2006, at 7:59 AM, William Akey wrote:

> Hi Andy,
>
> Thanks for your reply. The form does include one or more multi-line
> textfields, specifically asking for biography information -- just  
> the sort
> of thing that people are likely to have written in a word processor  
> like MS
> Word and then paste it into the field. Funny thing is, this never  
> caused a
> problem with FM Unlimited 5.5. Are there any settings in the FM 7  
> database
> that I should know about but may not know?
>
> William
>
>
> ----- Original Message -----
> From: "Andy Gaunt" <andy at fmpug.com>
> To: "'FX.php Discussion List'" <fx.php_list at mail.iviking.org>
> Sent: Thursday, March 30, 2006 1:49 PM
> Subject: RE: [FX.php List] error 958 parameter missing from query
>
>
>> William,
>>
>> We had this issue when people were pasting into a field from word.  
>> It was
>> trying to add all the fun word "code" to the form and causing this  
>> issue.
> We
>> got around this by implementing a Rich Text Editor on that particular
> field
>> (it happens to be used by our training accounts).
>>
>> If you cannot get the system to recreate then it could be a  
>> similar issue.
>> What info are you gathering? Is it a multi line text field or  
>> basic stuff
>> such as name and email?
>>
>> Andy Gaunt
>> T: 407.810.4722
>> andy at fmpug.com
>> http://www.fmpug.com
>>
>> Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award
>>
>> For chapter locations, dates & times please visit the website at
>> http://www.fmpug.com If you can make it to a meeting, please RSVP at
>> http://www.fmpug.com/rsvp.php
>>
>>
>> -----Original Message-----
>> From: fx.php_list-bounces at mail.iviking.org
>> [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of William  
>> Akey
>> Sent: Thursday, March 30, 2006 4:46 PM
>> To: FX.php Discussion List
>> Subject: [FX.php List] error 958 parameter missing from query
>>
>> Hi All,
>>
>> I have been getting reported failures of a simple registration  
>> form that
>> creates a new record in a FM 7 database using FX.php. The reported  
>> error
> is
>> error code 958 which has the description of "parameter missing from
> query".
>>
>> The problem is, I have never been able to make the registration  
>> process
>> fail, so I doubt that there is truly a missing parameter. The  
>> registration
>> process works fine for me, whether I fill in all fields on the
> registration
>> form or leave it blank -- a record is always written to the database.
>>
>> To get a bit more information, I set up the confirmation.php page  
>> to send
> me
>> an email message with all of the user posted data if the query  
>> returns a
>> non-zero error code. One thing I have noted so far is that all of the
>> reported failures have had strange characters in the posted data. All
> except
>> one of the failed registrations has come from international  
>> registrants
> and
>> the one from the USA registrant also included strange characters.
>>
>> The only thing I do to the posted data is to use stripslashes()  
>> and trim()
>> to clean it up. Is there something else I should routinely be  
>> doing with
> the
>> posted data?
>>
>> I did note that the header of the application form had a setting of
>> charset=iso-8859-1 and I have since changed that to charset=utf-8.
>>
>> Your thoughts would be appreciated.
>>
>> Thanks
>>
>> William
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>