RE: IMAGES/PICTURES-MYSQL
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
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
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
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
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]