RE: IMAGES/PICTURES-MYSQL

2007-11-24 Thread puntapari

Hi!

I have seen in this page http://www.blobstreaming.org/ but i think that it´s
quite difficult. I want to put only the url of the image, and as you said
the pictures o images might be in the server folder, but what is the folder?

Thanks.
-- 
View this message in context: 
http://www.nabble.com/IMAGES-PICTURES-MYSQL-tf4845682.html#a13923823
Sent from the MySQL - General mailing list archive at Nabble.com.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: IMAGES/PICTURES-MYSQL

2007-11-22 Thread puntapari

Hello!

I have tried the instructions that you explain to me. I have read also some
issues but doens´t work.

So i have done:



 

http://www.nabble.com/file/p13894350/1.jpg 
http://www.nabble.com/file/p13894350/2.jpg 
http://www.nabble.com/file/p13894350/3.jpg 

I don´t know if my proyect is in the correct path (C:\Documents and
Settings\Ibai Leizea\Escritorio\gsg\SociedadGastronomica\) or the images
(C:\Documents and Settings\Ibai
Leizea\Escritorio\gsg\SociedadGastronomica\web\IMAGES). I have also proved
copying the IMAGE folder in other path, but it doesn´t work. I don´t know
specifically which is the server path.


Thanks to everybody!

Ibai
-- 
View this message in context: 
http://www.nabble.com/IMAGES-PICTURES-MYSQL-tf4845682.html#a13894350
Sent from the MySQL - General mailing list archive at Nabble.com.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: IMAGES/PICTURES-MYSQL

2007-11-20 Thread Jerry Schwartz
It all comes down to what you are most comfortable with. What I have done is 
to name each image file with a serial number (1.jpg, 2.gif, 3.png, ...) and 
store the path along with the "real" name of the image in a table row. Doing 
it this way means that you don't need to program logic to convert a blob in 
order to serve it up with a script, you just need to programmatically create a 
link to the image file and let the web server do it. I find that easier to 
work with, and certainly easier to debug.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com

> -Original Message-
> From: puntapari [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 20, 2007 3:38 PM
> To: mysql@lists.mysql.com
> Subject: Re: IMAGES/PICTURES-MYSQL
>
>
>
> Hello!
>
> I have read that. But i have not idea what i have to do. Because i´m
> amateur
> in this topic.
>
> Thank you
> --
> View this message in context: http://www.nabble.com/IMAGES-PICTURES-
> MYSQL-tf4845682.html#a13865352
> Sent from the MySQL - General mailing list archive at Nabble.com.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> infoshop.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: IMAGES/PICTURES-MYSQL

2007-11-20 Thread puntapari


Hello!

I have read that. But i have not idea what i have to do. Because i´m amateur
in this topic.

Thank you
-- 
View this message in context: 
http://www.nabble.com/IMAGES-PICTURES-MYSQL-tf4845682.html#a13865352
Sent from the MySQL - General mailing list archive at Nabble.com.


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: IMAGES/PICTURES-MYSQL

2007-11-20 Thread Martijn Tonies
Hi,

>I have read some messages about this topic but i haven´t resolved my
problem
>yet. I am using mySQL Query Browser to make de schema. And i have a table
>(product) where there are some attributes (producto, precio,
>nUds,tipo)(spanish). All are relationated with one product (ex: heineken
>beer). So, i want to put another atribute image where i can put the image
of
>all the products. But i have read that is imposible, that i have to put the
>path of the jpeg or gif, but i don´t know how. If anyone could help me i
>will be grateful. Attached is the image of my DB:

What makes you think it's impossible to store the actual image inside a
blob field?

Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]