Other choices allowed

[Roger]

I have a "single select" option selected from "administration" for a field that has several options listed in a "drop down" box, using the "Option to Include". This works fine. If I check "Other choices allowed", when "adding" a record it allows "input" to the right of the "drop down", which I thought was for options other than those listed in the drop down box. The problem is that when I do enter something in the "other" input box, it never appears in the database, or in the record when viewed. What gives? Am I using this option the wrong way??

Thanks

 

[Eugenio]

Roger wrote:

> I have a "single select" option selected from
> "administration" for a field that has several options listed in
> a "drop down" box, using the "Option to Include". This works
> fine. If I check "Other choices allowed", when "adding" a
> record it allows "input" to the right of the "drop down", which
> I thought was for options other than those listed in the drop
> down box. The problem is that when I do enter something in the
> "other" input box, it never appears in the database, or in the
> record when viewed. What gives? Am I using this option the
> wrong way??

No, you are using the option in the correct way, please post here the dump of your db (including DaDaBIK tables) in order to understand where the problem is.



(Latest version of DaDaBIK when this message was posted: 2.2.1)

 

[Roger]

DaDaBIK Table Dump:

Database IT - Table dadabik_2_ipipxtable running on localhost
# phpMyAdmin SQL Dump
# version 2.5.3
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Feb 19, 2004 at 08:33 AM
# Server version: 3.23.54
# PHP Version: 4.2.2
#
# Database : `IT`
#

# --------------------------------------------------------

#
# Table structure for table `dadabik_2_ipipxtable`
#

CREATE TABLE `dadabik_2_ipipxtable` (
`name_field` varchar(50) NOT NULL default '',
`label_field` varchar(255) NOT NULL default '',
`type_field` enum('text','textarea','password','insert_date','update_date','date','select_single','select_multiple_menu','select_multiple_checkbox','generic_file','image_file','ID_user','password_record') NOT NULL default 'text',
`content_field` enum('alphabetic','alphanumeric','numeric','web','email','phone','city') NOT NULL default 'alphanumeric',
`present_search_form_field` enum('0','1') NOT NULL default '1',
`present_results_search_field` enum('0','1') NOT NULL default '1',
`present_details_form_field` enum('0','1') NOT NULL default '1',
`present_insert_form_field` enum('0','1') NOT NULL default '1',
`present_ext_update_form_field` enum('0','1') NOT NULL default '1',
`required_field` enum('0','1') NOT NULL default '0',
`check_duplicated_insert_field` enum('0','1') NOT NULL default '0',
`other_choices_field` enum('0','1') NOT NULL default '0',
`select_options_field` text NOT NULL,
`foreign_key_field` text NOT NULL,
`db_primary_key_field` varchar(255) NOT NULL default '',
`select_type_field` varchar(50) NOT NULL default 'exactly/like/>/<',
`prefix_field` text NOT NULL,
`default_value_field` text NOT NULL,
`width_field` varchar(5) NOT NULL default '',
`height_field` varchar(5) NOT NULL default '',
`maxlength_field` varchar(5) NOT NULL default '100',
`hint_insert_field` varchar(255) NOT NULL default '',
`order_form_field` smallint(6) NOT NULL default '0',
`separator_field` char(2) NOT NULL default '~',
PRIMARY KEY (`name_field`)
) TYPE=MyISAM;


MYSQL Table Dump:
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Feb 19, 2004 at 08:29 AM
# Server version: 3.23.54
# PHP Version: 4.2.2
#
# Database : `IT`
#

# --------------------------------------------------------

#
# Table structure for table `ipipxtable`
#

CREATE TABLE `ipipxtable` (
`Record` int(6) NOT NULL auto_increment,
`IPAddress` varchar(16) NOT NULL default '',
`HostNameDescrip` varchar(128) NOT NULL default '',
`Comments` varchar(32) NOT NULL default '',
`IPXAddress` varchar(8) NOT NULL default '',
`ServerID` varchar(8) NOT NULL default '',
PRIMARY KEY (`Record`),
UNIQUE KEY `IPAddress` (`IPAddress`)
) TYPE=MyISAM AUTO_INCREMENT=1140 ;

 

[Eugenio]

Roger wrote:

[....]

Duplicated post, see here:

http://www.dadabik.org/forum/read.php?f=1&i=1645&t=1645



(Latest version of DaDaBIK when this message was posted: 2.2.1)