J!Extensions Store™
Forum
Welcome, Guest
Please Login to access forum.
- Joomla! Extensions Store
Re:SQL for adding fields to custom URLs (1 viewing) 
Go to bottom
TOPIC: Re:SQL for adding fields to custom URLs
#3317
John Dagelmore
Admin
Posts: 3873
User Online Now
Re:SQL for adding fields to custom URLs Karma: 84  
Hello Glenn,

if you have configured a custom data source for EZ Realty and you want to concatenate SQL fields for the title you must use the CONCAT_WS in the raw SQL query.

For example if you have a query like this:

SELECT title FROM ....

you can concatenate fields like this:

SELECT CONCAT_WS(',','title','price','address' ) AS title FROM .....

Notice that this is used for the title not for the link and URL.

John
 
Logged Logged  
  The administrator has disabled public write access.
Go to top