Re: BLOB Filed - Image Store [THANKS]

2010-02-10 Thread Vikram A
helping time of the experts. Sorry for wasting such experts time by posting simple queries. Thank you VIKRAM A From: Johan De Meersman To: Vikram A Sent: Wed, 10 February, 2010 7:22:18 PM Subject: Re: BLOB Filed - Image Store On Wed, Feb 10, 2010 at 2:08 PM

Re: BLOB Filed - Image Store

2010-02-10 Thread Johan De Meersman
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-handling.html > > I have stored image using the following. >

BLOB Filed - Image Store

2010-02-10 Thread Vikram A
Hi, As stated http://dev.mysql.com/tech-resources/articles/vb-blob-handling.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

Image - Crystal Report - VB6.0

2010-02-09 Thread Vikram A
Hi experts, I have blob filed, which contains the image. I am using BV6.0 as my front end application. And i have some pre-defined [defined by me] .rpt file. Along with the details, i would like to add the photo on the report. Can you help how to do this? Thank you Regards, VIKRAM A

Re: [MySQL] Re: Image Store @ My SQL

2010-01-30 Thread Ashley M. Kirchner
Vikram A wrote: Is it So? then i may have the following, when ever i want the image of a i need look for the share machine! If it is not available it may cause some difficulties. 1) NFS sharing a file (any file) is better suited for this task. 2) The DB should only hold the file

Re: Image Store @ My SQL

2010-01-30 Thread Colin Streicher
30, 2010 05:01:54 am Vikram A wrote: > Dear Sir, > > Let me explain what i understood, > > 1. I have to create a shareable folder among the network. > 2. The image files has to be kept at share machine > 3. Then the path (share machine) of the file has to be stored in the DB

Fw: IMAGE STORE @ FEDORA 11

2010-01-30 Thread Vikram A
sorry the link i given is wrong. Please follow this http://dev.mysql.com/tech-resources/articles/vb-blob-handling.html - Forwarded Message From: Vikram A To: MY SQL Mailing list Sent: Sat, 30 January, 2010 7:04:01 PM Subject: IMAGE STORE @ FEDORA 11 Dear One, I found nice

IMAGE STORE @ FEDORA 11

2010-01-30 Thread Vikram A
Dear One, I found nice solution on the following citation http://dev.mysql.com/tech-resources/articles/vb-cursors-and-locks.html It was really helpful to me. Thank you VIKKI A Your Mail works best with the New Yahoo Optimized IE8. Get it NOW! http://downloads.yahoo.com/in/internetexp

Re: Image Store @ My SQL

2010-01-30 Thread Vikram A
Dear Sir, Let me explain what i understood, 1. I have to create a shareable folder among the network. 2. The image files has to be kept at share machine 3. Then the path (share machine) of the file has to be stored in the DB 4. When we want it has to be taken from the share Is it So? then i

Re: Image Store @ My SQL

2010-01-30 Thread Walter Heck
am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32). > > We have an client server application, server is located at another end of an > intranet and the nodes are connected from different ends of intranet. > > In this modal, I need to store image of the student fr

Re: Image Store @ My SQL

2010-01-30 Thread Walter Heck
On Sat, Jan 30, 2010 at 19:03, Vikram A wrote: > I am not clear with your answer, can you please explain it? Well, MySQL (as most databases) is not really suited for storing images. If you create a networked storage that you can share between both locations, that would solve your problem, right?

Re: Image Store @ My SQL

2010-01-30 Thread Vikram A
Dear Walter Heck, I am happy to receive immediate response from you. I am not clear with your answer, can you please explain it? Thank you From: Walter Heck To: Vikram A Cc: mysql@lists.mysql.com Sent: Sat, 30 January, 2010 2:29:43 PM Subject: Re: Image

Image Store @ My SQL

2010-01-30 Thread Vikram A
Hi, I am using MYSQL with VB 6.0. We have fedora11 my sql (version 5.1.32). We have an client server application, server is located at another end of an intranet and the nodes are connected from different ends of intranet. In this modal, I need to store image of the student from one node that

Re: Inserting an Image

