ASP»ñÈ¡ÏÂÀ¿òÖÐÖµµÄÎÊÌâ - Web ¿ª·¢ / ASP
ÎÒÏë»ñµÃÏÂÀ¿òÀïÃæµÄÖµ¿ÉÊÇ×ÜÊÇ»ñµÃ×îºóÒ»¸ö
´úÂëÈçÏ£º
<select name="select19" id="select19" onchange="javascript:form.submit()">
<option selected="selected" value="0">ÇëÑ¡Ôñ</option>
<%
sql1="select brandName from brand GROUP BY brandName"
set rs1=UseDB.EditDB(sql1)
while not rs1.eof
brandName=rs1("brandName")
%>
<option value="<%=brandName%>"><%=brandName%></option>
<%
rs1.movenext
wend
set rs1=Nothing
%>
</select>
ÎÒÊÇÒª»ñµÃvalueÀïÃæµÄÖµ£¬Ò³ÃæÏÔʾµÄÖµÊǺõġ£
<%
sql1="select brandName from brand GROUP BY brandName"
set rs1=UseDB.EditDB(sql1)
do while not rs1.eof and rs1.bof
brandName=rs1("brandName")
%>
<option value="<%=brandName%>"><%=brandName%></option>
<%
rs1.movenext
loop
set rs1=Nothing
%>
</select>
²»Ðа¡Ðֵܣ¬ÄãÄÇÑùÁ¬¸öÖµ¶¼»ñÈ¡²»µ½ÁË
»òÕßÄÇλÐֵܰïÃ¦ÖØÐÂдһ¸ö£¬Ð»Ð»ÁË
Óà DropDownList »ñȡֵ²»ºÜÈÝÒ×Âð£¿ÄãÊÇÓÃʲô¿Ø¼þ»ñÈ¡µÄ£¿
ȡֵ£¿request("select19")È¡²»µ½Âð£¿
¿ÉÒÔÈ¡µ½Öµ£¬¿ÉÊÇ×ÜÊÇ×îºóÒ»¸öoptionµÄÖµ
onchange="javascript:form.submit()"ÕâÑùд£¬Ê×ÏȾͷ¸ÁËb/s±à³ÌµÄ´ó¼É£¬·þÎñÆ÷ºÍ¿Í»§¶Ë²»·Ö
Ó¦¸Ãµ÷ÓÃÒ»¸ö
Ïà¹ØÎÊ´ð£º
¹ØÓÚÍøÕ¾°²È«µÄÎÊÌ⣡
ÎÒÁ˽⵽µÄÍøÕ¾°²È«ÎÊÌâ°üÀ¨£º
sql×¢Èë©¶´ºÍ±©¿â©¶´»¹ÓÐÉÏ´«Â©¶´
³ýÁËÕâЩ»¹ÓÐÆäËûµÄ©¶´Ã´£¿
×¢Èë©¶´¿ÉÒÔͨ¹ý¹ýÂËÀ´·ÀÖ¹
±©¿â©¶´Ôõô·ÀÖ¹
»¹ÓÐÈËÉÏ´«µÄľÂíÊÇ.gif
ÕâÖÖ©¶´Ôõôȥ± ......
sqlserverµÄÊý¾Ý¿â£¬×Ö¶ÎÊÇimageÀàÐ͵ġ£Ôõôд´úÂ룬ÔÚÒ³ÃæÖеã»÷¡°ÏÂÔØ¡±¾ÍÄÜ´ò¿ªÄǸöÏÂÔØ¶Ô»°¿ò£¿
PS£ºOracleLob ÔÚsqlserverÀïÊÇʲô£¿
Response.Redirect("test.jpg")
ÒýÓÃ
Response.Redirect( ......
ÔÚPHPÖÐÓÐûÓÐÏñASPÖеļǼ¼¯(ADODB.Recordset )ÕâÖÖÀàÐ͵ĶÔÏó?¿É²»¿ÉÒÔÏñÔÚASPÖÐÒ»Ñùͨ¹ý¼Ç¼¼¯À´¸üÐÂÊý¾Ý¿â.ÈçÏÂÃæÕâÑù.
VBScript code:
set rs=server.createobject("adodb.recordset")
......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......