Using Post tData?

[JOHN PATTEN]

Thanks Dave! 

That was my problem. I have to commit that to long term memory now…I got a faint Déjà vu after reading your reply :(

Thank Again!


Déjà vu

On Sep 23, 2013, at 3:03 PM, Dave Cragg <dave.cragg at lacscentre.co.uk> wrote:

>> But in a lc code stack with a button and two flds I get:
>> "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"
>> 
>> Button's script:  
>> 
>> on mouseUp
>>  post cd fld 1 to URL "http://jpatten.on-rev.com/safetube_student/lc_lookup_list_exec_nc.php"
>>  put it into cd fld 2
>>  answer the result
>> end mouseUp
> 
> 
> John, are you entering just a number in card field 1? If so, the posted data won't be structured correctly. The data you post needs to be formatted like this:
> 
> doccode=19
> 
> So something like this:
> 
> put "doccode=" & cd fld 1 into tPostdata
> post tPostdata to url "http://jpatten.on-rev.com/safetube_student/lc_lookup_list_exec_nc.php"
> 
> Or use libUrlFormData to format the data you are posting.
> 
> Cheers
> Dave Cragg
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode