I have several projects which need a top notch ASP programmer for my site.

One is immediate and needs completing within a few days, which is only a few hours work, otehrs are more ongoing.

If you are a serious asp programmer with lots of experience please contact me for immediate start.

Beow is a small sample from one of our pages - If any of this confuses you dont apply! This is 50 lines of code from a page with 400 lines of code!

--------------------------------------------------------

dim strRemoveID
sql = "Select removed_ids from tblremovedid where id="&newID
Set rs = RetrieveRS(sql, Application("DataConn"))
if rs.eof=false and rs.bof=false then
strRemoveID = rs.GetString(,,,",")
strRemoveID = left(strRemoveID,len(strRemoveID)-1)
strRemoveID = replace(trim(strRemoveID)," ","")
else
strRemoveID = "0"
end if
dim strSeviceNumber
sql ="select ServiceNumber from PersonalDetails where ID in("&strRemoveID&")"
Set rs = RetrieveRS(sql, Application("DataConn"))
if rs.eof=false and rs.bof=false then
' strSeviceNumber = rs.GetString(,,,"','")
strSeviceNumber = rs.GetString(,,,"w|awuyt*<")
strSeviceNumber = replace(strSeviceNumber,"'","''")
strSeviceNumber = replace(strSeviceNumber,"w|awuyt*<","','")
strSeviceNumber = left(strSeviceNumber,len(strSeviceNumber)-2)
strSeviceNumber = "'" & strSeviceNumber

else
strSeviceNumber = "0"
end if

'Response.Write strSeviceNumber & "<br>"
sql = "SELECT ServiceNumber,ID,Service, Regiment,Regiment2,Regiment3,Regiment4,Regiment5,R egiment6,Regiment7,Regiment8,Regiment9,Regiment10, YearSignedUp,YearLeft,FirstName,SurName,StartDate, NewPhoto,OldPhoto,EmailAddress,Whereru,ServiceHist ory,lastupdated FROM PersonalDetails WHERE ID not in("&strRemoveID&") AND Service='" & strService & "' AND (Regiment LIKE '%" & strReg1 & "%' OR Regiment2 LIKE '%" & strReg1 & "%' OR Regiment3 LIKE '%" & strReg1 & "%' OR Regiment4 LIKE '%" & strReg1 & "%' OR Regiment5 LIKE '%" & strReg1 & "%' OR Regiment6 LIKE '%" & strReg1 & "%' OR Regiment7 LIKE '%" & strReg1 & "%' OR Regiment8 LIKE '%" & strReg1 & "%' OR Regiment9 LIKE '%" & strReg1 & "%' OR Regiment10 LIKE '%" & strReg1 & "%'"

If strReg2 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg2 & "%' OR Regiment2 LIKE '%" & strReg2 & "%' OR Regiment3 LIKE '%" & strReg2 & "%' OR Regiment4 LIKE '%" & strReg2 & "%' OR Regiment5 LIKE '%" & strReg2 & "%' OR Regiment6 LIKE '%" & strReg2 & "%' OR Regiment7 LIKE '%" & strReg2 & "%' OR Regiment8 LIKE '%" & strReg2 & "%' OR Regiment9 LIKE '%" & strReg2 & "%' OR Regiment10 LIKE '%" & strReg2 & "%'"
End If

If strReg3 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg3 & "%' OR Regiment2 LIKE '%" & strReg3 & "%' OR Regiment3 LIKE '%" & strReg3 & "%' OR Regiment4 LIKE '%" & strReg3 & "%' OR Regiment5 LIKE '%" & strReg3 & "%' OR Regiment6 LIKE '%" & strReg3 & "%' OR Regiment7 LIKE '%" & strReg3 & "%' OR Regiment8 LIKE '%" & strReg3 & "%' OR Regiment9 LIKE '%" & strReg3 & "%' OR Regiment10 LIKE '%" & strReg3 & "%'"
End If

If strReg4 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg4 & "%' OR Regiment2 LIKE '%" & strReg4 & "%' OR Regiment3 LIKE '%" & strReg4 & "%' OR Regiment4 LIKE '%" & strReg4 & "%' OR Regiment5 LIKE '%" & strReg4 & "%' OR Regiment6 LIKE '%" & strReg4 & "%' OR Regiment7 LIKE '%" & strReg4 & "%' OR Regiment8 LIKE '%" & strReg4 & "%' OR Regiment9 LIKE '%" & strReg4 & "%' OR Regiment10 LIKE '%" & strReg4 & "%'"
End If

