Recent content by aplusc

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

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

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

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

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?

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

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

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

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!

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

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.

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

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

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

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