[thelist] Really weird ASP problem

Mark Howells mark at mountain.ch
Fri Jan 25 06:10:01 CST 2002


>> SELECT name, update, boardpic FROM chapter WHERE id=99999
>>

Not sure whether that 'update' will cause a problem.

> [...] the above works where [...] "SELECT b.name, b.email,
> bp.bpname FROM board b, board_position bp WHERE b.position=bp.id and
> b.chapter='99999'" doesn't

Try ... FROM board AS b, ....

Regards
Mark Howells
<http://www.mark.ac/evl>




More information about the thelist mailing list