1122

[koge2000]

vUsername= zhaohuihuang
sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author='zhaohuihuang'"
''sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= "&vUsername&" "
''sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= &vUsername& "
'' sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= vUsername "
'''sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= 'vUsername' " '无错，但不能查询出来
''sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= &'vUsername&' "
sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= &'vUsername' "
'''sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= '&vUsername&' " '无错，但不能查询出来
''sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= '&vUsername&' "
''sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= "vUsername" " '报错
sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author= '&vUsername&' " ‘不行

现在我要用vUsername，怎么搞，
你看还有什么办法？

[koge2000]

第一句是成功的

[pressman]

第一句是成功的
就用第一句

[pressman]

sql="select pr_number,pr_state,pr_title,pr_date from pr_main where pr_author='"&vUsername&"'"