Hope to see you tonight at NYCFUG!!!

[Judith Dinowitz]

This is the first of two great NYCFUG (http://www.nycfug.org) meetings this month. I am very much looking forward to hearing Greg Anthony talk about his book, Iterating Infusion: Clearer Views of Objects, Classes, and Systems, and his system of software development. We have books and a t-shirt for a raffle! In addition, we will start off the evening with my presentation on CFSET and the proper way to set variables.

When: Tonight, Tuesday, September 13, 2005, 6:30 PM
Where: NYU Medical Center, 550 1st Avenue, Corner of E. 31st Street, Room: Coles 101

There is no sponsor for this meeting, so please plan for dinner before or after.

If you haven't RSVP'd and are coming, please do:
http://www.nycfug.org

Judith Dinowitz
Co-Manager
New York ColdFusion User Group
NYCFUG

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:25:1836
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Joe Russo]

hi judith,

i can't make it tonight - will this be taped?

cheers,

joe



Judith Dinowitz wrote:

>This is the first of two great NYCFUG (http://www.nycfug.org) meetings this month. I am very much looking forward to hearing Greg Anthony talk about his book, Iterating Infusion: Clearer Views of Objects, Classes, and Systems, and his system of software development. We have books and a t-shirt for a raffle! In addition, we will start off the evening with my presentation on CFSET and the proper way to set variables.
>
>When: Tonight, Tuesday, September 13, 2005, 6:30 PM
>Where: NYU Medical Center, 550 1st Avenue, Corner of E. 31st Street, Room: Coles 101
>
>There is no sponsor for this meeting, so please plan for dinner before or after.
>
>If you haven't RSVP'd and are coming, please do:
>http://www.nycfug.org
>
>Judith Dinowitz
>Co-Manager
>New York ColdFusion User Group
>NYCFUG
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:25:1837
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Judith Dinowitz]

Joe,

No, I'm afraid it wasn't taped, but I'm going to try to do a writeup of the meeting so that you'll at least get the gist of what Greg was saying. I'll be working on that tonight.

My beginner's powerpoint presentation will be put up on the NYCFUG site.

Judith
----- Original Message -----
> hi judith,
>
> i can't make it tonight - will this be taped?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:25:1858
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[R.J.Siegel]

I was given a .dat file which was said to be downloaded
from a sql server.  It is mostly binary.

I can't open it with anything I have and there seems to be
no references to .dat files in the Ent Mgr docs.

Would you know what this file might be and how to
convert it to an mdb or something?


--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Now there?s a better way to fax. eFax makes it possible to use your existing email account to send and receive faxes. Try eFax free.
http://www.houseoffusion.com/banners/view.cfm?bannerid=63

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1925
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Cook, Scott]

maybe a database dump or binary BCP if you're talking about a single table of data

-----Original Message-----
From: R.J.Siegel [mailto:bob.siegel@...]
Sent: Friday, October 07, 2005 12:32 PM
To: NYCFUG
Subject: sequel question


I was given a .dat file which was said to be downloaded
from a sql server.  It is mostly binary.

I can't open it with anything I have and there seems to be
no references to .dat files in the Ent Mgr docs.

Would you know what this file might be and how to
convert it to an mdb or something?


--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1926
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[R.J.Siegel]

Is there a way to retrieve all recs where a certain
field starts with a lowercase letter?

Letters can be done one at a time if needed.

--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Sams Teach Yourself Regular Expressions in 10 Minutes  by Ben Forta
http://www.houseoffusion.com/banners/view.cfm?bannerid=40

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1943
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Cook, Scott]

From the Sybase SQL Server Manual, altered to match your request

In the following example, patindex finds all the rows in sysobjects that start with "a" thru "z":

select name
from sysobjects
where patindex("[a-z]%", name) > 0

-----Original Message-----
From: R.J.Siegel [mailto:bob.siegel@...]
Sent: Wednesday, October 26, 2005 6:37 PM
To: NYCFUG
Subject: Quick Sequel Server Question


