Try:
SQL = 'UPDATE tbl2inspectorformgeneration SET inspected = ''5/5/1'''
Single quotes make strings, not double quotes. Two single quotes together
makes for a single quote inside of a string.
-----Original Message-----
From: Lee Fuller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 12:33 PM
To: CF-Talk
Subject: Strange SQL Error...
Has anyone seen this?
There are no "subqueries" going on in this SQL statement.. But yet we get
this error.
==============
ODBC Error Code = 21000 ()
[Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1
value. This is not permitted when the
subquery follows =, !=, <, <= , >, >= or when the subquery is used as an
expression.
SQL = "UPDATE tbl2inspectorformgeneration SET inspected = '5/5/1'"
==============
Clues anyone?
TTAIA!
Lee
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists