SELECT statement ...error

Results 1 to 3 of 3

Thread: SELECT statement ...error

  1. #1
    Join Date
    Dec 1969

    Default SELECT statement ...error

    I have a SQL statement in my Asp code which is a simple SELECT statement that chooses a no. of fields of a table from the database. On trying to display these values using recordsets, I get an error;<BR><BR>error &#039;80004005&#039; <BR>Unspecified error <BR><BR>However if I simply replace the SELECT statment alone, to select fields from another table, it works.<BR><BR>I assume this could mean that my remaining code is fine. Can anyone please suggest what could be the reason and how I could get that to work?<BR><BR>Thanks!!!

  2. #2
    Join Date
    Dec 1969

    Default RE: SELECT statement ...error

    could u show us the code please

  3. #3
    GeorgeE Guest

    Default RE: SELECT statement ...error

    One thing I like to do when getting this general error, which can mean allot of things, is to add a couple lines of code just after the SQL statement that you just built. Put<BR><BR>Response.write YourSQLStatement &#039;then <BR>Response.end<BR><BR>in the code this way you can see what SQL is kicking back, no other code will process so you can see what is up.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts