DMXzone Database Connector PHP Support Product Page
Can I concatinate three fields in a query?
Asked 13 Oct 2014 13:06:19
1
has this question
13 Oct 2014 13:06:19 Peter Hoyt posted:
I need to concatinate a firstname, middle name, and last name fields in a employee lookup query so that a select item on a form shows an employee's full name. I used to do that with a stored procedure in the database and just call it with DW. Is this possible with the Database Connector's query ability? Replies
Replied 13 Oct 2014 15:05:09
13 Oct 2014 15:05:09 Teodor Kuduschiev replied:
Hi Peter,
Are those stored in 3 different database fields?
Are those stored in 3 different database fields?
Replied 13 Oct 2014 16:06:58
13 Oct 2014 16:06:58 Peter Hoyt replied:
Hello,
Yes, they are stored in multiple fields.
Yes, they are stored in multiple fields.
Replied 13 Oct 2014 19:17:38
13 Oct 2014 19:17:38 Teodor Kuduschiev replied:
Hi Peter,
You can add the names like:
...
<option...>{{firstname}} {{secondname}} {{thirdname}}</option>
...
You can add the names like:
...
<option...>{{firstname}} {{secondname}} {{thirdname}}</option>
...