ado recordset.recordcount has value 0

From: pherms (pherms_at_planet.nl)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 02:56:05 -0800

I have this really weird problem.
When I query a database with a string, which I know will return only one record, by using an asp page, the recordcount object of the adodb.recordset has value 0. I do know that the sql query I use is ok, because I tested it in my database app.

I use Windows 2003 server as the asp platform and I use mysql 4.0.18 ad the database.

Please can anyone help me? It's dirving me crazy!

Relevant Pages

  • Re: Complex query criteria - desperate appeal
    ... I made an ASP website using an Access DB ... criteria listboxes have the ALL choice, and the value passed to the query is ... I then build a string of the selected ID's and use ...
    (microsoft.public.access.queries)
  • ADO exception with character combination inside string...
    ... We also have various Delphi7 programs that operate on this database. ... These programs are set up to trap the exception in an ADO operation ... and log the query text that was in use when the exception happened. ... What happens is that if we have a string to store inside the database ...
    (borland.public.delphi.database.ado)
  • Row Level Locking from Excel VBA query
    ... There are multiple users accessing the database at ... query that I am using so that two users will not get the same order ... Dim dbsConn As ADODB.Connection ... Dim connString As String ...
    (microsoft.public.access.queries)
  • search query help
    ... I had an ASP intranet app up for a while, in use by many at my company. ... query which will search two targeted varchar fields and: ... So if a user wanted to search on "database error 30008", ... SQL Server database, because that's where the data is kept. ...
    (microsoft.public.sqlserver.programming)
  • DataBase results Error continued
    ... What I dont understand is that my query and output uses ... <% ' FP_ASP -- ASP Automatically generated by a Frontpage ... black;'>The Database Results component on this page is ... What it boils down to is that FP uses only one SQL ...
    (microsoft.public.frontpage.client)