You can do it with temporary tables.
Like this-
create temporary table foo (
note_id int,
notes varchar
);
insert into foo select Note.note_id, Note.notes from Note, Artist
where Note.note_id=Artist.note_id and Artist.artist_id=23;
update foo set notes="asdlfna";
replace into Note select n
What version of Zope are you using?
Urvashi Singh wrote:
>
> Hi,
>
> I am a new user of Zope. I have Zope--linux2-x86.tar.gz bundle installed
> on my Linux machine, up and working. While I was trying to create a simple
> page using dtml files, I wanted to upload a few files from my hard drive
>
I'm there, just let me know when and where.
Monty
>> Original Message <<
On 7/11/00, 3:40:08 PM, Paul Everitt <[EMAIL PROTECTED]> wrote regarding
[Zope] Q: Zope meeting in Paris in August?:
> Hello everybody. I'm chatting with someone in Paris about a possibl
Here's what happenes from me. You can see from the getSource on
PGM140_API that the procedure exists within called select_targets. I
can't get anything to recognize it.
Help?
>>> dbc.getSource('PGM140_API.SELECT_TARGETS')
''
>>> dbc.getSource('PGM140_API')
'PACKAGE PGM140_API IS\012-- PL/SQL S
I have **exactly** the same problem. I've tried 8.1.5 and 8.1.6.
I would LOVE any help anyone could give.
Monty
>> Original Message <<
On 7/6/00, 9:47:09 AM, Ronnie Sengupta <[EMAIL PROTECTED]> wrote
regarding [Zope] Calling Stored Procedures using DCOracle:
So what you want is this...
1) Web page is displayed to client with two fields, 'a' and 'b'.
2) Client enters value in 'a'.
3) Client enters value in 'b'.
4) Client hits 'Submit'.
5) contents of 'b' get added to contents of 'a' and stored in 'a'.
6) Form contents are submitted to form processor.
>> Original Message <<
On 7/4/00, 12:47:07 AM, Andy Dustman <[EMAIL PROTECTED]> wrote regarding
Re: [Zope] MySQL transaction support (was: MySQL Select Statements):
> Note also: With non-transactional databases, you would expect to get
> better performance by h
Why not have one ZmySQLDA that attempts to determine whether it is
transactional or not when the connect method is executed. That way you
could have a DA connect to your 3.22 database, upgrade your database to
>3.23.15 and not see any problems. A combination of try-except:ing an
attempted "beg
It has to do with the new security model. The supuser can no longer own
stuff.
Monty
>> Original Message <<
On 6/26/00, 3:31:02 PM, frank cuzzocrea <[EMAIL PROTECTED]> wrote
regarding [Zope] problem with the beta:
> i am using 2.2 Beta 2 and every time i atte
This is actually fixed in both 1.1.4 and in 1.2.0. The problem has to do
with type conversions from a dictionary in the adapter. Any type of
non-row function or aggregate returns a type of 'unhandled' which was
not mapped in the conversion dictionary. This is fairly much the bug
that called for 1.
was on a Zope news announcement for a while then
> disappeared. Anyway, could you send me the URL to 1.2.0?
>
> Thanks,
> T.J.
>
> - Original Message -
> From: Monty Taylor <[EMAIL PROTECTED]>
> To: T.J. Mannos <[EMAIL PROTECTED]>
> Cc: IPM Retur
I was also trying to accomplish this a while back. I managed to add the
new class with a database connection and execute sql statements. My
class had some stuff like this:
def __init__(self,id,title,dbconn):
self.id=id
self.title=title
self.
Well, I'm not sure why you would need to change versions as I haven't
done any testing of ZMySQLDA on the 2.2 Beta release, but I would
suggest downloading and installing ZMySQLDA 1.2.0. Andy's version,
2.0.0, isn't published because he doesn't really want to provide support
right now. He does hav
Sounds like you didn't get everything when you reverted. Make sure that
you replace everything in the lib/python tree. Remember that MailHost
and ZCatalog live in Products, so if you replaced everything but saved
the Products dir so you wouldn't have to re-install your products, you
might want to
You'll need to add a 'Z MySQL Database Connection' Since you're using
1.1.4, the connection string won't show up in the add dialog. It is of
the form
"database@host user password"
You'll then need to add one or more "ZSQL Method"s to actually do the
work.
Good luck.
Monty
vikas wrote:
>
> Sir
A couple of quick things.
First, thanks for pointing out a problem in my documentation.
That said, what the docs don't make clear is that the posted install
docs are only for the new ZMySQLDA-1.2.0. If you are using
ZMySQLDA-1.1.4, please read the docs in the package, as they are a bit
different
If you're running from the RPM install, I believe it puts the Components
dir somewhere else. (Can't remember, though)
For what it's worth...
Monty
Peter Simmons wrote:
>
> Hi Guys,
>
> I was trying to setup ZPatterns 0.3.0 and I got up to making the
> extension DynPersistc. I had run "make -f
The user/passwd@SID is the correct format. Zope, however, probably has
no clue about your environment variables. I would recommend looking at
the start-up script for Zope and adding the environment variables in
there (ORACLE_HOME is quite important, for one.)
Monty
"Bak @ kedai" wrote:
>
> hull
18 matches
Mail list logo