|
| |
|
|
DKN
Posts: 35
From: Olathe, Kansas, USA
Status: offline
 |
Using Drop down menus to edit a record - 10/8/2001 20:17:00
I know its possible to use a drop down menu to create a new record but can you use drop down menus to edit a record. Say when a user clicks on a certain record a paramater is used to pull that specific record from the database to the edit page. Usually this page is all text boxes. Is it possible to use drop down menus again with this edit page?
|
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Using Drop down menus to edit a record - 10/8/2001 18:57:00
Yes it is, but there needs to be a way to check that the first view is the current record and not the default (top) value of the drop down list.eg: <option name="1" Value="1" <%If DatabaseValue="1" then Response.write " selected"%>>Value 1</option>
<option name="2" Value="2" <%If DatabaseValue="2" then Response.write " selected"%>>Value 2</option>
| |
|
|
|
DKN
Posts: 35
From: Olathe, Kansas, USA
Status: offline
|
RE: Using Drop down menus to edit a record - 10/9/2001 14:34:00
Could you take a quick look at this code and tell mw what Im doing wrong. <td width="109" bgcolor="#C0C0C0"><b>Project Mgr:</b></td>
<td width="626"><select size="1" name="Project Mgr">
<option name="1" Value="John Mueller" <%If "ProjectMgr"="1" then Response.write " selected"%>>John Mueller</option>
<option name="2" Value="Darren Nichols" <%If "ProjectMgr"="2" then Response.write " selected"%>>Darren Nichols</option>
<option name="3" Value="Darrell Fox" <%If "ProjectMgr"="3" then Response.write " selected"%>>Darrell Fox</option> </select></td>
| |
|
|
|
rdouglass
Posts: 9228
From: Biddeford, ME USA
Status: offline
|
RE: Using Drop down menus to edit a record - 10/9/2001 15:04:00
I think you're just grabbing your field values incorrectly. I think it should be something like:<td width="109" bgcolor="#C0C0C0"><b>Project Mgr:</b></td>
<td width="626"><select size="1" name="Project Mgr">
<option name="1" Value="John Mueller" <%If fp_fieldVal(fp_rs,"ProjectMgr")="1" then Response.write " selected"%>>John Mueller</option>
...etc... That is if you're pulling info from a DB. If you're pulling it from a POSTing form, use: <option name="1" Value="John Mueller" <%If Request.Form("ProjectMgr")="1" then Response.write " selected"%>>John Mueller</option>
[This message has been edited by rdouglass (edited 10-09-2001).]
| |
|
|
|
DKN
Posts: 35
From: Olathe, Kansas, USA
Status: offline
|
RE: Using Drop down menus to edit a record - 10/9/2001 17:11:00
This is coming from the database. I tried this code with still no luck. <td width="109" bgcolor="#C0C0C0"><b>Project Mgr:</b></td>
<td width="626"><select size="1" name="ProjectMgr">
<option name="1" Value="John Mueller" <%If FP_FieldVal(fp_rs,"ProjectMgr")="1" then Response.write " selected"%>>John Mueller</option>
| |
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Using Drop down menus to edit a record - 10/9/2001 21:27:00
If you have a "Value=John Mueller" then the FP_FieldVal(fp_rs,"ProjectMgr") will also have to equal "John Mueller"Unless you are using the priamry autonumber
field, and the value for John Mueller is "1" It thats the case,then "value" will also have to equal "1" So to clarify : <option Value="John Mueller" <%If FP_FieldVal(fp_rs,"ProjectMgr")="John Mueller" then Response.write " selected"%>>John Mueller</option> This assumes the list box is INSIDE the DRW area so that that function is valid.
------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart
| |
|
|
|
DKN
Posts: 35
From: Olathe, Kansas, USA
Status: offline
|
RE: Using Drop down menus to edit a record - 10/11/2001 20:26:00
That worked like a charm. Thanks much Spooky
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
