Re: Similar Group Names

2008-09-18 Thread Dwayne Martin
2008 16:09:41 -0700 From: Joe DeSouza [EMAIL PROTECTED] Subject: Re: Similar Group Names To: arslist@ARSLIST.ORG ** Depending on how you have structured your Group ID's you are less likelier to get this error if you base your search criteria on the Group ID of the group

Re: Similar Group Names

2008-09-18 Thread Joe DeSouza
[EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, September 18, 2008 8:19:25 AM Subject: Re: Similar Group Names Joe, Wouldn't '$GROUP$ like (100012; + %)' depend on 100012; being the first group on the list? How about '$GROUP$ like (100012; + %) or '$GROUP$ like (%;100012

Re: Similar Group Names

2008-09-18 Thread Axton
: Similar Group Names To: arslist@ARSLIST.ORG ** Depending on how you have structured your Group ID's you are less likelier to get this error if you base your search criteria on the Group ID of the group. It is a good practice therefore to have a good group ID naming convention

Re: Similar Group Names

2008-09-18 Thread Joe DeSouza
= ?? How would equal to find a string if its in the middle?   Joe - Original Message From: Axton [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Thursday, September 18, 2008 10:34:34 AM Subject: Re: Similar Group Names A better approach is to parse the group list into an external qual

Re: Similar Group Names

2008-09-18 Thread Axton
] To: arslist@ARSLIST.ORG Sent: Thursday, September 18, 2008 10:34:34 AM Subject: Re: Similar Group Names A better approach is to parse the group list into an external qual. e.g., 1;2;3 into 'groupid' = 1 or 'groupid' = 2 or 'groupid' = 3 Axton Grams On Thu, Sep 18, 2008 at 8:19 AM, Dwayne Martin

Re: Similar Group Names

2008-09-17 Thread Robert Molenda
Don't you just have to love the LIKE %Groupname% functionality? That's HD 5x for you... it is because of the LIKE queries... To get around this in the past we put a non-descript character in the group name which is getting 'duplicated' so your your example if you change Quest to Quest. (with a

Re: Similar Group Names

2008-09-17 Thread Shane Buchholz
To: arslist@ARSLIST.ORG Subject: Re: Similar Group Names ** Don't you just have to love the LIKE %Groupname% functionality? That's HD 5x for you... it is because of the LIKE queries... To get around this in the past we put a non-descript character in the group name which is getting

Re: Similar Group Names

2008-09-17 Thread Joe DeSouza
of the C104 column in your T table of the User schema to arrive at what might be the best search for you..   Joe - Original Message From: Robert Molenda [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, September 17, 2008 6:46:07 PM Subject: Re: Similar Group Names ** Don't you

Re: Similar Group Names

2008-09-17 Thread Joe DeSouza
into a limitation like you have.. Joe - Original Message From: Shane Buchholz [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, September 17, 2008 6:33:09 PM Subject: Similar Group Names ** I ran into an interesting problem today with group names that are similar.  One group is called Quest

Re: Similar Group Names

2008-09-17 Thread sam appecherla
Hi Shane, You may like to try changing the QBE value to 'Exact' for the Group field (field properties) in the Group form. Regards, SriSamSri Appecherla Mobile# +91 991 610 6008 On Thu, Sep 18, 2008 at 4:03 AM, Shane Buchholz [EMAIL PROTECTED]wrote: ** I ran into an interesting problem

Re: Similar Group Names

2008-09-17 Thread Axton
That's probably not going to help and it is ill-advised to change the core forms (e.g., User, Group). You should always use the run process command that checks group membership based on groupid or use an equal comparison. Axton Grams On Wed, Sep 17, 2008 at 10:18 PM, sam appecherla [EMAIL

Re: Similar Group Names

2008-09-17 Thread Joe DeSouza
PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, September 17, 2008 11:00:42 PM Subject: Re: Similar Group Names That's probably not going to help and it is ill-advised to change the core forms (e.g., User, Group).  You should always use the run process command that checks group membership based