I was just looking at your original posting.. yes you tried everything but the right one :-) I didn't notice you had put down all what you tried..
This would be the correct one... the only one you hadn't tried.. "'Manager*' = " + """" + $col_MgrName + """" Joe ----- Original Message ---- From: Eli Schilling <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, April 5, 2007 3:37:18 PM Subject: Re: HELP - Building EXTERNAL table qual using table loop ** Perfect...I think I tried every combination of double quotes except that one. Works like a charm. Thanks Joe! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Thursday, April 05, 2007 12:32 PM To: arslist@ARSLIST.ORG Subject: Re: HELP - Building EXTERNAL table qual using table loop ** Eli, Have you tried to put the double quotes within double quotes??? That has worked for me.. Write to me offline if you still cannot figure how to include those double quotes before and after the $col_name$.. Joe ----- Original Message ---- From: Eli Schilling <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, April 5, 2007 3:24:18 PM Subject: HELP - Building EXTERNAL table qual using table loop ** 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 Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ ____________________________________________________________________________________ Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
