|
|
|
<%
Set conn = server.CreateObject("ADODB.connection")
Conn.open "Provider=MSDASQL.1;Password=11312003;Persist Security Info=True;User ID=sa;Data Source=MusicDatabase;Extended Properties=""DSN=MusicDatabase;UID=sa;APP=Microsoft Development Environment;WSID=JORDAN;DATABASE=MusicDatabase;Network=DBMSSOCN;Address=localhost"";User Id=sa;PASSWORD=11312003;"
SQL2="select istationid,sgenre from t_stations where showonChannelChanger=1 order by sGenre"
set rs=conn.Execute(SQL2)
%>
|
