Don't store them directly in the DB, instead use cfdirectory to get them all
and put their names in a table.
<cfdirectory action="list" directory="#pathToImages#" name="qDir">
<cfloop query="qDir">
<cfquery>
INSERT INTO .....
</cfquery>
</loop>
About as quick and easy as it gets I think...
Ade
-----Original Message-----
From: Jenny [mailto:[EMAIL PROTECTED]
Sent: 21 August 2004 16:57
To: [EMAIL PROTECTED]
Subject: Re: [ cf-dev ] CFFILE ....
Ok, this is getting messy storing pics as files .. is there an easy way to
store them in an ms sql 7 database please?
Thanks, Jenny
----- Original Message -----
From: "Jenny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 21, 2004 4:33 PM
Subject: Re: [ cf-dev ] CFFILE ....
> Thanks Terry, I'd missed the fileexists function.
>
> Jenny
>
> ----- Original Message -----
> From: "Terry Riley" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturday, August 21, 2004 12:24 PM
> Subject: Re: [ cf-dev ] CFFILE ....
>
>
> > Sure.
> >
> > Something like this:
> >
> > <cfif FileExists(#variables.x_file_name#)>
> > <cffile action="DELETE" file="#variables.x_file_name#">
> > </cfif>
> >
> > Of course, you'll have to substitute your own file name for the
variable.
> >
> > Cheers
> > Terry
> >
> > ----- Original Message -----
> >
> > > Hi all,
> > >
> > > Is there a way to check for the existence of a file before doing a
> > > cffile
> > > delete, please?
> > >
> > > Thanks, Jen
> > >
> > >
> > > (have to get in plug for new web site ..
http://www.chicksNchaps.co.uk)
> > >
> > >
> >
> >
> >
> > --
> > These lists are syncronised with the CFDeveloper forum at
> http://forum.cfdeveloper.co.uk/
> > Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
> >
> > CFDeveloper Sponsors and contributors:-
> > *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF
provided
> by activepdf.com*
> > *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
> proworkflow.com*
> > *Tutorials provided by helmguru.com* :: *Lists hosted by
> gradwell.com*
> >
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004
>
>
>
> --
> These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
> Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
>
> CFDeveloper Sponsors and contributors:-
> *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
> *Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
> *Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
>
>
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided
by activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by
proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by
gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
--
These lists are syncronised with the CFDeveloper forum at
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by
activepdf.com*
*Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
*Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*
To unsubscribe, e-mail: [EMAIL PROTECTED]
