Datasource:emp
Template:emp.htx
SQLStatement:SELECT distinct emptype, mid([emptype],4,20) as emptype1
+FROM JobDisplay
+Where emptype='30 Graduate Assistant'
SQLStatement:SELECT *, Left([postingdate],10) as displaypostingdate, Left([closingdate],10) as displayclosingdate
+FROM JobDisplay
+Where postingdate<=Date() and emptype='30 Graduate Assistant' and closingdate >=Date() and closingdate >Time()
+Order by FunctionalTitle ASC, dept ASC
SQLStatement:SELECT *, Left([postingdate],10) as displaypostingdate, Left([closingdate],10) as displayclosingdate
+FROM JobDisplay
+Where postingdate<=Date() and emptype='30 Graduate Assistant' and closingdate >=Date() and closingdate >Time()
+Order by FunctionalTitle ASC, dept ASC;




Password:
Username: