[ic] query tag usage

Jonathan Clark interchange-users@icdevgroup.org
Wed Jun 11 03:30:01 2003


> >> 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]
> >>
> > Change your [on-match]...[/on-match] to [list]...[/list].
>
> Tried it, but got the same results.  It seems to find the data that I
> want, but I just can't get it to display.

And did you try my reply which said to use [sql-param] instead of
[sql-field]?

Jonathan
www.webmaint.net