Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
ohrwurm
Jun 25, 2003

Some gems from an ASP app that I inherited:

code:
if strCompanyID = "1" then
    intCompanyID = 1
elseif strCompanyID = "2" then
    intCompanyID = 2
elseif strCompanyID = "3" then
    intCompanyID = 3
elseif strCompanyID = "4" then
    intCompanyID = 4
end if
:what:

code:
strsql = ""
  strsql = "select AppVars.RecordID From AppVars where AppVars.VarName = 'RAFDE'" 
  set rsGetRAFDE = Server.CreateObject("ADODB.Recordset")
  rsGetRAFDE.ActiveConnection = connection
  rsGetRAFDE.Open(strsql)
  if not rsGetRAFDE.EOF then
    strRAFDE = cstr(rsGetRAFDE.Fields("RecordID"))
  end if
  rsGetRAFDE.Close
  set rsGetRAFDE = nothing

  strsql = ""
  strsql = "select AppVars.RecordID From AppVars where AppVars.VarName = 'RAF2'" 
  set rsGetRAF2 = Server.CreateObject("ADODB.Recordset")
  rsGetRAF2.ActiveConnection = connection
  rsGetRAF2.Open(strsql)
  if not rsGetRAF2.EOF then
    strRAF2 = cstr(rsGetRAF2.Fields("RecordID"))
  end if
  rsGetRAF2.Close
  set rsGetRAF2 = nothing
This block above gets used about 10 more times in the exact same way, just to set some variables. It's like they have never heard of functions.

Imagine at least 25 pages of this at several thousand lines each littered with inline sql, years of uncommented edits, and tons of copied and pasted code and you will see what I work with daily.

Adbot
ADBOT LOVES YOU

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply