ARI Soft - ARISQLTABLE Problem: "select *" and "select field"

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

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

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

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Smart Content

ARISQLTABLE Problem: "select *" and "select field"

(1 viewing) (1) Guest

Page: 12

TOPIC: ARISQLTABLE Problem: "select *" and "select field"

Forum Tools

#10836

ARISQLTABLE Problem: "select *" and "select field" 13 Years, 9 Months ago	Karma: 1
Hi, i have a problem with different select statments. Everything works fine when i run a statement with "select *" or a select with only one column. When i try to run a select with minimum 2 fields i get a white page as result. I have this problem only with created tables of myself. With standard joomla tables(jos_xx) everything works fine. What do i wrong?

gramar82

The administrator has disabled public write access.

#10837

Re:ARISQLTABLE Problem: "select *" and "select field" 13 Years, 9 Months ago	Karma: 760
Hello, Could you provide code which you use and if possible temporary access to your Joomla! backend by email that we can investigate this issue? Regards, ARI Soft

admin

The administrator has disabled public write access.

#10838

Re:ARISQLTABLE Problem: "select *" and "select field" 13 Years, 9 Months ago Karma: 1

Sorry, at the moment i have the project only on my localhost.

Here is the used code:

This works:

Code:

{arisqltable}

    {ariconnectionstring dbHost="localhost" dbName="test" dbUser="root" 

	dbPass="" dbType="mysqli" persistent="false"}



    {arisqltablequery}

SELECT id AS ID,name AS NAME 

FROM jos_users

    {/arisqltablequery}

{/arisqltable}

This works:

Code:

{arisqltable}

    {ariconnectionstring dbHost="localhost" dbName="test" dbUser="root" 

	dbPass="" dbType="mysqli" persistent="false"}



    {arisqltablequery}

SELECT genre 

FROM dvds

    {/arisqltablequery}

{/arisqltable}

This don't work:

Code:

{arisqltable}

    {ariconnectionstring dbHost="localhost" dbName="test" dbUser="root" 

	dbPass="" dbType="mysqli" persistent="false"}



    {arisqltablequery}

SELECT genre,datum

FROM dvds

    {/arisqltablequery}

{/arisqltable}

gramar82

The administrator has disabled public write access.

#10839

Re:ARISQLTABLE Problem: "select *" and "select field" 13 Years, 9 Months ago	Karma: 760
Does this SQL query work fine in a SQL manager application like PHPMyAdmin? BTW, if you run SQL query on Joomla! database, you can omit {ariconnectionstring} tag. Regards, ARI Soft

admin

The administrator has disabled public write access.

#10842

Re:ARISQLTABLE Problem: "select *" and "select field" 13 Years, 9 Months ago	Karma: 1
Thanks for the tio to omit the tag. Yes, the query work fine in PHPMyAdmin. Also from an external SQL Manager.

gramar82

The administrator has disabled public write access.

#10847

Re:ARISQLTABLE Problem: "select *" and "select field" 13 Years, 9 Months ago	Karma: 1
Now i have tried to put the query into a view. Same problem here. A view with more then one field fails...

gramar82

The administrator has disabled public write access.

Page: 12

Useful Links