Posted by Johnny Ruin on 12/29/05 22:53

Hello everyone,

Thank you for your responses. My apologies for such a late reply.

Dan, you were right. Those weren't the queries that were being sent to
the server. I put the profiler to work and found the queries that I'm
being sent had a '#' wrapping the date. I had known about that issue
and put a line in to replace the #'s with quotes. I had misplaced my
pstrQuery->Replace call so that my logfile showed the single quotes
even though the # were being sent in .... so silly. Sorry I
bothered the group with it.

Mike, that missing space issue was my typo in presenting the question.
I was editing the original query so things would be closer to the
simplest case.

Hugo, thanks for that info. I found some stuff about that in the
"Writing International Transact-SQL Statements". Unfortunately this
string is the same string the user sees. I'm basically a pass
through, so it'd be special code to snag it and change. Seems to be
working, but if I have more date issues I'll revisit that element.

Thanks again for everyone's comments, and again, apologies for late
reply and foolish post. It just never pays to be in hurry does it?

[Back to original message]