这句SQL怎么写?# Database - 数据库
s*u
1 楼
select ID from Table1 where Name = '" & name & "'"
but, some names 里面有"'", 所以会出错.
怎么办? 谢谢.
but, some names 里面有"'", 所以会出错.
怎么办? 谢谢.
q*e
2 楼
if it is in code, then it is easy since you can set a string
for it. if you use it in command line, then it may be
impossible.
【在 s***u 的大作中提到】
: select ID from Table1 where Name = '" & name & "'"
: but, some names 里面有"'", 所以会出错.
: 怎么办? 谢谢.
for it. if you use it in command line, then it may be
impossible.
【在 s***u 的大作中提到】
: select ID from Table1 where Name = '" & name & "'"
: but, some names 里面有"'", 所以会出错.
: 怎么办? 谢谢.
W*S
3 楼
use " instead
【在 s***u 的大作中提到】
: select ID from Table1 where Name = '" & name & "'"
: but, some names 里面有"'", 所以会出错.
: 怎么办? 谢谢.
【在 s***u 的大作中提到】
: select ID from Table1 where Name = '" & name & "'"
: but, some names 里面有"'", 所以会出错.
: 怎么办? 谢谢.
s*u
4 楼
the name is from :
name = recordset1("Name")
so, impossible?
【在 q***e 的大作中提到】
: if it is in code, then it is easy since you can set a string
: for it. if you use it in command line, then it may be
: impossible.
name = recordset1("Name")
so, impossible?
【在 q***e 的大作中提到】
: if it is in code, then it is easy since you can set a string
: for it. if you use it in command line, then it may be
: impossible.
s*u
5 楼
How to instead ya?
thanks.
【在 W****S 的大作中提到】
: use " instead
thanks.
【在 W****S 的大作中提到】
: use " instead
a*o
6 楼
best way is to write a stored procedure and take this
parameter.
the simplest way is to replace the "'" with "''"
【在 s***u 的大作中提到】
: the name is from :
: name = recordset1("Name")
: so, impossible?
parameter.
the simplest way is to replace the "'" with "''"
【在 s***u 的大作中提到】
: the name is from :
: name = recordset1("Name")
: so, impossible?
g*p
7 楼
Add this line after the above:
name=replace(recordset("Name"),"'","''")
What it does is, it escapes the ' character so your value
indeed can contain apostrophe.
For details see:
http://www.aspfaq.com/faq/faqShow.asp?fid=4
HTH.
【在 s***u 的大作中提到】
: the name is from :
: name = recordset1("Name")
: so, impossible?
s*n
8 楼
for vb, asp: select ID from Table1 where Name = '" & Replace(name,"'","'') &
"'"
【在 a****o 的大作中提到】
: best way is to write a stored procedure and take this
: parameter.
: the simplest way is to replace the "'" with "''"
"'"
【在 a****o 的大作中提到】
: best way is to write a stored procedure and take this
: parameter.
: the simplest way is to replace the "'" with "''"
相关阅读
mysql challengeSQL Server restore(transferred from other DB) error... HELP!讨论:在SELECT中限制TOP N条纪录A dummy question about Enterprise Manager我这个数据库怎么办啊？how to use c language to implement Access Database operations?ACCESS中的图片在网页中显示问题如何从一个表中删除在另一个表中存在的记录[转载] any database programming books?One question on SQL Serveroracle dbms_outputhow to particially delete record in sql serverZachary+CA-Clipper ---> MS SQL ServerOracle Default passwd for SYS, SYSTEM is not valiRe: 求救!!! 一个oracle的问题! 在procedure中所涉及的表名可以用变量从参数中传入吗急：为何ACCESS中数据export为.txt文件后格式丢失？Managment server in Oracle8i ORACLE 底下有什么好的加密包？找到一个偷懒的办法，不知道是不是可行Does VB works with Oracle