BLOB Filed - Image Store

--0-698755509-1265799504=:90197
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi, As stated http://dev.mysql.com/tech-resources/articles/vb-blob-han=
dling.html I have stored image using the following. CREATE TABLE =
files(=0Afile_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,=0Af=
ile_name VARCHAR(64) NOT NULL,=0Afile_size MEDIUMINT UNSIGNED NOT NULL,=0Af=
ile MEDIUMBLOB NOT NULL); I can store and i can retrieve the image to =
local machine as a file. I NEED TO SHOW ALL THE FIELDS IN THE CRYSTAL=
REPORT. Thank you=0AVIKRAM A =0A Your Mail works best with =
the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/inte=
rnetexplorer/
--0-698755509-1265799504=:90197--

Re: BLOB Filed - Image Store

--0050450142ca3713f7047f3e9d61
Content-Type: text/plain; charset=ISO-8859-1

You also need to NOT YELL AT PEOPLE, and GO LOOK AT THE CRYSTAL REPORTS
MANUALS.

On Wed, Feb 10, 2010 at 11:58 AM, Vikram A wrote:

> Hi,
>
> As stated
> http://dev.mysql.com/tech-resources/articles/vb-blob-handlin g.html
>
> I have stored image using the following.
>
> CREATE TABLE files(
> file_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
> file_name VARCHAR(64) NOT NULL,
> file_size MEDIUMINT UNSIGNED NOT NULL,
> file MEDIUMBLOB NOT NULL);
>
> I can store and i can retrieve the image to local machine as a file.
>
> I NEED TO SHOW ALL THE FIELDS IN THE CRYSTAL REPORT.
>
> Thank you
> VIKRAM A
>
>
> Your Mail works best with the New Yahoo Optimized IE8. Get it NOW!
> http://downloads.yahoo.com/in/internetexplorer/




--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--0050450142ca3713f7047f3e9d61--

Re: BLOB Filed - Image Store [THANKS]

--0-1472956585-1265810707=:29870
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Dear Sir, Thank you for advising me generally, how to approach/in what=
cause we need to approach! I will follow your advise very strictly he=
re after. I will try to find out solutions my self first and if not, i ll w=
rite to the experts. Thank you so much for making me to understand th=
e helping time of the experts. Sorry for wasting such experts time by =
posting simple queries. Thank you VIKRAM A ____=
____________________________=0AFrom: Johan De Meersman =
=0ATo: Vikram A =0ASent: Wed, 10 February, 2010 7:22:=
18 PM=0ASubject: Re: BLOB Filed - Image Store =0AOn Wed, Feb 10,=
2010 at 2:08 PM, Vikram A wrote: Sir, =0A>=0A>=
I am new to MY SQL, that's why i am expecting help from the experts. =0A>=
Yes, that much was clear. =0ASo far, I've seen you post questio=
ns about Visual Basic and Crystal Reports, on a MySQL mailinglist. Wat make=
s you think this is the right place ? Also, albeit slightly unrelated, do y=
ou have other masochistic tendencies ? As a rule of thumb, people are =
generally happy to help you with problems that you've researched and can't=
find the solution to. On the other hand, repeated questions that could eas=
ily have been avoided by reading the fine manual, tend to be looked upon wi=
th slightly less enthusiasm. Google is everyone's best friend, and the very=
extensive MySQL documentation is a very close second if you want to learn =
about it. You don't have to be an expert to ask questions, but you're =
more likely to get an answer if you: =091. are nice and polite, 2=
.. frame your question with sufficient detail and background so that we get =
a good idea what you're trying to do and what's going wrong, and =093.=
have done your homework before coming here.People here are voluntarily spe=
nding some of their usually sparse free time to help others. Wasting that t=
ime with questions that are either irrelevant or could have been solved wit=
h a quick google is, frankly, rather insulting. =0A-- =0ABier met gren=
adyn=0AIs als mosterd by den wyn=0ASy die't drinkt, is eene kwezel=0AHy die=
't drinkt, is ras een ezel The INTERNET now has a personal=
ity. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/
--0-1472956585-1265810707=:29870--