Datasource:emp
Template:emp.htx
SQLStatement:SELECT distinct emptype, mid([emptype],4,14) as emptype1
+FROM JobDisplay
+Where emptype='51 ContingentI'
SQLStatement:SELECT *, Left([postingdate],10) as displaypostingdate, Left([closingdate],10) as displayclosingdate
+FROM JobDisplay
+Where postingdate<=Date() and emptype='51 ContingentI' 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='51 ContingentI' and closingdate >=Date() and closingdate >Time()
+Order by FunctionalTitle ASC, dept ASC;




Password:
Username: