That did it thanks. For others, I ended up with ...
samp_reques_id IS TABLE KEY
<CFQUERY name="loop_date_sr" datasource="#source1#">
SELECT samp_reques_id,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))#
WHERE samp_reques_id = #samp_reques_id#
</cfquery>
</CFoutput>
> 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>
>
>
>
______________________________________________________________________
Get Your Own 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=coldfusionb
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
