Stick this code at the top of your SP: SET DATEFORMAT DMY
-----Original Message----- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:Rodney.Bruce@;HQISEC.ARMY.MIL] Sent: 07 November 2002 19:29 To: CF-Talk Subject: RE: Stored proc help Sent it once but here it is again. It has the recommended changes and runs without errors but returns nothing? <cfstoredproc procedure="sp_mySP" datasource="SQLDB" username="xxxxx" password="xxx"> <cfprocparam type="In" cfsqltype="CF_SQL_TIMESTAMP" dbvarname="startdate" value="#CreateODBCDateTime(10/01/2000)#" null="No"> <CFprocresult name="Qtest"> </CFSTOREDPROC> the username has full privileges to the db. and I have gone into the tables and verified that there are records with a start date after the one entered. and if the storedproc is run from the SQL server it returns records? -----Original Message----- From: Bryan Stevenson [mailto:bryan@;electricedgesystems.com] Sent: Thursday, November 07, 2002 11:29 AM To: CF-Talk Subject: Re: Stored proc help How about we get to see some code instead of playing 20 questions ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Bruce, Rodney S HQISEC/Veridian IT Services" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 9:49 AM Subject: RE: Stored proc help > No params are dates > > -----Original Message----- > From: Andy Ewings [mailto:andy.e@;thoughtbubble.net] > Sent: Thursday, November 07, 2002 10:26 AM > To: CF-Talk > Subject: RE: Stored proc help > > > Is one of your parameters type "text" or "ntext"? > > -----Original Message----- > From: Weaver, Anthony [mailto:AWeaver@;Limitedbrands.com] > Sent: 07 November 2002 17:07 > 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 Get the mailserver that powers this list at http://www.coolfusion.com
