Wednesday, March 21, 2012

ExecuteScalar() Returns -1

The following query returns 0 when executing in Query Analyzer:
SELECT isnull(Count(*),0) as total FROM SplitDetail WHERE SiteCode = 14 AND ProjectID = 4367
Yet ExecuteScalar() in vb.net return a -1.

Any ideas on what I might be doing wrong... ?Discovered my error...

The ExecuteScalar method deep in the plumbing of my DAL was actually calling an ExecuteNonQuery() function...

No comments:

Post a Comment