Unspecified Error

Results 1 to 3 of 3

Thread: Unspecified Error

  1. #1
    Chris Surfleet Guest

    Default Unspecified Error

    I am using a select query, opening using 3, 3 on the MS access driver. The query works fine except when finding no records. I check for this using &#039If objRS.EOF Then&#039 but on that line i am given &#039unspecified error&#039 I need to fix this urgently - help!!!

  2. #2
    Join Date
    Dec 1969

    Default RE: Unspecified Error

    not really enough info to help - anything further?<BR><BR>j

  3. #3
    Chris Surfleet Guest

    Default RE: Unspecified Error

    Thats about as much as I can tell you...<BR>Basicly I just use a SQL statement to bring back records (this works fine usually) I use the following code...<BR>objRS.Open strsql, objConn, 3, 3<BR>If objRS.EOF Then<BR> response.write "Sorry, not messages were found"<BR>Else<BR> While not objRS.EOF<BR> &#039display records<BR> Wend<BR>End If<BR><BR>This code has worked fine loads of times, it just seems that the server don&#039t like me...

Posting Permissions

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