[thelist] SQL statement - What's wrong here?

Warden, Matt mwarden at odyssey-design.com
Fri Jul 7 09:06:26 CDT 2000


What is the output of the SQL statement you have? Updates are in the format
of:

UPDATE [table name] SET [field name]=[new value] WHERE [condition]

Is #url.LineNumber# returning the name of a table? If so, that's quite odd.
If I type myurl.cfm?LineNumber=thisIsntReallyATable, I'll get SQL errors
because that table/view doesn't exist.

--
mattwarden





More information about the thelist mailing list