Results 1 to 11 of 11

Thread: The Future

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: The Future

    I have another question I'm just looking for some opinions on this. I created a database through sql (sql engine, access 2000 client side) now this database has Hyperlinks in it which lead to the employee's documents which on in acrobat pdf. Does anyone for see an problems that might occur wth that???

    Thanks again

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Problems with NOT storing the actual documents into the database? Here we go again...Pat, Brett, Mr. Lindman, come on out!

    Well, along with backing up your db you will have to maintain a close look at what's going on with the file system where the docs reside. Hope your sysadmin or network admin wouldn't want to mess with it.

    Of course I have a different opinion, especially if it's documents (!!!) and the database structure contains means of locating those documents other than attempting to search the text/image field itself, or if Full-Text Search is implemented...But, it looks like "people" here don't want to share my views in this respect, so...there you have it
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Hey, leave me out of it. I don't have an axe to grind on this subject.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Just answer 1 question.

    Which is less work?
    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.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Now Brett, you KNOW that's not a fair question. Some methods are easy to set up, but don't scale well. Others are a bear to design and test, but are easy to expand. The unavoidable answer to the question "What's easiest" is
    "It depends".
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Dont know how

    Quote Originally Posted by rdjabarov
    Problems with NOT storing the actual documents into the database? Here we go again...Pat, Brett, Mr. Lindman, come on out!

    Well, along with backing up your db you will have to maintain a close look at what's going on with the file system where the docs reside. Hope your sysadmin or network admin wouldn't want to mess with it.

    Of course I have a different opinion, especially if it's documents (!!!) and the database structure contains means of locating those documents other than attempting to search the text/image field itself, or if Full-Text Search is implemented...But, it looks like "people" here don't want to share my views in this respect, so...there you have it
    My only problem with this is that I wouldnt know how to place documents in sql for users to acces. I mean how would you query that. Wouldnt that put an enormous strain on the server??? And I dont know vb. I really wouldnt know how to set that up. I'm not against it its just that I wouldnt know how

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by desireemm
    I'm not against it its just that I wouldnt know how
    And that's a good thing....

    But it's worth playing with....

    Look up READTEXT, WRITETEXT, UPDATETEXT, TXTPTR and @@TEXTSIZE

    Also look up root canal in websters.....
    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.

  8. #8
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I'm not sure, but I believe ROOT CANAL is a unix command, Brett.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by Brett Kaiser
    Also look up root canal in websters.....
    ...and be sure to have your leather underwear cleaned and shined. You want to look lovely for that kind of thing you know!

    -PatP

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    axe to grind? why yes, i do, thanks for axing

    PDF documents are the spawn of the devil

    let's start a new topic with a poll -- what does PDF stand for?

    Proprietary Data Format -- because you need a plugin to open it
    Paper Doesn't Fade -- oh yes it does
    Plump Download File -- because it's so much fatter than text
    Print Da F*cker -- because there's no way you can read it on a screen
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  11. #11
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Unfortunately the gov is using it for publishing all their standards, at least for Health Care industry. I am also storing those into db, along with amendments, appendixes, errata, etc. So that when they are ready to sanction my client I can present to them the timeline of issuance along with their unreasonable expectations.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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