Dave
|
| Posted: 07/02/2002, 9:05 AM |
|
Hi
I had a site published in php/mysql which included the following lookup sql in field properties:
select school_id, concat(school, ', ', local_area) as school_details from srstable order by school
However, I had to change the site to Access/Coldfusion and now this does not work. The message I get is
[Microsoft][ODBC Microsoft Access Driver] Undefined function 'concat' in expression
I do not know what to replace concat with.
Can anyone put me straight please?
Thanks
Dave S
PS swapping the data from mysql to Access was lengthy, but swapping from php to Coldfusion was the work of a few seconds using CC. Absolutely superb for someone like me who's still only a little way along their learning curve.
|
|
|
 |
Chris K.
|
| Posted: 07/02/2002, 9:27 AM |
|
Use following query intead:
select school_id, school & ', ' & local_area as school_details from srstable order by school
& is JET's concatenation operator
|
|
|
|
Dave
|
| Posted: 07/09/2002, 9:46 AM |
|
works now - thanks very much
|
|
|
|
|
