I don't know what Ron's problem is, but cf_sql_char isn't limited to a single char. Sean, you thought wrong ;). It's the same thing as a CHAR datatype in a RDBMS. I use cf_sql_char with a size="35" for my UUID cfqueryparams w/o issue.
t On Tue, 15 Mar 2005 16:46:02 -0800, Sean Corfield <[EMAIL PROTECTED]> wrote: > On Tue, 15 Mar 2005 19:19:49 -0400, Ron G <[EMAIL PROTECTED]> wrote: > > I have an Access 97 database(Yes I Know) that has a linked Oracle > > table\view in it. I can query the linked table without cfqueryparam. > .... > > LAWSON_SHC_EMPLOYEE_V.LAST_NAME= <cfqueryparam > > value="#ucase(form.Lname)#" cfsqltype="cf_sql_char"> > > > > I can do a similar query against an integer datatype with queryparam and it > > will work. > > cf_sql_char is a single character I thought. Try cf_sql_varchar. > > See also the documents linked from my blog entry on this subject: > > http://www.corfield.org/blog/index.cfm?do=blog.entry&entry=E33E072C-F67D-BA7C-310D63974FA85A92 > -- > Sean A Corfield -- http://www.corfield.org/ > Team Fusebox -- http://www.fusebox.org/ > Got Gmail? -- I have 50, yes 50, invites to give away! > > "If you're not annoying somebody, you're not really alive." > -- Margaret Atwood > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198903 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
