Query builder

[kalastaja]

Why doesn't query builder accept my constant (CAMPAIGN_LIMIT), when table name (TABLE_CUSTOMERS) is accepted?

SELECT customers_email_address, customers_firstname, customers_lastname 
FROM TABLE_CUSTOMERS 
WHERE customers_campaign >= CAMPAIGN_LIMIT 
ORDER BY customers_lastname, customers_firstname, customers_email_address

[Limitless]

Why doesn't query builder accept my constant (CAMPAIGN_LIMIT), when table name (TABLE_CUSTOMERS) is accepted?

SELECT customers_email_address, customers_firstname, customers_lastname 
FROM TABLE_CUSTOMERS 
WHERE customers_campaign >= CAMPAIGN_LIMIT 
ORDER BY customers_lastname, customers_firstname, customers_email_address

Not sure where customers_campaign came from? but use lower case and check your table name (customers vs TABLE_CUSTOMERS)

SELECT customers_email_address, customers_firstname, customers_lastname 
FROM customers 
WHERE customers_campaign >= campaign_limit 
ORDER BY customers_lastname, customers_firstname, customers_email_address

[kalastaja]

Sorry, I don't get it! The TABLE_CUSTOMERS is defined (in upper case), why should I use lower case? I have added the "customers_campaign" for my own purposes and the whole thing works if I substitute 1000 for the CAMPAIGN_LIMIT! This issue would seem to require deep knowledge of the query builder...

[Limitless]

I thought you were using the default zen cart customer table which is customers, not TABLE_CUSTOMERS.

If these are custom designed tables and fields, you will need to describe them.


DESCRIBE TABLE_CUSTOMERS;


Is campaign_limit an INT, VARCHAR, etc?

try quoting your 'campaign_limit'

[kalastaja]

Everything eccept "customers_campaign >= CAMPAIGN_LIMIT" is STARDARD query builder! "TABLE_CUSTOMERS" IS customers in query builder! CAMPAIGN_LIMIT (not campaign_limit) is

define ('CAMPAIGN_LIMIT', '1000');

just as

define('TABLE_CUSTOMERS', DB_PREFIX . 'customers');

We are talking MySQL as far as I can understand! This issue would seem to require deep knowledge of the query builder...
TABLE... might be treated differently in query builder - that's what I need to know!
Quoting didn't do the trick.

[DrByte]

The only constants accepted by query_builder are tablenames.