% Session("domain")=22 domain="22" dateCheck=cdate(Cstr(datepart("d",Now))+"/"+Cstr(datepart("m",Now))+"/" + Cstr(datepart("yyyy",now))) set datapath1=server.createobject("adodb.connection") datapath1.open strConnTucsa sql="SELECT * FROM messages WHERE (category=95) AND domain=" & domain & "AND expiryDate>" & dateCheck & " ORDER BY entryDate DESC" set rsh=datapath1.execute(Sql) sql="SELECT * FROM messages WHERE thumbnail='' AND (category=2 or category=1 or category=34 or category=40 or category=41 or category=43) AND domain=" & domain & "AND expiryDate>" & dateCheck & " ORDER BY entryDate DESC" set rsd=datapath1.execute(Sql) sql="SELECT * FROM messages WHERE section=3 AND domain=" & domain & "AND expiryDate>" & dateCheck & " ORDER BY entryDate DESC" set rse=datapath1.execute(Sql) sql="SELECT * FROM messages WHERE category=9 AND domain=" & domain & "AND expiryDate>" & dateCheck & " ORDER BY entryDate DESC" set rsm=datapath1.execute(Sql) sql="SELECT * FROM messages WHERE category=4 AND domain=" & domain & "AND expiryDate>" & dateCheck & " ORDER BY entryDate DESC" set rsp=datapath1.execute(Sql) sql="SELECT * FROM messages WHERE category=2 AND manset<>'ON' AND thumbnail<>'' AND domain=" & domain & "AND expiryDate>" & dateCheck & " ORDER BY entryDate DESC" set rsresimli=datapath1.execute(Sql) sql="SELECT * FROM messages WHERE manset='ON' ORDER BY message_id DESC" 'sql="SELECT * FROM messages WHERE attachment<>'' AND domain=" & domain & "AND expiryDate>" & dateCheck & " ORDER BY entryDate DESC" set rsmanset=datapath1.execute(Sql)%>
![]() |
||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||
| Türk Yapısal Çelik Derneği - Turkish Constructional Steelwork Association | ||||||||||||||||||||||||||||||||||||||||||||||||||||