You will need a WHERE clause in the update query.
>>> <[EMAIL PROTECTED]> 01/04/02 04:07PM >>>
Hi,
I'm trying to interate through all the records in a
table and add two weeks to a new date column based on
and existing date value(srf_date_created). When I run
the code below, I get the same date instead of an entry
based on (srf_date_created + 2 weeks) And yes the date
valuefor srf_date_created is different for each record.
srf_date_created is an exist date value
srf_date_fu is a newly added date column
<CFQUERY name="loop_date_sr" datasource="#source1#">
SELECT srf_date_created
FROM samprequest
</cfquery>
<CFoutput query="loop_date_sr">
<CFQUERY NAME="update_sampler" datasource="#source1#">
UPDATE samprequest
SET srf_date_fu = #DateAdd('ww', 2, (srf_date_created))#
</cfquery>
</CFoutput>
______________________________________________________________________
Why Share?
Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
