Storing documents MSSQL IMAGE datatype

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default Storing documents MSSQL IMAGE datatype

    I am trying to store various kinds of documents in an IMAGE datatype in MS SQL
    Server 2000 using CFMX 7 and having no luck.

    I have googled the subject but only found some CFX tags to allow me to
    accomplish this. I would really like to be able to do this w/o using CFX tags.

    The basic procss now is a form to upload a file then CFFILE readBinary,
    convert to base64, and insert. I get a SQL syntax error both when i use ' '
    and w/o. I am converting to Base64 because when i didn't i got an error
    telling me to.

    Any ideas?

    Thanks.

    Kaptain_Krayola Guest

  2. Similar Questions and Discussions

    1. storing image hight and width
      Hi there, I tried this in the DevloperToolbox forum but no reply... How is it possible to capture and store the height and width values of an...
    2. Storing and retrieving image files in a database
      hi JerkyRobot I can see no one answered your question. here is the answer. a few things you will have to do before this will work. 1) you need to...
    3. PHP Storing compressed data in mssql image field
      Hello all, I am trying to store a large string representing a RTF document through PHP in a MS SQL Server database. To gain diskspace i want to...
    4. How can i put the image file to the db ? (mssql)
      Hi, i have a little problem. i hope u guys give me a clear solution (: db: mssql i just want to put jpeg file to the image field at the...
    5. SQL Server query with Image datatype
      Hi Folks Can anyone please tell me how I can safely run an SQL query on SQL 2000 via a Perl which includes a field of Image datatype which holds...
  3. #2

    Default Re: Storing documents MSSQL IMAGE datatype

    see if [url]http://www.macromedia.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=1025860[/url] thread has anything useful.
    PaulH Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139