|
<%
exbId=Request("exbId") 'exbId=6
'accessdb="tradeshow.mdb"
'myDSN="DRIVER={Microsoft Access Driver (*.mdb)};"
'myDSN=myDSN & "DBQ=" & server.mappath(accessdb)
set db=server.CreateObject("adodb.connection" )
set rs=server.CreateObject("adodb.recordset")
'set rs=server.CreateObject("adodb.recordset")
db.open "driver={SQL Server};server=localhost;database=easy2source_com_easysource2;uid=easy2source_com_easysource;pwd=n-h3d$v^b2#vr!x"
dim sql
sql="select ExbTitle,ExbStartDate,ExbEndDate,Venue from Exhibition where Exhibition_id="&exbId
rs.open sql ,db,3
dup_org_fl=0
if rs.recordcount > 0 then
dup_org_fl = 1
exbTitle=rs("ExbTitle")
exbStartDate=rs("ExbStartDate")
exbEndDate=rs("ExbEndDate")
exbVenue=rs("Venue")
'exbImgPath=rs("ExbImagePath")
end if
rs.Close
'exbId=6
sql="select * from Category where Cat_id in(select Cat_id from Exhibition_Category where Exhibition_id= " & exbId & " ) and len(Index1) = 3"
set rsCat3=server.CreateObject("adodb.recordset")
rsCat3.Open sql ,db,3
set rsCat6=server.CreateObject("adodb.recordset")
sql="select * from Category where Cat_id in(select Cat_id from Exhibition_Category where Exhibition_id= " & exbId & " ) and len(Index1) = 6"
rsCat6.Open sql ,db,3
%>
<%
tradelindividualeft exbId ' leftside panel
%> |
Exhibitor Registration
|
<%
Response.Write(ucase(exbTitle))
Response.Write(" ")
Response.Write(exbStartDate & " - " &exbEndDate & " ")
Response.Write(exbVenue & " ")
Response.Write(" | ")
%>
|
<%
'Response.Write "Click Here!"
%>
Note : Please enter accurate information to use the trade services productively. The given information helps us understand your business processes and needs, while maintaining trust and goodwill in the marketplace.
Please enter your company details:
Fields marked with asterisk ( * ) are mandatory
|
|
<%
traderight
tradecopyright
%>
|