Try to make first a query that uses the same conditions witha select, and then it will return a reordcount to you. But this "alternative" will only be functional in case of Delete and Update. In case of Insert, you can make a trigger that will select all the data moved to the temporary table "inserted"(SQL Server case), and move it to another temporary table, where you can make a select and bring the recordcount.
If you have doubts contact me and I can help you more. Regards Marcos Placon� Desenvolvedor - NAVITA Fone: 55 11 3055-2001 Celular: 55 11 9560-3260 http://www.navita.com.br ------------- Segue mensagem original! ------------- De: Xavi <[EMAIL PROTECTED]> Data: Thu, 18 Nov 2004 13:05:42 +0100 Para: [EMAIL PROTECTED] Assunto: [CFCDev] [off-topic] Number of registers deleted, inserted, updated Sorry, this is alittle off topic but related to databases and CFCS. When you deals with database and do inserts,updates and deletes sometimes is itneresting to know the number of regiters affected. So how to know the number of ie registers updated after an UPDATE, some function? maybe a java class which acces to query metada? I dont know. CF should return rows afected after insert, update and delete like select. Anyone can help�? -- Xavi (http://xavicl.blogspot.com) ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at [EMAIL PROTECTED]
