Subquery errors..how to resolve?

mdms · #1 (**permalink**) 06-07-2006, 02:22 PM

I got this error when trying to display information from DB..

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[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.

/procureplus2/interface/admin/regvend_review.asp, line 178

--------------------
Line 178 refers to:

SET oRS = MyConn.Execute(sSQL)

FYI, DB that I used is SQL2005

wajafly · #2 (**permalink**) 02-09-2006, 08:59 AM

Quote:

Originally Posted by mdms

I got this error when trying to display information from DB..

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[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.

/procureplus2/interface/admin/regvend_review.asp, line 178

--------------------
Line 178 refers to:

SET oRS = MyConn.Execute(sSQL)

FYI, DB that I used is SQL2005

I need to see your SQL Statement and some sample data if can....

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Fixing HTML code errors.. isk	experimental	Webmaster Tools	9	30-05-2004 02:18 AM
knapa... done but with errors on page	Syazwan	Website Programming	10	04-02-2004 07:25 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)