How to link my pictures-db to my internet page *762008

[J.Alladien]

Dear All,

I have a product-database with relevant product-info including linked Pics
and I would like to know if it,s possible to put all that info INCLUDING the
PICTURES on my internetpage via a link ,so that the information does not have
to be updated all the time because its linked and changes made in the DB
automatically get updated on the website!

Thanks in advance!

 

[a a r o n . k e m p f]

keep your data in SQL Server and it would work like this.

For 9 out of the past 10 years, Microsoft has insisted that nobody
should ever use jet for a webpage, not for any reason. NEVER.

 

[BruceM]

I can't address your question, but a good starting point is to ignore Aaron.
He has one answer to every question, but provides little useful information
about how to implement that answer on the occasions when it happens to be
arguably valid.

 

[J.Alladien]

Dear Bruce,

I already know about AAron, but thanks for the heads up anyway;

To the community , isnt there a way we can ban or close him out, because its
very irritating this way!

I would appreciate some info from others as well cc my question ,thnks in
advance!

 

[Tom van Stiphout]

Most if not all software used to build webpages cannot deal with
images stored in an Access database. That's one of the reasons people
have said for years not to do this, and store the images in the file
system. Once they are there, it's a simple <img> tag to reference an
image.

-Tom.

 

[J.Alladien]

Dear Tom,

Your name seems dutch, do you speak dutch?I do

Can you explain how I need to store my pics then, I didnt exactly understand
what you meant!

 

[a a r o n . k e m p f]

he meant to say 'if Access is too bloated to store BLOBS then move to
SQL Server'

 

[Fred]

This is correct about the pictures, but that doesn't solve the core issue of
making the Access data available. Even the pictures need to be selected by
Access as being the ones relevant to that record.

This question has been asked several times wiht no positive responses.
My theory is that Aaron is just a one line program that answers all Access
questions with "don't use Access, use SQL Server". Even a broken clock is
right twice per day, and this may be one of those moments.

Fred

 

[BruceM]

Even if Aaron is right, the question remains unanswered. "Use SQL Server",
even if it is a correct answer, leaves unanswered all questions about how to
use it, and is therefore of no real value.
By the way, the response about using the <img> tag is positive even if a bit
short on details.

 

[Fred]

Bruce,

Of course you're right.

I didn't mean that your answer wasn't positive, I was thinking that, per the
details in my post, that it was not exactly relevant to the core question.

Fred

 

[So Sorry For Poor Aaron]

For 9 out of the past 10 years, Microsoft has
insisted that nobody should ever use jet for a
webpage, not for any reason. NEVER.

Microsoft has never "insisted" any such thing, not for 9 out of the past 10,
not last year, not this year, not ever. Jet databases are supported by Front
Page, by ActiveX Server pages (.asp) using ADO or DAO, by ASP.NET using
ADO.NET, and by both VB.NET and C#, also using ADO.NET.

Does that sound like what aaron the bonehead claimed? The only question is
this: is aaron just too stupid to know what he's talking about, or is he
deliberately lying, or both? I think I vote for "both".

 

[So Sorry For Poor Aaron]

he meant to say 'if Access is too bloated to store
BLOBS then move to SQL Server'

No, he did not. Unlike aaron the rockhead, Mr. van S. is a very intelligent
and well-informed professional. If he had meant to say that, he would have
said that. As he did not, then that is not what he meant.

aaron, you rockheaded dumbbutt, you mislead people enough on your own; you
shouldn't be interpreting what your betters "meant to say" to try to mislead
people even more.

"Keeping the rockheaded dumbbutt honest can be a full day's work."

 

[a a r o n . k e m p f]

you don't need to worry about bloat if you use a REAL MANS DATABASE

keep your images in SQL Server; and things just work

 

[Tom van Stiphout]

On Mon, 7 Jul 2008 07:22:03 -0700, J.Alladien

I do speak Dutch but since this is an English forum I prefer to use
that language.
What I meant to say is that rather than storing images in an OLE field
in the database, you would store the path (better: relative path) to
the images in a text field.
Then in your web application you can use an image tag, set the src
attribute that path, and voila, the image will display. The exact
details depend on which web programming language you're using and is
beyond the scope of this newsgroup.

-Tom.

 

[a a r o n . k e m p f]

DAO is not reccomended, nor is jet-- for a webpage -- for _ANY_
reason.

it's been plastered in about 20 different places for the first decade.

Anyone that is using JET for WEBPAGES should be fired and then spit
upon.
Why would you design with a tool that is explicitly modeled for ZERO
DOWNTIME and then use a database engine that can't stay up for an HOUR
without corruption?

Jet fucking sucks
anyone that defends it is a fucking retard.

So sorry that you dipshit stalkers got some stupid lying cop to beat
me up over it.
Just because you lie.
Just because cops lie.

**** THAT.

Eat shit fag. Anyone using JET for any reason should be fired and
then spit upon.

-Aaron

 

[a a r o n . k e m p f]

anyone using JET for any reason is sooooo stupid that they should be
stuck making $12/hour.

JET is a dead end database.
It doesn't support SMP or MultiCore, 80% of the networks IN THE REAL
WORLD

X64
Stored Procedures
Code Reuse
Indexes
Multiple Users

any dipshit building single-user solutions and then putting a label on
them 'oh, it's a linked backend'

I mean HOW FUCKING STUPID YOU AIN'T CLIENT SERVER

Your shit doesn't work over ANY network

Stick a fork in it dipshit, stalker... asshole

 

[J.Alladien]

Dear Tom,

The Dutch thing was just out of curiosity ,wasn,t my intention to
communicate in dutch,

As I am not very experienced in access I just want to make sure I understand
you,so with yr explanation the format of my products table should look like
F.E.:

ProdID Prodname Photo-Location(text field)
1012 apple C:\My pics\pic1012.jpg
1013 pears C:\My pics\pic1013.jpg

Is this right?
Appreciate your help!
Thanks

 

[a a r o n . k e m p f]

bull mother fucking shit

I hope that translates ok.

Maybe-- instead of hopping through all these hoops-- just because JET
is bloated-- maybe you should just use SQL Server!

SQL Server supports a handful of ways to store images; for small
files; I'd reccomend the VarBinary datatypes