[thelist] ASP using SQL but anoing me like $%&#

Scott Dexter sgd at ti3.com
Mon Jan 29 11:22:40 CST 2001


"order" is a reserved word, so its puking on that; change the column name to
something else and you should be good to go--

sgd
--
work: http://www.ti3.com/
non: http://thinksafely.org/

> -----Original Message-----
> From: Elfur Logadottir [mailto:elfur at lists.evolt.org]
> 
> strsql = "insert into vinstri
>     (name, url, menu, order)
>      values ('"& strName & "' ,'" & strUrl & "' ,'" &
> strMenu & "' ,'" & strOrder & "')"
> 
> your supposed to name first all the columns and then all the
> values.
> 
> But that still throws an error, and when using access,
> creating a query containing only the SQL statement, it stops
> on the 'order' part in the first parenthesis, claiming
> 'syntax error'




More information about the thelist mailing list