<%@ Language=VBScript %> <%Option Explicit%> <% Response.Buffer = true %> BuildersPlanet.com Ready To Work Post <% 'put this on pages that require log in vLogin_id = ForceLogin( Request.Cookies("BPLN")("Scrbl") ) %> <% ' set field vars dim vRdy2wrk_id, vSkillCat, vWrkType, vSkills, vAvailL, vWages, vContact dim vPost2wk, vPost4wk, vRemovePost, vRemovePostW, vRPostBox dim vPostTm, vToWeb, vToList,vToPriv, vSched, vName, vCreate, qRecId, vOrigin dim vSuccess, vOk_todistr, vNoFeat, vSpmChck vRdy2wrk_id = "" vSkillCat = "" vWrkType = "" vSkills = "" vAvailL = "" vWages = "" vName = "" vContact = "" vSched = "" vPostTm = "" vPost2wk = "checked" vPost4wk = "" vToWeb = "checked" vToList = "" vToPriv = "" vSpmChck ="0" vCreate = "" vOrigin = "" vRemovePost = "" vRemovePostW = "" vRPostBox = " " vNoFeat = "" vLoginName ="" if(not isempty (Request.QueryString("qRecId")))then vRdy2wrk_id = Request.QueryString("qRecId") ' visit to page - get info from db ' 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") vSQL = "GetRdy2WrkInfo '" & vLogin_id & "', '" & vRdy2wrk_id & "'" set vRec = conn.Execute ( vSQL ) if( not vRec.EOF ) then vRdy2wrk_id = vRec("rdywrk_id") vSkillCat = vRec("skill_Categ") vWrkType = vRec("wrk_type") vSkills = vRec("skills") vAvailL = vRec("avail_loc") vWages = vRec("wages") vName = vRec("ad_name") vContact = vRec("contact_inf") vSched = vRec("schedule") vPostTm = vRec("post_time") if( vPostTm = "4")then vPost4wk = "checked" vPost2wk = "" else vPost4wk = "" vPost2wk = "checked" end if vToWeb = vRec("to_web") vToList = vRec("to_list") vToPriv = vRec("to_priv") vCreate = vRec("created") vRPostBox = " Remove this posting (Delete) " end if end if if (Session("feature_set")< 2)then vNoFeat = ", certain requested information on your 'About Me' page of your 'Desktop' is incomplete. This may cause a delay in posting the following information. To assure a speedy post, please provide the requested information on the About Me page of your Desktop then return to this page. Or continue and be aware of possible delays in your post." vLoginName = Session("login_name") end if %> <% dim vState if(isempty (Request.QueryString("qRecId")))then set conn = server.CreateObject("adodb.connection") conn.Open Application("DBName"),Application("DBUser"),Application("DBPswd") vSQL = "GetuAdminProf '" & vLogin_id & "'" set vRec = conn.Execute ( vSQL ) 'set form information vName = vRec("first_name") & " " & vRec("last_name" ) vState =", " & vRec("state1") & ", " if vRec("state1")="Choose a State" then vState = "" end if vContact = "Phone: " & vRec("phone1") & vbCRLF & "Fax: " & vRec("fax1") & vbCRLF & "Email: " & vRec("comp_email") & vbCRLF & vRec("address1") & vbCRLF & vRec("city1") & vState & vRec("zip1") end if %> <% if not isempty( Request.Form("submit") ) then ' the user hit the submit button ' update or create the info vLogin_id = Session("login_id") vRdy2wrk_id = Request.Form("ready2workid") 'updating a record if value 'new record if empty vSkillCat = Request.Form("skillcateg") vWrkType = Request.Form("worktype") vWrkType = replace(vWrkType,"'","''") vSkills = Request.Form("skills") vSkills = replace(vSkills,"'","''") vAvailL= Request.Form("location") vAvailL = replace(vAvailL,"'","''") vWages = Request.Form("wages") vWages = replace(vWages,"'","''") vName = Request.Form("name") vName = replace(vName,"'","''") vContact = Request.Form("contact") vContact = replace(vContact,"'","''") vSched = Request.Form("schedule") vSched = replace(vSched,"'","''") vPostTm = Request.Form("posttime") vToWeb = Request.Form("toweb") if (Request.Form("remove") = "checked") then vToWeb = "" end if vToList = Request.Form("tolist") vToPriv = Request.Form("topriv") vSpmChck = tt(vWrkType&vSkills&vAvailL&vWages&vContact&vSched&vName) vOrigin = "web" vRemovePost = Request.Form("remove") if (vRemovePost = "checked") then vRemovePostW = Session("login_id") end if vOk_todistr = "yes" if (Session("feature_set")< 2)then vOk_todistr = "verify" end if set conn = server.CreateObject("adodb.connection") conn.Open Application("DBName"),Application("DBUser"),Application("DBPswd") vSQL = "SetRdy2Wrk '" & vLogin_id & "', '" & vRdy2wrk_id & "', '" & vSkillCat & "', '" & vWrkType & "', '" & vSkills & "', '" & vAvailL & "', '" & vWages & "', '" & vName & "', '" & vContact & "', '" & vSched & "', '" & vPostTm & "', '" & vToWeb & "', '" & vToList & "', '" & vToPriv & "', '" & vSpmChck & "', '" & vOrigin & "', '" & vRemovePost & "', '" & vRemovePostW & "', '" & vOk_todistr & "'" conn.Execute ( vSQL ) ' no results 'vSuccess = "Your Information Was updated Successfully
" Response.Redirect ("/Common/formsuccess.asp?originalPage="&Request.ServerVariables("SCRIPT_NAME"))'go here after submittal end if %> ">
BuildersPlanet.comBuildersPlanet Home Page
Marketplace Job Bank Buy/Sell Community News Services
 HOME  >  Job Bank >  Ready to Work  >  Ready to Work Form ','instantmessage','width=375,height=400')>Instant Feedback