2009-10-16 Thread Victor Subervi
te: > Victor, > > again, your question has more to do with python usage than MySQL > per-se.. you would be better off pursuing these questions in a python > forum. > > - michael dykman > > On Thu, Oct 15, 2009 at 3:28 PM, Gavin Towey wrote: > > "Image in string form"

Re: Inserting an Image

2009-10-15 Thread Michael Dykman
Victor, again, your question has more to do with python usage than MySQL per-se.. you would be better off pursuing these questions in a python forum. - michael dykman On Thu, Oct 15, 2009 at 3:28 PM, Gavin Towey wrote: > "Image in string form"  sounds like you're not ins

RE: Inserting an Image

2009-10-15 Thread Gavin Towey
"Image in string form" sounds like you're not inserting binary data, rather some sort of encoded data. Even if it is binary, you'll have to escape at least end quote characters, you can see clearly at the top of your data there is : 'ÿØÿà JFIF ÿÛC ""

Re: Inserting an Image

2009-10-15 Thread Jo�o C�ndido de Souza Neto
The first thing I think I have to sey is "it´s not a good idea to save image data in a mysql table field", the best way is to save the file in your file system and the file name in the table field, but, if you like to do that, it´s better to be a blob field. "Victor Suberv

Inserting an Image

2009-10-15 Thread Victor Subervi
Hi; I have successfully inserted images, like yesterday, before into MySQL with the following code: sql = 'update productsX set pic1="%s" where ID=2;' % pic1 cursor.execute(sql) where pic1 is simply an image uploaded through a form then sent over without any a

SQL Image Viewer 2.4.0.132 released

2009-08-05 Thread Yohz Software Support
SQL Image Viewer helps you retrieve, view, convert and export images and binary data stored in SQL Server, Firebird, MySQL, Oracle, SQLite, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF, and

.xml files extract to mysql for my image library

2008-07-12 Thread David Southwell
Has the wheel been invented?? All my image files, stored in *.psd (photoshop) or *.cr2 (canon raw files) file extension, have an associated *.xml file that contains the metadata relating to the image sharing the same file name. The *.xml files have been created by Adobe bridge and/or photoshop

Re: Array as Image?

2008-04-08 Thread Rafael Barbolo Lopes
What is your column's type? Is it blob? See this, might help: http://www.phpriot.com/articles/images-in-mysql On Tue, Apr 8, 2008 at 2:18 PM, Victor Subervi <[EMAIL PROTECTED]> wrote: > Hi: > I have successfully loaded an image into my database (I believe). When I > go >

Array as Image?

