Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Nov 2008
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Coldfusion form processing

    Hello,

    I have created a form based on values from a MSSQL database
    Code:
    <cfoutput query="Items">
    	<tr>
    	    <td>#trim(Item)# #DollarFormat(Price)#</td>
    	    <td><input name="#trim(Item)#" type="text" value="Qty"></td>
    	</tr>
    </cfoutput>
    how can i query the database and use the results from the item query to process the form



    Thanks in advance

  • #2
    Regular Coder slappyjaw's Avatar
    Join Date
    Mar 2009
    Location
    Wonderland!
    Posts
    146
    Thanks
    14
    Thanked 3 Times in 3 Posts
    Code:
    <cfquery name="name of query" datasource="your datasource address" username="usernameofdatasource" password="password for datasource" result="and your results for the query!">
    Please fill in the information and it will be the query part of the script.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •