Select Code to Download

Select or download this

CREATE TABLE coranto_csql (
    Coranto_newsid varchar(255) not null,
...

    PRIMARY KEY (Coranto_newsid,Coranto_newstime)
);

Select or download this

$Subs{'CorantoSQL_InsertDB'} = <<'END_SUB';
sub CorantoSQL_InsertDB {
    my $sthc = $corantosql_dbh->prepare("INSERT INTO coranto_csql
...
    $sthc->finish();
}
END_SUB

Select or download this

Coranto_Subject: Don Frye, Ken Shamrock Autograph Tours

Coranto_User: garrett
...
Coranto_Category: (default)

Coranto_CustomField_newssnippit: As part of a nationwide tour to promo
+te their fight in Japan for the Pride Fighting Championships (on pay 
+per view) on February 24th, <a href="http://www.sherdog.com/fightfind
+er/displayfighter.cfm?fighterid=4">Ken Shamrock</a> (former UFC champ
+ion and WWF Superstar) and <a href="http://www.sherdog.com/fightfinde
+r/displayfighter.cfm?fighterid=124">Don "The Predator" Frye</a> (form
+er UFC Champion) will be in Dallas, Texas tomorrow, February 6, 2002.

Select or download this

$corantosql_dbh->{LongReadLen} = 5120000;
$corantosql_dbh->{LongTruncOk} = 0;

Select or download this

$corantosql_dbh->{odbc_default_bind_type} = 0; # before creating the q
+uery...