database connect/query id's

[mfstuart]

Hi Robert,

What version of RunRev Studio do you have? This was saved in version 2.7.2.
If you have an earlier version, let me know and I'll save it in the "Legacy
Revolution Stack" format.

Also, you'll need to have the MySQL database already created:
Database name: States
Table name:  States

Table Definition:
Column 1 name: State (char 2), (Allow Null=No)
Column 2 name: State_Name (char 35), (Allow Null=Yes)

Indexes:
Indx 1: State (Unique)
Indx 2: State_Name (Normal)

Here's the states exported...
State	State_Name
AL	Alabama
AK	Alaska
AZ	Arizona
AR	Arkansas
CA	California
CO	Colorado
CT	Connecticut
DE	Delaware
DC	District of Coulmbia
FL	Florida
GA	Georgia
HI	Hawaii
ID	Idaho
IL	Illinois
IN	Indiana
IA	Iowa
KS	Kansas
KY	Kentucky
LA	Louisiana
ME	Maine
MD	Maryland
MA	Massachusetts
MI	Michigan
MN	Minnesota
MS	Mississippi
MO	Missouri
MT	Montana
NE	Nebraska
NV	Nevada
NH	New Hampshire
NJ	New Jersey
NM	New Mexico
NY	New York
NC	North Carolina
ND	North Dakota
OH	Ohio
OK	Oklahoma
OR	Oregon
PA	Pennsylvania
RI	Rhode Island
SC	South Carolina
SD	South Dakota
TN	Tennessee
TX	Texas
UT	Utah
VT	Vermont
VA	Virginia
WA	Washington
WV	West Virginia
WI	Wisconsin
WY	Wyoming

The delimiter is TAB.

I do not have an import script for this data.
Use MySQL to import the data, or create a script to open and read the txt
file, then read each line and INSERT to the SQL table.

Regards,
Mark
--
View this message in context: http://www.nabble.com/database-connect-query-id%27s-t1764778.html#a4823122
Sent from the Revolution - User forum at Nabble.com.