If strReg5 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg5 & "%' OR Regiment2 LIKE '%" & strReg5 & "%' OR Regiment3 LIKE '%" & strReg5 & "%' OR Regiment4 LIKE '%" & strReg5 & "%' OR Regiment5 LIKE '%" & strReg5 & "%' OR Regiment6 LIKE '%" & strReg5 & "%' OR Regiment7 LIKE '%" & strReg5 & "%' OR Regiment8 LIKE '%" & strReg5 & "%' OR Regiment9 LIKE '%" & strReg5 & "%' OR Regiment10 LIKE '%" & strReg5 & "%'"
End If

If strReg6 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg6 & "%' OR Regiment2 LIKE '%" & strReg6 & "%' OR Regiment3 LIKE '%" & strReg6 & "%' OR Regiment4 LIKE '%" & strReg6 & "%' OR Regiment5 LIKE '%" & strReg6 & "%' OR Regiment6 LIKE '%" & strReg6 & "%' OR Regiment7 LIKE '%" & strReg6 & "%' OR Regiment8 LIKE '%" & strReg6 & "%' OR Regiment9 LIKE '%" & strReg6 & "%' OR Regiment10 LIKE '%" & strReg6 & "%'"
End If

If strReg7 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg7 & "%' OR Regiment2 LIKE '%" & strReg7 & "%' OR Regiment3 LIKE '%" & strReg7 & "%' OR Regiment4 LIKE '%" & strReg7 & "%' OR Regiment5 LIKE '%" & strReg7 & "%' OR Regiment6 LIKE '%" & strReg7 & "%' OR Regiment7 LIKE '%" & strReg7 & "%' OR Regiment8 LIKE '%" & strReg7 & "%' OR Regiment9 LIKE '%" & strReg7 & "%' OR Regiment10 LIKE '%" & strReg7 & "%'"
End If

If strReg8 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg8 & "%' OR Regiment2 LIKE '%" & strReg8 & "%' OR Regiment3 LIKE '%" & strReg8 & "%' OR Regiment4 LIKE '%" & strReg8 & "%' OR Regiment5 LIKE '%" & strReg8 & "%' OR Regiment6 LIKE '%" & strReg8 & "%' OR Regiment7 LIKE '%" & strReg8 & "%' OR Regiment8 LIKE '%" & strReg8 & "%' OR Regiment9 LIKE '%" & strReg8 & "%' OR Regiment10 LIKE '%" & strReg8 & "%'"
End If

If strReg9 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg9 & "%' OR Regiment2 LIKE '%" & strReg9 & "%' OR Regiment3 LIKE '%" & strReg9 & "%' OR Regiment4 LIKE '%" & strReg9 & "%' OR Regiment5 LIKE '%" & strReg9 & "%' OR Regiment6 LIKE '%" & strReg9 & "%' OR Regiment7 LIKE '%" & strReg9 & "%' OR Regiment8 LIKE '%" & strReg9 & "%' OR Regiment9 LIKE '%" & strReg9 & "%' OR Regiment10 LIKE '%" & strReg9 & "%'"
End If

If strReg10 <> "" Then
sql = sql & " OR Regiment LIKE '%" & strReg10 & "%' OR Regiment2 LIKE '%" & strReg10 & "%' OR Regiment3 LIKE '%" & strReg10 & "%' OR Regiment4 LIKE '%" & strReg10 & "%' OR Regiment5 LIKE '%" & strReg10 & "%' OR Regiment6 LIKE '%" & strReg10 & "%' OR Regiment7 LIKE '%" & strReg10 & "%' OR Regiment8 LIKE '%" & strReg10 & "%' OR Regiment9 LIKE '%" & strReg10 & "%' OR Regiment10 LIKE '%" & strReg10 & "%'"
End If

sql = sql & ") AND ('" & strStart & "' <= YearSignedUp AND '" & strEnd & "' >= YearSignedUp OR '" & strStart & "' <= YearSignedUp AND '" & strEnd & "' >= YearLeft OR '" & strStart & "' >= YearSignedUp AND '" & strStart & "' <= YearLeft OR '" & strStart & "' >= YearSignedUp AND '" & strStart & "' <= YearLeft) GROUP BY ServiceNumber ORDER BY SurName"'