|
| |
trouble sending text to DB using check box in DB results region
View related threads:
(in this forum
| in all forums)
|
Logged in as: Guest
|
|
|
wlp
Posts: 54
From: None
Status: offline
 |
trouble sending text to DB using check box in DB result... - 7/12/2001 20:28:00
Sorry for the lengthy subject. I am sending text to a DB using a chack box inside the database results region so that I can send the text returned from a table. eg.Check box with Name = Category
Value = <%=FP_FieldLink(fp_rs,"Category")%> There are multiple records with different category names. What happens is when sent to the "Freelancers" table in the DB the characters "%20" are inserted as text spaces. So,,, I thought of using the ID to send to the category field but I cannot retrieve the linked data in the category table with having this look "Ausio%20Mixer" instead of "Audio Mixer". I know this is done all the time but I cannot figure it out by just using Front page,
Any Help??
|
|
|
|
Vince from Spain
Posts: 658
From: Madrid Spain
Status: offline
|
RE: trouble sending text to DB using check box in DB re... - 7/12/2001 20:48:00
Hi there,
it looks like what is happening is that your field is being encoded so that it can be passed as a safe URL. Spaces are not safe in a URL so are replaced with %20 which is the equivilent URL encoded form.
If you don't want this to happen, try usingCheck box with Name = Category
Value = <%=FP_Field(fp_rs,"Category")%> instead of the FP_FieldLink call. All the best Vince ------------------
Internet Business Solutions S.L.(Spain)
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
RE: trouble sending text to DB using check box in DB re... - 7/16/2001 22:55:00
Thanks for the response. it works just fine now. My next challange is much bigger. I have asked members to enter information about themselves to fields in a database using check boxes. One of the fields is "Expertise" the expertise field contains about twenety possible and multiple selections. I now want to give the membees the possibility of editing or adding to these selections. I do not know how to retrieve the muliple selections from the one field of 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". Do I make sense. Should have I created a different database field for every "expertise value"Thanks John Stafford ------------------
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 
