What exactly do you mean with the old code, what exactly does cfparam
achieve, I am just trying to update a database field, why does cfparam need
to be used and why does the update code need to be updated?
I have just had a look at the CFPARAM tag and is used to test for a
parameter's existence, and optionally test its data type, and provide a
default value if one is not assigned.
The syntax I am using looks correct so what else needs to be modified, I
cant see what??
Ian
----- Original Message -----
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 24, 2002 10:23 AM
Subject: Re: SQL Errors when updating Oracle table with CF ???
> Ian Vaughan wrote:
>
> > I have just changed my query to cfqueryparam
> >
> > <cfparam name="file.serverFile" value="null">
>
> value => default
>
> > <CFQUERY DATASOURCE="#Application.DSN#" name="insert_query">
> > UPDATE downloads
> > SET dldate = TO_DATE ('#formatted_date#', 'MM/DD/YYYY'),
> > dltitle ='#form.dltitle#',
> > dlsummary ='#form.dlsummary#',
> > area ='#form.area#',
> > dlos ='#form.dlos#',
> > dlpath ='#file.serverFile#',
> > username ='#Session.Fname# #Session.Lname#'
> > WHERE dloadidid = #form.id#
> > </CFQUERY>
>
> This is still the old code without cfqueryparam.
>
> Jochem
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
