Implementing a "special" Access database to Expression Web

Posted by Newbie on Stack Overflow See other posts from Stack Overflow or by Newbie
Published on 2010-06-13T19:44:50Z Indexed on 2010/06/13 20:02 UTC
Read the original article Hit count: 371

Filed under:
|
|

I have just got an answer to my question about combining the result of a SQL. This was done with "ConcatRelated". Now I want to implement this in Expression Web 3.

The SQL's I used in Access:

SELECT land.id, land.official_name, vaksiner.vaksiner
FROM land INNER JOIN (vaksiner INNER JOIN land_sykdom ON vaksiner.id = land_sykdom.sykdom) ON land.kort = land_sykdom.land
ORDER BY land.official_name;

and

SELECT DISTINCT id, official_name, ConcatRelated("vaksiner","qryVaksinerRaw","id = " &    [id]) AS vaksiner
FROM qryVaksinerRaw;

The last is saved as vaksine_query

This is the SQL that I want to add to Expression Web:

SELECT vaksine_query.id, vaksine_query.official_name, vaksine_query.vaksiner
FROM vaksine_query
WHERE vaksine_query.id="?";

Expression Web gives me the error message "Undefined function 'ContactRelated' in expression.

© Stack Overflow or respective owner

Related posts about sql

Related posts about ms-access