SQL problem
Terry Vogelaar
tvogelaar at de-mare.nl
Mon May 4 11:19:15 EDT 2009
Hi all,
I am struggling to get a MySQL database filled. The idea is to use a
form that calls an irev file, that in turn adds to the database.
Here is the script:
<?rev
put revOpenDatabase
("mysql","localhost","terry_dbname","terry_dbuser","password") into
tConID
# Construct SQL
put "INSERT INTO 'terry_dbname'.'tablename' ('login' , 'ww' ,
'toegang') VALUES ('" & $_GET["login"] & "', '" & $_GET["ww"] & "',
'" & $_GET["toegang"] & "');" into tSQL
if tConID is a number then
# Execute SQL
put revDataFromQuery(tab, return, tConID, tSQL) into tList
revCloseDatase tConID
end if
?>
Sample data:
http://terry.on-rev.com/h.irev?login=hafaddegon&ww=%3D%
5DwTjLEl&toegang=xA1%0D%0AxB1
All arguments are URL encoded...
But I get a SQL error... Is anyone seeing what the error could be?
Terry
More information about the use-livecode
mailing list