I'm only just
starting to use CFQueryParam myself, but I think the syntax you've
shown below is correct. It's good to use for a few reasons not the
least of which is that it protects against SQL injection. :)
Chris
Mark Armstrong 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%
> 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
_______________________________________________
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/
|
