Jump to content

devilish

Newbies
  • Posts

    2
  • Joined

  • Last visited

devilish's Achievements

Newbie

Newbie (1/14)

  • First Post
  • Conversation Starter
  • Week One Done
  • One Month Later
  • One Year In

Recent Badges

0

Reputation

  1. i think you din't get my problem. i realized that i can't use the symbol '@' so i replaced it with '+' . yes i did try the queries natively in filemaker and they work, but the problem is that when i run the query, php calls the URL its gettin "URLencoded" which means '+' becomes '%2B' and i can't even use quotes even they get encoded.. i tried using slashes to escape.. but it doesn't work. no matter what i do.. i can't perform a search.. Hope this is clear..
  2. hi, I'm using PHP FX to interface with Filemaker and i am having a problem in the way fx.php urlencodes DB paramenters before passing it to the Filemaker server.. This is my php script <?php include_once('../fx/fx.php'); include_once('../db_config.php'); $email=test@test.com; $cand=new FX($dbHost,$port,$dbType,$conType); $cand->setDBPassword($dbPass,$dbUser); $cand->setDBData($dbName,'webdev_Candidate'); $cand->AddDBParam('email',$email,'eq'); $cand_data=$cand->FMFind(); $count= $cand_data['foundCount']; unset($cand); echo $count; ?> I checked the url that is being called and its as follows: (i've slightly modified the url by removing slashes from http:// because the forum post is truncating the address ) There is an email record called test@test.com in the database, since i can't use @ in the query i've changed the @ to + using php. http:xxxx:xxxx@zzzzz.moyergroup.com:80/fmi/xml/FMPXMLRESULT.xml?-db=JobPostings&-lay=webdev_Candidate&-max=50&email.op=eq&email=test%2Btest.com&-find This above query returns zero results since filemaker searches for "test%2Btest.com" and not "test+test.com" i've also tried to use quotes but even they are gettin urlencoded to %22 by manually calling the url htp:xxxx:xxxx@zzzzz.moyergroup.com:80/fmi/xml/FMPXMLRESULT.xml?-db=JobPostings&-lay=webdev_Candidate&-max=50&email.op=eq&email=test+test.com&-find it returns the XML page with the resultset correctly Does anyone have any clues how i can fix this, or override php-fx from urlencoding select parameters.. Is there something wrong in my approach? Thanks,
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.