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 Mike Lewis 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

    Javascript not invoked until browser refresh?

    Check out using jQuery and then use the $(document).ready method.
  2. ElJayWilson

    Scrollbar UI emulation

    Show what you have coded. Would be next to impossible to help you figure something out without knowing what you have done.
  3. ElJayWilson

    Loop through query and exec a stored proc for each record

    It is going to run once a day and have at most 10 records to process. An application for this small job is not an efficient way to do it. The SP is already running once a day (when the Reporting Services report runs), so if I were to go the application route, I would have to build the app and...
  4. ElJayWilson

    Loop through query and exec a stored proc for each record

    Since we have an established SP for sending out emails, it only makes sense to use it. I didn't write that one, but it sure works very nicely.
  5. 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...
  6. ElJayWilson

    LEFT OUTER JOIN Problem

    I understand what you are saying, but actually - I don't want any records returned when there are no matching records in CHAOS_Awards. I should get back nothing. What I am getting now is records with the Mnemonic field being NULL. Here is an example of two records in the table for a given...
  7. ElJayWilson

    LEFT OUTER JOIN Problem

    That worked, but I am getting a value of NULL for the Mnemonic field. I would be getting a real value (something like "ITMER") Is is possible to select the matching record in CHAOS_Awards that doesn't have the Mnemonic of "NULL"? BTW - Thanks for the tips on the where statement. I need all...
  8. 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...
  9. ElJayWilson

    Getting Session Variable via AJAX - Not working

    Solved. The problem was caching in IE. Didn't happen it Firefox. Adding this before I do the ajaxrequest.open solved the issue. ajaxrequest.setRequestHeader("If-Modified-Since", "Sat, 1 Jan 2000 00:00:00 GMT");
  10. ElJayWilson

    Getting Session Variable via AJAX - Not working

    Maybe this will help with troubleshooting. The code seems to work just fine on Firefox. I am using Firebug and it is returning the proper session variable value.
  11. 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...
  12. ElJayWilson

    Using PatIndex

    Works like a charm!!! Plus I can see what I need to be doing now :). Thanks RiverGuy!
  13. 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...
  14. 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...
  15. ElJayWilson

    Autocomplete Not Working

    It is on a private network. The issue is definitely a DOM issue I think. I can get the autocomplete to work just fine when it is on its own page. When I try to add the textbox to the form I generate using a javascript window, it doesn't work. LJ P.S. The javascript windowing system I am...
  16. 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 =...
  17. ElJayWilson

    dialing rules

    In your dialplan, use a mask like this: exten => _9NXXXXXX,1,Dial(${TRUNK}/$[w${EXTEN:${STRIPMSD}}]) Use the same method for other types of calls (800, long distance, etc). In the globals section put the following: TRUNK=Zap/g0 ; Trunk interface STRIPMSD=1 ; MSD digits to strip (usually...
  18. ElJayWilson

    IP Phone on Asterisk (Trixbox)

    Is there a "Send" key on that phone?

Part and Inventory Search

Back
Top