|
| |
|
|
wlp
Posts: 54
From: None
Status: offline
 |
Database update challange - 7/22/2001 23:00:00
I have asked members to enter information about themselves to fields in a form on an asp page using check boxes. One of the fields is "Expertise" the expertise field contains about twenty possible and multiple selections. I now want to give the members the possibility of editing or adding to these selections. I do not know how to retrieve the muliple selections from the one field in the database and display them using a check box eg.
Input page check box 1 name "Expertise" default value "audio Mixer"
Input page check box 2 name "Expertise" default value "Foley Artist". and so on for other selections in the expertise field.Should have I created a different database field for every "expertise value"? How do I allow the members to update these check box entries? Thanks John Stafford ------------------
John Stafford
WaterLine Productions
Where Sound Decsions Are Made
|
|
|
|
Mojo
Posts: 2477
From: Chicago
Status: offline
|
RE: Database update challange - 7/23/2001 20:46:00
The short answer is yes, you should have seperate fields. It will make it easier to update the information.Here is an article on database normalization. This should give you some direction on database design: http://www.4guysfromrolla.com/webtech/042699-1.shtml After you have seperate fields check out Spooky's faq on updates: http://www.outfront.net/spooky/update.htm Joe
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
RE: Database update challange - 7/23/2001 13:56:00
Thanks, I knew that would be the answer.
------------------
John Stafford
WaterLine Productions
Where Sound Decsions Are Made
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
RE: Database update challange - 7/25/2001 20:42:00
I have made my changes but I forget how to udate all the fields. Spookiy's lesson shows us just one. I have success with one but when I try to add AND I make a mistake. Sorry for the ingnorance.Can you help? ------------------
John Stafford
WaterLine Productions
Where Sound Decsions Are Made
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
RE: Database update challange - 7/29/2001 19:57:00
got it.
| |
|
|
|
Mojo
Posts: 2477
From: Chicago
Status: offline
|
RE: Database update challange - 7/29/2001 22:38:00
Whoops! Sometimes these posts need *slight* nudges to bump them back into our memory.I am glad you got it. Joe
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
RE: Database update challange - 7/30/2001 20:48:00
Okay, I have asked members to add this info to the database so that I may display the results in text form to the viewer. Do I use a text string eg. Audio Mixer in the default value so that when the check box for each field is checked. that text goes to the DB field. How do I display this text in a frindly way so that if a nu,ber of these fields are mot selected I do not have big gaps between the ones which are selected. Go to:http://www.postproduction.atfreeweb.com/english/search.asp and search for "Audio Mixer" you will see the display I wish to present. Thanks ------------------
John Stafford
WaterLine Productions
Where Sound Decsions Are Made
| |
|
 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 