Hi
In the sql that I use I have
modifyDate = '#nowDateTime#'
It could be that you need the single quotes duedate='#duedate#'
Regards
From: Mark Armstrong <[EMAIL PROTECTED]>
Reply-To: Dallas/Fort Worth ColdFusion User Group Mailing
List<[email protected]>
To: Dallas/Fort Worth ColdFusion User Group Mailing
List<[email protected]>
Subject: [DFW CFUG] Newbie Confusion: Dateformat from SQL
Date: Tue, 6 Jun 2006 13:21:36 -0500
OK,
I give up!!! I cannot seem to get the date to work correctly. (to insert,
modify or output the data in the table).
I am CF formatting the date, properly, but its not showing up in the table
anything other than 01/01/01.
When I modify the form to insert the new values, its still the same...
what can I be doing wrong?
The output page is this: #DateFormat(duedate,"MM-DD-YY")#
the modify page looks like this:
<cfset duedate1 = DateFormat(#duedate#, "mm/dd/yy")>
<input name="duedate" type="text" value="#duedate1#"
cfsqltype="CF_SQL_DATE" />
and the modify page posts to the update processing page:
UPDATE tasks
SET taskname = '#taskname#', taskdescription = '#taskdescription#',
first_name='#first_name#', weburl='#weburl#', test='#test#',
visual='#visual#', comments='#comments#', duedate=#duedate#
WHERE taskID = #form.taskID#
Any help is appreciated!
Mark
_______________________________________________
Reply to DFWCFUG: [email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
_________________________________________________________________
Dont just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
