Embedding images stored in database

2003-01-13 Thread Toomas
Hello List, Is there a simplier way to embed an image stored in BLOB field into HTML than using 2 calls to Perl scripts - one to generate HTML and another call from that HTML via IMG tag to retrieve and print image? I mean, something like you do it in a multipart e-mail message? A more general qu

Re: Having lots of tables

2002-04-23 Thread Toomas Vendelin
F>http://www.mysql.com/manual.php (the manual) AF>http://lists.mysql.com/ (the list archive) AF> To request this thread, e-mail <[EMAIL PROTECTED]> AF> To unsubscribe, e-mail <[EMAIL PROTECTED]> AF> Trouble unsubscribing? Try:

Re: joins vs excess fields

2002-04-21 Thread Toomas Vendelin
Hello olinux, If I were in your shoes, I would put not only paths to images into a separate table, but also a field called "content" and probably title, summary, author and linked all this stuff together via ID-like fields which are primary keys in those new tables. Then articles table can be sea

Re[2]: SELECT the first letter MATCH in mySQL

2002-04-19 Thread Toomas Vendelin
Hello Paul, But RLIKE won't use indexes (even if they exist), so why RLIKE '^A' is better than LIKE 'A%', if LIKE which starts at the beginning of the string **will** use indexes? Regards, Tom PD> Regular expression patterns (unlike SQL patterns) don't need to match the PD> entire string, so R

Re[2]: SELECT the first letter MATCH in mySQL

2002-04-19 Thread Toomas Vendelin
Hello Mikael, Just add LIMIT 10 (which is equivalent to LIMIT 0,10) to show the first 10 records, and LIMIT 10,10 to show 10 records starting from 10. This issue is covered in online docs. Regards, Tom Friday, April 19, 2002, 9:18:53 AM, you wrote: MH> This brings up another question to m

Really big text - where to get?

2002-04-18 Thread Toomas Vendelin
Hello developers, When you write another MySQL-based search engine, you obviosly test it issuing queries against big amounts of data which contains more or less sane text. Tell me, where (or how) you usually get the text when you need, say, 10GB of it and, I repeat, it should be a REAL non-repeat

Re: Parentheses regexp

2002-03-10 Thread Toomas Vendelin
e manual) a>http://lists.mysql.com/ (the list archive) a> To request this thread, e-mail <[EMAIL PROTECTED]> a> To unsubscribe, e-mail <[EMAIL PROTECTED]> a> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Best regards, Too

Re[2]: How to load binary data with Perl DBI?

2002-03-09 Thread Toomas Vendelin
--- PD> Before posting, please check: PD>http://www.mysql.com/manual.php (the manual) PD>http://lists.mysql.com/ (the list archive) PD> To request this thread, e-mail <[EMAIL PROTECTED]> PD> To unsubscribe, e-mail <[EMAIL P