You're right, John, MySQL is not case sensitive on column names. I
did some research and found that my problem was due to the fact
that the table map *is* case sensitive and we were passing in lower
case names that matched our db.
On Wednesday, January 10, 2001, at 11:17 AM, John McNally wrote:
> The patch for Peer.vm appears fine. I do not like the one for
> MapBuilder.vm. In $cup, I believe the up stands for uppercase, if there
> is really some problem I would just use $col.Name in its place, but ...
>
> I do not think MySQL is case sensitive on column names. It is on table
> names on platforms where the filesystem is case sensitive. Please
> investigate this a bit more before changing things as it will affect
> other databases and I know MySQL works fine for me, with the current
> system of uppercase column names.
>
> >
> > % cvs diff -u Peer.vm
> > Index: Peer.vm
> > ===================================================================
> > RCS file: /products/cvs/turbine/turbine/conf/torque/templates/om/Peer.vm,v
> > retrieving revision 1.12
> > diff -u -r1.12 Peer.vm
> > --- Peer.vm 2001/01/05 17:09:49 1.12
> > +++ Peer.vm 2001/01/10 17:08:39
> > @@ -167,8 +167,8 @@
> > #end
> > #if ($addSaveMethod)
> > obj.setModified(false);
> > - obj.setNew(false);
> > #end
> > + obj.setNew(false);
> > return obj;
> > }
> >
> > @@ -470,6 +470,7 @@
> > public static void doInsert( $table.JavaName obj ) throws Exception
> > {
> > obj.setPrimaryKey(doInsert(buildCriteria(obj)));
> > + obj.setNew(false);
> > }
> >
> > /**
> > @@ -497,6 +498,7 @@
> > public static void doInsert( $table.JavaName obj, DBConnection dbCon) throws
>Exception
> > {
> > obj.setPrimaryKey(doInsert(buildCriteria(obj), dbCon));
> > + obj.setNew(false);
> > }
> >
> > /**
> >
> > % cvs diff -u MapBuilder.vm
> > Index: MapBuilder.vm
> > ===================================================================
> > RCS file: /products/cvs/turbine/turbine/conf/torque/templates/om/MapBuilder.vm,v
> > retrieving revision 1.11
> > diff -u -r1.11 MapBuilder.vm
> > --- MapBuilder.vm 2001/01/03 20:14:39 1.11
> > +++ MapBuilder.vm 2001/01/10 17:09:28
> > @@ -26,7 +26,7 @@
> > #foreach ($col in $table.Columns)
> > #set ( $tfc=$table.JavaName )
> > #set ( $cfc=$col.JavaName )
> > - #set ( $cup=$col.Name.toUpperCase() )
> > + #set ( $cup=$col.Name )
> >
> > /** ${table.Name}.$cup */
> > public static String get${tfc}_${cfc}()
> > @@ -83,7 +83,7 @@
> > #foreach ($col in $table.Columns)
> > #set ( $tfc=$table.JavaName )
> > #set ( $cfc=$col.JavaName )
> > - #set ( $cup=$col.Name.toUpperCase() )
> > + #set ( $cup=$col.Name )
> >
> > #if($col.isPrimaryKey())
> > #if($col.isForeignKey())
> >
> >
> >
> > ------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> > Problems?: [EMAIL PROTECTED]
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
> Problems?: [EMAIL PROTECTED]
>
>
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