Is there a way to retrieve all recs where a certain
field starts with a lowercase letter?

Letters can be done one at a time if needed.

--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---

==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.csfb.com/legal_terms/disclaimer_external_email.shtml

==============================================================================


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1946
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Howdy,

How about something like

SELECT Foo1, Foo2, ...
FROM Bar
WHERE ASCII(Foo1) BETWEEN 97 AND 122

Assuming Foo1 is a char or varchar column.

-MOM


At 06:37 PM 10/26/2005 -0400, you wrote:

>Is there a way to retrieve all recs where a certain
>field starts with a lowercase letter?
>
>Letters can be done one at a time if needed.
>
>--
>--  Bob/Jules Siegel  Bob.Siegel@...  --
>--  ColdFusion / Web Databases   ---
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1945
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[R.J.Siegel]

Many thanks for your replies, but read on...


Mark Modig wrote:
> How about something like>
> SELECT Foo1, Foo2, ...
> FROM Bar
> WHERE ASCII(Foo1) BETWEEN 97 AND 122
> Assuming Foo1 is a char or varchar column.

That works fine, thanks!


 > where patindex("[a-z]%", name) > 0

this "works" but it is case-INSENSITIVE, so does
not do what is needed.


--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1948
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Cook, Scott]

Don't know why kind of server you're using but that's a bug unless the docs state it's case insensitive

I just ran this on Sybase 12.x and

select patindex("[a-z]%","lowercase"), patindex("[a-z]%","UPPERCASE")

1 0

works fine.

-----Original Message-----
From: R.J.Siegel [mailto:bob.siegel@...]
Sent: Thursday, October 27, 2005 11:48 AM
To: NYCFUG
Subject: Re: Quick Sequel Server Question answered


Many thanks for your replies, but read on...


Mark Modig wrote:
> How about something like>
> SELECT Foo1, Foo2, ...
> FROM Bar
> WHERE ASCII(Foo1) BETWEEN 97 AND 122
> Assuming Foo1 is a char or varchar column.

That works fine, thanks!

 > where patindex("[a-z]%", name) > 0

this "works" but it is case-INSENSITIVE, so does not do what is needed.

--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---

==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.csfb.com/legal_terms/disclaimer_external_email.shtml

==============================================================================


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
All-in-one: antivirus, antispam, firewall for your PC and PDA. Buy Trend Micro PC-cillin Internet Security
http://www.houseoffusion.com/banners/view.cfm?bannerid=60

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1949
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[R.J.Siegel]

MS Sequel Server.
It has been set up so everything is NOT case-sensitive, so
this apparently includes your test.

Server is owned by edgewebhosting.net, and I much prefer
no case-sensitivity, except this one oddball case.

I am happy tho that
     WHERE ASCII(address1) BETWEEN 97 AND 122
works just fine.

Cook, Scott wrote:
> Don't know why kind of server you're using but that's a bug unless the
> docs state it's case insensitive
>
> I just ran this on Sybase 12.x and
>
> select patindex("[a-z]%","lowercase"), patindex("[a-z]%","UPPERCASE")
>
> 1 0
>


--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:25:1951
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Wolf, Yonah]

I think that the issue at hand is the collation (sp?) mode that was installed on the server. If the collation mode is Case-Insensitive, then it will treat all queries as case-insensitive, in which case it will see the Regex [a-z] to be the same as [A-Z]. I just ran Scott's Query on my own server (with a CI collation) and it returned 1 1 as the result set.

That being said, Mark's approach is independent of the system collation.

To add a twist- you could also try this in the vane that Mark set forth, but I can't guarantee it is any more or less efficient that his method:

Select ...

WHERE ascii(mycol)=ascii(lower(mycol))

Yonah Wolf
Development Project Manager
United Jewish Communities
111 8th Ave, Suite 11E
New York, NY 10011
V: 212.284.6550 / F: 212.284.6819
E: yonah.wolf@... / W: http://www.ujc.org
Live Generously.?  It does a world of good.

