Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ElJayWilson

    Loop through query and exec a stored proc for each record

    I am trying to figure out how to loop through a recordset and call a stored proc (from within a stored proc) to send out emails. We have an SP that will do all the work of sending out emails, I just need some help in modifying my SP to send one email for every record in the recordset. Here is...
  2. ElJayWilson

    LEFT OUTER JOIN Problem

    I have a table that has some records that are the same other than one of the fields is NULL in one record and populatated in another record (same AwardNumber, different ActivityNumbers). The following view will not pull records due to there being instances of NULL values for Mnemonic in the...
  3. ElJayWilson

    Getting Session Variable via AJAX - Not working

    I am having the most difficult time getting the value of a a session variable using AJAX. I am inheriting a classic ASP application and it uses session vars to keep track of key information. I am trying to get to those values using javascript and httprequest. It doesn't work consistently...
  4. ElJayWilson

    Using PatIndex

    I have tried using PatIndex in a query, but can't seem to get a grasp on it. What I am trying to do is generate a string that contains the first initial and then the last name from a field that contains the full name formatted like this: WILSON,LARRY JAY What I want to wind up with is L...
  5. ElJayWilson

    Expected end of statement Error (that makes no sense)

    For the life of me, I cannot figure out why I am getting this error: Microsoft VBScript Compilation error 800a0401 Expected end of statement /ajax/ajax.asp line 13 dim myCommand as string = Request.QueryString(&quot;cmd&quot;) -----^ Here is my code <% Response.Expires = 0...
  6. ElJayWilson

    Autocomplete Not Working

    I just cannot get this to work. I am trying to use an Autocomplete with a windowing system and it just won't work. Here is the code I use to create a window: function createwindow(parameters) { dialogopen=true; var divid = parameters['divid']; var title = parameters['title']; var text =...

Part and Inventory Search

Back
Top