ary value).
Thanks in advance
Adam
--
/------\
|Adam Carmichael, A+, 2xMCP (Windows 2000), Cert IV Helpdesk Admin |
|[EMAIL PROTECTED] /( _,-,_ )\ _| |_ /,|| |
|#1 Computer Services \`/ \'/ _| |_|| |
|B
The more I look at this, the more I think I may be forced to select the date
interval to add and then build a query and execute it rather than do that in
just one statement. I would have preferred to have this work (or something
similar).
--
Adam Carmichael
[EMAIL PROTECTED]
- Original M
g along the lines of:
UPDATE foo_table
SET NextDate=DATE_ADD(foo_table.NextDate,(SELECT foo_table.Period))
WHERE NextDate<=NOW()
Has anybody tried anything like this before with any luck?
Regards,
Adam Carmichael
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
e earlier on today to help me compile mysql with debugging (which was
answered quickly [Thanks Sergei!]), however there was no further information yielded
in the errorlog as to what I had before.
Thanks in advance
Adam Carmichael
Network Operations Manag
Worked like a charm!
Thank you very much Sergei! :)
Adam
- Original Message -
From: "Sergei Golubchik" <[EMAIL PROTECTED]>
To: "Adam Carmichael" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 20, 2003 10:04 PM
Subject: Re: MySQL com
reference errors - so I have
piped the STDOUT and STDERR to a file available for download at:
http://www.no1.com.au/~adamc/makeoutput.txt hoping that someone with more C/C++
knowledge than myself can offer some insight.
Thanks in advance,
Adam Carmichael
Network Operations Manager
ema
