> I'm told that all databases have the potential to be either > case sensitive or case-insensitive provided you can set their > colation.
Most enterprise-level databases SHOULD have this ability. My point was that CF (as far as I know) supports only case-sensitive comparisons when querying a dbtype of "query", which may not be what a developer is used to, depending on what database platform they are developing on. As you pointed out, this can be overcome by using CF's LCASE or UCASE functions to force the casing of the column. When querying a resultset from a database query (as opposed to a query object created from scratch), you can fix the case issue by creating an aliased column in your original, forcing case to upper or lower using that database's associated function, eg: SELECT first_name, last_name, LOWER(last_name) AS last_name_lowercase.... Then using the aliased column in your q-of-a-q.. Just some info for the uninitiated.. :) Take Care, Seth > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of S.Isaac Dealey > Sent: Monday, February 02, 2004 1:17 PM > To: [EMAIL PROTECTED] > Subject: RE: is this a bug? > > It's at least true of Oracle and MS SQL Server where Oracle > defaults to a case sensitive colation and SQL Server defaults > to a case insensitive colation. I believe they both set > colation on a per-catalog (database) basis. > > > > As an added note, items in the Where clause of a query with > > dbtype="Query" > > are case sensitive, ala Oracle, instead of bein case insensitive as > > with database drivers for SQL Server, Access, and some other DB's. > > > Just wanted to throw that out there. :) > > > Take Care, > > > Seth > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] > >> [mailto:[EMAIL PROTECTED] On Behalf Of > >> [EMAIL PROTECTED] > >> Sent: Monday, February 02, 2004 10:44 AM > >> To: [EMAIL PROTECTED] > >> Subject: RE: is this a bug? > >> > >> Hey Ron, > >> > >> Dates are not strings, so even though CF is "typeless" > >> and > >> won't throw an error when you supply a quoted date for a query of > >> this type, it will do a literal comparison, so if the > format of the > >> date in your "virtual table" and your query of that table are not > >> literally identical, no matches will be returned. > >> > >> What you will likely want to do is leave out the quotes in your > >> query. If that doesn't work, you might try using > >> DateFormat() around the values in your query, as well as when you > >> create the values in your QueryNew() call. > >> Remember, no quotes or else you'll be comparing the text > description > >> of the two dates. > >> > >> Hope this helps, > >> > >> Seth > >> > >> > -----Original Message----- > >> > From: [EMAIL PROTECTED] > >> > [mailto:[EMAIL PROTECTED] On Behalf Of Ron Mast > >> > Sent: Monday, February 02, 2004 10:30 AM > >> > To: [EMAIL PROTECTED] > >> > Subject: is this a bug? > >> > > >> > Sorry that I'm asking a lot of questions today.:( I have > created a > >> > query using the queryNew() function, then I'm querying that > >> query like > >> > so: > >> > <CFQUERY NAME="q3" > >> > DBTYPE="query"> > >> > SELECT * > >> > FROM q2 > >> > WHERE PRT = > >> > '#YHSPRT#' AND > >> > YR = '#thisyear#' > >> > </CFQUERY> > >> > > >> > But I don't get any record when there should be 1 when > >> > I dump the > >> > query above. > >> > > >> > I can dump the record when I hardcode PRT and the YR > >> > value. > >> > > >> > Does anyone have a clue why? > >> > > >> > Ron > >> > > >> > > >> > >> ----------------------------------------------- > >> To post, send email to [EMAIL PROTECTED] > >> To unsubscribe: > >> Send UNSUBSCRIBE to [EMAIL PROTECTED] To > >> subscribe > >> / unsubscribe: http://www.dfwcfug.org > >> > > > ----------------------------------------------- > > To post, send email to [EMAIL PROTECTED] > > To unsubscribe: > > Send UNSUBSCRIBE to [EMAIL PROTECTED] > > To subscribe / unsubscribe: http://www.dfwcfug.org > > > > s. isaac dealey 214.823.9345 > > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > http://www.turnkey.to/ontap > > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > Send UNSUBSCRIBE to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org > ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
