<% set abc = Server.CreateObject("MSWC.AdRotator") %> <% = abc.GetAdvertisement("/b2b01/admin/banner/ctrl_brc_conferences1.txt") %>

<% set def = Server.CreateObject("MSWC.AdRotator") %> <% = def.GetAdvertisement("/b2b01/admin/banner/ctrl_brc_conferences2.txt") %>


<% set ghi = Server.CreateObject("MSWC.AdRotator") %> <% = ghi.GetAdvertisement("/b2b01/admin/banner/ctrl_brc_conferences3.txt") %>

 

 

 
 
Select at least one option from any of the boxes.
Refresh
<% if Request.Form("select2") <> "" then sql = "select id,conname,conorganiser,constdate,conenddate from conference where conorganiser ='" & Request.Form("select2") & "' and cononline='1'" else sql = "select id,conname,conorganiser,constdate,conenddate from conference where cononline='1'" end if set rst1=nothing set rst1=server.CreateObject("ADODB.Recordset") rst1.Open sql,con1,adOpenDynamic %> <% if Request.Form("select3") <> "" then sql = "select * from conference where id =" & Request.Form("select3") set rst1=nothing set rst1=server.CreateObject("ADODB.Recordset") rst1.Open sql,con1,adOpenDynamic end if %>
Conference Organiser

<% set con1=server.CreateObject("ADODB.Connection") set rst1=server.CreateObject("ADODB.Recordset") if session("con_str")="" then session("con_str")="DSN=b2bcast;uid=b2bcast;pwd=nin19-9;database=b2bcast;" end if con1.Open session("con_str") sql = "select distinct(conorganiser) from conference where cononline='1'" 'id,,conname,constdate,conenddate rst1.Open sql,con1,adOpenDynamic %>

Conference Name
Conference Dates

<% set rst_topic=server.CreateObject("ADODB.Recordset") if trim(Request.Form("select3")) <> "" then sql_topic = "select id,sp_name,s_company from speakers where id in (select distinct(speakerid) from topicrole where topicid in(select id from topic where concode='" & trim(Request.Form("select3")) & "')) order by sp_name" else sql_topic = "select id,sp_name,s_company from speakers order by sp_name" end if rst_topic.Open sql_topic,con1,adOpenDynamic %>
<% set rst_topic=server.CreateObject("ADODB.Recordset") if trim(Request.Form("select3")) <> "" then sql_topic = "select distinct(s_company) from speakers where id in (select distinct(speakerid) from topicrole where topicid in(select id from topic where concode='" & trim(Request.Form("select3")) & "')) order by s_company" else sql_topic = "select distinct(s_company) from speakers order by s_company" end if rst_topic.Open sql_topic,con1,adOpenDynamic %>
Names
Organisation Represented

<% set rst_topic = nothing set rst_topic=server.CreateObject("ADODB.Recordset") if trim(Request.Form("select3")) <> "" then 'sql_topic = "select id,topic_name from topic where id in(select distinct(topic) from pres_files where conf_code='" & trim(Request.Form("select3")) & "')" sql_topic = "select id,topic_name from topic where concode='" & trim(Request.Form("select3")) & "'" else sql_topic = "select id,topic_name from topic where concode in(select id from conference where cononline='1') order by topic_name" end if 'Response.Write sql_topic rst_topic.Open sql_topic,con1,adOpenDynamic %> <% set rst_topic = nothing set rst_topic=server.CreateObject("ADODB.Recordset") sql_topic = "select id,name from industry_channel" rst_topic.Open sql_topic,con1,adOpenDynamic %>
Topic
Industry Channel
Keyword Search

Streaming Files
Show All          Video          Audio          Presentation
 
   
 


   

 

 

about b2bcast | business resource center | corporate service center | contact us | home
 
 

Download Windows Media Player