This is a multi-part message in MIME format.
------=_NextPart_000_0031_01BE8FEC.F54EF980
Content-Type: text/plain;
charset="windows-1257"
Content-Transfer-Encoding: quoted-printable
I would like some help I am wanting to rename the files being uploaded =
as part of a from so that the file name stored in the directory =
propertyphotos will be the phone number of the property (which is passed =
via the form at the time the file being uploaded is passed)
I am having difficulty understanding what modifications are needed to =
the code below to achieve this
the objective being that each property who uploads a picture will have =
that picture stored under the directory propertyphotos and the file name =
will be the phone number of the property in question thus allowing me to =
identify who photo applies to which property and using the rename =
facility to each properties phone number eliminates the issue of file =
names being accidentally overwritten as no to properties will have the =
same phone number
I look forward to your replies
<cfif Len(form.photofile)>
<CFFILE=20
DESTINATION=3D"d:\www\austaccomm\propertyphotos\
ACTION=3D"UPLOAD"=20
NAMECONFLICT=3D"overwrite"=20
FILEFIELD=3D"PhotoFile"=20
ACCEPT=3D"image/gif, image/jpg, image/pjpeg">
<CFQUERY NAME=3D"UPDATE_PROP" DATASOURCE=3D"australianaccomm">
UPDATE properties=20
SET Photo =3D '#FILE.ServerFile#'
WHERE username=3D'#FORM.username#'
</CFQUERY>
</cfif>
=20
Kind Regards
Claude Raiola
E-Mail: [EMAIL PROTECTED]
Website: www.internetgoldcoastproperties.com.au
------=_NextPart_000_0031_01BE8FEC.F54EF980
Content-Type: text/html;
charset="windows-1257"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1257" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3013.2600" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT color=3D#0000ff size=3D2>I would like some help I am wanting =
to rename=20
the files being uploaded as part of a from so that the file name stored =
in the=20
directory propertyphotos will be the phone number of the property (which =
is=20
passed via the form at the time the file being uploaded is =
passed)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff size=3D2>I am having difficulty understanding =
what=20
modifications are needed to the code below to achieve this</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff size=3D2>the objective being that each =
property who=20
uploads a picture will have that picture stored under the directory=20
propertyphotos and the file name will be the phone number of the =
property in=20
question thus allowing me to identify who photo applies to which =
property and=20
using the rename facility to each properties phone number eliminates the =
issue=20
of file names being accidentally overwritten as no to properties will =
have the=20
same phone number</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff size=3D2>I look forward to your =
replies</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff size=3D2>
<DIV><FONT color=3D#0000ff size=3D2><cfif =
Len(form.photofile)><BR><CFFILE=20
<BR>DESTINATION=3D"d:\www\austaccomm\propertyphotos\</FONT></DIV>
<DIV><FONT color=3D#0000ff size=3D2>ACTION=3D"UPLOAD" =
<BR>NAMECONFLICT=3D"overwrite"=20
<BR>FILEFIELD=3D"PhotoFile" <BR>ACCEPT=3D"image/gif, image/jpg,=20
image/pjpeg"></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff size=3D2><CFQUERY NAME=3D"UPDATE_PROP"=20
DATASOURCE=3D"australianaccomm"><BR>UPDATE properties <BR>SET Photo =
=3D=20
'#FILE.ServerFile#'<BR>WHERE=20
username=3D'#FORM.username#'<BR></CFQUERY><BR></cfif></FONT><=
/DIV>
<DIV><FONT color=3D#0000ff size=3D2></FONT> </FONT></DIV></DIV>
<DIV><FONT color=3D#0000ff size=3D2><BR>Kind Regards</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff size=3D2>Claude Raiola<BR>E-Mail: <A=20
href=3D"mailto:[EMAIL PROTECTED]">info@internetgold=
coastproperties.com.au</A><BR>Website:=20
<A=20
href=3D"http://www.internetgoldcoastproperties.com.au">www.internetgoldco=
astproperties.com.au</A></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=3D#0000ff size=3D2></FONT> </DIV></BODY></HTML>
------=_NextPart_000_0031_01BE8FEC.F54EF980--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Help with CFFILE and rename file facility
Internet Gold Coast Properties Wed, 26 Apr 2000 00:44:13 -0700
