Problem displaying Informix INTERVALs using DTML
Hi, I am using Zope on a PC running on NT and using ODBC to connect to a Informix database. I am running a query that returns a column of INTERVAL type, calculated by subtracting to DATE types. The query, when tested using the test tab, displays the results as I expected. However, when I try to display the results using either a search interface, or my own DTML method, NETSCAPE 4.7 refuses to display the results. Instead it reckons it cannot handle the resultant HTML from the DTML used to produce the results page. Instead, it decides the best thing to do is save the file but when it is reloaded it load just fine. IE5 does get a little further and it will display the page but there are numerous strange characters at the end of the expected interval field. This seems like some additional characters are coming back from the query and they may cause Netscape to trip up and IE5 to display odd characters. What I have tried to do, without sucess, is to get access to the DTML, within Zope, which produces the results of a test on an SQL query. This is where the solution lives!, but I plain just can't find it. I have tried formating the the INTERVAL type and truncating but nothing yields the same results as the 'test' DTML. Any ideas for a poor Zope newbie. Thanks Raymond
Hi all! I've successfully installed current releases of ZPatterns, LoginManager and "Membership". This Membership product comes up with some nice high level methods / forms for the common procedures, but still doesn't help me with my basic LoginManager question: How do I add users? I can see there's a UserSource, and its property sheet "storage" says something about "LoginUser"s (resp. "LoginMember"s), and that they are to be "stored persistently", "directly in this object". Now how does this happen? (I would like to put my users in a gadfly db, because they are <500, but not ZODB because too many transactions will happen) What am I supposed to do? TY VM IA Danny
Danny William Adair wrote:
Hi all!
I've successfully installed current releases of ZPatterns, LoginManager and "Membership". This Membership product comes up with some nice high level methods / forms for the common procedures, but still doesn't help me with my basic LoginManager question: How do I add users? I can see there's a UserSource, and its property sheet "storage" says something about "LoginUser"s (resp. "LoginMember"s), and that they are to be "stored persistently", "directly in this object". Now how does this happen?
(I would like to put my users in a gadfly db, because they are <500, but not ZODB because too many transactions will happen)
What am I supposed to do?
First: Remember that all of the above are either _alpha_ or beta, AFAIK. IOW, not aimed at production/still in development. That will make the rest of it come into perspective, and help keep blood pressure form spiraling ;^) Next: For membership, you add members by 'joining the site'. That is what Membership's intent is, so of course it won't provide documentation on how to do the above. To use your gadfly db for users would mean you need to write a Usersource fo rLogin Manager that would do this. Membership, and the default LoginManager stuff does not (yet) do this. For details on how to do this see http://www.zope.org/Members/tsarna/LoginManager/Help/API.txt and post questions on this to zope-dev, since that is the appropriate list. Bill Anderson
TY VM IA Danny
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- Do not meddle in the affairs of sysadmins, for they are easy to annoy, and have the root password.
participants (3)
-
Bill Anderson -
Danny William Adair -
Raymond Kelly