[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date ][Interchange by thread ]

[ic] perl sql query more than 1 inner join?

To: interchange-users@interchange.redhat.com
Subject: [ic] perl sql query more than 1 inner join?
From: Brian Kosick <briank@nacs.net>
Date: Mon, 29 Oct 2001 11:52:58 -0500

Hello again,
         I realize that sql lookups through the [query] tag is limited to 1 
join.  My question is if you drop to a [perl] tag, and use the 
$db->query($sql) syntax can you use more than one join?  I have a simple 
query that I'm working on that I can't seem to get to work in IC but works 
from the psql prompt.



Brian Kosick
Web Programmer
New Age Consulting Service, Inc.
216-619-2000
briank@nacs.net

_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users

Follow-Ups:
- Re: [ic] perl sql query more than 1 inner join?
  - From: Jon Jensen <jon@redhat.com>
- Re: [ic] perl sql query more than 1 inner join?
  - From: racke@linuxia.de (Stefan Hornburg (Racke))

Prev by Date: Re: [ic] Flypage, multiple product tables, and [item-field]
Next by Date: Re: [ic] Flypage, multiple product tables, and [item-field]
Prev by thread: Re: [ic] Items not appearing in front end
Next by thread: Re: [ic] perl sql query more than 1 inner join?
Index(es):
- Date
- Thread