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