[Product-Developers] File saving with PloneFormGen in MySQL

bad_my84 bas.roijen at cofely-gdfsuez.nl
Fri Sep 11 06:48:14 UTC 2009


With the line Andreas gave ("binary_data =
context.REQUEST['name-of-file-field'].read()") or some small variation
of that.
I can't tell you exactly because I lost all my code.
 

________________________________

Van: bribon (via Nabble) [mailto:ml-user+283476-530272490 at n2.nabble.com]

Verzonden: donderdag 10 september 2009 20:49
Aan: Roijen, Bas
Onderwerp: Re: [Product-Developers] File saving with PloneFormGen in
MySQL




	bad_my84 wrote:

		Andreas Jung-5 wrote:
		On 13.11.2008 10:41 Uhr, bad_my84 wrote: 
		> The problem is that I don't know how I can add a file
via the 'File field' 
		> into the database. 
		> 
		> With strings&  integers I use the 'ZSQL Method' with: 
		> INSERT INTO tabel VALUES( 
		>    <dtml-sqlvar voornaam type=string>, 
		>    <dtml-sqlvar achternaam type=string> 
		> ) 
		> 
		> But what kind of type should I use for a file? Or
isn't it that ease? 
		
		No idea about MySQL but a blob-ish type is likely the
right choice. 
		You have to check your MySQL documentation how to insert
binary data 
		into a blob. This is not a Zope issue since Zope
generates only the SQL 
		_you are writing_. If you upload a file you should be
able to get hold 
		of the binary data of the file through something like 
		
		binary_data =
context.REQUEST['name-of-file-field'].read() 
		
		-aj 
		
		begin:vcard 
		fn:Andreas Jung 
		n:Jung;Andreas 
		org:ZOPYX Ltd. & Co. KG 
		adr;quoted-printable:;;Charlottenstr.
37/1;T=C3=BCbingen;;72070;Germany 
		email;internet:info at zopyx.com 
		title:CEO 
		tel;work:+49-7071-793376 
		tel;fax:+49-7071-7936840 
		tel;home:+49-7071-793257 
		x-mozilla-html:FALSE 
		url:www.zopyx.com 
		version:2.1 
		end:vcard 
		
		
		_______________________________________________ 
		Product-Developers mailing list 
		Product-Developers at lists.plone.org 
	
http://lists.plone.org/mailman/listinfo/product-developers

	Thanks, now I know how to get the binary data! 


How did you get it?? 


________________________________

View message @
http://n2.nabble.com/File-saving-with-PloneFormGen-in-MySQL-tp1493368p36
18392.html 
To unsubscribe from Re: File saving with PloneFormGen in MySQL, click
here
< (link removed) 
jb2ZlbHktZ2Rmc3Vlei5ubHwxNDkzNDQ3fDMwMTY4MjI5NA==> . 

================================================
De informatie opgenomen in dit bericht kan vertrouwelijk zijn en 
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht 
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en 
de afzender direct te informeren door het bericht te retourneren. 
================================================
The information contained in this message may be confidential 
and is intended to be exclusively for the addressee. Should you 
receive this message unintentionally, please do not use the contents 
herein and notify the sender immediately by return e-mail.
================================================ 
================================================
De informatie opgenomen in dit bericht kan vertrouwelijk zijn en 
is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht 
onterecht ontvangt, wordt u verzocht de inhoud niet te gebruiken en 
de afzender direct te informeren door het bericht te retourneren. 
================================================
The information contained in this message may be confidential 
and is intended to be exclusively for the addressee. Should you 
receive this message unintentionally, please do not use the contents 
herein and notify the sender immediately by return e-mail.
================================================

-- 
View this message in context: http://n2.nabble.com/File-saving-with-PloneFormGen-in-MySQL-tp1493368p3623905.html
Sent from the Product Developers mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.plone.org/pipermail/plone-product-developers/attachments/20090911/3128d6f8/attachment.html>


More information about the Product-Developers mailing list