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...
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...
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...
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...
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...
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...
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...
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...
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] =>...
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...
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...
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.
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.
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 =...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.