?? 5663.html
字號:
<html>
<head>
<title>請問傳入 SQL 的字串長度問題</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>請問傳入 SQL 的字串長度問題</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:harman@iis.sinica.edu.tw">Haha</a> on September 15, 1998 at 17:05:17:<p>
請問各位，用 RDO 要傳 SQL string 到 SQL SERVER 時,<br>自串長度太長，會不會有問題<p>因為我用的字串好像超過 256 個字元, 如下：<p>sqls = "insert tablemeaningfacet (word,zhuyin,sense,meaningfacet,source," & _<br> "lloce,cilin,freq,meaning,Constitutive,formal,telic,agentive,Collocates)" & _<br> " values ('" & sWord & "','" & sZhuYin & "','" & sSense & "','" & txtMeaningFacet.Text _<br> & "','" & txtSource.Text & "','" & txtLLOCE.Text & "','" & txtCILIN.Text _<br> & "'," & txtFreq.Text & ",'" & txtMeaning.Text & "','" & txtQcon.Text _<br> & "','" & txtQfor.Text & "','" & txtQtel.Text & "','" & txtQage.Text _<br> & "','" & txtCollocates.Text & "')"<p>請幫忙解答， 感激不盡
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 5663-->
<!--top: 6053--><li><a href="6053.html">Re: 請問傳入 SQL 的字串長度問題</a> <b>老怪</b> <i>17:13:38 9/27/98</i>
(<!--responses: 6053-->0)
<ul><!--insert: 6053-->
</ul><!--end: 6053-->
</ul><!--end: 5663-->
<br><hr size=7 width=75%><p>
</body></html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -