Dropdown List of Countries

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   In the account setup and checkout page, there is a dropdown list of countries. Is there a quick way I can place US at the top of the list? Funny, I have performed so much major surgery on this cart, but something like this is throwing me off. Thanks in advance!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
theqc Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18-August-2009 Status: Offline Points: 0	Post Options Post Reply Quote theqc Report Post Thanks(0) Quote Reply Topic: Dropdown List of Countries Posted: 26-August-2009 at 4:55pm
	In the account setup and checkout page, there is a dropdown list of countries. Is there a quick way I can place US at the top of the list? Funny, I have performed so much major surgery on this cart, but something like this is throwing me off. Thanks in advance!

theqc Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18-August-2009 Status: Offline Points: 0	Post Options Post Reply Quote theqc Report Post Thanks(0) Quote Reply Posted: 27-August-2009 at 8:46am
	Hello. Just want to post an update that I got this working in case anybody ever needs to figure this out. All I did was create a new column in the "countries" database called "countryOrder" and gave the record "united state" a value of 1 and on the page includes/javascript/pcStateAndProvince.asp I change line 11 of the code. What I have bolded is what I added. query="SELECT CountryCode,countryName,pcSubDivisionID, countryOrder FROM countries ORDER BY countryOrder DESC, countryName ASC" Hope this can help someone out. Later

sirene Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 22-November-2009 Location: Austria Status: Offline Points: 6	Post Options Post Reply Quote sirene Report Post Thanks(0) Quote Reply Posted: 18-December-2009 at 5:30am
	Where did you get the value set to 1?

Hamish Members Profile Send Private Message Find Members Posts Add to Buddy List Admin Group Joined: 12-October-2006 Location: United Kingdom Status: Offline Points: 56	Post Options Post Reply Quote Hamish Report Post Thanks(0) Quote Reply Posted: 18-December-2009 at 6:55am
	Hi Sirene, From theqc's post I take it that he added the additional database field and set it's value direct in the DB. (Edited for typo) Edited by Hamish - 18-December-2009 at 6:56am
	Editing ProductCart Code? See WIKI Guidelines for Editing ProductCart's ASP Source Code

sirene Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 22-November-2009 Location: Austria Status: Offline Points: 6	Post Options Post Reply Quote sirene Report Post Thanks(0) Quote Reply Posted: 20-April-2010 at 4:44am
	What is written in the SQL File? CREATE TABLE [countries]( [countryName] [nvarchar](255) NULL, [countryCode] [nvarchar](255) NULL, [countryOrder] [nvarchar](255) NULL, [pcSubDivisionID] [int] NULL CONSTRAINT [DBX_pcSubDivisionID_20378] DEFAULT ((0))