On Sun, 2002-06-30 at 22:24, Karl Putland wrote:
> On Sun, 2002-06-30 at 21:58, Edmund Lian wrote:
> >
> > Karl wrote:
> >
> > >I am using psycopg, but it doesn't appear to be related to the
> > >db module. A plethora of print statements show that the select
> > >completes, the loop finishes, the page finishes, then the AppServer
> > >pukes
> >
> > Hmmm... then as Aaron wrote, suspect PyDO first--try posting about the
> > problem to the PyDO mailing list...
> >
> > ...Edmund.
> >
> >
>
> I posted the initial message before some more testing. PyDO is not the
> issue. PyDO successfully returns the data set. It is not puking on my
> development machine. I need to get a larger data set imported, and I'll
> post results tomorrow. The only difference right now, is that my
> partner is running the app server (on port 80076) and apache on a remote
> machine, and accessing the pages from a win2000 machine with IE6, Where
> I have webware app server and apache running on my laptop, and I'm using
> Galeon as my web browser.
>
> --Karl
>
>
I think I've tracked it down to a python problem. The difference
between the machines is the version of python. 2.2.1 on the machine
that fails, and 2.2 on the machine that works. I'm downgrading to 2.2
and will post results shortly.
[lvanhelden@mercury webware]$ python2
Python 2.2.1 (#1, Jun 24 2002, 14:09:11)
[GCC 2.96 20000731 (Red Hat Linux 7.1 2.96-98)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from Lib import ShipEze
>>> Killed
[lvanhelden@mercury webware]$ python2
Python 2.2.1 (#1, Jun 24 2002, 14:09:11)
[GCC 2.96 20000731 (Red Hat Linux 7.1 2.96-98)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> from Lib import ShipEze
>>> import psycopg
>>> con = psycopg.connect("user=postgres dbname=shipeze host=localhost")
>>> leads = ShipEze.Leads.getSome(con)
SQL> SELECT contact_first_name, to_addr1, contact_addr2, contact_addr1,
to_addr2, modified_datetime, to_first_name, from_addr1,
created_datetime, contact_last_name, storage, phone_work, moving_date,
to_city, source, from_addr2, from_city, email, status, fax,
contact_state, to_zip, num_rooms, to_last_name, from_zip, packing,
phone_home, total_weight, lead_id, from_state, to_state, contact_city,
notes, contact_zip, from_first_name, raw_lead, phone_cell, db_user,
time_to_call, from_last_name, cubic_feet, app_user, source_ref FROM
leads
>>> len(leads) # leads is a list type
1096
>>> leads = leads[:100]
Aborted
[lvanhelden@mercury webware]$
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Webware-discuss mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/webware-discuss
--
Karl Putland
Director of Technical Operations
ShipEze Inc
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
Webware-discuss mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/webware-discuss
