Recent content by TheEarthWillShake

  1. T

    Quick sql 2005 query question

    I figured it out. SELECT MAX(Date) AS Expr1 FROM temp GROUP BY MONTH(Date), YEAR(Date)
  2. T

    Oracle autonumber question

    Not fun at all lol.
  3. T

    Quick sql 2005 query question

    I'm new to sql querys and I'm not quite sure what you mean :-x (SELECT MAX(Date) AS Expr1 needs to be grouped?
  4. T

    Quick sql 2005 query question

    This is a basic example of what I'm trying to achieve. One table Table TEMP ID Date 1 1/15/2007 2 1/25/2007 3 2/16/2007 4 2/25/2007 I want to return the most recent date within each month. so I want 2 1/25/2007 4 2/25/2007 SELECT Date, ID FROM temp AS ut...
  5. T

    Oracle autonumber question

    How do you generate a autonumber that needs to be put in more than one table to create a relationship? For example I have 3 tables. TBgenData Proj_Num* Proj_Name TBdate Date_ID* Proj_Num Date TBfinancial Fin_ID* Date_ID YTD_Budg In this case, the Date_ID needs to be...
  6. T

    How to stop IE6 from auto launching excel file downloads

    In the corporate world it isn't that easy. It's in My Computer --> Tools --> File Types Tab. Gotta love internet explorer integration right.
  7. T

    Search for a string in a HTML file c#

    Is is possible to search out a string with a start and end and grab everything between? It starts with /content/ ends is /NAME.tmp.x.xls so I want to grab window.open('/content/RANDOMESTUFF/NAME.tmp.x.xls', This is out of a html file and there can be anywhere from 1 to 30...
  8. T

    How to stop IE6 from auto launching excel file downloads

    I want to revert back to asking me to save the file instead of automatically opening it. I've looked through the security features and I have tried every option in there. Any ideas? Thanks
  9. T

    Dynamic loading multiple pie charts

    How would I go about loading more than one pie chart by reading a database. I know it would be some kind of loop to get the data but I have no idea how to render them? http://www.carlosag.net/Tools/...art/sampleDataSet.aspx I'm using this.. The part that would need to be looped is...
  10. T

    I.E. 6 and Windows 2000 Pro

    I don't think IE 6 had plugins in the same sense as Firefox and IE7 do. They're probably hidden somewhere.. I haven't found anything online lol.
  11. T

    IE6 automatically opens excel files how to reset?

    Is there anyway to reset the settings in IE6 to get excel files to ask me if I want to download it? When I download it now, it automatically opens. Thanks.
  12. T

    Creating a XML file with arrays in C#

    Never mind I found a easier solution to work with. Sorry
  13. T

    Creating a XML file with arrays in C#

    This is what I have so far, it's general //*** using System; using System.Xml; using System.Collections; namespace ReadXml1 { class Class1 { static void Main(string[] args) { //pick whatever filename with...
  14. T

    Creating a XML file with arrays in C#

    I have a question. say I have 2 arrays. arrayNames arrayContent so arrayNames has ProjectName, ProjectID, ProjectDate and arrayContent has Server Implementation, 123, 05/30/07 I want to loop through and create a XML file. The other thing is, there are more then one project so I...