[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