Re: recordcount = -1 ??

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mich (mich_at_nomail)
Date: 11/08/04 

Date: Mon, 8 Nov 2004 14:40:46 +0100

Thanks, but i need to run that query from Access (with parameter wwk). Is
there no parameter i can use to change the cursor in order to get the
recordcount (and also to get rs.fields("maandag").value)?

"McKirahan" <News@McKirahan.com> wrote in message
news:C7Ijd.61194$HA.25228@attbi_s01...
> "Mich" <mich@nomail> wrote in message
> news:O6iHv9WxEHA.2564@TK2MSFTNGP12.phx.gbl...
> > Hi,
> >
> > I defined a query (name = myquery) in Access like this:
> > SELECT
> >
>
IIf([wwk]='Maandag',[maandag],IIf([wwk]='Dinsdag',[dinsdag],IIf([wwk]='Woens
> > dag',[woensdag],IIf([wwk]='Donderdag',[donderdag],[vrijdag]))))
> > FROM daguur;
> > When executing in Access and filling e.g. 'maandag' as parameter, it
works
> > (10 records). No problem.
> >
> > In ASP:
> > set OBJDC = Server.CreateObject("ADODB.Connection")
> > objdc.Open("provider=Microsoft.Jet.OLEDB.4.0; Data Source =c:\mydb.mdb")
> > set rs=Server.createObject("ADODB.recordset")
> > objdc.myquery wwk,rs
> > rec=rs.recordcount
> >
> > My problem is: no error, but rec = -1.
> > Any idea why i don't get the 10 records?
> > Thanks
> > Mich
>
> http://www.aspfaq.com/show.asp?id=2193
>
>