主题：[求助]

老师 我们有一个查询表  只有一个字段  想要把它的多行的值连接成一个 字符串要怎么处理

例如 khmc列 有 AAA BBB CCC 三条记录 怎样达到如下效果 某个变量T=AAABBBCCC

 参考 http://www.foxtable.com/help/topics/1435.htm

 

老师，如下代码执行的时候报错，至少有个参数没有指定值，请帮忙看看，谢谢！

未指定值的参数address

 

Dim Ac As String

Dim cmd2 As New SQL-Command

cmd2.Con-nection-Name = "User"

cmd2.CommandText = "S-ELECT EAccount F-rom {Users} where UserName = '" & _UserName & "'"

Ac = cmd2.ExecuteScalar()

 

Dim fr As String

Dim cmd3 As New SQL-Command

cmd3.Con-nection-Name = "User"

cmd3.CommandText = "S-ELECT Email F-rom {Users} where UserName = '" & _UserName & "'"

fr = cmd3.ExecuteScalar()

 

Dim rc As String = Forms("邮件").Controls("Receiver").Value

Dim m As New MailSender

m.Host = "192.168.1.103"

m.Account = Ac

m.Password = "123456"

m.From = fr

m.To = rc

m.Title = Forms("邮件").Controls("subject").Value

m.Content = Forms("邮件").Controls("body").Value

m.SendAsync()

 应该是你的列名写错了

 

EAccount 、UserName 、Email