SQL Database Improvements
We have made the following improvements to SQL Server.
- Updated Query Analyzer based on MS Scripting Engine, this closes all reported defects
- Support for Unicode when viewing in table content view
- User-Defined Functions Management (2005 only)
- Updated Data Editing for Tables, this allows for data to be viewed in non-Latin languages
- Improved CSV import performance
thx
Reply to this
I'm using Coldfusion and MS Access via ODBC, I'm unable to write data of type datetime by using either CF_SQL_TIMESTAMP, CF_SQL_DATETIME or CF_SQL_DATE. the data is going through the standard createodbcdatetime() conversion. So what is the proper syntax for datetime stamps? One of the above works with most ISPs.
thanks,
dave
Reply to this
We wrote a simple test and were able to successfully use CF_SQL_DATE and CF_SQL_TIMESTAMP within a CFQUERYPARAM tag. Two things you may need to take a look at. First, we only support connections to databases through ColdFusion DSN's and please make sure the access database is not password protected.
Reply to this