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!

  • Congratulations Wanet Telecoms Ltd 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: *

  • Users: jatkinson
  • Order by date
  1. jatkinson

    Trying to use WHERE statement on char column with '-' in?

    Thanks PHV, thats great!
  2. jatkinson

    Trying to use WHERE statement on char column with '-' in?

    Yep, that does it!!! If I pad it out at the front to make 16 characters it works!! Thanks for the pointer! Next question then, is it possible, to code the query so I can strip the extra characters out and just type in the numbers I want to search by rather than padding it out into the query?
  3. jatkinson

    Trying to use WHERE statement on char column with '-' in?

    Hi, That didn't seem to work either. Interestingly I thought of using LIKE so I played with various but couldn't get that to work. The only result that gave anything was the following WHERE tablename.fieldname LIKE '%1-00001' but that then gave me entries for 1-00001 11-00001 21-00001...
  4. jatkinson

    Trying to use WHERE statement on char column with '-' in?

    Aah, I see what you're saying I'll give that a whirl! Cheers.
  5. jatkinson

    Trying to use WHERE statement on char column with '-' in?

    Hi, I did think of that and used: WHERE tablename.fieldname = '12345-00001' That simply returned no entries even though I can see the value clear as day in the open table. Hence a newbie getting confused! ;o)
  6. jatkinson

    Trying to use WHERE statement on char column with '-' in?

    For example I want to search for an entry with the value 12345-00001 so I used the following: WHERE tablename.fieldname = 12345-00001
  7. jatkinson

    Trying to use WHERE statement on char column with '-' in?

    Hi, First of all let me apologise if I'm in the wrong place and for the naivity of my question, I'm new to SQL queries etc, so please do point me in the right direction of the correct forum if this isn't right. Basically, a product we use stores records into a field in the format 12345-12345...
  8. jatkinson

    Group Policy confusion - I'm stuck on software install

    Thanks Guys for confirming my suspicions. I'm going to have to rework this on computer groups. I could push the software out to every PC on the domain but after testing it specifically on my PC it took more than 30 mins to install at start-up! (pretty certain something wrong there!) so I wan't...
  9. jatkinson

    Group Policy confusion - I'm stuck on software install

    Hi Steve, I'm thinking down the same lines as you and that is when I started getting confused. Like you it doesn't make sense to me logically to configure this way but this is how it's been explained and taught to me. I want to run the policy at computer level so it is installed prior to...
  10. jatkinson

    Group Policy confusion - I'm stuck on software install

    Yep, tried that..no problem with users access rights. Thanks for your post though.
  11. jatkinson

    Group Policy confusion - I'm stuck on software install

    Hi all, It's been a while since I've used Group Policies and I thought what I wanted to do was simple enough, however it doesn't seem to be working and I can't figure out why, which is now confusing me even more!! Basically, I want to install a piece of software via a policy to a specific...
  12. jatkinson

    connect part wired to part wireless lan

    Yeah, that is what I'm going to do, I was just looking to find a solution with the kit I had available at the time. Cheers.
  13. jatkinson

    connect part wired to part wireless lan

    Simply because they are in a different room to my Client devices and I cannot cable through the rooms due to layout issues.
  14. jatkinson

    connect part wired to part wireless lan

    Hi all, Any pointers on how I can connect part of my LAN which is wired to a wireless part? Specifically, all my devices connect to a wireless AP, including one of my servers (DC) in my home 'office' room, the other server is a DC too and is wired via a switch to the DC with the wireless card...
  15. jatkinson

    log onto domain for 1st time via wireless client

    name resolution seems spot on, problem seems to lie with the wireless connection not being up whilst a user is not logged in ?
  16. jatkinson

    log onto domain for 1st time via wireless client

    OK, just come across this issue and wondered if anyone had any ideas. We've just set up a smal training LAN at work, I've set up a domain controller (W2k3) and configured each client (WXP) correctly. Each client is connection to the LAN via a wireless connection. Now when a new user tries to...
  17. jatkinson

    RIS install problem, pci.sys missing or corrupt

    Hi Bill, Thanks for your efforts, knowledge and experience on this problem. I'll keep investigating and post back when a little less rushed :-) Cheers, James
  18. jatkinson

    RIS install problem, pci.sys missing or corrupt

    Hmm... interesting, as I'm rushing to meet a deadline I decided to simply redo 6 of the machines using the base image, use Group Policy to install most of my software afterwards and then simply run between to install legacy software that doesn't work in AD (ie. no msi file) Anyway, the 1...
  19. jatkinson

    RIS install problem, pci.sys missing or corrupt

    Hi again, thanks for you continued help The source is a Microsoft CD from a MYO license. I copied the CD to a folder on the hard drive and then using a 2nd CD that has SP1 on it slipstreamed SP1 into the directory. I then used this on my RIS server to create my base image. After pre-staging...
  20. jatkinson

    RIS install problem, pci.sys missing or corrupt

    OK, the base image, license and hardware are identical. I'm using a Win XP VLP CD to create the base and then installed software and updates (could it be updates changing kernal etc?). Can you elaborate on the BIOS and OEM bit please? The PCs are 8 new identical Fujitsu-Siemens PCs, which...

Part and Inventory Search

Back
Top