[ic] PREFIX-param behaviours

Dan Browning interchange-users@icdevgroup.org
Thu Sep 5 18:05:01 2002


At 12:26 AM 9/6/2002 +0300, you wrote:
>Hi,
>
>I have a joined query ([query prefix="foo" list=1 sql="..."], and I use for
>some of my select fields the tablename.fieldname reference. When I then want
>to use that value with [foo-param tablename.fieldname] I get an empty value.
>
>Is this a normal behaviour, or did I screw up something somehow?
>
>Regards, Rene

[Should make it into the FAQ sometime]

tablename.fieldname notation isn't supported by Interchange, use:

SELECT
         table_a.field AS table_a_field
         table_b.field AS table_b_field
         ...

/~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\
| Dan Browning, Kavod Technologies      <dan.browning@kavod.com> |
| (360) 882-7872 x7, 6700 NE 162nd Ave, Suite 210, Vancouver, WA |
\~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~/
Immigration is the sincerest form of flattery.
                 -- Jack Paar