Everything eccept "customers_campaign >= CAMPAIGN_LIMIT" is STARDARD query builder! "TABLE_CUSTOMERS" IS customers in query builder! CAMPAIGN_LIMIT (not campaign_limit) isjust asCode:define ('CAMPAIGN_LIMIT', '1000');We are talking MySQL as far as I can understand! This issue would seem to require deep knowledge of the query builder...Code:define('TABLE_CUSTOMERS', DB_PREFIX . 'customers');
TABLE... might be treated differently in query builder - that's what I need to know!
Quoting didn't do the trick.
Thread: Query builder
Results 1 to 6 of 6
Hybrid View
-
21 Oct 2012, 08:06 AM #1
Zen Follower
- Join Date
- Mar 2010
- Location
- Finland
- Posts
- 463
- Plugin Contributions
- 0
Re: Query builder
Last edited by kalastaja; 21 Oct 2012 at 08:12 AM.
Reply With QuoteSimilar Threads
-
v154 Help with a SQL Query for Query Builder
By lindasdd in forum Managing Customers and OrdersReplies: 2Last Post: 24 Mar 2016, 01:18 PM -
v151 SQL query setup. How do I TEST a query 'off-line'?
By lewisasding in forum General QuestionsReplies: 3Last Post: 8 Mar 2013, 12:24 AM -
Name Builder...errr... PC Builder?
By prosam in forum General QuestionsReplies: 3Last Post: 1 Oct 2010, 12:23 AM -
Query Builder Table syntax? - custom email groups
By mcarbone in forum General QuestionsReplies: 4Last Post: 22 Apr 2010, 10:57 PM -
Query Builder Hanging
By thomasharding in forum Managing Customers and OrdersReplies: 6Last Post: 6 Oct 2009, 09:25 AM
