Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: help


Message #1 by Dan Crandell <dan_c39@y...> on Fri, 11 Oct 2002 07:16:09 -0700 (PDT)
question this code makes a drop down with No and Yes, No shows up in the text field by default.  I want to make yes show up?

 

<tr><td WIDTH="20"></td>
 <td ALIGN="LEFT" WIDTH="150" VALIGN="TOP" class="rhf">Requisition Approved:</td>
 <td ALIGN="LEFT" WIDTH="490" VALIGN="TOP" class="rf">
  <Select Name="RequisitionApproved">
   <%
    Dim YSelected, NSelected
    
    If (objRst("RequisitionApproved") = "Y") Then
     YSelected = "SELECTED"
     NSelected = ""
    Else
     YSelected = ""
     NSelected = "SELECTED"
    End If
   %>
   <option value=N <%=NSelected%>>No</option>
   <option value=Y <%=YSelected%>>Yes</option>
  </select>
 </td>
</tr>

 



---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com
Message #2 by "Scott Heath" <scott@s...> on Fri, 11 Oct 2002 09:32:49 -0500
Dan,
I just copied this code, change the database stuff to basic variables
and tested it and it worked. Try printing the result from the database
such as:

<tr><td WIDTH="20"></td>
 <td ALIGN="LEFT" WIDTH="150" VALIGN="TOP" class="rhf">Requisition
Approved:</td>
 <td ALIGN="LEFT" WIDTH="490" VALIGN="TOP" class="rf">
  <Select Name="RequisitionApproved">
   <%
    Dim YSelected, NSelected
    
    If (objRst("RequisitionApproved") = "Y") Then
     YSelected = "SELECTED"
     NSelected = ""
    Else
     YSelected = ""
     NSelected = "SELECTED"
    End If
'error checking (why wont this work gosh darnit!)
Response.Write(objRst("RequisitionApproved") & "<BR>")
Response.Wite(NSelected & "<br>" & YSelected)
'end error checking
   %>
   <option value=N <%=NSelected%>>No</option>
   <option value=Y <%=YSelected%>>Yes</option>
  </select>
 </td>
</tr>


Scott
 
Website      | http://www.scottspad.com
E-mail       | scott@s...
Alpha Pager  | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] help


question this code makes a drop down with No and Yes, No shows up in the
text field by default.  I want to make yes show up?

 

<tr><td WIDTH="20"></td>
 <td ALIGN="LEFT" WIDTH="150" VALIGN="TOP" class="rhf">Requisition
Approved:</td>
 <td ALIGN="LEFT" WIDTH="490" VALIGN="TOP" class="rf">
  <Select Name="RequisitionApproved">
   <%
    Dim YSelected, NSelected
    
    If (objRst("RequisitionApproved") = "Y") Then
     YSelected = "SELECTED"
     NSelected = ""
    Else
     YSelected = ""
     NSelected = "SELECTED"
    End If
   %>
   <option value=N <%=NSelected%>>No</option>
   <option value=Y <%=YSelected%>>Yes</option>
  </select>
 </td>
</tr>

 



---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


Message #3 by Dan Crandell <dan_c39@y...> on Fri, 11 Oct 2002 07:43:55 -0700 (PDT)
Hey scott the actual code I have does work ie, if there is a "Y" then yes gets populated.  However, I want yes to show up in the
text box prior to updating the table right now it No shows up is that because of alphabetical?
 Scott Heath <scott@s...> wrote:Dan,
I just copied this code, change the database stuff to basic variables
and tested it and it worked. Try printing the result from the database
such as:


Requisition
Approved:

 >No >Yes




Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] help


question this code makes a drop down with No and Yes, No shows up in the
text field by default. I want to make yes show up?




Requisition
Approved:

 >No >Yes







---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com
Message #4 by "Scott Heath" <scott@s...> on Fri, 11 Oct 2002 11:01:51 -0500
OK call me a moron :) I see what your asking now. Try the following:

YSelected = "SELECTED"

If (objRst("RequisitionApproved") = "Y") Then     
	YSelected = "SELECTED"
     NSelected = ""
End IF

If (objRst("RequisitionApproved") = "N") Then     
     YSelected = ""
     NSelected = "SELECTED"
    End If

It's not because it's in Alpha order. Look at your IF THEN ELSE
statement.
'ORGINAL CODE
If (objRst("RequisitionApproved") = "Y") Then
     YSelected = "SELECTED"
     NSelected = ""
    Else
     YSelected = ""
     NSelected = "SELECTED"
    End If

If object = Y Then
Mark yes as selected
If object <> Y then
Mark No as selected

Instead of using Else you may want to use two IF THEN statements.
Hope this helps

Scott
 
