Re: I need help with IPCop.

2009-08-04 Thread Eric Shubert
Matthew A Coulliette wrote: Hi Lisa Eric, Questions: Can you just assign an ip number to a computer? Yes, for the most part. You also need to give it a subnet mask, so it knows what the network and broadcast addresses are. The network and broadcast addresses are the first and last

Re: I need help with IPCop.

2009-08-04 Thread Craig White
On Tue, 2009-08-04 at 08:10 -0700, Eric Shubert wrote: Once you have a caching nameserver set up on an orange host, any additional servers on the orange subnet can use that resolver as well. You might need to tweak the config a little to allow other machines to query it though - I'm not

Re: I need help with IPCop.

2009-08-04 Thread Eric Shubert
Craig White wrote: On Tue, 2009-08-04 at 08:10 -0700, Eric Shubert wrote: Once you have a caching nameserver set up on an orange host, any additional servers on the orange subnet can use that resolver as well. You might need to tweak the config a little to allow other machines to query

Re: I need help with IPCop.

2009-08-04 Thread Craig White
On Tue, 2009-08-04 at 09:26 -0700, Eric Shubert wrote: Craig White wrote: On Tue, 2009-08-04 at 08:10 -0700, Eric Shubert wrote: Once you have a caching nameserver set up on an orange host, any additional servers on the orange subnet can use that resolver as well. You might need to

Mysql updating dates in a table

2009-08-04 Thread Craig White
I need to update almost all (but not quite all) records in a data table because the dates were imported like '08/04/09' instead of '2009-08-04' I am looking at the mysql reference manual but it doesn't appear that it would be easy to script a line by line 'update' from a csv file. Now I still

Re: Mysql updating dates in a table

2009-08-04 Thread Eric Cope
how many tables? On Tue, Aug 4, 2009 at 3:44 PM, Craig White craigwh...@azapple.com wrote: I need to update almost all (but not quite all) records in a data table because the dates were imported like '08/04/09' instead of '2009-08-04' I am looking at the mysql reference manual but it doesn't

Re: Mysql updating dates in a table

2009-08-04 Thread Austin William Wright
Craig White wrote: I need to update almost all (but not quite all) records in a data table because the dates were imported like '08/04/09' instead of '2009-08-04' I am looking at the mysql reference manual but it doesn't appear that it would be easy to script a line by line 'update' from a

Re: Mysql updating dates in a table

2009-08-04 Thread Austin William Wright
Austin William Wright wrote: [...] Replace all instances of tablename and columnname with the targets, and change DATE NOT NULL as necessary. That should work. Whoops, Thunderbird formatted my fonts for me, ignore the pipes (wysiwyg fail): ALTER TABLE `tablename` CHANGE `columnname`

Re: Mysql updating dates in a table

2009-08-04 Thread Craig White
On Tue, 2009-08-04 at 15:46 -0700, Eric Cope wrote: how many tables? On Tue, Aug 4, 2009 at 3:44 PM, Craig White craigwh...@azapple.com wrote: I need to update almost all (but not quite all) records in a data table because the dates were imported like '08/04/09'

Re: Mysql updating dates in a table

2009-08-04 Thread Craig White
On Tue, 2009-08-04 at 16:05 -0700, Austin William Wright wrote: Craig White wrote: I need to update almost all (but not quite all) records in a data table because the dates were imported like '08/04/09' instead of '2009-08-04' I am looking at the mysql reference manual but it doesn't

Re: Mysql updating dates in a table

2009-08-04 Thread JD Austin
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html* You can use Str_to_date to convert it to a date. *Date*/*timestamp data should be* *one of the date types (Datetime, date, timestamp). I'd do it like this (all sql and won't lose data): 1. Add a column to the table that is

Re: Mysql updating dates in a table

2009-08-04 Thread Craig White
On Tue, 2009-08-04 at 16:21 -0700, JD Austin wrote: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html You can use Str_to_date to convert it to a date. Date/timestamp data should be one of the date types (Datetime, date, timestamp). I'd do it like this (all sql and won't lose

Re: Mysql updating dates in a table

2009-08-04 Thread JD Austin
If the current column was a date type there had to be a ton of failures! If you have unique values in the data you can just craft update statements from the csv file. Use excel/OO Calc, perl, etc to parse apart the original file to create update table statements that you can pipe back to mysql

OT: Elance and Outsourcing Room

2009-08-04 Thread Eric Cope
I recently received an email saying I had finished registering at outsourceroom.com (I have never heard of them). My username, name, email all matched my typical business identification. I googled them and found a report on ripoff report saying they scraped data from Elance.com. This certainly

Re: Mysql updating dates in a table

2009-08-04 Thread Craig White
On Tue, 2009-08-04 at 16:41 -0700, JD Austin wrote: If the current column was a date type there had to be a ton of failures! If you have unique values in the data you can just craft update statements from the csv file. Use excel/OO Calc, perl, etc to parse apart the original file to create

Re: I need help with IPCop.

2009-08-04 Thread Eric Shubert
Craig White wrote: On Tue, 2009-08-04 at 09:26 -0700, Eric Shubert wrote: Craig White wrote: On Tue, 2009-08-04 at 08:10 -0700, Eric Shubert wrote: Once you have a caching nameserver set up on an orange host, any additional servers on the orange subnet can use that resolver as well. You

Re: Sonoran Penguin

2009-08-04 Thread Lisa Kachold
I can't remember who made it! I think it was one of younger guys! I don't have all that email thread from 2 years ago! On 8/3/09, Dazed_75 lthiels...@gmail.com wrote: On Fri, Jul 31, 2009 at 7:33 PM, Lisa Kachold lisakach...@obnosis.comwrote: Just like it says! -- (623)239-3392

Re: Sonoran Penguin

2009-08-04 Thread Joshua Zeidner
I made it with GIMP. How come no one liked it when I posted it I need to fire my PR manager. come to think of it, it does look better when Lisa posted it. :) -jmz On Tue, Aug 4, 2009 at 6:35 PM, Lisa Kacholdlisakach...@obnosis.com wrote: I can't remember who made it!  I think it was

Re: Sonoran Penguin

2009-08-04 Thread R P Herrold
On Tue, 4 Aug 2009, Joshua Zeidner wrote: I made it with GIMP. How come no one liked it when I posted it I need to fire my PR manager. I read email with [al]pine in a monochrome terminal, fast and low, and tossing read pieces out. If it was in an early email, I missed it. I cannot

Re: Sonoran Penguin

2009-08-04 Thread Joshua Zeidner
If everyone likes this, I can offer to write a Drupal template for the PLUG site using this concept. -jmz On Tue, Aug 4, 2009 at 8:03 PM, R P Herroldherr...@owlriver.com wrote: On Tue, 4 Aug 2009, Joshua Zeidner wrote:  I made it with GIMP.  How come no one liked it when I posted it