nuBuilder Forum

First post, wonderful product..thanks.

I have a table fs_students and am pulling data from column nok_firstname from table fs_nok

You can see this in the page properties display section and is functioning correctly using fs_nok.nok_firstname
I would also like to add nok_lastname to that display.

I'm guessing it would be something similar to fs_nok.nok_firstname & " " & fs_nok.nok_lastname
I'm quite new to this, hope it makes sense
Is this possible?

With thanks

bobbyrabbit,

Try this (MySQL function)

CONCAT(fs_nok.nok_firstname, " ",fs_nok.nok_lastname);

Thanks for the quick reply. Where would I enter the CONCAT line, my current code in the SQL Builder is:

It can be added in the display field

Thanks, I put it in the display field initially, it was the semi-colon at the end of the code causing a problem. Now displays perfectly.
I get the information from a dropdown box in the edit section, how do I add the CONCAT code so it also shows first and last name in the dropdown box? Is that in the Form Object List section?

Yes, under Form Object List, then select the object and enter an SQL.

Thanks so much guys.
For reference, dropdown box fixed like so:

SELECT
fs_nok.fs_nok_id, CONCAT(fs_nok.nok_firstname, " ",fs_nok.nok_lastname)

FROM
fs_nok