Article View: cn.bbs.comp.database
Article #9648Re: ��һ��SQL������
From: ������� ˼����
Date: Fri, 11 Jul 2003 03:33
Date: Fri, 11 Jul 2003 03:33
23 lines
1901 bytes
1901 bytes
function sqlStr(s)
sqlStr="'" & Replace(s,"'","''") & "'"
end function
sql="update table1 set my_str="&sqlstr(some_str)&"..."
����� OK ��
�� �� zq.bbs@bbs.sjtu.edu.cn (lz) �Ĵ������ᵽ: ��
: update table1 set my_str = some_str ....
: somestr �Ǵ������ģ��Լ���������ʲô��������������� ����ţ�����
: a'df ���� ad'f'gk������update����ôд�أ���������?��sql��ֱ���滻��
: ��ģ����鷳������ #define.������
--
[17;35m �� ��
��[1m [3I�ҡ� �� �� �� �� ��
[1;5;31;31m���� Ϊ �� �� �� [17;35m��
�� [17;34m �� [3I�� �� �� �� �� �� ��
[1;5;32;32m�� Ϊ �� �� �ҡ� [17;35m ��
[m[1;36m�� ��Դ:������δ��վ bbs.pku.edu.cn��[FROM: 162.105.223.169][m
Technical Details
Message-ID:
<47DZOZ$Za5@bbs.pku.edu.cn>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.happynet.org!PKUShow Full Headers
Complete Article Headers
X-Google-Language: Chinese,GB X-Google-Thread: 101948,c7ef056ecbc34d88 X-Google-Attributes: gid101948,public X-Google-ArrivalTime: 2003-07-10 20:34:06 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-05!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.media.kyoto-u.ac.jp!newsgate.cuhk.edu.hk!news.zixia.net!news.happynet.org!PKU From: mi@bbs.pku.edu.cn (������� ˼����) Newsgroups: cn.bbs.comp.database Subject: Re: ��һ��SQL������ Date: 11 Jul 2003 03:33:26 GMT Organization: ����δ��վ Message-ID: <47DZOZ$Za5@bbs.pku.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: Database/M.1057894307.A Lines: 23