cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Feldman, Leonid" <leonid.feld...@comverse-in.com>
Subject need help with sql update
Date Mon, 10 Apr 2000 13:48:33 GMT


	My email has been down for a day so I am giving it one last try.

	I cannot get sql update to work with the SQLProcessor.

	<query connection="con">
	  update subscriber
	  set pin = <xsp:expr>newpin</xsp:expr>
	  where id= <xsp:expr>name</xsp:expr> and
pin=<xsp:expr>oldpin</xsp:expr>
	</query>		

	I get the following result:

	[TDS Driver]No result sets were produced by 
				' update subscriber
				  set pin = yyyyyy
				  where id= xxxxx and pin=zzzzz '


	Can somebody send me an example of using of the SQL update
	query with the SQLProcessor or the SQL tag library.

	Thanks,
	Leonid

Mime
View raw message