2008-04-08 Thread Victor Subervi
Hi: I have successfully loaded an image into my database (I believe). When I go to retrieve it, I get this... array('c', '\xff\xd8\xff\xe0\\0... How do I convert that into an image. TIA, Victor

Re: retrieveng DB data on filesystem level (image stuff)

2007-02-11 Thread Lars Schwarz
hi tsr, where's the question? :) store the reference to the file in the database, not the file itself. hth: lars On 2/11/07, tsr.offentlig <[EMAIL PROTECTED]> wrote: Hi, Ok, I've been searching around for information on storing images in a DB (ok, not very original, but anyhow). After readin

retrieveng DB data on filesystem level (image stuff)

2007-02-11 Thread tsr.offentlig
Hi, Ok, I've been searching around for information on storing images in a DB (ok, not very original, but anyhow). After reading these links: http://www.dreamwerx.net/phpforum/?id=1 http://www.zend.com/zend/trick/tricks-sept-2001.php?article=tricks-sept-2001&kind=tr&id=2033&open=1&anc=0&view=1

RE: Saving Image in Database [again]

2006-07-30 Thread Jay Blanchard
[snip] Was wondering if I could get a conversation started on the pros/cons of database storage verse filesystem [/snip] There is additional overhead in saving and retrieving images from a database typically. Most folks benchmark to see which is faster and more efficient on their systems. YMMV. B

Re: Saving Image in Database [again]

2006-07-30 Thread Michael Loftis
--On July 30, 2006 10:42:16 AM -0500 Chris McKeever <[EMAIL PROTECTED]> wrote: Starting to build a new schema, and one of the items is image storage In the past I have always used filesystem storage. Was wondering if I could get a conversation started on the pros/cons of database s

RE: Saving Image in Database [again]

2006-07-30 Thread John Berman
Chris I'm sure that many of the experienced list members may well correct me however I started saving images in my databases and found it much simpler to simply store the image name and the path if required. Regards John Berman -Original Message- From: Chris McKeever [mailto:[

Re: Saving Image in Database [again]

2006-07-30 Thread mos
Chris, At 10:42 AM 7/30/2006, you wrote: Starting to build a new schema, and one of the items is image storage In the past I have always used filesystem storage. Was wondering if I could get a conversation started on the pros/cons of database storage verse filesystem Thanks! It takes a lot

Saving Image in Database [again]

2006-07-30 Thread Chris McKeever
Starting to build a new schema, and one of the items is image storage In the past I have always used filesystem storage. Was wondering if I could get a conversation started on the pros/cons of database storage verse filesystem Thanks! -- -- please respond to the

RE: Document / Image (Blob) archival -- Best Practices

2006-04-20 Thread Tim Lucia
- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 18, 2006 11:35 PM To: Tim Lucia Cc: mysql@lists.mysql.com Subject: Re: Document / Image (Blob) archival -- Best Practices Tim Lucia wrote: > Hi all, > > > I am considering moving some archival records which largely c

Re: Document / Image (Blob) archival -- Best Practices

2006-04-18 Thread Daniel Kasak
Tim Lucia wrote: Hi all, I am considering moving some archival records which largely consist of blobs (PDF Image files) out of an Oracle DB and onto MySQL. Has anyone done this (not necessarily the Oracle part) who can relate their experience(s)? I can go with MyISAM or archive storage

Re: Document / Image (Blob) archival -- Best Practices

2006-04-18 Thread Michael Kruckenberg
cords which largely consist of blobs (PDF Image files) out of an Oracle DB and onto MySQL. Has anyone done this (not necessarily the Oracle part) who can relate their experience (s)? I can go with MyISAM or archive storage engine, from the looks of it. This is not transactional data, alt

Document / Image (Blob) archival -- Best Practices

2006-04-18 Thread Tim Lucia
Hi all, I am considering moving some archival records which largely consist of blobs (PDF Image files) out of an Oracle DB and onto MySQL. Has anyone done this (not necessarily the Oracle part) who can relate their experience(s)? I can go with MyISAM or archive storage engine, from the looks

Re: Image Storage -- Better to store them on the Filesystem or in the MySQL DB

2005-11-24 Thread Gleb Paharenko
Hello. >From my experience in most cases it is recommended to store images in files. ESV Media GmbH wrote: > Hey, > > we´ve large amount of Images ( nearly 2 GB ). > And they will increase, cause or Editors will submit several articles a > day where they´re allowed to upload > some ne

Re: Image Storage -- Better to store them on the Filesystem or in the MySQL DB

2005-11-24 Thread SmellySocks
: "ESV Media GmbH" <[EMAIL PROTECTED]> To: Sent: Thursday, November 17, 2005 1:18 AM Subject: Image Storage -- Better to store them on the Filesystem or in the MySQL DB Hey, we´ve large amount of Images ( nearly 2 GB ). And they will increase, cause or Editors will submit several

Image Storage -- Better to store them on the Filesystem or in the MySQL DB

2005-11-24 Thread ESV Media GmbH
Hey, we´ve large amount of Images ( nearly 2 GB ). And they will increase, cause or Editors will submit several articles a day where they´re allowed to upload some new pics. So, whats the better solution ? To store them in the filesystem ( with only the path in the db ) or to store them as BL

ANN: uc2004.vbmysql.com - Conference Blog Collection and Image Gallery

2004-04-10 Thread Mike Hillyer
Hi All; I would like to take a moment to announce the launch of http://uc2004.vbmysql.com. This site is intended to serve as a resource for the MySQL community as a blog collection and photo gallery related to the 2004 MySQL User Conference & Expo (http://www.mysql.com/news-and-events/users-confer

Re: Multiple Image inserts into a MySQL BLOB column

2003-10-21 Thread gerald_clark
Using the recommeded method from the MySQL manaual ie. UPDATE tbl_name SET blob_column=LOAD_FILE("/tmp/picture") WHERE id=1; only sets the blob field to NULL (0 bytes) ! - even where an image is stored perfectly well. There has to a SAFE METHOD of doing these image inserts from wi

Re: Multiple Image inserts into a MySQL BLOB column

2003-10-20 Thread colbey
E id=1; > > only sets the blob field to NULL (0 bytes) ! - even where an image is > stored perfectly well. > There has to a SAFE METHOD of doing these image inserts from within a > 'while' 'for' or some other loop statement in a shell script or perl > routine. Apprecia

Re: Multiple Image inserts into a MySQL BLOB column

2003-10-20 Thread Zafar
lob_column=LOAD_FILE("/tmp/picture") WHERE id=1; only sets the blob field to NULL (0 bytes) ! - even where an image is stored perfectly well. There has to a SAFE METHOD of doing these image inserts from within a 'while' 'for' or some other loop statement in a s

Retrieving a BMP image from a binary field in the DB

2003-08-01 Thread Franz Klein
Hi Thanks to everybody who told me how to store a BMP image as a BLOB using the LOAD_FILE. Now I would like to now if there is a function that does the opposite to LOAD_FILE? I have tried using SQLFetch after using a SQLBindCol, but all I get returned is the first 4 bytes even if the size of

Retrieving image files

2003-07-24 Thread Sreesekhar Palaparthy
I used mysql_real_escape_string() method to insert image file into database. Now how do icheck whether it got stored in proper format ?? I used SELECT * INTO OUTFILE F1 FROM IMGTABLE; command , but i'm not able to see the image back in F1. How do i retrieve the image in proper f

Re: Retreiving image files

2003-07-24 Thread Egor Egorov
"Sreesekhar Palaparthy" <[EMAIL PROTECTED]> wrote: > I used mysql_real_escape_string() to insert jpg image file into > database. Now how do i check whether it got stored in proper > format?? I tried to retriev that image file using > > SELECT * INTO OUTFILE

Retreiving image files

2003-07-23 Thread Sreesekhar Palaparthy
I used mysql_real_escape_string() to insert jpg image file into database. Now how do i check whether it got stored in proper format?? I tried to retriev that image file using SELECT * INTO OUTFILE FROM IMGTABLE; But it says cannot open image file as it contains errors. How do i retrieve the

Re: Image files

2003-07-14 Thread Thomas Spahni
Hi, you have to escape your binary data; check mysql_real_escape_string() function in the manual and the archives. This is a frequently asked question. Thomas Spahni On 14 Jul 2003, Sreesekhar Palaparthy wrote: > Hi, > How do i insert binary data into a BLOB field??? Like , if i > have

Image files

2003-07-13 Thread Sreesekhar Palaparthy
Hi, How do i insert binary data into a BLOB field??? Like , if i have a table with say 3 fields of which 1 is blob type, now how do i store some binary file in that particular field??? Please help me out as i have to look put for some corresponding function in C++ API after that.Thank You

Image files

2003-07-06 Thread Sreesekhar Palaparthy
Hi, I want to save image files into BLOB fields?? How do i do it?? And how to retrieve it back from database?? ___ Click below to experience Sooraj R Barjatya's latest offering 'Main Prem Ki Diwani Hoon' starring Hrithik, Abhi

Re: create a table with an image item

2003-06-17 Thread gerald_clark
Since you are providing the web page, it depends on how you write the web page. This really isn't a MySQL question, is it? v7rg8 wrote: Hi all, My table is like this: professor(name, gender, bodyImage) I am not sure if this is correct to set up the table: create table professor (name char(10),

create a table with an image item

2003-06-17 Thread v7rg8
Hi all, My table is like this: professor(name, gender, bodyImage) I am not sure if this is correct to set up the table: create table professor (name char(10), gender char(10), bodyImage blob); If it is correct, I was wondering how users are going to load images into the database from the webpage

Re: Insert Image content via command line

2003-06-10 Thread gerald_clark
How big is the imge file? How do you check the contents of the table? How are you determining that it is null? Did you try to select the column into an outfile? If so, how big was the outfile? Titu Kim wrote: Yes, the image file is on the server and i already chown and chrgp to mysql for this

Re: Insert Image content via command line

2003-06-10 Thread Titu Kim
Yes, the image file is on the server and i already chown and chrgp to mysql for this file. Still the data is null in the table. --- gerald_clark <[EMAIL PROTECTED]> wrote: > > > Titu Kim wrote: > > >Hi, > >I am trying to insert an image directly from > &

Re: Insert Image content via command line

2003-06-10 Thread gerald_clark
Titu Kim wrote: Hi, I am trying to insert an image directly from command line into mysql table. My table looks like == Create table ImageTab (id int, content longblob); === I login to localhost. I have an image at /tmp. Then i issue this query

Insert Image content via command line

2003-06-09 Thread Titu Kim
Hi, I am trying to insert an image directly from command line into mysql table. My table looks like == Create table ImageTab (id int, content longblob); === I login to localhost. I have an image at /tmp. Then i issue this query insert

RE: Mysql / PHP image link problem.

2003-06-04 Thread Peter Lovatt
'; ?> Peter -Original Message- From: Becoming Digital [mailto:[EMAIL PROTECTED] Sent: 03 June 2003 20:57 To: [EMAIL PROTECTED] Subject: Re: Mysql / PHP image link problem. FWIW, there is a PHP-DB mailing list that might prove more helpful to you. I know certain folk on both l

Re: Mysql / PHP image link problem.

2003-06-04 Thread Becoming Digital
l.com - Original Message - From: "Daniel Crompton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 03 June, 2003 14:20 Subject: Mysql / PHP image link problem. I have a mysql table column called 'imagecolumn' The rows contain links i.e. image.gif image.gif nu

RE: Mysql / PHP image link problem.

2003-06-04 Thread Jonathan Villa
You'll have to check if the result is NULL or not. Try this " : ""; ?> This is print out nothing if your result is equal to null. On another notes, how do you specify the width and height of this image? Or the alt tag, or set the border so that on older versions

Re: Mysql / PHP image link problem.

2003-06-04 Thread Roman Neuhauser
t; (null), a web browser shows this as a broken image link icon. i.e. it > doesn't ignore it. > > Does anyone know how I can get my page to ignore it if there is no link. like: don't output the tag if the image is null? -- If you cc me or remove the list(s) completely I'

Re: Mysql / PHP image link problem.

2003-06-04 Thread Paul DuBois
e field in my table is left blank (null), a web browser shows this as a broken image link icon. i.e. it doesn't ignore it. Does anyone know how I can get my page to ignore it if there is no link. Add WHERE imagecolumn IS NOT NULL to your SELECT statement. Then you won't select the ro

Mysql / PHP image link problem.

2003-06-04 Thread Daniel Crompton
eb browser shows this as a broken image link icon. i.e. it doesn't ignore it. Does anyone know how I can get my page to ignore it if there is no link.

Re: How to insert an Image in a table with libmysqlclient and API C ?

2003-02-01 Thread Benjamin Pflugmann
Hi. On Fri 2003-01-31 at 18:56:19 +0100, [EMAIL PROTECTED] wrote: > Hi all, > > my problem is the following, it's possible to insert an image in a table > with the libmysqlclient ? Yes. > My language is C > > i'm working with GNU/Linux Bye, Benjamin

How to insert an Image in a table with libmysqlclient and API C ?

2003-01-31 Thread Stephane Wirtel
Hi all, my problem is the following, it's possible to insert an image in a table with the libmysqlclient ? My language is C i'm working with GNU/Linux Best Regards, Stephane Wirtel - Before posting, please chec

Re: View image from browser

2002-12-27 Thread Michael She
What language are you using to pull the data? ASP? PHP? VB? At 11:23 PM 12/26/2002 -0800, tan tan wrote: Hi, Is anyone know how to view image that is stored in mysql as binary format to a browser ? Thank you. -- Michael She : [EMAIL PROTECTED] Mobile : (519) 589-7309 WWW Homepage

Re: View image from browser

2002-12-27 Thread tan tan
.com/mysql-perl/webdb/webdb.tar.gz > http://www.kitebird.com/mysql-perl/webdb/webdb.zip > > > > >--- Paul DuBois <[EMAIL PROTECTED]> wrote: > >> At 23:23 -0800 12/26/02, tan tan wrote: > >> >Hi, > >> > > >> >Is anyone know

Re: View image from browser

2002-12-27 Thread Doug Thompson
On Fri, 27 Dec 2002 07:15:01 -0600, Paul DuBois wrote: >At 0:43 -0800 12/27/02, tan tan wrote: >>Hi Paul >>I went to the site and I can't look for the page. >>If you dont' mind to get the the exact url. >>Thanks. > >Odd. Anyone else out there have trouble with that URL? > >http://www.kitebird.com

Re: View image from browser

2002-12-27 Thread Paul DuBois
perl/webdb/webdb.tar.gz http://www.kitebird.com/mysql-perl/webdb/webdb.zip --- Paul DuBois <[EMAIL PROTECTED]> wrote: At 23:23 -0800 12/26/02, tan tan wrote: >Hi, > >Is anyone know how to view image that is stored in >mysql as binary format to >a browser ? > >

Re: View image from browser

2002-12-27 Thread Solid Plasma (slpl)
pdf file http://www.kitebird.com/mysql-perl/ch05.pdf and do a search in the pdf file for the string 'Storing and Retrieving Images' > --- Paul DuBois <[EMAIL PROTECTED]> wrote: >> At 23:23 -0800 12/26/02, tan tan wrote: >> >Hi, >> > >> >Is anyone

Re: View image from browser

2002-12-27 Thread tan tan
Hi Paul I went to the site and I can't look for the page. If you dont' mind to get the the exact url. Thanks. --- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 23:23 -0800 12/26/02, tan tan wrote: > >Hi, > > > >Is anyone know how to view image that is stored

Re: View image from browser

2002-12-27 Thread Paul DuBois
At 23:23 -0800 12/26/02, tan tan wrote: Hi, Is anyone know how to view image that is stored in mysql as binary format to a browser ? Thank you. Once you pull your image data from MySQL (I assume you're using some kind of script for this), then you do this the same way you'd do i

View image from browser

2002-12-26 Thread tan tan
Hi, Is anyone know how to view image that is stored in mysql as binary format to a browser ? Thank you. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

Re: help for image into database

2002-11-22 Thread John Ragan
some problems when i first started using it because i sometimes needed to declare a client side cursor. you might fiddle with that. step back and look at what your code is doing. hope that this helps some. > > > > > Hi, mysql > > I want to put a image into mysql

help for image into database

2002-11-21 Thread luoya li
Hi, mysql I want to put a image into mysql database,but when I run program listed below <% formsize=Request.TotalBytes formdata=Request.BinaryRead(formsize) set rs=server.CreateObject("adodb.recordset") strconn="driver={mysql};dbq="&server.MapPath("test

help for put image into mysql

2002-11-21 Thread luoya li
Hi, I want to put a image into mysql,but when I run program listed below <% formsize=Request.TotalBytes formdata=Request.BinaryRead(formsize) Dim mycon set mycon=server.createobject("adodb.Connection") mycon.mode=adModeReadWrite mycon.connectionString="DSN=ez;UID=aa;P

store an image as BLOB

2002-11-20 Thread Fam. Tarniceru
Hi, I would like to know how to store an image as a BLOB in MySQL. (from Delphi). Sincerely, Adrian Tarniceru --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all

store an image as BLOB

2002-11-18 Thread Fam. Tarniceru
Hi, I would like to know how to store an image as a BLOB in MySQL. (from Delphi). Sincerely, Adrian Tarniceru --- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for

Re: Image display Blob

2002-10-24 Thread muyuan
I have seen a solution from a book how to display image queryed by php from db step 1. at first like you ,create a php using Header("Content-type: image/gif") to display the mesage queried from my sql. This displays the image .for example this file named "image.php?imageID = ??

Image display Blob

2002-10-15 Thread anonazyet
Hi! I have a html-php form which connects to a my-sql DB and retrieves and displays the name and image(Stored in Blob) I'm using Header("Content-type: image/gif") to display the mesage queried from my sql. This displays the image, but I want it displayed in a along with oth

Re: storing image in the db ????

2002-10-08 Thread Ivan Paul
toby, to store image in mysql database, i usually use blob/mediumblob/longblob data type. what do u mean for images in text? Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: toby gibbson <[EMAIL PROTECTED]> To: &

Re: storing image in the db ????

2002-10-08 Thread Ivan Paul
toby, to store image in mysql database, i usually use blob/mediumblob/longblob data type. what do u mean for images in text? Ivan Paul Web Developer Mediate - Media Communications http://www.bhaktimedia.com - Original Message - From: toby gibbson <[EMAIL PROTECTED]> To: &

Re: storing image in the db

2002-10-08 Thread Michael T. Babcock
Sherif D Mohamad wrote: >>I am not sure, But maybe you can convert images to mime formart (which is >>text actually), > Just to be picky; MIME format just describes how to seperate sections of a mail message, the 'text format' version of the image is described in the &

Re: storing image in the db ????

2002-10-08 Thread Sherif D Mohamad
: "toby gibbson" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 08, 2002 4:09 AM Subject: storing image in the db > hi guyz > > i ve these images of text n i ve to store em in mysql database > ALONG WITH some TEXT > n im storing the tex

storing image in the db ????

2002-10-08 Thread toby gibbson
hi guyz i ve these images of text n i ve to store em in mysql database ALONG WITH some TEXT n im storing the text in a longtext field vat do i do can n will some1 plz help ? thnx a million guyz toby .. _ Join th

RE: image size in mysql

2002-09-24 Thread Dean Harding
Hey, > 1.I have to store some images in the db. Each image size is around 800kb > to > 900kb(almost 1 mb). Will it affect the performance. I am using mediumblob > for this. I'm not sure about this as I've never really tried, but my intuition tells me: no, it won't aff

image size in mysql

2002-09-24 Thread kayamboo
filter;sql;query Hello folks Can anyone pls give some useful tips for these questions 1.I have to store some images in the db. Each image size is around 800kb to 900kb(almost 1 mb). Will it affect the performance. I am using mediumblob for this. 2.Secondly, if I am storing for eg. this is

Re: Save Image (GIF or JPEG) file in the database ?

2002-08-02 Thread Serge Paquin
I use blob columns. One thing I do though is store them in there own table and not in a table with other data. I just link through primary key. That way when you are not looking for an image the database does not have to deal with it. Also it's easier for disaster recovery since you d

RE: Save Image (GIF or JPEG) file in the database ?

2002-08-02 Thread Francisco
helps. Bye and Good Luck. --- Simon Green <[EMAIL PROTECTED]> wrote: > Have a look at > http://www.mysql.com/doc/B/L/BLOB.html > > Simon > > -Original Message- > From: Khanh Pham > [mailto:[EMAIL PROTECTED]] > Sent: 02 August 2002 09:59 > To: [EMAIL P

RE: Save Image (GIF or JPEG) file in the database ?

2002-08-02 Thread Simon Green
Have a look at http://www.mysql.com/doc/B/L/BLOB.html Simon -Original Message- From: Khanh Pham [mailto:[EMAIL PROTECTED]] Sent: 02 August 2002 09:59 To: [EMAIL PROTECTED] Subject: Save Image (GIF or JPEG) file in the database ? Hello ladies & gents, I am new to MySQL. I wo

Save Image (GIF or JPEG) file in the database ?

2002-08-02 Thread Khanh Pham
Hello ladies & gents, I am new to MySQL. I wonder if I can save a picture in the database, then I can load into a JSP. The perfect example is an employee page ! Thanks in advance for your helps ! /Khanh - Before posting, ple

Re: image data

2002-07-12 Thread Egor Egorov
William, Friday, July 12, 2002, 12:45:02 AM, you wrote: WM> I am new to MySQL and I was trying to find out how to setup a record WM> with a datatype as a image jpg etc... Take a look at BLOB column type: http://www.mysql.com/doc/B/L/BLOB.html -- For technical s

Re: image data

2002-07-11 Thread Michael McClennen
William Miller <[EMAIL PROTECTED]> wrote: > I am new to MySQL and I was trying to find out how to setup a record > with a datatype as a image jpg etc... I have recently done just that. Here is my table structure: CREATE TABLE IF NOT EXISTS Item_binary ( entry int(11) NOT

image data

2002-07-11 Thread William Miller
I am new to MySQL and I was trying to find out how to setup a record with a datatype as a image jpg etc... Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: saving modified image to blob

2002-06-29 Thread Georg Richter
On Saturday, 29. June 2002 15:10, andy wrote: Hi Andy, What shows mysql_errno after mysql_query?! Why you don't use mysql_real_escape_string (or mysql_escape_string for PHP Version < 4.1.1) instead of addslashes?! Regards Georg -

saving modified image to blob

2002-06-29 Thread andy
Hi there, I would like to save a jpg into a blob field of mysql. The function underneath works fine if I read the image from the temporary destination where php did put it after uploading. My problem is, that I would like to do some funky stuff to the image like changing colors or adding

Re: Scanning Directory/Inserting Image Links to DB

2002-04-14 Thread Michael A Chase
From: "Will K." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, April 14, 2002 23:21 Subject: Scanning Directory/Inserting Image Links to DB > Can someone recommend a Perl script/technique that will scan a Unix > directory of ima

Scanning Directory/Inserting Image Links to DB

2002-04-14 Thread Will K.
Greets Folks, Can someone recommend a Perl script/technique that will scan a Unix directory of image/text files, and then insert the links into a MySQL database? I used to have a good one, but it got misplaced... Doh! Thanks, Will

How can I store a image into MYSQL database

2002-04-03 Thread Victoria Reznichenko
Ibrahim, Wednesday, April 03, 2002, 11:30:28 AM, you wrote: IKC> I want to knowledge about blob. IKC> how can write or read image(jpeg,gif or tiff) to/from MYSQL database by IKC> using Visual C++. MySQL++ seems too confused. :) In the manual you can find examples of loading/readi

Re: How can I store a image into MYSQL database

2002-04-03 Thread TAKAHASHI, Tomohiro
object , > for example, an image, to the mysql database, while I use EJB. > Another words, I have a object , which has a blob column, I wanna to > save and retrive this object from mysql database via > CMP or BMP...how to make that? -- Borland Japan / Consulting Group TAKAHASH

How can I store a image into MYSQL database

2002-04-03 Thread pwxgao
I also interestig in this topic...I wanna know how to save a blob object , for example, an image, to the mysql database, while I use EJB. Another words, I have a object , which has a blob column, I wanna to save and retrive this object from mysql database via CMP or BMP...how to make that

How can I store a image into MYSQL database

2002-04-03 Thread Ibrahim K. Cihan
hii all, I want to knowledge about blob. how can write or read image(jpeg,gif or tiff) to/from MYSQL database by using Visual C++. MySQL++ seems too confused. Can any body say me more basic and understandable way to do this.. Thanks... Ibrahim Kivanc Cihan Anadolu University

How to store an Image on MySQL

2002-03-01 Thread Egor Egorov
Hector, Thursday, February 28, 2002, 7:51:39 PM, you wrote: HR> Hi Everybody, I have a problem with MySQL when I try to store HR> image file on it. I use a Blob field but the info that must be HR> stored there should be between quotations marks right? Like a HR> string , i mean

RE: How to store an Image on MySQL

2002-02-28 Thread Matthew Smith
TECTED]] Sent: 28 February 2002 17:52 To: [EMAIL PROTECTED] Subject: How to store an Image on MySQL Hi Everybody, I have a problem with MySQL when I try to store image file on it. I use a Blob field but the info that must be stored there should be between quotations marks right? Like a string ,

  1   2   >