like:
<cfloop list="#FORM.cat_no#">
<cfquery to insert>
</cfloop>
Pete
Tim Laureska wrote:
> Is it possible to insert into one access database number field, a comma
> delimited list of numbers, received from a form template thusly (is not
> working now ... only can one number to show in the database when
> multiples are selected on the form drop down):
>
> FORM CODE:
> <select name="cat_no" multiple>
> <cfoutput query="client_cat"><option
> value="#cat_no#">#work_cat#</cfoutput>
> </select>
>
> TEMPLATE WHERE DATABASE INSERT IS HAPPENING:
>
> <cfquery datasource="todo" dbtype="odbc">
> INSERT into clients (category)
> VALUES (#cat_no#)
> </cfquery>
>
> TIA
> Tim
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
