Post reply

Help on web multiple web forms.

  • January 17, 2004 at 11:48 am

    #106733

    CREATE TABLE Lookup_User_Title (

    [TitleID] varchar(10) primary key,

    [TitleText] varchar (10) not null

    )

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Mr.','Mr.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Ms.','Ms.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Miss.','Miss.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Mrs.','Mrs.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Dr.','Dr.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('M.','M.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Mme.','Mme.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Mlle.','Mlle.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Prof.','Prof.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Rev.','Rev.')

    GO

    INSERT INTO Lookup_User_Title(TitleID,TitleText) VALUES('Other','Other')

    GO

    ----------------------------------------------- 2

    CREATE TABLE [Lookup_User_Gender] (

    [GenderID] integer identity primary key,

    [GenderText] varchar (50)

    )

    GO

    INSERT Lookup_User_Gender(GenderText) VALUES('Male')

    INSERT Lookup_User_Gender(GenderText) VALUES('Female')

    GO

    ----------------------------------------------- 3

    CREATE TABLE Lookup_User_SecretWordType (

    [SecretWordTypeID] varchar(50) primary key,

    [SecretWordTypeText] varchar (50) not null

    )

    GO

    INSERT INTO Lookup_User_SecretWordType(SecretWordTypeID,SecretWordTypeText) VALUES('What street did I grow up on?','What street did I grow up on?')

    GO

    INSERT INTO Lookup_User_SecretWordType(SecretWordTypeID,SecretWordTypeText) VALUES('What is the name of the high school I attended?','What is the name of the high school I attended?')

    GO

    INSERT INTO Lookup_User_SecretWordType(SecretWordTypeID,SecretWordTypeText) VALUES('What is my favorite type of music?','What is my favorite type of music?')

    GO

    INSERT INTO Lookup_User_SecretWordType(SecretWordTypeID,SecretWordTypeText) VALUES('What is my pet''s name?','What is my pet''s name?')

    GO

    ----------------------------------------------- 4

    CREATE TABLE Lookup_User_StateProvince (

    [StateProvinceID] integer identity primary key,

    [StateProvinceText] varchar (50)

    )

    GO

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Not Applicable')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Alabama')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Alaska')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Army Post Office')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Arizona')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Arkansas')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('California')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('District of Columbia')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Delaware')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Florida')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Fleet Post Office')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Georgia')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Guam')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Hawaii')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Idaho')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Illinois')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Indiana')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Iowa')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Kansas')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Kentucky')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Louisiana')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Maine')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Maryland')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Massachusetts')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Michigan')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Minnesota')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Mississippi')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Missouri')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Montana')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Nebraska')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Nevada')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('New Hampshire')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('New Jersey')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('New Mexico')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('New York')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('North Carolina')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('North Dakota')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Ohio')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Oklahoma')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Oregon')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Pennsylvania')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Puerto Rico')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Rhode Island')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('South Carolina')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('South Dakota')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Tennessee')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Texas')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Utah')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Vermont')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('West Virginia')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Wisconsin')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Wyoming')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('British Columbia')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Manitoba')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('New Brunswick')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Newfoundland')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Northwest Territories')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Nova Scotia')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Nunavut')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Ontario')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Prince Edward Island')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Quebec')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Saskatchewan')

    INSERT Lookup_User_StateProvince(StateProvinceText) VALUES('Yukon')

    GO

    ----------------------------------------------- 5

    CREATE TABLE Lookup_User_Country (

    [CountryID] integer identity primary key,

    [CountryText] varchar (50)

    )

    GO

    INSERT Lookup_User_Country(CountryText) VALUES('Not Applicable')

    INSERT Lookup_User_Country(CountryText) VALUES('Canada')

    INSERT Lookup_User_Country(CountryText) VALUES('Afghanistan')

    INSERT Lookup_User_Country(CountryText) VALUES('Albania')

    INSERT Lookup_User_Country(CountryText) VALUES('Algeria')

    INSERT Lookup_User_Country(CountryText) VALUES('American Samoa')

    INSERT Lookup_User_Country(CountryText) VALUES('Andorra')

    INSERT Lookup_User_Country(CountryText) VALUES('Angola')

    INSERT Lookup_User_Country(CountryText) VALUES('Angola')

    INSERT Lookup_User_Country(CountryText) VALUES('Anguilla')

    INSERT Lookup_User_Country(CountryText) VALUES('Antarctica')

    INSERT Lookup_User_Country(CountryText) VALUES('Antigua and Barbuda')

    INSERT Lookup_User_Country(CountryText) VALUES('Argentina')

    INSERT Lookup_User_Country(CountryText) VALUES('Armenia')

    INSERT Lookup_User_Country(CountryText) VALUES('Aruba')

    INSERT Lookup_User_Country(CountryText) VALUES('Australia')

    INSERT Lookup_User_Country(CountryText) VALUES('Austria')

    INSERT Lookup_User_Country(CountryText) VALUES('Azerbaijan')

    INSERT Lookup_User_Country(CountryText) VALUES('Bahrain')

    INSERT Lookup_User_Country(CountryText) VALUES('Bangladesh')

    INSERT Lookup_User_Country(CountryText) VALUES('Barbados')

    INSERT Lookup_User_Country(CountryText) VALUES('Belarus')

    INSERT Lookup_User_Country(CountryText) VALUES('Belgium')

    INSERT Lookup_User_Country(CountryText) VALUES('Belize')

    INSERT Lookup_User_Country(CountryText) VALUES('Benin')

    INSERT Lookup_User_Country(CountryText) VALUES('Bermuda')

    INSERT Lookup_User_Country(CountryText) VALUES('Bhutan')

    INSERT Lookup_User_Country(CountryText) VALUES('Bolivia')

    INSERT Lookup_User_Country(CountryText) VALUES('Bosnia and Herzegovina')

    INSERT Lookup_User_Country(CountryText) VALUES('Botswana')

    INSERT Lookup_User_Country(CountryText) VALUES('Bouvet Island')

    INSERT Lookup_User_Country(CountryText) VALUES('Brazil')

    INSERT Lookup_User_Country(CountryText) VALUES('British Indian Ocean Territory')

    INSERT Lookup_User_Country(CountryText) VALUES('Brunei Darussalam')

    INSERT Lookup_User_Country(CountryText) VALUES('Burkina Faso')

    INSERT Lookup_User_Country(CountryText) VALUES('Burundi')

    INSERT Lookup_User_Country(CountryText) VALUES('Cambodia')

    INSERT Lookup_User_Country(CountryText) VALUES('Cameroon')

    INSERT Lookup_User_Country(CountryText) VALUES('Cape Verde')

    INSERT Lookup_User_Country(CountryText) VALUES('Cayman Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Central African Republic')

    INSERT Lookup_User_Country(CountryText) VALUES('Chad')

    INSERT Lookup_User_Country(CountryText) VALUES('China')

    INSERT Lookup_User_Country(CountryText) VALUES('Christmas Island')

    INSERT Lookup_User_Country(CountryText) VALUES('Cocos (Keeling Islands)')

    INSERT Lookup_User_Country(CountryText) VALUES('Colombia')

    INSERT Lookup_User_Country(CountryText) VALUES('Comoros')

    INSERT Lookup_User_Country(CountryText) VALUES('Congo')

    INSERT Lookup_User_Country(CountryText) VALUES('Cook Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Costa Rica')

    INSERT Lookup_User_Country(CountryText) VALUES('Cote D''Ivoire (Ivory Coast)')

    INSERT Lookup_User_Country(CountryText) VALUES('Croatia (Hrvatska)')

    INSERT Lookup_User_Country(CountryText) VALUES('Cuba')

    INSERT Lookup_User_Country(CountryText) VALUES('Cyprus')

    INSERT Lookup_User_Country(CountryText) VALUES('Czech Republic')

    INSERT Lookup_User_Country(CountryText) VALUES('Denmark')

    INSERT Lookup_User_Country(CountryText) VALUES('Djibouti')

    INSERT Lookup_User_Country(CountryText) VALUES('Dominican Republic')

    INSERT Lookup_User_Country(CountryText) VALUES('Dominica')

    INSERT Lookup_User_Country(CountryText) VALUES('East Timor')

    INSERT Lookup_User_Country(CountryText) VALUES('Ecuador')

    INSERT Lookup_User_Country(CountryText) VALUES('Egypt')

    INSERT Lookup_User_Country(CountryText) VALUES('El Salvador')

    INSERT Lookup_User_Country(CountryText) VALUES('Equatorial Guinea')

    INSERT Lookup_User_Country(CountryText) VALUES('Eritrea')

    INSERT Lookup_User_Country(CountryText) VALUES('Estonia')

    INSERT Lookup_User_Country(CountryText) VALUES('Ethiopia')

    INSERT Lookup_User_Country(CountryText) VALUES('Falkland Islands (Malvinas)')

    INSERT Lookup_User_Country(CountryText) VALUES('Faroe Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Fiji')

    INSERT Lookup_User_Country(CountryText) VALUES('Finland')

    INSERT Lookup_User_Country(CountryText) VALUES('France, Metropolitan')

    INSERT Lookup_User_Country(CountryText) VALUES('France')

    INSERT Lookup_User_Country(CountryText) VALUES('French Guiana')

    INSERT Lookup_User_Country(CountryText) VALUES('French Polynesia')

    INSERT Lookup_User_Country(CountryText) VALUES('French Southern Territories')

    INSERT Lookup_User_Country(CountryText) VALUES('Gabon')

    INSERT Lookup_User_Country(CountryText) VALUES('Gambia')

    INSERT Lookup_User_Country(CountryText) VALUES('Georgia')

    INSERT Lookup_User_Country(CountryText) VALUES('Germany')

    INSERT Lookup_User_Country(CountryText) VALUES('Ghana')

    INSERT Lookup_User_Country(CountryText) VALUES('Gibraltar')

    INSERT Lookup_User_Country(CountryText) VALUES('Greece')

    INSERT Lookup_User_Country(CountryText) VALUES('Greenland')

    INSERT Lookup_User_Country(CountryText) VALUES('Grenada')

    INSERT Lookup_User_Country(CountryText) VALUES('Guadeloupe')

    INSERT Lookup_User_Country(CountryText) VALUES('Guam')

    INSERT Lookup_User_Country(CountryText) VALUES('Guatemala')

    INSERT Lookup_User_Country(CountryText) VALUES('Guinea-Bissau')

    INSERT Lookup_User_Country(CountryText) VALUES('Guinea')

    INSERT Lookup_User_Country(CountryText) VALUES('Guyana')

    INSERT Lookup_User_Country(CountryText) VALUES('Haiti')

    INSERT Lookup_User_Country(CountryText) VALUES('Heard and McDonald Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Honduras')

    INSERT Lookup_User_Country(CountryText) VALUES('Hong Kong')

    INSERT Lookup_User_Country(CountryText) VALUES('Hungary')

    INSERT Lookup_User_Country(CountryText) VALUES('Iceland')

    INSERT Lookup_User_Country(CountryText) VALUES('India')

    INSERT Lookup_User_Country(CountryText) VALUES('Indonesia')

    INSERT Lookup_User_Country(CountryText) VALUES('Iran')

    INSERT Lookup_User_Country(CountryText) VALUES('Iraq')

    INSERT Lookup_User_Country(CountryText) VALUES('Ireland')

    INSERT Lookup_User_Country(CountryText) VALUES('Israel')

    INSERT Lookup_User_Country(CountryText) VALUES('Italy')

    INSERT Lookup_User_Country(CountryText) VALUES('Jamaica')

    INSERT Lookup_User_Country(CountryText) VALUES('Japan')

    INSERT Lookup_User_Country(CountryText) VALUES('Jordan')

    INSERT Lookup_User_Country(CountryText) VALUES('Kazakhstan')

    INSERT Lookup_User_Country(CountryText) VALUES('Kenya')

    INSERT Lookup_User_Country(CountryText) VALUES('Kiribati')

    INSERT Lookup_User_Country(CountryText) VALUES('Korea (North)')

    INSERT Lookup_User_Country(CountryText) VALUES('Korea (South)')

    INSERT Lookup_User_Country(CountryText) VALUES('Kuwait')

    INSERT Lookup_User_Country(CountryText) VALUES('Kyrgyzstan')

    INSERT Lookup_User_Country(CountryText) VALUES('Laos')

    INSERT Lookup_User_Country(CountryText) VALUES('Latvia')

    INSERT Lookup_User_Country(CountryText) VALUES('Lebanon')

    INSERT Lookup_User_Country(CountryText) VALUES('Lesotho')

    INSERT Lookup_User_Country(CountryText) VALUES('Liberia')

    INSERT Lookup_User_Country(CountryText) VALUES('Libya')

    INSERT Lookup_User_Country(CountryText) VALUES('Liechtenstein')

    INSERT Lookup_User_Country(CountryText) VALUES('Lithuania')

    INSERT Lookup_User_Country(CountryText) VALUES('Luxembourg')

    INSERT Lookup_User_Country(CountryText) VALUES('Macau')

    INSERT Lookup_User_Country(CountryText) VALUES('Macedonia')

    INSERT Lookup_User_Country(CountryText) VALUES('Madagascar')

    INSERT Lookup_User_Country(CountryText) VALUES('Malawi')

    INSERT Lookup_User_Country(CountryText) VALUES('Malaysia')

    INSERT Lookup_User_Country(CountryText) VALUES('Maldives')

    INSERT Lookup_User_Country(CountryText) VALUES('Mali')

    INSERT Lookup_User_Country(CountryText) VALUES('Malta')

    INSERT Lookup_User_Country(CountryText) VALUES('Marshall Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Martinique')

    INSERT Lookup_User_Country(CountryText) VALUES('Mauritania')

    INSERT Lookup_User_Country(CountryText) VALUES('Mauritius')

    INSERT Lookup_User_Country(CountryText) VALUES('Mayotte')

    INSERT Lookup_User_Country(CountryText) VALUES('Mexico')

    INSERT Lookup_User_Country(CountryText) VALUES('Micronesia')

    INSERT Lookup_User_Country(CountryText) VALUES('Moldova')

    INSERT Lookup_User_Country(CountryText) VALUES('Monaco')

    INSERT Lookup_User_Country(CountryText) VALUES('Mongolia')

    INSERT Lookup_User_Country(CountryText) VALUES('Montserrat')

    INSERT Lookup_User_Country(CountryText) VALUES('Morocco')

    INSERT Lookup_User_Country(CountryText) VALUES('Mozambique')

    INSERT Lookup_User_Country(CountryText) VALUES('Myanmar')

    INSERT Lookup_User_Country(CountryText) VALUES('Namibia')

    INSERT Lookup_User_Country(CountryText) VALUES('Nauru')

    INSERT Lookup_User_Country(CountryText) VALUES('Nepal')

    INSERT Lookup_User_Country(CountryText) VALUES('Netherlands Antilles')

    INSERT Lookup_User_Country(CountryText) VALUES('Netherlands')

    INSERT Lookup_User_Country(CountryText) VALUES('New Caledonia')

    INSERT Lookup_User_Country(CountryText) VALUES('New Zealand')

    INSERT Lookup_User_Country(CountryText) VALUES('Nicaragua')

    INSERT Lookup_User_Country(CountryText) VALUES('Nigeria')

    INSERT Lookup_User_Country(CountryText) VALUES('Niger')

    INSERT Lookup_User_Country(CountryText) VALUES('Niue')

    INSERT Lookup_User_Country(CountryText) VALUES('Norfolk Island')

    INSERT Lookup_User_Country(CountryText) VALUES('Northern Mariana Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Norway')

    INSERT Lookup_User_Country(CountryText) VALUES('Oman')

    INSERT Lookup_User_Country(CountryText) VALUES('Pakistan')

    INSERT Lookup_User_Country(CountryText) VALUES('Palau')

    INSERT Lookup_User_Country(CountryText) VALUES('Panama')

    INSERT Lookup_User_Country(CountryText) VALUES('Papua New Guinea')

    INSERT Lookup_User_Country(CountryText) VALUES('Paraguay')

    INSERT Lookup_User_Country(CountryText) VALUES('Peru')

    INSERT Lookup_User_Country(CountryText) VALUES('Philippines')

    INSERT Lookup_User_Country(CountryText) VALUES('Pitcairn')

    INSERT Lookup_User_Country(CountryText) VALUES('Poland')

    INSERT Lookup_User_Country(CountryText) VALUES('Portugal')

    INSERT Lookup_User_Country(CountryText) VALUES('Puerto Rico')

    INSERT Lookup_User_Country(CountryText) VALUES('Qatar')

    INSERT Lookup_User_Country(CountryText) VALUES('Reunion')

    INSERT Lookup_User_Country(CountryText) VALUES('Russian Federation')

    INSERT Lookup_User_Country(CountryText) VALUES('Rwanda')

    INSERT Lookup_User_Country(CountryText) VALUES('S.  Georgia and S.  Sandwich Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Saint Kitts and Nevis')

    INSERT Lookup_User_Country(CountryText) VALUES('Saint Lucia')

    INSERT Lookup_User_Country(CountryText) VALUES('Saint Vincent and The Grenadines')

    INSERT Lookup_User_Country(CountryText) VALUES('Samoa')

    INSERT Lookup_User_Country(CountryText) VALUES('San Marino')

    INSERT Lookup_User_Country(CountryText) VALUES('Sao Tome and Principe')

    INSERT Lookup_User_Country(CountryText) VALUES('Saudi Arabia')

    INSERT Lookup_User_Country(CountryText) VALUES('Senegal')

    INSERT Lookup_User_Country(CountryText) VALUES('Seychelles')

    INSERT Lookup_User_Country(CountryText) VALUES('Sierra Leone')

    INSERT Lookup_User_Country(CountryText) VALUES('Singapore')

    INSERT Lookup_User_Country(CountryText) VALUES('Slovak Republic')

    INSERT Lookup_User_Country(CountryText) VALUES('Slovenia')

    INSERT Lookup_User_Country(CountryText) VALUES('Solomon Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Somalia')

    INSERT Lookup_User_Country(CountryText) VALUES('South Africa')

    INSERT Lookup_User_Country(CountryText) VALUES('Spain')

    INSERT Lookup_User_Country(CountryText) VALUES('Sri Lanka')

    INSERT Lookup_User_Country(CountryText) VALUES('St.  Helena')

    INSERT Lookup_User_Country(CountryText) VALUES('St.  Pierre and Miquelon')

    INSERT Lookup_User_Country(CountryText) VALUES('Sudan')

    INSERT Lookup_User_Country(CountryText) VALUES('Suriname')

    INSERT Lookup_User_Country(CountryText) VALUES('Svalbard and Jan Mayen Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Swaziland')

    INSERT Lookup_User_Country(CountryText) VALUES('Sweden')

    INSERT Lookup_User_Country(CountryText) VALUES('Switzerland')

    INSERT Lookup_User_Country(CountryText) VALUES('Syria')

    INSERT Lookup_User_Country(CountryText) VALUES('Taiwan')

    INSERT Lookup_User_Country(CountryText) VALUES('Tajikistan')

    INSERT Lookup_User_Country(CountryText) VALUES('Tanzania')

    INSERT Lookup_User_Country(CountryText) VALUES('Thailand')

    INSERT Lookup_User_Country(CountryText) VALUES('Togo')

    INSERT Lookup_User_Country(CountryText) VALUES('Tokelau')

    INSERT Lookup_User_Country(CountryText) VALUES('Tonga')

    INSERT Lookup_User_Country(CountryText) VALUES('Trinidad and Tobago')

    INSERT Lookup_User_Country(CountryText) VALUES('Tunisia')

    INSERT Lookup_User_Country(CountryText) VALUES('Turkey')

    INSERT Lookup_User_Country(CountryText) VALUES('Turkmenistan')

    INSERT Lookup_User_Country(CountryText) VALUES('Turks and Caicos Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Tuvalu')

    INSERT Lookup_User_Country(CountryText) VALUES('US Minor Outlying Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Uganda')

    INSERT Lookup_User_Country(CountryText) VALUES('Ukraine')

    INSERT Lookup_User_Country(CountryText) VALUES('United Arab Emirates')

    INSERT Lookup_User_Country(CountryText) VALUES('United Kingdom')

    INSERT Lookup_User_Country(CountryText) VALUES('United States of America')

    INSERT Lookup_User_Country(CountryText) VALUES('Uruguay')

    INSERT Lookup_User_Country(CountryText) VALUES('Uzbekistan')

    INSERT Lookup_User_Country(CountryText) VALUES('Vanuatu')

    INSERT Lookup_User_Country(CountryText) VALUES('Vatican City State')

    INSERT Lookup_User_Country(CountryText) VALUES('Venezuela')

    INSERT Lookup_User_Country(CountryText) VALUES('Viet Nam')

    INSERT Lookup_User_Country(CountryText) VALUES('Virgin Islands (British)')

    INSERT Lookup_User_Country(CountryText) VALUES('Virgin Islands (US)')

    INSERT Lookup_User_Country(CountryText) VALUES('Wallis and Futuna Islands')

    INSERT Lookup_User_Country(CountryText) VALUES('Western Sahara')

    INSERT Lookup_User_Country(CountryText) VALUES('Yemen')

    INSERT Lookup_User_Country(CountryText) VALUES('Yugoslavia')

    INSERT Lookup_User_Country(CountryText) VALUES('Zaire')

    INSERT Lookup_User_Country(CountryText) VALUES('Zambia')

    INSERT Lookup_User_Country(CountryText) VALUES('Zimbabwe')

    GO

    And

    create table SignupUsers

    (

    UserID int identity primary key ,

    UserName varchar(50) not null,

    PasswordHash varchar(50) not null,

    Salt varchar(10) not null,

         HeadLine varchar(50) null,

    TitleID varchar(10) not null references lookup_User_Title (TitleID),

    FirstName varchar(50) not null,

         LastName varchar(50) not null,

         Email varchar(75) not null,

    SecretWordTypeID varchar(50) not null references lookup_User_SecretWordType (SecretWordTypeID),

    SecretWord varchar(50) not null,

    Age integer not null ,

    DOB datetime not null ,

    Zodiac varchar(50) not null,

    GenderID integer null references Lookup_User_Gender (GenderID),

    City varchar(50),

    StateProvinceID integer null references Lookup_User_StateProvince (StateProvinceID),

         CountryID integer not null references Lookup_User_Country (CountryID),

         DateCreated datetime not null constraint [DF_tbl_SignupUsers_DateCreated] default (getdate()),

         LastLogin datetime not null constraint [DF_tbl_SignupUsers_LastLogin] default (getdate()) ,

    LogCount int not null constraint [DF_tbl_SignupUsers_LogCount] default (1)  

    UNIQUE (UserName)

    )

    GO

    What would be the best way to create a web form with textbox and dropdownlist for the lookup tables and what type of object should I store the information.  For example Viewstate, sql adapter.  This object must be able to be passed through multiple pages without losing its values and if the person wants to change a value on the first page of the fourth web form values are automatically updated.

  • January 20, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • January 20, 2004 at 4:14 pm

    #490919

    You've posted to the wrong forum.  Actually you've posted to the wrong site!

    For ASP/ASP.NET help (you asked about creating a web form) try the following links...

    http://www.aspfaqs.com/aspfaqs/

    http://asp.net/Forums

    http://www.4guysfromrolla.com/


    Cheers,

    Kevin

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply