[ic] Database transaction?

T. Stoffels tstoffels at gmail.com
Tue May 31 11:28:19 EDT 2005


I just was pointed towards a different, imho more simple  approach:
I just do the begin..query..query..commit/rollback stuff myself =)
--
[tmp mysqlresult_begin][query sql=|begin work|][/query][/tmp]
			
[tmp mysqlresult_del1][query sql=|delete ...|][/query][/tmp]
			
[tmp mysqlresult_del2][query sql=|delete ...|][/query][/tmp]

		
			[if type=explicit compare=" 
				$Scratch->{mysqlresult_begin} == 1 && 
				$Scratch->{mysqlresult_del1} == 1 && 
				$Scratch->{mysqlresult_del2} == 1  
			"]
				[query sql=|commit|][/query]
				everything deleted

			      [else]do rollbackhere [/else]
			[/if]
--

But I just noticed that the query.../query tag does *not* return 1 if
the query was successfull or 0 if the database returned an error, as I
though before.

It seems to be the number of rows affected.

So I'd need to know how I can tell whether an sql statement caused an
error or was processed succesfully - even if it didnt affect any rows
(like 'begin' for example).

Once more thx in advance...



More information about the interchange-users mailing list