displaying top 100 results
Portal Topic Connect ColdFusion JDBC to Sybase SQL Anywhere
Connect ColdFusion JDBC to Sybase SQL Anywhere
2608797 CF-3991862 Database Henry Ho Log Activity in "Data & Services > Datasources > Microsoft SQL Server" doesn't work Problem Description: "Log database calls to (anywhere)" doesn't work in CF Admin's Data & Services > Datasources > Microsoft SQL Server.
Steps to Reproduce: Add a new data
Tracker Comment Comment on Dates beyond 12/31/9999 are considered "valid", yet crash or result in data loss. by James M.
5994179 CF-4204879 James M. I attempted to use the DATEDIFF function in Excel with a valid futuristic date to calculate the difference in days and it fails and returns "#VALUE!". What use is a valid date if it can't be used reused anywhere else? I checked out timeanddate.com and they don
Setup section, "Datasource" should be "Data source" as that's how it's spelled throughout the rest of the CF Administrator.
2. "Currently supported databases for cluster setup are MYSQL, SQLSERVER and ORACLE" should be "Currently supported databases for cluster setup are MySQL, Microsoft SQL Server
Tracker Issue Long running queries timeout
level.
I have tried adding the timeout attribute in the CFQUERY tag.
I have tried seeing if there were any SQL Server switches/properties that could be added to extend the timeout (didn't find anything)
Nothing I have tried seems to work. The query runs anywhere from 45 seconds to a little over 1
Tracker Issue Bug 82889:(Watson Migration Closure)Hi there,We have recently upgraded our database from Sybase 6 to Sybase 11
encoding :
Method:
Result:
ColdFusion 9 ODBC Server crashes when talking to Sybase over SQL Anywhere 11
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3041452
External Customer Info:
External Company:
External Customer Name: Holly Ackerman
Tracker Comment Comment on The product of listLast(x) and listFirst(x) changes in the context of cfquery and outside the context of cfquery by External U.
has to be processed before the result gets anywhere near any of the driver's methods.
You *could* make an argument that CF is doing this escaping at the wrong time... those expressions are not used within the SQL string, so shouldn't be "escaped". I wonder if there's a logical way for the parser
Tracker Issue Improve scalar functions in query of query
of scalar functions an SQL implementation ought to support.
Obviously Adobe are not in the business of creating a DB platform, but as a minimum a few ought to be added:
* time part extraction like year() / month() / day() / hour() / minute() / second()
* datediff() / dateadd()
* substring() / replace
Tracker Issue Improve scalar functions in query of query
?), but there are really a lot of scalar functions an SQL implementation ought to support.
Obviously Adobe are not in the business of creating a DB platform, but as a minimum a few ought to be added:
* time part extraction like year() / month() / day() / hour() / minute() / second()
* datediff() / dateadd()
* substring