Ready to work

Describe your abilities and availability so that those hiring can find you.

FREE!. This listing will be viewables on our site soon and will stay up for 2 to 4 weeks depending on your choice. You may change, update or delete postings as noted below. Post home page or permanent ad with your portfolio and resume for prospective employers to view.

Look at prospective employees.

<%=vLoginName%><%=vNoFeat%>
Items with an * are required.
Pressing the return key between text in a multi-line fields will display that text on a new line when users view this item.
We suggest this for lists or addresses. You can change or delete any ' auto filled' information.
*

Skill Category
 

Type of work available for
What Kind of work do you want Remodeling, Commercial, Piece work, etc.
 

Skills
Ex. Framing, Rough Plumbing,and Other Specifics
*

Location(s) available to work
 

Wages Range, None or Specific
  Contact Name
*

Contact information
Phone, E-mail, Address, etc.
  Available Schedule
Part Time, Full, ASAP, Summer
 

Length of posting

 id="posttime" name="posttime" type="radio" value="2" > 2 weeks id="posttime" name="posttime" type="radio" value="4"> 4wks(max allowed)
 
> Post to web > Post to List > Post Private
This will post this information to the BuildersPlanet.com website This will send this Information to interested parties on our list This will send this information only to your preferred list of businesses (My Desktop)
  You may change, update or delete information posted to the web site by clicking the update button on the display page.
List and Private options are sent immediately thus can not be updated or changed.
  <%=vRPostBox%>

Legal notice: BuildersPlanet.com reserves the right to not allow any posting for any reason. BuildersPlanet.com is NOT responsible for the content submitted or any errors in any posting. A posting does not constitute an endorsement or assurance of accuracy for any posting by BuildersPlanet.com.You agree to terms above and you agree to indemnify and hold BuildersPlanet.com harmless for any claim or damages arising from the use of this form and/or content of materials submitted to BuildersPlanet.com Website. By using this site you accept our terms and privacy policy. For comments or problems email Webmaster@buildersplanet.com