Forums
This topic is locked
SQL Image DATA type on ASP
Posted 03 Apr 2006 10:00:38
1
has voted
03 Apr 2006 10:00:38 Ahmed Fazeel posted:
SQL Image data type is in binary format. How do we get that on an ASP webpage. I've tried a lot non seem to work. It displays some odd charecters...Help..
tanks
Replies
Replied 03 Apr 2006 20:04:20
03 Apr 2006 20:04:20 micah santos replied:
visit this site:
www.stardeveloper.com/articles/display.html?article=2001040401&page=1
you'll learn a lot from it.
Micah Santos
n.1asphost.com/micahsantos
www.stardeveloper.com/articles/display.html?article=2001040401&page=1
you'll learn a lot from it.
Micah Santos
n.1asphost.com/micahsantos
Replied 05 Apr 2006 08:35:25
05 Apr 2006 08:35:25 allan khalil replied:
Hi Ahmed,
First thing you should check is what db drive you have...
If it is OLEDB then you need a asp script that recodes the binary into an image... You would soon enough after heaps of research find that IIS doesnt look to kindly towards binary images, so unless nessesary dont use it. I could provide you with a upload script i have recently created which extracts the image name and places in the given field in the db.
Let me know how you go...
Regs
Al
First thing you should check is what db drive you have...
If it is OLEDB then you need a asp script that recodes the binary into an image... You would soon enough after heaps of research find that IIS doesnt look to kindly towards binary images, so unless nessesary dont use it. I could provide you with a upload script i have recently created which extracts the image name and places in the given field in the db.
Let me know how you go...
Regs
Al