Newbie: SQL/recordset query

Results 1 to 2 of 2

Thread: Newbie: SQL/recordset query

  1. #1
    Join Date
    Dec 1969

    Default Newbie: SQL/recordset query

    I need to check that a recordset doesnt exist in a record set and then add the record.<BR><BR>At the moment I get the recordset and use a while not rs.eof statement to scan all the records before inserting the new record.<BR><BR>Is there a more efficient way to do this??<BR><BR>Thank for your help<BR><BR>Ian Buckland<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default ASPFAQs, category Databases, Queries

    The link to the ASPFAQs is at the top right corner of most every page on this site, including this one.<BR><BR>For what it&#039;s worth, I don&#039;t think there a more INefficient way to do it than what you are currently doing. In the FAQ, we quibble over what are probably microseconds. Even the way that Steve "puts down" in the first paragraph would be tons faster.<BR><BR>If you&#039;re a newbie, I&#039;d use that method [from the first paragraph of the FAQ] for now. It works. It&#039;s good enough for all but the very busiest sites.<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