- Zope - Zope lists

Last Insert ID?
by 3205 5361 1215 9784 27 Aug '02

27 Aug '02

Hello zope, how can i get the last_insert_id() from mysql? i have a zsql function : select last_insert_id() as last_id but this doesnt work... k -- don't believe everything you think

2 1

Passing lists through forms
by Colyn Brown 26 Aug '02

26 Aug '02

I've been struggling with trying to pass a list though a form on one page (method1) to a another page (method2). Now it sounds pretty straight forward, but for some reason I cannot get it to work. Here's what I have for method1: <form action=method2 method=post> <dtml-call "REQUEST.set('myIDS',[])"> <dtml-in mySQL_query> <dtml-call "myIDS.append(idFromQuery)"> </dtml-in> <input TYPE="hidden" name="myIDS:list" value=" <dtml-var myIDS> "> <input type="Submit" VALUE=" Submit "> </form> Then in method2 I just put the REQUEST to see what got passed: form myIDS [" ['8', '1', '2', '3', '4', '5', '6', '7'] "] As you can see, myIDS got turned into a ONE item list that contains a string that LOOKS like a list. What have I missed? I think I remember doing this before with no problems. I can't figure out what I'm doing wrong this time. Oh yeah, I figured out a way to turn that string into a list using string.replace to remove the brackets and then string.split on the commas to turn it into a workable list. I don't know about any of you, but to me that seems like way too much work for something that I know can be done a lot simpler. ------- Colyn Brown _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com

1 0

dcoracle2 and zoracleda
by Pierce, Scott 26 Aug '02

26 Aug '02

Figured it out. I had two DCOracle2 products, one in lib/python/Products and one in $INSTANCE_HOME/Products. Not sure how. The other problem I was having was due to the zope user not having ORACLE_HOME set. Running: * Zope version: (Zope 2.4.4b2 (binary release, python 2.1, linux2-x86), python 2.1.3, linux2) * Python version: 2.1.3 (#1, Apr 15 2002, 11:13:45) [GCC 2.7.2.3] * System Platform: linux2 With DCOracl2 version 2.1.1 installed I show DCOracl2 and ZOracleDA in Product Management screen but they do not show in the drop-down to add an item? I know this is something I am just not thinking straight about and am looking right past it. Anybody help me clear my head? Scott Pierce Sonopress LLC - Digital Services 828.658.6157

1 0

ignore this
by Matt Burleigh 26 Aug '02

26 Aug '02

-- Matt Burleigh Zope Managed Hosting - Zope Corporation http://www.zope.com http://www.zope.org

1 0

dcoracle2 and zoracleda
by Pierce, Scott 26 Aug '02

26 Aug '02

Running: * Zope version: (Zope 2.4.4b2 (binary release, python 2.1, linux2-x86), python 2.1.3, linux2) * Python version: 2.1.3 (#1, Apr 15 2002, 11:13:45) [GCC 2.7.2.3] * System Platform: linux2 With DCOracl2 version 2.1.1 installed I show DCOracl2 and ZOracleDA in Product Management screen but they do not show in the drop-down to add an item? I know this is something I am just not thinking straight about and am looking right past it. Anybody help me clear my head? Scott Pierce Sonopress LLC - Digital Services 828.658.6157

1 0

Fix broken python on Mac OS X version 10.2
by Jens Vagelpohl 26 Aug '02

26 Aug '02

sorry for the crossposting, here's a little heads-up for the mac OS X crowd: upon upgrading to 10.2 (jaguar) you will most likely find that your python binary (along with most other self-compiled software) is broken. in the case of python a simple re-build (if you compiled from source, that is) fixes this. i added explicit instructions to the "Zope and Python on Mac OS X" HowTo at http://www.zope.org/Members/jens/docs/zope_osx i highly recommend re-building zope after that as well. jens

3 4

Re: [Zope] redirect strangeness ...
by Dennis Allison 26 Aug '02

26 Aug '02

> To debug this problem, you might want to use the nice tcpwatch (-> > google). It acts as a proxy but displays the complete http conversation > in a window. Thanks for the pointer... > > Another remark to your redirects, AFAIK the the rfc mandates to redirect > to complete URLs, not just the relative link. I don't know offhand if > zope "fixes" you redirect, but I would use something like > absolute_url()+'/index_html' as a target instead. > That might be the problem although I have used relative URLS in redirects without problems in other contexts. I checked the Zope docs for this restriction and didn't find any information. Might you have a pointer? Thanks.

2 1

RE: [Zope] redirect strangeness ...
by Dennis Allison 26 Aug '02

26 Aug '02

"Charlie Reiman" <creiman(a)kefta.com> comments: > > Since you aren't generating any HTML, there is no advantage to using DTML. > Just use python scripts. > Agreed, but this is a collegue's code before she learned Python.

1 0

RE: [Zope] Crypt equivalent for Zope?
by Schmidt, Allen J. 26 Aug '02

26 Aug '02

I'm interested in this also. We use UBB for forums and I think it uses crypt to handle the password stuff. I want access to those users and their info inside Zope. Mainly for authentication. Ideas? Thanks -Allen -----Original Message----- From: zope-admin(a)zope.org [mailto:zope-admin@zope.org]On Behalf Of Oliver Bleutgen Sent: Monday, August 26, 2002 2:09 PM To: Alec Munro Cc: zope(a)zope.org Subject: Re: [Zope] Crypt equivalent for Zope? Alec Munro wrote: > Hi all, > I'm storing users in Mysql, and doing custom authentication on them. I > want to know if Zope has access to the crypt function, or if there is > something equivalent that is preferred. Thanks. > > Alec Munro No, there isn't AFAIK, I use an external method for that purpose. But since you're using MYSQL, it has various built-in functions which might fit you purposes. See http://www.mysql.com/doc/en/Miscellaneous_functions.html HTH, oliver _______________________________________________ Zope maillist - Zope(a)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 )

1 0

Urgent!!! Help needed with DCOracle2 + Stored procedure + Oracle9i
by alienoid 26 Aug '02

26 Aug '02

Hello zope users, I need your help. RH7.2 + Zope2.5.1 + DCOracle2 + Oracle9i When I try to test stored procedure from within ZMI I get: 'ORA-01460: unimplemented or unreasonable conversion requested' I tried with different procedures and functions - result is the same. >From the command line python I get: Traceback (most recent call last): File "db.py", line 4, in ? c.procedure.test_it('n') File "/usr/lib/python2.2/site-packages/DCOracle2/DCOracle2.py", line 1344, in __call__ cursor.execute(sql,__plist=args) File "/usr/lib/python2.2/site-packages/DCOracle2/DCOracle2.py", line 903, in execute result = self._cursor.execute() dco2.DatabaseError: (1460, 'ORA-01460: unimplemented or unreasonable conversion requested') test_it() code: create or replace procedure test_it(p in varchar2) return binary_integer is begin return 1; end; But another procs do no work too. These procedures work when I call them within PL/SQL code. Yout help, suggestions are very, very, very appreciated. -- Best regards, alienoid mailto:alienoid@is.lg.ua

1 0