Re: SQL question // date_format

2003-09-28 Thread Todd Farmer
I've used DATE_ADD function in MySQL for similar purposes: "SELECT id, DATE_FORMAT(DATE_ADD(datecreated, INTERVAL 2 HOUR), '%c/%e/%y at: %l:%i %p'), email, name, comments FROM $table_name order by id limit $offset,10;" Todd F. - Original Message - From: "David Gilden" <[EMAIL PROTECTED

Problem with LWP

2003-09-28 Thread George R. Gonzalez
LWP doesnt see a response from Galaxy Embedded Web Server. I have a cheeep router with an embedded Web server for maintenance. I'd like to read the stats page with LWP, but LWP doesnt get the body of the response. It returns the "OK" response, but no body If I step thru the code, it looks like

Re: SQL question escaping quotes

2003-09-28 Thread Todd Wade
"David Gilden" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > One final question here on my SQL -- PERL DBI > > > the following is wrong -- it does not work ! > > $sql = qq|insert into $table_name values (null,now(),"$email","$name","$comments");|; > $sql = $dbh->quote($sql); ## thi

Re: CGI Newbie - Need book recommendation

2003-09-28 Thread Shaun Fryer
> I am a complete newbie to CGI and have no programming experience. Do > any of you have a good recommendation on books are resources that will > help me? On the command line... perldoc perldoc Or if you prefer a browser based tutorial, try perldoc.com In particular: http://perldoc.com