You'd have to change the field type to some sort of string, or loop over
the form input and insert each one individually (depending on your
database design).
John Burns
-----Original Message-----
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Friday, January 09, 2004 9:15 AM
To: CF-Talk
Subject: insert multiple drop down list selects into access
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]