Recent content by RhythmAddict112

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

I think the trick here is being able to determine when you're ready to fire the event to begin searching. I would think that whenever the length of the value of txtQuickSearch is greater than 0 that you'd be ready to fire this event. You'd probably want to use the OnTextChanged event to do...

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

Hmmmm..I'm sure there are other way to go about this, but the first thing that popped into my head was doing your file upload logic in an iframe, so you could keep your request.form() In semi-pseudo code... If Request.Form("validate") <> Sessionthen 'session is valid DisplayIframe() 'display...

Don't know off hand if that does return a code, but you could do something like... dim filesys set filesys=CreateObject("Scripting.FileSystemObject") If filesys.FileExists("SomePath/File") Then 'do stuff http://geekswithblogs.net/sanjayu/

Should be a good place to start... http://www.tek-tips.com/faqs.cfm?fid=1869 http://geekswithblogs.net/sanjayu/

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

Mike - that's perfect. Thank you so much. http://geekswithblogs.net/sanjayu/

Oh, I'm sorry! yes, it's an excel http://geekswithblogs.net/sanjayu/

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/

Noted my friend. Thanks for the FYI! http://geekswithblogs.net/sanjayu/

You are the man. 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)...