[ic] list tag in query tag
Stefan Hornburg
interchange-users@icdevgroup.org
Wed Apr 23 15:16:00 2003
On Wed, 23 Apr 2003 11:32:23 -0700 (PDT)
Ryan Grace <ryan_grace@yahoo.com> wrote:
> Hi All,
>
> I've searched the archives for a clue on this one, but
> am coming up blank. I'm having trouble with a list
> within a query tag.
>
> Here's what I'm doing:
>
> [tmp retailer_query]
> select name, street1, street2, city, state, zip,
> phone, priority
> from retailer
> where
> [if cgi a]
> phone like '([cgi a])%'
> or phone like '[cgi a]-%'
> [elsif cgi z]
> zip like '[cgi z]%'
> [/elsif]
> [/if]
> and 1=1
> order by priority desc
> [/tmp]
>
> which is used in:
>
> [query sql=|[scratch retailer_query]| list=1]
> [no_match]
> <p>There were no retailers found in your area.</p>
> <p>You may [page retailers/index]Go Back[/page]
> and try again.</p>
> [/no_match]
>
> [list]
> <p>[sql-param name]<br>
> [sql-param street1]<br>
> [if sql-param street =~ /\w+/][sql-param
> street2]<br>[/if]
> [sql-param city], [sql-param state] [sql-param
> zip]<br>
> [sql-param phone]</p>
> [/list]
> [/query]
>
> The problem is that the [if] tag for street2 in the
> [list] evaluates to true for every list iteration.
> I've also tried this without luck:
>
> [if sql-param street2 !~ /^\s*$/][sql-param
> street2]<br>[/if]
>
> Most of the entries returned from the database have a
> blank street2 field. Can anyone see anything
> obviously wrong with what I'm doing here?
Beep. Invalid syntax. Try [if-sql-param street2] ... [/if-sql-param]
Bye
Racke