-----Original Message-----
From: Cook, Scott [mailto:scott.cook@...]
Sent: Thursday, October 27, 2005 11:56 AM
To: NYCFUG
Subject: RE: Quick Sequel Server Question answered

Don't know why kind of server you're using but that's a bug unless the docs state it's case insensitive

I just ran this on Sybase 12.x and

select patindex("[a-z]%","lowercase"), patindex("[a-z]%","UPPERCASE")

1 0

works fine.

-----Original Message-----
From: R.J.Siegel [mailto:bob.siegel@...]
Sent: Thursday, October 27, 2005 11:48 AM
To: NYCFUG
Subject: Re: Quick Sequel Server Question answered


Many thanks for your replies, but read on...


Mark Modig wrote:
> How about something like>
> SELECT Foo1, Foo2, ...
> FROM Bar
> WHERE ASCII(Foo1) BETWEEN 97 AND 122
> Assuming Foo1 is a char or varchar column.

That works fine, thanks!

 > where patindex("[a-z]%", name) > 0

this "works" but it is case-INSENSITIVE, so does not do what is needed.

--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---

==============================================================================
Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.csfb.com/legal_terms/disclaimer_external_email.shtml

==============================================================================




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:25:1950
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Cook, Scott]

Pretty disturbing I would think.  Would that also affect things like

select iddesc from sometable where idcode = "a"

I can easily image a single char field containing some kind of code where they started with A, ran thru Z, then started using a thru z.

-----Original Message-----
From: R.J.Siegel [mailto:bob.siegel@...]
Sent: Thursday, October 27, 2005 12:13 PM
To: NYCFUG
Subject: Re: Quick Sequel Server Question answered


MS Sequel Server.
It has been set up so everything is NOT case-sensitive, so
this apparently includes your test.

Server is owned by edgewebhosting.net, and I much prefer
no case-sensitivity, except this one oddball case.

I am happy tho that
     WHERE ASCII(address1) BETWEEN 97 AND 122
works just fine.

Cook, Scott wrote:
> Don't know why kind of server you're using but that's a bug unless the
> docs state it's case insensitive
>
> I just ran this on Sybase 12.x and
>
> select patindex("[a-z]%","lowercase"), patindex("[a-z]%","UPPERCASE")
>
> 1 0
>


--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how to get a fax number that sends and receives faxes using your current email address
http://www.houseoffusion.com/banners/view.cfm?bannerid=64

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1952
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Wolf, Yonah]

Scott,

 But then you need to consider inconsistencies in data entry and getting annoyed at having to wrap upper() and lower() around strings when searching. In a case-sensitive database, searching for 'car%' will only return carol and carolyn but not Carol, Carolyn, etc. In addition, it also becomes a pain to sort so that a comes after/together with A and not after Z.

 However, the other option that no one discussed is the COLLATE keyword in your create table statement, that let's you change the collation for an individual column. E.g.- I can make a specific column case-sensitive even though my entire database is defaulting to CI.

--Yonah


Yonah Wolf
Development Project Manager
United Jewish Communities
111 8th Ave, Suite 11E
New York, NY 10011
V: 212.284.6550 / F: 212.284.6819
E: yonah.wolf@... / W: http://www.ujc.org
Live Generously.?  It does a world of good.

-----Original Message-----
From: Cook, Scott [mailto:scott.cook@...]
Sent: Thursday, October 27, 2005 12:45 PM
To: NYCFUG
Subject: RE: Quick Sequel Server Question answered

Pretty disturbing I would think.  Would that also affect things like

select iddesc from sometable where idcode = "a"

I can easily image a single char field containing some kind of code where they started with A, ran thru Z, then started using a thru z.

-----Original Message-----
From: R.J.Siegel [mailto:bob.siegel@...]
Sent: Thursday, October 27, 2005 12:13 PM
To: NYCFUG
Subject: Re: Quick Sequel Server Question answered


