Normal Topic Parentheses in a combo box selection (Read 1310 times)
NICEBERG
Full Member
Members
***
Offline


I came, I saw, I'm still
trying to figure it out!

Posts: 208
Location: Green Bay, WI
Joined: Dec 17th, 2003
Parentheses in a combo box selection
Jul 29th, 2006 at 1:27pm
Print Post Print Post  
Since upgrading to 1.1.4 from 1.1.2 I find that I cannot Search on a combo list item if the selected item includes parentheses. I have two selection items in the combo list containing parentheses and neither will Retrieve when I press F10. ALL OTHER items in the list retrieve successfully - none of which cotains the parantheses.

I would prefer to include the parentheses if at all possible. Is this doable, or am I relegated to doing a mass update on all records for those two items? (How would I retrieve them for a mass update??)

Thanks - hope someone is around this weekend!
Fred
« Last Edit: Jul 29th, 2006 at 5:18pm by NICEBERG »  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Parantheses in a combo box selection
Reply #1 - Jul 29th, 2006 at 1:51pm
Print Post Print Post  
Parenthesis have significance in a search spec. To search for a literal on a significant character that character must be "escaped". Either place a backslash in front of the character, i.e.: "\(one\)" or place an open square brace before the entire string "[(one)". Be aware that if you chose the latter method, all other significant characters in the search spec string will also be escaped.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
NICEBERG
Full Member
Members
***
Offline


I came, I saw, I'm still
trying to figure it out!

Posts: 208
Location: Green Bay, WI
Joined: Dec 17th, 2003
Re: Parentheses in a combo box selection
Reply #2 - Jul 29th, 2006 at 3:22pm
Print Post Print Post  
I understand that, but why would this have changed in 1.1.4? I was able to do a Search on the items in question with no problems in 1.1.2. Example:
Combo box (first element on the form) contains:
5400-BO Boiler
5400-SS Super Single
5400-FO Single Folder (Small)
5400-PC Rewinder (IR505)

In 1.1.2 I would enter Search mode, select 5400-PC (IR505), press F10, and all of the records matching the retrieve spec would appear on screen, as expected. Now, either selection with (Small) or (IR505) returns nothing. All items without the parentheses return as before. There were no programming changes made since upgrading to 1.1.4, yet I've lost functionality.

Why are the parentheses treated differently between the two versions?

(Glad to see someone around this weekend. I was pretty lonely last weekend!)
Fred
« Last Edit: Jul 29th, 2006 at 5:19pm by NICEBERG »  
Back to top
 
IP Logged
 
NICEBERG
Full Member
Members
***
Offline


I came, I saw, I'm still
trying to figure it out!

Posts: 208
Location: Green Bay, WI
Joined: Dec 17th, 2003
Re: Parentheses in a combo box selection
Reply #3 - Jul 29th, 2006 at 8:16pm
Print Post Print Post  
btw - I was only kidding when I asked how I would retrieve the specs for a mass update! I will be doing this tomorrow to rid myself of the troublesome parenthesis.
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Parentheses in a combo box selection
Reply #4 - Jul 29th, 2006 at 9:20pm
Print Post Print Post  
Quote:
but why would this have changed in 1.1.4? I was able to do a Search on the items in question with no problems in 1.1.2


I think that was probably a bug in 1.1.2, and (Ray may correct me) corrected in 1.1.3.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
NICEBERG
Full Member
Members
***
Offline


I came, I saw, I'm still
trying to figure it out!

Posts: 208
Location: Green Bay, WI
Joined: Dec 17th, 2003
Re: Parentheses in a combo box selection
Reply #5 - Jul 30th, 2006 at 9:42am
Print Post Print Post  
Gee, I kinda liked that "bug" - can we put it back in?? LOL

Makes sense now. I made the corrections and mass updates. Thanks Mark.
  
Back to top
 
IP Logged