[SOLVED] Concantinate in List and Print Views

This topic is locked

[SOLVED] Concantinate in List and Print Views	4/21/2011 1:59:32 PM
PHPRunner General questions
D DouglasB author I know I can use the "Concan" command in mysql and even as a Custom Type in a field EDIT AS situation in the Visual Editor. What I want to do is a little different and I'm not sure how to proceed, may be I'm thinking about it too much. Anyway what I want to do for my Contact Management mySQL/phpRunner project is to make the LIST and PRINT view concantinate the fields [tbl_contact].[str_FName], [tbl_contact].[str_MI],and [tbl_contact].[str_LName] into one field on the views. I do not actually want to combind those fields in the database just as a display thing on the LIST and Print views. Am I making sense? Anyone have any suggestions? DouglasB

Mark as Solved Mark as not solved

2 replies


	Sergey Kornilov admin 4/21/2011
	I would modify SQL Query for this table: `select str_FName, str_MI, str_LName, concat(str_FName,str_MI,str_LName) as FullName from ...`


D	DouglasB author 4/21/2011
	I would modify SQL Query for this table: `select str_FName, str_MI, str_LName, concat(str_FName,str_MI,str_LName) as FullName from ...` Well duh! Told you I was thinking about it too hard. Thanks.

2 replies

Mark as Solved Reply