IMAGE AND TEXT FORM(HELP!!!)

•

What is DaniWeb IT Discussion Community?

You're currently browsing the ColdFusion section within the Web Development category of DaniWeb, a massive community of 373,469 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,968 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our ColdFusion advertiser:

Thread Tools Display Modes

Views: 997 | Replies: 1

•

Join Date: Feb 2008

Posts: 16

Reputation: zoid777 is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

zoid777

Offline

Newbie Poster

IMAGE AND TEXT FORM(HELP!!!)

Mar 6th, 2008

Hello Friends, I want to upload an image to the server and also insert the image path into the database, I have a sample of my code below

Help with Code Tags

(Toggle Plain Text)

<cfinput type="text" name="city">
      </label></td>
      <td>State</td>
      <td><label>
        <cfinput type="text" name="state">
      </label></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Email</td>
      <td><label>
        <cfinput type="text" name="email" validate="email" required="no" >
      </label></td>
<td>Picture</td>
      <td height="23"><label>
        <cfinput type="file" name="picture">
      </label></td>
I use the typical SQL syntax as below
INSERT INTO patient(
id,
lastname,
mi,
firstname,
age,
VALUES(
'#Trim(Form.id)#',
'#Trim(Form.lastname)#',
'#Trim(Form.mi)#',
'#Trim(Form.firstname)#',
'#Trim(Form.age)#',

Could someone give me a detailed description, on how to write the action page so I can insert the image path into the database.

Thanks

Last edited by peter_budo : Mar 6th, 2008 at 6:05 am. Reason: Please use [code] tags