BEFORE BROWSE creating temporary table

[tovidiu]

I want to create a temporary table to browse a concatenated value from multiple rows from another tableg.
1. I created in php a #TABLE_ID#

1 php.png

2 . then I added suprafata_test to the browse table

2 browse.png

3. It doesnt work

Code: Select all

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'suprafata_test' in 'field list'

I am sure that I doing something wrong .......... can someone explain me how it works ?
Thank`s
Ovidiu

[Dep]

Hi Ovidiu,

In your SQL Builder, you will also need to add " #TABLE#.* " from #TABLE_ID#" in your SELECT statement because the program needs to know which table the 'suprafata_test' is coming from.

I cannot see the whole SELECT statement in the second picture you sent but this is what I can show to make it look complete.
SELECT
#TABLE#.*,
lucrare.*,
adresa.*,
terad.*,
localit.*,
strada.*,
lucrare_imobil.*
FROM
#TABLE_ID#,
lucrare,
adresa,
terad,
localit,
strada,
lucrare_imobil

Hope this helps!

[admin]

tovidiu,

You need to show us the whole SQL statement you're having a problem with.

Steven