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>
______________________________________________________________________
Dedicated Windows 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=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
