RE: INSERT INTO foo () VALUES ()

[prev] [thread] [next] [Date index for 2004/05/26]

From: "g
Subject: RE: INSERT INTO foo () VALUES ()
Date: 06:00 on 26 May 2004

Hiya,

Tony Bowden said:
> Is this something else that's going to differ across the various
> databases? Or is there something standard that everything 
> will be happy with?
> Anyone able to confirm what Pg, Oracle, Sybase, etc need?

	Breaks horribly using Sybase :(

	Simon, maybe your best bet is to just use set_sql. If that statement
never changes, you can just call your set SQL with ->single_val. The only
thing is, it will require you to call retrieve with that set_sql->single_val
call as an argument. Which by even perl's standards, is really ugly.

INSERT INTO foo () VALUES ()
Simon Cozens 13:55 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Tony Bowden 14:13 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Simon Cozens 14:35 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Tony Bowden 14:37 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
ed-cdbi 14:42 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Simon Cozens 14:49 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
ed-cdbi 15:13 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
cees-cdbi 15:47 on 25 May 2004

Re: INSERT INTO foo () VALUES ()
Branislav Zahradnik 16:20 on 25 May 2004

RE: INSERT INTO foo () VALUES ()
"g 06:00 on 26 May 2004

Re: INSERT INTO foo () VALUES ()
Edward J. Sabol 14:40 on 26 May 2004