Re: [DFW CFUG] Newbie Confusion: Dateformat from SQL

Tue, 06 Jun 2006 11:41:42 -0700 

Hi

You are not passing a numeric number you are passing a string.

If I am correct.

try it.

It only take 2 second to put the quotes on and try.

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: Re: [DFW CFUG] Newbie Confusion: Dateformat from SQL
Date: Tue, 6 Jun 2006 13:34:32 -0500

I thought I didn't need single quotes when passing a numerical value.
and its not the NOW date I need anyway, its the date "desired" (in the future) 


On Jun 6, 2006, at 1:30 PM, Ray Hughes wrote:


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/


_________________________________________________________________
Don’t 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/



_______________________________________________
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/


_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement 


_______________________________________________
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/

Reply via email to