uum try this ?
<cfset loopdate = STARTDATE>
<cfloop condition=" loopdate LTE ENDATE>
<!--- do insert --->
<cfset loopdate = dateadd("d",1,loopdate>
</cfloop>
----- Original Message -----
From: "Stephen Moretti" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 01, 2004 4:09 PM
Subject: [ cf-dev ] Quick way to insert a record per day.
> I've got a start date and an end date and I want to insert a record into
> the database for each date between and including the start and end dates.
>
> Any thoughts on a quick and easy way to do this?
>
> Stephen the fuzzy brained.
>
> --
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
>
--
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]
