Printable Version | Subscribe | Add to Favourites
New Topic New Poll New Reply
Author: Subject: Anyone know anything about converting JPG to Long Binary data within a dataset?
tegwin

posted on 7/1/09 at 02:43 PM Reply With Quote
Anyone know anything about converting JPG to Long Binary data within a dataset?

I need to "import" some JPG files into an access/ MSDB file in Long Binary format...

Anyone know any way of doing it





------------------------------------------------------------------------------------------------------------------------
Would the last person who leaves the country please switch off the lights and close the door!

www.verticalhorizonsmedia.tv

View User's Profile Visit User's Homepage View All Posts By User U2U Member
Mr Whippy

posted on 7/1/09 at 02:52 PM Reply With Quote
any use?

linky






View User's Profile E-Mail User Visit User's Homepage View All Posts By User U2U Member
vinny1275

posted on 7/1/09 at 02:53 PM Reply With Quote
What language are you using? There must be a library for doing that already- try sourceforge.net if there isn't one built into the language / app you're using - I tend to search it with google though, as its own search doesn't always work well.....

HTH


vince






View User's Profile View All Posts By User U2U Member
tegwin

posted on 7/1/09 at 03:35 PM Reply With Quote
quote:

What language are you using?



English!!


All joking asside... The data sits in an MSSql database... the images are stored in that database as a link to a physical file..



I have exported from that database a CSV file which contains the usernames and links to their respective photo...

I now need to import that CSV into a piece of software... however it wont accept the links to the file directly it will only accept the images in long binary frmat...

So I dont mind what language I use I just need to change the "photo" field from a file location string to a true long binary...

Make sence... Im confused!





------------------------------------------------------------------------------------------------------------------------
Would the last person who leaves the country please switch off the lights and close the door!

www.verticalhorizonsmedia.tv

View User's Profile Visit User's Homepage View All Posts By User U2U Member
BenB

posted on 7/1/09 at 03:35 PM Reply With Quote
Looks tricky to me

http://databases.aspfaq.com/database/should-i-store-images-in-the-database-or-the-filesystem.html

View User's Profile Visit User's Homepage View All Posts By User U2U Member
mads

posted on 7/1/09 at 05:39 PM Reply With Quote
and i thought i had it difficult with some css drop-down menu code!!

got no advice but good luck!





We gain knowledge faster than we do wisdom!

Life is not a journey to the grave with the intention of arriving safely in a pretty and well-preserved body, but rather to skid in sideways, thoroughly used, totally worn out and loudly proclaiming... "f*ck, what a trip!"

View User's Profile Visit User's Homepage View All Posts By User U2U Member
tegwin

posted on 7/1/09 at 07:18 PM Reply With Quote
hmm..fudge

[Edited on 7/1/09 by tegwin]





------------------------------------------------------------------------------------------------------------------------
Would the last person who leaves the country please switch off the lights and close the door!

www.verticalhorizonsmedia.tv

View User's Profile Visit User's Homepage View All Posts By User U2U Member

New Topic New Poll New Reply


go to top






Website design and SEO by Studio Montage

All content © 2001-16 LocostBuilders. Reproduction prohibited
Opinions expressed in public posts are those of the author and do not necessarily represent
the views of other users or any member of the LocostBuilders team.
Running XMB 1.8 Partagium [© 2002 XMB Group] on Apache under CentOS Linux
Founded, built and operated by ChrisW.