James, What does the code look like that builds/displays the comma-separated string?
What I'm getting at is, if you are simply able to specify the variable name, something like... "...IS IN <@VAR local$MyArray>" ...that assumes are *not* using the default APREFIX, ASUFFIX, etc. settings. The default is to display an array as a <table>, so perhaps somewhere in the execution, your overrides are being lost. Just my 2p... Jon -----Original Message----- From: James Macfarlane [mailto:[EMAIL PROTECTED]] Sent: 15 July 2002 22:19 To: Multiple recipients of list witango-talk Subject: Witango-Talk: IS IN array not working For the last few weeks we've been having a strange problem where a search action that uses IS IN function gives us an error even though the code hasn't changed. After dumping out the <@SQL> statement to the browser it seems that the array used in the IS IN is coming back as an HTML table of values, rather than an array. We've even had a query with three IS IN functions fail -- the first IS IN showed a string of comma-separated values (what you'd expect), but the other two arrays appeared as HTML tables. This is driving us nuts! HELP! - James. ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
