rs.Recordcount isn't working with mySQL

[Roy Danon]

Hi,
I'm using a recordset object to open a sql statement(select * from
tablename)
and for some reason the rs.recordcount value is always 0.
and I know there are above 20 records in this table

is any1 familiar with this problem and knows how to solve it?

Roy.

[Manohar Kamath [MVP]]

[url]http://www.aspfaq.com/show.asp?id=2193[/url]

Perhaps that could help?

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Roy Danon" <admin@droyd.net> wrote in message
news:btov19$5c3$1@news2.netvision.net.il...

> Hi,
> I'm using a recordset object to open a sql statement(select * from
> tablename)
> and for some reason the rs.recordcount value is always 0.
> and I know there are above 20 records in this table
>
> is any1 familiar with this problem and knows how to solve it?
>
> Roy.
>
>

[Roy Danon]

Thanks for the reply,
but it doesn't help..

the first solution is the same as what i'm doin
the second is only for getrows which i don't always use
and the third is for MSSQL...


any other answers?


Roy.


"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message
news:eq9qUX51DHA.484@TK2MSFTNGP10.phx.gbl...

> [url]http://www.aspfaq.com/show.asp?id=2193[/url]
>
> Perhaps that could help?
>
> --
> Manohar Kamath
> Editor, .netBooks
> [url]www.dotnetbooks.com[/url]
>
>
> "Roy Danon" <admin@droyd.net> wrote in message
> news:btov19$5c3$1@news2.netvision.net.il...

> > Hi,
> > I'm using a recordset object to open a sql statement(select * from
> > tablename)
> > and for some reason the rs.recordcount value is always 0.
> > and I know there are above 20 records in this table
> >
> > is any1 familiar with this problem and knows how to solve it?
> >
> > Roy.
> >
> >

>
>

[Aaron Bertrand [MVP]]

> the first solution is the same as what i'm doin

How do we know that? SHOW YOUR CODE.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]

[Roy Danon]

Here you go :)

set rsNewsQuick=server.CreateObject("ADODB.recordset")
sqlNews="SELECT * FROM QuickNews order by id desc"
rsNewsQuick.Open sqlNews,dsn,1,1


Thanks,
Roy.

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:Oh80bR%231DHA.4064@tk2msftngp13.phx.gbl...

> > the first solution is the same as what i'm doin

>
> How do we know that? SHOW YOUR CODE.
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>

[Aaron Bertrand [MVP]]

And which driver are you using to connect to mySQL? Have you consulted its
documentation to see whether it even supports recordcount? If it does not,
have you tried any other driver(s)?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Roy Danon" <admin@droyd.net> wrote in message
news:btre0k$735$1@news2.netvision.net.il...

> Here you go :)
>
> set rsNewsQuick=server.CreateObject("ADODB.recordset")
> sqlNews="SELECT * FROM QuickNews order by id desc"
> rsNewsQuick.Open sqlNews,dsn,1,1
>
>
> Thanks,
> Roy.
>
> "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> news:Oh80bR%231DHA.4064@tk2msftngp13.phx.gbl...

> > > the first solution is the same as what i'm doin

> >
> > How do we know that? SHOW YOUR CODE.
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > [url]http://www.aspfaq.com/[/url]
> >
> >

>
>

[Roy Danon]

Hi,
I'm using the driver my hosting service adviced me to use :

"Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306; Option=0;
Socket=; Stmt=; Database=xxx_xxx; UID=xxx_xxx; PWD=xxx;"

where can i find it's documention?

Roy.

"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:OByO3zE2DHA.1264@TK2MSFTNGP11.phx.gbl...

> And which driver are you using to connect to mySQL? Have you consulted

its

> documentation to see whether it even supports recordcount? If it does

not,

> have you tried any other driver(s)?
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>
>
>
> "Roy Danon" <admin@droyd.net> wrote in message
> news:btre0k$735$1@news2.netvision.net.il...

> > Here you go :)
> >
> > set rsNewsQuick=server.CreateObject("ADODB.recordset")
> > sqlNews="SELECT * FROM QuickNews order by id desc"
> > rsNewsQuick.Open sqlNews,dsn,1,1
> >
> >
> > Thanks,
> > Roy.
> >
> > "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> > news:Oh80bR%231DHA.4064@tk2msftngp13.phx.gbl...

> > > > the first solution is the same as what i'm doin
> > >
> > > How do we know that? SHOW YOUR CODE.
> > >
> > > --
> > > Aaron Bertrand
> > > SQL Server MVP
> > > [url]http://www.aspfaq.com/[/url]
> > >
> > >

> >
> >

>
>

[Manohar Kamath [MVP]]

Roy,

Have you tried looping through the recordset to see if there are any
records, maybe zero is the right answer.

--
Manohar Kamath
Editor, .netBooks
[url]www.dotnetbooks.com[/url]


"Roy Danon" <admin@droyd.net> wrote in message
news:btre0k$735$1@news2.netvision.net.il...

