Recent content by JBellTek

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

feherke: Yes, thank you. With your help I now have the final piece to the solution for my problem.

Interesting. I wondered about that. What is the best way to find the current php install location? It was not where I expected to find it.

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

whosrdaddy I didn't see your response before I posted. Thank you for your respone.

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

jmeckley: Thank you. I'd looked for a jQuery forum, but I guess somehow I missed it.