Re: [Zope] Display images
--On 2. Juli 2008 16:36:33 +0530 smriti Sebastian <[EMAIL PROTECTED]> wrote: hi, I have stored an html code containing tag in postgres database.when i retrieve the contents using ZSQL the image is not displayed.currently i have stored my image in the /home folder of my system. Try using "Reflecto" for integration a filesystem into Plone. Plone questions belong to the plone-users mailinglist. -aj pgprZeqspb4Y0.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Display images
hi, I have stored an html code containing tag in postgres database.when i retrieve the contents using ZSQL the image is not displayed.currently i have stored my image in the /home folder of my system. On Wed, Jul 2, 2008 at 4:30 PM, Andreas Jung <[EMAIL PROTECTED]> wrote: > > > --On 2. Juli 2008 16:26:56 +0530 smriti Sebastian < > [EMAIL PROTECTED]> wrote: > > hi, >> i have stored image location in postgres database.I >> would like to know where do i store the image files inorder to display it >> in my plone-site? >> > > Not sure whaty you are trying to ask or to achieve. Images should be stored > within Zope/Plone or within the database? Please give a reasonable > description of your problem. > > Andreas ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Display images
--On 2. Juli 2008 16:26:56 +0530 smriti Sebastian <[EMAIL PROTECTED]> wrote: hi, i have stored image location in postgres database.I would like to know where do i store the image files inorder to display it in my plone-site? Not sure whaty you are trying to ask or to achieve. Images should be stored within Zope/Plone or within the database? Please give a reasonable description of your problem. Andreas pgpOUhEYYVvJD.pgp Description: PGP signature ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Display images
hi, i have stored image location in postgres database.I would like to know where do i store the image files inorder to display it in my plone-site? plz help. thanks in advance ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Display images stored in Relational DB
Αρχικό μήνυμα από Chris Withers <[EMAIL PROTECTED]>: > Thomas G. Apostolou wrote: > > I have an External Method "GetPrList" witch is connected to a > python > > module that reads like this > > You really want to be uxing mxODBC and it's Zope DA... > > > X.SODATA is jpg stored in SQL 2K in a field degined as [SODATA] > [image] > > NULL > > Bleugh... binary data in RBDs suck :-( > > > The problem is that i get a "pythonw.exe" Debug-Send Error > Report-Don't > > Send window and zope server breaks down. ( yes i use windows Xp > Pro, > > Zope 2.7.0, Python 2.3.3) > > Sorry, that made no sense. > > I suspect you need to have the template above generate a link to > another > method which actually returns the image data, sets content > disposition, > etc. All pretty yucky stuff... > > Chris > > -- > Simplistix - Content Management, Zope & Python Consulting > - http://www.simplistix.co.uk Dear friend thank you for your reply. I have posted another question (as you saw) in order to show that i am a newbie and did not understand the part of your answer: "> method which actually returns the image data, sets content > disposition, > etc. All pretty yucky stuff..." i mean that i have searched how to make this method which actually returns the image data, sets content disposition but found nothing. Do you have any reading to sugest about this? Thomas G. Apostolou Software Engineer Θωμάς Γ. Αποστόλου Μηχανικός Λογισμικού ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Display images stored in Relational DB
Thomas G. Apostolou wrote: I have an External Method "GetPrList" witch is connected to a python module that reads like this You really want to be uxing mxODBC and it's Zope DA... X.SODATA is jpg stored in SQL 2K in a field degined as [SODATA] [image] NULL Bleugh... binary data in RBDs suck :-( The problem is that i get a "pythonw.exe" Debug-Send Error Report-Don't Send window and zope server breaks down. ( yes i use windows Xp Pro, Zope 2.7.0, Python 2.3.3) Sorry, that made no sense. I suspect you need to have the template above generate a link to another method which actually returns the image data, sets content disposition, etc. All pretty yucky stuff... Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Display images stored in Relational DB
Hello all,
I try to display some images stored in SQL Server 2K.
What i do is:
I have an External Method "GetPrList" witch is connected to a python
module that reads like this
def GetPrListData(self, sysDSN="Test_A_Voisys", usr="sa",
mypass="voisys"):
id = self.id
import dbi
import odbc
connection=odbc.odbc(sysDSN+'/'+usr+'/'+mypass)
cur=connection.cursor()
sSQL='SELECT M.CODE,M.NAME,X.SODATA FROM dbo.MTRL M JOIN
dbo.XTRDOCDATA
X ON M.MTRL=X.REFOBJID WHERE X.SOSOURCE=51 AND M.MTRGROUP=3'
cur.execute(sSQL)
data=cur.fetchall()
cur.close()
connection.close()
return data
X.SODATA is jpg stored in SQL 2K in a field degined as [SODATA] [image]
NULL
The above select returns -executed from within PythonWin- the folowing:
[('ACC.ART.0001', 'xd3xc5xd4 xc2xc9xc4xc5xd3 &
xd0xc1xcexc9xccxc1xc4xc9xc1 xccxc5 xc5xcbxc1xd4 andy',
), ('ACC.CO3.0001', 'BATTERY
xccxcfxcbxd5xc2xc4xcfxd5 12V', ),
('ACC.CO3.0002', 'MExcbxc1xcdxc9 xcfxcaxc9 10i/12i/14e', )]
Then from a DTML Method "ShowResults" i call the above External Method
"GetPrList" and show its results in a table.
ShowResults reads like this:
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
http://www.w3.org/1999/xhtml"; xml:lang="en"
lang="en">
Κωδικός
Ονομασία
Εικόνα
dsnName, usrID, passWD are properties with values of a folder i use
with
aquisition when i call DTML Method "ShowResults"
The problem is that i get a "pythonw.exe" Debug-Send Error Report-Don't
Send window and zope server breaks down. ( yes i use windows Xp Pro,
Zope 2.7.0, Python 2.3.3)
Thanks in advance
Thomas G. Apostolou
Software Engineer
Θωμάς Γ. Αποστόλου
Μηχανικός Λογισμικού
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
