Re: Tweets to a database

my $sth=$dbh->prepare("INSERT INTO tweets (published, content, link) V +ALUES ('$published', '$content', '$link')");
[download]

Update: I was wrong... just ignore:

~~I think your single quotes are preventing variable interpolation. Try:~~

my $sth=$dbh->prepare("INSERT INTO tweets (published, content, link) V
+ALUES ($published, $content, $link)");
[download]

Comment on Re: Tweets to a database Select or Download Code

Replies are listed 'Best First'.
Re^2: Tweets to a database by JavaFan (Canon) on Apr 15, 2010 at 16:46 UTC
I think your single quotes are preventing variable interpolation. I think not. What makes you think that single quotes inside strings have a special meaning? The single quotes in `"INSERT INTO tweets (published, content, link) VALUES ('$published', ' +$content', '$link')"` [download] are just single quotes. They aren't any more special than the `e`'s or the commas in the string.	[reply] [d/l]
Re^2: Tweets to a database by gbotzz (Novice) on Apr 15, 2010 at 16:29 UTC
Thanks. I already tried that, I get the same error and it won't insert anything. With the single quotes it atleast puts 3 tweets in the database. I have tried TEXT and BLOB with no luck too.	[reply]