Yes ! That works too !
I just wanted to be as....analytic as I could ...
Can the members of the development team verify that is indeed a typo and not some hidden logic we fail to comprehend ?
Many thanks BlindSide for looking into this
Results 1 to 7 of 7
Hybrid View
-
14 Jul 2010, 09:01 AM #1
New Zenner
- Join Date
- Nov 2008
- Posts
- 9
- Plugin Contributions
- 0
Re: Problematic code in advanced search result ?
-
14 Jul 2010, 10:20 AM #2
New Zenner
- Join Date
- Nov 2008
- Posts
- 9
- Plugin Contributions
- 0
Re: Problematic code in advanced search result ?
Hmmm...another one....
Just before the problematic (?) SELECT, there is another strange thing...
I have no idea why it sums the tax rate, especially since this returned column (tax_rate) is not used anywhere belowPHP Code:SUM(tr.tax_rate) AS tax_rate
Any ideas to close this are most welcomed....
John
-
15 Jul 2010, 03:19 PM #3
Totally Zenned
- Join Date
- Sep 2004
- Posts
- 1,388
- Plugin Contributions
- 4
Re: Problematic code in advanced search result ?
You're welcome! I have passed along your thread to the team to make sure they see it, in order to confirm it's a bug.
On your second one, I'd wager a guess that a whoever did that was copy/pasting code from another section, and simply left it alone. In a project of this size, reusing code in this fashion is dogma. Why run the risk of introducing a problem when you borrow something that you know already works?
-
1 Mar 2011, 09:26 PM #4
Sensei
- Join Date
- Jan 2004
- Posts
- 66,446
- Plugin Contributions
- 81
Re: Problematic code in advanced search result ?
Are you still seeing this on v1.3.9?
.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole
Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.
-
3 Mar 2011, 04:52 PM #5
Oji-san
- Join Date
- Jun 2003
- Location
- Newcastle UK
- Posts
- 2,930
- Plugin Contributions
- 4
Re: Problematic code in advanced search result ?
Also, could you share some more details of your exact tax_rate setup.
From the details you posted you have multiple tax rates, even though you should need only one ?
Reply With Quote
Similar Threads
-
v154 Advanced search result display (custom field)
By chadlly2003 in forum General QuestionsReplies: 12Last Post: 5 Jun 2016, 09:50 PM -
v151 [Done v1.6.0] Advanced Search Result alpha_filter_id included twice in GET parameters
By torvista in forum Bug ReportsReplies: 1Last Post: 29 Aug 2013, 04:46 AM -
Advanced Search Result error 1064 You have an error in your SQL syntax;
By baracudamax in forum General QuestionsReplies: 10Last Post: 4 Oct 2010, 11:08 PM -
css override on advanced search result
By weirdorecords in forum Templates, Stylesheets, Page LayoutReplies: 2Last Post: 24 Jun 2010, 12:19 AM
