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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
