Displaying a database record set in a table

Squiz Matrix Support
1

I am trying to find a way to run a select statement on a given database and display the results in a table format.


Does anyone know if Squiz has the ability to do this, and if so where I would start looking in the documentation?



Cheers



:blink:

2

Yes! This is a fairly simple task with the DB Data Source asset, and a basic asset listing.


Note that the DB Data Source asset is in the data package, which has only just become GPL since 3.20 (stable due for release in the first week of January).

3

Are you talking about just the DB Data Source asset, or the entire Data package? I have 3.20 RC1 installed and I don't have either.
4

Oh! I’m so sorry. I lied :frowning:
http://matrix.squiz.net/developer/changelogs/3.20.x/3.18.x-3.20.0RC1



It’s only bulkmail, calendar, e-commerce and search (I was thinking of search…). :unsure:

5

The data manual is the best place to look for information, available from the client-access section of the Matrix website


http://matrix.squiz.net/resources/documentation

6

[quote]The data manual is the best place to look for information, available from the client-access section of the Matrix website


http://matrix.squiz.net/resources/documentation[/quote]



Thanks for the info.



Just what I was looking for.



Cheers

7

Hi,


I’m trying to use the DB Connector and DB Data Source to access my Oracle database so I can add two numbers! I’ve setup my DB Connector with the correct user details. I’ve added my connector asset to my DB Data Source. I’ve read the Data manual that says:



If the database details are incorrect, a MySource Warning will be shown indicating that it cannot connect to the database.



When I try and access the Query builder screen for my DB Data Source asset Squiz stops responding and after 1 minute I get the 504 error:



Could not load children: Server returned HTTP response code : 504 for url: http://… etc



I would assume that the account details are correct as I am not getting any MySource Warning but the account dose not have the correct privileges to perform some task in the database!!! I’m using v3.18.9. I can connect direct to the Oracle database with the user settings I am using in Squiz and I am able to create table with that user etc…



Any thoughts very welcome.



Cheers



[color="#FF0000"]Just read this back and it is getting off the point of the Group. I’ll start a new thread in support.