Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Another Minor Question
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Another Minor Question
#53773
Another Minor Question 9 Years, 3 Months ago Karma: 0
Hi,

See the attached image.

My table is showing a "0" where I would expect the name of the database field "ACFamily" to display. Any idea why?

This table is configured with this SQL,

SELECT
ACFamily, SimMaker, COUNT(DISTINCT uSimID) AS Count
FROM Simulators
WHERE
MarkForDeletion <> "1"
AND
({$REQUEST:vOrganization|empty:""} = '' OR Organization LIKE CONCAT('%',{$REQUEST:vOrganization|empty:""},'%'))
AND
({$REQUEST:vLocRegion|empty:""} = '' OR LocRegion LIKE CONCAT({$REQUEST:vLocRegion|empty:""},'%'))
AND
({$REQUEST:vLocCountry|empty:""} = '' OR LocCountry LIKE CONCAT({$REQUEST:vLocCountry|empty:""},'%'))
AND
({$REQUEST:vLocCity|empty:""} = '' OR LocCity LIKE CONCAT({$REQUEST:vLocCity|empty:""},'%'))
AND
({$REQUEST:vACMaker|empty:""} = '' OR ACMaker LIKE CONCAT({$REQUEST:vACMaker|empty:""},'%'))
AND
({$REQUEST:vSimType|empty:""} = '' OR SimType LIKE CONCAT('%',{$REQUEST:vSimType|empty:""},'%'))
GROUP BY
ACFamily,
SimMaker
ORDER BY
ACFamily,
SimMaker
Last Edit: 2015/03/11 18:07 By kefford.
The administrator has disabled public write access.
 
#53774
Re:Another Minor Question 9 Years, 3 Months ago Karma: 748
Hello,

It is possible to see the problem and have access to your J! backend?

Regards,
ARI Soft
The administrator has disabled public write access.
 
#53776
Re:Another Minor Question 9 Years, 3 Months ago Karma: 0
For now here is a screen grab of all the ARIDataTables settings. I am sure this is some setting that was not set properly. I have used many of these modules on my site with no issue, this is the only one with this problem.
File Attachment:
File Name: qSnap_Editor.zip
File Size: 677651
Last Edit: 2015/03/11 19:14 By kefford.
The administrator has disabled public write access.
 
#53777
Re:Another Minor Question 9 Years, 3 Months ago Karma: 0
also, for some reason my original post did not upload the image screen grab file. I attached it 3 times, not sure why. Maybe it thinks a 27kb file is too big, so let me attach again.
The administrator has disabled public write access.
 
#53778
Re:Another Minor Question 9 Years, 3 Months ago Karma: 0
To be clear, the problem is the "0" at the top of the first column. I would expect the column heading is the name of the field, which is "ACFamily".
The administrator has disabled public write access.
 
#53786
Re:Another Minor Question 9 Years, 3 Months ago Karma: 748
It is not possible to investigate the problem by this screenshot. Send screenshot(s) of module settings page or a link to a page where the problem occurs and temporary access to your J! backend by email so we can investigate the problem.

Regards,
ARI Soft
The administrator has disabled public write access.
 
Go to topPage: 1