MS Sequel Server.
It has been set up so everything is NOT case-sensitive, so this apparently includes your test.

Server is owned by edgewebhosting.net, and I much prefer no case-sensitivity, except this one oddball case.

I am happy tho that
     WHERE ASCII(address1) BETWEEN 97 AND 122 works just fine.

Cook, Scott wrote:
> Don't know why kind of server you're using but that's a bug unless the
> docs state it's case insensitive
>
> I just ran this on Sybase 12.x and
>
> select patindex("[a-z]%","lowercase"), patindex("[a-z]%","UPPERCASE")
>
> 1 0
>


--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---






~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1953
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Cook, Scott]

Drat, not in Sybase.  I would have used it in something I'm working on now.  Specifically fields with first and last name.  I would have set those to case-insensitive.

Would this statement find records where idcode is A or a?

select iddesc from sometable where idcode = "a"  

-----Original Message-----
From: Wolf, Yonah [mailto:Yonah.Wolf@...]
Sent: Thursday, October 27, 2005 1:31 PM
To: NYCFUG
Subject: RE: Quick Sequel Server Question answered


Scott,

 But then you need to consider inconsistencies in data entry and getting annoyed at having to wrap upper() and lower() around strings when searching. In a case-sensitive database, searching for 'car%' will only return carol and carolyn but not Carol, Carolyn, etc. In addition, it also becomes a pain to sort so that a comes after/together with A and not after Z.

 However, the other option that no one discussed is the COLLATE keyword in your create table statement, that let's you change the collation for an individual column. E.g.- I can make a specific column case-sensitive even though my entire database is defaulting to CI.

--Yonah


Yonah Wolf
Development Project Manager
United Jewish Communities
111 8th Ave, Suite 11E
New York, NY 10011
V: 212.284.6550 / F: 212.284.6819
E: yonah.wolf@... / W: http://www.ujc.org
Live Generously.?  It does a world of good.

-----Original Message-----
From: Cook, Scott [mailto:scott.cook@...]
Sent: Thursday, October 27, 2005 12:45 PM
To: NYCFUG
Subject: RE: Quick Sequel Server Question answered

Pretty disturbing I would think.  Would that also affect things like

select iddesc from sometable where idcode = "a"

I can easily image a single char field containing some kind of code where they started with A, ran thru Z, then started using a thru z.

-----Original Message-----
From: R.J.Siegel [mailto:bob.siegel@...]
Sent: Thursday, October 27, 2005 12:13 PM
To: NYCFUG
Subject: Re: Quick Sequel Server Question answered


MS Sequel Server.
It has been set up so everything is NOT case-sensitive, so this apparently includes your test.

Server is owned by edgewebhosting.net, and I much prefer no case-sensitivity, except this one oddball case.

I am happy tho that
     WHERE ASCII(address1) BETWEEN 97 AND 122 works just fine.

Cook, Scott wrote:
> Don't know why kind of server you're using but that's a bug unless the
> docs state it's case insensitive
>
> I just ran this on Sybase 12.x and
>
> select patindex("[a-z]%","lowercase"), patindex("[a-z]%","UPPERCASE")
>
> 1 0
>


--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---








~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1954
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Wolf, Yonah]

Scott,

 In Case Insensitive mode, ='a' matches both 'A' and 'a'.


Yonah Wolf
Development Project Manager
United Jewish Communities
111 8th Ave, Suite 11E
New York, NY 10011
V: 212.284.6550 / F: 212.284.6819
E: yonah.wolf@... / W: http://www.ujc.org
Live Generously.?  It does a world of good.

-----Original Message-----
From: Cook, Scott [mailto:scott.cook@...]
Sent: Thursday, October 27, 2005 2:04 PM
To: NYCFUG
Subject: RE: Quick Sequel Server Question answered

Drat, not in Sybase.  I would have used it in something I'm working on now.  Specifically fields with first and last name.  I would have set those to case-insensitive.

