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 Chriss Miller 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. Phizzle

    MySQL equivalent of SQL Bulk Insert using formatfile

    I need help using MySQL to do bulk inserts in a way similar to the was SQL uses a Format file. The txt file I'm importing from has a lot of information in a single row w/ fixed column widths separated by commas. Can anyone assist me w/ the proper syntax in MySQL to define the columns using...
  2. Phizzle

    PC Can't Join 2008 Domain

    More Information: From the PC I can ping & tracert the FQDN of the AD server but not the NetBIOS name. We do not have an extension as part of our FQDN as in .local ours is just . Does this have anything to do with the issue of not being able to join the domain or is it an issue with the PC...
  3. Phizzle

    PC Can't Join 2008 Domain

    I have 2 2008 AD DC servers, both doing DNS. I have a new PC that is unable to join the domain stating that it can't find the A records in _ldap._tcp.dc._msdcs.cbhc - however, those A records are there. I've also tried to use these 2 servers as DHCP servers without any luck. When I turn off...
  4. Phizzle

    IIf Query Question

    Ok - Currently I get: Services: Service1, Service2, Service3, I'd like to only see Services: Service1, Service2, Service3 Basically the same thing minus the trailing comma. Thanks!
  5. Phizzle

    IIf Query Question

    I got it to do what I need with: services: IIf(IsNull([service1]),""," " & [service1]) & IIf(IsNull([service2]),""," " & [service2]) & IIf(IsNull([service3]),""," " & [service3]) & IIf(IsNull([service4]),""," " & [service4]) & IIf(IsNull([service5]),""," " & [service5]) &...
  6. Phizzle

    IIf Query Question

    Randy - that's exactly what I'm after - I've been able to do it w/ the IIf and multiple queries, but doesn't seem practical. Could you elaborate a bit on your suggestion? Thanks again,
  7. Phizzle

    IIf Query Question

    This particular table has about 12 checkbox columns. I only want to disply those that are checked (True). If I do a normal query I will get the rows that pass the criteria, but I'll still see all the columns that were false. Not sure if that makes sense... Code SELECT tblCAP.ProviderName...
  8. Phizzle

    IIf Query Question

    I have a table w/ several check boxes and I would like to run a query against it, but I don't want to see the ones that are false/no - I think I can do this w/ the IIf function (eg. store each True as new column and supress the False?), but I don't know how - any help would be greatly...
  9. Phizzle

    ANI Question

    Thanks - finally talked to someone technicall (from a different LEC actually) Basically, what they are saying is that if a caller has requested that their number be blocked, it doesn't come to us and can't (w/out a dedicated trunks and PSAP equipment) because the ANI information terminates at...
  10. Phizzle

    ANI Question

    The caller is dialing a toll free number, and since we are designated as a community disaster response center it would be considered mission critical calls. You information does help, at least I have a little more knowledge of the ANI 'stuff' and have more ammo while talking to Sprint. Thanks!
  11. Phizzle

    ANI Question

    Forgot - calls are coming in via switched facilities - talking w/ Sprint to see if we can get on onto a dedicated trunk that will pass such info - so far no luck (no in denial, just no answers) :) go figure. Thanks,
  12. Phizzle

    ANI Question

    Whew - lot's of questions, but thanks for the help! Kinda muddy water right now - currently, the lines are plain analog lines on a Samsung iDCS 500, however we are looking at switching to VoIP soon (probably using Cisco hardware, but nothing set in stone yet), in which case they will probably...
  13. Phizzle

    ANI Question

    I think they can pursuant to FCC regulations that requires carriers to respect a caller's request that their number not be revealed. This, however, does not apply to those calling "emergency numbers", which we can qualify. I've finally got past the "legal" issues (I think) w/ Sprint, however...
  14. Phizzle

    ANI Question

    It is a toll-free number, basically, we need similar information to what 911 is getting (though we don't need to locate the person, we only need it in case of a crisis situation, we can give it to 911). Thanks,
  15. Phizzle

    ANI Question

    I'm looking to get blocked ANI information (we fall under the definition of a Public Safety Agency and Community Disaster Response). I'm working w/ our LEC (Sprint) w/ very little response or assistance. My basic question is a simple one - Can we or can we not get blocked ANI information send...
  16. Phizzle

    Restore from Sun to Linux

    tar -cvEbfx 20 /dev/rmt/0u /usr/root/exclude_file ./usr/root/._TAGFILE ./Mail ./TT_DB ./bin ./cdrom ./dev ./devices ./etc ./export ./fld644gsa ./home etc. etc. etc.
  17. Phizzle

    Restore from Sun to Linux

    Ok - tried that - same results. This was done via script. It is a system backup, however, I only need to recover our database .dat file. Thanks again! Phil
  18. Phizzle

    Restore from Sun to Linux

    Thanks for the help - when I do the test, I get... read: Not enough space 0+0 records in 0+0 records out Which brings me to another question - shouldn't I be able to mount the tape drive from a linux box? I have nfs running on the sun, but still get connection refused when I try to mount...
  19. Phizzle

    Restore from Sun to Linux

    I'm not very sure how to use the dd command to get the file off the tape...can you explain? Thanks Phil
  20. Phizzle

    Restore from Sun to Linux

    sorry ...tar

Part and Inventory Search

Back
Top