I don't know the answer to the questions in the note! On Thu, Jul 24, 2008 at 6:53 PM, Wendi Whitcomb wrote:

Hi

Nancy: you can skip to the note :) When I queried the ASM Developer database, I received the following sizes: 0, 1, 2, 3, 4, 5. I assigned 0 & 1 to Small, 2 & 3 to Medium, 4 & 5 to large. However this does not seem to match the birds in the database correctly. I am getting Amazons mixed in with cockatiels, Macaws mixed in with conures and cockatiels. Is this just because it's a developer database or is that not the correct field (animal.Size). Matt are there pictures of the birds in the developer database (i.e, that is to say some ID and accessible path that I could pull the photo...if not I'll just stub it out until later and put fake photos in)

Note: I have Menu (queries) for small, medium, large birds. A menu item that takes you to page where the number of birds per species is listed, one can then click on the species and be taken to a listing of birds of that species.

In process...would like input

1. On the newly added birds, what is the time period for being in the category "New Additions" 1 month, 2 weeks, etc? 2. On the Advanced search: * check boxes for good with children, special needs, drop down for species and size (which are mutually exclusive). Other parameters?

Thanks,

Wendi

-- Nancy Powell Operations Manager Mickaboo Companion Bird Rescue www.mickaboo.org

Wendi: The ASM database fields aren't -exactly- as they seem. We customized things a good deal in the codebase and database. In the instance of animal.Size we actually reused (but did not rename) that field for "Health Status" as it is displayed on our website. Our "small" "medium" and "large" bird categories were simply assigned by us in the website code. Below is the relevant snippet. Note that I realize this isn't intuitive or optimal -- that's just what we had to work with at the time. The developer ASM database has photos in it; it's basically a snapshot of the current ASM database that's static (no one uses it). ================= ## Determine whether the bird is small, medium or large if ( $speciesID <= 5 ) { $size = "small"; } elsif ( $speciesID <= 11 ) { $size = "medium"; } elsif ( $speciesID <= 15 ) { $size = "large"; } elsif ( $speciesID == 16 ) { $size = "small"; } elsif ( $speciesID == 17 ) { $size = "small"; } elsif ( $speciesID == 18 ) { $size = "medium"; } elsif ( $speciesID == 19 ) { $size = "medium"; } elsif ( $speciesID == 20 ) { $size = "medium"; } ================== Wendi Whitcomb wrote:

Hi

Nancy: you can skip to the note :) When I queried the ASM Developer database, I received the following sizes: 0, 1, 2, 3, 4, 5. I assigned 0 & 1 to Small, 2 & 3 to Medium, 4 & 5 to large. However this does not seem to match the birds in the database correctly. I am getting Amazons mixed in with cockatiels, Macaws mixed in with conures and cockatiels. Is this just because it's a developer database or is that not the correct field (animal.Size). Matt are there pictures of the birds in the developer database (i.e, that is to say some ID and accessible path that I could pull the photo...if not I'll just stub it out until later and put fake photos in)

Note: I have Menu (queries) for small, medium, large birds. A menu item that takes you to page where the number of birds per species is listed, one can then click on the species and be taken to a listing of birds of that species.

In process...would like input

1. On the newly added birds, what is the time period for being in the category "New Additions" 1 month, 2 weeks, etc? 2. On the Advanced search: * check boxes for good with children, special needs, drop down for species and size (which are mutually exclusive). Other parameters?

Thanks,

Wendi