[Zope-DB] prblem with insert attachment into database

[ah_new]

Hi,

I now facing problem with insert of attachment file
into MySQL database from a Zope page. I think the
insertion sql in Zope is causes the problem. The table
can accept data (attachment) when I had try to insert
attachment from the command prompt into MySQL. I
already have no idea to fix the problem after googling
on this topic for several days. I very hope that you
all can guide me to overcome the problem. 
The SQL that I write in Zope:

insert into email 
values('',
       <dtml-sqlvar name="email" type="string">,
       <dtml-sqlvar name="subject" type="string">,
       CURRENT_DATE,
       <dtml-sqlvar name="text" type="string">,
       <field name="attach" type="stream">
          <sql name="attach" type="blob"
dirty="ignore" />
       </field>)

 * the 1st column of the table is
auto-increase-number.

Sorry, if I am post this message to the wrong place.
Many Thanks.

Regards,
ah new 


	
	
		
___________________________________________________________ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com