M
Michael Workman
Guest
I am using databik 3.0 beta..
I have a simple table
CREATE TABLE `area` (
`area` varchar(35) NOT NULL default '',
`sort` tinyint(5) NOT NULL default '0',
PRIMARY KEY (`area`),
UNIQUE KEY `area` (`area`)
) TYPE=MyISAM;
that i am using to provide a drop down on the area field in this table:
CREATE TABLE `issue` (
`key` tinyint(5) NOT NULL auto_increment,
`area` varchar(35) NOT NULL default '',
`issue` varchar(35) NOT NULL default '',
`sort` tinyint(5) NOT NULL default '0',
PRIMARY KEY (`key`),
UNIQUE KEY `issue` (`issue`)
) TYPE=MyISAM AUTO_INCREMENT=33 ;
I defined in Dadabik via interface creator on the issue table as follows:
Primary key field ---- area
Primary key table ---- area
Linked fields ---- area
That seems to work as i want it to...in adding records...however...when i try to display the records via dadabik...it gives an error 08 and generates the SQL as follows.
SELECT `issue`.`key`, `issue`.`area`, `issue`.`issue`, `issue`.`sort`, `area`.`area` FROM issue LEFT JOIN `area` ON `issue`.`area` = `area`.`area` ORDER BY issue.key ASC LIMIT 0 , 10
I dont see what i have done wrong, Do YOU?
Thanks in advance for your help
I have a simple table
CREATE TABLE `area` (
`area` varchar(35) NOT NULL default '',
`sort` tinyint(5) NOT NULL default '0',
PRIMARY KEY (`area`),
UNIQUE KEY `area` (`area`)
) TYPE=MyISAM;
that i am using to provide a drop down on the area field in this table:
CREATE TABLE `issue` (
`key` tinyint(5) NOT NULL auto_increment,
`area` varchar(35) NOT NULL default '',
`issue` varchar(35) NOT NULL default '',
`sort` tinyint(5) NOT NULL default '0',
PRIMARY KEY (`key`),
UNIQUE KEY `issue` (`issue`)
) TYPE=MyISAM AUTO_INCREMENT=33 ;
I defined in Dadabik via interface creator on the issue table as follows:
Primary key field ---- area
Primary key table ---- area
Linked fields ---- area
That seems to work as i want it to...in adding records...however...when i try to display the records via dadabik...it gives an error 08 and generates the SQL as follows.
SELECT `issue`.`key`, `issue`.`area`, `issue`.`issue`, `issue`.`sort`, `area`.`area` FROM issue LEFT JOIN `area` ON `issue`.`area` = `area`.`area` ORDER BY issue.key ASC LIMIT 0 , 10
I dont see what i have done wrong, Do YOU?
Thanks in advance for your help