[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