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:188118
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
