Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    4

    Seriously Advanced ASP Programmer needed

    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"'

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    That's one ugly bit of code dude. if you are seriously looking for someone to help you with this I'd suggest posting some details regarding location, back end systems, overall project view and renumeration...

    Best of luck in your search.

  3. #3
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Well it's mostly building a SQL statement but I haven't seen too many pages that use GetString as GetRows is already pretty fast and retains the nature of each field instead of throwing all the fields (and rows) into one string.

    Speed Tips by Charles Carroll
    http://www.learnasp.com/learn/speedtips.asp
    <<
    GetRows is fast and GetString is faster but doesn't allow formatting of a field.
    The only thing faster than GetString I believe would be putting a recordset into an application variable.
    >>

    But yes it would be nice to know other things about how big and complex the project is, how much traffic there is, what kind of database is used...
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  4. #4
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    depends what you want to use the return values for. if, for example you want to all the id's returned in an in clause it might be handy.... or if you wanted to convert it into an array....... not saying it is the best way, but it is a way....

    there has got to be a better way of building that sql though.... atleast I would hope there would be...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •