Re: SQL queries with CASE statement stop working after Office SP2

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Have you tried recreating the query on a new page?

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp
_____________________________________________


"canan" <canan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:A4D8C53C-B44F-4554-B6A3-D224E0C35144@xxxxxxxxxxxxxxxx
| 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?


.

Quantcast