losing data on frontpage edit from drop down boxes

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

losing data on frontpage edit from drop down boxes

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> losing data on frontpage edit from drop down boxes

Page: [1]


designzo Posts: 16 Joined: 10/10/2007 Status: offline	losing data on frontpage edit from drop down boxes - 10/10/2007 1:29:56 We have created an availability system using Frontpage 2002 and Access 2003, please see http://www.designzontravel.co.nz/Database1_interface/Acottemp/editor/database_editor.asp Problem is that when we edit we lose our previous edits, each month is a record and days are fields Edit returns all fields that all get updated with each edit we have read articles on fixing results from drop downs but can not make it work Should we be filling edit cells another way, we have had it working using simple text letters but are keen to keep the colored boxes but can not ask users to put in the image files ie images/full.gif Any help would be appreciated Thank you


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: losing data on frontpage edit from drop down boxes - 10/10/2007 14:34:52 Have you modified the code for edit.asp your self? if so, what is the code? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to designzo)


designzo Posts: 16 Joined: 10/10/2007 Status: offline	RE: losing data on frontpage edit from drop down boxes - 10/10/2007 15:41:01 Thanks Spooky edit.asp was created entirely as standard by the Frontpage DBR wizard, option chosen for fields we wanted to update/change was dropdown boxes with 3 options we then changed edit.asp by going to html view and putting values for the 3 options i.e. for option 1 adding "images/avail.gif" and Available <td align="center" height="15"> <select size="1" name="S1"> <option <% if "Option 1" = FP_Field(fp_rs,"S1") then %> selected <% end if %> value="images/avail.gif">Available</option> <option <% if "Option 2" = FP_Field(fp_rs,"S1") then %> selected <% end if %> value="images/full.gif">Booked</option> <option <% if "Option 3" = FP_Field(fp_rs,"S1") then %> selected <% end if %> value="images/special.gif">Special</option> </select></td> We have also tried doing it though the normal view but lose the selected value on all fields, we have tried having a default selection and having no selection. Other mods were to list.asp and results_page.asp where we inserted an image in the field, went to picture properties, general, deleted picture parameter, and added field parameter to get a picture place holder. Thanks again (in reply to Spooky)

Spooky

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: losing data on frontpage edit from drop down boxes - 10/10/2007 15:50:53

Try it this way :

<td align="center" height="15">
<select size="1" name="S1"> 
<option <% if FP_Field(fp_rs,"S1") ="images/avail.gif" then %> selected <% end if %> value="images/avail.gif">Available</option>
<option <% if FP_Field(fp_rs,"S1") ="images/full.gif" then %> selected <% end if %> value="images/full.gif">Booked</option>
<option <% if FP_Field(fp_rs,"S1") ="images/special.gif" then %> selected <% end if %> value="images/special.gif">Special</option>
</select></td>

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

��k�

Database / DRW help Check out the Tutorials for Frontpage Databases

Forum FAQ' s

Developers Edition Spooky Login User Registration and Management tool

Personalized Frontpage Hosting

(in reply to designzo)


designzo Posts: 16 Joined: 10/10/2007 Status: offline	RE: losing data on frontpage edit from drop down boxes - 10/10/2007 16:37:13 Thank you very much Spooky Works perfectly! you're a star (in reply to Spooky)

Page: [1]

All Forums >> Web Development >> ASP and Database >> losing data on frontpage edit from drop down boxes

Page: [1]

Jump to: 1

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