Other choices allowed?

E

eugene

Guest
Can someone explain what the internal table manager admin option named:

'Other choices allowed?'

does exactly??

I cant find in documentation.

thanks :)
 
R

Roger

Guest
Did you get this to work???? If so would you mind sharing with me?? I can't seem to get this option to "add" information I enter in this field to update in the database.

Thanks
 
E

Eugenio

Guest
Roger wrote:

> Did you get this to work???? If so would you mind sharing
> with me?? I can't seem to get this option to "add" information
> I enter in this field to update in the database.

Do you still have the problem? If yes, post here the dump of your db.


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

Roger

Guest
I don't mean to sound dumb, but how exactly to I do a dump and post.

Thanks
 
R

Roger

Guest
# 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 ;


DaDaBik 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;
 
E

Eugenio

Guest
Roger wrote:

[....]

I need the data too, not only the tables structures.



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

Roger

Guest
Eugenio, I am emailing you the data in "zip" form. It is too much to post here. Thank you for your help.
 
R

Roger

Guest
DaDaBik table, values. I emailed the MYSQl data as it was too much to post here.

INSERT INTO `dadabik_2_ipipxtable` VALUES ('Record', 'Record', 'text', 'alphanumeric', '0', '0', '0', '0', '1', '0', '0', '0', '', '', '', 'exactly/like/>/<', '', '', '', '', '100', '', 1, '~');
INSERT INTO `dadabik_2_ipipxtable` VALUES ('IPAddress', 'IPAddress', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '1', '1', '0', '', '', '', 'exactly/like/>/<', '', '', '', '', '100', '', 2, '~');
INSERT INTO `dadabik_2_ipipxtable` VALUES ('HostNameDescrip', 'HostNameDescrip', 'select_single', 'alphanumeric', '1', '1', '1', '1', '1', '1', '0', '1', '', 'SQL: select distinct HostName, DeviceType, Descrip from devicetable order by HostName', '', 'exactly/like/>/<', '', '', '', '', '128', '', 3, '~');
INSERT INTO `dadabik_2_ipipxtable` VALUES ('Comments', 'Comments', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', 'exactly/like/>/<', '', '', '', '', '100', '', 4, '~');
INSERT INTO `dadabik_2_ipipxtable` VALUES ('IPXAddress', 'IPXAddress', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', 'exactly/like/>/<', '', '', '', '', '100', '', 5, '~');
INSERT INTO `dadabik_2_ipipxtable` VALUES ('ServerID', 'ServerID', 'text', 'alphanumeric', '1', '1', '1', '1', '1', '0', '0', '0', '', '', '', 'exactly/like/>/<', '', '', '', '', '100', '', 6, '~');
 
E

Eugenio

Guest
Roger wrote:

> DaDaBik table, values. I emailed the MYSQl data as it was
> too much to post here.

[....]

You have missed the dump of devicetab (and relative dadabik_ table) table! Please check that all the infos needed are included before posting.



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

Roger

Guest
I found the problem. It is working fine. Thank you for pointing me in the right direction. I discovered it when looking at the structure after doing a dump. I had a field labeled wrong.

Thanks again.
 
You must log in or register to reply here.
Top