https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 19:35:12 +0000 Tue, 20 Apr 2010 04:44:07 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=2983 https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ https://forum.productcart.com/dropdown-list-of-countries_topic2983_post14046.html#14046 Author: sirene
Subject: 2983
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))]]> Tue, 20 Apr 2010 04:44:07 +0000 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post14046.html#14046 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post12404.html#12404 Author: Hamish
Subject: 2983
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]]> Fri, 18 Dec 2009 06:55:47 +0000 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post12404.html#12404 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post12403.html#12403 Author: sirene
Subject: 2983
Posted: 18-December-2009 at 5:30am

Where did you get the value set to 1?]]> Fri, 18 Dec 2009 05:30:32 +0000 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post12403.html#12403 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post11163.html#11163 Author: theqc
Subject: 2983
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

]]> Thu, 27 Aug 2009 08:46:53 +0000 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post11163.html#11163 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post11156.html#11156 Author: theqc
Subject: 2983
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!]]> Wed, 26 Aug 2009 16:55:32 +0000 https://forum.productcart.com/dropdown-list-of-countries_topic2983_post11156.html#11156