Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by aplusc

  1. aplusc

    Replacing NULL's in results

    Thanks for all of your help. Zathras your code looks like it would work, but unfortunately I only have SELECT access on the table and cannot create any objects (even views). The avg/min/max solution seems better but I'm worried that this might be a performance issue. In the actual table there...
  2. aplusc

    Replacing NULL's in results

    Lets say I have a table called TRANSACTIONS with the following columns: customer item quantity total_cost -------- ---- -------- ---------- Bob 121 4 400.00 Mary 115 1 50.00 John 100 2 100.00 Mike 121 7...
  3. aplusc

    J2EE security?

    Could somebody please recommend a security framrework for J2EE applications (JSP's, servlets) that fits into the following criteria: 1. Server independent and portable (can be easily moved from one app server to another). 2. Uses a relational database for the backend. Users, groups, access...
  4. aplusc

    How to set up both XP and Red Hat 8.0?

    Ok here is my situtation: 1. I had one harddrive 40 GB, FAT32 (C: drive), on which I had Windows XP installed. 2. Since my first hardrive has almost not free space installed, I decided to buy another 120 GB hardrive. 2. After installing, XP formatted the entire thing to NTFS as single...
  5. aplusc

    ASP and windows services

    Is there a way from ASP (not .NET) to detect whether a particular windows service is up and running? For exmaple, how could I detect the status of the "Event Log" service?
  6. aplusc

    How does this code work? ("static" keyword)

    I came across this code with a very bizzare syntax, but apparently it compiles and runs without an error: class z{ z(String s){ System.out.println(s); System.exit(0); } static{new z("Hello, World!");} } I understand everything that happens in the constructor, but what's going on...
    • aplusc
    • Thread
    • Replies: 1
    • Forum: Java
  7. aplusc

    How do I write a J2EE application?

    I am very new to J2EE and just trying to figure out how to do things. I built a simple application - a JSP to display data and a servlet to get that data from a database. It seems to work well, but from what I understand it would make sense to make the servlet into a Java Bean instead...
  8. aplusc

    Sort by Date Modified

    I have a folder with audio files. Windows XP allows me to sort file by album, year. track time, etc. which is great. But, of course I also want to sort by the date modified. To do this I have to go to View > Choose Details and check "Date Modified". However when I close the...
  9. aplusc

    Automatic downloads in IE under XP

    I'm sorry I made my question so confusing :( Yes my problem was basically "Not Prompted to Specify Download Folder for File". Thanks for you help guys!
  10. aplusc

    Automatic downloads in IE under XP

    This is a silly newbie question, but does anyone know how to disable automatic downloads in IE? For example, yesterday I downloaded a 300 MB file, which IE saved to a "Temporary Folder". I did not have time to install the program I downloaded then so I just forgot about it. Sure...
  11. aplusc

    Accessing SQL Database w/Stored Procedure and Parameters

    Are you using native drivers for the database connection? In general, I noticed that native drivers do not work as well as ODBC does. Try changing it to ODBC and see if you get the same error.
  12. aplusc

    Updating table 1 based on table 2

    Try this: update table1 join table2 on table1.itemName = table2.itemName set table1.itemID = table2.itemID
  13. aplusc

    Efficiency Issue

    Let's say I have a simple table with two columns - C1, and C2. C1 is indexed, while C2 is not. If I were to write a stamenet like this: select C1, C2 from table WHERE C1 = "A" and C2 = "B" Would it be any different if I write it like this: select C1, C2 from table WHERE...
  14. aplusc

    How do I pass database logon information?

    I am trying to use URL reporting on the web and wondering if there is any way I can pass the database logon info without it actually being displayed in clear text. Of course, the simplest way to do this would be user0=username&password0=password, however everybody would see the login...
  15. aplusc

    Using the BETWEEN keyword

    JM Craig, you are exactly correct. The transaction papers are PHYSICALLY ordered this way for business purposes. Certain transaction papers are grouped in folders and this is why there is a need to use ranges as the could be hundreds of papers in a single folder. Your solution would work...
See more

Part and Inventory Search

Back
Top