Chris, Try "’Product’ LIKE $Product$ + " + """" + "%" + """"
What's happening with "’Product’ LIKE $Product$ + "%"" is, it takes "’Product’ LIKE $Product$ + " as one part of the string and doesn't not know what to do with % followed by "". In an operation that uses % there has to be a LIKE and since the LIKE is not found within the operation it know not what to do with it. Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Moore, Chris Sent: Tuesday, October 02, 2007 2: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 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.13.39/1044 - Release Date: 10/2/2007 11:10 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
