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


Recent Events
  • 23/11/2024 Black Friday 2024

    BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

  • 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.


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?

Cellspacing and cellpadding for SQL Table
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Cellspacing and cellpadding for SQL Table
#46336
Cellspacing and cellpadding for SQL Table 10 Years, 12 Months ago Karma: 0
Hi,

I'm trying to format a table of results in ARI SQL Table plugin.

In your example given with the plugin how would you set the cellspacing or cellpadding on the results?

{arisqltable}
{arisqltablecolumns}
{arisqltablecolumn id="ID" alias="ID" width="20%" className="idg"}
{arisqltablecolumn id="NAME" alias="UserName" headerClassName="head"}
{/arisqltablecolumns}
{arisqltablequery}
SELECT id AS ID, name AS NAME
FROM #__users
{/arisqltablequery}
{/arisqltable}





A second question, is it possible to add a column which can contain data which is not from the database, I'm going to be returning a single row of results and want to be able to add text into the first column as below:


My Text ¦ My Data from database column 1 ¦ My data from database column 2



Thanks
The administrator has disabled public write access.
 
#46341
Re:Cellspacing and cellpadding for SQL Table 10 Years, 12 Months ago Karma: 760
Hello,

1. Use cellPadding and cellSpacing attribute of {arisqltable} tag. For example

{arisqltable cellPadding="6" cellSpacing="3"

2. Use a virtual column:

{arisqltablecolumn alias="Virtual Column" virtual="true" pos="1"}
{coltemplate}Some text goes here{/coltemplate}
{/arisqltablecolumn}

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