Hi All,
Here is question:

<cfquery name = "MyQuery" datasource =
"OurDataSource">
        UPDATE EMPLOYEES
        SET SALARY = 70000
        WHERE EMP_NAME = 'MEE'
</cfquery>

Assuming the EMP_NAME was 'ME' instead of 'MEE', the
update will not take place. The Database return code
woud be 'zero rows updated'.

Is there a way to know whether the update was
successful? Like in the above SQL can we come to know
that the update did not actually take place.

Thanks and regards,
Planet CF
Differential Technologies
Fairfa, VA

__________________________________________________
Do You Yahoo!?
Get Yahoo! Mail � Free email you can access from anywhere!
http://mail.yahoo.com/
------------------------------------------------------------------------------
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.

Reply via email to