|
 |
asp_databases thread: date
Message #1 by "crystal" <crystalightening@j...> on Tue, 24 Jul 2001 16:04:26
|
|
Hi!
In my guestbook.htm I have <input type = "hidden" name
= "date_submitted" value = "<% =Date() %>" > to get the date when people
submit their guestbook entry. When I query the database I get this
<% =Date() %> Do you know why and would you please help? Thank you in
advance.
Crystal
Message #2 by "Tomm Matthis" <matthis@b...> on Tue, 24 Jul 2001 11:13:30 -0400
|
|
You have to rename the file to have an .ASP extension... that way it
will parse the file for ASP code.
-- Tomm
> -----Original Message-----
> From: crystal [mailto:crystalightening@j...]
> Sent: Tuesday, July 24, 2001 4:04 PM
> To: ASP Databases
> Subject: [asp_databases] date
>
>
> Hi!
> In my guestbook.htm I have <input type =3D "hidden" name
> =3D "date_submitted" value =3D "<% =3DDate() %>" > to get the date
when people
> submit their guestbook entry. When I query the database I get this
>
> <% =3DDate() %> Do you know why and would you please help? Thank you
in
> advance.
> Crystal
> ---
Message #3 by Ludwig Brandon-FBL017C <Brandon.Ludwig@m...> on Tue, 24 Jul 2001 11:08:33 -0400
|
|
The file's extension is .htm? It needs to be .asp in order to get processed
by the asp.dll - otherwise it won't do anything about the <% %>
(Unless, of course you process all pages via the asp.dll)
Brandon Ludwig
Brandon.Ludwig@M...
-----Original Message-----
From: crystal [mailto:crystalightening@j...]
Sent: Tuesday, July 24, 2001 12:04 PM
To: ASP Databases
Subject: [asp_databases] date
Hi!
In my guestbook.htm I have <input type = "hidden" name
= "date_submitted" value = "<% =Date() %>" > to get the date when people
submit their guestbook entry. When I query the database I get this
<% =Date() %> Do you know why and would you please help? Thank you in
advance.
Crystal
---
Message #4 by "Peter Foti (PeterF)" <PeterF@S...> on Tue, 24 Jul 2001 11:18:29 -0400
|
|
Your file has a .htm extension instead of a .asp extension, so
therefore
is not processed by the ASP engine. If you want ASP tags to be
processed, you need to have an ASP extension.
Rename your file to guestbook.asp and give it a shot. Assuming your
web
server is IIS, this should solve your problem.
Regards,
Peter Foti
> -----Original Message-----
> From: crystal [mailto:crystalightening@j...]
> Sent: Tuesday, July 24, 2001 4:04 PM
> To: ASP Databases
> Subject: [asp_databases] date
>
>
> Hi!
> In my guestbook.htm I have <input type =3D "hidden" name
> =3D "date_submitted" value =3D "<% =3DDate() %>" > to get the date
> when people
> submit their guestbook entry. When I query the database I get this
>
> <% =3DDate() %> Do you know why and would you please help?
> Thank you in
> advance.
> Crystal
Message #5 by "Shaw, Mike" <MShaw@s...> on Tue, 24 Jul 2001 11:18:01 -0400
|
|
Any help for my ADODB.Recordset error of 800a0bb9?
Michael Shaw
Web Programmer
Select Medical Corporation
(xxx) xxx-xxxx
mshaw@s...
-----Original Message-----
From: Peter Foti (PeterF) [mailto:PeterF@S...]
Sent: Tuesday, July 24, 2001 11:18 AM
To: ASP Databases
Cc: 'crystalightening@j...'
Subject: [asp_databases] RE: date
Your file has a .htm extension instead of a .asp extension, so
therefore
is not processed by the ASP engine. If you want ASP tags to be
processed, you need to have an ASP extension.
Rename your file to guestbook.asp and give it a shot. Assuming your
web
server is IIS, this should solve your problem.
Regards,
Peter Foti
> -----Original Message-----
> From: crystal [mailto:crystalightening@j...]
> Sent: Tuesday, July 24, 2001 4:04 PM
> To: ASP Databases
> Subject: [asp_databases] date
>
>
> Hi!
> In my guestbook.htm I have <input type =3D "hidden" name
> =3D "date_submitted" value =3D "<% =3DDate() %>" > to get the date
> when people
> submit their guestbook entry. When I query the database I get this
>
> <% =3DDate() %> Do you know why and would you please help?
> Thank you in
> advance.
> Crystal
Message #6 by "Peter Foti (PeterF)" <PeterF@S...> on Tue, 24 Jul 2001 11:43:44 -0400
|
|
Unfortunately, I don't own the book you referenced, so I don't know
what
it is that you are trying to do. Could you post the code?
Thanks,
Peter
> -----Original Message-----
> From: Shaw, Mike [mailto:MShaw@s...]
> Sent: Tuesday, July 24, 2001 11:18 AM
> To: ASP Databases
> Subject: [asp_databases] RE: date
>
>
> Any help for my ADODB.Recordset error of 800a0bb9?
>
> Michael Shaw
> Web Programmer
> Select Medical Corporation
> (xxx) xxx-xxxx
> mshaw@s...
>
>
> -----Original Message-----
> From: Peter Foti (PeterF) [mailto:PeterF@S...]
> Sent: Tuesday, July 24, 2001 11:18 AM
> To: ASP Databases
> Cc: 'crystalightening@j...'
> Subject: [asp_databases] RE: date
>
>
> Your file has a .htm extension instead of a .asp extension,
> so therefore
> is not processed by the ASP engine. If you want ASP tags to be
> processed, you need to have an ASP extension.
>
> Rename your file to guestbook.asp and give it a shot.
> Assuming your web
> server is IIS, this should solve your problem.
>
> Regards,
> Peter Foti
>
>
>
> > -----Original Message-----
> > From: crystal [mailto:crystalightening@j...]
> > Sent: Tuesday, July 24, 2001 4:04 PM
> > To: ASP Databases
> > Subject: [asp_databases] date
> >
> >
> > Hi!
> > In my guestbook.htm I have <input type =3D "hidden" name
> > =3D "date_submitted" value =3D "<% =3DDate() %>" > to get the date
> > when people
> > submit their guestbook entry. When I query the database I get this
> >
> > <% =3DDate() %> Do you know why and would you please help?
> > Thank you in
> > advance.
> > Crystal
>
Message #7 by crystal k davis <crystalightening@j...> on Tue, 24 Jul 2001 13:48:05 -0400
|
|
duh!!!!! What an oversite. Thank you
On Tue, 24 Jul 2001 11:08:33 -0400 Ludwig Brandon-FBL017C
<Brandon.Ludwig@m...> writes:
> The file's extension is .htm? It needs to be .asp in order to get
> processed
> by the asp.dll - otherwise it won't do anything about the <% %>
> (Unless, of course you process all pages via the asp.dll)
>
> Brandon Ludwig
> Brandon.Ludwig@M...
>
>
> -----Original Message-----
> From: crystal [mailto:crystalightening@j...]
> Sent: Tuesday, July 24, 2001 12:04 PM
> To: ASP Databases
> Subject: [asp_databases] date
>
> Hi!
> In my guestbook.htm I have <input type = "hidden" name
> = "date_submitted" value = "<% =Date() %>" > to get the date when
> people
> submit their guestbook entry. When I query the database I get this
>
> <% =Date() %> Do you know why and would you please help? Thank you
> in
> advance.
> Crystal
>
Message #8 by "Drew, Ron" <RDrew@B...> on Thu, 26 Jul 2001 08:11:07 -0400
|
|
I dont use a hidden field, I pass the html form the guest inputs to an
asp
(can be done in one asp) without a date...do the request.form for all
other
fields and to add the date input I do the following:
Dim dtInput
dtInput =3D date
....do your connection to the database...then setup the insert for the
guestbook....
strSQL =3D "INSERT INTO Guestbook (Name, Email, City, St, Country,
URL,
HowFind, Message, DateInput)" &_
" VALUES (?,?,?,?,?,?,?,?,?)"
objCommand.CommandText =3D strSQL
objCommand.Parameters.Append objCommand.CreateParameter("Name",200,
,30)
objCommand.Parameters.Append objCommand.CreateParameter("Email",200,
,40)
objCommand.Parameters.Append objCommand.CreateParameter("City",200,
,20)
objCommand.Parameters.Append objCommand.CreateParameter("St",200,
,2)
objCommand.Parameters.Append
objCommand.CreateParameter("Country",200,
,20)
objCommand.Parameters.Append objCommand.CreateParameter("URL",200,
,40)
objCommand.Parameters.Append
objCommand.CreateParameter("HowFind",200,
,45)
objCommand.Parameters.Append
objCommand.CreateParameter("Message",200,
,180)
objCommand.Parameters.Append
objCommand.CreateParameter("DateInput",134,
,10)
objCommand("Name") =3D sName
objCommand("Email") =3D sEmail
objCommand("City") =3D sCity
objCommand("St") =3D sSt
objCommand("Country") =3D sUSA
objCommand("URL") =3D sURL
objCommand("HowFind") =3D sHow
objCommand("Message") =3D sMessage
objCommand("DateInput") =3D dtInput
objCommand.Execute
Ron
-----Original Message-----
From: crystal [mailto:crystalightening@j...]
Sent: Tuesday, July 24, 2001 12:04 PM
To: ASP Databases
Subject: [asp_databases] date
Hi!
In my guestbook.htm I have <input type =3D "hidden" name
=3D "date_submitted" value =3D "<% =3DDate() %>" > to get the date when
people
submit their guestbook entry. When I query the database I get this
<% =3DDate() %> Do you know why and would you please help? Thank you
in
advance.
Crystal
|
|
|
View Cart
