[ic] query tag usage
Jonathan Clark
interchange-users@icdevgroup.org
Mon Jun 9 17:04:00 2003
> Okay, I'm stumped.
>
> I'm trying to do use the query tag in IC 4.9.7 to pull some data from a
> MySQL 4.1 database, and haven't gotten too far. The following code:
>
> ----------------------------------------
> [query
> sql="select * FROM nc_authorarticle where articleID = '31'"
> type=list
> list=1
> more=1
> ml=100
> st=db
> ]
> [on_match]
> Match:[sql-field authorDisplay] [sql-field articleID]
> [sql-field authorship]<br>
> [/on_match]
> [/query]
[query
sql="select * FROM nc_authorarticle where articleID = '31'"
type=list
list=1
more=1
ml=100
st=db
]
[on_match]
Got a match
[/on_match]
[list]
Match:[sql-param authorDisplay] [sql-param articleID]
[sql-param authorship]<br>
[/list]
[/query]
As you have a more=1, you probably want a [more] [/more] section as well.
Jonathan
www.webmaint.net