Results 1 to 9 of 9

Thread: Images

  1. #1
    Join Date
    Jan 2004
    Posts
    30

    Unanswered: Images

    I want to create a catalogue such thing with stores items in a shop, some with pictures. How do I store images in sql server 2000???

    Thank You

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Painfully...just store the path to the image...

    Look up READTEXT, WRITETEXT in bol if your still interested....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    sort the threads on this forum .. its the tenth largest thread..
    but please read it completely to get the idea to store images in SQL server
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  4. #4
    Join Date
    Jan 2004
    Posts
    30

    Unhappy sort the images

    how do you sort the threads????

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Click on the word reply....

    http://www.dbforums.com/t203835.html
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  6. #6
    Join Date
    Jan 2004
    Posts
    30

    link for forum on storing images

    are u sure u gav me the correct link....

  7. #7
    Join Date
    Mar 2004
    Location
    NC
    Posts
    13

    Re: Images

    Originally posted by asbirpam
    I want to create a catalogue such thing with stores items in a shop, some with pictures. How do I store images in sql server 2000???

    Thank You
    You can create a field in your table with the type of image. you can then save the image in the table.

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Check the thread http://www.dbforums.com/t203835.html referred by Brett which is updated.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  9. #9
    Join Date
    Mar 2004
    Location
    Germany
    Posts
    11
    http://www.microsoft.com/resources/d...rt3/c1161.mspx is a really comprehensive article on that topic

Posting Permissions

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