Do you have an update trigger on the table?
-----Original Message-----
From: Lee Fuller [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 04, 2001 2: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
