I'm told that all databases have the potential to be either case sensitive or case-insensitive provided you can set their colation. 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
