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

[Andy Gaunt]

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