[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