Mike...
no, <cfqueryparam> 'negates' the need for the single quotes. it
simply accepts the value and the cfsqltype and does the rest of its
magic under the hood :)
On Sat, 18 Dec 2004 14:03:51 +1100, Mike Kear <[EMAIL PROTECTED]> wrote:
> Tony,
>
> I might be wrong, because I dont know as much about cfqueryparam as I
> ought to, but you dont have single quotes around your inserted values.
> Shouldn't your code be:
>
> ...
>
> values
> ('<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.company#">',
> '<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.contact#"'> )
> </cfquery>
>
> Cheers
> Mike Kear
> Windsor, NSW, Australia
> AFP Webworks
> http://afpwebworks.com
> .com,.net,.org domains from AUD$20/Year
>
> On Fri, 17 Dec 2004 09:23:55 -0500, Tony Weeg <[EMAIL PROTECTED]> wrote:
> > here's the code, fairly straightforward...
> >
> > <cfquery name="insertClient" username="#application.username#"
> > password="#application.password#" datasource="webCollect">
> > insert into clients
> > (company, contact)
> > values
> > (<cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.company#">,
> > <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#form.contact#">
> > )
> > </cfquery>
> >
> > thanks.
> > tony
> >
> > --
> > tony
> >
> > Tony Weeg
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188119
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
