Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: Inserting Time and Date into insert sql string


Message #1 by "Jonathan Marshall" <jdmarsh2g@h...> on Wed, 12 Dec 2001 20:18:05 +0000
<html><div style='background-color:'><DIV>Having issues inserting system time and date
into database field&nbsp; named Time inside of insert sql string<BR></DIV></div><br
clear=all><hr>Get your FREE download of MSN Explorer at <a
href='http://go.msn.com/bql/hmtag_etl_EN.asp'>http://explorer.msn.com</a>.<br></html>

Message #2 by "John P. Miller" <jpmiller@a...> on Wed, 12 Dec 2001 15:44:18 -0500
This is a multi-part message in MIME format.



------=_NextPart_000_0032_01C18323.DC7DA3C0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



try renaming your field.



  ----- Original Message -----

  From: Jonathan Marshall

  To: ASP Web HowTo

  Sent: Wednesday, December 12, 2001 3:18 PM

  Subject: [asp_web_howto] Inserting Time and Date into insert sql 

string





  Having issues inserting system time and date into database field  

named Time inside of insert sql string







-------------------------------------------------------------------------

-----

  Get your FREE download of MSN Explorer at http://explorer.msn.com.




$subst('Email.Unsub').






Message #3 by "Ken Schaefer" <ken@a...> on Thu, 13 Dec 2001 12:16:17 +1100
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Jonathan Marshall" <jdmarsh2g@h...>

Subject: [asp_web_howto] Inserting Time and Date into insert sql string





: Having issues inserting system time and date into database field

: named Time inside of insert sql string

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~



>> The error is on line 6

> How do you know? I didn't post any code

Exactly



For all we know:

a) the problem could be that the field is a reserved word

b) you aren't connecting sucessfully to the database at all

c) your page isn't running at all because of some other error

d) your webserver isn't running at all

e) nothing it working because you have no electricity for the server in

question

f) nothing will work because your hosting company has been flattened by a

meteorite

g) ...



www.adopenstatic.com/personal/help.asp



Cheers

Ken




  Return to Index