What's Wrong with My "Where" Clause?

> However, when I add an "AND" to the Where clause, it complains:

What the exact error message?

--
Regards

John Waller

What complains? DW? Your SQL server?


"jasons" <webforumsuser@macromedia.com> wrote in message
news:ebqjjl$du6$1@forums.macromedia.com...
> The Where clause in this statement generated by DW works fine:
>
> "SELECT * FROM qryGetMessages Where MemberID = " +
> Replace(rsShowData__MMColParam, "'", "''") + ""
>
> However, when I add an "AND" to the Where clause, it complains:
>
> "SELECT * FROM qryGetMessages Where MemberReplyID = 1 AND MemberID = " +
> Replace(rsShowData__MMColParam, "'", "''") + ""
>
> I've tried adding "MemberReplyID = 1" to the end of the clause but to no
> avail. Obviously, I am missing something. Please forgive my SQL
> ignorance and
> accept my thanks for any assistance.
>
>
>
>