At 00:58 16/10/2003 -0400, you wrote:
>I would like the user to be able to update at whim and to loop through these
>records and update them.

Sorry, I can't quite grasp what you're trying to do, or what the form
does... Is this an admin system for course organisers to change the dates
of courses?

>When I get to the update section I should be able to put the IDs in a list
>and then from that list get a LISTLEN
>
>and do a
>
><cfloop list="#dateList#" index="dateSessions">
>
>       <cfquery name="getSessionDays" datasource="">
>
>        UPDATE classDates
>        SET
>         classDay='#FORM.classDay#',
>         classSession='#FORM.classSession#',
>         classDates='#dateSessions#',
>         classStart='#FORM.classStart#',
>         classEnd='#FORM.classEnd#'
>
>        WHERE ID IN(#dateList#)
>
>    </cfloop>

What error do you get?

Gyrus
[EMAIL PROTECTED]
http://norlonto.net/gyrus/dev/
PGP key available

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to