'state' drop down select in registry missing 'WY'
 

a) am I blind?
b) am I an idiot? I thought the abbrev for Wyoming was WY, but when I force it in the URI, I get no results... ( https://www.scionlife.com/registry/?state=wy )

I guess I am kinda curious how the values for county (especially county!), city and state are arrived at, since the field in profile called 'physical location' is a free-form text field. I suppose the lookup is a text-compare query like so?

select *
from profile
where location like '% CA%' or location like '%cali%'

ad infinitum, right? well, my point being that if that is the case, then I am REALLY stumped as to why there are no results.

Thanks D

and I guess I should have mentioned that I _am_ aware that there are only 37 people IN wyoming, and only 1 drives a scion... but ya know...

It's simple. No Scion owners in Wyoming have registered their Scion. The option to view a state only appears if there is data in the database to view.

Cuunty, city and state are entered seperately into the registry, not from the profile entry box.

Hope that helps!

that's pretty funy. Hey D, got my schwag in the mail today! thanks a ton!

lock.

county :wink: sorry for the nitpick