Jump to content

jeff8j

Members
  • Posts

    222
  • Joined

  • Last visited

Contact Methods

  • Website URL
    http://www.centrexity.com

Profile Information

  • Gender
    Not Telling

jeff8j's Achievements

Advanced Member

Advanced Member (4/5)

0

Reputation

1

Community Answers

  1. That was it! I thought it was something more complicated I didnt make these sql statements im just converting a script so didnt have any say in the or Thank you guys!
  2. @Jacques1 would that be more efficient? Also did you format that by hand or use a tool? I came across another one that throws something into the mix I dont know anything about the LEFT JOIN SELECT `or`.order_recurring_id, `or`.order_id, `or`.reference, `or`.`status`, `or`.`date_added`, CONCAT(`o`.firstname, ' ', `o`.lastname) AS customer FROM `order_recurring` `or` LEFT JOIN `order` `o` ON (`or`.order_id = `o`.order_id) ORDER BY or.order_recurring_id DESC LIMIT 0,20 Query Error: near "or": syntax error Unable to execute statement Im assuming its the first `or` where the error is but it looks good to me (is there a way to tell where a sqlite error occured? like character count or something)
  3. Took some trys but I think that might just have been the issue SELECT a.key, a.data, a.date_added FROM (SELECT ('customer_' || ca.key) AS `key`, ca.data, ca.date_added FROM `customer_activity` ca UNION SELECT ('affiliate_' || aa.key) AS `key`, aa.data, aa.date_added FROM `affiliate_activity` aa) a ORDER BY a.date_added DESC LIMIT 0,5 That looks like it works! Thanks so much!
  4. I have been converting mysql to sqlite and for basic queries have had good success but I ran across this one I can figure out how to convert its a bit over my head can someone help SELECT a.key, a.data, a.date_added FROM ((SELECT ('customer_' || ca.key) AS `key`, ca.data, ca.date_added FROM `customer_activity` ca) UNION (SELECT ('affiliate_' || aa.key) AS `key`, aa.data, aa.date_added FROM `affiliate_activity` aa)) a ORDER BY a.date_added DESC LIMIT 0,5 I get this error Query Error: near "UNION": syntax error Unable to execute statement Thanks
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.