Member Avatar for OWL76

Hey guys, complete noob, been trying to figure out how to wrap my head around cffile for a couple of weeks now. I can get a file to upload to the server, even change the name once saved. But i am having problems entering the data into my database.any help would be greatly appreciated...

<cfif structKeyExists(form,"fileUpload") and len(form.fileUpload)>
<cfquery datasource="wpan7608">
INSERT INTO Photos('Photo')
VALUES('#Trim(FORM.Photo)#')
</cfquery>
</cfif>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Upload Photo</title>
<link rel="stylesheet" href="styles/style.css" type="text/css" media="screen" />

<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>

<body class="oneColElsCtr">

<div id="container">
  <div id="mainContent">
  
    <cfinclude template="includes/header.cfm">
    <div id="uploadForm">
    <!---
   Create folder structure or change to fit your needs
   Expects images to be uploaded to images and thumbnails go in thumbs
--->


<!--- set the full path to the images folder --->


<!--- set the desired image height ---->
<cfset thumbsize = 75>

<!--- set the desired image width --->
<cfset imagesize = 320>


<cfif structKeyExists(form,"fileUpload") and len(form.fileUpload)>
   <cfset mediapath = expandpath('./images/#FORM.Name#.jpg')>
   <cffile action="upload"
   filefield="FileUpload"
   destination="#MediaPath#"
   nameconflict="makeunique">
   
   <!--- read the image ---->
   <cfimage name="uploadedImage"
   source="#MediaPath#" >

  
   
   <cfoutput>
      <img src="images/#file.ServerFile#" align="left" hspace="10"><br>

          <a href="images/#file.serverFile#">See Image</a><br>
      
   </cfoutput>
</cfif>   

<cfform action="test_upload_3.cfm" method="post" enctype="multipart/form-data">
   <label for="artist_name">Name image:</label>
   <cfinput type="text" name="artist_name" />
   <label for="fileUpload">Choose Image: </label>
   <cfinput type="file" name="fileUpload">
   <cfinput type="submit" name="UploadImage" value="Upload Image">
   <label for="Photo">Photo name:</label>
   <cfinput type="text" name="Photo" />
</cfform>

 </div>
    
    
	<!-- end #mainContent --></div>
<!-- end #container --></div>
<div id="footer">
<cfinclude template="includes/footer.cfm">
	</div>
</body>
</html>
  • 3 Contributors
  • 2 Replies
  • 145 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by danarashad
Member Avatar for freshfitz

What error are you geting I think your insert should be

INSERT INTO Photos(Photo)

Member Avatar for danarashad

Move your insert statement below the file upload section.
Then insert file.ServerFile as the name.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.