a difference from CF5 to MX because I ran both against the same
database and the MX server worked with cf_sql_date, but on CF5 it
errrored. When I changed the CF5 code to cf_sql_timestamp it works.
Anyone know why, or is this documented? I wasn't able to find anything
on it on the MM site.
Greg
On Thu, 7 Oct 2004 17:50:24 -0500, Kore Peterson <[EMAIL PROTECTED]> wrote:
> I had the same problem and it was caused by the format of the date. I used
> 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]
