[thelist] asp & access - valid query to db table returning norows???

[Joshua Olson]

> -----Original Message-----
> From: Paul Bennett
> Sent: Thursday, May 08, 2008 6:36 AM
> 
> Hi all,
> 
> I'm normally a PHP / MySQL person, but need to use ASP / 
> Access for a small project.
> 
> I'm connecting to an access database and running a simple 
> select * query but can't get any results returned.
> 
> The only thing I can think of is that the file isn't writable...?

Paul,

If you haven't done so already, update the MDAC.  

http://www.google.com/search?q=mdac

Secondly, try the simpler syntax for executing the query:

Set rs = dbCon.execute(q)

Actually, now that I am looking at your code again, when you are creating
the RecordSet, you are not using the "Set" operator.  Change:

rs = Server.CreateObject("ADODB.Recordset")

To:

Set rs = Server.CreateObject("ADODB.Recordset")

HTH,

Joshua

<><><><><><><><><><>
Joshua L. Olson
WAE Technologies, Inc.
Augusta, Georgia Web Design
http://www.waetech.com/
Phone: 706.210.0168
Fax: 707.988.0168
Private Enterprise Number: 28752

Portfolio:
http://www.waetech.com/design/portfolio/

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/