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]

Reply via email to