Hi Terry,
Shouldn't that be revExecuteSQL?
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
http://economy-x-talk.com
http://www.salery.biz
Dutch forum: http://runrev.info/rrforum
New: Snapper Screen Recorder 2.0.1
Download at http://snapper.economy-x-talk.com
On 4 mei 2009, at 17:19, Terry Vogelaar wrote:
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
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
