I have a routine to take data from fields on a card and upload to
a mysql database. Has worked well for years, got the original
script off the Livecode learning site.
-------
# Construct SQL
put "INSERT INTO
podcast(IP,accesstime,access_date,pgm_name,access_code,bytes,agent,city,region,country)"
& \
" VALUES(" & tRowData & ")" into tSQL
# Execute SQL
put revdb_execute(gconnection,tSQL) into tTmp
if the result is not 1 then
put the result && tSQL & return after message
end if
---------
tRowData has the data from the card fields, comma delimited.
Now, I'm needing to upload fields with multiple lines. But the
returns in the data mess it up. Tried enclosing the field data in
quotes, like .csv files, but that didn't work either.
MySQL can handle multi-line text fields.... so how do I upload
them from LC? Any hints greatly appreciated.
Tim Selander
Tokyo
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