Would this statement find records where idcode is A or a?

select iddesc from sometable where idcode = "a"  

-----Original Message-----
From: Wolf, Yonah [mailto:Yonah.Wolf@...]
Sent: Thursday, October 27, 2005 1:31 PM
To: NYCFUG
Subject: RE: Quick Sequel Server Question answered


Scott,

 But then you need to consider inconsistencies in data entry and getting annoyed at having to wrap upper() and lower() around strings when searching. In a case-sensitive database, searching for 'car%' will only return carol and carolyn but not Carol, Carolyn, etc. In addition, it also becomes a pain to sort so that a comes after/together with A and not after Z.

 However, the other option that no one discussed is the COLLATE keyword in your create table statement, that let's you change the collation for an individual column. E.g.- I can make a specific column case-sensitive even though my entire database is defaulting to CI.

--Yonah


Yonah Wolf
Development Project Manager
United Jewish Communities
111 8th Ave, Suite 11E
New York, NY 10011
V: 212.284.6550 / F: 212.284.6819
E: yonah.wolf@... / W: http://www.ujc.org Live Generously.?  It does a world of good.

-----Original Message-----
From: Cook, Scott [mailto:scott.cook@...]
Sent: Thursday, October 27, 2005 12:45 PM
To: NYCFUG
Subject: RE: Quick Sequel Server Question answered

Pretty disturbing I would think.  Would that also affect things like

select iddesc from sometable where idcode = "a"

I can easily image a single char field containing some kind of code where they started with A, ran thru Z, then started using a thru z.

-----Original Message-----
From: R.J.Siegel [mailto:bob.siegel@...]
Sent: Thursday, October 27, 2005 12:13 PM
To: NYCFUG
Subject: Re: Quick Sequel Server Question answered


MS Sequel Server.
It has been set up so everything is NOT case-sensitive, so this apparently includes your test.

Server is owned by edgewebhosting.net, and I much prefer no case-sensitivity, except this one oddball case.

I am happy tho that
     WHERE ASCII(address1) BETWEEN 97 AND 122 works just fine.

Cook, Scott wrote:
> Don't know why kind of server you're using but that's a bug unless the
> docs state it's case insensitive
>
> I just ran this on Sybase 12.x and
>
> select patindex("[a-z]%","lowercase"), patindex("[a-z]%","UPPERCASE")
>
> 1 0
>


--
--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---










~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1955
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[R.J.Siegel]

Cook, Scott wrote:
 > Pretty disturbing I would think.  Would that also affect things like select
 > iddesc from sometable where idcode = "a" I can easily image a single char
 > field containing some kind of code where they started with A, ran thru Z,
 > then started using a thru z.

This brings up what amounts to a religious issue, whether ANYTHING
should be case-sensitive.

I am staunchly on the "non" side, as I have found case-sensitivity
causes nothing but trouble, like with filenames on Unix servers,
or with Verisign payments where their friggin' form-field names
are case-sensitive (ugh).

Of course the other side maintains that "a" is not "A".
That is true, but for machines, not so much for humans who just
see it as a format and/or cosmetic difference.

Please don't start a flame war about this.
Everyone is entitled to their opinion.



--  Bob/Jules Siegel  Bob.Siegel@...  --
--  ColdFusion / Web Databases   ---


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:25:1956
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

[Joe Russo]

Hi Judith,

I looked through my email but was unable to locate your writeup.  Might
you be able to resend it to me?

Thanks so much,

Joe Russo



Judith Dinowitz wrote:

>Joe,
>
>No, I'm afraid it wasn't taped, but I'm going to try to do a writeup of the meeting so that you'll at least get the gist of what Greg was saying. I'll be working on that tonight.
>
>My beginner's powerpoint presentation will be put up on the NYCFUG site.
>
>Judith
>----- Original Message -----
>  
>
>>hi judith,
>>
>>i can't make it tonight - will this be taped?
>>    
>>
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:25:1988
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/25
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:25
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.25
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54