This is a forum where members new and old can come to ask questions and get info and opinions. It is not a place to advertise your business or have other forms of advertising, whether it be in your posts or signature.

All links in the forum will not be indexed by Search Engines and any unapproved forms of advertising or spam will be dealt with accordingly, deleted, and that member's account banned.

Forums

Overview » Dreamweaver » Uploading images

Uploading images
M. Stan Member Since: 15 Apr 2002 Posts: 38	Posted 29 May 2002 20:43:41 <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'> <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'>

Uploading images

M. Stan
Member

Since: 15 Apr 2002
Posts: 38

Posted 29 May 2002 20:43:41

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

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

Viktor Farcic Zone Manager Since: 03 Apr 2001 Posts: 607	Replied 30 May 2002 09:12:28 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

M. Stan Member Since: 15 Apr 2002 Posts: 38	Replied 30 May 2002 19:43:11 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.

Viktor Farcic Zone Manager Since: 03 Apr 2001 Posts: 607	Replied 31 May 2002 09:26:35 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

M. Stan Member Since: 15 Apr 2002 Posts: 38	Replied 31 May 2002 15:06:30 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.

Ramesh Reddy Member Since: 03 Nov 2007 Posts: 1	Replied 03 Nov 2007 05:21:13 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>