This should work:
update artikel_table set artikel_qty=artikel_qty -
where artikel_id=
__
Jim Sanford
. Database Engineer
/ \ / Accelerated Technology, Inc.
/ / 720 Oak Circle Drive East
/ / \Mobile, AL 36609
/ / \ Voice: 334-661-5770 fax: 334-661-5788
/ \ E-Mail: [EMAIL PROTECTED]
Web: http://www.atinucleus.com
Nucleus. All You NEED in an RTOS. Royalty Free
__
- Original Message -
From: Borno Janekovic <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 08, 2000 11:13 AM
Subject: [Zope] Getting single values out of lists
Hi,
I have a page wich is created out of a database. For every artikel (item)
I have a description and a number of available items.
The page has multiple rows (depending on the database content)
in every row is a input-box in wich the user can enter a number. This
number needs to be substracted from the available items number of the
correct artikel.
My question is how can I get the correct tuple of items out of the list.
For example
In every row I have the substract box and a hidden field with the primary
key:
When I submit the Form I get with the following lines
:
the content
substract = ['12', '', '', '', '', '', '', '', '', '']
artikel_id = ['2808095658', '2808095503', '2808095341',
'2808095744', '2731135126', '2808092056', '2808092333',
'2808092723', '2808095232', '27311227']
and this is correct. This means that a user has entered 12 for the
artikel_id 2808095658.
How can I get the single values, so that I can use them?
How can I extract the values from the list to use the tuple in a
sql-statement?
Help would be great.
Thanxs
Borno
--
Sent through GMX FreeMail - http://www.gmx.net
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )