为什么我在access中运行下面SQL语句时提示输入参数值？_百度知道
为什么我在access中运行下面SQL语句时提示输入参数值？
/zhidao/wh%3D600%2C800/sign=8e4de44b0e77a613ff5c1//zhidao/pic/item/728dabc67adab4e151.jpg" esrc="http.baidu.baidu.jpg" target="_blank" title="点击查看大图" class="ikqb_img_alink"><a href="/zhidao/wh%3D450%2C600/sign=f11d83fc932397ddd62c9/02d966f6d80713dfa9ec8a13cd95://e<a href="http
提问者采纳
女士&#39;尊称=&#39，这个用单引号和双引号应该是都可以;&你的分号和双引号都要用英文的写法，但一定要英文的写法复制我这个select&;where&*&雇员&from&nbsp
提问者评价
来自团队：
其他类似问题
9人觉得有用
为您推荐：
sql语句的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁当单元格中输入的公式出现缺少函数参数的错误时，在单元格中显示的错误值是什么？_百度知道
当单元格中输入的公式出现缺少函数参数的错误时，在单元格中显示的错误值是什么？
当单元格中输入的公式出现缺少函数参数的错误时，在单元格中显示的错误值是什么？下次出现该类题目时应该如何解答?
上网搜，关键还是在于平时的积累。临时抱佛脚的方法，或者当公式自动更正功能不能更正公式时#VALUE! 当使用错误的参数或运算对象类型时!，将产生错误值#VALUE。 遇到这类问题回想下
其他类似问题
为您推荐：
其他1条回答
般出现#VALUE,单元格格式等等来判断问题,输入的数值不满足要求象这个要看你具体使用的函数!这个不代表什么意义,只是提示你的公式应用有问题,以及相关的参数
单元格的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁请定义一个带参数的宏，使两个参数的值互换。要求在主函数中输入两数作为宏的实参，最后输出交换以后的值_百度知道
请定义一个带参数的宏，使两个参数的值互换。要求在主函数中输入两数作为宏的实参，最后输出交换以后的值
① 按要求定义宏；② 在主函数中任意输入两个数；③ 使用宏交换两个数的值；
提问者采纳
y); SWAP(x.h& printf(&quot,x;}void main(){ n&#define SWAP(a;%d%d&quot,b) {a=a+b;,y;,&y);b=a-b;a=a-b,y); scanf(&quot,&x;%d %d&#92#include &quot
其他类似问题
为您推荐：
主函数的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁请教高手。在Access中，新建一个查询表，输入select语句运行后，总是让输入参数值，怎么回事？_百度知道
请教高手。在Access中，新建一个查询表，输入select语句运行后，总是让输入参数值，怎么回事？
老师要求做出的是运行select，直接就出来结果了。
为您推荐：
参数值的相关知识
等待您来回答
下载知道APP
随时随地咨询
出门在外也不愁1、脚本中对用户名进行参数化后：如下（我的参数化文件中有三个值）
web_submit_data("authentication",
"Action=/mojingcsp/authentication",
"Method=POST",
"TargetFrame=",
"RecContentType=application/json",
"Referer=/user/login.html",
"Snapshot=t3.inf",
"Mode=HTML",
"Name=username", "Value={userName}", ENDITEM,
"Name=password", "Value=e10adc3949ba59abbe56e057f20f883e", ENDITEM,
2、在脚本中添加函数用以输入参数化的值：
lr_output_message("用户名信息：",lr_eval_string("{userName}"));
3、设置一下运行时设置：F4键，因为系统默认输出标准日志，想要输出参数化的值需要修改默认配置，其余两个选项不要选择，否则信息太多了。
4、我设置了迭代三次。
5、于是我想看一下 &这三次迭代的过程中，是否正确执行了三个参数化的值，于是需要做以上一些列的操作。
6、开始回放：
7、看回放日志：输入参数化的值在回放日志中可以查看。（可以看出三次迭代中使用了三个不同的用户名。）
Action.c(211): Notify: Parameter Substitution: parameter "userName" =
Action.c(211): 用户名信息：
Action.c(213): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(213): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(207): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(209): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(211): Notify: Parameter Substitution: parameter "userName" =
Action.c(211): 用户名信息：
Action.c(213): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(213): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(207): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(209): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(211): Notify: Parameter Substitution: parameter "userName" =
Action.c(211): 用户名信息：
Action.c(213): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(213): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
8、日志信息文件output.txt，windows环境，默认保存在脚本文件中；
& & &输出函数
1、lr_log_message() & &// 输出信息，并记录到 output.txt 中
2、lr_output_message() & &// 输出信息，不记录到日志文件中
3、lr_message() & &// 输出信息，不记录到日志文件中
4、lr_error_message() & &// 输出信息，不记录到日志文件中
9、可以看一下完整的回放日志，说明一开始准备好参数化的值，然后用到的时候再输入
Action.c(110): Downloading resource "/mojingcsp/public/page/list" (specified by argument number 26)
[MsgId: MMSG-26577]
Action.c(110): web_submit_data("lxb.gif") was successful, 8112 body bytes, 603 header bytes, 45 chunking overhead bytes
[MsgId: MMSG-26385]
Action.c(128): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(130): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(132): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(134): Downloading resource "/cclv/v2/patterns.json" (specified by argument number 18)
[MsgId: MMSG-26577]
Action.c(134): Downloading resource "/mojingcsp/public/scrollinfo/promotion" (specified by argument number 9)
[MsgId: MMSG-26577]
Action.c(134): Downloading resource "/mojingcsp/public/feedback/types" (specified by argument number 12)
[MsgId: MMSG-26577]
Action.c(134): Downloading resource "/mojingcsp/public/page/3/videos/top4?O_o=3o0w1f6sfji" (specified by argument number 15)
[MsgId: MMSG-26577]
Action.c(134): web_url("bpaId") was successful, 5597 body bytes, 1441 header bytes, 65 chunking overhead bytes
[MsgId: MMSG-26385]
Action.c(148): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(150): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(152): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(154): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(159): Registering web_reg_save_param_ex was successful
[MsgId: MMSG-26390]
Action.c(167): Notify: Parameter Substitution: parameter "userName" =
Action.c(167): Notify: Saving Parameter "CorrelationParameter_1 = 20000".
Action.c(167): Downloading resource "/lib/leaflet/leaflet.css?_d=2" (specified by argument number 17)
[MsgId: MMSG-26577]
Action.c(167): Downloading resource "/css/icon/style.css?_d=2" (specified by argument number 20)
[MsgId: MMSG-26577]
Action.c(167): Downloading resource "/css/common.css?_d=2" (specified by argument number 23)
[MsgId: MMSG-26577]
Action.c(167): Downloading resource "/js/mjchart/theme/mjvi.css?_d=2" (specified by argument number 26)
[MsgId: MMSG-26577]
Action.c(167): Downloading resource "/js/config.js" (specified by argument number 29)
[MsgId: MMSG-26577]
Action.c(167): Downloading resource "/js/functions.js?_d=2" (specified by argument number 32)
[MsgId: MMSG-26577]
Action.c(167): Downloading resource "/js/mjchart/mjvi.min.js?_d=2" (specified by argument number 35)
[MsgId: MMSG-26577]
Action.c(167): Downloading resource "/js/common.js?_d=2" (specified by argument number 38)
[MsgId: MMSG-26577]
Action.c(167): Downloading resource "/static/js/csp.js?_=1" (specified by argument number 41)
[MsgId: MMSG-26577]
Action.c(167): web_submit_data("authentication") was successful, 632562 body bytes, 5049 header bytes, 35 chunking overhead bytes
[MsgId: MMSG-26385]
Action.c(190): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(190): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(190): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(190): Resource "/static/common.css?v=1" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Resource "/static/common.js?v=1" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Resource "/user/static/user.css?v=1" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Resource "/user/static/user.js?v=1" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Resource "/user/static/images/help/worsa.png" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Resource "/user/static/images/help/ttime.png" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Resource "/user/static/images/help/giftss.png" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Resource "/user/static/images/help/erws.png" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Resource "/user/static/images/help/twes.png" is in the cache already and will not be downloaded again
[MsgId: MMSG-26655]
Action.c(190): Downloading resource "/hm.js?177ebef2f9aeef680a83" (specified by argument number 10)
[MsgId: MMSG-26577]
Action.c(190): Downloading resource "/stat.htm?id=&r=http%3A%2F%%2Fuser%2Flogin.html&lg=zh-cn&ntime=&cnzz_eid=--http%3A%2F%%2F&showp=&p=http%3A%2F%%2Fprojects.html%23%2F%3FMoJing-Token%3D20000&t=&h=1&rnd=" (specified by argument number 13)
[MsgId: MMSG-26577]
Action.c(190): Downloading resource "/mojing-server/user/login?MoJing-Token=20000" (specified by argument number 16)
[MsgId: MMSG-26577]
Action.c(190): Downloading resource "/hm.gif?cc=0&ck=1&cl=24-bit&ds=&et=0&fl=22.0&ja=0&ln=zh-CN&lo=0&lt=&nv=0&rnd=&si=177ebef2f9aeef680a83&st=4&su=http%3A%2F%%2Fuser%2Flogin.html&v=1.1.26&lv=3" (specified by argument number 19)
[MsgId: MMSG-26577]
Action.c(190): web_url("popup-help.html_2") was successful, 1797 body bytes, 1606 header bytes, 23 chunking overhead bytes
[MsgId: MMSG-26385]
Action.c(205): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(207): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(209): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(211): Notify: Parameter Substitution: parameter "userName" =
Action.c(211): 用户名信息：
Action.c(213): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(213): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(213): Found resource "/projects/images/wschuan.png" in HTML "/projects/projectlist.html?MoJing-Token=20000"
[MsgId: MMSG-26659]
Action.c(213): Warning -26627: HTTP Status-Code=404 (Not Found) for "/projects/images/wschuan.png"
[MsgId: MWAR-26627]
Action.c(213): Downloading resource "/mojing-server/project?MoJing-Token=20000" (specified by argument number 10)
[MsgId: MMSG-26577]
Action.c(213): web_url("projectlist.html") highest severity level was "warning", 7577 body bytes, 1676 header bytes, 19 chunking overhead bytes
[MsgId: MMSG-26387]
Action.c(225): Verification checks not enabled. web_find is skipped. See the 'Run-time settings/Preferences/Checks'
[MsgId: MMSG-27197]
Action.c(225): web_find was successful
[MsgId: MMSG-26392]
Action.c(228): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(230): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(230): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(230): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(230): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(230): Downloading resource "/lxb.js?sid=7232801" (specified by argument number 9)
[MsgId: MMSG-26577]
Action.c(230): Downloading resource "/mojingcsp/public/user/status?O_o=5" (specified by argument number 12)
[MsgId: MMSG-26577]
Action.c(230): Downloading resource "/css/icon/fonts/icomoon.ttf?4kq5qy" (specified by argument number 15)
[MsgId: MMSG-26577]
Action.c(230): Downloading resource "/mojing-server/admin/user/getUid?MoJing-Token=20000" (specified by argument number 18)
[MsgId: MMSG-26577]
Action.c(230): Downloading resource "/newFloat/log.gif?fType=2&name=lxb&t=4&uuid=a7a5d166-046b-420b-96ec-ea6e55509c9e" (specified by argument number 21)
[MsgId: MMSG-26577]
Action.c(230): Downloading resource "/newFloat/_l.js?siteid=7232801&bdclickid=&bdcbid=f92ca554-e7d1-227baedebd&refer_domain=&ishttp=1&t=8&callback=_lxb_jsonp_iq5bz6g6_" (specified by argument number 24)
[MsgId: MMSG-26577]
Action.c(230): Downloading resource "/api/asset/api.js?t=8" (specified by argument number 27)
[MsgId: MMSG-26577]
Action.c(230): Downloading resource "/newFloat/log.gif?fType=2&name=_l&t=9&uuid=a7a5d166-046b-420b-96ec-ea6e55509c9e" (specified by argument number 30)
[MsgId: MMSG-26577]
Action.c(230): web_url("v.js_2") was successful, 88497 body bytes, 2988 header bytes, 84 chunking overhead bytes
[MsgId: MMSG-26385]
Action.c(248): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(250): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(250): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(250): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(250): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(250): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(250): Downloading resource "/bpa/bpa.js" (specified by argument number 23)
[MsgId: MMSG-26577]
Action.c(250): Downloading resource "/mojingcsp/public/page/list" (specified by argument number 26)
[MsgId: MMSG-26577]
Action.c(250): Downloading resource "/mojingcsp/public/feedback/types" (specified by argument number 29)
[MsgId: MMSG-26577]
Action.c(250): Downloading resource "/mojingcsp/public/scrollinfo/promotion" (specified by argument number 32)
[MsgId: MMSG-26577]
Action.c(250): web_submit_data("lxb.gif_2") was successful, 10566 body bytes, 1258 header bytes, 69 chunking overhead bytes
[MsgId: MMSG-26385]
Action.c(270): web_add_cookie was successful
[MsgId: MMSG-26392]
Action.c(272): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(272): Notify: Parameter Substitution: parameter "CorrelationParameter_1" =
Action.c(272): Downloading resource "/mojingcsp/public/page/4/videos/top4?O_o=bd457w0xdnt" (specified by argument number 9)
[MsgId: MMSG-26577]
Action.c(272): Downloading resource "/hm.gif?cc=0&ck=1&cl=24-bit&ds=&ep=%7B%22netAll%22%3A4%2C%22netDns%22%3A18%2C%22netTcp%22%3A0%2C%22srv%22%3A4%2C%22dom%22%3AloadEvent%22%3Aqid%22%3A%22%22%2C%22bdDom%22%3A0%2C%22bdRun%22%3A0%2C%22bdDef%22%3A0%7D&et=87&fl=22.0&ja=0&ln=zh-CN&lo=0&lt=&nv=0&rnd=&si=177ebef2f9aeef680a83&st=4&su=http%3A%2F%%2Fuser%2Flogin.html&v=1.1.26&lv=3" (specified by argument number 12)
[MsgId: MMSG-26577]
Action.c(272): web_url("bpaId_2") was successful, 1086 body bytes, 556 header bytes, 12 chunking overhead bytes
[MsgId: MMSG-26385]
Ending action Action.
Ending iteration 1.
Starting iteration 2.
Notify: Next row for parameter userName = 2 [table
= userName].
Notify: Getting new value for parameter 'userName': table = 'userName.dat' column = '0' row = '2'.
Starting action Action.
Action.c(4): web_add_cookie was successful
[MsgId: MMSG-26392]
&以下是引用别人的文章
1.打开EXtended Log
　 　Log告诉了我们一切,默认的Log是standard Log,这时远远不够的.我们要extended log,打开路径为runtime settings--&log--&extended log.把parameter substitution和data returned byserver和advanced trace大家根据需要勾选吧.
　　2.log文件位置，特别是controll执行后，怎么看log。这里一一说明一下：
　 　（1）vgen的runtime settings设置：在vgen中，我们必须写输出函数输出信息，将我们所想要了解的信息用函数输出，主要有这么几个函数输出信 息：lr_output_message,lr_error_message,lr_log_message。这些函数请参阅 help--&function reference.
　 　其次，我们要在runtime settings中设置，勾选always send messages,具体的做法是：runtime settings---&log--&always send messages，这样我们才能写出Log，在我们的脚本所在的文件夹中，有两个文件很重要，mdrv.log.txt和output.txt文 件，lr_log_message只会把信息输到mdrv.log文件中，而lr_output_message则会写进以上两个文件。
　　（2）controller的runtime settings设置：在controller我们也要设置runtime settings，这样才能在场景运行后查看相应， 而且每个用户组的runtime settings都有设置。设置的方法是：在controller的design标签页中，右下角的部分有runtime settings按钮，我们点击它，设置的方法与在vgen中一样的。很多朋友都会想知道多次迭代，参数是否正确的导入了呢，我们依旧查看log,我们在 执行结束后，查看结果目录的Log文件夹,如果是负载生成器运行的话,则在tmp目录。
　　在环境下，日志文件output.txt保存在脚本目录中；在UNIX环境下，保存在标准输出中。
【Vuser】&&【Run Time Settings】&&【General】&&【Log】
1、【Enable logging】启动日志功能；（建议运行场景进行负载时关闭此项）
2、【Send messages only when an error occurs】仅发送出错时的日志，可设置缓存大小（默认1KB）；
3、【Always send message】发送所有日志；
4、【Standard log】标准日志，脚本运行时发送函数信息；
【Extended log】扩展日志：
5、【Parameter substitution】脚本运行时，在【Replay log】显示参数信息、参数值；
6、【Data returned by&】记录服务器返回的所有数据；
7、【Advanced trace】多用于脚本调试，记录VU在运行期间发送的所有函数信息。
　　========================================
　　【Replay log】显示的日志颜色：
　　1、红色：错误信息；
　　2、橙色：迭代信息；
　　3、蓝色：事件信息；
　　4、黑色：输出信息；
　　5、绿色：字符信息。
　　========================================
　　输出函数：
1、lr_log_message() & &// 输出信息，并记录到 output.txt 中
2、lr_output_message() & &// 输出信息，不记录到日志文件中
3、lr_message() & &// 输出信息，不记录到日志文件中
4、lr_error_message() & &// 输出信息，不记录到日志文件中
阅读(...) 评论()}