[thelist] Really weird ASP problem

rudy r937 at interlog.com
Thu Jan 24 13:30:00 CST 2002


>The query is this:
>
>   SELECT b.name, b.email, bp.bpname
>      FROM board b, board_position bp
>  WHERE b.position=bp.id
>        and b.chapter='99999'

hi jason

so b.chapter is a charcater field?

your original post had

query = "SELECT b.name, b.email, bp.bpname "
query = query & "FROM board b INNER JOIN board_position bp "
query = query & "ON b.position=bp.id "
query = query & "WHERE b.chapter="&chapter_id

how are you putting the single quotes around &chapter_id?

rudy




More information about the thelist mailing list