sqlstr="insert into flower (userid,item,stuff,color,"
sqlstr=sqlstr & "money,rname,raddr,rphone,sdate,"
sqlstr=sqlstr & "stime,card_no,pay_type,message)"
sqlstr=sqlstr & "values('" & userid & "','" & item
sqlstr=sqlstr & "','" & stuff & "','" & color & "',"
sqlstr=sqlstr & money & ",'" & rname & "','" & raddr
sqlstr=sqlstr & "','" & rphone & "','" & sdate & "','"
sqlstr=sqlstr & stime & "','" & card_no & "','"
sqlstr=sqlstr & pay_type & "','" & msg_str & "')"
sqlstr=sqlstr & "money,rname,raddr,rphone,sdate,"
sqlstr=sqlstr & "stime,card_no,pay_type,message)"
sqlstr=sqlstr & "values('" & userid & "','" & item
sqlstr=sqlstr & "','" & stuff & "','" & color & "',"
sqlstr=sqlstr & money & ",'" & rname & "','" & raddr
sqlstr=sqlstr & "','" & rphone & "','" & sdate & "','"
sqlstr=sqlstr & stime & "','" & card_no & "','"
sqlstr=sqlstr & pay_type & "','" & msg_str & "')"
解决方案 »
- dtree如何获取节点值?
- 提示后强制关闭当前页,不要提示
- 请问在网页中怎么和ActiveX交互?
- 如果用js来播放音频文件(wav格式),使用windows media player
- 网页选择播放多个音频如何实现呢?类似音乐网站的类型
- self.resizeto 报对象拒绝访问
- iframe问题
- 请问添加,删除LIST中元素的语法是怎样的,如何判断当前是否有选中项.
- 一个有关弹出子窗口的问题,在线等待,高分相赠!
- 有没有办法用把网页,旋转过来,比如横线变成竖线
- 【求助】数据导入的问题
- r建议CSDN社区每个版块都有自己的专家榜,而且可以察看每个人在各个版块的得分,就想看自己的一样,有利于大家互相了解。支持请进!(
规律可寻呢?当然有的,数值型时不用,其它的如字符型就要,用ACCESS,日期型这样写#"&stime&"#,sql server中用'"&stime&"'简单吧,呵呵
sqlstr=sqlstr & "money,rname,raddr,rphone,sdate,"
sqlstr=sqlstr & "stime,card_no,pay_type,message)"
sqlstr=sqlstr & "values(" & userid & "," & item
sqlstr=sqlstr & "," & stuff & "," & color & ","
sqlstr=sqlstr & money & "," & rname & "," & raddr
sqlstr=sqlstr & "," & rphone & "," & sdate & ","
sqlstr=sqlstr & stime & "," & card_no & ","
sqlstr=sqlstr & pay_type & "," & msg_str & ")"好像应该把单引号都去掉,你试一下!
字符串比如 NAME用'"&NAME&"'
不能一味的用'"&&"'
晕。这个不能这么说。。我在ACCESS里面就能用'"&&"'。网上好像有这么说的。不过你可以试一下。不用#了可以在ACCESS里用。。