MSSQL Questions - Images and Frontpage integration

[Ryan F Bracy]

I'm currently a computer networking student, and a semester long project this year requires us to build an online store using IIS6 and MSSQL. I have run into a dead end in this project and cannot find information or documentation that answers my questions.

So as follows.

1. How do I store an image in the MSSQL database, preferably through a frontpage-created form with upload boxes?
   

   I am working with forms that I create in Frontpage (a requirement of the course) to add entries to the database. Working with just text boxes and text areas I have had much success with this, but I cannot figure out, when using upload boxes, how to direct the file uploaded to be stored in the database instead of a folder on the local machine (I have associated these upload boxes with the image and thumbnail fields on the appropriate table, with no success)

2. How do I use dropdown boxes to limit the number of selections on a backend form which inserts data into the SQL database but pulls it's selections from the SQL database instead of generating list entries myself.
   

   Currently my attempts have been to insert into the form a database results entry which pulls the data from appropriate tables, lists by name, but uses the associated numerical key to store the data, with no success)

These issues have been driving me crazy and with 4 weeks left before it's due, I'm pulling my hair out trying to figure it out.

Thanks in advance for any help you can give, if I've not been 100% clear with my explanations, please contact me and I will clarify to the best of my ability.

~Ryan F. Bracy "Angel"

[iburyak]

1. If I find my old code I will share it with you. The thing is pictures are not stored in SQL serve even thou it is possible as binary. It puts strain on a server and works terribly. What usually is done picture is stored on sharable server drive not on local machine and full path to that picture is stored in a database.

2. I need more information on table definitions and code you use.

I think I saw these questions before but you keep changing your nick and I am not sure if it is the same person.


Irina.

[iburyak]

By the way, how did you put picture next to your nick here?
I don't see how to do it.... :)

[Ryan F Bracy]

I think I saw these questions before but you keep changing your nick and I am not sure if it is the same person.
Irina.

This is my first time ever posting here.

and I will try to remember to post the code we're using presently.

Today our professor decided that we need to use all ASP to make the site, as frontpage doesn't have the capabilities to do what he wants us to do...with 3 1/2 weeks left before the project is due, and now he tells us that we have to learn ASP and code our whole site with it. When I suggested ASP from the beginning and was shot down...

[Ryan F Bracy]

By the way, how did you put picture next to your nick here?
I don't see how to do it.... :)

it's under the control panel, under edit avatar....

[iburyak]

I did find code how to convert picture into a binary stream. But I am sure if you'll see complexity of it you will change your mind to use it.... :)

Suggest your professor to FTP picture to the server and save it their as I originally suggested on server side and save full path to the picture in a database.

If you still want code I found - send me private message with your direct e-mail.
I am not going to post this code on forum.

Thank you.

P.S. Is it possible that your professor was asking the same thing on forum here? :)

[iburyak]

it's under the control panel, under edit avatar....

Thank you... :)