This is a discussion on "Update form question" within the Databases section. This forum, and the thread "Update form question are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
Update form question
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
|||
|
Hi folks-
I am in the learning stages of working with databases. Anyway, I am at the point where I have created the database and am looking to create teh function in which the user can choose a listing from the database to update using a dropdown menu. I have created the page that has the dropdown menu with the listings (for my purpose they are job postings) and that part functions. What I am confused on is how to pass on the chosen listings to the update form page which will then list the job posting and all other info for that record. (i.e. the position, description and requirements). My DSN is named Jobpost and my database is jobs. My primary key is JobID Here's the code I have set up on the dropdown menu page which is functioning correctly: <cfquery name="JobPost" datasource="JobPost"> SELECT * FROM jobs </cfquery> <p class="Photos">Please select an option below:</p> <form action="Updateselectedjob.cfm" method="post"> <table width="310" border="1"> <tr> <td width="120" class="Copy">Job Position: </td> <td colspan="2"><select name="Postion" id="Postion" class="formcopy"> <option value="Jobs">Choose One</option> <cfoutput query="JobPost"> <option value="#JobID#">#Position#</option> </cfoutput> </select></td> </tr> <tr> <td width="62"><input type="submit" id="ModifyPosting" value="Edit Posting"></td> On that update page, here I believe is my area that needs to be resolved. I have the following code set up: <cfquery name= "JobPost" datasource="JobPost"> SELECT * FROM jobs WHERE JobID = #URL.JobID# </cfquery> How do I get the dropdown menu page to pass on the jobID info to the update page through the URL? Thanks for any help you can provide!! Dave |
|
|
![]() |
| Tags |
| update, form, question |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| First Hello - and a simple FORM question | webhead | Introduce Yourself | 4 | Apr 7th, 2008 18:02 |
| [SOLVED] 2 weeks trying to update from a form | saltedm8 | PHP Forum | 12 | Oct 13th, 2007 14:32 |
| basic form question | antonyx | Classic ASP | 1 | Aug 30th, 2006 14:18 |
| Another form-tag question | a.jenery | Web Page Design | 3 | Mar 23rd, 2006 10:10 |
| Newbie question - update ASP on server | alexandra | Classic ASP | 6 | Dec 4th, 2005 05:13 |