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

[William Akey]

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
>