Wednesday, October 22, 2008

How To Make It Not Awkward With A Guy

Count in MySQL and ASP results

Normally when we started to program in ASP started with Access tables, which are very useful to some extent, when you've already migrated to MySQL (Highly Recommended) some things change, as the displaying of the results of a query.


In Access use something like this:

SQL = "Select * From Table"
rs.Open SQL, oConn, 1.1
 few = RS.RecordCount 

MySQL
But things change, if we use this technique the result is a horrible -1, to correct this is to use: Simply add


this:

rs.CursorLocation = 3
 Rs.Open 
Before

and Walaa, I hope you serve.



0 comments:

Post a Comment