以文本方式查看主题

-  Foxtable(狐表)  (http://foxtable.com/bbs/index.asp)
--  专家坐堂  (http://foxtable.com/bbs/list.asp?boardid=2)
----  多字段如何实现?  (http://foxtable.com/bbs/dispbbs.asp?boardid=2&id=192905)

--  作者:lin98
--  发布时间:2024/7/31 15:34:00
--  多字段如何实现?
\'Dim cmd As New SQ-LCommand
\'cmd.C 
\'cmd.CommandText = "SELEC-T Group,部门,角色  From {Users} where name=\'" & e.sender.text & "\'" \'"
\'e.Form.Controls("Group").text = cmd.ExecuteScalar() 

报错,多字段怎么实现?
You have an error in your SQL syntax; check the manual that corresponds to your SQL server version for the right syntax to use near \'Group   From xtyh_tb where name=\'陆一明\'\' at line 1

--  作者:有点蓝
--  发布时间:2024/7/31 15:37:00
--  
列名加上中括号