-----Original Message-----
From: Jeremy Brodie [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 14, 2003 2:02 PM
To: CF-Talk
Subject: Re:multiple inserts, no solution, thx but one more question
Gil,
See Ian's advice on using a list loop. They are very handy for this
situation, when you're using a comma delimited list! To set up your CFSET
you'll sill need to use the evaluate function to create your date. This is
the reason
If you don't want to use a list loop as Ian suggested use the listlen
function to determine the length of your comma delimited list in the from
field.
<cfloop from="1" to="#listlen(form.year)#" index="myIndex">
<cfset
variables.date=#DateFormat(CreateODBCDate(createdate(evalaute("form.year#myI
ndex#")#,#evalaute("form.month#myIndex#")#,#evaluate("form.day#myIndex#")#
>)),"mm/dd/yyyy")#>
<cftransaction>
<cftry>
INSERT Query
<cfcatch>
</cfcatch
</cftry>
</cftransaction>
</cfloop>
Jeremy Brodie
Gil Wrote:
>
>right now I have:
>
><cfset
>date1=#DateFormat(CreateODBCDate(createdate(form.year1,form.month1,form.day
1
>)),"mm/dd/yyyy")#>
><cfset
>date2=#DateFormat(CreateODBCDate(createdate(form.year2,form.month2,form.day
2
>)),"mm/dd/yyyy")#>
><cfset
>date3=#DateFormat(CreateODBCDate(createdate(form.year3,form.month3,form.day
3
>)),"mm/dd/yyyy")#>
><cfset
>date4=#DateFormat(CreateODBCDate(createdate(form.year4,form.month4,form.day
4
>)),"mm/dd/yyyy")#>
>
><cfset dateList="#date1#,#date2#,#date3#,#date4#">
>
>It works, but is very inelegant.
>
>How would one loop through the above?
>
>you can't do a
>
><cfloop from="1" to="4" index="myIndex">
>
><cfset date#myIndex#= ...form.year#myIndex#,form.month#myIndex# ...>
>
></cfloop>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
