正在学习ASP + javascript + SQL
<input onBlur="login_onblur()" name="yhid" type="text" id="textfield2" size="30" />
<%
function login_onblur()
{
var sql
sql = "select A.User_code,A.User_name,A.User_PSD,CONVERT(varchar(100), P.Begin_date, 23) as Begin_date, CONVERT(varchar(100), P.END_date, 23) as END_date,Q.vendorCode,Q.cvenname FROM vendor_username A LEFT JOIN vendor_JiaoFei P ON A.vendorid=P.vendorid LEFT JOIN ba_vendor_all Q ON A.vendorid=Q.vendorid where A.if_active=1 and getDATE()>=P.Begin_date and getDATE()<=P.END_date and A.User_Code=" Response.Write(sql)
Response.End}
%>运行结果是:无任何反应,也无任何出错提示。
<input onBlur="login_onblur()" name="yhid" type="text" id="textfield2" size="30" />
<%
function login_onblur()
{
var sql
sql = "select A.User_code,A.User_name,A.User_PSD,CONVERT(varchar(100), P.Begin_date, 23) as Begin_date, CONVERT(varchar(100), P.END_date, 23) as END_date,Q.vendorCode,Q.cvenname FROM vendor_username A LEFT JOIN vendor_JiaoFei P ON A.vendorid=P.vendorid LEFT JOIN ba_vendor_all Q ON A.vendorid=Q.vendorid where A.if_active=1 and getDATE()>=P.Begin_date and getDATE()<=P.END_date and A.User_Code=" Response.Write(sql)
Response.End}
%>运行结果是:无任何反应,也无任何出错提示。
解决方案 »
- js如何获得下拉列表的值,并把这个值赋给文本框
- extjs脚本写的界面在ie里显示正常.在firefox里显示无法触发脚本事件
- window.open 打开一个新一窗口时,为什么IE7地址栏还在?
- 高分急求js 脚本 实现 div 隐藏和显示
- 一个框架页面,怎么判断window.parent.opener是否关闭??
- createTextNode换行问题
- 请教:如何用js编写实现tomcat下jsp文件打开apache下html文件
- 怎样用JS判断一个上传文件的名字是不是中文和它的类型
- json数据的装换
- 怎么把一组数字用逗号分隔,再给每个数字加上双引号,急救啊
- dwr中的问题,求高人指点啊。。。。。。。。弄了两天了
- 日期插件input的value值 怎么自动获取当前电脑的 年月日
function getPage(url){
var xhr=window.ActiveXObject? new ActiveXObject("Microsoft.XMLHTTP"):new XMLHttpRequest();
xhr.open('get',url,false);
xhr.send(null);
return xhr.responseText
}
function login_onblur()
{
var content= getPage(login_onblur.asp)
alert(content)
}独立个asp页面 login_onblur.asp
var sql
sql = "select A.User_code,A.User_name,A.User_PSD,CONVERT(varchar(100), P.Begin_date, 23) as Begin_date, CONVERT(varchar(100), P.END_date, 23) as END_date,Q.vendorCode,Q.cvenname FROM vendor_username A LEFT JOIN vendor_JiaoFei P ON A.vendorid=P.vendorid LEFT JOIN ba_vendor_all Q ON A.vendorid=Q.vendorid where A.if_active=1 and getDATE()>=P.Begin_date and getDATE()<=P.END_date and A.User_Code=" Response.Write(sql)