Recent content by Phizzle

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

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

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

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!

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]) &...

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,

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

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

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

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!

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,

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

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

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,

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