multi line Livecode field uploaded to MySQL

Tim Selander selander at tkf.att.ne.jp
Sat Feb 16 01:59:54 EST 2019


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




More information about the Use-livecode mailing list