Forum OpenACS Q&A: Re: sql query problem

Collapse
2: Re: sql query problem (response to 1)
Posted by Char Wang on
sorry, I posted a wrong souce code, my source code should be the following lines:

===========================================================
ad_page_contract {
    @author char.wang
    @creation-date 2003-7-14
}

set issue 113
set query1 "SELECT cm_magazine.issue FROM cm_magazine WHERE cm_magazine.issue = $issue"
set IfIssueExist [db_0or1row {dummy1} $query1]

set artID AXT1113

set query2 "SELECT cm_index.articleid FROM cm_index WHERE cm_index.articleid=$artID"
set cm2 [db_0or1row {dummy2} $query2]

ad_return_template
===========================================================