[SOLVED] Query Field for Displaying Link

Additionally, attached is a screenshot of the exact same query (pasted) in phpMyAdmin... (query1.png)
And a screenshot of the query in CB query parameters (query2.png)

Just to reiterate... I AM NOT trying to do a query validation... just using the query field to display a list of results from the DB. Please don't send more instructions on validation... this only concerns the query field type.

tjohns92109 wrote: Additionally, attached is a screenshot of the exact same query (pasted) in phpMyAdmin... (query1.png)
And a screenshot of the query in CB query parameters (query2.png)

Just to reiterate... I AM NOT trying to do a query validation... just using the query field to display a list of results from the DB. Please don't send more instructions on validation... this only concerns the query field type.

Question: is the table in the same database as Joomla?

Yes. Same database.

You're selecting multiple rows without setting it to multiple row output. Try the below usage to limit it to a single row.


To output multiple rows you'd need to use the following usage.

Query: Output: Multiple Rows
Row:

Strange... I copied your query into the query parameter. It worked to return a single row. I compared it character by character to the one that didn't work and don't see the slightest difference (even checked the backticks and single quotes). Maybe a caching issue or there was a hidden character that I copied before.

Anyway, thanks for repeating that query because it does seem to work now.

You are correct in thinking I want to return more than 1 row. I put the div in the row field and it works!!! I was losing faith haha.

Quick additional question... that query returns rows that have the user_id of the profile that the field is on. Is there a way to echo rows from the user that's logged in? Do I need to get and declare that variable (as in $user = JFactory::getUser())? Or is it already available?

Quick additional question... that query returns rows that have the user_id of the profile that the field is on. Is there a way to echo rows from the user that's logged in? Do I need to get and declare that variable (as in $user = JFactory::getUser())? Or is it already available?

It supports standard substitutions too. So if you want to substitute in their username for example you could do [username]. See the below for substitution usage information.

www.joomlapolis.com/support/tutorials/107-use-cases/18353-using-substitutions-throughout-cb