<%
If blnLoggedIn Then
strSQL = "SELECT jobID, jobTitle, jobCompany, jobDesc FROM tblJobs WHERE jobChapter = " & intChapterID & " AND " & _
"(jobExpire IS NULL OR jobExpire >= """ & formatDateMySQL(Date()) & """) ORDER BY jobPosted DESC;"
Set rsInfo = objConn.Execute(strSQL)
%>
<% If Not rsInfo.EOF Then %>
<% Do While Not rsInfo.EOF %>
<%= rsInfo(1) %> - <%= rsInfo(2) %>
<%= Left(Replace(rsInfo(3),"
"," "),150) %>...
|
<% rsInfo.MoveNext: Loop %>
<% Else %>
There are no job listings at this time. Please check back soon
<% End If %>
<% Else %>
You must be signed in to view job listings. Please sign in.
<% End If %>
|
