Dropdown Box...

1

116

I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can be
swapped out with a Textarea. This has worked fine. But can the same be done
with a Dropdown replacing a Textbox. This way I can still limit what is be
entered.

David
 
R

Ronx

Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.
 
1

116

Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David
 
S

Stefan B Rusynko

If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David
 
1

116

I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

Stefan B Rusynko said:
If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

Ronx said:
Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.





.


.
 
S

Stefan B Rusynko

Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

Stefan B Rusynko said:
If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

Ronx said:
Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.





.


.
 
1

116

Here is the code for one of the dropdown boxes:
<!--webbot bot="Validation" s-display-name="Registered Quality System"
b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1"
name="RTG_RQS" tabindex="7">
<option selected>< SELECT ONE ></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>

But I have no code to evaluate. I'm guessing that is the issue? I merely
swapped out textbox form dropdown.

Stefan B Rusynko said:
Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

Stefan B Rusynko said:
If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

Ronx said:
Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can
be
swapped out with a Textarea. This has worked fine. But can the same be
done
with a Dropdown replacing a Textbox. This way I can still limit what is
be
entered.

David

.


.


.
 
S

Stefan B Rusynko

The evaluation would have to be in the page the form is sending that form field (RTG_RQS) to
- or if sending to a database your database would have a field named RTG_RQS to accept it along with all your other fields

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Here is the code for one of the dropdown boxes:
<!--webbot bot="Validation" s-display-name="Registered Quality System"
b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1"
name="RTG_RQS" tabindex="7">
<option selected>< SELECT ONE ></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>

But I have no code to evaluate. I'm guessing that is the issue? I merely
swapped out textbox form dropdown.

Stefan B Rusynko said:
Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

Stefan B Rusynko said:
If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

Ronx said:
Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can
be
swapped out with a Textarea. This has worked fine. But can the same be
done
with a Dropdown replacing a Textbox. This way I can still limit what is
be
entered.

David

.


.


.
 
1

116

Am I correct in saying that this is basiclly an if...else?
If the data coming in is blank.value=1, then I would have to set the value
of the dropdown to 1 to see the correct option? And this script would run
'onload='?

David

Stefan B Rusynko said:
The evaluation would have to be in the page the form is sending that form field (RTG_RQS) to
- or if sending to a database your database would have a field named RTG_RQS to accept it along with all your other fields

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Here is the code for one of the dropdown boxes:
<!--webbot bot="Validation" s-display-name="Registered Quality System"
b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1"
name="RTG_RQS" tabindex="7">
<option selected>< SELECT ONE ></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>

But I have no code to evaluate. I'm guessing that is the issue? I merely
swapped out textbox form dropdown.

Stefan B Rusynko said:
Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

Stefan B Rusynko said:
If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

:

Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can
be
swapped out with a Textarea. This has worked fine. But can the same be
done
with a Dropdown replacing a Textbox. This way I can still limit what is
be
entered.

David

.



.


.


.
 
S

Stefan B Rusynko

The validation does not run at onload,
- it runs on onsubmit of the form (to check for 1st choice as not being a valid one)
- view the source of your page in the browser to see how FP generates the validation script above the form

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Am I correct in saying that this is basiclly an if...else?
If the data coming in is blank.value=1, then I would have to set the value
of the dropdown to 1 to see the correct option? And this script would run
'onload='?

David

Stefan B Rusynko said:
The evaluation would have to be in the page the form is sending that form field (RTG_RQS) to
- or if sending to a database your database would have a field named RTG_RQS to accept it along with all your other fields

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Here is the code for one of the dropdown boxes:
<!--webbot bot="Validation" s-display-name="Registered Quality System"
b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1"
name="RTG_RQS" tabindex="7">
<option selected>< SELECT ONE ></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>

But I have no code to evaluate. I'm guessing that is the issue? I merely
swapped out textbox form dropdown.

Stefan B Rusynko said:
Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

Stefan B Rusynko said:
If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

:

Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can
be
swapped out with a Textarea. This has worked fine. But can the same be
done
with a Dropdown replacing a Textbox. This way I can still limit what is
be
entered.

David

.



.


.


.
 
1

116

Sorry Stefan, I think I'm missing something.

I have a results pages with a link that send the data to a page with a
results section for editing. But my entry page is using somedropdown boxes.
On the edit page I would like to use the same (similar) dropdown boxes to
maintain uniform data entry. When the data is passed for editing, I can not
seem to get the dropdowns to reflect what was entered.

See:
http://mail.stdgear.com/intranet/quality_control/asl_ratings_edit.asp?EntryID=2

David

Stefan B Rusynko said:
The validation does not run at onload,
- it runs on onsubmit of the form (to check for 1st choice as not being a valid one)
- view the source of your page in the browser to see how FP generates the validation script above the form

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Am I correct in saying that this is basiclly an if...else?
If the data coming in is blank.value=1, then I would have to set the value
of the dropdown to 1 to see the correct option? And this script would run
'onload='?

David

