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: admoore
  • Content: Threads
  • Order by date
  1. admoore

    sed substitution within bash script with mixed quotes

    I am trying to update some legacy php code via some sed substitutions running in a bash script. Some items seem to work fine; others not so much. The issue appears to be when the substitution strings contain single or double quotes. I have tried a variety of means of escaping the quotes; but...
  2. admoore

    exclude erroneous returns / line feeds from count() ?

    I am updating legacy php code which imports csv data to a mySQL database. The code includes error checking which compares the number of imported rows to the number of lines found in the import file. The problem is that a small percentage of records includes returns or line feeds enclosed within...
  3. admoore

    Bootstrap modal form in v4

    I have a form within a modal which sends an email... While it works in Bootstrap 3, in v4 I get a javascript console error: Uncaught TypeError: $.ajax is not a function Any help on resolving appreciated very much. TIA, -allen_m The function: <script> function submitContactForm(){ var reg...
  4. admoore

    delete with join on single table...

    I have a query which matches records with similar 7 and 6 digit primary keys... I wish to delete the matching 7 digit records only... The query below returns: '#1242 - Subquery returns more than 1 row' I know I could write a loop in PHP to accomplish this; but, would like to write a proper...
  5. admoore

    Only records up to a specific SUM() value?

    From a table of sales records, I need to select the most recent transactions by customer where the sum of those transactions is greater than $500; BUT, only enough records to meet the minimum sum requirement- not all of them. So if a customer spent $150 once a month for the last year, I want to...
  6. admoore

    Need 'distributed' sort...

    I'll do my best to describe what I need; hopefully, my description is clear. I have a table containing a group of records with 2 fields upon which i need to sort. record_no (integer and primary key) and cust_id (varchar - data set contains duplicates) In a nutshell I need a result sorted such...
  7. admoore

    Issue w- MySQL 5.75 on OSX 10.10 - can't find .mysql_secret

    I installed MySQL 5.75 on OSX 10.10 and it is up and running successfully; but, following execution of mysql_install_db I can not locate .mysql_secret anywhere... I double checked the home env variable to make sure as well as searched via spotlight etc... It simpley does not seem to exist; but...
  8. admoore

    help parsing xml from email

    I am using SimpleXMLElement()to parse the body of an email for XML data and am having difficulty parsing fields with 'parts' defined; such as: <name part="first">First</name> <name part="last">Last</name> $array->prospect->customer->contact->name yields the first name; but I can't resolve...
  9. admoore

    problem with multidimensional array

    I need to access specific data in one array while looping through another... I can print_r the array I need to reference; but, somehow I cannot retrieve the data I am looking for... Example: the array $data[] Array ( [0] => Array ( [salesman] => 818 [0] =>...
  10. admoore

    JOIN without ON

    My goal is to update only more recent records into a table from another 'import' table which gets updated daily... There is considerable 'overlap' and I want to look at the MAX() value of a date in the table to be updated in order to select the records from the import table to be imported. I...
  11. admoore

    table expand collapse &lt; default collapse

    I am using code as below to expand & collapse table rows... I wish to: 1) default to a collapsed view instead of expanded 2) exchange the plus.gif image for minus.gif as appropriate TIA, -Allen M. <html> <head> <script type="text/javascript"> var rowVisible = true; function...
  12. admoore

    select part of a field string

    I wish to select the portion of a field preceding a given character... In this case the portion of an email address preceding the '@'. As the length varies, I an unsure how to proceed... TIA, -Allen M.
  13. admoore

    return numbers only in SELECT query?

    I have a query that includes a VARCHAR field with phone numbers formatted in a variety of ways, i.e. 999-555-1212, (999) 555-1212, etc... Can a select query return only the numeric data in the record, in this case 9995551212 ? TIA, -Allen M.
  14. admoore

    File upload works from OSX, not from WIndows...

    Never experienced anything quite like this... File handling within PHP script running on BSD server accepts uploaded files from OSX (Mac) computers with seeming any browser; but not from any windows machine regardless of browser... if(isset($upload)) { // process uploaded file $allowedExts =...
  15. admoore

    merging variables into mysql result

    I have a variety of text strings stored in a MySQL database which need to be combined with variables in php.... The variable NAMES are stored as text within the data which needs to be replaced with the variable VALUES example- contents of SQL varchar data field: "some text $var1 more text...
  16. admoore

    simple home lab question...

    Is it OK to install & swap serial DCE / DTE cables on a powered-up router? How about on shut vs opened interfaces? TIA, -A
  17. admoore

    Problem starting ospf...

    I have 3 routers connected to a fourth acting as a frame relay switch for a hub and spoke lab with ospf. Frame relay connects fine; but, for some odd reason, my hub router says ospf is "unknown" in spite of listing it in ios help? Wassup with that?? 2509_T-SERVE_R1>enable 2509_T-SERVE_R1#conf...
  18. admoore

    split horizon on 2509?

    I use a 2509 as both my terminal server and, presently as the hub in a frame-relay spoke-and-hub lab running RIP. I am NOT using sub-interfaces and have not specifically turned off split-horizon; yet I am getting RIP routing updates to both spokes. Is the IOS too old to support split-horizon...
  19. admoore

    Still having issues with frame-relay lab

    I am still having issues with my frame-relay lab... I have one router set as the FR switch and 3 other routers in a hub-and-spoke configuration. For now, I am not even concerned about split-horizon... The frame route comes up OK on the FR SWITCH The serial interfaces and LMI's come up...
  20. admoore

    Frame Relay, RIP &amp; Split Horizon lab exercise issue...

    I am having issues with RIP updates while attempting a training lab concerning Frame Relay and split-horizon... Basic setup is: show ip route on r1 shows no RIP routes; and, debug ip rip on R2 reports: *Mar 1 18:48:31.487: RIP: sending v2 update to 224.0.0.9 via Loopback0 (2.2.2.2) *Mar 1...

Part and Inventory Search

Back
Top