Hi everyone. I have not done any type of coding in some years and can use some help with a simple yet frustrating task. I am trying to allow registered users to upload a "profile" photo to the server and insert the path into the database. I would like to do this as a "record update" in coldfusion with the session variable MM_Username as the primary key. Can someone please help me with a code sample.
cee.gee.50
0
Newbie Poster
Recommended Answers
Jump to PostArrgh... the site ate my response. Anyway, that's a sql UPDATE. The basic syntax is:
http://www.w3schools.com/SQl/sql_update.asp<cfquery ...> UPDATE TheTableName SET ImagePathColumnName = <cfqueryparam value="#variableWithPath#" cfsqltype="(your type here)"> WHERE …
Jump to PostOk, I didn't know that was your issue. Glad you figured it out. Just one thing -
#FILE#
is deprecated. Use#CFFILE.serverFile#
instead.
Jump to PostROFL .. I wish! Too bad code always does what we tell it to do, instead of what we want it to do ;-)
All 12 Replies
arrgh
22
Posting Whiz
cee.gee.50
0
Newbie Poster
arrgh
22
Posting Whiz
cee.gee.50
0
Newbie Poster
cee.gee.50
0
Newbie Poster
arrgh
22
Posting Whiz
cee.gee.50
0
Newbie Poster
arrgh
22
Posting Whiz
cee.gee.50
0
Newbie Poster
arrgh
22
Posting Whiz
cee.gee.50
0
Newbie Poster
arrgh
22
Posting Whiz
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.