数据库中的值未显示在 PloneFormGen 中

发布于 2024-12-21 04:24:15 字数 930 浏览 2 评论 0原文

我遵循了 SteveM 的关于使用 PloneFormGen 进行 SQL CRUD 的操作方法。该表单有 3 个字符串字段： uid、string1 和 string2。我能够通过示例表单将数据写入数据库，并且所有 Z 方法在 ZMI 中测试正常。但是，formSetup 脚本没有按我的预期工作。

这是 fromSetup 脚本

request = container.REQUEST
form = request.form

if form.has_key('uid') and not form.has_key('form.submitted') :
    res = context.testReadRow().dictionaries()
    if len(res) == 0:

container.REQUEST.RESPONSE.redirect(context.portal_url()+'/add-new-employee')
    else:
        row = res[0]
        for key in row.keys():
            form[key] = row[key]

通过 URL 传递不在数据库中的 uid，正确重定向到 add-new-employee 表单。

传递数据库中的 uid，用传递的值填充 uid 文本框，但 string1 和 string2 文本框为空。

如何从 testReadRow 获取值以显示为 string1 和 string2 中的默认值？我错过了什么吗？

原文

I have followed SteveM's How-To on SQL CRUD with PloneFormGen. The form has 3 string fields:
uid, string1 and string2.
I'm able to write data to the database via the example form and all the Z methods test ok in the ZMI. However, the formSetup script is not working as I expected.

Here's the fromSetup script

request = container.REQUEST
form = request.form

if form.has_key('uid') and not form.has_key('form.submitted') :
    res = context.testReadRow().dictionaries()
    if len(res) == 0:

container.REQUEST.RESPONSE.redirect(context.portal_url()+'/add-new-employee')
    else:
        row = res[0]
        for key in row.keys():
            form[key] = row[key]

Passing, via URL, a uid that IS NOT in the database, correctly redirects to add-new-employee form.

Passing a uid that IS in the database, populates the uid text box with the value passed, but string1 and string2 text boxes are empty.

How do I get the values from testReadRow to show as the defaults in string1 and string2?
Am I missing something?

分享到QQ

分享到微博