-
dbDisplayLookup could not do first_name & '' & last_name
Hi,
I tried to follow closely the example to join first_name & last_name
together, but somehow I still got the error.
If I omit the &''& last_name , it then can show first_name correctly.
Thanks for your time & looking forward for your reply,
Adhitya
x.dbDisplayLookupList="(;|)contact_prsn_id||se lect contact_prsn_id, first_name & '' & last_name as Name FROM databasename.contact_person;"
----Error message:---------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid operator for data type. Operator equals boolean AND, type equals varchar.
/editlab.asp, line 150
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|