Re: [custom field] >255 entries and from SQL SELECT

Hi Marcel,

Please upgrade your copy of Mantis. v1.0.1 is extremely outdated (by
many years) and is unsafe to use from a security perspective. I strongly
suggest using 1.2.x as it contains all the latest bug fixes and will be
much better supported if you need help.

Also I don't understand why "populate" and "SQL SELECT" should be in the
same sentence? I assume what you're trying to do is create a custom
enumeration field which has 1500 names within? You can manually run a
query like:

UPDATE mantis_custom_field_table SET possible_values = '...huge list of
names...' WHERE id=X

X is the id of the custom field you have already created.

You'd then need to ensure that you have parsed and delimited the names
correctly so you don't end up with a situation like http://xkcd.com/327/

I strongly suggest the feature I have described above be implemented
with a plugin rather than a custom field. Custom fields won't really
work nicely with huge enumerations because Mantis has to parse a massive
string of text (possible_values) from the database and then it'll create
<option> dropdowns with 1500 options presented to the user. With your
own Mantis plugin, you can create your own database table (or use an
existing one elsewhere) to check if the values provided are valid.

Regards,

David



On Wed, 2009-07-29 at 15:55 +0200, Marcel Ducamion wrote:
> Hello everybody
> 
> Apologize me for my (very) poor english
> 
> I use Mantis 1.0.1
> I have custom fields "text" (type == 0) for person's name, with a lot of
> mistake by operator
> 1500 person's name are possible and defined
> Can i populate an custom field "enumeration" (type == 3), by an SQL
> SELECT, with 1500 rows dataset ?
> 
> Thanks by advance
> 
> p.s. This message are cross-posted in forum
> http://www.mantisbt.org/forums/viewforum.php?f=3
> 
> 
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
> trial. Simplify your report design, integration and deployment - and focus on 
> what you do best, core application coding. Discover what's new with 
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> mantisbt-help mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/mantisbt-help

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july

_______________________________________________
mantisbt-help mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mantisbt-help

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.11 (GNU/Linux)

iEYEABECAAYFAkpyabEACgkQ5klVxIINWqZ9yQCfQCYlDJoohUwUZtudYrvyC19E
xh8An1TZJ49khzDWwIY1GXPcEHej5+Io
=0fOT
-----END PGP SIGNATURE-----