Thanks for the response, Esoteric!
That doesn't make a lot of sense to me, since the other set of code (using a different query and recordset but otherwise identical) works properly, but I tried it using:
if not rsTCList.EOF then
do while not rsTClist.EOF
Response.Write...
Below are two virtually identical sets of code. Both queries work properly and return the expected recordsets when using Enterprise Manager, but while the first set (lines currently commented out) return the records in my ASP page, the second set returns the following error message:
Error...
I have now tried all three methods described on Microsoft's HOWTO page- http://support.microsoft.com/default.aspx?scid=kb;EN-US;q164485
My two most recent attempts are:
'Set cn = Server.CreateObject("ADODB.Connection")
'Set rsPlatforms =...
I'm trying to call a stored procedure:
CREATE PROCEDURE usp_osArray @Prodver numeric(9) AS SELECT Short, OS FROM platforms WHERE ProdVer= @ProdVer ORDER BY OSID DESC
using the following code:
Set cmdPassProdVer = Server.CreateObject("ADODB.Command")
cmdPassProdVer.CommandType =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.