Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Comma added to userstatus field in table farUser "active," (OpenBD)

Description

Created a new user, filled in the fields User ID, Password (and confirm password) and save - when I look in the database the field "userstatus" reads "active," in the farUser table. That new user is unable to log in, due to that comma (account is disabled). If that comma is removed, it works fine.

I have tested this in both IE7 and FF2 - and I get the same result, just in case it would a be a browser issue.

It is probably due to some incompability in OpenBD that this manifests itself.

Snooped around a bit in the files to find out more about the ORM, and how the form results make it into the database, but I couldn't find anything too obvious...

Environment

OpenBD of Nov 19 2008, Tomcat 5.5, Apache 2.2, MSSQL 2005

Attachments

1

Activity

Show:
Matthew Bryant
January 8, 2009 at 8:56 AM

Now deleting leading and trailing commas (,) from formtool:list properties.

Matthew Bryant
January 6, 2009 at 5:50 PM

Re-added hidden field as its required for when the select has a parameter of select multiple. In this case, if the user does not select an option, the hidden field ensures that an empty string is submitted. Otherwise, if nothing was submitted (ie. without the hidden field) the previous value would not be overridden. We need to sort this out with BD as their functionality differs from ColdFusion and Railo.

Matthew Bryant
January 6, 2009 at 1:44 AM

Removed hidden field for ftRenderType: Dropdown.

Thanks Hugo.

Former user
November 21, 2008 at 11:15 AM

I did some more digging in the innards of the processing there, but I see that there are actually two fields in the form in the webtop form (when I examine the source) - one hidden in addition to the select box for status, and that is submitted by the browser with a comma (the hidden value is empty, so it looks like 'active,') - I think that is standard.

So the bug is related to the form processing.

I see this on line 67 of core\packages\formtools\list.cfc - don't know what purpose this serves.

Fixed

Details

Assignee

Reporter

Components

Fix versions

Affects versions

Priority

Created November 20, 2008 at 9:38 PM
Updated January 8, 2009 at 8:56 AM
Resolved January 6, 2009 at 11:09 PM