[Babase] Query trouble

kfenn kfenn at princeton.edu
Fri Mar 20 08:42:08 EDT 2009


Karl O. Pinc wrote:
>
> On 03/19/2009 04:18:20 PM, Catherine Markham wrote:
>> Hi Karl,
>>
>> It was the caps in the column names that messed me up.  After reading 
>> your comments, I changed everything to lower case and the query 
>> worked perfectly.  Thanks!
>
> I find it hard to get caps in the column names.  What are
> folks doing that allows caps and what can we do about
> keeping it from happening?
>
I've never noticed that it's hard to get caps in the column names.  Most 
of the users at Princeton make tables using the interface available in 
PPA and then populate them with data from a tabbed text file...so maybe 
that's the difference (I'm guessing you use SQL to make your tables 
Karl).  I tell people here to avoid caps in column headers and we've 
removed them several times when troubleshooting queries.  I'll try to 
stick it in the tutorial someplace in BIG LETTERS, but honestly I don't 
know if we've really written a good section on creating tables in PPA 
yet because selecting the data types can be tricky.  I usually sit down 
with folks and walk them through it based on the data they want to import.

Tabby

> Karl <kop at meme.com>
> Free Software:  "You don't pay back, you pay forward."
>                  -- Robert A. Heinlein
>
> _______________________________________________
> Babase mailing list
> Babase at www.eco.princeton.edu
> http://www.eco.princeton.edu/mailman/listinfo/babase

-- 
Tabby Fenn
Research Assistant

Dept of Ecology and Evolutionary Biology
401 Guyot Hall
Princeton University
Princeton, NJ  08544

609 258-6898 (Ph)
609 258-2712 (Fx)



More information about the Babase mailing list