Search results for query: *

Hey SQL Gurus, Not sure if I'm just "not all there" today, or what...but here is the Q. I need to do a case statement in my where clause, this works: WHERE r.[SomeCol] = @SomeColVal AND SomeOtherCol = ( CASE WHEN (@Year = 0 AND @Period = 0) THEN @SomeVal CASE WHEN... ... CASE ELSE @SomeVal...

Hi All, Pretty new to java - so bear with me, please. I do think the problem is probably a simple one. In short, another developer had to change the JAVA_HOME environment variable from jdk1.4 to jdk1.5. However, after doing so JSPs in a certain directory don't work (no error at all, no 404...

Hi All, I've got a object that has a property that is a collection. I have binded a collection of this object to a gridview, and I need to know how to only display the zero-th index of my collection as a column... pseudo-code Dim oUserList as List(Of oUser) = GetUsersList() Dim gv as...

Hey boys 'n girls - Real quick Q.. Formally, I was coding my loop through a data table like... Dim s As New List(Of String)(dt.Rows.Count) Dim dr As DataRow For Each dr In dt.Rows s.Add(dr("FirstName").ToString) Next Return s.ToArray...

Hi All, Quick question..I have to make a schedule for my team. There is a meeting that occurs on every other tuesday...Is there an easy way I can populate a row with all tuesdays from a year without laboriously putting values in cells? Thanks! http://geekswithblogs.net/sanjayu/

Hey all, Quick question...I'm using process.start() coupled with osql to connect to a db and run a proc. Trouble is, I want to hide my osql command line arguments (read:password) How can I do this? Thanks! http://geekswithblogs.net/sanjayu/

Hey all, Thanks for looking at my post...I am sure I'm either not understanding something here, or just flat out doing something wrong but..the concatenation of the line below in read isn't working. (The value is null) How can I get this to concatenate? DECLARE @currYear varchar(4)...

Hi All, Quick question. I need to create a JS function that will test a string for repeat characters. Basically, it can return false if any characters in the string are repeated, true if not. just to clarify, that'd mean no character can be repeated in the string, as opposed to back to...

Hi all, Quick question. I'm doing some playing around w/FTS and it's functionality. I've been messing, specifically, with FREETEXTTABLE & CONTAINSTABLE and I have a question regarding them. Is it possible for me to use AND in the search to combine criteria? I've seen tons of examples using...

Hi all, So I'm working on a project where we'll need to go through and cleanse some data. Here is one scenario... We've got a table that stores educational information. Currently, the "school" column exists as a varchar field. We're going to modify the front-end logic so that users must...

Hi all, Long time no post. I have a few questions regarding SQL Full-Text Searching/Indexing in a SQL 2K environment. We've got the business need here to build a search engine on top of a database. I'll need to do the "Normal" search, where I specify the value I want to look for in a certain...

Hi All, I have a bit of an issue here...I need to migrate a classic ASP application running on IIS5/win2k over to IIS6/win2k3. No problem I thought. Created my virtual directory in IIS, and enabled ASP in the web service extensions. Unfortunately, it does not serve any ASP pages out. IIS...

Hi all, I have a page that has numerous DIVs (with iframes inside of them) that load server-side dynamic pages. As such, there is a slight latency while these pages are loading. I need a way to either preload these pages while displaying a wait message of some sort.....Ive hunted around a bit...

Good Afternoon, Quick question...I'm using window.createPopup() in the following manner. var oPopBody = oPopup.document.body; oPopBody.innerHTML = "<DIV>" + vText + "</DIV>"; oPopBody.style.border = "solid black 1px"; My question is the following, is there a way for me to assign the DIV a...

Hi all, I moved an NTFS drive from one box to another (win2k3) I've got directories and files that I receive an "Access is denied" message on. I can access the files/folders fine if I change the owner, though. However, I don't want to do this for ALL the folders/files. When I go to the root...

Hi all, I have the feeling the answers I get from this post aren't gonna be what I'd like to hear, but I digress. Long story short, I have an internal web application that we need to open up via VPN to external vendors. A vendor will be able to get to one page within the application to input...

Greetings, I need your advice on something here. I'm currently working on an application where I need to maintain a collection that will store a string value and an associated value of type double. Example: "Requirements" .2 "Code" .4 ..etc Essentially, project phases and their associated...

Hi all, Real quick question. I have a page/class named Default.aspx...I've also got a base class called Report, and various reportTypes that inherit from it - one of which is "Department. My question is the following... When I instantiate the Department type within the Default page/class....Is...

I'm interested in the web applications cert...Anyone take this? How did you do? What book(s) and/or tools did you use? Thanks! http://geekswithblogs.net/sanjayu/

Hello . I've got a user created custom control with 4 drop down lists and a button. This control is on my main page, default3.aspx. What I'd like to do is fire an event on the main page (default3.aspx) when the button is clicked on the user control (DropMenu.ascx) This is what I've tried...