SQL queries with CASE statement stop working after Office SP2

[canan]

In my ASP pages I had some SQL queries with CASE statements running. After I
installed MS Office SP2 they gave error messages. They display the results on
the web but when I open the page with FrontPage the database result region
shows red color instead of yellow, and I can't verify the query I had working
before. It gives database results wizard error, saying "The custom query
contains errors."
My other queries work fine if they don't have any CASE statements in them.
But the ones with CASE statement stop working. Any idea why?

 

[Stefan B Rusynko]

Have you tried recreating the query on a new page?




| In my ASP pages I had some SQL queries with CASE statements running. After I
| installed MS Office SP2 they gave error messages. They display the results on
| the web but when I open the page with FrontPage the database result region
| shows red color instead of yellow, and I can't verify the query I had working
| before. It gives database results wizard error, saying "The custom query
| contains errors."
| My other queries work fine if they don't have any CASE statements in them.
| But the ones with CASE statement stop working. Any idea why?

 

[canan]

I did try on a new page, it didn't help. The query is not the problem. It
works fine and displays the results on the page when I view the page but when
it comes to modify the query in FrontPage, the working query complains about
that error.

 

[alex]

I got exactly the same problem. The query was working perfectly fine before
the upgrade. Now I have to remove all the queries with CASE statement. Trying
to recreate them does not help. The same query is running perfect inside the
Query Analyzer. Any ideas?

Thanks,
Alex