Canadian Web Hosting Blog and News canadian web hosting vps windows hosting canada servers dedicated colocation hosts

13Nov/073

ASP Recordcount with MySQL database

I was trying to use the Recordcount in asp with MySQL and always came up with -1.  It took me sometime finding a solution. Apparently MySQL does not support Server Side Cursors. Here is a quick fix:

To make this work you will need to set the CursorLocation to 3:

Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CursorLocation = 3
objRS.Open mySQL, objConn

Hope this helps!

 

Kevin Liang
CTO / SEO Guru
Canadian Web Hosting
http://www.canadianwebhosting.com/

Related Posts:

  • No Related Posts
Filed under: Programming Leave a comment
PDF Version
Comments (3) Trackbacks (0)
  1. yossi
    August 26th, 2008

    “Hope this helps!”

    It actually did :)
    thank you!

  2. Roush
    January 27th, 2010

    Muchas gracias !

  3. Canariooo
    May 13th, 2010

    Thank you VERY MUCH!!!!!!!


Leave a comment


No trackbacks yet.

« Affiliate Program at Canadianwebhosting.com Updated. Grand Central from Google-Got my number! »

Subscribe


 Subscribe

Categories

Hosting Services

Recent Posts

Recent Comments

Archives

Meta

Tags

advanced format technology adwords baseball ugm bing boxbe comodo dns fetch folder rename geotarget godmode google google adwords googlebot google chrome google goggles google maps google store view google street maps vancouver canada gps hard drives link building local search lunch food cheap eats malware microsoft opendns page speed seagate search based keyword tool sidewiki site speed sktool social search spam spyware tweet twitter virus webmaster tools western digital windows 7 wordpress yahoo youtube