But i dont want to do a previous query, i want a more efficient solution. Only an update..etc and know rows affected.
On Thu, 18 Nov 2004 11:02:19 -0200, Marcos Placon� <[EMAIL PROTECTED]> wrote: > 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] > -- 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]
