实施“特殊”访问 Expression Web 数据库
我刚刚得到了关于合并 SQL 结果的问题的答案。这是通过“ConcatRelated”完成的。现在我想在 Expression Web 3 中实现这一点
。我在 Access 中使用的 SQL：
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;
最后
SELECT DISTINCT id, official_name, ConcatRelated("vaksiner","qryVaksinerRaw","id = " & [id]) AS vaksiner
FROM qryVaksinerRaw;
一个保存为 vaksine_query
这是我想要添加到 Expression Web 的 SQL：
SELECT vaksine_query.id, vaksine_query.official_name, vaksine_query.vaksiner
FROM vaksine_query
WHERE vaksine_query.id="?";
Expression Web 给我错误消息“未定义函数'ContactRelated” ' 在表达中。
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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
ConcatRelated 中拥有的是用户定义函数，它在 Access 之外无法工作。
您似乎必须获取记录集，然后循环遍历它以构建连接的输出。
What you have in ConcatRelated is a User Defined Function, and it will not work outside Access.
It seems likely that you will have to get your recordset and then loop through it to build the concatenated output.