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

[Dennis Crall]

William,

Since you're getting a parameter missing error, my guess is that you
probably need to convert the string to unicode (see PHP's utf8_encode()
function) and possibly urlencode() the string as well.

I had some problems with searching a FM database when foreign language
characters where involved. I solved that issues like so:

$fx->AddDBParam( 'field', utf8_encode( $_REQUEST[ 'formValue' ] ), "eq" );

Good luck,

Denny


On 3/30/06 4:32 PM, "William Akey" <wcakey at hotmail.com> wrote:

> Thanks Michael,
> 
> Well, it is beginning to come together. Now, the question is, how to prevent
> the posted data from stopping the registration process cold. I obviously
> can't control what people submit, so there has to be a way to clean out the
> junk on the php side of things.
> 
> This is new territory for me. Any  ideas on how to reliably clean out the
> junk in php before submitting the query to the database?
> 
> Thanks
> 
> William
> 
> 
> ----- Original Message -----
> From: "Michael Ward" <headhoncho at customikesolutions.com>
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Sent: Thursday, March 30, 2006 3:13 PM
> Subject: Re: [FX.php List] error 958 parameter missing from query
> 
> 
> 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
> 
> _______________________________________________
> 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