>From: "Spectrum WebDesign" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Images - store in DB or filesystem?
>Date: Fri, 09 Jan 2004 12:15:21 -0300
>
>What's the in/out for image storage? Bynary in BLOB database fields or file
>system or path in text fields?
>
>
>
>
>----- Original Message -----
>From: "Pascal Peters" <[EMAIL PROTECTED]>
>Date: Fri, 9 Jan 2004 15:40:16 +0100
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: insert multiple drop down list selects into access
>
>Looks like you want a one-to many relationship. Create a second table for
>that (with a FK to the existing table). Then loop over the list and insert
>in the second table within the loop (using the PK from the record in the
>first table as FK in the second table)
>
> -----Oorspronkelijk bericht-----
> Van: Tim Laureska [mailto:[EMAIL PROTECTED]
> Verzonden: vr 9/01/2004 15:15
> Aan: CF-Talk
> CC:
> Onderwerp: 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]
