SQL problem

[Mark Schonewille]

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