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!

Search results for query: *

  1. Arrowx7

    How to write a query like this...

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

    SQL: "ORDER BY clause conflicts with DISTINCT" please help

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

    shutting off secondary hard disk

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

    shutting off secondary hard disk

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

    GeforceFX6200 problem? replaced motherboard, does not boot

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

    shutting off secondary hard disk

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

    GeforceFX6200 problem? replaced motherboard, does not boot

    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?
  8. Arrowx7

    GeforceFX6200 problem? replaced motherboard, does not boot

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

    confirm field values

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

    drag n drop - the drop doesn't work in IE

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

    two questions: how to log connection and how to execute as connection

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

    checking character case

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

    Encoding problem (newbie question)

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

    How to send requests with python

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

    fstream class pointer goes to -1

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

    Query loop VBA

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

    Query loop VBA

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

Part and Inventory Search

Back
Top