Re: SQL::Statement cannot parse valid Postgresql statement

2001-12-10 Thread Terrence Brannon
On Monday, December 10, 2001, at 11:29 AM, Jeff Zucker wrote: > It's still not clear to me exactly what you're expecting SQL::Statment > to do, but if it's a simple as identifying the command, my newer > version > (still in development) can allow you to bypass the error message you're > getting

Re: SQL::Statement cannot parse valid Postgresql statement

2001-12-10 Thread Terrence Brannon
On Monday, December 10, 2001, at 10:30 AM, Wilson, Doug wrote: > >> From: Terrence Brannon [mailto:[EMAIL PROTECTED]] >> >> On Monday, December 10, 2001, at 09:16 AM, Jeff Zucker wrote: >> >>> Terrence Brannon wrote: The following SQL is not parseable by SQL::Statement: INSER

Re: SQL::Statement cannot parse valid Postgresql statement

2001-12-10 Thread Jeff Zucker
Terrence Brannon wrote: > > > sub test { > ... > my $parse = parse_sql $sql;## calls SQL::Statement > ... > return unless ($parse->{command} =~ /select/i); It's still not clear to me exactly what you're expecting SQL::Statment to do, but if it's a simple as identifying t

RE: SQL::Statement cannot parse valid Postgresql statement

2001-12-10 Thread Wilson, Doug
> From: Terrence Brannon [mailto:[EMAIL PROTECTED]] > > On Monday, December 10, 2001, at 09:16 AM, Jeff Zucker wrote: > > > Terrence Brannon wrote: > >> > >> The following SQL is not parseable by SQL::Statement: > >> > >> INSERT > >>INTO thot_log (thot_fk,thot_type_fk,thot_temporality_fk,

Re: SQL::Statement cannot parse valid Postgresql statement

2001-12-10 Thread Terrence Brannon
On Monday, December 10, 2001, at 09:16 AM, Jeff Zucker wrote: > Terrence Brannon wrote: >> >> The following SQL is not parseable by SQL::Statement: >> >> INSERT >>INTO thot_log (thot_fk,thot_type_fk,thot_temporality_fk,date) >>VALUES (?,?,?,CURRENT_TIMESTAMP) >> >> the error msg is : >

Re: SQL::Statement cannot parse valid Postgresql statement

2001-12-10 Thread Jeff Zucker
Terrence Brannon wrote: > > The following SQL is not parseable by SQL::Statement: > > INSERT >INTO thot_log (thot_fk,thot_type_fk,thot_temporality_fk,date) >VALUES (?,?,?,CURRENT_TIMESTAMP) > > the error msg is : > > Parse error near CURRENT_TIMESTAMP) What is your aim here? If you

SQL::Statement cannot parse valid Postgresql statement

2001-12-09 Thread Terrence Brannon
The following SQL is not parseable by SQL::Statement: INSERT INTO thot_log (thot_fk,thot_type_fk,thot_temporality_fk,date) VALUES (?,?,?,CURRENT_TIMESTAMP) the error msg is : Parse error near CURRENT_TIMESTAMP) Also, this module is listed under Jochen Wiedman, but I was under the im