expandPath

Thanks a lot. the cfqueryparam worked a treat. Now the filename is perfect. Still can't get the image to display though ;) but the path is fine.

see if using cfqueryparam makes a difference:
UPDATE site_user SET prof_img=<cfqueryparam cfsqltype="cf_sql_varchar"
value="#fileloc#">

if not, try setting your fileloc var as a string:
<cfset fileloc="#destination#/#img#">

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

<cfif structKeyExists(form, "prof_img")>

<cfset destination = expandPath("../images/userimgs")>

<cffile action="upload" destination="#destination#" filefield="FORM.prof_img" nameconflict="makeunique" >

<cfset img1= UserID& DateFormat(Now(),"DDMMYY") & TimeFormat(Now(),"HHmmss")>

<cfset img =ListAppend(img1,FILE.ServerFileExt,".")>

<cffile action="rename" source="#destination#/#cffile.ServerFile#" destination="#destination#/#img#" >
<cfset fileloc=#destination# & "/" & #img#>

<cfquery datasource="foliobox">
UPDATE site_user SET prof_img='#fileloc#'
WHERE userid=<cfqueryparam value="#FORM.userid#" cfsqltype="cf_sql_numeric">
</cfquery>

</cfif>


Now I just tested this and checked the db, here is my entry into it:

C:ColdFusion8wwwrootPortfolio_Projectimagesuserimgs/10040308004649.jpg

See no '/' except fo the one I put in while setting the fileloc variable

post your code that inserts the directory. there's likely a problem with
that...

do you use the #cffile.serverDirectory# var or insert the path manually?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/