In your insert statement, reference the "FORM.eqImage" field for your dbase entry and use '#cffile.serverFile#. This will grab the name of the file (in this case, the image) that you have uploaded to your server. cffile.clientfile also works, but this will only get the name of what the user uploads--with the "makeunique" on the cffile, this will not work, for the file will be renamed on the server, but will be entered into the dbase as what the client's file was named.
To display it, simply do a normal <img src="pathtoimage/#ImageName#"> or whatever your query column is. > Hey Dave, > > I have to save the name of the image in the database.how to do it. and > then need to make a display page where i have to display the entire > image with other information.how should i go about with that.the code > that i am using currently: > > <cffile action="upload" fileField="Form.eqImage" > destination="Pictures" nameConflict="MakeUnique" accept="image/*"> > > your help is appreciated. > > > > >Simple answer: Wrap part of the display in a link, and pass the row > id as a > >url parameter to the target page. In the target page re-query just > that row > >and display the results. > > > > For the file upload, do you want to save the actual file or the > >filepath/filename in the db? > > > >-----Original Message----- > >From: Mayank Sharma [mailto:[EMAIL PROTECTED] > >Sent: Wednesday, March 14, 2007 11:23 AM > >To: CF-Talk > >Subject: How to make query results clickable > > > > > >Hey, > >I am querying the database and displaying the results.How can i make > the > >results clickable such that when u click on any of the rows it > displays the > >detailed description of that row. > > > >Also if i am uploading a file.how do we save it the database. > >here we r using MY SQL. > > > >Please help..its urgent > > > >Thanks >Mayank ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
