Topics

Suggestion for rate center search

Sklar, Robert <rsklar@...>
 

I'd like to offer the following suggestion for the rate center search:

Provide an option to list only the actual rate centers, not including the localities.

Thanks,

Bob





Robert L. Sklar
GIS Specialist, Citywide GIS
New York City Department of
Information Technology & Telecommunications
2 MetroTech Center, 4th Floor, 4.173N
Brooklyn, NY 11201

1-718-403-8434
1-718-403-8591 (Fax)
rsklar@...<mailto:rsklar@...>

[NYCITT_RGB4officeprint]



________________________________

This e-mail, including any attachments, may be confidential, privileged or otherwise legally protected. It is intended only for the addressee. If you received this e-mail in error or from someone who was not authorized to send it to you, do not disseminate, copy or otherwise use this e-mail or its attachments. Please notify the sender immediately by replying to this e-mail and delete the e-mail from your system.

czg7777@...
 

Although I could do a specific query in the database that omits localities, generalizing it to the web environment didn't quite work (not sure why, but it wasn't returning any records at all - I suspect PHP may handle null values differently).

While looking into this I thought I might try a different approach. Instead of generating pages of rate centres/localities with a fixed number of rows per page, I could group them by the first character of the name. That will at least make it easier to narrow down the scope of the search.

rsklar@...
 

Did you try testing for the string " see " in the name, that is, the word "see" surrounded by two blanks (X'40' if EBCDIC is in use here)?


rsklar@...
 

Did you try to test for the string " see " in the name?  That is, the word "see" surrounded by two X'40' blanks?

Ray Chow <czg7777@...>
 

No, because that “ see “ is not how it’s stored internally - that is triggered by the presence of a value in another column (hence my note about null values - PHP is rather quirky in the way it handles them).


On Apr 28, 2016, at 9:50 AM, rsklar@... [local-calling-guide] <local-calling-guide@...> wrote:



Did you try testing for the string " see " in the name, that is, the word "see" surrounded by two blanks (X'40' if EBCDIC is in use here)?





czg7777@...
 

I have now added a checkbox to allow you to hide the localities. It is not checked by default.

RobertSklar@...
 

---- "czg7777@... [local-calling-guide]" <local-calling-guide@...> wrote:
I have now added a checkbox to allow you to hide the localities. It is not checked by default.
Thanks. It works well.

Bob