you won't get a large blob back in one piece. to retrieve blobs, you need to use the getchunk method.
refer to getchunk in the vb documentation. it also has an excellent example. > 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 > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.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
