You cannot get a BLOB back in one piece. I wrote an article at www.dynamergy.com/mike/blobaccessvb.html that describes how to use the adodb.stream object to access MySQL BLOB data through VB.
Mike Hillyer -----Original Message----- From: Lalit Chandwani [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 10:19 AM To: [EMAIL PROTECTED] Subject: ado , blob reading problem i am using vb,ado,myodbc,mysql i have some values in longblob,mblob fields when i read it with ado , if the data is less than 1o kb then the field having the value otherwise it shows the null for ex. select image from stumaster where id=12 if the image is of <= 10 kb then it returns value otherswise shows null in fieldvalue please help __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php