Click here to Skip to main content
15,891,431 members

Comments by NeonMika (Top 39 by date)

NeonMika 15-Apr-14 10:22am View    
Thank you for the link!
NeonMika 7-Jan-14 5:45am View    
Thanks for your help. Yes, it's some legacy code and concatinates strings to generate the query.
I think it's the best way to rebuild the whole query with a parameterized query.
NeonMika 7-Jan-14 5:40am View    
Yeah I know that it's as good as nothing, but I thought probably someone knows a little better than me how to interpret MS SQL Server error messages...
You can find countless internet threads on Incorrect syntax near ',' or Incorrect syntax near '(' but I cannot find any about Incorrect syntax near ' '...
I don't want to know where exaclty the error is, but I could probably minimize the space where to search.
NeonMika 7-Jan-14 5:39am View    
Sorry, I can't because it's business code...
The "GetQuery"-method is about 500 lines of code and mostly contains of "if the filter is set add following line to the query" like
if (Translator.CurrentLanguageID == LanguageID.DE)
{
query = query.Replace("%%Language%%", "GD_Translation.TranslatedTextDE");
}

Furthermore the problem is that I don't have the exact executed SQL (I don't know which filters were set)

I'm sorry that i cannot post code, probably someone has some basic idea what an errer "near ' '" could point to.
NeonMika 22-Nov-13 15:00pm View    
It's just a little project for university to learn TAP.
It shouldn't matter which RSS feed it is.
But I found out a solution myself, but thanks for asking :)