ASP, Images, Access and Uploading

[axeman420]

Hey guys I need some help here. I am trying to create somewhat of a web-based inventory management for a used car dealer. My problem is the following:

I need to be able to upload images from the users computer through the browser onto the server. In addition, I need to have the link (not the image itself) saved in an Access database (along with the rest of the information for that specific car). How would I go about this and then displaying the page? Can anyone provide any sample code that I can work off of. I am fairly new to ASP and I am not using .NET just plain old ASP.

Any suggestions or a link to a site with a tutorial on how to do it or something would seriously help.

Thanks in advance,
Axe

[axeman420]

Also, any recommendation on Books relating to ASP, Access, and SQL?

Thanks!
Axe

[txbakers]

Hi and welcome to the webmasterworld forums!

First, you will need a component such as ASPUpload to accept uploaded files to your server.

Then, you will need to learn how to write code to update/insert into a database based on a web form.

It's not difficult to do. There are good tutorials all over the web. I like the ones at "http://www.w3schools.com"

look at their tutorials on ASP and ADO (the data connection part)

Once you have some code in place, someone here can help you with it. Generally we don't like to throw solutions out, as 1) they generally aren't what you need, and without understanding what it does will cause you more grief, and 2) it doesn't help you learn how to do it.

Good luck with the project!

[axeman420]

Is there any way to do it without having to pay for a component like ASPUpload? I mean is there a free one out there. I already have the input, update, display records pages but I need to add an image field that can hold a URL in the Access database. Please let me know of any suggestions as soon as possible. In addition, I did the tutorials on www.w3schools.org already and a couple of others so I am semi-familiar with the code. Furthermore, any suggestions on good books?

Thanks in advance,
Axe

[txbakers]

TMK there are no free upload tools. Some have 30 day trials.

I'd get a book on your language of choice for ASP. I use javascript so I bought a WROX and O'Reilly book on javascript.

Both are good companies.

[Spooky]

Check out something like the free script based component at "www.lewismoten.com" ( asp scripts > upload version 3)

[streetshirts]

Here is a free upload object for use like ASPUpload.

[freeaspupload.net...]

[txbakers]

Very cool, I stand corrected.

Any benefits to using the Paid, ActiveX versions?

[Spooky]

Typically speed is the advantage of components.
There was an asp.general newsgroup discussion about it quite some time ago, and the components beat the asp based scripts hands down.
However, using adodb stream like Lewis has, speeds things up considerably. Havent seen or tried a proper comparison on that one yet.
However, if you dont have access to a component, whatcha gonna do? :-)

Lewis's script has heaps of examples, the only one I think thats missing is placing the file in a folder, and the file reference in the database.
That tends to be one of the more required examples, but its very easy to do as well.
Id almost recommend it over any component due to the number of samples and supporting documentation