Community Member Profile
Aruna
Member since Apr 2, 2009
- Profile: /members/3215-Aruna.htm
- Comments: 2
- Points: 19
Recent Blog Comments By Aruna
-
CF_SQL_DATE Issues with MS SQL Server 2005
Posted on Apr 2, 2009 at 1:17 PM
sorry I used CF_SQL_TIMESTAMP in the querynew statement. My code: <!--- Create query to ouptut to excel. ---> <cfset qMovie = QueryNew( "StudentFName,StudentLName,StudentID,InstructorName,CoursePrefix,CourseNo,Section,Semester,Date_1,Reason", "CF_SQL_VARC... read more »
-
CF_SQL_DATE Issues with MS SQL Server 2005
Posted on Apr 2, 2009 at 1:15 PM
I am using the POI utility to upload data into a excel spread sheet. I had seen your code helps. The number part works but the date part is a problem in my case. I tried to use the sqldatetime in my querynew declaration for the columns. I tried to put the datatime as string in the row... read more »
