Okay, so I am attempting to nest a grid.
I have a grid displaying table pm_companies, within this grid I would like to nest table pm_tenants to match up with each company. So I have this syntax
SELECT
Company,
Tenant,
Address,
City,
Zip Code,
Phone
FROM
pm_tenants
WHERE Company = [Company]
and I get this error when I test it out…
[TABLE=“class: scErrorTable, align: center, cellpadding: 0, cellspacing: 0, width: 320, height: 30”]
[TR]
[TD=“class: scErrorTitle, align: left”]Error[/TD]
[/TR]
[TR]
[TD=“class: scErrorMessage, align: center”]Error while accessing the database:
Unknown column ‘CA Gold Properties’ in ‘where clause’
select count(*) from pm_tenants where Company = CA Gold Properties[/TD]
[/TR]
[/TABLE]
So I attempted to set the [Company] as [glob_Company] and I get a no global defined error. I have tried everything I know. Help please.