Hi there :
I was using a cfqueryparam tag to work with my queries and when i set some
Datetime values coldfusiion raise this error ,
note : sorry about the field names , i'm working on a Spanish database.
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
SQL = "SET DATEFORMAT DMY; INSERT INTO pla06_caratula
(pla06_tipo_cliente,pla06_id_cliente_sp,pla06_ejecutivo_placement,
pla06_poliza_anterior,pla06_compania_anterior,pla06_ramo,
pla06_vigencia_desde,pla06_vigencia_hasta,pla06_vigencia_hora,
pla06_fecha_limite_cotizar,pla06_moneda,pla08_id_tipo_cotizacion)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
"Query Parameter Value(s) -
Parameter #1 = 1
Parameter #2 = 77046420-K
Parameter #3 = 1
Parameter #4 = 41234123
Parameter #5 = 12
Parameter #6 = 69
Parameter #7 = {d '2004-11-09'}
Parameter #8 = {d '2005-11-09'}
Parameter #9 = 12:00 Hrs local
Parameter #10 = {d '2004-11-23'}
Parameter #11 = 1
Parameter #12 = 1 Data Source = "PLACEMENT"
if i use a direct variable instead of <cfqueryparam (type date)
this query works fine..
Any ideas?
The environment
Coldfusion 5 professional
MS SQL Server 2000
MDAC 2.8
Windows 2000 server
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183763
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
