Thanks, I'll torch up the monkeys :-)
At 08:49 PM 10/15/00 -0700, pan wrote:
>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 no rows - RecordCount is meaningless and
>will throw an error. Works every time. :)
>
>In your case - no rows were updated so RecordCount has nothing
>to count and nothing != zero.
>
>There was a discussion here recently about how to count updated
>rows ... if your rdbms has a fucntion like @@rows (MSSQL) you're
>in business easily - if not you have to make monkeys jump through
>flaming hoops to get an answer.
>
>Pan
>
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
---------------------------------------------------------------------------
Peter Theobald, Chief Technology Officer
LiquidStreaming http://www.liquidstreaming.com
[EMAIL PROTECTED]
Phone 1.212.545.1232 x204 Fax 1.212.545.0938
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
