That may not work as it appears you need a quote on both sides of $Product$ after it resolves your operation.
Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of L. J. Head Sent: Tuesday, October 02, 2007 4:14 PM To: [email protected] Subject: Re: Why does this set fields action fail? How bout "'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:32 PM To: [email protected] Subject: Re: Why does this set fields action fail? 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: [email protected] 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: [email protected] 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: [email protected] 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: [email protected] 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"
