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...
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...
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...
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...
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...
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");
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.
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...
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...
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("cmd")
-----^
Here is my code
<%
Response.Expires = 0...
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...
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 =...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.