It turned that into ( "'Product' LIKE " + $Product$) + "%" when I modified the action.
Trying it on the form, after selecting mdClassifieds from the list, it put 'Product' LIKE mdClassifieds% in the hidden field and the query isn't returning anything. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Tuesday, October 02, 2007 3:25 PM To: arslist@ARSLIST.ORG Subject: Re: Why does this set fields action fail? Woops! I mistyped. Try this: "'Product' LIKE " + $Product$ + "%" -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris Sent: Tuesday, October 02, 2007 2:17 PM To: arslist@ARSLIST.ORG Subject: Re: Why does this set fields action fail? Hey Norm, thanks for the response. Trying that gives me the following error: Unexpected character (AERR 2291) mdwAllTicketQualification [Assign line error at position 0] I was thinking since it's a string I had to use the double quotes, but there must be some special way to format it. ARS 6.3 but 7.1 clients, BTW. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 CS/SCCE Sent: Tuesday, October 02, 2007 3:07 PM To: arslist@ARSLIST.ORG Subject: Re: Why does this set fields action fail? Don't put the quotes around the field names. Like this: 'Product' LIKE $Product$ + "%" Instead of this: "'Product' LIKE $Product$ + "%"" -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Moore, Chris Sent: Tuesday, October 02, 2007 1:59 PM To: arslist@ARSLIST.ORG Subject: Why does this set fields action fail? ** Hey everyone- Hopefully this will be a simple question for someone! I made a display only form to act as sort of a QM control panel. There is a form on our system called AllTickets which contains basic information on all types of tickets- ID, Summary, Status, etc. The form I made has a table and 2 character fields with menus that correspond to fields on AllTickets. The idea is that users can select an item from the menu and get a list of all records on AllTickets that match. Once the user chooses a menu item, an active link sets a hidden field (mdwAllTicketQualification/mdwAllTicketQualificationRelease) for a qualification for the table. The table qualification is (EXTERNAL( $mdwAllTicketQualification$)) AND (EXTERNAL( $mdwAllTicketQualificationRelease$)) AND ( 'mdwLISTTicketNumber' LIKE ( "QM" + "%" )) AND ( 'mdwLISTStatus' != "Closed" ) AND ( 'mdwLISTStatus' != "Resolved" ) AND ( 'mdwLISTStatus' != "Rejected" ) AND ( 'mdwLISTStatus' != "Canceled" ) This works fine if I use an exact match: 'Product' LIKE $Product$ or 'Release' LIKE $Release$. However, we have a product called Classified. There are several versions, stored as Classifieds 2.x for example, so I want to be able to use wildcards. If I paste 'Product' LIKE $Product$ + "%" directly into mdwAllTicketQualification, it does what I want it to do and returns all records that start with Classifieds, but if I try and get an active link to set "'Product' LIKE $Product$ + "%"" into the field, I get an error that says "Data values are not appropriate for arithmetic operation." Apparently it's treating the % like a literal character. What do I have to do to get that string set into the field? I hope this is clear- let me know if you need clarification on the process. Thanks, Chris __20060125_______________________This posting was submitted with HTML in it___ ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
