|
 |
asp_web_howto thread: see code and help please.
Message #1 by nusrat sarwar <nusratsarwar@y...> on Wed, 27 Mar 2002 05:08:58 -0800 (PST)
|
|
Hello all please see the code and help
<p> </p>
<form action="orderinsert.asp" method="post"
name="frm" onsubmit="return isname()">
<table width="616">
<tr>
<td valign="top"
align="left" width="206"><font face="Verdana" size="3"
color="#000080"><b>Vehicle Details</b></font></td>
<td valign="top"
align="left" width="396"><font size="2"
face="Verdana"> </font></td>
</tr>
<tr>
<td valign="top" align="left"
width="206"><font size="2" face="Verdana">Stock Number
(SN)</font></td>
<td valign="top" align="left" width="206"><font
size="2" face="Verdana">
<%
strconn = "DRIVER=Microsoft Access Driver
(*.mdb);DBQ=" & Server.MapPath("/data/car.mdb")
set conn = server.createobject("ADODB.Connection")
set rs = server.createobject("ADODB.Recordset")
conn.open strconn
rs.open "SELECT * from cardetail ;", conn,2,2
%>
<select size="1" name="SNRef"
onChange="MjumpM_Menu('parent',this,1)">
<option value="none" selected>Select St.No.
<% while Not rs.eof %>
<option value="<%=rs("sno")%>"><%=rs("sno")%></option>
<%
rs.MoveNext
wend
%>
</select>
</font>
</td>
<%
rs.close
set rs=nothing
conn.close
set conn = nothing
%>
</tr>
<tr>
<td valign="top"
align="left" width="206"><font size="2"
face="Verdana">Vehicle make and
model</font></td>
<td valign="top"
align="left" width="396"><font size="2"
face="Verdana">
__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
Message #2 by Joe Ingle <Joe@k...> on Wed, 27 Mar 2002 13:23:48 -0000
|
|
What is the problem?? That may be a help!
-----Original Message-----
From: nusrat sarwar [mailto:nusratsarwar@y...]
Sent: Wednesday, March 27, 2002 1:09 PM
To: ASP Web HowTo
Subject: [asp_web_howto] see code and help please.
Hello all please see the code and help
<p> </p>
<form action=3D"orderinsert.asp" method=3D"post"
name=3D"frm" onsubmit=3D"return isname()">
<table width=3D"616">
<tr>
<td valign=3D"top"
align=3D"left" width=3D"206"><font face=3D"Verdana" size=3D"3"
color=3D"#000080"><b>Vehicle Details</b></font></td>
<td valign=3D"top"
align=3D"left" width=3D"396"><font size=3D"2"
face=3D"Verdana"> </font></td>
</tr>
<tr>
<td valign=3D"top" align=3D"left"
width=3D"206"><font size=3D"2" face=3D"Verdana">Stock Number
(SN)</font></td>
<td valign=3D"top"
align=3D"left" width=3D"206"><font
size=3D"2" face=3D"Verdana">
<%
strconn =3D "DRIVER=3DMicrosoft Access Driver
(*.mdb);DBQ=3D" & Server.MapPath("/data/car.mdb")
set conn =3D server.createobject("ADODB.Connection")
set rs =3D server.createobject("ADODB.Recordset")
conn.open strconn
rs.open "SELECT * from cardetail ;", conn,2,2
%>
<select size=3D"1" name=3D"SNRef"
onChange=3D"MjumpM_Menu('parent',this,1)">
<option value=3D"none" selected>Select St.No.
<% while Not rs.eof %> =09
<option value=3D"<%=3Drs("sno")%>"><%=3Drs("sno")%></option>
=09
<%
rs.MoveNext
wend
%>
</select>
</font>
</td>
<%
rs.close
set rs=3Dnothing
conn.close
set conn =3D nothing
%>
</tr>
<tr>
<td valign=3D"top"
align=3D"left" width=3D"206"><font size=3D"2"
face=3D"Verdana">Vehicle make and
model</font></td>
<td valign=3D"top"
align=3D"left" width=3D"396"><font size=3D"2"
face=3D"Verdana">
__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards=AE
http://movies.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=3Dnosim/theprogram
me
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogram
me
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogram
me
r-20
Message #3 by nusrat sarwar <nusratsarwar@y...> on Wed, 27 Mar 2002 06:00:35 -0800 (PST)
|
|
sorry Joe and all
in a hurry I forgot to explain
acctually
I want my select list to show ID's from the DB
but this code is not doing what I want
the select list must have all IDs present in the DB
would any one help???/
many thanks and obliged
take care
regards
nusrat
--- nusrat sarwar <nusratsarwar@y...> wrote:
>
> Hello all please see the code and help
>
> <p> </p>
> <form action="orderinsert.asp" method="post"
> name="frm" onsubmit="return isname()">
> <table width="616">
> <tr>
> <td valign="top"
> align="left" width="206"><font face="Verdana"
> size="3"
> color="#000080"><b>Vehicle Details</b></font></td>
> <td valign="top"
> align="left" width="396"><font size="2"
> face="Verdana"> </font></td>
> </tr>
> <tr>
> <td valign="top"
> align="left"
> width="206"><font size="2" face="Verdana">Stock
> Number
> (SN)</font></td>
> <td valign="top" align="left"
> width="206"><font
> size="2" face="Verdana">
>
> <%
> strconn = "DRIVER=Microsoft Access Driver
> (*.mdb);DBQ=" & Server.MapPath("/data/car.mdb")
> set conn = server.createobject("ADODB.Connection")
> set rs = server.createobject("ADODB.Recordset")
> conn.open strconn
>
> rs.open "SELECT * from cardetail ;", conn,2,2
> %>
> <select size="1" name="SNRef"
> onChange="MjumpM_Menu('parent',this,1)">
> <option value="none" selected>Select St.No.
> <% while Not rs.eof %>
> <option
> value="<%=rs("sno")%>"><%=rs("sno")%></option>
>
>
> <%
> rs.MoveNext
> wend
> %>
> </select>
> </font>
> </td>
> <%
> rs.close
> set rs=nothing
> conn.close
> set conn = nothing
> %>
>
>
> </tr>
>
> <tr>
> <td valign="top"
> align="left" width="206"><font size="2"
> face="Verdana">Vehicle make and
> model</font></td>
> <td valign="top"
> align="left" width="396"><font size="2"
> face="Verdana">
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy Awards®
> http://movies.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
__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
Message #4 by "Drew, Ron" <RDrew@B...> on Wed, 27 Mar 2002 11:59:48 -0500
|
|
Changed the code a little to point at my test mdb and picked on of the
fields in my db...it works fine and showed all..only thing I added
besides the html/head/body was to end the td/tr/table at the end. What
is your's showing...nothing, part of a list or stopping somewhere in
between?
-----Original Message-----
From: nusrat sarwar [mailto:nusratsarwar@y...]
Sent: Wednesday, March 27, 2002 9:01 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: see code and help please.
sorry Joe and all
in a hurry I forgot to explain
acctually
I want my select list to show ID's from the DB
but this code is not doing what I want
the select list must have all IDs present in the DB
would any one help???/
many thanks and obliged
take care
regards
nusrat
--- nusrat sarwar <nusratsarwar@y...> wrote:
>
> Hello all please see the code and help
>
> <p> </p>
> <form action=3D"orderinsert.asp" method=3D"post" name=3D"frm"
> onsubmit=3D"return isname()">
> <table width=3D"616">
> <tr>
> <td valign=3D"top"
> align=3D"left" width=3D"206"><font face=3D"Verdana"
> size=3D"3"
> color=3D"#000080"><b>Vehicle Details</b></font></td>
> <td valign=3D"top"
> align=3D"left" width=3D"396"><font size=3D"2"
> face=3D"Verdana"> </font></td>
> </tr>
> <tr>
> <td valign=3D"top"
> align=3D"left"
> width=3D"206"><font size=3D"2" face=3D"Verdana">Stock
> Number
> (SN)</font></td>
> <td valign=3D"top"
align=3D"left"
> width=3D"206"><font
> size=3D"2" face=3D"Verdana">
>
> <%
> strconn =3D "DRIVER=3DMicrosoft Access Driver
> (*.mdb);DBQ=3D" & Server.MapPath("/data/car.mdb")
> set conn =3D server.createobject("ADODB.Connection")
> set rs =3D server.createobject("ADODB.Recordset")
> conn.open strconn
>
> rs.open "SELECT * from cardetail ;", conn,2,2
> %>
> <select size=3D"1" name=3D"SNRef"
> onChange=3D"MjumpM_Menu('parent',this,1)">
> <option value=3D"none" selected>Select St.No.
> <% while Not rs.eof %> =09
> <option
> value=3D"<%=3Drs("sno")%>"><%=3Drs("sno")%></option>
> =09
>
> <%
> rs.MoveNext
> wend
> %>
> </select>
> </font>
> </td>
> <%
> rs.close
> set rs=3Dnothing
> conn.close
> set conn =3D nothing
> %>
>
>
> </tr>
>
> <tr>
> <td valign=3D"top"
> align=3D"left" width=3D"206"><font size=3D"2" face=3D"Verdana">Vehicle
make
> and
> model</font></td>
> <td valign=3D"top"
> align=3D"left" width=3D"396"><font size=3D"2"
> face=3D"Verdana">
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy Awards(r)
> http://movies.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=3Dnosim/theprogramm
e
> r-20
> Constructing Accessible Web Sites
>
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
> r-20
> Practical JavaScript for the Usable Web
>
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
> r-20
__________________________________________________
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards(r)
http://movies.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=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
Message #5 by nusrat sarwar <nusratsarwar@y...> on Wed, 27 Mar 2002 13:24:46 -0800 (PST)
|
|
Hi Ron
thanx for replying
acctually it is showing only one ID in the list
or all IDs out of select box
if you have successfully done that can you just write
me the code where you have taht select list??
I am truly irritated for being so dum head
I got to solve that problem, kind of badly stuck
many many thanx again for yr help and precious time
take care
regards
nusrat
--- "Drew, Ron" <RDrew@B...> wrote:
> Changed the code a little to point at my test mdb
> and picked on of the
> fields in my db...it works fine and showed all..only
> thing I added
> besides the html/head/body was to end the
> td/tr/table at the end. What
> is your's showing...nothing, part of a list or
> stopping somewhere in
> between?
>
> -----Original Message-----
> From: nusrat sarwar [mailto:nusratsarwar@y...]
> Sent: Wednesday, March 27, 2002 9:01 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] Re: see code and help
> please.
>
>
> sorry Joe and all
> in a hurry I forgot to explain
> acctually
> I want my select list to show ID's from the DB
> but this code is not doing what I want
> the select list must have all IDs present in the DB
> would any one help???/
> many thanks and obliged
> take care
> regards
> nusrat
>
> --- nusrat sarwar <nusratsarwar@y...> wrote:
> >
> > Hello all please see the code and help
> >
> > <p> </p>
> > <form action="orderinsert.asp"
> method="post" name="frm"
> > onsubmit="return isname()">
> > <table width="616">
> > <tr>
> > <td valign="top"
> > align="left" width="206"><font face="Verdana"
> > size="3"
> > color="#000080"><b>Vehicle Details</b></font></td>
> > <td valign="top"
> > align="left" width="396"><font size="2"
> > face="Verdana"> </font></td>
> > </tr>
> > <tr>
> > <td valign="top"
> > align="left"
> > width="206"><font size="2" face="Verdana">Stock
> > Number
> > (SN)</font></td>
> > <td valign="top"
> align="left"
> > width="206"><font
> > size="2" face="Verdana">
> >
> > <%
> > strconn = "DRIVER=Microsoft Access Driver
> > (*.mdb);DBQ=" & Server.MapPath("/data/car.mdb")
> > set conn = server.createobject("ADODB.Connection")
> > set rs = server.createobject("ADODB.Recordset")
> > conn.open strconn
> >
> > rs.open "SELECT * from cardetail ;", conn,2,2
> > %>
> > <select size="1" name="SNRef"
> > onChange="MjumpM_Menu('parent',this,1)">
> > <option value="none" selected>Select St.No.
> > <% while Not rs.eof %>
> > <option
> > value="<%=rs("sno")%>"><%=rs("sno")%></option>
> >
> >
> > <%
> > rs.MoveNext
> > wend
> > %>
> > </select>
> > </font>
> > </td>
> > <%
> > rs.close
> > set rs=nothing
> > conn.close
> > set conn = nothing
> > %>
> >
> >
> > </tr>
> >
> > <tr>
> > <td valign="top"
> > align="left" width="206"><font size="2"
> face="Verdana">Vehicle make
> > and
> > model</font></td>
> > <td valign="top"
> > align="left" width="396"><font size="2"
> > face="Verdana">
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Movies - coverage of the 74th Academy
> Awards(r)
> > http://movies.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
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Movies - coverage of the 74th Academy
> Awards(r)
> http://movies.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! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
|
|
|
View Cart
