Thanks for all the replies It runs now without any errors but nothing is being return and I know that there are records that are after the date I am entering.
-----Original Message----- From: Mike Townend [mailto:mike@;cfnews.co.uk] Sent: Thursday, November 07, 2002 11:12 AM To: CF-Talk Subject: RE: Stored proc help Ive found better results using CF_SQL_TIMESTAMP in conjunction with createodbcdate and createodbcdatetime HTH -----Original Message----- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:Rodney.Bruce@;HQISEC.ARMY.MIL] Sent: Thursday, November 7, 2002 17:23 To: CF-Talk Subject: RE: Stored proc help I added the CreateODBCDateTime() but there is no option for SQLDATESTAMP for type, only CF_SQL_DATE for cfsqltype. type is "IN", "out" "IN/OUT". My code: <cfstoredproc procedure="sp_mySP" datasource="SQLDB" username="xxxxx" password="xxx"> <cfprocparam type="In" cfsqltype="CF_SQL_DATE" dbvarname="@startdate" value="CreateODBCDateTime(1/1/2000)" null="No"> <CFprocresult name="Qtest"> </CFSTOREDPROC> Thanks Rodney -----Original Message----- From: Weaver, Anthony [mailto:AWeaver@;Limitedbrands.com] Sent: Thursday, November 07, 2002 10:07 AM To: CF-Talk Subject: RE: Stored proc help make sure that your date CFPROCPARAMS use the SQLDATESTAMP type and use CreateODBCDateTime(your date). i get this often on date formats -----Original Message----- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:Rodney.Bruce@;HQISEC.ARMY.MIL] Sent: Thursday, November 07, 2002 12:04 PM To: CF-Talk Subject: Stored proc help Hello all I am trying to call a storedproc from an SQL 7 db. and I get this error. Does anyone know what it means. ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented I have tested the connection through CF admin and it tests ok. If I leave out a param. I get the error the param is missing. SO I think the connection to the db if ok. Thanks Rodney ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
