Search results

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

    find replace in c# with a certain character.

    I have a issue with extracting some cells from c#. When I open what I make in excel, the csv does some new lines or something and causes excel not to do CSV correctly. I opened the file in wordpad and I found that there are some box characters [] < Like that but a full box. So I did a...
  16. T

    How many $Billions did GM lose last quarter?

    This is what they get for expanding their empires.
  17. T

    Passing a array piece to a function

    Wow that was easy, thank you!
  18. T

    Passing a array piece to a function

    Thank you, I have done this but I'm stuck. //********** using System; using System.Collections.Generic; using System.Text; namespace ConsoleApplication6 { class Program { static void Main(string[] args) { int[] cellData = new int[] { 39945...
  19. T

    Passing a array piece to a function

    I see, this is what I want to do but I don't know how. namespace ConsoleApplication5 { class Program { static void Main(string[] args) { int[] fibarray = new int[] { 0, 1, 2, 3, 5, 8, 13 }; domath(fibarray[4]); //Call domath function...
  20. T

    Passing a array piece to a function

    That won't work out too well because only parts of the array need to be fixed. Should I make another array just for dates?? My code is here ******************* using System; using Microsoft.Office.Interop.Excel; using System.Threading; using System.IO; namespace ExcelExample {...
  21. T

    Passing a array piece to a function

    How do I pass a lot of variables to one function. It's going to be about 15+ dates that need to be converted. Right now I can only do one. presidenttender, My code works, I just don't understand how I can pass a bunch of variables in a array through it. something like...
  22. T

    Passing a array piece to a function

    Hi, let's say I have an array and cellData[5], cellData[7], and cellData[15] need to be passed off to a function to format it right. In this case, it's a date from excel, but it doesn't convert right, 10/27/2007 turns into 39545 or something. So I have a piece of code that can convert it...
  23. T

    Reading an Excel sheet by cell in c#

    Dhaval00, it's a form so there's a lot of useless things that I would pick up. Thanks, techfuzz, I got that to work. I have one issue... I can't use Excel.Range... What I can use is Microsoft.Office.Interop.Excel.Range. I registered it at the top as using...
  24. T

    Reading an Excel sheet by cell in c#

    I've been looking online and I still am stuck. I'd like to select certain cells out of 50+ excel files. Each file is the same, just different numbers. So say I want to extract A1, B5, C7, D9 etc..... What is my best approach? I found some c# code and I'm able to capture one cell...
  25. T

    GridView to CSV file in C#

    That spit out an error... I was able to do this foreach (GridViewRow row in GridView1.Rows) { } Does that allow me to iterate through? I was able to get a count... with int = int + 1;
  26. T

    GridView to CSV file in C#

    I'm trying to convert a GridView to CSV All I have is the GridView displaying my XML file. //************** protected void Page_Load(object sender, EventArgs e) { DataSet myDataSet = new DataSet(); myDataSet.ReadXml(Server.MapPath("portfolio.xml"))...
  27. T

    Windows Xp Pro

    Your best bet is to make a new profile and see if her profile got messed up.
  28. T

    New Truecrypt v6 -- pretty cool "Hidden OS" feature

    Do I have to reformat OS X to use this?
  29. T

    Is this worth using?

    Just HTML and CSS? What about dynamic content?
  30. T

    Need computer job

    Get a job at Geek Squad. Come back when you're serious about a career.
  31. T

    Need computer job

    There's no job in that. EDIT: You can't be serious. Maybe in maintaining servers but you don't have any experience in that do you.
  32. T

    Replacing an old Knowledge base

    It's not hard at all to setup. If you want to use some LDAP login there could be issues. Making users get new logins and passwords creates a problems.
  33. T

    MS Reporting Services and Oracle db

    Thanks for the info!
  34. T

    MS Reporting Services and Oracle db

    There's a chance that the company I work for can get Reporting Services. We use Oracle as the standard db but we can use SQL 2005. It's just that this app might need to hook up to another Oracle database in the future for more financial information so using Oracle for our database might make it...
  35. T

    fubar mail at work

    There's no backup because management felt it cost too much.
  36. T

    username and role protection in C#

    I did not but I don't think we can use ODP.NET. Stupid standards :-/
  37. T

    Remote access setup

    XP Home doesn't have Remote Access, only Pro. Get logmein or something similar.
  38. T

    I hate the way VS 2005 handles web applications

    Change the project location from Filesystem to HTTP and point it to the server.
  39. T

    username and role protection in C#

    I have a a web app that uses single sign on but it still needs to read my web app to see if a user is allowed on the site. Would hashing the username and role be enough security? What other methods are there? It's gonna be working with a Oracle database. Edit: Looks like I need to do...