I do not understand your question.
So I explain what I did:
I have a query:
“SELECT wv62b_comprofiler.cb_addres, wv62b_comprofiler.cb_addressline2,
If( IsNull( cb_zip1 ) or cb_zip1 = "" ,
CONCAT(cb_city ," ",cb_zip2 ), CONCAT( cb_zip1, " ", cb_city , " ",cb_zip2 )) AS zCz,
wv62b_comprofiler.cb_country
FROM wv62b_comprofiler
WHERE wv62b_comprofiler.user_id= [user_id]”
in the field I have:
Mode: Internal
Output: Single Row
Columns: Multiple
Display Delimiter / Div
Name cb_address
Titel: Address
Location
Registration: Disable
Profile Edit Disable ( if I set to Enable then I have no selection: Public/Private
Profil Viewer: Enabled
Userlist View: Enabled
CB Privacy: Field privacy preferences:
Display: user can control privacy
Default: Public
Edit Display: Normal CB settings
Force Edit Display: Enable
In the I defined in Colum 3: Address
rh