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...

Thanks folks!

Hi, yes, that is exactly what I am trying to do. I really only have experience using the roleProvider and membershipProvider to limit access, and this item requires Windows Authentication. So I'm trying to use that (Windows Authentication), but still be able to use roles, etc, without extra...

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...

Thanks for the reply, Mark - I had found some things like this online, but because I am outputing a formatted GANTT chart (done with tables), I would need to run the logic all over again in VBScript to do so. I know if you have an HTML file named as an XLS file it reads it and displays it, same...

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")...

To clarify, this is how I am accessing the LDAP: Dim de As DirectoryEntry = New DirectoryEntry("LDAP://#.#.#.#", "OPENTEST\Administrator", "password", AuthenticationTypes.Secure)

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...

Bah, even in a standalone page, it can't find "grid" - I'm stuck here.

Alright, thanks for the help! I put it together and ran it with a few other msgboxes for error checking and I see that it cannot find the item "grid". "grid" is an <asp:gridview> on my page with ID="grid" and all bound columns - nothing fancy. My concern now would be, since this site uses master...

That's the problem - is there something wrong with this statement? How come it claims it isn't valid?

I changed it to XMLNode and it still skips the if statement; when I change to the "allow" node and try to get attribute count/anything it says that Object Not Set to Reference. Ideas? thanks, James

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...

Thanks, I'll give that a shot and see how it goes - it's just a quick fix for a longer term problem. I can't set the allowed roles from an XMLfile? bummer... Thanks though!

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="*"/>...

1) Where do I put the try catch blocks? Since the columns are autogenerated, there is no function call per se that I can access - RowDeleting and RowDeleted don't have that functionality. 2 and 3) Since they are autogenerated, I had moved the selectedRow.Cells from 0 to 1, but how come when I...

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...

Well, the radio button event fires, it picks up the correcy values, but it does not work. For example, I'll have four items with different statuses, one active, two completed, one withdrawn. I select a radio button that will put me into the "Other" branch of the if-else codebehind listed above...