Update form question

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.



Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Nov 26th, 2005, 15:59
Junior Member
Join Date: Nov 2005
Location: Wisconsin
Age: 38
Posts: 27
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Update form question

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
Reply With Quote

Reply

Tags
update, form, question

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

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


All times are GMT. The time now is 23:25.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43