|
 |
asp_discuss thread: Re: Records found question
Message #1 by "Line Spongsveen" <line@k...> on Thu, 3 Jan 2002 11:55:02
|
|
Hello,
I had exactly the same problem, but I posted the question to another discussion list and got this url:
http://www.adopenstatic.com/faq/recordcounterror.asp
which explained what is happening.
Hope this soles your problem.
Line Spongsveen
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_006B_01C18E4E.93ECD690
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> If anyone can help - my thanks ...
>
> Using the following code ...
>
> "intRecords =3D adoRS.RecordCount"
>
> I expect "intRecords" to contain the count of the number of records
> found from a SQL Query. When I test however I always get "-1" ... But, I
> know the SQL Query has worked properly, because I can loop through and
> display all of the records found.
>
> I know this should work ... Aaaaargh.
>
> Chip Dukes
>
>
> ------=_NextPart_000_006B_01C18E4E.93ECD690
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html;
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 6.00.2600.0" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>If anyone can help - my thanks
> ...</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Using the following code
> ...</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV>"intRecords =3D adoRS.RecordCount"</DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>I expect "intRecords" to contain the
> count of the
> number of records found from a SQL Query. When I test however I always
> get "-1"
> ... But, I know the SQL Query has worked properly, because I can
> loop
> through and display all of the records found.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>I know this should work ...
> Aaaaargh.</FONT></DIV>
> <DIV> </DIV>
> <DIV><FONT face=3DArial size=3D2>Chip Dukes</FONT></DIV>
> <DIV> </DIV></BODY></HTML>
>
> ------=_NextPart_000_006B_01C18E4E.93ECD690--
>
>
|
|
|
View Cart