Website      | http://www.scottspad.com
E-mail       | scott@s...
Alpha Pager  | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Hey scott the actual code I have does work ie, if there is a "Y" then
yes gets populated.  However, I want yes to show up in the text box
prior to updating the table right now it No shows up is that because of
alphabetical?
 Scott Heath <scott@s...> wrote:Dan,
I just copied this code, change the database stuff to basic variables
and tested it and it worked. Try printing the result from the database
such as:


Requisition
Approved:

 >No >Yes




Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] help


question this code makes a drop down with No and Yes, No shows up in the
text field by default. I want to make yes show up?




Requisition
Approved:

 >No >Yes







---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


Message #5 by Dan Crandell <dan_c39@y...> on Fri, 11 Oct 2002 09:16:11 -0700 (PDT)
Excellent thanks it works great.
 Scott Heath <scott@s...> wrote:OK call me a moron :) I see what your asking now. Try the following:

YSelected = "SELECTED"

If (objRst("RequisitionApproved") = "Y") Then 
YSelected = "SELECTED"
NSelected = ""
End IF

If (objRst("RequisitionApproved") = "N") Then 
YSelected = ""
NSelected = "SELECTED"
End If

It's not because it's in Alpha order. Look at your IF THEN ELSE
statement.
'ORGINAL CODE
If (objRst("RequisitionApproved") = "Y") Then
YSelected = "SELECTED"
NSelected = ""
Else
YSelected = ""
NSelected = "SELECTED"
End If

If object = Y Then
Mark yes as selected
If object <> Y then
Mark No as selected

Instead of using Else you may want to use two IF THEN statements.
Hope this helps

Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Hey scott the actual code I have does work ie, if there is a "Y" then
yes gets populated. However, I want yes to show up in the text box
prior to updating the table right now it No shows up is that because of
alphabetical?
Scott Heath wrote:Dan,
I just copied this code, change the database stuff to basic variables
and tested it and it worked. Try printing the result from the database
such as:


Requisition
Approved:

>No >Yes




Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] help


question this code makes a drop down with No and Yes, No shows up in the
text field by default. I want to make yes show up?




Requisition
Approved:

>No >Yes







---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com
Message #6 by "Scott Heath" <scott@s...> on Fri, 11 Oct 2002 11:22:57 -0500
WOO HOO!!!




-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 11:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Excellent thanks it works great.
 Scott Heath <scott@s...> wrote:OK call me a moron :) I see
what your asking now. Try the following:

YSelected = "SELECTED"

If (objRst("RequisitionApproved") = "Y") Then 
YSelected = "SELECTED"
NSelected = ""
End IF

If (objRst("RequisitionApproved") = "N") Then 
YSelected = ""
NSelected = "SELECTED"
End If

It's not because it's in Alpha order. Look at your IF THEN ELSE
statement.
'ORGINAL CODE
If (objRst("RequisitionApproved") = "Y") Then
YSelected = "SELECTED"
NSelected = ""
Else
YSelected = ""
NSelected = "SELECTED"
End If

If object = Y Then
Mark yes as selected
If object <> Y then
Mark No as selected

Instead of using Else you may want to use two IF THEN statements.
Hope this helps

Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Hey scott the actual code I have does work ie, if there is a "Y" then
yes gets populated. However, I want yes to show up in the text box
prior to updating the table right now it No shows up is that because of
alphabetical?
Scott Heath wrote:Dan,
I just copied this code, change the database stuff to basic variables
and tested it and it worked. Try printing the result from the database
such as:


Requisition
Approved:

>No >Yes




Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] help


question this code makes a drop down with No and Yes, No shows up in the
text field by default. I want to make yes show up?




Requisition
Approved:

>No >Yes







---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


Message #7 by Dan Crandell <dan_c39@y...> on Fri, 11 Oct 2002 09:29:03 -0700 (PDT)
Yea and its friday!
 Scott Heath <scott@s...> wrote:WOO HOO!!!




-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 11:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Excellent thanks it works great.
Scott Heath wrote:OK call me a moron :) I see
what your asking now. Try the following:

YSelected = "SELECTED"

If (objRst("RequisitionApproved") = "Y") Then 
YSelected = "SELECTED"
NSelected = ""
End IF

If (objRst("RequisitionApproved") = "N") Then 
YSelected = ""
NSelected = "SELECTED"
End If

It's not because it's in Alpha order. Look at your IF THEN ELSE
statement.
'ORGINAL CODE
If (objRst("RequisitionApproved") = "Y") Then
YSelected = "SELECTED"
NSelected = ""
Else
YSelected = ""
NSelected = "SELECTED"
End If

If object = Y Then
Mark yes as selected
If object <> Y then
Mark No as selected

Instead of using Else you may want to use two IF THEN statements.
Hope this helps

Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Hey scott the actual code I have does work ie, if there is a "Y" then
yes gets populated. However, I want yes to show up in the text box
prior to updating the table right now it No shows up is that because of
alphabetical?
Scott Heath wrote:Dan,
I just copied this code, change the database stuff to basic variables
and tested it and it worked. Try printing the result from the database
such as:


