I've always heard path in text fields. From what I understand, storing as BLOBs will bloat the db, and it's rather slow.
----- Original Message -----
From: Spectrum WebDesign
To: CF-Talk
Sent: Friday, January 09, 2004 8:15 AM
Subject: Images - store in DB or filesystem?
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]
- Images - store in DB or filesystem? Spectrum WebDesign
- Re: Images - store in DB or filesystem? Charlie Griefer
- Re: Images - store in DB or filesystem? Jochem van Dieten
- RE: Images - store in DB or filesystem? MILAN MUSHRAN
- RE: Images - store in DB or filesystem? Schuster, Steven
- Re: Images - store in DB or filesystem? Matt Liotta
- Re: Images - store in DB or filesystem? Charlie Griefer
- Re: Images - store in DB or filesystem? Spectrum WebDesign
- Re: Images - store in DB or filesystem? Jochem van Dieten
- RE: Images - store in DB or filesystem? Dave Watts
- Re: Images - store in DB or filesystem? Paul Hastings
- Re: Images - store in DB or filesystem? Spectrum WebDesign