Stefan B Rusynko said:
The evaluation would have to be in the page the form is sending that form field (RTG_RQS) to
- or if sending to a database your database would have a field named RTG_RQS to accept it along with all your other fields

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Here is the code for one of the dropdown boxes:
<!--webbot bot="Validation" s-display-name="Registered Quality System"
b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1"
name="RTG_RQS" tabindex="7">
<option selected>< SELECT ONE ></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>

But I have no code to evaluate. I'm guessing that is the issue? I merely
swapped out textbox form dropdown.

Stefan B Rusynko said:
Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

:

If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

:

Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can
be
swapped out with a Textarea. This has worked fine. But can the same be
done
with a Dropdown replacing a Textbox. This way I can still limit what is
be
entered.

David

.



.



.


.


.
 
S

Stefan B Rusynko

If you use an input box it would be:
<INPUT name="RTG_RQS" value="<%=RTG_RQS %>">
Or you would set up your dropdown as
<select name="RTG_RQS">
<option>< SELECT ONE ></option>
<option value="<%=RTG_RQS %>" selected><%=RTG_RQS %></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>
</select>

Where in both cases RTG_RQS is the value you get from the DB for that field by doing a DB query at the top of the page before the
form

For an example see http://www.asp101.com/samples/db_edit.asp


PS
I would tell your host to immediately TURN OFF Directory Browsing
- it is turned on and anyone can get to any of your files in any folder
(including the ones to delete records)



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Sorry Stefan, I think I'm missing something.

I have a results pages with a link that send the data to a page with a
results section for editing. But my entry page is using somedropdown boxes.
On the edit page I would like to use the same (similar) dropdown boxes to
maintain uniform data entry. When the data is passed for editing, I can not
seem to get the dropdowns to reflect what was entered.

See:
http://mail.stdgear.com/intranet/quality_control/asl_ratings_edit.asp?EntryID=2

David

Stefan B Rusynko said:
The validation does not run at onload,
- it runs on onsubmit of the form (to check for 1st choice as not being a valid one)
- view the source of your page in the browser to see how FP generates the validation script above the form

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Am I correct in saying that this is basiclly an if...else?
If the data coming in is blank.value=1, then I would have to set the value
of the dropdown to 1 to see the correct option? And this script would run
'onload='?

David

Stefan B Rusynko said:
The evaluation would have to be in the page the form is sending that form field (RTG_RQS) to
- or if sending to a database your database would have a field named RTG_RQS to accept it along with all your other fields

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Here is the code for one of the dropdown boxes:
<!--webbot bot="Validation" s-display-name="Registered Quality System"
b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1"
name="RTG_RQS" tabindex="7">
<option selected>< SELECT ONE ></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>

But I have no code to evaluate. I'm guessing that is the issue? I merely
swapped out textbox form dropdown.

Stefan B Rusynko said:
Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

:

If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

:

Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can
be
swapped out with a Textarea. This has worked fine. But can the same be
done
with a Dropdown replacing a Textbox. This way I can still limit what is
be
entered.

David

.



.



.


.


.
 
1

116

Thanks Stefan, I did happen to find that info over the w/e. However, this
returns the DB value. Since I am using lets say No, and that is stored as a
'0', its the '0' I am seeing, rather than the 'No'. Can the 'No' be
displayed rather than the value?

David

Stefan B Rusynko said:
If you use an input box it would be:
<INPUT name="RTG_RQS" value="<%=RTG_RQS %>">
Or you would set up your dropdown as
<select name="RTG_RQS">
<option>< SELECT ONE ></option>
<option value="<%=RTG_RQS %>" selected><%=RTG_RQS %></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>
</select>

Where in both cases RTG_RQS is the value you get from the DB for that field by doing a DB query at the top of the page before the
form

For an example see http://www.asp101.com/samples/db_edit.asp


PS
I would tell your host to immediately TURN OFF Directory Browsing
- it is turned on and anyone can get to any of your files in any folder
(including the ones to delete records)



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Sorry Stefan, I think I'm missing something.

I have a results pages with a link that send the data to a page with a
results section for editing. But my entry page is using somedropdown boxes.
On the edit page I would like to use the same (similar) dropdown boxes to
maintain uniform data entry. When the data is passed for editing, I can not
seem to get the dropdowns to reflect what was entered.

See:
http://mail.stdgear.com/intranet/quality_control/asl_ratings_edit.asp?EntryID=2

David

Stefan B Rusynko said:
The validation does not run at onload,
- it runs on onsubmit of the form (to check for 1st choice as not being a valid one)
- view the source of your page in the browser to see how FP generates the validation script above the form

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Am I correct in saying that this is basiclly an if...else?
If the data coming in is blank.value=1, then I would have to set the value
of the dropdown to 1 to see the correct option? And this script would run
'onload='?

David

Stefan B Rusynko said:
The evaluation would have to be in the page the form is sending that form field (RTG_RQS) to
- or if sending to a database your database would have a field named RTG_RQS to accept it along with all your other fields

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Here is the code for one of the dropdown boxes:
<!--webbot bot="Validation" s-display-name="Registered Quality System"
b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1"
name="RTG_RQS" tabindex="7">
<option selected>< SELECT ONE ></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>

