| Subject | Calculated SQLField: Conversion Error from String |
|---|---|
| Author | jwcane2003 |
| Post date | 2012-08-08T02:52:53Z |
Trying to create a sql result that, when painted in html, generates an email link. Would you please show me what is wrong. Using the following query:
select '<a href="mailto:' + r.email + '">' + r.ResLast +'</a>' as ResLast
from Residents r where kRes = 26
================
This returns the correct table data, but generates the following error:
ISC ERROR CODE:335544334
ISC ERROR MESSAGE:
conversion error from string "jwcane@..."
STATEMENT:
frmSQL.crEdit(TIB_Cursor)
================
The email address is correct.
What is wrong with the syntax for adding the email address, and how can I avoid the conversion error?
select '<a href="mailto:' + r.email + '">' + r.ResLast +'</a>' as ResLast
from Residents r where kRes = 26
================
This returns the correct table data, but generates the following error:
ISC ERROR CODE:335544334
ISC ERROR MESSAGE:
conversion error from string "jwcane@..."
STATEMENT:
frmSQL.crEdit(TIB_Cursor)
================
The email address is correct.
What is wrong with the syntax for adding the email address, and how can I avoid the conversion error?