RE: Weird... cfquery update 0 rows - query disappears

I have a SQL update. When it tries to update data a row that doesn't exist I don't get an error, I don't get 0 rows, I get the query variable itself doesn't exist!? A query can exist and contain no rows. RecordCount counts existing rows. If query has no rows - RecordCount is

Weird... cfquery update 0 rows - query disappears

I have a SQL update. When it tries to update data a row that doesn't exist I don't get an error, I don't get 0 rows, I get the query variable itself doesn't exist!? See sample code: !-- Testing SELECT on

Re: Weird... cfquery update 0 rows - query disappears

From: "Peter Theobald" [EMAIL PROTECTED] I have a SQL update. When it tries to update data a row that doesn't exist I don't get an error, I don't get 0 rows, I get the query variable itself doesn't exist!? A query can exist and contain no rows. RecordCount counts existing rows. If query has