|
| |
|
|
Kage
Posts: 129
Joined: 11/20/2003
Status: offline
 |
RE: Creating an Update Query using Frontpage - 12/16/2003 18:30:05
Alright, I got a DRW page to open up an update form, into that form i copied the basic html layout information from the form used to enter the data so that it will look the same. I'm in the process of setting the fields to display data from the database by using:
<INPUT TYPE=TEXT NAME="PickedBy" SIZE=7 MAXLENGTH=7 value="<%PickedBy%>"> <b>Date Picked</b>:
I've come to a part where I need to set it to display whether or not a checkbox is checked or not and I've no idea where to begin with it. any ideas?
|
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Creating an Update Query using Frontpage - 12/16/2003 20:06:17
What is the condition that must be met for the checkbox to be marked? Here is a sample I worked up. If the record's RecordingArtistName is Homer, the box shows checked. You get the idea.
<input type="checkbox" name="C1" Value=ON <%
If FP_Field(fp_rs,"RecordingArtistName")="Homer" Then
Response.write "Checked"
End If
%>>
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kage
Posts: 129
Joined: 11/20/2003
Status: offline
|
RE: Creating an Update Query using Frontpage - 12/17/2003 13:34:57
the option itself looks like:
<INPUT TYPE=CHECKBOX NAME="ScaleCounted_Yes" value="ON">
i'm just not sure how to word it to recognize whats in the access database, the field in the database says its "text". Is the access side using "on' and "off" to determine this? the table itself was built by letting frontpage build it to the form so I'm unsure how exactly it works.
also tresting out the update query page i get the error:
"Loop Expected"
any idea what thats all about?
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Creating an Update Query using Frontpage - 12/17/2003 18:40:34
You are correct. If FP creates your db then a checkbox in the form creates a text field in the db. You will have essentially one value. The default in FP is "ON", but you could use Yes or True whatever. What happens is if the box is checked then the value you decided on is entered into the db. If the box is not checked nothing is entered or in an update form, any value in that field would be deleted if the checkbox is not checked on the update form. I am guessing your db is using "ON", so try this code:
<input type="checkbox" name="C1" Value=ON <%
If FP_Field(fp_rs,"YourFieldName")="ON" Then
Response.write "Checked"
End If
%>>
As for the "Loop Expected" error, I'll have to get back with you.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kage
Posts: 129
Joined: 11/20/2003
Status: offline
|
RE: Creating an Update Query using Frontpage - 12/17/2003 18:48:04
I will try that, I've ran into another error which prevents me from knowing if that will work or not. I fixed the Loop error lol. Thats what I came in here to state and here you were.
| |
|
|
|
Kage
Posts: 129
Joined: 11/20/2003
Status: offline
|
RE: Creating an Update Query using Frontpage - 12/17/2003 18:50:17
this double posted for some reason
< Message edited by Kage -- 12/17/2003 7:00:26 PM >
| |
|
 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 
