I'd be interested in seeing the JSP code, particularly the part
about streaming the output.
Thanks,
Dave Jones
NetEffect
At 12:39 PM 1/9/04 -0500, you wrote:
>Well I'm not sure about taking up less size at all. Now given you will have
>to create an initial database but minus that it's just data. Regardless if
>you go this route the space differences would be minimal.
>
>
>If you want I can post the JSP code we use for retrieval?
>
>
>
>Stephen E. Schuster
>PeopleSoft Administrator
>2000 Ashland Drive
>Ashland, KY 41101
>
>Office Phone 606.920.7447
>Cell Phone 606.831.4590
>
> _____
>
>From: Charlie Griefer [mailto:[EMAIL PROTECTED]
>Sent: Friday, January 09, 2004 11:04 AM
>To: CF-Talk
>Subject: Re: Images - store in DB or filesystem?
>
>
>Hi Steven:
>
>I'll have to defer to your experience here, as my answer was based only on a
>response I got from an instructor when asking him this same question...so
>I've always done it the text datatype/file path method.
>
>Maybe 'bloat' was too strong of a word? Maybe he just meant that storing
>the images as files would take up -less- space than storing them as BLOBs?
>
>Charlie
>
> ----- Original Message -----
> From: Schuster, Steven
> To: CF-Talk
> Sent: Friday, January 09, 2004 8:47 AM
> Subject: RE: Images - store in DB or filesystem?
>
> I can assure you that storing images in BLOB does not bloat a database.
>They
> are designed for this very thing. Though I will admit that Oracle is far
> better than SQL Server at doing it. I have never really dealt with mySQL
>and
> it's been years since I used Informix so I can't tell you much on those
> products.
>
> We do this for our fax apps. We store all types of data in Oracle BLOBS
>and
> it is actually faster than file writes. We use a JSP page to do the pulls
> and puts. In fact we even integrated it into our PeopleSoft product so
>that
> our remote locations can now just fax in new hire documents, the faxes go
> directly to the database and are available for viewing through the Job
>panel
> in PS.
>
> Stephen E. Schuster
> PeopleSoft Administrator
> 2000 Ashland Drive
> Ashland, KY 41101
>
> Office Phone 606.920.7447
> Cell Phone 606.831.4590
>
> _____
>
> From: Charlie Griefer [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 09, 2004 10:42 AM
> To: CF-Talk
> Subject: Re: Images - store in DB or filesystem?
>
> 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]
