Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor
  • Default (No Skin)
  • No Skin
Collapse
Code Project
CODE PROJECT For Those Who Code
  • Home
  • Articles
  • FAQ
Community
  1. Home
  2. Web Development
  3. Linux, Apache, MySQL, PHP
  4. blob file (.jpg) has been inserted into database but no value, please help....

blob file (.jpg) has been inserted into database but no value, please help....

Scheduled Pinned Locked Moved Linux, Apache, MySQL, PHP
helpdatabasequestionoracle
2 Posts 1 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    alexyxj
    wrote on last edited by
    #1

    Scenario: a GUI allows to upload a .jpg and display on the page. I successfully got the data of .jpg and uploaded into Oracle, the problem is the data row of this .jpg has length=0 and couldn't display the picture. How can I check to see if the query(use to insert into database) bears the correct value before inserting? if yes, what might be the problem that oracle database doesn't have correct value? Have spent a long time but couldn't figure out the issue, please give advice..thanks..

    A 1 Reply Last reply
    0
    • A alexyxj

      Scenario: a GUI allows to upload a .jpg and display on the page. I successfully got the data of .jpg and uploaded into Oracle, the problem is the data row of this .jpg has length=0 and couldn't display the picture. How can I check to see if the query(use to insert into database) bears the correct value before inserting? if yes, what might be the problem that oracle database doesn't have correct value? Have spent a long time but couldn't figure out the issue, please give advice..thanks..

      A Offline
      A Offline
      alexyxj
      wrote on last edited by
      #2

      by the way, i used EMPTY_BLOB() as a locator..

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes

      • Login
      • Don't have an account? Register
      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups