Results 1 to 2 of 2

Thread: recordset

  1. #1
    Join Date
    Dec 1969

    Default recordset

    I am passing a variable through the url to determine what functions of the page should run. The page has several functions that are very close to another, displaying user info. However, when the edit action is passed, it queries the database for the users information. When the new action is passed, it just display the page with no information posted. I have a problem, with an if statement. The if statement contains a reference to the recordset when querying the database during the edit mode. However, this gives me a problem when in the new user mode because the recordset doesn&#039t exist. This there a way to get around this problem short of writing if statements for each input box?

  2. #2
    Join Date
    Dec 1969

    Default RE: recordset

    To check to see that there are actually one or more records in a recordset perhaps do the following:<BR><BR>&#039 If not empty rst.<BR>If Not rst.EOF Then<BR><BR>Best regards,<BR>-Paul<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