On 6/6/06, Mark Armstrong <
[EMAIL PROTECTED]> wrote:
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/
--
diabetic? http://www.diabetesforums.com
Bill Cosby - A word to the wise ain't necessary - it's the stupid ones that need the advice.
_______________________________________________ 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/
