ODBC Count Field Incorrect

I am using SQL 2000

The _ScriptLibrary/Recordset.asp is part of the built in stuff that just automatically gets inserted when you create a new product.

Here is some of the code from the recordset that it is having a problem with...

<SCRIPT LANGUAGE="JavaScript" RUNAT="server">
function _setParametersRecordset1()
{
      Recordset1.setParameter(0,Session("SalesRep"));
}
function _initRecordset1()
{
      Recordset1.advise(RS_ONBEFOREOPEN, _setParametersRecordset1);
      var DBConn = Server.CreateObject('ADODB.Connection');
      DBConn.ConnectionTimeout = Application('Database_ConnectionTimeout');
      DBConn.CommandTimeout = Application('Database_CommandTimeout');
      DBConn.CursorLocation = Application('Database_CursorLocation');
      DBConn.Open(Application('Database_ConnectionString'), Application('Lumbermens_RuntimeUserName'), Application('Database_RuntimePassword'));
      var cmdTmp = Server.CreateObject('ADODB.Command');
      var rsTmp = Server.CreateObject('ADODB.Recordset');
      cmdTmp.ActiveConnection = DBConn;
      rsTmp.Source = cmdTmp;
      cmdTmp.CommandType = 1;
      cmdTmp.CommandTimeout = 10;
      cmdTmp.CommandText = 'select * from table where field = ?';
      rsTmp.CacheSize = 10;
      rsTmp.CursorType = 3;
      rsTmp.CursorLocation = 3;
      rsTmp.LockType = 3;
      Recordset1.setRecordSource(rsTmp);
      Recordset1.open();
      if (thisPage.getState('pb_Recordset1') != null)
            Recordset1.setBookmark(thisPage.getState('pb_Recordset1'));
}
function _Recordset1_ctor()
{
      CreateRecordset('Recordset1', _initRecordset1, null);
}
function _Recordset1_dtor()
{
      Recordset1._preserveState();
      thisPage.setState('pb_Recordset1', Recordset1.getBookmark());
}
</SCRIPT>

Thanks.

Parameters using the ? mark can cause this error when converting from access to mssql.  Post the code where you create the query and pass the parameter and I can show you how to change it to make it work.

Thomas

I'm not converting from access to mssql. I've always used sql for my database. I'm switching from windows NT to windows 2000 server. Above is the recordset where I pass in the parameter.

Okay, sorry about that, good luck.

how about doing a response.write at the top of the page to check your session variable that you are passing as a parameter?
put this as the second line after setting the code language
<%
response.write "Salesrep="+cstr(Session("SalesRep"))
%>

and see what the value of that session variable is

also - try hardocding the session variable to make sure it is going to work

Session("SalesRep")="bigbilly"

it has to be something with your parameters going into the recordset
no other reason the recordset object should return that error unless its not dealing wit hthe passed paramter properly

I hard coded in the parameter and it works just fine. It is only when I have the question mark (select * from table where field = ?)

I transfered an intranet based application from windows NT to windows 2000 using the same code and that works just fine. Do you think it has anything to do with the firewall?

no - i dont beleive it is a firewall issue at all

It has to do with the setting of the parameter - since it works when hard coded
the code you are posting - it looks like the output of a DTC recordset control
is that correct?

something looks fishy about your recordset objecti cant seem to figure out how you set it up to work like that
can you tell me more about what you are trying to accomplish?
I have used VI for a long time, and have found alot easier methods than using the DTC recordset controls
i'd be glad to share if you tell me what you are trying to do
cheers

I did figure my problem out, but if there is an easier method that I should be using, I'm all about learning!

First let me explain how I fixed my problem.

I was coping all files to my new server, including the files that normally get created by creating a new project. I decided to delete those and only copied my .asp/.htm pages. I created a new project (on the new server with the same name as it was on the old server), set up my dataconnection, then I copied my .asp/.htm pages. That was set one of fixing my problem.

Set two. I forgot about that I was using the global.asp to pass in some parameters/login information. I added that code, which gave me another error.

I then checked my ODBC connection and realized I was still pointing at our old database. Once I established an odbc connection to the correct database, it started working.

It is always the little things that should be so easy that always get you!

Thank you to all your suggestions!

Back to what BIGBILLYDOTCOM was talking about.

What I'm trying to do is when a sales rep enters their username (salesrep number), they get their customer information. That mainmenu page when they login takes their salesrep number and puts it as a session variable.

Another thing it does is there are other people that have access to login that are not salesreps that need access particular pages. The mainmenu determines if they are a sales rep, if they are a sales rep it displays buttons that a non-salesrep would not see. If they aren't a sales rep then they get other buttons and other access to different pages.

Other pages do other things. I always use the recordset DTC control and use the recordset.updaterecord, etc. But if there is a better way, by all means, share!