Gossamer Forum
Home : Products : Gossamer Links : Version 1.x :

Re: What If SQL Name is different???

Quote Reply
Re: What If SQL Name is different??? In reply to
thanks, pugdog!
but how can i get this message then?
Connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (1
11) at Parse_RDF.pl line 81

line 79-89 read:
# First, Connect to the database, and prepare our insert queries that will add
# links and categories.
my $dbh_Links = DBI->connect(@dbi_Links) | | die "Connect: $DBI::errstr";
my $sth_Links = $dbh_Links->prepare("insert into Links (Title, URL, Add_Date, Mod_Date, CategoryID, Description, Contact_Name, Contact_Email, Hits, isNew, isPopular, Rating, Votes, ReceiveMail) values (?,?,'','',?,?,?,?,?,?,?,?,?,?)") | | die "Prepare: $DBI::errstr";
my $sth_Category = $dbh_Links->prepare("insert into Category (ID, Name, Description, Meta_Description, Meta_Keywords, Header, Footer, Number_of_Links, Has_New_Links) values (?,?,?,?,?,?,?,?,?)") | | die "Prepare: $DBI::errstr";
my $alt_cat = $dbh_Links->prepare("insert into CategoryAlternates (LinkID, CategoryID) VALUES (?, ?)");

my $max_id = $dbh_Links->prepare ("select ID from Category order by ID desc limit 1");
$max_id->execute();
($CATCNT) = $max_id->fetchrow_array();
$CATCNT++;


THANKS AGAIN IN ADVANCE!!
Subject Author Views Date
Thread What If SQL Name is different??? barutheela 1367 May 13, 2000, 10:15 PM
Post Re: What If SQL Name is different???
pugdog 1314 May 13, 2000, 10:25 PM
Post Re: What If SQL Name is different???
barutheela 1306 May 13, 2000, 10:37 PM
Post Re: What If SQL Name is different???
pugdog 1310 May 13, 2000, 10:43 PM
Post Re: What If SQL Name is different???
barutheela 1312 May 13, 2000, 10:45 PM