CHAR is a fixed width datatype If you have a field with CHAR( 34 ) and you only insert 4 characters than the other 30 characters are padded with a space.
-- Taco Fleur Senior Web Systems Engineer http://www.webassociates.com -----Original Message----- From: Tyler Fitch [mailto:[EMAIL PROTECTED] Sent: Wednesday, 16 March 2005 11:11 AM To: CF-Talk Subject: Re: cfqueryparam breaking query 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-F6 > 7D-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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:198918 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
