something like this LSDateFormat(timestamp_in, "yyyy-mm-dd") &' ' &
LSTimeFormat(timestamp_in, "HH:mm:ss") and it got me through the day even
though I suspect there is a more elegant solution.
-Kore
Greg Luce
<[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]>
m> cc:
Subject: CFQUERYPARAM - CF5
10/07/2004 12:02
PM
Please respond to
cf-talk
I'm trying to add cfqueryparams to some old code running on CF5. My
local server is CF6.1 and my queries seem to work. But on the CF5
server I keep getting:
ODBC Error Code = S1C00 (Driver not capable)
[Microsoft][ODBC SQL Server Driver]Optional feature not implemented
SQL = "UPDATE Cases SET CaseType = ? , ReferralID = ? , ReferralType =
? , CSECaseNumber = ? , County = ? , Comment = ? , clerkofcourtsent =
?, clerkofcourtfiled = ?, sop = ?, FinalDisposition = NULL WHERE
CaseID = ?"
Query Parameter Value(s) -
Parameter #1 = PA
Parameter #2 = 40420837
Parameter #3 =
Parameter #4 = 4042089000
Parameter #5 = 53
Parameter #6 =
Parameter #7 = {d '2004-10-01'}
Parameter #8 = {d '2004-10-01'}
Parameter #9 = {d '2004-10-01'}
Parameter #10 = 46769
Data Source = "CS-TEST"
Here's the queryparams that are breaking it. If I comment them out and
run it on CF5 it runs without error.
clerkofcourtsent = <cfqueryparam
value="#createodbcdate(form.txtPam1Date)#" cfsqltype="CF_SQL_DATE"
null="#YesNoFormat(NOT len(trim(form.txtPAM1Date)) GT 0)#">,
clerkofcourtfiled = <cfqueryparam
value="#createodbcdate(form.txtPam1Date)#" cfsqltype="CF_SQL_DATE"
null="#YesNoFormat(NOT len(trim(form.txtPAM1Date)) GT 0)#">,
sop = <cfqueryparam value="#createodbcdate(form.txtPam1Date)#"
cfsqltype="CF_SQL_DATE" null="#YesNoFormat(NOT
len(trim(form.txtPAM1Date)) GT 0)#">,
I've tried so many different things. I'm baffled!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
