[SQL] Selecting rows as if they were columns?

2003-10-09 Thread Kurt Overberg
Gang, I've got what I think should be a pretty simple problem- I just can't figure out how I'd do it. Heck, I can't even figure out how I'd search for an answer to this problem. I've got 2 tables: member and member_attr Member is just a standard entry for a member. Very simple: table member

[SQL] JDBC encoding problem

2003-08-14 Thread Kurt Overberg
I'm having a rather strange problem that I'm hoping someone can help me with. I'm using Struts 1.0/jsp on Debian linux under Tomcat 4.1.x and the blackdown JVM . I'm attempting to convert my current SQL_ASCII database to UNICODE. I'm new to this, so am most likely making a few mistakes. He

Re: [SQL] Query suddenly taking longer....

2003-08-14 Thread Kurt Overberg
it seems to work great though. Thank you. /kurt Tom Lane wrote: Kurt Overberg <[EMAIL PROTECTED]> writes: I have the following query on postgresql 7.3.2 on RedHat 7. select *, (select count(*) from xrefmembergroup where membergroupid = m.id) as numberingroup from membergroup m;

[SQL] Query suddenly taking longer....

2003-08-14 Thread Kurt Overberg
Hi all, I have the following query on postgresql 7.3.2 on RedHat 7. select *, (select count(*) from xrefmembergroup where membergroupid = m.id) as numberingroup from membergroup m; (basically- try to get a list of 'groups' and the number of members in each group) The xrefmembergroup table has abo

Re: [SQL] JDBC encoding problem

2003-08-10 Thread Kurt Overberg
leon - Original Message - From: "Kurt Overberg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, August 06, 2003 1:11 AM Subject: [SQL] JDBC encoding problem I'm having a rather strange p

[SQL] JDBC encoding problem

2003-08-05 Thread Kurt Overberg
I'm having a rather strange problem that I'm hoping someone can help me with. I'm using Struts 1.0/jsp on Debian linux under Tomcat 4.1.x and the blackdown JVM . I'm attempting to convert my current SQL_ASCII database to UNICODE. I'm new to this, so am most likely making a few mistakes. Here's