Ask a Question related to Coldfusion Database Access, Design and Development.
-
Zefodder #1
Date Time objects in CF7 :(
why doesn't CF7 handle date time objects right anymore (like CF5)?
code sample that works in CF5 but not in CF7 (datetime object 'wdate' is not a
date time object anymore)
and not caught by the code analyzer
<cfquery name="getber" datasource="some Access database">
select body, titel, user, wdate
from berichies
order by wdate desc
</cfquery>
//some cf code but no format changes to wdate
<cfquery datasource="some Access database" name="autoarchive">
INSERT INTO OuweTroep
(
body,
titel,
user,
wdate
)
values
(
'#body#',
'#titel#',
'#user#',
'#wdate#'
)
</cfquery>
while this works fine in Both CF versions:
<cfquery datasource="some Access database" name="selectedforarchive">
INSERT INTO OuweTroep
(
body,
titel,
user,
wdate
)
SELECT
body,
titel,
user,
wdate
from berichies
WHERE berid= #mssgid#
</cfquery>
Is this a bug or simply a new version of the microsoft access ODBC driver
which has some new "by design" features for timestamp recognition? :frown;
Zefodder Guest
-
CFMX7.0.1 Administrator date time issue showing 13hrsbehind server time
I am running a W2k SP4 box that has been upgraded from CFMX6 to CFMX7.0.1. The CFMX7.0.1 server is showing the date on the Server Settings >... -
Convert date/time to date in SQL Server 2000 statement
Can this be done? tia -
Time/Date format and changing time to GMT
Hi All, Sorry if this is the wrong newsgroup to post into, on this topic, if so, please point me in the right direction..... Currently working... -
asp.net date objects vs. classic asp date objects
I have scripts on a server that awhile back had new option/server packs installed (to accomodate security and net framework issues) and my classic... -
accessing Global.asax design time objects
hi, how to access to Global.asax design time objects from my asp.net page? thanks in advance ..Javier Ros.



Reply With Quote

