[ic] SQL update problems

[Scott Andreas]

Hey thanks everyone all is working.
except for diplaying the row count

my code...

[seti dropdate][tag op=time]%Y%m%d[/tag][/seti]
[tag flag write]catalogs[/tag]
[query  list=1
	row_count=1
	table=catalogs
	st=sql
	sql="UPDATE catalogs
	SET mv_shipmode = '0', catdropdate = '[scratch dropdate]'
	WHERE country = 'US' AND show_qty = '1' AND mv_shipmode = '1' AND completed
!= '1'
"]
[/query]
[row_count] Contacts updated!
_________________________
The docs are no help here!

your help is greatly appreciated

Scott

-----Original Message-----
From: interchange-users-admin@interchange.redhat.com
[mailto:interchange-users-admin@interchange.redhat.com]On Behalf Of
Kevin Walsh
Sent: Tuesday, February 05, 2002 4:13 PM
To: interchange-users@interchange.redhat.com
Subject: RE: [ic] SQL update problems


>
> Also how can I display the rows effected by the UPDATE
>
Oops - didn't spot that part of your question.

Use [query row-count=1 ...] and the query tag will return the
number of rows affected by whatever query you make.

--
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin@cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/
_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users