Ready
To Work Record Details
This is the record Detail you requested
These
are professionals Ready to Work.
Are you a construction professional with a schedule opening ?
Post Work Force Hotlist
Post Ready to Work if your
looking for a position or longer term projects.
Post Employment Ad
You can
update or delete an existing listing by pressing the update link next
to a listing.
You must be logged in to see the update links or to make an update. Close
this window <%
' connect to the database
dim conn ' hold the connect to the database
dim vSQL ' holds the sql statement to execute
dim vRec ' holds the record from query.
set conn = server.CreateObject("adodb.connection")
conn.Open Application("DBName"),Application("DBUser"),Application("DBPswd")
' set field vars
dim vRdy2wrk_id, vSkillCat, vWrkType, vSkills, vAvailL, vWages, vContact
dim vPostTm, vToWeb, vToList, vToPriv, vName, vSched, vCreateDt
dim vSuccess, vUpdateBut
vLogin_id = Session("login_id")
vRdy2wrk_id = Request.QueryString("qRecId")
' visit to page - get expandedinfo from db that relates to Record id
vSQL = "select * from ready2work where rdywrk_id =" & vRdy2wrk_id
set vRec = conn.Execute (vSQL)
if( Not vRec.Eof)then
'if( not vRec.EOF ) then
vRdy2wrk_id = vRec("rdywrk_id")
vSkillCat = vRec("skill_Categ")
vWrkType = vRec("wrk_type")
vSkills = vRec("skills")
vSkills = replace(vSkills,vbCRLF,"
")
vAvailL = vRec("avail_loc")
vWages = vRec("wages")
vName = vRec("ad_name")
vContact = vRec("contact_inf")
vContact = replace(vContact,vbCRLF,"
")
vSched = vRec("schedule")
vPostTm = vRec("post_time")
vToWeb = vRec("to_web")
vToList = vRec("to_list")
vToPriv = vRec("to_priv")
vCreateDt = left(vRec("created"),8)
vUpdateBut=" "
if (vLogin_id = vRec("login_id"))then
vUpdateBut = "(update)"
end if
end if
%>
| Ready to Work Post | <%=vUpdateBut%> |
| Work Type Category: | <%=vSkillCat%> |
| Work Type Requested: | <%=vWrkType%> |
| Skills: | <%=vSkills%> |
| Locations Available to Work: | <%=vAvailL%> |
| Wages Requested: | <%=vWages%> |
| Name: | <%=vName%> |
| Contact Info: | <%=vContact%> |
| Schedule: | <%=vSched%> |
| Date Posted: | <%=vCreateDt%> |