我试图在参数化查询中运行以下agregate函数在Access2000上： Min（[t1]。[f1] * sqr （[t2]。[f1] / [t1]。[f1]）/ [param]） 查询保存确定，但尝试运行它会产生以下消息： 表达式输入错误或者太复杂而无法评估 如果sintax正确吗？也许是这样，否则就不会保存。 可以做些什么呢？
解决方案aa写道：我试图在Access2000上的参数化查询中运行以下agregate函数： Min（[t1]。[f1] * sqr（[t2] 。[f1] / [t1]。[f1]）/ [param]） 查询保存OK，但尝试运行它会产生以下消息：表达式已输入不正确或太复杂而无法评估 如果sintax正确吗？也许它是，否则它不会保存。可以做些什么呢？
在Access中运行它时，或者何时运行它运行它来自 ASP？ 我想你已经确认这个表达式（似乎是 语法正确）是删除 这个表达式后运行查询的罪魁祸首吗？ 我建议您通过 开头： 最小（[t1]。[f1]） 并添加件直至失败。 FWIW，我刚刚在我的示例数据库中对它进行了测试，查询运行没有 问题。 Bob Barrows - Microsoft MVP - ASP / ASP.NET 请回复新闻组。我的From 标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。
谢谢，Bob。 1.当我从Access2000中运行此查询时弹出提到的错误 当我从ASP运行它时，它返回 ===== ========================== 错误类型： Microsoft JET数据库引擎（ 0x80040E07） 标准表达式中的数据类型不匹配。 ========================= ======= 2.在我添加 sqr（）之前，查询在Access和ASP中都运行良好： /> Min（[t1]。[f1] * [t2]。[f1] / [t1]。[f1]）/ [param] 所以sqr（）似乎是一个罪魁祸首。 你是说你在机器上使用sqr（）工作的查询吗？ 鲍勃巴罗斯 <再****** @ NOyahoo.SPAMcom>在消息中写道 news：u3 ************** @ tk2msftngp13.phx.gbl ... aa写道：我试图在Access2000上的参数化查询中运行以下agregate函数： Min（[t1]。[f1] * sqr（[t2]。 [f1] / [t1]。[f1]）/ [param]） 查询保存正常，但尝试运行它会产生以下消息：表达式输入错误或者它太复杂了无法评估 如果sintax正确吗？也许它是，否则它不会保存。可以做些什么呢？
在Access中运行它时，或者从<运行它时，是否收到此消息？ ASP？ 我想你已经确认这个表达式（似乎在语法上是正确的）是删除这个表达式后运行查询的罪魁祸首？ 我建议您通过以下方式发现表达问题的哪一部分： Min（[t1]。[f1]） FWIW，我刚刚在我的示例数据库中测试它，并且查询运行没有问题。 - 微软MVP - ASP / ASP.NET 请回复新闻组。我的From 标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将得到更快的回复。
aa写道：谢谢，鲍勃。 1.当我从内部运行此查询时弹出提到的错误 当我从ASP运行它时，它返回 =============================== 错误类型： Microsoft JET数据库引擎（0x80040E07） ）标准表达式中的数据类型不匹配。 ================================ /> 2.在我添加sqr（）之前，查询在Access和ASP中都运行正常： Min（[t1]。[f1] * [t2]。[ f1] / [t1]。[f1]）/ [param] 所以sqr（）似乎是罪魁祸首。 你是说在你用sqr（）加工查询工作？
是的，我在运行它时没有问题。在AccessXP中。 快速Google搜索显示有人解决了这个问题是在参数的PARAMETERS部分中声明了他的参数查询，如下： PARAMETERS param Short; SELECT ... Bob Barrows - Microsoft MVP - ASP / ASP.NET 请回复新闻组。我的From 标题中列出的电子邮件帐户是我的垃圾邮件陷阱，因此我不经常检查它。通过发布到新闻组，您将获得更快的回复。
I am trying to run the following agregate function in a parameterized query on Access2000: Min([t1].[f1]*sqr([t2].[f1]/[t1].[f1])/[param]) The query saved OK, but an attempt to run it results in the message: The expression is typed incorrectly or it is too complex to be evaluated If the sintax correct? Perhaps it is, otherwise it would not save. What can be done about it?
解决方案 aa wrote: I am trying to run the following agregate function in a parameterized query on Access2000: Min([t1].[f1]*sqr([t2].[f1]/[t1].[f1])/[param]) The query saved OK, but an attempt to run it results in the message: The expression is typed incorrectly or it is too complex to be evaluated If the sintax correct? Perhaps it is, otherwise it would not save. What can be done about it?Do you get this message when running it in Access, or when running it from ASP? I suppose you''ve confirmed that this expression (which appears to be syntactically correct) is the culprit by running the query after removing this expression? I suggest that you discover what part of the expression is the problem by starting with: Min([t1].[f1]) and adding on pieces until it fails. FWIW, I just tested it in my sample database, and the query runs without problem. Bob Barrows -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don''t check it very often. You will get a quicker response by posting to the newsgroup.
Thanks, Bob. 1. The mentioned error pops up when I run this query from within Access2000 When I run it from ASP, it returns =============================== Error Type: Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. ================================ 2. The query was working fine both in Access and in ASP before I added that sqr(): Min([t1].[f1]*[t2].[f1]/[t1].[f1])/[param] So sqr() seems to be a culprit. Are you saying that on you machine the query with sqr() worked? "Bob Barrows" <re******@NOyahoo.SPAMcom> wrote in message news:u3**************@tk2msftngp13.phx.gbl... aa wrote: I am trying to run the following agregate function in a parameterized query on Access2000: Min([t1].[f1]*sqr([t2].[f1]/[t1].[f1])/[param]) The query saved OK, but an attempt to run it results in the message: The expression is typed incorrectly or it is too complex to be evaluated If the sintax correct? Perhaps it is, otherwise it would not save. What can be done about it?Do you get this message when running it in Access, or when running it from ASP? I suppose you''ve confirmed that this expression (which appears to be syntactically correct) is the culprit by running the query after removing this expression? I suggest that you discover what part of the expression is the problem by starting with: Min([t1].[f1]) and adding on pieces until it fails. FWIW, I just tested it in my sample database, and the query runs without problem. Bob Barrows -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don''t check it very often. You will get a quicker response by posting to the newsgroup.
aa wrote: Thanks, Bob. 1. The mentioned error pops up when I run this query from within Access2000 When I run it from ASP, it returns =============================== Error Type: Microsoft JET Database Engine (0x80040E07) Data type mismatch in criteria expression. ================================ 2. The query was working fine both in Access and in ASP before I added that sqr(): Min([t1].[f1]*[t2].[f1]/[t1].[f1])/[param] So sqr() seems to be a culprit. Are you saying that on you machine the query with sqr() worked?Yes, I had no problem running it.in AccessXP. A quick Google search shows that somebody solved this problem by declaring his parameters in a PARAMETERS section of the query, like this: PARAMETERS param Short; SELECT ... Bob Barrows -- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don''t check it very often. You will get a quicker response by posting to the newsgroup.
更多推荐
表达式输入不正确或者太复杂而无法评估
发布评论