in reply to SQL causing 500 error (was: What's Wrong With This?)

I don't have a database handy, so I can't check, but I have a sneaking suspicion you're actually passing two lines as the SQL query instead of one. You're passing:
select count(*) from userlist
and:
where colemail = \'$FORM{'email'}\';

instead of the whole in one go. Try putting both on one line, or putting in a line continuation character. Your DB documentation should tell you what that character should be (often a backslash \ ).

CU
Robartes-

Replies are listed 'Best First'.
Re: Re: What's Wrong With This?
by chromatic (Archbishop) on Oct 05, 2002 at 19:04 UTC

    I've never seen a database that sensitive to newlines. Which have you used that might be a problem?