D
DanW
Guest
Having problems with the: Display ALL
I have 16 tables total.
15 tables - allow for choices that feed into (select single now, on 3.0 beta) 1 table.
So , 15 Support tables, providing some choices into another table named "Systems".
So, I'm working in "Systems"
I'm trying to provide a selection of hardware for field "hw_platform) -
Primary key table: Hardware
Primary key field: id ( which it is in the table) ...
Linked fields: hardware_type
Now, on an new insert or search, the selections ( from Hardware.hardware_type) are properly displayed.
If I choose to "Show all" I get the (way) below error...
If I change to:
Primary key field: <leave blank>
Primary key table: Hardware
Linked fields: hardware_type
The results for SHOW ALL are good, but my selections do not show up as choices on an Insert.
Finally, If I change to:
Primary key field: hardware_type
Primary key table: Hardware
Linked fields: hardware_type
I alsoe end up the below errors....
Your SQL query (for debugging purpose): SELECT `Systems`.`name`, `Systems`.`core_ip`, `Systems`.`hw_platform`, `Systems`.`function`,
`Systems`.`region`, `Systems`.`status`, `Systems`.`notification`, `Systems`.`serial_number`, `Systems`.`asset_tag`, `Systems`.`searchflag`, `Systems`.`business_segment`, `Systems`.`projects`, `Systems`.`admin_rule_pri`, `Systems`.`admin_rule_sec`, `Systems`.`admin_pots_pri`, `Systems`.`admin_pots_sec`, `Systems`.`admin_plandesign_pri`, `Systems`.`address`, `Systems`.`room`, `Systems`.`location_other`, `Systems`.`city`, `Systems`.`state`, `Systems`.`local_contact_name`, `Systems`.`local_contact_phone`, `Systems`.`local_contact_pager`, `Systems`.`interface_info`, `Systems`.`disk_info`, `Systems`.`hardware_info`, `Systems`.`os_info`, `Systems`.`software_info`, `Systems`.`businesspartners`, `Systems`.`notes`, `Systems`.`add_date`, `Systems`.`last_update`, `Systems`.`fw_id`, `Systems`.`checkpoint_info`, `Systems`.`gauntlet_info`, `Systems`.`gated_info`, `Systems`.`ospatch_info`, `Systems`.`route_info`, `Systems`.`arp_info`, `Systems`.`firewall_ver`, `Systems`.`os_ver`, `Hardware`.`hardware_type` FROM Systems LEFT JOIN `Hardware` ON `Systems`.`hw_platform` = `Hardware`.`hardware_type` ORDER BY Systems.name ASC LIMIT 0 , 600
437 records found
[08] Error: during query execution.
SELECT `hardware_type` FROM `Hardware` WHERE `hardware_type` = SUN_E250
MySQL server said: Unknown column 'SUN_E250' in 'where clause'
Where AM I Caching the "SUN_E250"??
I do not see it in the select statement.
If I change the name SUN_E250, I still get an error. IE: Change Name to "BOSCO"
Also, this is not a column. It is an entry in a column.
Your SQL query (for debugging purpose): SELECT `Systems`.`name`, `Systems`.`core_ip`, `Systems`.`hw_platform`, `Systems`.`function`, `Systems`.`region`, `Systems`.`status`, `Systems`.`notification`, `Systems`.`serial_number`, `Systems`.`asset_tag`, `Systems`.`searchflag`, `Systems`.`business_segment`, `Systems`.`projects`, `Systems`.`admin_rule_pri`, `Systems`.`admin_rule_sec`, `Systems`.`admin_pots_pri`, `Systems`.`admin_pots_sec`, `Systems`.`admin_plandesign_pri`, `Systems`.`address`, `Systems`.`room`, `Systems`.`location_other`, `Systems`.`city`, `Systems`.`state`, `Systems`.`local_contact_name`, `Systems`.`local_contact_phone`, `Systems`.`local_contact_pager`, `Systems`.`interface_info`, `Systems`.`disk_info`, `Systems`.`hardware_info`, `Systems`.`os_info`, `Systems`.`software_info`, `Systems`.`businesspartners`, `Systems`.`notes`, `Systems`.`add_date`, `Systems`.`last_update`, `Systems`.`fw_id`, `Systems`.`checkpoint_info`, `Systems`.`gauntlet_info`, `Systems`.`gated_info`, `Systems`.`ospatch_info`, `Systems`.`route_info`, `Systems`.`arp_info`, `Systems`.`firewall_ver`, `Systems`.`os_ver`, `Hardware`.`hardware_type` FROM Systems LEFT JOIN `Hardware` ON `Systems`.`hw_platform` = `Hardware`.`hardware_type` ORDER BY Systems.name ASC LIMIT 0 , 600
437 records found
[08] Error: during query execution.
SELECT `hardware_type` FROM `Hardware` WHERE `hardware_type` = BOSCO
MySQL server
I have 16 tables total.
15 tables - allow for choices that feed into (select single now, on 3.0 beta) 1 table.
So , 15 Support tables, providing some choices into another table named "Systems".
So, I'm working in "Systems"
I'm trying to provide a selection of hardware for field "hw_platform) -
Primary key table: Hardware
Primary key field: id ( which it is in the table) ...
Linked fields: hardware_type
Now, on an new insert or search, the selections ( from Hardware.hardware_type) are properly displayed.
If I choose to "Show all" I get the (way) below error...
If I change to:
Primary key field: <leave blank>
Primary key table: Hardware
Linked fields: hardware_type
The results for SHOW ALL are good, but my selections do not show up as choices on an Insert.
Finally, If I change to:
Primary key field: hardware_type
Primary key table: Hardware
Linked fields: hardware_type
I alsoe end up the below errors....
Your SQL query (for debugging purpose): SELECT `Systems`.`name`, `Systems`.`core_ip`, `Systems`.`hw_platform`, `Systems`.`function`,
`Systems`.`region`, `Systems`.`status`, `Systems`.`notification`, `Systems`.`serial_number`, `Systems`.`asset_tag`, `Systems`.`searchflag`, `Systems`.`business_segment`, `Systems`.`projects`, `Systems`.`admin_rule_pri`, `Systems`.`admin_rule_sec`, `Systems`.`admin_pots_pri`, `Systems`.`admin_pots_sec`, `Systems`.`admin_plandesign_pri`, `Systems`.`address`, `Systems`.`room`, `Systems`.`location_other`, `Systems`.`city`, `Systems`.`state`, `Systems`.`local_contact_name`, `Systems`.`local_contact_phone`, `Systems`.`local_contact_pager`, `Systems`.`interface_info`, `Systems`.`disk_info`, `Systems`.`hardware_info`, `Systems`.`os_info`, `Systems`.`software_info`, `Systems`.`businesspartners`, `Systems`.`notes`, `Systems`.`add_date`, `Systems`.`last_update`, `Systems`.`fw_id`, `Systems`.`checkpoint_info`, `Systems`.`gauntlet_info`, `Systems`.`gated_info`, `Systems`.`ospatch_info`, `Systems`.`route_info`, `Systems`.`arp_info`, `Systems`.`firewall_ver`, `Systems`.`os_ver`, `Hardware`.`hardware_type` FROM Systems LEFT JOIN `Hardware` ON `Systems`.`hw_platform` = `Hardware`.`hardware_type` ORDER BY Systems.name ASC LIMIT 0 , 600
437 records found
[08] Error: during query execution.
SELECT `hardware_type` FROM `Hardware` WHERE `hardware_type` = SUN_E250
MySQL server said: Unknown column 'SUN_E250' in 'where clause'
Where AM I Caching the "SUN_E250"??
I do not see it in the select statement.
If I change the name SUN_E250, I still get an error. IE: Change Name to "BOSCO"
Also, this is not a column. It is an entry in a column.
Your SQL query (for debugging purpose): SELECT `Systems`.`name`, `Systems`.`core_ip`, `Systems`.`hw_platform`, `Systems`.`function`, `Systems`.`region`, `Systems`.`status`, `Systems`.`notification`, `Systems`.`serial_number`, `Systems`.`asset_tag`, `Systems`.`searchflag`, `Systems`.`business_segment`, `Systems`.`projects`, `Systems`.`admin_rule_pri`, `Systems`.`admin_rule_sec`, `Systems`.`admin_pots_pri`, `Systems`.`admin_pots_sec`, `Systems`.`admin_plandesign_pri`, `Systems`.`address`, `Systems`.`room`, `Systems`.`location_other`, `Systems`.`city`, `Systems`.`state`, `Systems`.`local_contact_name`, `Systems`.`local_contact_phone`, `Systems`.`local_contact_pager`, `Systems`.`interface_info`, `Systems`.`disk_info`, `Systems`.`hardware_info`, `Systems`.`os_info`, `Systems`.`software_info`, `Systems`.`businesspartners`, `Systems`.`notes`, `Systems`.`add_date`, `Systems`.`last_update`, `Systems`.`fw_id`, `Systems`.`checkpoint_info`, `Systems`.`gauntlet_info`, `Systems`.`gated_info`, `Systems`.`ospatch_info`, `Systems`.`route_info`, `Systems`.`arp_info`, `Systems`.`firewall_ver`, `Systems`.`os_ver`, `Hardware`.`hardware_type` FROM Systems LEFT JOIN `Hardware` ON `Systems`.`hw_platform` = `Hardware`.`hardware_type` ORDER BY Systems.name ASC LIMIT 0 , 600
437 records found
[08] Error: during query execution.
SELECT `hardware_type` FROM `Hardware` WHERE `hardware_type` = BOSCO
MySQL server