'state' drop down select in registry missing 'WY'
02-26-2006, 07:01 PM
#1
Senior Member
SL Member
Scinergy
Thread Starter
Join Date: Oct 2005
Location: ScinergyCO
Posts: 6,157
'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
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
02-26-2006, 07:04 PM
#2
Senior Member
SL Member
Scinergy
Thread Starter
Join Date: Oct 2005
Location: ScinergyCO
Posts: 6,157
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...
02-27-2006, 03:29 PM
#3
Founder
SL Member
Join Date: Apr 2003
Location: scionlife.com
Posts: 4,281
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!
Cuunty, city and state are entered seperately into the registry, not from the profile entry box.
Hope that helps!
02-27-2006, 04:08 PM
#4
Senior Member
SL Member
Scinergy
Thread Starter
Join Date: Oct 2005
Location: ScinergyCO
Posts: 6,157
that's pretty funy. Hey D, got my schwag in the mail today! thanks a ton!
lock.
lock.
02-27-2006, 04:40 PM
#5
Senior Member
SL Member
Join Date: Jul 2004
Posts: 13,963
Originally Posted by scionlife
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!
Cuunty, city and state are entered seperately into the registry, not from the profile entry box.
Hope that helps!
sorry for the nitpick
Thread
Thread Starter
Forum
Replies
Last Post
carid
Exclusive Sponsored Sales
0
02-12-2015 11:54 AM