When I retrived a Date field in TOAD it displayed likeis \'1/18/2038 9:14:07 PM\', But when I rertrived in Coldfusion using cfquery and displayed using , then I got the date on screen like \'2038-01-
I am wondering if there are java methods/objects that would be alternatives to cfquery, that both allow variable sanitation, and better caching methods.
I had to change the SQL stored procedure to ORacle stored procddure.I am able to successfully execute my modified stored procedure i开发者_Go百科n oracle.
If one of the columns in the returned coldfusion query result set has a NULL, how do we check if the value of this column being NULL?
I\'m usingCF8 and SQL2000.I\'m sto开发者_运维技巧ring a bunch of HTML in a Text field in my SQL table.When I do a simple CFQUERY against that data, and CFDUMP it, it\'s truncated to 64000 characters.
How to print all the result without using Results.columnname in ColdFusion for ex:- I have <cfquery name=\"getProductId\">