Re: DBI SQL problem

This really isn't a perl question. At all. Not even a bit. Just because you are using perl to execute the SQL doesn't make it a perl thing (99.9% of the time anway). Please, for yours and our sanity go ask on your database's mailing list. A snippet of SQL's behaviour can and will be different between different databases. On it's face the behaviour looks odd but it's also entirely possible that this is understandable from the perspective of your database. Right now we don't know if this is PostgreSQL or MySQL or what your table schema and data looks like.

So... either just turn that into a completely RDMBS oriented question (since that what it really is) or ask the question in an appropriate forum. Just don't pretend it's a perl question.

Update: Fixed formatting

Comment on Re: DBI SQL problem

Replies are listed 'Best First'.
Re^2: DBI SQL problem by Aristotle (Chancellor) on Sep 22, 2002 at 20:55 UTC
I disagree. Quoth vroom himself in Friar: The monastery tolerates general off-topic questions occasionally, and some monks even know a little bit about operating systems, web servers, databases, and the like. Perl is a glue language, and occasionally it has to interact with other things. Sometimes the problem is with the poster's code, sometimes not. If the question has come up before, it will probably come up again. Let the archives take it. Makeshifts last the longest.	[reply]
Re: Re^2: DBI SQL problem by diotalevi (Canon) on Sep 22, 2002 at 23:02 UTC
Well... I disagree with your disagreement. There's a whole lot of context missing in that question which just nixed it for me. I really got the impression that the poster either didn't get it and thinks it's a perl question or was just leaving some perl crumbs onto a SQL only problem. It's entirely possible for a person who knows ANSI SQL would notice that DATE is reserved but in general the entire behaviour in question is going to very RDBMS specific. There just isn't any fair way for the people here to guess at what the RDBMS was really doing since no one knew what it is. It's sort of like asking about some specific output from ps(1). While we all know what that is and in general it acts (I suppose) similarly from UNIX to UNIX the actual options are going to be different and it isn't really fair to expect any PM to be able to answer the question. I'm also ill and cranky today so that's partly why I'm less tolerant than I might be normally. I thought I was fair - mostly.	[reply]
Re^blah: DBI SQL problem by Ryszard (Priest) on Sep 23, 2002 at 07:23 UTC
Good, call. Despite my initial post receiving a fair bit of down voting, I stick by my comments. It appears to me as if the original poster had chosen a website a random and posted the question. There is no mention of perl, no mention of OT. Sure there are lots of people here (myself included) who know the answer to the question, however I know the answer to lots of different questions that may arise, and also have may questions that people here may be able to answer. Doesnt mean I'm going to ask them all, nor answer them all... IMHO, the original post was the wrong place to put it. A db mailing list or other db related website/faq/news group would be much more suited...	[reply]