I am working out a single-use query for populating a new table structure from existing data.
I have:
tbl1
id, name, value
I want:
tbl2
id, name, value, prior_id
So far I have a select query that populates everything but the prior_id column. I was solving this with a subquery for that column...
I don't know if this is the best place to post this question or not, if not let me know where it belongs.
I am working on a site that allows for reservations/bookings, and have been assigned the task of finding a good looking calendar to convey currently booked dates. We will eventually expand...
Ok, checking the mail file has revealed that the cron is firing once a minute, generating the following error message:
/bin/sh: php.exe: not found
I do not understand why I would be getting that message when the command is run from Cron but not from the command line.
I think we may be getting somewhere here -
running /etc/init.d/cron status returns the following:
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service cron status
Since the script you are attempting to invoke has been converted to an
Upstart job...
One other comment I should make - this is not on a box that I set up, and this is the first cron job I have attempted on this box, so if there is anything in particular I need to do to make sure crons are functioning on this box, I may have missed it.
Sorry how terse I was, I was in a hurry.
When the script file executes correctly using this line:
php /srv/var/www/ads.bandmix.com/cron/check_pending.php > /home/ubuntu/cronlogs/check_pending.txt
then I get an email from the script, and this file is generated...
I've made a cron job that I am not getting results from. For testing, I entered the following line into crontab:
*/1 * * * * php /srv/var/www/ads.bandmix.com/cron/check_pending.php > /home/ubuntu/cronlogs/check_pending.txt
Now I can enter the following line into the command prompt and get...
traycee and SkipVought,
Thank you for your input.
To better explain my situation, I am working on a large project deployed to numerous locations, and have to keep track of my progress in a spreadsheet. I typically have many windows open, and I have been leaving the spreadsheet in the...
I have a spreadsheet I need open and editable all day, preferably on top. I only need to be able to work with a small section at a time, two or three colums and a maximum of five rows. I've tried to look around into what I can do with Windows Sidebar and Google Sidebar but the only thing I can...
For anyone searching for an answer to this question, I have resolved the issue.
There was a white space between the opening parend and the first argument:
SUBSTR( arg1...
Removing this single whitespace resolved the issue, as is shown below:
SUBSTR(arg1...
I have a query that I have executed on a MySQL 5.3 server, but when I try to execute the same query on the MySQL 5.0 server the server returns the following error message:
Error Code : 1305
FUNCTION dbname.SUBSTRING does not exist
I have never encountered this before. I have tried using...
I want to validate an input field to be numeric with a variable precision, e.g. 1, 1.2, 1.23, etc. If I was doing it without jQuery, it'd look something like this:
function validateNum(id, precision){
var regex = /^\d{1,3}\.?\d{precision}$/;
if...
BillyRayPreachersSon:
You are correct. I have fixed this problem, and it was not the regex at fault. Using breakpoints did help me find the error farther down in the code.
feherke:
Thank you for your input. I have been attempting to better my skills with regex, and your comment helps me to...
I am writing a date validation function using jQuery, and seem to have run into a snag. Before I go into detail on the actual date, I run a quick regex to make sure that the format is right, but it is returning false on some dates that I know are valid. For instance, 01/22/2010 is fine, but it...
BillyRayPreachersSon:
Good call. It appears to work correctly in FireFox using the timer. It slows IE down enough to be able to watch focus going back and forth between the field tabbed out of and the field tabbed into.
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.