Exactly...
IMO there is very rarely (I can't think of any at the moment) a case for
not cfparamming *every* value going into your database. There are
arguments
for both performance and security.
~d
On 6/6/06, Mark Armstrong <[EMAIL PROTECTED]> wrote:
>
> I'm not sure how the cfqueryparam works... I need to read up more. I
> know it has to go into a query tag, but on the modify page? like this?
>
> <CFQUERY NAME="update" datasource="#application.dsn#">
> UPDATE tasks
> SET taskname = '#taskname#', taskdescription = '#taskdescription#',
> first_name='#first_name#', weburl='#weburl#', test='#test#',
> visual='#visual#', comments='#comments#', duedate = <cfqueryparam
> type="cf_sql_date" value=#CreateODBCDate(duedate)# />
> WHERE taskID = #form.taskID#
>
> </CFQUERY>
> ??
>
> Mark
>
> On Jun 6, 2006, at 1:38 PM, Dave Shuck wrote:
>
> > Mark, have you tried:
> >
> > WHERE .... duedate=#CreateODBCDate(duedate)#
> >
> > or even better...
> >
> > WHERE .... duedate = <cfqueryparam type="cf_sql_date"
> > value=#CreateODBCDate(duedate)# />
> >
> >
> >
> > ~d
> >
> >
> > On 6/6/06, Mark Armstrong <[EMAIL PROTECTED]> wrote: Sorry, MSSQL 7.
> > table, meaning the "tasks" table that I am storing
> > the data.
> >
> >
> > On Jun 6, 2006, at 1:27 PM, Matt Woodward wrote:
> >
> > > When you say "in the table" what specifically do you mean? What
> > > database are you using?
> > >
> > > On 6/6/06, Mark Armstrong <[EMAIL PROTECTED]> wrote:
> > >> 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/
> > >>
> > >
> > >
> > > --
> > > Matt Woodward
> > > [EMAIL PROTECTED]
> > > http://www.mattwoodward.com
> > >
> > > _______________________________________________
> > > Reply to DFWCFUG: [email protected]
> > > Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/
> > > listinfo/list
> > > List Archives: http://www.mail-archive.com/list%
> <http://www.mail-archive.com/list%25>
> > > 40list.dfwcfug.org/
http://www.mail-archive.com/list%<http://www.mail-archive.com/list%25>
> > > 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/
> >
> >
> >
> > --
> > ~Dave Shuck
> > [EMAIL PROTECTED]
> > www.daveshuck.com
> > www.worldwildweb.biz
> > _______________________________________________
> > 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/
>
--
~Dave Shuck
[EMAIL PROTECTED]
www.daveshuck.com
www.worldwildweb.biz