Requisition
Approved:

>No >Yes




Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] help


question this code makes a drop down with No and Yes, No shows up in the
text field by default. I want to make yes show up?




Requisition
Approved:

>No >Yes







---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better
Message #8 by "Scott Heath" <scott@s...> on Fri, 11 Oct 2002 11:42:32 -0500
Then it deserves a double woo hoo!

  Ok I'm gonna get back to work now...XP is taking FOREVER to install on
this machine!


-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 11:29 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Yea and its friday!
 Scott Heath <scott@s...> wrote:WOO HOO!!!




-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 11:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Excellent thanks it works great.
Scott Heath wrote:OK call me a moron :) I see
what your asking now. Try the following:

YSelected = "SELECTED"

If (objRst("RequisitionApproved") = "Y") Then 
YSelected = "SELECTED"
NSelected = ""
End IF

If (objRst("RequisitionApproved") = "N") Then 
YSelected = ""
NSelected = "SELECTED"
End If

It's not because it's in Alpha order. Look at your IF THEN ELSE
statement.
'ORGINAL CODE
If (objRst("RequisitionApproved") = "Y") Then
YSelected = "SELECTED"
NSelected = ""
Else
YSelected = ""
NSelected = "SELECTED"
End If

If object = Y Then
Mark yes as selected
If object <> Y then
Mark No as selected

Instead of using Else you may want to use two IF THEN statements.
Hope this helps

Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:44 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: help


Hey scott the actual code I have does work ie, if there is a "Y" then
yes gets populated. However, I want yes to show up in the text box
prior to updating the table right now it No shows up is that because of
alphabetical?
Scott Heath wrote:Dan,
I just copied this code, change the database stuff to basic variables
and tested it and it worked. Try printing the result from the database
such as:


Requisition
Approved:

>No >Yes




Scott

Website | http://www.scottspad.com
E-mail | scott@s...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
There are 10 types of people in the world,
those that can read binary and those that can not.

-----Original Message-----
From: Dan Crandell [mailto:dan_c39@y...] 
Sent: Friday, October 11, 2002 9:16 AM
To: ASP Web HowTo
Subject: [asp_web_howto] help


question this code makes a drop down with No and Yes, No shows up in the
text field by default. I want to make yes show up?




Requisition
Approved:

>No >Yes







---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos, & more
faith.yahoo.com


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20




---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


---------------------------------
Do You Yahoo!?
Yahoo! Health - Feel better, live better


---

Improve your web design skills with these new books from Glasshaus.

Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


Message #9 by "Aaron Fleming" <aaronf@w...> on Fri, 11 Oct 2002 10:29:11 -0400
Here you go...

<tr>
<td WIDTH="20"></td>
<td ALIGN="LEFT" WIDTH="150" VALIGN="TOP" class="rhf">Requisition
Approved:</td>
<td ALIGN="LEFT" WIDTH="490" VALIGN="TOP" class="rf">
<select Name="RequisitionApproved"><%
    Dim YSelected, NSelected
    
    If (objRst("RequisitionApproved") = "Y") Then
     YSelected = "SELECTED"
     NSelected = ""
    Else
     YSelected = ""
     NSelected = "SELECTED"
    End If
   %>
<option value="N" <%=NSelected%>>No</option>
<option value="Y" <%=YSelected%> selected>Yes</option>
</select>
</td>
</tr>





> -----Original Message-----
> From: Dan Crandell [mailto:dan_c39@y...] 
> Sent: Friday, October 11, 2002 10:16 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] help
> 
> 
> 
> question this code makes a drop down with No and Yes, No 
> shows up in the text field by default.  I want to make yes show up?
> 
>  
> 
> <tr><td WIDTH="20"></td>
>  <td ALIGN="LEFT" WIDTH="150" VALIGN="TOP" 
> class="rhf">Requisition Approved:</td>  <td ALIGN="LEFT" 
> WIDTH="490" VALIGN="TOP" class="rf">
>   <Select Name="RequisitionApproved">
>    <%
>     Dim YSelected, NSelected
>     
>     If (objRst("RequisitionApproved") = "Y") Then
>      YSelected = "SELECTED"
>      NSelected = ""
>     Else
>      YSelected = ""
>      NSelected = "SELECTED"
>     End If
>    %>
>    <option value=N <%=NSelected%>>No</option>
>    <option value=Y <%=YSelected%>>Yes</option>
>   </select>
>  </td>
> </tr>
> 
>  
> 
> 
> 
> ---------------------------------
> Do you Yahoo!?
> Faith Hill - Exclusive Performances, Videos, & more faith.yahoo.com
> 
> 
> ---
> 
> Improve your web design skills with these new books from Glasshaus.
> 
> Usable Web Menus 
> http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/th
eprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20


  Return to Index