showModalDialog ·µ»ØÖµ ²éѯsql´íÎó
×Ó´°Ìå´«µ½¸¸´°ÌåµÄÖµ£¬Í¨¹ý²éѯÓï¾ä²éѯÊý¾Ý¿â£¬ÏÖÔÚÊÇÒ»´ò¿ª¸¸´°Ìå¾Í¿ªÊ¼Ö´ÐÐSQLÓï¾ä±¨´í£¬Èç¹û°ÑSQLÖ´ÐÐÓï¾ä×¢ÊÍ£¬ÓÖÄÜÕý³£ÏÔʾKµÄÖµ£¬Çë¸ßÊÖ°ïæ¿´¿´¡£Ð»Ð»£¡£¡£¡
¸¸Ò³Ãæ´úÂ룺VBScript code:
function Client_List(){
var k=window.showModalDialog('Client_List.asp',window,'dialogWidth:600px;dialogHeight:700px;help:0;status:0;resizeable:0;scroll:no;status:no');
if(k!=null){
//document.getElementById("ClientName").value=k;//ÕâÀï²âÊÔ¿ÉÒÔÈ¡kµÄÖµ
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from Client_Table where ID="&k
rs.open sql,conn,1,1
%>
alert(k);//ÕâÀïÄÜ´òÓ¡KµÄÖµ
}
else{
alert("ȡֵΪ¿Õ");
}
}
×ÓÒ³Ãæ´úÂ룺
function retrun_Value()
{
var selectedIndex = -1;
var i =0;
for(i=0;i<myform.khxh.length;i++)
{
if(myform.khxh[i].checked){
selectedIndex=i;
window.returnValue=myform.khxh[i].value;
window.close();
break;
}
}
if(selectedIndex <0)
{
alert("ÇëÑ¡Ôñ");
}
}
Ä㻹ÊÇÏÈÈ¥¸ãÇå³þ·þÎñÆ÷½Å±¾ºÍ¿Í»§¶Ë½Å±¾µÄÇø±ðÔÙ˵°É£¡
ÄÇÎÒÕâ
Ïà¹ØÎÊ´ð£º
....½Óµ½Ò»¸öС³ÌÐò..¹¤×÷ÔÀ´´ó¸ÅÊÇÕâÑùµÄ...ǰ̨ÊÇWEB·þÎñÆ÷.¼Ü¹¹¾ÍÊÇASP+SQL..ǰ̨ÓÉASPÏòSQLÌí¼Ó·þÎñÀà±ð(±íµ¥).È»ºóÓÖºǫ́³ÌÐò¶ÁÈ¡±íµ¥..Ҫʵʱ¶ÁÈ¡..È»ºóÏÔʾÔÚ·þÎñÆ÷ÉÏÃæ..´ÓÀíÂÛÉÏÃæÄÜÐÐͨ²»?Èç¹û¿ÉÒÔ..ºǫ́ ......
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
ÎÒEXCELÖÐÒ»¸öµ¥Ôª¸ñµÄÊý¾ÝÈç "2009-01","8949-232"
½«Õâ¸öÊý¾ÝÕ³Ìùµ½PL/SQLÖеÄÒ»¸ö±íÖкó,Êý¾ÝÈ·ÊdzÉΪÁË 2009-01,8949-232 ,°ÑËùÓеÄ""¶¼Ã»ÁË,
ÈçºÎÅªÄØ?Çë´ó¼ÒÊÔ ......
sql2005
select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......