Gilbert,
1) Use the CreateODBCDate function
i.e CreateODBCDate(createdate(form.year,form.month,form.day)) This will fix the date formating problem
2) Think about using a seperate lookup table associating classes with times. This way you can CFLoop around the infoirmation and pull the dates into
Gil,
When you output getClassDate before going into the loop, what is the value of the variable? Is it 4? Is it 1?
P.S. The CFTRANSACTION and CFTRY/CFCATCH block are to ensure the right data is going into the mutliple INSERT block
Also, take a look at the evaluation function and the CreateOBDCDa
'2003,2003,2003,2003/10,10,10,10/1,8,15,22',
>>'12:00-2:00' )
>
>I'll look into the transaction tag but I thought it had more to do with
>multiple insertions by multiple people and ensuring that one transaction was
>finished before starting another.
>
&g
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 li
4 matches
Mail list logo