Search results for query: *

Personnel Table PID Name 1 John 2 Tom 3 Tim 4 Jay Appointment table: PID rank start 1 A 12/12/2003 1 B 10/12/2001 1 C 15/12/2006 4 A 13/09/2004 How do I write a query such that I get the first "rank" for John? so a query should output john, B Jay, A...

Hello, I've been at this for many hours, if you can give me help I would greatly appreciate it. This is the query: SELECT DISTINCT tblPersonnel.PID, (select distinct top 1 tblAppointments.rank from tblAppointments where tblAppointments.PID=tblPersonnel.PID order by tblAppointments.start) AS...

hey it worked, I put "turn off hard disks" in the power management utility to 3 minutes and it shuts off the ones you don't use. When you need to use any of them, they get started back up. Thanks guys, that's exactly what I needed. Initially I thought that would shut off both hard disks.

I don't want to turn off all the hard disks, just my secondary one that I don't use that much. I tried AMSET (acousting management for Maxtor), but it works on both Maxtor drives :( powercfg managers power on BOTH drives as well. Is there a way to selectively shut off just that one drive...

you were right, my 300W power supply wasn't enough. The Motherboard was dying every time I connect the video card. That thing sucks a lot of power. I replaced it with a 400W power supply and it solved the problem. Thanks

Hello, I have two hard drives. The first one is 7200RPm that I use as my primary (master) and the second is the secondary 5200RPM slave. I only use the second one for storage of large files that I don't normally use. The problem is that the second disk is very loud, and I was wondering if...

actually, I don't even have the hard drive plugged in, and I never ran any OS on that MB+processor. I simply installed the MB+processor combo and trying to get it to work. I think it's the power supply because mine is only 300W. Any ideas?

Hello, I changed my motherboard to a P4M800Pro-M dual core 2.66x2Ghz, and kept all hardware the same. The motherboard boots file on integrated video, but when I put the Geforce FX6200 256MB AGP into the AGP slot and connect my monitor to it, the following happens: The very first time I boot up...

what?? I'm sorry but you'll have to spend 10 extra seconds of your life retyping that field. :P

Hello, I know it's LONG, but please read, it's an interesting problem, but I'm sure I'm issing something I was working on a drag-drop script. I was able to pick up an object, and move the object setting position: absolute, and myobject.left = event.pageX; myobject.top = event.pageY; The idea...

Hello, Two questions, if you guys would be so kind as to address: 1. How do I log only a certain connection? I know I can log the current connection using "\T filename" option, but I am more interested in logging another connection knowing its ID. Perhaps I can switch the current connection...

Hi guys, How do I check if the character is a capital or not? There is nothing in the string method to help me. Thanks.

Hello, I am am using a python script that fetches raw data from the web. However, while processing information I get the following error: UnicodeEncodeError: 'ascii' codec can't encode character u'\u2013' in position 17: ordinal not in range(128) It's actually the sql escape method that fails...

Hello, I an trying to recieve an XML or HTML page from another server. Is there a way to make python send a request to that server via HTTP and recieve a response containing the XML/HTML page. How do we get that into a string so I can process it etc.. Kind of like a web browser does. It goes...

I am sure people had this problem before and was wondering how people get around it. I use MyFile.ignore(100, '%') to get around the file where % is my marker (for example separating entries). In some cases when using this feature the pointer goes to -1, and I can't change it....in a way it...

I looked at it and it's very confusing. I have a query and I want to loop over items in the query. The VBA help engine doesn't really help, just gives me a whole bunch of parameters. But I don't undestand how to get it to loop through the query results.

Hello, What would a loop for VBA access look like if I wanted to loop elements (rows) in a query. Thanks in advance.