[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] SQL update problems
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