|
 |
access_asp thread: please help!!!
Message #1 by "Tushar kale" <kale_tushar@v...> on Thu, 29 Aug 2002 07:51:06
|
|
I have register form in which i am using a drop down menu for DOB etc..
If user wants to register his info so whenever user click on UPDATE YOUR
DEATILS button i want his details (which he has given during the
registration) to display in register page. I am able to retrive his
deatils in text box,textarea but not in drop down menu and listbox.
So anyone can tell me how to do that?
Message #2 by "aboamama atahar ahmed" <khrtoto@h...> on Thu, 29 Aug 2002 08:10:32
|
|
hi
can u show me your code so i can tell you what to do for this
Abo
Message #3 by "Tushar kale" <kale_tushar@v...> on Thu, 29 Aug 2002 09:31:59
|
|
> hi
> can u show me your code so i can tell you what to do for this
> Abo
Here is my code.
updateform.asp
<%
'Dimension variables
Dim adoCon 'Holds the Database Connection Object
Dim rsGuestbook 'Holds the recordset for the record to be
updated
Dim strSQL 'Holds the SQL query for the database
Dim lngRecordNo 'Holds the record number to be updated
'Read in the record number to be updated
lngRecordNo = CLng(Request.QueryString("ID"))
'Create an ADO connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")
'Set an active connection to the Connection object using a DSN-less
connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("point.mdb")
'Set an active connection to the Connection object using DSN connection
'adoCon.Open "DSN=guestbook"
'Create an ADO recordset object
Set rsGuestbook = Server.CreateObject("ADODB.Recordset")
'Initialise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT tblComments.* FROM tblComments WHERE ID_no=" & lngRecordNo
'Open the recordset with the SQL query
rsGuestbook.Open strSQL, adoCon
%>
<html>
<head>
<title>Guestbook Update Form</title>
</head>
<body bgcolor="white" text="black">
<!-- Begin form code -->
<form name="form" method="post" action="update_entry.asp">
<P><STRONG><FONT face=Tahoma size=2>Event
Name  
;
: <INPUT id=text1
name=eventname value="<% = rsGuestbook("eventname") %
>"></FONT></STRONG></P>
<P><STRONG><FONT face=Tahoma
size=2>Date &nbs
p; &
nbsp;
: <SELECT id=select4 name=dat value="<% = rsGuestbook
("date") %>"> <OPTION value=1
>1</OPTION><OPTION value=2>2</OPTION><OPTION value=3>3</OPTION><OPTION
value=4>4</OPTION><OPTION value=5>5</OPTION><OPTION
value=6>6</OPTION><OPTION
value=7>7</OPTION><OPTION value=8>8</OPTION><OPTION
value=9>9</OPTION><OPTION
value=10>10</OPTION><OPTION value=11>11</OPTION><OPTION
value=12>12</OPTION><OPTION value=13>13</OPTION><OPTION
value=14>14</OPTION><OPTION value=15>15</OPTION><OPTION
value=16>16</OPTION><OPTION value=17>17</OPTION><OPTION
value=18>18</OPTION><OPTION value=19>19</OPTION><OPTION
value=20>20</OPTION><OPTION value=21>21</OPTION><OPTION
value=22>22</OPTION><OPTION value=23>23</OPTION><OPTION
value=24>24</OPTION><OPTION value=25>25</OPTION><OPTION
value=26>26</OPTION><OPTION value=27>27</OPTION><OPTION
value=28>28</OPTION><OPTION value=29>29</OPTION><OPTION
value=30>30</OPTION><OPTION value=31>31</OPTION></SELECT> /
<SELECT id=select1 style="WIDTH: 66px" name=month value="<%=rsGuestbook
("month")%>">
<OPTION value=Jan>Jan</OPTION>
<OPTION value=Feb>Feb</OPTION>
<OPTION value=Mar>Mar</OPTION>
<OPTION value=Apr>Apr</OPTION>
<OPTION value=May>May</OPTION>
<OPTION value=Jun>Jun</OPTION>
<OPTION value=Jul>Jul</OPTION>
<OPTION value=Aug>Aug</OPTION>
<OPTION value=Sep>Sep</OPTION>
<OPTION value=Oct>Oct</OPTION>
<OPTION value=Nov>Nov</OPTION>
<OPTION value=Dec>Dec</OPTION>
</SELECT> </FONT></STRONG>/ <SELECT id=select2
name=year value="<% = rsGuestbook("year") %>"> <OPTION value=2002
selected>2002</OPTION><OPTION
value=2003>2003</OPTION><OPTION value=2004>2004</OPTION></SELECT></P>
<P><STRONG><FONT face=Tahoma size=2>Starting
Time  
;
: <INPUT id=text2 name=time value="<% = rsGuestbook("time") %
>"></FONT></STRONG></P>
<P><STRONG><FONT face=Tahoma size=2>Event
Description :
</FONT></STRONG></P>
<P><TEXTAREA id=TEXTAREA1 style="WIDTH: 415px; HEIGHT: 109px"
name=description rows=5 cols=44><% = rsGuestbook("description") %
></TEXTAREA> </P>
<P><STRONG><FONT face=Tahoma size=2>Event
Head/s &nb
sp;
: <SELECT id=select3 style="WIDTH: 253px; HEIGHT: 55px" multiple
size=4
name=heads value="<% = rsGuestbook("heads") %>"> <OPTION value=LK>Lubaina
Kitabi</OPTION><OPTION value=SL>Suyog
Lakeshri</OPTION><OPTION value=SJ>Sarita Japtiwale</OPTION><OPTION
value=TM>Tarun Makhija</OPTION><OPTION
value=""></OPTION></SELECT></FONT></STRONG></P>
<P> </P>
<P><FONT face=Tahoma size=2><STRONG><INPUT id=submit1 style="LEFT: 11px;
TOP: 342px" type=submit value="Submit Query"
name=Action></STRONG></FONT></P>
<input type="hidden" name="ID_no" value="<% = rsGuestbook("ID_no") %>">
<input type="submit" name="Submit" value="Submit">
</form>
<!-- End form code -->
</body>
</html>
<%
'Reset server objects
rsGuestbook.Close
Set rsGuestbook = Nothing
Set adoCon = Nothing
%>
Message #4 by "Carl E. Olsen" <carl-olsen@m...> on Thu, 29 Aug 2002 06:41:30 -0500
|
|
I can see right now that you don't have your string values in double
quotes. Try that first.
Carl Olsen, MCSE
Des Moines, Iowa
http://carl-olsen.com/
> -----Original Message-----
> From: Tushar kale [mailto:kale_tushar@v...]
> Sent: Thursday, August 29, 2002 9:32 AM
> To: Access ASP
> Subject: [access_asp] Re: please help!!!
>
> > hi
>
> > can u show me your code so i can tell you what to do for this
>
> > Abo
>
> Here is my code.
>
> updateform.asp
>
> <%
> 'Dimension variables
> Dim adoCon 'Holds the Database Connection Object
> Dim rsGuestbook 'Holds the recordset for the
record to be
> updated
> Dim strSQL 'Holds the SQL query for the database
> Dim lngRecordNo 'Holds the record number to be
updated
>
> 'Read in the record number to be updated
> lngRecordNo = CLng(Request.QueryString("ID"))
>
> 'Create an ADO connection odject
> Set adoCon = Server.CreateObject("ADODB.Connection")
>
> 'Set an active connection to the Connection object using a DSN-less
> connection
> adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> Server.MapPath("point.mdb")
>
> 'Set an active connection to the Connection object using DSN
connection
> 'adoCon.Open "DSN=guestbook"
>
> 'Create an ADO recordset object
> Set rsGuestbook = Server.CreateObject("ADODB.Recordset")
>
> 'Initialise the strSQL variable with an SQL statement to query the
> database
> strSQL = "SELECT tblComments.* FROM tblComments WHERE ID_no=" &
> lngRecordNo
>
> 'Open the recordset with the SQL query
> rsGuestbook.Open strSQL, adoCon
> %>
> <html>
> <head>
> <title>Guestbook Update Form</title>
> </head>
> <body bgcolor="white" text="black">
> <!-- Begin form code -->
> <form name="form" method="post" action="update_entry.asp">
> <P><STRONG><FONT face=Tahoma size=2>Event
>
Name &n
bs
> p
> ;
> : <INPUT id=text1
> name=eventname value="<% = rsGuestbook("eventname") %
> >"></FONT></STRONG></P>
> <P><STRONG><FONT face=Tahoma
>
size=2>Date &
nb
> s
>
p; &nbs
p;
> &
> nbsp;
> : <SELECT id=select4 name=dat value="<%
rsGuestbook
> ("date") %>"> <OPTION value=1
> >1</OPTION><OPTION value=2>2</OPTION><OPTION
value=3>3</OPTION><OPTION
> value=4>4</OPTION><OPTION value=5>5</OPTION><OPTION
> value=6>6</OPTION><OPTION
> value=7>7</OPTION><OPTION value=8>8</OPTION><OPTION
> value=9>9</OPTION><OPTION
> value=10>10</OPTION><OPTION value=11>11</OPTION><OPTION
> value=12>12</OPTION><OPTION value=13>13</OPTION><OPTION
> value=14>14</OPTION><OPTION value=15>15</OPTION><OPTION
> value=16>16</OPTION><OPTION value=17>17</OPTION><OPTION
> value=18>18</OPTION><OPTION value=19>19</OPTION><OPTION
> value=20>20</OPTION><OPTION value=21>21</OPTION><OPTION
> value=22>22</OPTION><OPTION value=23>23</OPTION><OPTION
> value=24>24</OPTION><OPTION value=25>25</OPTION><OPTION
> value=26>26</OPTION><OPTION value=27>27</OPTION><OPTION
> value=28>28</OPTION><OPTION value=29>29</OPTION><OPTION
> value=30>30</OPTION><OPTION
value=31>31</OPTION></SELECT> /
> <SELECT id=select1 style="WIDTH: 66px" name=month
value="<%=rsGuestbook
> ("month")%>">
> <OPTION value=Jan>Jan</OPTION>
> <OPTION value=Feb>Feb</OPTION>
> <OPTION value=Mar>Mar</OPTION>
> <OPTION value=Apr>Apr</OPTION>
> <OPTION value=May>May</OPTION>
> <OPTION value=Jun>Jun</OPTION>
> <OPTION value=Jul>Jul</OPTION>
> <OPTION value=Aug>Aug</OPTION>
> <OPTION value=Sep>Sep</OPTION>
> <OPTION value=Oct>Oct</OPTION>
> <OPTION value=Nov>Nov</OPTION>
> <OPTION value=Dec>Dec</OPTION>
> </SELECT> </FONT></STRONG>/ <SELECT id=select2
> name=year value="<% = rsGuestbook("year") %>"> <OPTION value=2002
> selected>2002</OPTION><OPTION
> value=2003>2003</OPTION><OPTION
value=2004>2004</OPTION></SELECT></P>
> <P><STRONG><FONT face=Tahoma size=2>Starting
>
Time &n
bs
> p
> ;
> : <INPUT id=text2 name=time value="<%
rsGuestbook("time") %
> >"></FONT></STRONG></P>
> <P><STRONG><FONT face=Tahoma size=2>Event
> Description :
> </FONT></STRONG></P>
> <P><TEXTAREA id=TEXTAREA1 style="WIDTH: 415px; HEIGHT: 109px"
> name=description rows=5 cols=44><% = rsGuestbook("description") %
> ></TEXTAREA> </P>
> <P><STRONG><FONT face=Tahoma size=2>Event
>
Head/s
&n
> b
> sp;
> : <SELECT id=select3 style="WIDTH: 253px; HEIGHT: 55px" multiple
> size=4
> name=heads value="<% = rsGuestbook("heads") %>"> <OPTION
value=LK>Lubaina
> Kitabi</OPTION><OPTION value=SL>Suyog
> Lakeshri</OPTION><OPTION value=SJ>Sarita Japtiwale</OPTION><OPTION
> value=TM>Tarun Makhija</OPTION><OPTION
> value=""></OPTION></SELECT></FONT></STRONG></P>
> <P> </P>
> <P><FONT face=Tahoma size=2><STRONG><INPUT id=submit1 style="LEFT:
11px;
> TOP: 342px" type=submit value="Submit Query"
> name=Action></STRONG></FONT></P>
> <input type="hidden" name="ID_no" value="<% = rsGuestbook("ID_no")
%>">
> <input type="submit" name="Submit" value="Submit">
> </form>
> <!-- End form code -->
> </body>
> </html>
> <%
> 'Reset server objects
> rsGuestbook.Close
> Set rsGuestbook = Nothing
> Set adoCon = Nothing
> %>
> to unsubscribe send a blank email to leave-access_asp-
> 1112135Q@p...
Message #5 by "Carl E. Olsen" <carl-olsen@m...> on Thu, 29 Aug 2002 06:46:29 -0500
|
|
I'm thinking double quotes might have something to do with it, but maybe
not. VBScript is sensitive to this, but I'm not sure it matters with
HTML.
<SELECT id=select1 style="WIDTH: 66px" name=month value="<%=rsGuestbook
("month")%>">
<OPTION value="Jan">Jan</OPTION>
<OPTION value="Feb">Feb</OPTION>
<OPTION value="Mar">Mar</OPTION>
<OPTION value="Apr">Apr</OPTION>
<OPTION value="May">May</OPTION>
<OPTION value="Jun">Jun</OPTION>
<OPTION value="Jul">Jul</OPTION>
<OPTION value="Aug">Aug</OPTION>
<OPTION value="Sep">Sep</OPTION>
<OPTION value="Oct">Oct</OPTION>
<OPTION value="Nov">Nov</OPTION>
<OPTION value="Dec">Dec</OPTION>
</SELECT>
Carl
rsGuestbook("month") should return whichever value has been selected.
> -----Original Message-----
> From: Tushar kale [mailto:kale_tushar@v...]
> Sent: Thursday, August 29, 2002 9:32 AM
> To: Access ASP
> Subject: [access_asp] Re: please help!!!
>
> > hi
>
> > can u show me your code so i can tell you what to do for this
>
> > Abo
>
> Here is my code.
>
> updateform.asp
>
> <%
> 'Dimension variables
> Dim adoCon 'Holds the Database Connection Object
> Dim rsGuestbook 'Holds the recordset for the
record to be
> updated
> Dim strSQL 'Holds the SQL query for the database
> Dim lngRecordNo 'Holds the record number to be
updated
>
> 'Read in the record number to be updated
> lngRecordNo = CLng(Request.QueryString("ID"))
>
> 'Create an ADO connection odject
> Set adoCon = Server.CreateObject("ADODB.Connection")
>
> 'Set an active connection to the Connection object using a DSN-less
> connection
> adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> Server.MapPath("point.mdb")
>
> 'Set an active connection to the Connection object using DSN
connection
> 'adoCon.Open "DSN=guestbook"
>
> 'Create an ADO recordset object
> Set rsGuestbook = Server.CreateObject("ADODB.Recordset")
>
> 'Initialise the strSQL variable with an SQL statement to query the
> database
> strSQL = "SELECT tblComments.* FROM tblComments WHERE ID_no=" &
> lngRecordNo
>
> 'Open the recordset with the SQL query
> rsGuestbook.Open strSQL, adoCon
> %>
> <html>
> <head>
> <title>Guestbook Update Form</title>
> </head>
> <body bgcolor="white" text="black">
> <!-- Begin form code -->
> <form name="form" method="post" action="update_entry.asp">
> <P><STRONG><FONT face=Tahoma size=2>Event
>
Name &n
bs
> p
> ;
> : <INPUT id=text1
> name=eventname value="<% = rsGuestbook("eventname") %
> >"></FONT></STRONG></P>
> <P><STRONG><FONT face=Tahoma
>
size=2>Date &
nb
> s
>
p; &nbs
p;
> &
> nbsp;
> : <SELECT id=select4 name=dat value="<%
rsGuestbook
> ("date") %>"> <OPTION value=1
> >1</OPTION><OPTION value=2>2</OPTION><OPTION
value=3>3</OPTION><OPTION
> value=4>4</OPTION><OPTION value=5>5</OPTION><OPTION
> value=6>6</OPTION><OPTION
> value=7>7</OPTION><OPTION value=8>8</OPTION><OPTION
> value=9>9</OPTION><OPTION
> value=10>10</OPTION><OPTION value=11>11</OPTION><OPTION
> value=12>12</OPTION><OPTION value=13>13</OPTION><OPTION
> value=14>14</OPTION><OPTION value=15>15</OPTION><OPTION
> value=16>16</OPTION><OPTION value=17>17</OPTION><OPTION
> value=18>18</OPTION><OPTION value=19>19</OPTION><OPTION
> value=20>20</OPTION><OPTION value=21>21</OPTION><OPTION
> value=22>22</OPTION><OPTION value=23>23</OPTION><OPTION
> value=24>24</OPTION><OPTION value=25>25</OPTION><OPTION
> value=26>26</OPTION><OPTION value=27>27</OPTION><OPTION
> value=28>28</OPTION><OPTION value=29>29</OPTION><OPTION
> value=30>30</OPTION><OPTION
value=31>31</OPTION></SELECT> /
> <SELECT id=select1 style="WIDTH: 66px" name=month
value="<%=rsGuestbook
> ("month")%>">
> <OPTION value=Jan>Jan</OPTION>
> <OPTION value=Feb>Feb</OPTION>
> <OPTION value=Mar>Mar</OPTION>
> <OPTION value=Apr>Apr</OPTION>
> <OPTION value=May>May</OPTION>
> <OPTION value=Jun>Jun</OPTION>
> <OPTION value=Jul>Jul</OPTION>
> <OPTION value=Aug>Aug</OPTION>
> <OPTION value=Sep>Sep</OPTION>
> <OPTION value=Oct>Oct</OPTION>
> <OPTION value=Nov>Nov</OPTION>
> <OPTION value=Dec>Dec</OPTION>
> </SELECT> </FONT></STRONG>/ <SELECT id=select2
> name=year value="<% = rsGuestbook("year") %>"> <OPTION value=2002
> selected>2002</OPTION><OPTION
> value=2003>2003</OPTION><OPTION
value=2004>2004</OPTION></SELECT></P>
> <P><STRONG><FONT face=Tahoma size=2>Starting
>
Time &n
bs
> p
> ;
> : <INPUT id=text2 name=time value="<%
rsGuestbook("time") %
> >"></FONT></STRONG></P>
> <P><STRONG><FONT face=Tahoma size=2>Event
> Description :
> </FONT></STRONG></P>
> <P><TEXTAREA id=TEXTAREA1 style="WIDTH: 415px; HEIGHT: 109px"
> name=description rows=5 cols=44><% = rsGuestbook("description") %
> ></TEXTAREA> </P>
> <P><STRONG><FONT face=Tahoma size=2>Event
>
Head/s
&n
> b
> sp;
> : <SELECT id=select3 style="WIDTH: 253px; HEIGHT: 55px" multiple
> size=4
> name=heads value="<% = rsGuestbook("heads") %>"> <OPTION
value=LK>Lubaina
> Kitabi</OPTION><OPTION value=SL>Suyog
> Lakeshri</OPTION><OPTION value=SJ>Sarita Japtiwale</OPTION><OPTION
> value=TM>Tarun Makhija</OPTION><OPTION
> value=""></OPTION></SELECT></FONT></STRONG></P>
> <P> </P>
> <P><FONT face=Tahoma size=2><STRONG><INPUT id=submit1 style="LEFT:
11px;
> TOP: 342px" type=submit value="Submit Query"
> name=Action></STRONG></FONT></P>
> <input type="hidden" name="ID_no" value="<% = rsGuestbook("ID_no")
%>">
> <input type="submit" name="Submit" value="Submit">
> </form>
> <!-- End form code -->
> </body>
> </html>
> <%
> 'Reset server objects
> rsGuestbook.Close
> Set rsGuestbook = Nothing
> Set adoCon = Nothing
> %>
> to unsubscribe send a blank email to leave-access_asp-
> 1112135Q@p...
Message #6 by "Carl E. Olsen" <carl-olsen@m...> on Thu, 29 Aug 2002 07:34:52 -0500
|
|
I'm thinking double quotes might have something to do with it, but maybe
not. VBScript is sensitive to this, but I'm not sure it matters with
HTML.
<HTML>
<HEAD>
</HEAD>
<BODY>
<FORM id="Form1" name="Form1" method="post" action="someresponse.asp">
<SELECT id="month" style="WIDTH: 66px" name="month" value="<%
Request.Form("month") %>"
<OPTION value="Jan">Jan</OPTION>
<OPTION value="Feb">Feb</OPTION>
<OPTION value="Mar">Mar</OPTION>
<OPTION value="Apr">Apr</OPTION>
<OPTION value="May">May</OPTION>
<OPTION value="Jun">Jun</OPTION>
<OPTION value="Jul">Jul</OPTION>
<OPTION value="Aug">Aug</OPTION>
<OPTION value="Sep">Sep</OPTION>
<OPTION value="Oct">Oct</OPTION>
<OPTION value="Nov">Nov</OPTION>
<OPTION value="Dec">Dec</OPTION>
</SELECT>
<INPUT TYPE="submit" id="submit" name="submit" value="Submit">
</FORM>
</BODY>
</HTML>
Carl
Request.Form("month") should return whichever value has been selected.
If you want rsGuestbook = Request.Form("month") it should work.
Carl Olsen, MCSE
Des Moines, Iowa
http://carl-olsen.com/
> -----Original Message-----
> From: Tushar kale [mailto:kale_tushar@v...]
> Sent: Thursday, August 29, 2002 9:32 AM
> To: Access ASP
> Subject: [access_asp] Re: please help!!!
>
> > hi
>
> > can u show me your code so i can tell you what to do for this
>
> > Abo
>
> Here is my code.
>
> updateform.asp
>
> <%
> 'Dimension variables
> Dim adoCon 'Holds the Database Connection Object
> Dim rsGuestbook 'Holds the recordset for the
record to be
> updated
> Dim strSQL 'Holds the SQL query for the database
> Dim lngRecordNo 'Holds the record number to be
updated
>
> 'Read in the record number to be updated
> lngRecordNo = CLng(Request.QueryString("ID"))
>
> 'Create an ADO connection odject
> Set adoCon = Server.CreateObject("ADODB.Connection")
>
> 'Set an active connection to the Connection object using a DSN-less
> connection
> adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> Server.MapPath("point.mdb")
>
> 'Set an active connection to the Connection object using DSN
connection
> 'adoCon.Open "DSN=guestbook"
>
> 'Create an ADO recordset object
> Set rsGuestbook = Server.CreateObject("ADODB.Recordset")
>
> 'Initialise the strSQL variable with an SQL statement to query the
> database
> strSQL = "SELECT tblComments.* FROM tblComments WHERE ID_no=" &
> lngRecordNo
>
> 'Open the recordset with the SQL query
> rsGuestbook.Open strSQL, adoCon
> %>
> <html>
> <head>
> <title>Guestbook Update Form</title>
> </head>
> <body bgcolor="white" text="black">
> <!-- Begin form code -->
> <form name="form" method="post" action="update_entry.asp">
> <P><STRONG><FONT face=Tahoma size=2>Event
>
Name &n
bs
> p
> ;
> : <INPUT id=text1
> name=eventname value="<% = rsGuestbook("eventname") %
> >"></FONT></STRONG></P>
> <P><STRONG><FONT face=Tahoma
>
size=2>Date &
nb
> s
>
p; &nbs
p;
> &
> nbsp;
> : <SELECT id=select4 name=dat value="<%
rsGuestbook
> ("date") %>"> <OPTION value=1
> >1</OPTION><OPTION value=2>2</OPTION><OPTION
value=3>3</OPTION><OPTION
> value=4>4</OPTION><OPTION value=5>5</OPTION><OPTION
> value=6>6</OPTION><OPTION
> value=7>7</OPTION><OPTION value=8>8</OPTION><OPTION
> value=9>9</OPTION><OPTION
> value=10>10</OPTION><OPTION value=11>11</OPTION><OPTION
> value=12>12</OPTION><OPTION value=13>13</OPTION><OPTION
> value=14>14</OPTION><OPTION value=15>15</OPTION><OPTION
> value=16>16</OPTION><OPTION value=17>17</OPTION><OPTION
> value=18>18</OPTION><OPTION value=19>19</OPTION><OPTION
> value=20>20</OPTION><OPTION value=21>21</OPTION><OPTION
> value=22>22</OPTION><OPTION value=23>23</OPTION><OPTION
> value=24>24</OPTION><OPTION value=25>25</OPTION><OPTION
> value=26>26</OPTION><OPTION value=27>27</OPTION><OPTION
> value=28>28</OPTION><OPTION value=29>29</OPTION><OPTION
> value=30>30</OPTION><OPTION
value=31>31</OPTION></SELECT> /
> <SELECT id=select1 style="WIDTH: 66px" name=month
value="<%=rsGuestbook
> ("month")%>">
> <OPTION value=Jan>Jan</OPTION>
> <OPTION value=Feb>Feb</OPTION>
> <OPTION value=Mar>Mar</OPTION>
> <OPTION value=Apr>Apr</OPTION>
> <OPTION value=May>May</OPTION>
> <OPTION value=Jun>Jun</OPTION>
> <OPTION value=Jul>Jul</OPTION>
> <OPTION value=Aug>Aug</OPTION>
> <OPTION value=Sep>Sep</OPTION>
> <OPTION value=Oct>Oct</OPTION>
> <OPTION value=Nov>Nov</OPTION>
> <OPTION value=Dec>Dec</OPTION>
> </SELECT> </FONT></STRONG>/ <SELECT id=select2
> name=year value="<% = rsGuestbook("year") %>"> <OPTION value=2002
> selected>2002</OPTION><OPTION
> value=2003>2003</OPTION><OPTION
value=2004>2004</OPTION></SELECT></P>
> <P><STRONG><FONT face=Tahoma size=2>Starting
>
Time &n
bs
> p
> ;
> : <INPUT id=text2 name=time value="<%
rsGuestbook("time") %
> >"></FONT></STRONG></P>
> <P><STRONG><FONT face=Tahoma size=2>Event
> Description :
> </FONT></STRONG></P>
> <P><TEXTAREA id=TEXTAREA1 style="WIDTH: 415px; HEIGHT: 109px"
> name=description rows=5 cols=44><% = rsGuestbook("description") %
> ></TEXTAREA> </P>
> <P><STRONG><FONT face=Tahoma size=2>Event
>
Head/s
&n
> b
> sp;
> : <SELECT id=select3 style="WIDTH: 253px; HEIGHT: 55px" multiple
> size=4
> name=heads value="<% = rsGuestbook("heads") %>"> <OPTION
value=LK>Lubaina
> Kitabi</OPTION><OPTION value=SL>Suyog
> Lakeshri</OPTION><OPTION value=SJ>Sarita Japtiwale</OPTION><OPTION
> value=TM>Tarun Makhija</OPTION><OPTION
> value=""></OPTION></SELECT></FONT></STRONG></P>
> <P> </P>
> <P><FONT face=Tahoma size=2><STRONG><INPUT id=submit1 style="LEFT:
11px;
> TOP: 342px" type=submit value="Submit Query"
> name=Action></STRONG></FONT></P>
> <input type="hidden" name="ID_no" value="<% = rsGuestbook("ID_no")
%>">
> <input type="submit" name="Submit" value="Submit">
> </form>
> <!-- End form code -->
> </body>
> </html>
> <%
> 'Reset server objects
> rsGuestbook.Close
> Set rsGuestbook = Nothing
> Set adoCon = Nothing
> %>
> to unsubscribe send a blank email to leave-access_asp-
> 1112135Q@p...
|
|
|
View Cart
