2. PHPRunner General questions
  3. [SOLVED]  Lookup table, custom expression - not working
This topic is locked
[SOLVED]

 Lookup table, custom expression - not working

 		10/21/2010 2:22:03 PM
PHPRunner General questions
S
 Shinzon author

Trying to get this to work but i can't. Got one table students with atributes ID, FirstName, LastName, Phone, CardNumber,...
When i try to display FirstName + LastName with custom expression in dropdown box i get zero. FirstName and LastName are VARCHAR. (FirstName+' '+LastName)

When i try to display ID + CardNumber i got sum of those two numers. ID and CardNumber are INT. (ID+' '+CardNumber)
So is that some error that can only show INT and not VARCHAR or my SQL expression is not correct?
Sergey Kornilov admin 10/21/2010

It all depends on what database do you use.
In MySQL you need to use concat() function. In MS Access you need to convert numbers to strings first using CStr() function.
S
 		Shinzon author 10/22/2010



It all depends on what database do you use.
In MySQL you need to use concat() function. In MS Access you need to convert numbers to strings first using CStr() function.


Concat is what I needed. Thank you very much!