Read up the docs on it to get a full overview of all the sqltypes. CF_SQL_VARCHAR is saying it must be a varchar (or text) field.
It's well worth using cfqueryparam all the time. As Dennis says, it protects against sql injection attacks apart from anything else. will -----Original Message----- From: Frank Velazquez [mailto:[EMAIL PROTECTED] Sent: 22 February 2008 21:58 To: CF-Newbie Subject: Re: More mismatch Data...( u_u)! I've heard bout cfqueryparam from a few dif people, but I don't know how to use it, with the forms and stuff. What does: cfsqltype="CF_SQL_VARCHAR" do? is there a dif in me using access? and all my data type fields in that category are text fields. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3344 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
