adDBTimeStamp Check my site for a list of the datatypes and examples of code:
http://www.davidpenton.com/testsite/scratch/adodb.command3.asp and scratch root for more stuff... http://www.davidpenton.com/testsite/scratch/ David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Chris Tifer [mailto:[EMAIL PROTECTED]] Are you calling a stored procedure? Do you mean you don't know what type of parameter you should define it as? I always use adDate If that's not what you're talking about, you might need to explain a little further. Chris Tifer http://www.emailajoke.com ----- Original Message ----- From: "Dylan Barber" <[EMAIL PROTECTED]> I have a news script that inserts a news item into a database (MS SQL server 2000) the table has a release date field that I want to check against the current date. Sounds simple right. However I can not figure out how to submit a datetime to the Database so Right now I can't check the date can anybody help me? __________________________________________________ Dylan Barber (CIW Professional, A+ Technician) Programmer/Analyst DPRA Inc. phone (785) 539-3565 ext.1034 e-mail [EMAIL PROTECTED] --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
