QUERYING FROM DATABASE AND FOLDER ??

[kingjjx]

Hi, I want to ask how I can display results of a query or how to do this query .... .

I have a database called CARS where information of car name and owner is stored, and a folder called CARIMAGES where users upload pictures of their cars.

How do I output the car owner's name, his car and the name of his picture file in a page.

Result would look something like this:

OWNER: JAMES
CAR: HONDA
PICTURE: Jameshonda.JPG

OWNER: MARK
CAR: BMW
PICTURE: Mark.JPG


thanks !!

 

[vipm]

You need to also store the file name of the images in your database so you can dynamically show them. So it'll be something like:
<cfoutput query=&quot;q_cars>
OWNER: #name#
CAR: #car#
PICTURE: <IMG SRC=&quot;#carpic#&quot;>
</cfoutput>

 

[kingjjx]

hey .. how do i upload the images ?
can i do multiple uploads ???

the only way i know how to upload a file is :
Image: <INPUT TYPE=&quot;FILE&quot; NAME=&quot;FILE1&quot;>
<input type=&quot;submit&quot;>

how do i write the upload script to upload the images and the owner's name and car name at one time ??

thanks

 

[slackie]

Use the <cffile> tag in coldfusion.

Something like

<CFFILE
DESTINATION=&quot;C:\INETPUB\

http://WWWROOT\SITEFOLDER\FILES\&quot;

ACTION=&quot;UPLOAD&quot;
NAMECONFLICT=&quot;OVERWRITE&quot;
FILEFIELD=&quot;FileName&quot;>