Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jl2
Starting Member
2 Posts |
 Posted - 2009-01-20 : 11:30:51
|
| G-Day allI'm not sure this is the exact forum for this, but maybe someone here has done this before. I need some very plain ASP (not .NET) to upload an image file to and SQL 2000 server. What I have is three fields - pnID, pnPartNumber, pnImage. I want to create a link on a page I have that would take you to page that you could upload or replace an image for a particular pnID. |
|
|
uberman
Posting Yak Master
159 Posts |
Posted - 2009-01-21 : 06:16:21
|
| Your best bet will (probably) be to upload the file (you can do this natively in ASP code but we use SoftArtisans products (SAFILEUP) for this) and then store the image on the file system, you CAN store it in the db, but in nearly every case storing on the file system is much easier, and use the ID of the item as the image name so you can find it easily.Optionally, you may need to process the image (thumbnails, resizing etc.), we use ImageGlue for this, but there are other apps out there you can use.In all cases, google is your friend for examples (If you use the SoftArtisans stuff the documentation comes with examples) on how do it; you should be able to put together a cut n paste page from google searches for something like this relatively easily... |
 |
|
|
|
|
|
ASP to SQL 2000 image file upload