archive to see any postings
-Original Message-
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 30, 2001 6:13 AM
To: Boyd, David; EmbPerl News Group (E-mail)
Subject: Re: Help on using DBIx
> This is correct I am passing %fdat to Execute.
>
> From the documen
> Sent: Wednesday, August 29, 2001 2:40 PM
> To: Boyd, David; EmbPerl News Group (E-mail)
> Cc: [EMAIL PROTECTED]
> Subject: Re: Help on using DBIx
>
>
> > If I understand you correctly. When you use DBIx with an excute it
makes
> > use of what is in %fdat even though
&
hat I am
reading then I apologies for
I am new to developing web sites with Perl.
-Original Message-
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 2:40 PM
To: Boyd, David; EmbPerl News Group (E-mail)
Cc: [EMAIL PROTECTED]
Subject: Re: Help on using D
> If I understand you correctly. When you use DBIx with an excute it makes
> use of what is in %fdat even though
> I did not do a $fdat{!Fields'} or $fdat('$fields'} statement. if that is
> the case then there seems to be a problem with using
> DBIx. I can see why using the search does not have
does not have a problem is that I am
telling it directly what to use.
-Original Message-
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 12:48 PM
To: Boyd, David; EmbPerl News Group (E-mail)
Cc: [EMAIL PROTECTED]
Subject: Re: Help on using DBIx
...
> fdat
...
> fdat{note.employee_key} = 1
...
> fdat{note.note_datetime} = 8/29/2001
> fdat{note.note_key} = 10037
> fdat{note.incident_key} = 10149
The above values of %fdat, are made to the where expression by
DBIx::Recordset. You only pass %fdat to Execute not to Search, that's the
difference:
> DB:
Below is the code that I have written to handle the case of when the user
selects the update button on the form. The update button is of type submit.
I
assume that what is in fdat are all the items that are on the form. I have
created an array that holds the names of each of the form elements:
On Tue, Aug 28, 2001 at 03:57:45PM -0500, Boyd, David wrote:
> DBIx::Recordset::Undef ('set');
> $fdat{'!DataSource'} = GetDSN();
> $fdat{'!Table'} = 'note';
> $fdat{'!Fields'} = 'MAX(note.note_key) AS dave';
> $fdat{'=search'} = 'ok';
>
> *set = DBIx::Recordset->Execute({%fdat});
>
a where statement? pretty wacky.
-Original Message-
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 28, 2001 10:40 AM
To: Boyd, David; EmbPerl News Group (E-mail)
Subject: Re: Help on using DBIx
> What is the difference between these statemens:
>
Should be the
> What is the difference between these statemens:
>
Should be the same if $DSN and GetDSN and $Table and 'note' are the same.
BTW. The use of \%fdat instead of {%fdat} is a little fater
If it still doesn't work, set $DBIx::Recordset::Debug = 2 before any access
and watch the log output
Geral
DBIx::Recordset->Execute({%fdat});
push @debugMessage, "another one set{dave} = $set{dave}";
To me they seem to be the same except the bottom statement does not produce
a results.
...
-----Original Message-
From: Gerald Richter [mailto:[EMAIL PROTECTED]]
Sent: Monday, Augu
You need to give column names when a accessing the result:
$fdat{'!Fields'} = "employee_key, first_name || ' ' || last_name as
name";
...
[+
$employeeDat[$row]{name} +]
or even better leave out the $row in the second expression, because
otherwise the loop will end when you have an name that
12 matches
Mail list logo