> Here you go :)
>
> set rsNewsQuick=server.CreateObject("ADODB.recordset")
> sqlNews="SELECT * FROM QuickNews order by id desc"
> rsNewsQuick.Open sqlNews,dsn,1,1
>
>
> Thanks,
> Roy.
>
> "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> news:Oh80bR%231DHA.4064@tk2msftngp13.phx.gbl...

> > > the first solution is the same as what i'm doin

> >
> > How do we know that? SHOW YOUR CODE.
> >
> > --
> > Aaron Bertrand
> > SQL Server MVP
> > [url]http://www.aspfaq.com/[/url]
> >
> >

>
>

[Aaron Bertrand [MVP]]

Did you try [url]www.mysql.com?[/url]

Also, there are methods in the article posted that you may have missed or
ignored, such as:

set rs = conn.execute("SELECT COUNT(*) FROM table WHERE ...")
response.write rs(0) & " rows."
set rs = conn.execute("SELECT * FROM table WHERE ...")
if not rs.eof then
' ... process rs
end if

Also, just because you "don't always use" GetRows doesn't mean it is an
invalid solution for the problem you are currently having. You probably
"don't always use" a recordcount at all, either.

You seemed to discard it without a thought. Maybe you gave as much thought
to the database platform you chose.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"Roy Danon" <admin@droyd.net> wrote in message
news:bts32c$eum$1@news2.netvision.net.il...

> Hi,
> I'm using the driver my hosting service adviced me to use :
>
> "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306; Option=0;
> Socket=; Stmt=; Database=xxx_xxx; UID=xxx_xxx; PWD=xxx;"
>
> where can i find it's documention?
>
> Roy.

[Roy Danon]

Hi,
My problem is actually that my website contains over 100 pages which
connects to the database and displays records using "for i = 1 to
rs.recordcount" or GetRows.
And I really don't have time to change my entire website and use getrows
instead of looping, because only about 10% of the webpages were converted to
GetRows after i had some resources issues.

So, first of all thank you.
I've returned to use MSSQL instead, and it meanwhile the site is online i
will change the pages to other methods and stop using recordcount and when
the site will be ready I will try and change my DB to mySQL again.


Thanks for everything,
Roy.
"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:uT4pL1H2DHA.1908@TK2MSFTNGP10.phx.gbl...

> Did you try [url]www.mysql.com?[/url]
>
> Also, there are methods in the article posted that you may have missed or
> ignored, such as:
>
> set rs = conn.execute("SELECT COUNT(*) FROM table WHERE ...")
> response.write rs(0) & " rows."
> set rs = conn.execute("SELECT * FROM table WHERE ...")
> if not rs.eof then
> ' ... process rs
> end if
>
> Also, just because you "don't always use" GetRows doesn't mean it is an
> invalid solution for the problem you are currently having. You probably
> "don't always use" a recordcount at all, either.
>
> You seemed to discard it without a thought. Maybe you gave as much

thought

> to the database platform you chose.
>
> --
> Aaron Bertrand
> SQL Server MVP
> [url]http://www.aspfaq.com/[/url]
>
>
>
>
> "Roy Danon" <admin@droyd.net> wrote in message
> news:bts32c$eum$1@news2.netvision.net.il...

> > Hi,
> > I'm using the driver my hosting service adviced me to use :
> >
> > "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306; Option=0;
> > Socket=; Stmt=; Database=xxx_xxx; UID=xxx_xxx; PWD=xxx;"
> >
> > where can i find it's documention?
> >
> > Roy.

>
>

[Roy Danon]

No, there are about 20 records, and i havn't given any creteria(where ...)

Thanks,
Roy.
"Manohar Kamath [MVP]" <mkamath@TAKETHISOUTkamath.com> wrote in message
news:O9N69dH2DHA.3140@tk2msftngp13.phx.gbl...

> Roy,
>
> Have you tried looping through the recordset to see if there are any
> records, maybe zero is the right answer.
>
> --
> Manohar Kamath
> Editor, .netBooks
> [url]www.dotnetbooks.com[/url]
>
>
> "Roy Danon" <admin@droyd.net> wrote in message
> news:btre0k$735$1@news2.netvision.net.il...

> > Here you go :)
> >
> > set rsNewsQuick=server.CreateObject("ADODB.recordset")
> > sqlNews="SELECT * FROM QuickNews order by id desc"
> > rsNewsQuick.Open sqlNews,dsn,1,1
> >
> >
> > Thanks,
> > Roy.
> >
> > "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> > news:Oh80bR%231DHA.4064@tk2msftngp13.phx.gbl...

> > > > the first solution is the same as what i'm doin
> > >
> > > How do we know that? SHOW YOUR CODE.
> > >
> > > --
> > > Aaron Bertrand
> > > SQL Server MVP
> > > [url]http://www.aspfaq.com/[/url]
> > >
> > >

> >
> >

>
>

[Aaron Bertrand - MVP]

> I've returned to use MSSQL instead, and it meanwhile the site is online i

> will change the pages to other methods and stop using recordcount and when
> the site will be ready I will try and change my DB to mySQL again.

Usually, MySQL is used when the cost of SQL Server or other RDBMS platforms
is too prohibitive. If SQL Server is available, and it works, why do you
feel the need to switch to MySQL?

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]