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