I'm trying to check the DB for a valid record. How I'm handling it now is by spinning through the table and doing record id AND comparisons then setting a record exists flag to true.
I think I have seen better code for this in the past. Can I just attempt to access the record directly and if the action succeeds set the flag to true? My problem is I don't know what to replace EXISTS with. Johnny ========= Dim strSQL Dim strRecordExists strRecordExists = 0 strSQL = "SELECT * FROM tbl_deliverables WHERE record_id = 5 AND deliverable_id = 2" If (EXISTS(objRecordCheck.Open strSQL, objConn)) Then strRecordExists = 1 End If ============ --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
