是做在线词典用的。javastricpt按照用户文本框输入查询Access数据库。
这一句怎么也搞不定了,怎么改都不对,痛苦了一天一夜了,求各位大侠请赐教。var mySql = "SELECT * FROM table1 WHERE 发音=form1.txtjiansuo.text";
有朋友回答我说
var mySql = "SELECT * FROM table1 WHERE 发音='" & form1.txtjiansuo.text & "'";
可是提示“无效的SQL语句;期待‘delete’、‘insert’、‘procedure’、‘select’或‘update’”。
第一段可以执行。
--------------------------------------------------------------
function zhongying()
{
var mySql = "SELECT * FROM table1 WHERE 发音='nihao'";
var recordSet = database.Execute(mySql);
var tempText = "";
document.getElementById("dataDisplay").value = "";
while (!recordSet.EOF)
{
tempText = tempText + recordSet(0) + ":" +recordSet(2)+"【" +recordSet(3)+ "】"+ recordSet(4)+ recordSet(5)+"\n";
recordSet.MoveNext();
}
document.getElementById("dataDisplay").value = tempText;
recordSet.Close();
recordSet = null;
}
--------------------------------------------------------------
第二段的第一句出错了
(与第一段的区别就第一句,汗...用途是希望将用户在form1,id=txtjiansuo文本框中输入的值检索access表中发音字段)function yingzhong()
{
var mySql = "SELECT * FROM table1 WHERE 发音=form1.txtjiansuo.text"; var tempText = "";
var recordSet = database.Execute(mySql);
document.getElementById("dataDisplay").value = "";
while (!recordSet.EOF)
{
tempText = tempText + recordSet(0) + ":" +recordSet(2)+"【" +recordSet(3)+ "】"+ recordSet(4)+ recordSet(5)+"\n";
recordSet.MoveNext();
}
document.getElementById(dataDisplay).value = tempText;
recordSet.Close();
recordSet = null;
}
这一句怎么也搞不定了,怎么改都不对,痛苦了一天一夜了,求各位大侠请赐教。var mySql = "SELECT * FROM table1 WHERE 发音=form1.txtjiansuo.text";
有朋友回答我说
var mySql = "SELECT * FROM table1 WHERE 发音='" & form1.txtjiansuo.text & "'";
可是提示“无效的SQL语句;期待‘delete’、‘insert’、‘procedure’、‘select’或‘update’”。
第一段可以执行。
--------------------------------------------------------------
function zhongying()
{
var mySql = "SELECT * FROM table1 WHERE 发音='nihao'";
var recordSet = database.Execute(mySql);
var tempText = "";
document.getElementById("dataDisplay").value = "";
while (!recordSet.EOF)
{
tempText = tempText + recordSet(0) + ":" +recordSet(2)+"【" +recordSet(3)+ "】"+ recordSet(4)+ recordSet(5)+"\n";
recordSet.MoveNext();
}
document.getElementById("dataDisplay").value = tempText;
recordSet.Close();
recordSet = null;
}
--------------------------------------------------------------
第二段的第一句出错了
(与第一段的区别就第一句,汗...用途是希望将用户在form1,id=txtjiansuo文本框中输入的值检索access表中发音字段)function yingzhong()
{
var mySql = "SELECT * FROM table1 WHERE 发音=form1.txtjiansuo.text"; var tempText = "";
var recordSet = database.Execute(mySql);
document.getElementById("dataDisplay").value = "";
while (!recordSet.EOF)
{
tempText = tempText + recordSet(0) + ":" +recordSet(2)+"【" +recordSet(3)+ "】"+ recordSet(4)+ recordSet(5)+"\n";
recordSet.MoveNext();
}
document.getElementById(dataDisplay).value = tempText;
recordSet.Close();
recordSet = null;
}
单引号前面加上转义符
单引号前面加上转义符来试试看
仔细看了下,第二段dataDisplay没有加"",现在加上了,也还是不行.
document.getElementById(dataDisplay).value = tempText;
能不能请您再再教教我.万分感谢!
附html相关部分:
<form name="form1">
SEARCH WORD:<input type="text" name="txtjiansuo" id="txtjiansuo">
还有
<div id="sqlDisplay"></div>
<textarea name="dataDisplay" id="dataDisplay" rows="20" cols="50"></textarea>
请赐教...
alert(cument.getElementById(dataDisplay).value);
其次确定tempText有值
alert(tempText)
alert(cument.getElementById(dataDisplay).value);
其次确定tempText有值
alert(tempText)
alert(cument.getElementById(dataDisplay).value);执行失败cument未定义.
alert(tempText);果然没有值...所以没有结果显示呢...附:执行时候代码是下面这样加的.
function rizhong()
{
var mySql = "SELECT * FROM table1 WHERE 发音 = \'form1.txtjiansuo.text\'";
var tempText = "";
var recordSet = database.Execute(mySql);
document.getElementById("dataDisplay").value = "";
while (!recordSet.EOF)
{
tempText = tempText + recordSet(0) + ":" +recordSet(2)+"【" +recordSet(3)+ "】"+ recordSet(4)+ recordSet(5)+"\n";
recordSet.MoveNext();
}
alert(cument.getElementById(dataDisplay).value);
alert(tempText);
document.getElementById("dataDisplay").value = tempText;
recordSet.Close();
recordSet = null;
}
这个兼容ie与火狐
document.getElementById('bt').innerText="赋值";
alert(document.getElementById(dataDisplay).value);缺少对象
这样你首先要确定tempText 它要有值 我现在怀疑你没有进while,所以tempText没有值,你在while里面alert一下,看进while了吗?如果没进再进行调式
如果现在tempText有值的话
就用document.getElementById("dataDisplay").innerText= tempText;
innerText兼容性很好
function rizhong()
{
var mySql = "SELECT * FROM table1 WHERE 发音 = \'form1.txtjiansuo.text\'";
var tempText = "";
var recordSet = database.Execute(mySql);
document.getElementById("dataDisplay").value = "";
while (!recordSet.EOF)
{
tempText = tempText + recordSet(0) + ":" +recordSet(2)+"【" +recordSet(3)+ "】"+ recordSet(4)+ recordSet(5)+"\n";
recordSet.MoveNext();
alert(document.getElementById(dataDisplay).value);
alert(tempText);
}
document.getElementById("dataDisplay").value = tempText;
recordSet.Close();
recordSet = null;
}
换成
(recordSet!=EOF)
我没看错吧?还是我out了?
应该是用active控件操作数据库吧,js只是操作返回的结果而已。