All pastes #926821 Raw Copy code Copy link Edit

zope-mysql selectAllMethod not r

public text v1 · immutable
#926821 ·published 2008-03-03 21:17 UTC
rendered paste body
selectAllMethod contains:

select * from cmdb_device

In test, returns big table with all these columns

Id  	Name  	Os  	Domain  	Cluster  	Role  	Hwtype  	Gateway  	Arch  	Site  	Location  	Power volts  	Power amps  	Memory type  	Memory slots  	Memory installed  	Timezone  	Manufacturer  	Model  	Processor speed  	Processor arch  	Bios manufacturer  	Bios version  	Asset id  	Description  	Serial number  	Purchase date  	Installed date  	Warranty expires  	Circuit id  	Contract number  	Enclosure number  	Name in enclosure  	Username  	Item id  	Owners  	Sandependent  	Disk number  	Power watts  	Weight  	Psu number  	Connects  	Device status  	Leased from  	Leased end


In the example, they example at:  http://www.devshed.com/c/a/Zope/Zope-And-MySQL/4/ they use a page called "list"
I am actually trying to modify deviceHardwareDetail to put info from my own mysql db in there, rather then what zenoss fineds.

deviceHardwareDetail contains:  

<dtml-var standard_html_header>
<h2>Devices</h2>
<ul>
<dtml-in selectAllMethod>
<li><dtml-var name> 
<br>
<font size="-1"><a href="edit?id=<dtml-var id>">edit</a> | <a
href="delete?id=<dtml-var 
id>">delete</a></font>
<p>
</dtml-in>
</ul>
<a href="add">Add 
a new DVD</a>
<dtml-var standard_html_footer>


____________


The result just looks like this, with a blank bullet point:

Devices

    *


      edit | delete

Add a new DVD