mysql - Coldfusion output variable as image from database -

-

this function upload photo in map in our network. after sets path of photo , puts source in imagepath.

    <cffunction name="uploadphoto" access="public" output="false" returntype="any">              <cfif isdefined("myform.submit")>                 <returnvariable="imagepath">             </cfif>          <cfparam name="form.fileupload" default="">          <cfif len(trim(form.fileupload))>             <cfset local.imagepath = 'img/profiles/' />             <cfset strpath = expandpath( "./" ) & local.imagepath />               <cffile action="upload"              filefield="fileupload"              destination="#strpath#"              nameconflict="overwrite">            <p>thankyou, file has been uploaded.</p>         </cfif>         <cfset form.filename = cffile.serverfile>           <cfreturn local.imagepath & form.filename/>          </cffunction>    function update's database , puts img source path (imagepath) in database.        <cffunction name="savephoto" access="public" output="false" returntype="any">                     <cfargument name="dbname"   type="any" required="no" default="#server.cfc.core.getdbname()#" />                     <cfargument name="myform" type="struct" required="yes">                     <cfargument name="imagepath" type="any" required="yes">                      <cfquery name="upload" datasource="#server.cfc.core.getdsn()#">                      update logboek.tbl_users set photo=<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.imagepath#"/>                     users_id=<cfqueryparam value="#session.login_logboek.user_id#" cfsqltype="cf_sql_integer">                     </cfquery>          </cffunction>      <cffunction name="checkavatar" access="public" output="false" returntype="any">                 <cfargument name="dbname"   type="any" required="no" default="#server.cfc.core.getdbname()#" />                  <cfquery name="checkavatar" datasource="#server.cfc.core.getdsn()#">  function checks if right user logged in see photo.                      select photo logboek.tbl_users users_id=<cfqueryparam value="#session.login_logboek.user_id#" cfsqltype="cf_sql_integer">                  </cfquery>      <cfif checkavatar.recordcount eq 1>         <cfreturn checkavatar.photo />     </cfif>       </cffunction>

my problem lies in view want use image source path database output image on screen variables.checkavatar needs return "photo" database so: 

<cfoutput> #variables.checkavatar# </cfoutput>

there several things going wrong here.

first , foremost, within function checkavatar, reassigning variable checkavatar query result. effectively, destroys function first time called. due cf's weird scoping rules, need first include line <cfset var checkavatar = -1> in function before query. further recommend not naming variable same thing function in.

your call function should end looking like

<img src="#checkavatar()#"/>

since function returns path. may have additional problems sorting out difference between local file , web-accessible path file, hard debug remotely.

next, rid of <cfif checkavatar.recordcount eq 1> check, or modify handle case. if <cfreturn checkavatar.photo /> worst empty string if nothing found. currently, return nothing @ all, , crash page calls it. either throw explicitly or return default avatar image.

finally, use variables passed function arguments (as opposed passing in variables via session being done now). better design , easier reuse later.


Comments

Post a Comment

Popular posts from this blog

java - Run spring boot application error: Cannot instantiate interface org.springframework.context.ApplicationListener -

-
i have spring project , try make use spring boot , run @ embadded tomcat following : https://spring.io/guides/gs/rest-service/ this application //@configuration //@enableaspectjautoproxy @springbootapplication @componentscan(basepackages = "gux.prome") public class application { public static void main(string[] args) { springapplication.run(application.class, args); } } if use maven command: mvn spring-boot:run , project starts fine, need debug , run main method @ intelij, exception occurs: exception in thread "main" java.lang.illegalargumentexception: cannot instantiate interface org.springframework.context.applicationlistener : org.springframework.boot.logging.classpathloggingapplicationlistener @ org.springframework.boot.springapplication.createspringfactoriesinstances(springapplication.java:414) @ org.springframework.boot.springapplication.getspringfactoriesinstances(springapplication.java:394) @ org.springframework.bo...
Read more

python - pip wont install .WHL files -

-
when try install .whl gohike typing cmd c:\users\owner\downloads>pip install ta_lib-0.4.9-cp27-none-win_amd64.whl i print out: `processing c:\users\owner\downloads\ta_lib-0.4.9-cp27-none-win_amd64.whl complete output command python setup.py egg_info: traceback <most recent call last>: file "<string>", line 1, in <module> ioerror: [errno 2] no such file or directory:'c:\\users\\owner\\appdata\\lo cal\\temp\\pip-9gwk2c-build\\setup.py' ----------------------------------------- command "python setup.py egg_info" failed error code 1 in c:\users\owner\ap pdata\local\temp\pip-9gwk2c-build\` the part between pip- , -build in pip-9gwk2c-build different on same file. i asked python 2.7.11 pip 8.0.3 can't install gohike whl of ta-lib 0.4.9 few days ago , decided ask differently. can me! you have outdated pip not understand wheels. wheels not supposed have setup.py inside. try upgrading pip pip in...
Read more

Excel VBA "Microsoft Windows Common Controls 6.0 (SP6)" Location Changes -

-
i have excel workbook used generate quotations customers. there main page user inputs data, , there buttons generate various pdfs , send them customer. however, 1 user consistently getting error preventing generating , sending pdfs. i beleive "microsoft windows common controls 6.0 (sp6)". it's installed on users' computers. on mine, location "c:\windows\syswow64\mscomctl.ocx" on others "c:\windows\system32\mscomctl.ocx" the user experiencing issues on 32-bit machine, "mscomctl.ocx" file should in system32. have manually put in there, , pointed common controls reference in vba it. issue seems keep reverting looking in syswow64. since folder doesn't exist, can't find it, , can't produce pdfs. i thought perhaps issue user running older version of office (2007) there users on 2013 , 2016. thought perhaps mixture of 64-bit , 32-bit users. user gets sent workbook other users (as quotation process goes further, gets passed ...
Read more