I think you use 4 Quotes...one to start the string...two to represent a single quote within the quoted text...and a 4th to close the text string
"'Manager*' = " + """" + $col_MgrName + """" _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, April 05, 2007 1:35 PM To: [email protected] Subject: Re: HELP - Building EXTERNAL table qual using table loop ** I believe you need to include three sets of quotes for each one: "'sddsdsdsd' = """ + $Status$ + """" Also, you may need to store the column data in display only fields and then use them in your qualification. I remember having an issue where I was referring to the column and the table looping would not work. Switched to using display only fields and it worked. On 4/5/07, Eli Schilling <[EMAIL PROTECTED]> wrote: ** So I need to build an EXTERNAL qualification using a table loop. When the user opens a form there is a hidden table that looks to another form to determine associations. The table loop builds a list of these associates into a qualification (i.e. ['Manager*' = $col_MgrName$ OR 'Manager* = $col_MgrName$...] etc) and sets a field with this value. The EXTRNAL qual on the table then grabs this field. The problem is I can't get double quotes around the column value. So I end up with 'Manager*' = Steve Smith...and of course without the double quotes the qualification fails. Can someone tell me what I'm missing? I have tried: "'Manager*' = " + $col_MgrName "'Manager*' = " + """ + $col_MgrName + """ "'Manager*' = " + """"" + $col_MgrName + """"" Thanks in advance! Eli __20060125_______________________This posting was submitted with HTML in it___ -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com <http://www.specificintegration.com> 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
