Only List Active Aquaria when Adding to My Cats
- Martin S
- Posts: 2100
- Joined: 26 Mar 2003, 11:14
- I've donated: $20.00!
- My images: 9
- My cats species list: 90 (i:19, k:0)
- My aquaria list: 11 (i:3)
- Spotted: 17
- Location 1: Guildford, Surrey
- Location 2: UK
- Interests: Aquatics
Only List Active Aquaria when Adding to My Cats
When you add (a nd subsequently edit) a new addition to My Cats, it gives you the option to assign the fish to an aquarium - could this list only show those that are active?
I'm assuming it's something along the lines of 'AND [MY_Aquaria].[Stop_Date] IS NULL' type addition to the query that brings back this list?
Martin
I'm assuming it's something along the lines of 'AND [MY_Aquaria].[Stop_Date] IS NULL' type addition to the query that brings back this list?
Martin
- MatsP
- Posts: 21038
- Joined: 06 Oct 2004, 13:58
- My articles: 4
- My images: 28
- My cats species list: 117 (i:33, k:0)
- My aquaria list: 12 (i:10)
- My BLogs: 4 (i:0, p:164)
- Spotted: 187
- Location 1: North of Cambridge
- Location 2: England.
Re: Only List Active Aquaria when Adding to My Cats
I'm moving this to "Bugs", as it's clearly wrong. And I agree, it's conceptually the fix you describe. It's slightly more complicated because the code for "take things from a database and make it into a drop-down" is generic (it's used to select species, genus, etc, etc), but I think there is a way to add an extra statement.
--
Mats
--
Mats
- MatsP
- Posts: 21038
- Joined: 06 Oct 2004, 13:58
- My articles: 4
- My images: 28
- My cats species list: 117 (i:33, k:0)
- My aquaria list: 12 (i:10)
- My BLogs: 4 (i:0, p:164)
- Spotted: 187
- Location 1: North of Cambridge
- Location 2: England.
Re: Only List Active Aquaria when Adding to My Cats
Fixed in R548.
--
Mats
--
Mats
- Jools
- Expert
- Posts: 16274
- Joined: 30 Dec 2002, 15:25
- My articles: 198
- My images: 941
- My catfish: 237
- My cats species list: 87 (i:13, k:1)
- My aquaria list: 21 (i:13)
- My BLogs: 7 (i:10, p:167)
- My Wishlist: 23
- Spotted: 450
- Location 1: Middle Earth,
- Location 2: Scotland
- Interests: All things aquatic, Sci-Fi, photography and travel. Oh, and beer.
- Contact:
Re: Only List Active Aquaria when Adding to My Cats
Uploaded. Fixed?MatsP wrote:Fixed in R548.
--
Mats
Jools
Owner, AquaticRepublic.com, PlanetCatfish.com & ZebraPleco.com. Please consider donating towards this site's running costs.
- Martin S
- Posts: 2100
- Joined: 26 Mar 2003, 11:14
- I've donated: $20.00!
- My images: 9
- My cats species list: 90 (i:19, k:0)
- My aquaria list: 11 (i:3)
- Spotted: 17
- Location 1: Guildford, Surrey
- Location 2: UK
- Interests: Aquatics
Re: Only List Active Aquaria when Adding to My Cats
Looks good to me - thanks
Sorry, can't test it via tapatalk and don't turn on the PC much when not at work ;)
Thanks again
Martin

Sorry, can't test it via tapatalk and don't turn on the PC much when not at work ;)
Thanks again
Martin