13Nov/072
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/
Subscribe
Categories
Hosting Services
Recent Posts
- Google Store View Coming Soon
- 10 Tips to Building and Structuring Inbound Links
- Google Rich Snippets to Include Events
- Google Olympic Page with Snow View
- Google Shortcut Search Commands
Recent Comments
- admin on Parked Domains, Sub Domains, Add-on Domains… What are they?
- Elaine on Parked Domains, Sub Domains, Add-on Domains… What are they?
- Dorothy Turcotte on 10 Tips to Building and Structuring Inbound Links
- Ryan on 10 Tips to Building and Structuring Inbound Links
- Randy on Installing Ruby on Rails in Cpanel
Archives
- March 2010
- February 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- July 2009
- April 2009
- November 2008
- October 2008
- September 2008
- July 2008
- June 2008
- February 2008
- January 2008
- November 2007
- August 2007
- July 2007
- June 2007
Meta
Tags
advanced format technology
adwords
baseball ugm
bing
boxbe
comodo
dns
fetch
folder rename
geotarget
godmode
google
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
seagate
search based keyword tool
sidewiki
sktool
social search
spam
spyware
tweet
twitter
virus
webmaster tools
western digital
windows 7
yahoo
youtube
August 26th, 2008
“Hope this helps!”
It actually did
thank you!
January 27th, 2010
Muchas gracias !