Thank you for your reply, but I haven't gotten it working yet.
The code in my first post was from my working stack. Here is what
I have from my non-working stack after re-writing to follow your
instructions:
------------
# Construct SQL
put "INSERT INTO
contactInfo(key,organization,denomination,address,category,tel,fax,email,access,founded,staff,servicetime,web,character)"
& \
" VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,:12,:13,:14)" into tSQL
# Execute SQL
revExecuteSQL(gconnection,tSQL,vkey,vorg,vdenom,vadd,vcategory,vtel,vfax,vemail,vaccess,vfounded,vstaff,vtime,vweb,vcat)
put the result into tTmp
------------
The table name is "contactInfo" and the list of the table's
fields is in the paranthesis.
The VALUES(:1,:2.... syntax is something I haven't seen before.
I assume that you need as many numbers as you have fields?
You say to use variables, and I am assuming in the
"revExecuteSQL" line. Is that correct? I tried the list of
variables both with the quotes you used, and without just to see.
I also tried replacing the revExecuteSQL comman with
revdb_execute. Both result in this error: {execution error at
line n/a (External handler execution error: revdberr,syntax
error) near "revdberr,syntax error"}
I appreciate your taking the time to educate me.
Tim Selander
On 2019.02.16 16:12, Ludovic THEBAULT via use-livecode wrote:
Le 16 févr. 2019 à 07:59, Tim Selander via use-livecode
<use-livecode@lists.runrev.com> a écrit :
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.
Hello,
use this syntax :
put "INSERT INTO
podcast(IP,accesstime,access_date,pgm_name,access_code,bytes,agent,city,region,country)"
& \
" VALUES(:1,:2,:3,:4,:5,:6,:7,:8,:9)" into tSQL
# Execute SQL
revExecuteSQL
gconnection,tSQL,"IP","accesstime","access_date","pgm_name","access_code","bytes","agent","city","region
», "country »)
put the result into tTmp
// where IP, accesstime… are variables
Ludovic
_______________________________________________
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
_______________________________________________
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
