Hi All,
When trying to save any one of many forms (not all, only some custom) on my ARS
7.5 patch 3 windows server with SQL 2005 I receive the following error:
ARERR [552] Failure during SQL operation to the database : Incorrect syntax
near '|'. #SQL Server 102#
The log shows:
*/SELECT name FROM filter WHERE (NOT '' LIKE ('%;'||name||';%')) AND filterId IN
(SELECT filterId FROM filter_set WHERE (assignShort LIKE
'%102\1\@\\\%\$ztmpFieldID\99\%') OR (assignShort LIKE '%102\1\@\\\%\99\%\\%'))
*/*** ERROR *** Incorrect syntax near '|'. (SQL Server 102)
Can anyone shed any light on this?
Thanks,
Sharon
404 2007257
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