But I have no code to evaluate. I'm guessing that is the issue? I merely
swapped out textbox form dropdown.

:

Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

:

If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

:

Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can
be
swapped out with a Textarea. This has worked fine. But can the same be
done
with a Dropdown replacing a Textbox. This way I can still limit what is
be
entered.

David

.



.



.



.


.


.
 
S

Stefan B Rusynko

Above the form preprocess the DB values to get the dropdown display values as say: strRTG_RQS
<%
'get RTG_RQS from DB
IF Len(RTG_RQS)>0 THEN 'make sure we have value
If IsNumeric(RTG_RQS) THEN 'make numeric if not
valRTG_RQS=Cint(RTG_RQS)
Else
valRTG_RQS=99 ' bad data
End If
Select Case valRTG_RQS
Case 0
strRTG_RQS="No"
Case 1
strRTG_RQS="Compliant"
Case 2
strRTG_RQS="Yes"
Case Else ' bad data
strRTG_RQS="Invalid"
End Select
ELSE
RTG_RQS= 99 ' bad data
END IF
%>

Then in the form field use:
<option value="<%=RTG_RQS %>" selected><%=strRTG_RQS %></option>


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Thanks Stefan, I did happen to find that info over the w/e. However, this
returns the DB value. Since I am using lets say No, and that is stored as a
'0', its the '0' I am seeing, rather than the 'No'. Can the 'No' be
displayed rather than the value?

David

Stefan B Rusynko said:
If you use an input box it would be:
<INPUT name="RTG_RQS" value="<%=RTG_RQS %>">
Or you would set up your dropdown as
<select name="RTG_RQS">
<option>< SELECT ONE ></option>
<option value="<%=RTG_RQS %>" selected><%=RTG_RQS %></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>
</select>

Where in both cases RTG_RQS is the value you get from the DB for that field by doing a DB query at the top of the page before the
form

For an example see http://www.asp101.com/samples/db_edit.asp


PS
I would tell your host to immediately TURN OFF Directory Browsing
- it is turned on and anyone can get to any of your files in any folder
(including the ones to delete records)



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Sorry Stefan, I think I'm missing something.

I have a results pages with a link that send the data to a page with a
results section for editing. But my entry page is using somedropdown boxes.
On the edit page I would like to use the same (similar) dropdown boxes to
maintain uniform data entry. When the data is passed for editing, I can not
seem to get the dropdowns to reflect what was entered.

See:
http://mail.stdgear.com/intranet/quality_control/asl_ratings_edit.asp?EntryID=2

David

Stefan B Rusynko said:
The validation does not run at onload,
- it runs on onsubmit of the form (to check for 1st choice as not being a valid one)
- view the source of your page in the browser to see how FP generates the validation script above the form

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Am I correct in saying that this is basiclly an if...else?
If the data coming in is blank.value=1, then I would have to set the value
of the dropdown to 1 to see the correct option? And this script would run
'onload='?

David

Stefan B Rusynko said:
The evaluation would have to be in the page the form is sending that form field (RTG_RQS) to
- or if sending to a database your database would have a field named RTG_RQS to accept it along with all your other fields

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Here is the code for one of the dropdown boxes:
<!--webbot bot="Validation" s-display-name="Registered Quality System"
b-value-required="TRUE" b-disallow-first-item="TRUE" --><select size="1"
name="RTG_RQS" tabindex="7">
<option selected>< SELECT ONE ></option>
<option value="0">No</option>
<option value="1">Compliant</option>
<option value="2">Yes</option>

But I have no code to evaluate. I'm guessing that is the issue? I merely
swapped out textbox form dropdown.

:

Post the code snippet from your form generating the dropdown from the results wizard
- and the snippet of code trying to evaluate it

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


I have checked the values, and everything appears to looks correct. The
fact that this is an update page (results with in a form), this should be
working?

David

:

If your dropdown had correct values it would work

<option value="2">Approved</option>
<option value="1">Limited</option>
<option value="0">Not Approved</option>



--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


Ok, example...I have an entry form with one dropdown box with 3 options:
Approved, value = 2
Limited, value = 1
Not Approved, value = 0
I created my edit page and then substituted the textbox for the dropdown
having the same options as above (same as entry). The dropdown did not show
the value (selection) as when it was entered.

I had tested the pages prior to making changes, and all the data was passing
fine. So I'm thinking that the dropdown will not display as entered (text,
not numerical).

David

:

Assuming no additional validation:

Text area - unlimited freeform text input
Text box - Freeform text input limited to 255 characters
Select/dropdown - Select from options, no freeform input.

All these are interchangeable, but have different functions as indicated.
--
Ron Symonds
Microsoft MVP (Expression Web)
http://www.rxs-enterprises.org/fp

Reply only to group - emails will be deleted unread.



I have created an Edit & Update page. On my entry page, I have used some
dropdown boxes to limit what can be entered. I realize that a Textbox can
be
swapped out with a Textarea. This has worked fine. But can the same be
done
with a Dropdown replacing a Textbox. This way I can still limit what is
be
entered.

David

.



.



.



.


.


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top