Results 1 to 2 of 2

Thread: BLOB Size

  1. #1
    Lou Simon Guest

    Default BLOB Size

    I'm trying to display information and a pic on my page that are both pulling out of a DB, the pic is a BLOB in an MSSQL DB. Some of the entries in the DB do not have pictures. I need to find a way to find the BLOB size so that if there is nothing in the "Binary" field in SQL then I can display a default value. Can anyone help, I've been searching and cannot find an answer exept that there is one.

  2. #2
    Join Date
    Dec 1969

    Default RE: BLOB Size

    Couple of questions, <BR>1.) if there is no pic, then why do you have a record in the table at all<BR>2.) its best to have a column called size in the table, which can be queried<BR>3.) there is a function called lenb() - you may want to try this<BR>cheers...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts