populating a text area

Discussion in 'Programming' started by cfnut, Apr 20, 2007.

  1. #1
    I am trying to populate a text area but am having no success. The code listed below does not generate an error but also does not populate my text area. Any suggestions are welcome!!

    Thanks,
    JN

    
    <cfquery  datasource="Mydsn"  name="custinfoquery">
    Select Custinfo FROM tblCust Where UserName = '#Client.UserName#'
    </cfquery>
    
    <cfoutput query="custinfoquery">
    	<TEXTAREA NAME="bkeywords" value="#Custinfo#" COLS=40 ROWS=6></TEXTAREA><input type="submit" name="cbkeywords"  value="Change"/>
    	</cfoutput>
    
    Code (markup):
     
    cfnut, Apr 20, 2007 IP
  2. datropics

    datropics Peon

    Messages:
    309
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    0
    #2
    It's a friday night, you're forgiven! lol

    Ok here goes:
    <cfquery datasource="Mydsn" name="custinfoquery">
    Select Custinfo FROM tblCust Where UserName = '#Client.UserName#'
    </cfquery>

    Let us ASSUME that the above query indeed returned a record (you can test that)

    Your cfoutput tag doesn't need to contain all of what you had. Instead, this what you should have done:

    <TEXTAREA NAME="bkeywords" COLS=40 ROWS=6> <cfoutput query="custinfoquery">#Custinfo#</cfoutput> </TEXTAREA>

    <input type="submit" name="cbkeywords" value="Change" />


    When it all boils down to it, you were having an HTML issue not necessarily a ColdFusion issue. For textarea, to assign a value it is <textarea .....>VALUE</texarea>

    Hope this helps

    daTropics
     
    datropics, Apr 20, 2007 IP