"Jeff Zucker" <[EMAIL PROTECTED]> wrote in message
news:3DB98694.8080701@;vpservices.com...
> Yes, there is a bug in SQL::Statement related to table names combined with
a column name (e.g. megaliths.id).
>
> I will be releasing a fix later today.
Thank you oh great and wise one! I appreciate the h
On Friday, October 25, 2002 11:01 PM [GMT + 10:00 AEST],
Scott McGee <[EMAIL PROTECTED]> wrote:
> I am trying to get comfortable with DBI, and due to stupid
> circumstances beyond my control at the moment, have to try to make do
> without an actual database server. This means using something like
Scott McGee wrote:
SQL::Parser v1.004
SQL::Statement v1.004
> ...
my $query = "SELECT megaliths.id, megaliths.name, site_types.site_type
Yes, there is a bug in SQL::Statement related to table names combined with a column name (e.g. megaliths.id).
I will be releasing a fix later today
<[EMAIL PROTECTED]> wrote in message
news:1842904766.20021025094128@;comcast.net...
> It appears from the error message that it cannot locate the CSV file
> at all. Are you sure:
>
> $dbd = "DBI:CSV:f_dir=magalith_db";
>
> Is correct? You've spelled 'megalith' as 'magalith'. Just have to
> check
s your
script and that you've got a file named megaliths.csv in that dir.
Nick Hendler
[EMAIL PROTECTED]
_
From:Scott McGee <[EMAIL PROTECTED]>
Date:Friday, October 25, 2002
Time: 9:01:08 AM
Subject: DBD::CSV and multiple table qu
I am trying to get comfortable with DBI, and due to stupid circumstances
beyond my control at the moment, have to try to make do without an actual
database server. This means using something like DBD::CSV. I am just trying
to go through the O'Reilly Perl DBI book, so don't need anything too complex
On Wed, Feb 14, 2001 at 11:27:34AM +1100, Stacy Mader wrote:
>
> So my question is: for fault_no's with multiple response_no's, can
> I modify the SQL to just
> return results with the latest response_no only? For example, from the
> above query, I'd
> like to have returned:
>
> '1189','653','Dr
ive a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
- Original Message -
From: "Stacy Mader" <[EMAIL PROTECTED]>
To: "dbi-users" <[EMAIL PROTECTED]>
Sent: Tuesday, February 13, 2001 7:27 PM
Subject: Mult
ROTECTED]>
Sent: Tuesday, February 13, 2001 5:34 PM
Subject: Re: Multiple table queries
> Louise,
>
> Thanks, that works great. One thing though: what about when response_no
> = null? These don't show!!!
>
> Regards,
> Stacy.
>
>
> "Mitche
where a.fault_no = b.fault_no )
>
> This is Oracle-ish sql... hope this helps..
>
> L
>
> -Original Message-
> From: Stacy Mader [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 13, 2001 4:28 PM
> To: dbi-users
> Subject: Multiple table queries
&g
I have tried DISTINCT, but I still get the same results: ie,
SELECT DISTINCT
response.response_no,
response.category
FROM report,
response
WHERE report.fault_no = response.fault_no(+)
Results:
'1189','457','Telescope control system'
'1189
On Wed, 14 Feb 2001 11:27:34 +1100, Stacy Mader <[EMAIL PROTECTED]>
wrote:
Have you tried using DISTINCT in your SELECT query??
>>
>>Hi all,
>>
>>I am trying to perform a query from two tables linked by the field
>>fault_no. My SQL is:
>>
>>
>>SELECT report.fault_no,
>> respon
Hi all,
I am trying to perform a query from two tables linked by the field
fault_no. My SQL is:
SELECT report.fault_no,
response.response_no,
response.category
FROM report,
response
WHERE report.fault_no = response.fault_no(+)
Now th
13 matches
Mail list logo