Well, I guess it was my bet ... solaris uses 'crle' for the ld
configuration. I included the mysql-lib directory and it seems to work
now.
On Wed, 2009-01-21 at 06:20 +0530, Chetan Kumar wrote:
> On Wed, Jan 21, 2009 at 3:19 AM, SolidEther wrote:
> > ImportError: ld.so.1: python: fatal: libmysqlc
Hi Everyone,
I am having trouble to make use of a compiled version of MySQL-
python-1.2.2 with Zope/Python under OpenSolaris snv_101b.
I installed Zope/Plone (running) and need mysql-python to be compiled
with the python version (2.4) that came with zope. I further compiled
MySQL 5.1.30 and
On 15.10.2008 13:16 Uhr, [EMAIL PROTECTED] wrote:
hello everybody!
this is a 50%zope and 50%mysql question..hope somebody here will help me..:-)
in PC1: are running a mysql and zope+Plone server. A zsql method imports a csv
file into mysql using a LOAD DATA LOCAL INFILE and all runs OK when the
hello everybody!
this is a 50%zope and 50%mysql question..hope somebody here will help me..:-)
in PC1: are running a mysql and zope+Plone server. A zsql method imports a csv
file into mysql using a LOAD DATA LOCAL INFILE and all runs OK when the file
is in the PC1 filesystem.
I know that "LOCA
On 16/07/2008 Peter Bengtsson wrote:
> I don't have an easy answer but if you do dig into Andy's code and try
> to implement this, I would suggest you look at the ZPsycopgDA code
> perhaps and look for inspiration since I think that one works much
> better.
Thanks, but finally I found an easier so
I don't have an easy answer but if you do dig into Andy's code and try
to implement this, I would suggest you look at the ZPsycopgDA code
perhaps and look for inspiration since I think that one works much
better.
2008/7/16 Jonas <[EMAIL PROTECTED]>:
> Hello,
>
> On several zope 2.10.6 instances w
Hello,
On several zope 2.10.6 instances we discovered issues with database
connections to MySQL. Apparently MySQL seems to not automaticly
reconnect connections with a timeout since version 5.0.3 due to issues
with transactions.
Until now, mysql-python was patched to restore that behaviour to
aut
Hi Tino,
Is "I've never used Postgres before and all my web life experience is
MySQL based" reason enough?
:-)
Thanks
Hugo
On Thu, Feb 21, 2008 at 3:31 PM, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> Hugo Ramos wrote:
> > Well,
> >
> > I went googling for this error... Google gives 1 (one)
Hugo Ramos wrote:
Well,
I went googling for this error... Google gives 1 (one) answer!!! The
worst part is that it's related to django and mod_python.
I guess nobody solved this yet... I'll have to go back to OS X 10.4 (Tiger).
You could also forward to Postgres :-) Unless you have a very spe
Hi Hugo. Yes, that's true but of course you have to consider all of the
other frameworks that apple has already put on your machine. Much of the
problem will come when linking the libraries when compiling. So in fact
it is a bigger issue and requires much of the base software to
recompiled usin
Hello David,
It makes sense to me! The only thing I was using as a binary was
Python 2.4.4 universal binary.
I guess if I was using Python from the source it should work then.
Thank you very much.
Hugo
On Thu, Feb 21, 2008 at 3:01 AM, David Pratt <[EMAIL PROTECTED]> wrote:
> Hi Hugo. I believe
Hi Hugo. I believe 'file is not of required architecture' may be the
clue here. Ever since mac went to universal binaries, folks with ppc
have been having trouble since it is compiled with i386 arch flags and
vice versa for folks with intel macs (with ppc arch flags). The only way
to get around
Man...
I should buy you a drink at Lisbon when you decide to come here!!! :-)
The binary package works fine now!
I just wish someone would answer about the compilation warning and
import error in Zope.
Thank you very much
Really appreciated
Hugo
On Wed, Feb 20, 2008 at 8:47 PM, Giampiero Ben
Forget it... Just found the file at:
http://pythonmac.org/packages/py24-fat/index.html
Thanks a lot!
Hugo
On Feb 20, 2008 5:57 PM, Hugo Ramos <[EMAIL PROTECTED]> wrote:
> Where did you get that file? MySQL-Python at sourceforge?
>
>
> Thanks
>
>
> On Feb 20, 2008 5:28 PM, Giampiero Benvenuti
>
Where did you get that file? MySQL-Python at sourceforge?
Thanks
On Feb 20, 2008 5:28 PM, Giampiero Benvenuti
<[EMAIL PROTECTED]> wrote:
> I used MySQL_Python-1.2.1_p2-py2.4-macosx10.4.zip with 10.5 and It works
> just fine.
>
> Giampiero
>
>
>
> On Feb 20, 2008, at 8:52 AM, Hugo Ramos wrote:
>
Well,
I went googling for this error... Google gives 1 (one) answer!!! The
worst part is that it's related to django and mod_python.
I guess nobody solved this yet... I'll have to go back to OS X 10.4 (Tiger).
omg...
Thanks
Hugo
On Feb 20, 2008 12:31 PM, Hugo Ramos <[EMAIL PROTECTED]> wrote:
Hello Chetan,
Well thank you very much! I must be very tired to forget to compile
MySQL without --enable-thread-safe-client !!!
It seems that MySQL-python now compiles with a warning:
ld: warning in /usr/local/mysql/lib/mysql/libmysqlclient_r.dylib, file
is not of required architecture
But when
Hey Kumar,
I like to think that the amount of time I could make anyone here spend
looking for something is VERY well spent.
That link you sent me is just 1 of the about 50 I searched on google
before posting the problem. :-)
I can tell you now that cp, mv and ln are not the solution.
I can also t
Yellow ppl,
I'm having a problem I didn't have in OS X 10.4 (tiger)...
When compiling MySQL-python-1.2.2 on OS X 10.5 (leopard) I get a very
annoying error I'm not being able to solve.
I've tried moving, copying and linking libraries around but nothing
seems to work.
Anyone seen this before? Andy
Your right, the older mysql da I was using gave 'Shouldn't Load State
When Connection is Closed'.
It turns out that my DA is implemented correctly, but the database
cursor is being persisted in another object(past transaction commit) as
you noted. So, with some readjusting, the error seems reso
Le Samedi 25 Août 2007 17:07, Kevin a écrit :
> Intermittently, I recieve an error *Shouldn't load state for 0xf5f137
> when the connection is closed
> *
This means there is somewhere a reference to a persistent object which keeps
it past transaction commit, which is a bad behaviour.
> I impleme
I have a mysqldb connector object based on
http://svn.zope.org/mysqldbda/ under zope 2.9.7
Intermittently, I recieve an error *Shouldn't load state for 0xf5f137
when the connection is closed
*
I implemented this object because the standard mysql database adapter
would fail if the connection w
--On 4. Mai 2007 17:34:23 +0200 [EMAIL PROTECTED] wrote:
Hi,
I must use mysql lock/unlock with zsql. I haven't found anything about
it. There is any solutions? I must lock a table but i don't know how do
it :(
Since LOCK is a SQL statement you can *of course* integrate with ZSQL
method
Hi,
I must use mysql lock/unlock with zsql. I haven't found anything about it.
There is any solutions? I must lock a table but i don't know how do it :(
max
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cr
baiewola wrote at 2006-8-9 05:16 -0700:
> ...
>We can connect with PHP apps, Filemaker Pro, and MySQL client. However,
>all Z MySQL database connections are broken. Here is the error:
>OperationalError: (2002, "Can't connect to local MySQL server through
>socket '/tmp/mysql.sock' (2)")
>
>After goo
Yesterday I finally updated my MOSX Server 10.4.6 to 10.4.7. In
addition to usual list of
hosed configuration files and scripts, we now have a problem with Zope
2.7.x connecting to MySQL through a unix socket.
We can connect with PHP apps, Filemaker Pro, and MySQL client. However,
all Z MySQL dat
On Tue, Aug 01, 2006 at 02:50:19PM -0400, Muk Yan wrote:
> Dear Coveted Braintrust,
>
> I was wondering if anyone had any experience with MySQL queries in Python in
> Zope:
People have already answered your main question, but:
> SELECT name
> FROM person
> WHERE ID =
Never ever pass raw user i
Usually you install the database adaptor ZMySQLDB and make queries through
a ZSQL Method object.
On Tue, 1 Aug 2006, Muk Yan wrote:
> Dear Coveted Braintrust,
>
> I was wondering if anyone had any experience with MySQL queries in Python in
> Zope:
>
> import MySQLdb
> import string
>
> reque
import MySQLdb
This is probably redundant.
import string
request = container.REQUEST
session = request.SESSION
result = (context.aq_parent).selects.select_from_table()
print result
Assuming you want the person's name printed, change this line to:
print result[0].name
Think of the resul
--On 1. August 2006 14:50:19 -0400 Muk Yan <[EMAIL PROTECTED]> wrote:
I know the MySQL query works, but I get garbage results from the python
script (). All I
want is to contain the results of the SQL query in a list or container.
Zope Book 2.7 edition -> RDBMS chapter. The result object i
Have a look at this:
http://www.zope.org/Members/spinwing/ZSQL_Results
Jonathan
- Original Message -
From:
Muk Yan
To: zope@zope.org
Sent: Tuesday, August 01, 2006 2:50
PM
Subject: [Zope] MySQL queries in
Python
Dear Coveted Braintrust,I was wondering if
Dear Coveted Braintrust,I was wondering if anyone had any experience with MySQL queries in Python in Zope:import MySQLdbimport stringrequest = container.REQUESTsession = request.SESSION
result = (context.aq_parent).selects.select_from_table()print resultreturn printedWHERE select.select_from_table(
Cameron Beattie wrote at 2006-1-17 17:37 +1300:
>I was getting the following error when attempting to call a stored procedure
>via a Z SQL Method:
>_mysql_exceptions.OperationalError: (1312, etc
You consult your MySQL documentation to find out what the error
code "1312" means...
--
Dieter
_
Yeah, I put up a patch on the MySQLDb Sourceforge page a long time ago for that. Doing almost the same thing. Only I made it so you specify the client flag in the Zope connection object. Doesnt do any good for windows though, they still have a problem with the mysql lib. (I think I posted a bug o
I was getting the following error when attempting to call a stored procedure
via a Z SQL Method:
_mysql_exceptions.OperationalError: (1312, etc
So I made the following change to
/usr/lib/zope/lib/python/Products/ZMySQLDA/db.py:
def _parse_connection_string(self, connection):
kwargs =
Am Donnerstag, den 01.12.2005, 15:45 -0800 schrieb Dennis Allison:
> I have not yet completed differential diagnosis, but I was hoping someone
> had encountered a similar problem and could pass along a fix/workaround.
>
> The following program fails to do the writes --
>
> import MySQLdb
> init
I have not yet completed differential diagnosis, but I was hoping someone
had encountered a similar problem and could pass along a fix/workaround.
The following program fails to do the writes --
import MySQLdb
initdb='test'
dbuser = 'root'
dbpass = 'XX'
host = 'localhost'
connection = MySQ
I guess it's not a matter of should, but rather a preference. I
am running it just fine on Linux. Had to do some tweeks to the
ZMySQLDA, but it works great. Stored Procedures and
everything. I just havent seen hardly anyone testing it, so I
thought I would ask around and see if others are runni
Greg Fischer schrieb:
This is totally unimportant, but I was just curious to know if anyone is
running Mysql 5 on Zope right now.
why should one? :)
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or
Richard Smith wrote:
A very quick test shows the basics work just fine (adding a record to a
table and displaying the whole table). Just watch authentication -
they've changed the password algorithms again as in the 3/4 upgrade.
The work around is in the manual.
rats, probably only an issue
Greg Fischer wrote:
This is totally unimportant, but I was just curious to know if anyone is
running Mysql 5 on Zope right now.
That would be some achievement! ISn't MySQL written in C++ or something?
Seriously though, Andy Dustman is your man, maybe try compiling mySQLdb
and seeing if it'll
This is totally unimportant, but I was just curious to know if anyone is running Mysql 5 on Zope right now.
-- Greg Fischer1st Byte Solutionshttp://www.1stbyte.com
___
Zope maillist - Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
** No cros
It turned out there were two different problems at
work here.
First, I had to hard code the paths of my include_dirs
and include_lib.
Second, I didn't realize my bash shell wasn't taking
the export command. I had to edit my bash profile to
set the mysqlclient environment variable (which is the
pa
I installed Plone 2.1 from the binary installer at
plone.org and MySQL 4.1 from the binary at mysql.com.
When attempting to build MySQL-python-1.2.0 on MOSX
10.4.2 client, I get this error:
sh: line 1: mysql_config: command not found
sh: line 1: mysql_config: command not found
running build
runnin
[Reposted with a non-blank Subject field]
We've been seeing this problem for some time. Earlier postings to the
list were helpful in that we have eliminated possible causes, but the
problem has never been resolved. Any assistance in tracking down the
problem and fixing it would be greatly apprec
Yellow Andy,
In fact what you've said works!
That line was missing on db.py and after I inserted it there
everything works the right way.
I guess this thread is now over. Thanks!!!
Cheers
Hugo
On 6/3/05, Andy Dustman <[EMAIL PROTECTED]> wrote:
> On 6/3/05, Hugo Ramos <[EMAIL PROTECTED]> wrot
On 6/3/05, Hugo Ramos <[EMAIL PROTECTED]> wrote:
> Yellow,
>
> I wrote the wrong version.
> I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3
Take a look at ZMySQLDA/db.py:
http://cvs.sourceforge.net/viewcvs.py/mysql-python/ZMySQLDA/lib/python/Products/ZMySQLDA/db.py?rev=
Yellow,
I wrote the wrong version.
I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3
This is the DTML code generating the error:
docdataemissao is a timestamp field in a table like:
200406011023
The traceback:
Error Type: ValueError
Error Value: unsupported format chara
On 6/3/05, Hugo Ramos <[EMAIL PROTECTED]> wrote:
> I already know what exactly makes Zope hang!
> The problem is located at times.py that was installed by MySQL-Python
> 1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip)
This is a package for Python-2.4. Are you using Python-2.4 with
Zope-2.7? If you
I already know what exactly makes Zope hang!
The problem is located at times.py that was installed by MySQL-Python
1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip)
==OLD==
def mysql_timestamp_converter(s):
"""Convert a MySQL TIMESTAMP to a Timestamp object."""
s = s +
Hugo Ramos wrote:
Could anyone explain me why this works in Zope 2.7.0 final and doesn't
work in Zope 2.7.6 final and/or 2.8.0b1 ??
If Zope is really hanging, look at DeadlockDebugger and find out where
it's hanging...
Chris
--
Simplistix - Content Management, Zope & Python Consulting
Yellow,
Could anyone explain me why this works in Zope 2.7.0 final and doesn't
work in Zope 2.7.6 final and/or 2.8.0b1 ??
also when I try this:
Zope hangs!!!
ps: timestampvar is a timestamp var comming from MySQL 4.0.24
tia
--
Hugo Ramos - [EMAIL PROTECTED]
__
On Sun, 28 Jan 2001, Jens Grewen wrote:
> I installed
>
> mySQL-3.23.32
> mySQLdb 0.3.1
> ZmySQLDA 2.0.4
>
> When I change to mediumint (database field description) I get the
> expected 233.
>
> How can I fix this.
You just did. :) If a mediumint is big enough for you, use that. As Ron
point
work with Zope 2.3.0.
___
Ron Bickers
Logic Etc, Inc.
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jens
Grewen
Sent: Saturday, January 27, 2001 11:36 PM
To: Zope Maillist
Subject: [Zope] MYSQL Problem
>From
I installed
mySQL-3.23.32
mySQLdb 0.3.1
ZmySQLDA 2.0.4
on Win98
From the following SQL statment I get the
result 233L and not 233 as expected
select count(PID)from product
When I run this SQL Statment from another program I
get the expected value 233.
In my installation there
On Fri, 26 Jan 2001, Piotr Kozbial wrote:
> I have upgraded to MySQL 3.23.28 and both ZMySQLDA and ZMySQLTDA were
> broken.Thus I have installed latest
> ZMySQLDA-2.0.4 and MySQLdb 0.3.1.
MySQL-3.23.32 would be a good idea. It has at least one security fix, and
a lot of bug fixes.
> Ufter upg
I have upgraded to MySQL 3.23.28 and both ZMySQLDA and ZMySQLTDA were
broken.Thus I have installed latest
ZMySQLDA-2.0.4 and MySQLdb 0.3.1.
Ufter upgrade it does not work.
I am able to search pages, ie.:
http://arete.ibb.waw.pl/html/leksykon/cd_rom_report_en?nazwa_angielska=b
but I am unable to
Indra Gunawan wrote:
> Hello,
> could anyone tell me how to make connection string to MySQL in Linux?
> I use Zope 2.3 and I've tried the
>
> database@[host] username password
This should work. Your problem is probably somewhere else. Are you sure
that the database adapter, database etc. are
Hello,
could anyone tell me how to make connection string to MySQL in Linux?
I use Zope 2.3 and I've tried the
database@[host] username password
format, and still no luck,
TIA,
-IGUN-
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/ma
On Mon, 15 Jan 2001, Olaf Zanger wrote:
> right now my setup uses a connection string "db root" which doesn't seam
> to give a lot of savety :-).
> at my provider i have a login, but sure no root access to the db.
> * how does the connection string look for user name "peter-hauser" and
> password
hi there,
two times trouble
first:
right now my setup uses a connection string "db root" which doesn't seam
to give a lot of savety :-).
at my provider i have a login, but sure no root access to the db.
* how does the connection string look for user name "peter-hauser" and
password "test3-.2"?
e the quality of the available
documentation.
Best regards
Petter Enholm
Also:
- Original Message -
From: "Eric Walstad" <[EMAIL PROTECTED]>
To: "vishnu prasad" <>
Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Wednesday, January 10, 2
http://www.zope.org/Members/alanpog/zmysqlda_steps
Should get you started...
Eric.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of vishnu
prasad
Sent: Tuesday, January 09, 2001 3:17 PM
To: [EMAIL PROTECTED]
Subject: [Zope] MySQL
can anyone update me
can anyone update me with list of activities that I need to
follow for having MySQL installed and integrated with Zope?
thanks in advance,
vp
One other bizarre symptom: when I test the database connection with a
INSERT query it works and inserts data into the designated MySQL table in
the query, although there is no indication that it is working in Zope. I
changed the user table for the MySQL user cited in the connection string so
th
gt; >> connect with the connection string "test@localhost"
>
> >thank u, this was the point to my problem. I have tried a nologin mysql
> and it
> >worked with database@myhost !!! :)
> >so i know i have a grant table problem in mysql (no big deal - i hope :
) )
QUESTION:
Being a relative newbie to this whole thing (Linux, Zope, MySQL, etc.), how
do I create a null login in MySQL with blanket privleges? Could it still be
a faulty ZMySQLDA setup? How do I troubleshoot that possibility?
Thanks,
P. Johnson
I came across links that recommended recompiling both MySQL and the MySQL DA. I
did so without too much difficuly. The batch compile scripts did not work, but
compiling through the MicroSoft IDE did work. The source code I pulled down
required the Microsoft compiler, not gcc++.
I still have th
Couldn't one just use MyODBC and the ODBC DA? What disadvantages (besides
latency from yet another API to go through) are there to this approach?
Sean
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross po
Hi, Lee
I got zope and mysql working together last night on win2k. I used the
instructions in
http://www.zope.org/Members/philh/mysql
(Thanks, Phil Harris!)
I did have to use the custom dll and pyd mentioned there.
http://www.google.com/search?q=mysql+zope+win32 might have more clues if
this
> From: "Lee Reilly CS1997" <[EMAIL PROTECTED]>
>
> I have seen the mySQL DA on Zope.org but I understand that it "does not
> support win32 platforms at this time". I need database access ASAP so
> can anyone offer any advice?
There is a HOW-TO for this: How-To: ZMySQLDA on Win32
Search for it
Lee,
Have you read the MySQL on Win32 howto?
btw, give my regards to Duncan.
Phil
[EMAIL PROTECTED]
- Original Message -
From: "Lee Reilly CS1997" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 14, 2000 2:46 PM
Subject: [Zope] my
Hi,
Zope is currently being installed on the Unix machines at my uni but it
won't be available for a while. However, I have set up a mySQL database
in the Dept. and installed Zope on a Dept. machine (Windows 95). I can
only access the database from uni so I must have a database adpater
setup on t
Alexander DePauli writes:
> ... using Zope management interface with custom objects ...
The form actions of the Zope management interface are not
built in. They are methods of the managed objects.
This implies, if your objects override these management
method, you get different behaviour.
I
http://www.zope.org/Members/alanpog/zmysqlda_steps
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of K H
Subrahmanyan
Sent: Thursday, November 30, 2000 4:08 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [Zope] MySQL
hi,
I want to add MySQL
Hi Ruediger,
You might consider ZPatterns. It allows you to develop
applications with ZODB, and then, later, 'easily' switch to
other forms of attribute storage for your objects.
-steve
> "Alexander" == Alexander DePauli <[EMAIL PROTECTED]> writes:
Alexander> Hi Zopistas!
Al
Hi Zopistas!
we are looking for a method to do a better integration of mysql
3.23.27 with zope 2.2.2. (we are using the Z MySQL database adapter Z
MySQL DA 1.1.3.)
We have to store data in a mysql database - we can´t use ZODB
because we need the data accessible by other programs via ODBC.
We h
K H Subrahmanyan wrote:
>
> hi,
>I want to add MySQL to my ZOPE.
>
> Please help me in installing it.
>
> Please give the links, necessary information.
How about actually doing some work for yourself for a change rather than
expecting everyone else to do it for you?
Chris
___
hi,
I want to add MySQL to my ZOPE.
Please help me in installing it.
Please give the links, necessary information.
thanks
bye
subrahmayan.
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or
zmysqlda_steps
hth, Eric.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Aitor
Grajal Crespo
Sent: Friday, November 17, 2000 8:37 AM
To: [EMAIL PROTECTED]
Subject: [Zope] MySQL Connection String
I have installed ZMySQLDA 1.1.4,
anybody knows the format of t
On 17/11/00 4:36 pm, "Aitor Grajal Crespo" <[EMAIL PROTECTED]>
wrote:
> I have installed ZMySQLDA 1.1.4,
> anybody knows the format of the database connection string???
>
> I have put database user passw , and doesn't work
>
> Thanks
>
>
database@host user passwd
'host' can be 'localhost' f
I have installed ZMySQLDA 1.1.4,
anybody knows the format of the database connection string???
I have put database user passw , and doesn't work
Thanks
What about one sql method:
select @noteid:=note_id from artist where
update note set notes =
where note_id = @noteid
-Original Message-
From: Richard Moon [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 2:48 AM
To: [EMAIL PROTECTED]
Subject: [Zope] MySQL and Zope
Thanks Monty,
I did try the temporary table route - problem is that Zope keeps the
connection open so the temporary table stays there. Of course you can
explicitly drop the temporary table after you've used it. However if the
update fails for any reason the temporary table will still exist so
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
Nice idea. Trouble is the note table is used to hold notes for many
different reasons, so it looks like this -
---
| Artist| | Recording | | Label | etc.
---
| artist_id | |recording_id| |label_id|
| note_id
is another way around this.
It probably doesn't solve real complex scenarios either.
JAT
Dale
-Original Message-
From: administrator [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 16, 2000 6:11 AM
To: zope
Cc: administrator
Subject: Re: [Zope] MySQL and Zope struggles
I don't k
I don't know if the following link can solve your problem,
but maybe it gives you an idea:
http://www.zope.org/Members/Roug/new_record_with_subrecords
(How-To: Creating a new record with subrecords in MySQL)
Arno
> I'm struggling to migrate an application from Zope/PostgreSQL
I'm struggling to migrate an application from Zope/PostgreSQL to Zope MySQL
(Why ? - because I've got a kind offer of free hosting if I use MySQL).
MySQL offers a limited set of features and is missing, among other things,
the ability to use subqueries - so for example in PostgreS
Hello Zope and MySQL users,
I'm trying to access MySQL through Zope.
I hope someone can point out my set-up error(s).
Environment:
Windows98: 4.10.98
MySQL Server: 3.23.21-beta-debug
Zope v.: 2.2.0 (binary release, python 1.5.2, win32-x86)
Python v.: 1.5.2 (#0, Jul 30 1999, 09:5
Gijs Reulen writes:
> INSERT INTO test1
> ( id, content, phone )
> VALUES (
> ,
> ,
>
> )
>
> According to the doc I should be able to use dtml-var statements in Z SQL
> Methods. However, this returns an error: Error, exceptions.KeyError: 12.12
This is indeed a strange variable name (1
Why does this not work inside a Z SQL Method (using MySQL) ?!
INSERT INTO test1
( id, content, phone )
VALUES (
,
,
)
According to the doc I should be able to use dtml-var statements in Z SQL
Methods. However, this returns an error: Error, exceptions.KeyError: 12.12
I also tried:
INSERT INTO t
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, July 12, 2000 11:03 AM
> > To: [EMAIL PROTECTED]
> > Subject: [Zope] MySQL LIKE operator
> >
> >
> > Hello,
> >
> > I&#
> Sent: Wednesday, July 12, 2000 11:03 AM
> To: [EMAIL PROTECTED]
> Subject: [Zope] MySQL LIKE operator
>
>
> 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 ";
&g
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 , right? But
what if I want to use LIKE?
If I say: WHERE goo LIKE "%%" then
effectively I am saying:
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 7/4/00, 12:47:07 AM, Andy Dustman <[EMAIL PROTECTED]> wrote regarding
Re: [Zope] MySQL transaction support (was: MySQL S
On Sat, 1 Jul 2000, Dieter Maurer wrote:
> I recently found out that Oracle returns column names
> converted into all uppercase. I needed about 2 hours
> to analyse this weird behaviour.
That's actually not too weird. Solid does the same thing. It is a standard
"feature" of SQL-89 that column na
On Tue, 4 Jul 2000, Hannu Krosing wrote:
> AFAIK the transaction support is enabled on table-by-table basis, so
> there
> is no way to know for sure if transactions are
> supported/partially-supported/unsupported for a particular set of
> queries
True enough. There are several problems here:
Andy Dustman wrote:
>
> There are two factors which determine whether or not transactions can be
> supported. Actually, there's only one, but it can't be directly tested
> for:
>
> 1) If the server version (easily obtained upon establishing the
> connection) is < 3.23.15, transactions are defini
1 - 100 of 116 matches
Mail list logo
