Announcement

Collapse
No announcement yet.

BLOBs

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • BLOBs

    Hi,

    Good day!

    How would I increase the max allowed packet size in mysql? I've been trying to upload some pdf files.

    And just wondering, Is it possible to create a form in scriptcase in which one of the fields(read-only) is a BLOB column. Then when a user clicks that BLOB column (ex. pdf file) , it would open that particular file..

    Thanks in advance..




  • #2
    Re: BLOBs

    Hello Ishey,

    You can put a blob field on your form. Use the Scriptcase data type "Database (document)".

    Works very nice.

    Regards,
    Martin
    'Man is a Tool Making Animal' ("Benjamin Franklin&quot

    Comment


    • #3
      Re: BLOBs

      In answer to your package size question. You can modify your mysql my.cnf :

      key_buffer = 16M
      max_allowed_packet = 16M

      Modify to maximum wanted blob size.

      After that restart mysql service (on Linux):
      /etc/init.d/mysql restart
      'Man is a Tool Making Animal' ("Benjamin Franklin&quot

      Comment


      • #4
        Re: BLOBs

        Hi mr2fit,

        Thanks for replying, I really appreciate it..

        I'm using XAMPP webserver, and now I'm trying to set the key_buffer and max_allowed_packet using command line since I can't find the my.cnf..,

        I've tried this:

        mysql> set max_allowed_packet = 32000000;
        Query Ok, O rows affected...


        but then y it does not affect any changes... And I can't find the my.cnf (xampp)


        Thanks..
        ishey

        Comment


        • #5
          Re: BLOBs

          The my.cnf file is located in the mysqlin directory on xampp.
          It may just show "my" as the name because Windows treats the .cnf as a very special file extension.

          Try renaming it and opening it up in notepad.

          This of course assumes you are using Windows version xampp.

          Alan

          Comment

          Working...
          X