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. _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
