On 18/04/06, Dave Howorth <[EMAIL PROTECTED]> wrote:
> Kim Ryan wrote:
> > OK, now I know that lower case names are expected. This problem
> > came up when a user was adding a Maypole front end to an existing
> > database that had columns with upper case names. There will be
> > situations like t
Kim Ryan wrote:
OK, now I know that lower case names are expected. This problem
came up when a user was adding a Maypole front end to an existing
database that had columns with upper case names. There will be
situations like this where you cannot alter the database schema.
CDBI has good facil
Thanks Aaron,
OK, now I know that lower case names are expected. This problem
came up when a user was adding a Maypole front end to an existing
database that had columns with upper case names. There will be
situations like this where you cannot alter the database schema.
I added a section on c
On 4/13/06, Peter Speltz <[EMAIL PROTECTED]> wrote:
> funny , I just ran accross this piece of code today and thought to
> myself, "Thats a good comment" :)
>
> __PACKAGE__->connection("dbi:mysql:database=$db;host=$host", $usr,
> $pw,{FetchHashKeyName => 'NAME',});
> # NOTE need to specify
funny , I just ran accross this piece of code today and thought to
myself, "Thats a good comment" :)
__PACKAGE__->connection("dbi:mysql:database=$db;host=$host", $usr,
$pw,{FetchHashKeyName => 'NAME',});
# NOTE need to specify NAME above since the old tables use mixed case
col names.
Try
Kim Ryan wrote:
The odd thing is if I remove these lines to display all columns, the
sorting
works correctly. The beer example uses all lower case column names,
could not find any examples of people using column names starting with
upper case.
Column-name case-sensitivity is database dependent
Hi Kim
> I don't specifically refer to the Place column in the template,
> just use the generic factory templates. Because I don't want to
> display all columns in the table I have the following code:
>
> package Verification::MyData;
> sub display_columns
> {
> qw(
> Name
> Place
>
Hi Aaron,
I don't specifically refer to the Place column in the template,
just use the generic factory templates. Because I don't want to
display all columns in the table I have the following code:
package Verification::MyData;
sub display_columns
{
qw(
Name
Place
)
}
sub column_name
I normally use all lower case letters for my column names and
both ascending and descending column sorts work fine in lists.
I noticed problems when the column name starts with an upper case
letter. For example, I have a column called Place,
mytable/list/?order=Place&page=1 , does not return cor
