- Zope - Zope lists

how to check if the ResultSet is null?
by Sa 13 Jul '00

13 Jul '00

Hi, I stuck on a problem: I am creating a registration form. I need to check if the person info has already in database. I created a Z SQL method which I used "select usr_email from info(table name) where usr_email = <dtml-sqlvar usr_email type=string>" I want to call this method from my dtml method and see if it returns "null". But I'm not sure how to implement this. In Java, it has ResultSet which I can check if it returns null. I'm not sure how to accomplish this in Zope. I could not find relevant document. If you know this, could you give me a hand? Thanks! Sa

4 3

Linux user group
by CURTIS David 13 Jul '00

13 Jul '00

Greetings, I am a member of the a Linux users group and I have been asked to do a demo on ZOPE because I am using it and many members are curious. I consider myself a ZOPE newbie, because use I use ZOPE to access some really simple databases. I have NOT done any special python programming (but not for lack of trying) but would like some input on what I should say about ZOPE. 1) Is there a ZOPE demo for that runs on a CDROM? 2) What is the best way to present ZOPE? Any help would be apprechiated. Thanks

1 0

2.1.6 and ZSQL methods
by The Sanfords 13 Jul '00

13 Jul '00

Like an idiot I blythly ignored all the emails flying back and forth concerning the problems with 2.1.6 and ZSQL methods because I was not using 2.1.6 and didn't plan on upgrading my 2.1.4 until the 2.2 was stable. Hah!!! Was the issue ever resolved? I really need for my 2.1.4 ZSQL methods to work in 2.1.6. Does anyone know of a patch or other workarounds? mea culpa. Jim

2 1

SyabaseDa SP problem
by Mathias Bengtsson 13 Jul '00

13 Jul '00

I have the following problem. I run Zope under RH6.2 with Apache and SyBase through SyBaseDA. I have gorren the connection to work so that I can make simple SQL questions. The problem I have arise when I try to run an SQL StoreProcedure that lies in SyBase. At first it didn't wokr att all but after I changed the connection to not supporting transaction it worked better. But not good. I can call upon this SP one time. (the test SP I use does an simple insert(it works)). But I get the error message -- Error, Products.SybaseDAv2.db.Error: Unexpected result type Then the server waits for an answer to it's query. If I now try to use ANY sql methods i get the answer that the server is waiting for an answer and that I can't execute any more SQL's during that time. What can I do to eliminate this problem. Any help is welcome /Mathias Bengtsson

3 2

Re: [Zope] how to check if the ResultSet is null?
by Robert Wohlfahrt 13 Jul '00

13 Jul '00

Hi, > > Hi, I stuck on a problem: I am creating a registration form. I need > to check if the person info has already in database. I created a Z SQL > method which I used "select usr_email from info(table name) where > usr_email = <dtml-sqlvar usr_email type=string>" I want to call this > method from my dtml method and see if it returns "null". But I'm not > sure how to implement this. In Java, it has ResultSet which I can let's say, you called your ZSQL-method "getThisAddress" then you can do something like this: <dtml-if getThisAddress> You are already in the database </dtml-if> Robert -- Robert Wohlfahrt (robert.wohlfahrt(a)sachsen-net.com) Tel: 0179 / 2980074 Fax: 0351 / 2880145

1 0

RE: [Zope] simple instructions for site search
by Jens Vagelpohl 13 Jul '00

13 Jul '00

chris, catalogs don't automatically search other catalogs they find. until this is implemented you could create a separate catalog that only catalogs other catalog instances (and your squishdot instance) and then you could ask that main catalog to give you all its other catalogs and simply fire off the search you want to do on each of them. if your site is very simple and the location/number of catalogs doesn't really change you could also hard-code them into a search page that asks all of them directly. jens > -----Original Message----- > From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On > Behalf Of Chris > Withers > Sent: Thursday, July 13, 2000 04:49 > To: Ethan Fremen > Cc: Sean Kelley; zope(a)zope.org > Subject: Re: [Zope] simple instructions for site search > > > ethan mindlace fremen wrote: > > You want the ZCatalog Howto: > > > > http://www.zope.org/Documentation/How-To/ZCatalogTutorial > > Do catalogs search otehr catalogs they find? > > Only asking 'cos I don't think that'll help him search his > whole site as > the Squishdot postings won't get searched. But, if the above is true, > then it should be okay since Squishdot is now subclassed from ZCatalog > :-) > > cheers, > > Chris

1 0

Newbie->adding content by form
by brocken22＠gmx.de 13 Jul '00

13 Jul '00

Hallo, I'd like a user to add content with a form. The website is made with a framest and content should be added and also the navigation should be updated! I think that's a smaller problem but I didn't find an explanation. I'm very happy about every hint! -- Sent through GMX FreeMail - http://www.gmx.net

1 0

Antwort: RE: [Zope] LoadSite can create a corrupted data.fs ?
by Tino_Wildenhain＠peacock.de 13 Jul '00

13 Jul '00

Hi Jonathan, Jonathan Desp, 12.07.2000 23:27:03 >Hi, > >How I can make a regular backup ? How I can restore it ? I cannot log in. >it's 100% corrupted. Uhm. As far as I practice, I make backups of the filesystem on a regular basis. If you replace the Data.fs with an older version without the corruption, it does work. Thats why backups are usually made ;) Regards Tino Wildenhain

1 0

MySQL LIKE operator
by Aaron Williamson 13 Jul '00

13 Jul '00

Hello, I'm writing a search query to a MySQL database. I want to keep people from screwing around with my database by running searches like "; delete from ... yada yada. So I should use <dtml-sqlvar>, right? But what if I want to use LIKE? If I say: WHERE goo LIKE "%<dtml-sqlvar name=bar type=string>%" then effectively I am saying: WHERE goo LIKE "%'somestring'%". In other words, it will match only the string with the single quotes. I hope this makes sense. Has anyone faced a similar problem? Thanks for any help --Aaron

3 2

I want to assign the values of parameters in a form to another parameter in the same form?
by Sean G Richards 13 Jul '00

13 Jul '00

Dear Zope list, I want to cat the values of parameters, all strings, in a form to another parameter in the same form. How would I go about doing this using dtml? -- Sean G. Richards : Web Technician/Treasurer PLUG Purdue University : Engineering Computing Network seangr(a)purdue.edu :

2 1