based on the code Tony posted in the original message, i don't see anything wrong either (sorry, T).
I figured I'd sit back too and see what he and Jochem figure out...but I'm definitely curious :) On Sat, 18 Dec 2004 14:44:11 +1100, Mike Kear <[EMAIL PROTECTED]> wrote: > Ah ok then. thanks Charlie. I've learned two things here on this thread. > > The other thing I've learned is that I dont know what's wrong with > Tony's insert, and if it was my project, I'd be looking for ways to > see the actual insert created by ColdFusion.. Then i'd tinker around > with that until I found the character(s) causing the problem. That > would tell me what I should change in the ColdFusion code. > > I'll now sit back and watch to see what turns out to be the cause. > > Thanks again Charlie. > > Cheers > Mike Kear > Windsor, NSW, Australia > AFP Webworks > http://afpwebworks.com > .com,.net,.org domains from AUD$20/Year > > > On Fri, 17 Dec 2004 20:26:46 -0700, Charlie Griefer > <[EMAIL PROTECTED]> wrote: > > 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:188121 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
