[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