> I guess what he (and I) would like to know is that if there
> is a way to know that the SQL actually updated the record, not
> if it ran, I know (by passed experience) that SQL has some
> returns code (100=no record found, etc) which are store in
> a returned variable... in other languages after an SQL statement
> is ran you actually have access to those variables returned as
> an structure of SQL (.ErrorCode, .ErrText,among others) if you
> look at .ErrorCode and is empty you can know that everyhting was
> right otherwise .ErrText will have a description of the error...
> is there such a thing in CF?
Specific databases may provide return codes, but in my experience those
return codes only tell you general information; the query ran successfully,
or it didn't run successfully. If a query is unsuccessful in CF, you'll find
out right away.
I spent a few minutes looking at SQL Server Books Online, and couldn't find
anything which SQL Server would automatically return how many records were
updated by a query. You can use the RETURN keyword within a stored procedure
to return a value, or you could use RAISERROR to throw an error, but I
didn't find what you're looking for, and I don't think it exists, at least
not in SQL Server.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
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.
