Pull an ID or whatever record identifier you have in your first query. Not just the date. Then in the update statement you need a where ID = #ID# or whatever your record identifier is called. It has no idea what row you want to update the way you wrote it. Kelly
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, January 04, 2002 4:07 PM To: CF-Talk Subject: <CF_CFLOOP_2nd_pair_of_eyes> 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
