Search results for query: *

If I run this code, I get the proper results: SELECT SUM(CASE WHEN MS.strMilestoneStatus = 'GREEN' THEN 1 ELSE 0 END) [COUNT_GREEN], SUM(CASE WHEN MS.strMilestoneStatus = 'YELLOW' THEN 1 ELSE 0 END) [COUNT_YELLOW], SUM(CASE WHEN MS.strMilestoneStatus = 'RED' THEN 1 ELSE 0...

Hi, I want to use the Windows authentication mechanism in the Web.Config to make sure the users are authenticated against a particular Windows group, like: <authentication mode="Windows"> </authentication> <authorization> <allow roles="DOMAIN\WINDOWSGROUP" /> <deny...

Hi, I am trying to display an HTML table in an excel cell. I am using VBscript to write the table to the Excel file - it looks something like this: Set objWorksheet = objWorkbook.Sheets.Add objExcel.activeworkbook.ActiveSheet.name = "Chart for Project 1" objWorksheet.Columns.AutoFit...

Hi folks, I am exporting to excel via VBScript and I am trying to figure out how to set the legend - what looks wrong with this? The code for the chart is as follows, the resulting image is attached: objWorksheet.Columns.AutoFit Dim objRange : Set objRange = objWorksheet.Range("B2","B4")...

Hi, I am querying a test AD that I set up today, that is its own forest and DNS - the name is OPENTEST.EXAMPLE. I created a user called "jfogarty" on it, so the logon is "OPENTEST\jfogarty". This user is part of the "Domain Users" group, but not "Users". I am trying to use VB to see if that...

Hi, I can't access the following XML structure - it never goes into the if statement. The Web.Config I am accessing is well formed and this is the structure. Ideas why? Dim doc As XmlDocument = New XmlDocument() doc.Load("C:\Documents and...

Hi, I have a VBScript function to export to excel - it finds an item on the page and then grabs the outerHTML and uses the COM components of Excel to write it out. However, it writes out nothing and a msgbox check to see what the HTML is is empty. The page is a content page in a master page...

Hi, I am using Windows authentication on an intranet application - the web.config looks something like this: <authentication mode="Windows"> </authentication> <authorization> <allow users="domain\user, BUILTIN\Administrator, BUILTIN\Administrators"/> <deny users="*"/>...

Hi, I have a gridview that is causing some problems. I have a few questions. 1) Is it possible to have a custom error message? I have autogeneratedeletecolumn set to true, but in some cases I may not be able to delete an item (foreign key restraint, etc) - can I show a custom error message...

Hi folks, I have a gridview that I would like to filter based on a radio button selection - however, the filter doesn't seem to work properly. What I'd like to do is assign parameters and filter based on the values of a column called "Status" - am I doing this the right way? Radio...

Hi, I have a working embedded gridview on one page that loads on the page load and pulls the select parameter from a query string; I tried to recreate it on another page where the grid is populated dynamically once a button is clicked, but it does not work: Button click event...

Hi, I am trying to write a file out to an Excel, tab-delimeted file. I do this by going through a datatable, getting the values and creating a tab-delimited string, which I then try to write out. However, when I use the response.write to spit the file out, it writes the string AS WELL AS all the...

Hi, in a gridview, I've set the commandargument during a rowdatabound event. What I'd like to do now is when an icon is clicked, have a Javascript alert popup the command argument (this leads to something else). How can I access the command argument? Is there a server tag I could use? I'd...

Hi, I have a select statement that gets data from one table and I have part of the main select constructed of selects on another table to get counts and return it in the same data set. SELECT P.intProjectID [ProjectID], P.strProjectName [Name], ... COUNT_GOOD = (SELECT COUNT(*)...

I'm having a problem. I have a stored procedure for selecting items like this: SELECT intMilestoneID [ID], strMilestoneName [Name], strMilestoneDescription [Desc], intMilestoneOrder [MSOrder], And so on. See how it gives aliases for the data. I bind it to a gridview like so...

Hi, I'd like to make a stored procedure that checks the list of parameters and only compares the ones that are not null. I assume that means that I set the default parameters to NULL, or that when I call the stored procedure I pass in null values. How do I set the select statement then? I have...

Hi folks, I am trying to reformat an eSeries e232 and whenever I am working on it (windows install cd, linux system rescue, etc) it will reboot about 2-3 minutes into the process. Any ideas why this is? I'll be actively working on it - installing something - and it will restart. Thanks, James

Hi, I have a question concerning upgrading Sharepoint database. The drive I'm hosting it on now is running out of room and I need to get it up and running on a larger drive. Do I move the SQL database to another drive, and point the Management Studio there? Then how do I get Sharepoint to find...

Hi all, there's not a lot of information on using C++ to consume web services (there are things like gSOAP) but here goes. I wanted to create a new C++ project to consume web services (getting away from VB for a while ). I created a new Windows Forms project in VS.Net 2005, added my Web...

Hi, I have a form that has multiple fields to be validated, but only parts need to be validated at one time - for example, the upload field doesn't need to be validated when the user is searching, and vice versa. But, when I try to upload, it triggers the search validation, which fails because -...