ColdFusion

how to solve this problem

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2009

Posts: 7

Reputation: nagkar is an unknown quantity at this point

Solved Threads: 0

nagkar

Offline

Newbie Poster

how to solve this problem

May 1st, 2009

Hi ...how to solve this problem........In a form there is a Cfbutton which is of submit type.when the user click this button i want a insertquery to be executed which collects datat from a dynamic table.I dont want to reload the whole page when the user clicks this button.

 Help with Code Tags 
 coldfusion Syntax (Toggle Plain Text) 
<table border="2px">
                                              <tr>
                                                <td>product</td>
                                                <td>Lot</td>
                                                <td>d_amount</td>
                                                <td>d_unit</td>
 
                                              </tr>
                                              <cfoutput query="qrecipes">
                                                <tr>
                                                  <td>#qrecipes.ingredient#</td>
                                                  <td><cfselect name="lot" id="lot" ><option value=1>xyz</option><option value=2>abc</option></cfselect></td>
                                                  <td>#qrecipes.d_amount#</td>
                                                  <td>#qrecipes.d_unit#</td>
 
 
                                                </tr>
                                              </cfoutput>
                                            </table>
 
 
                                          <cfinput type="submit" name="storebuild" value="sotrebuild">
                              <cfinput type="submit" name="clear" value="clear">
<table border="2px">
                                              <tr>
                                                <td>product</td>
                                                <td>Lot</td>
                                                <td>d_amount</td>
                                                <td>d_unit</td>
                                               
                                              </tr>
                                              <cfoutput query="qrecipes">
                                                <tr>
                                                  <td>#qrecipes.ingredient#</td>
                                                  <td><cfselect name="lot" id="lot" ><option value=1>xyz</option><option value=2>abc</option></cfselect></td>
                                                  <td>#qrecipes.d_amount#</td>
                                                  <td>#qrecipes.d_unit#</td>
                                                
                                                 
                                                </tr>
                                              </cfoutput>
                                            </table>


                                          <cfinput type="submit" name="storebuild" value="sotrebuild">
                              <cfinput type="submit" name="clear" value="clear">

when the user clicks the storebuild button i want to run a insert query to enter the data displayed in to another table.how do i need to approach thisproblem.

Last edited by peter_budo; May 7th, 2009 at 3:27 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.