|
 |
asp_web_howto thread: RE: see code and help please.
Message #1 by "Drew, Ron" <RDrew@B...> on Mon, 8 Apr 2002 08:24:37 -0400
|
|
What was the problem...I tested this against a DB I have and it worked
fine.
-----Original Message-----
From: Joe Ingle [mailto:Joe@k...]
Sent: Wednesday, March 27, 2002 8:24 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: see code and help please.
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(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
---
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 #2 by nusrat sarwar <nusratsarwar@y...> on Mon, 8 Apr 2002 10:51:30 -0700 (PDT)
|
|
Hi Ron
many thanx
the problem has been solved
and its working fine
God bless you for yr concern
take good care
regards
nusrat
--- "Drew, Ron" <RDrew@B...> wrote:
> What was the problem...I tested this against a DB I
> have and it worked
> fine.
>
> -----Original Message-----
> From: Joe Ingle [mailto:Joe@k...]
> Sent: Wednesday, March 27, 2002 8:24 AM
> To: ASP Web HowTo
> Subject: [asp_web_howto] RE: see code and help
> please.
>
>
> 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="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
>
>
> ---
>
> 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! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
|
|
|
View Cart
