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 Herrold wrote: > 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 fir

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
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 Kachold wrote: > I can't remember who made it!  I think it was one of younger guys! >

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 wrote: > On Fri, Jul 31, 2009 at 7:33 PM, Lisa Kachold > wrote: > >> Just like it says! >> >> -- >> >> (623)239-3392 >> (503)754-4452 www.obnosis.com >> > >

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 >

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 creat

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 alig

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 afte

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

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 dat

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 does

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

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` `columnna

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

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

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 hav

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 mi

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

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

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