<font face='Verdana'><font size=2>
I'm working on making a classified ads page, where someone can fill a form and upload an image to a SQL Server database. All data gets squirted into the database fine until I get to the image. Under the image field, I get "Long Binary Data" for all entries. The image uploaded fine to the directory that I wanted, but I'm confused on how it put this data into the database.

Did it actually extract the binary data from the photo and put that into SQL? If so, how do I extract it back out of there on the classified ad? Obviously I can just use "img src". I'd like it to just leave the filename (no path) in the SQL database, because then I know exactly how to get it out of the database. Is there an option in UltraDev where I can specify what format the file is uploaded into the database in? I'm stuck in a bind here, with no vision of where to go. If you need any more info, please ask.

Any help is greatly appreciated.

Thanks,
Matt
</font id=size2></font id='Verdana'>

How are you uploading images? Via ASP Upload extension, manually created code...?

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<font face='Verdana'><font size=2>
I'm working on making a classified ads page, where someone can fill a form and upload an image to a SQL Server database. All data gets squirted into the database fine until I get to the image. Under the image field, I get "Long Binary Data" for all entries. The image uploaded fine to the directory that I wanted, but I'm confused on how it put this data into the database.

Did it actually extract the binary data from the photo and put that into SQL? If so, how do I extract it back out of there on the classified ad? Obviously I can just use "img src". I'd like it to just leave the filename (no path) in the SQL database, because then I know exactly how to get it out of the database. Is there an option in UltraDev where I can specify what format the file is uploaded into the database in? I'm stuck in a bind here, with no vision of where to go. If you need any more info, please ask.

Any help is greatly appreciated.

Thanks,
Matt
</font id=size2></font id='Verdana'>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

Using ASP Upload. I tried the ASP Upload forum, but that is no help since George is gone.

I don't understand why it's putting the binary data into the database rather than the filename. I've recreated a test page dozens of times and I still get the same effect. I could try to test with an Access database, but that won't really solve my problem since I'm using SQL Server.

I know I could use a custom script to access this binary data, but that defeats the whole reason I bought ASP Upload.

Thanks again.

Don't upload image to SQL Server DB. Upload image to the server and in db store it's file name.

Viktor Farcic

TalkZone Manager

vfarcic:

That's what I was trying to do. That's what I was saying I needed help with doing. I couldn't help that it was going in the DB rather than just the filename. But it's OK...I got it figured out now.

Matt,

Currently I am working on asp. I am trying upload the user data with an image option, I could not able to upload data and image at the same time to the access database. I saw your message you got a solution for this kind of problem.

Could you please help regarding this, if you can send me a sample code or give me an idea, that wil great help.

Regards,

Ramesh






<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<font face='Verdana'><font size=2>
I'm working on making a classified ads page, where someone can fill a form and upload an image to a SQL Server database. All data gets squirted into the database fine until I get to the image. Under the image field, I get "Long Binary Data" for all entries. The image uploaded fine to the directory that I wanted, but I'm confused on how it put this data into the database.

Did it actually extract the binary data from the photo and put that into SQL? If so, how do I extract it back out of there on the classified ad? Obviously I can just use "img src". I'd like it to just leave the filename (no path) in the SQL database, because then I know exactly how to get it out of the database. Is there an option in UltraDev where I can specify what format the file is uploaded into the database in? I'm stuck in a bind here, with no vision of where to go. If you need any more info, please ask.

Any help is greatly appreciated.

Thanks,
Matt
</font id=size2></font id='Verdana'>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote><font size=4></font id=size4>