CREATE TABLE coranto_csql (
    Coranto_newsid varchar(255) not null,
    Coranto_User ntext not null,
    Coranto_Category ntext null,
    Coranto_newstime bigint not null,
    Coranto_Subject ntext,
    Coranto_CustomField_url_link ntext,
    Coranto_CustomField_newssnippit ntext,
    Coranto_Text ntext,

    PRIMARY KEY (Coranto_newsid,Coranto_newstime)
);

##</code><code>##

$Subs{'CorantoSQL_InsertDB'} = <<'END_SUB';
sub CorantoSQL_InsertDB {
    my $sthc = $corantosql_dbh->prepare("INSERT INTO coranto_csql
    (Coranto_Subject,Coranto_User,Coranto_Text,Coranto_newsid,Coranto_newstime,
    Coranto_Category,Coranto_CustomField_newssnippit,
    Coranto_CustomField_url_link) VALUES (?,?,?,?,?,?,?,?)");

    $sthc->bind_param(1, $Subject);
    $sthc->bind_param(2, $User);
    $sthc->bind_param(3, $Text);
    $sthc->bind_param(4, $newsid);
    $sthc->bind_param(5, $newstime);
    $sthc->bind_param(6, $Category);

    $sthc->bind_param(7, $CustomField_newssnippit);
    $sthc->bind_param(8, $CustomField_url_link);

    $sthc->execute();
    $sthc->finish();
}
END_SUB


##</code><code>##

Coranto_Subject: Don Frye, Ken Shamrock Autograph Tours

Coranto_User: garrett

Coranto_Text: <b>Official Press Release</b><br><br>As part of a nationwide tour to promote their fight in Japan for the Pride Fighting Championships (on pay per view) on February 24th, Ken Shamrock (former UFC champion and WWF Superstar) and Don "The Predator" Frye (former UFC Champion) will be in Dallas, Texas tomorrow!<br><br>Be there!<br><br>Pride FC videos and DVDs will be on sale for fans and this is your chance to meet the legends and get your videos signed!<br><br>Also, special local guests are expected at each event, depending on the city. You never know which big NHB fighter may show up!<br><br>Don't miss a rare chance to meet two of the best in the sport!<br><br><ul><li>Ken Shamrock and Don Frye<br>Wednesday, February 6th at 6:30pm<br>Fry's Electronics, Dallas, Texas</li><br><li>Ken Shamrock and Don Frye<br>Thursday, February 7th at 6pm<br>Fry's Electronics, Phoenix, Arizona</li><br><li>Ken Shamrock and Don Frye<br>Friday, February 8th at 7pm<br>Tower Video on Sunset, West Hollywood, California</li>

Coranto_newsid: EpEFkEuZVljCJkETqB

Coranto_newstime: 1012896000

Coranto_Category: (default)

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

##</code><code>##

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


##</code><code>##

$corantosql_dbh->{odbc_default_bind_type} = 0; # before creating the query...