Recent content by adonis547

Excellent - thanks to both of you.

Hello, I've got the following table: COMP_ID COMP_NAME COMP_PSEUDO ---------------------------------- 1 ABC XXYXX 2 ORACLE YYXXY 3 DELL OOSSX 4 IBM 5 MS So, (ABC,DELL & ORACLE) all subscribe to my fine Pseudo...

Group, On my postfix server, I've got an entry in /etc/aliases like so: board:mich,jay,peter,paul,kris When sending to board@mydomain.com, I receive the mail as well.. Is there anyway, to send the mail so the author does not receive a copy ? TIA, /mich

Hello, I'm running Oracle 8i on a linux box. Recently, I've been seeing the following error, when logging with sqlplus: ----- oracle@mybox ~> sqlplus user@DB/pw SQL*Plus: Release 8.1.7.0.0 - Production on Fri Jun 10 11:03:40 2005 (c) Copyright 2000 Oracle Corporation. All rights reserved...

Thanks. Though meanwhile I solved the problem. From the "orders" table I pulled out, doc_type and set that up as a group - and then moved contents in the report from the detail section to the nested group.

Hmm.. Thanks. I tried out "Running totals" and "Summary total" - both of them can give me the "minimum" date - but none of them addresses the problem at hand: the accounts are listed as many times, as there's a hit in the "orders" table. Is there no way of changing the SELECT statement that...

Hello group, Imagine the following two tables: accounts: account# Name CreateDate Salesrep ===================================================== 0101 ABC 01-02-05 CARLOS 0102 ACB 02-02-05 JOHN 0104 CBA 01-12-04 BEN orders: account#...

Dennisbbb: Sending from the unix box works fine. The mailserver log on the unix box, is not even registrering connection attempts from the exchange server. I can do a `telnet unixserver 25` from the exchange server, and it works fine. I can also do a `telnet exchange-server 25` and send a...

I'm gonna reply to myself ;) It seems I've found a solution.. it's got to do with altaddr.. Sorry for jumping the gun.

Hello, I've got a citrix server farm running on 2 servers (Citrix Presentation Server 3.0). Everything works great from my LAN - however when connecting from outside our LAN - it says "There is not citrix configured on the address". This is happening even though the ICA client can find the...

Thanks for your reply. I actually solved it meanwhile. I could not type cast varchar to int - so I ended type casting varchar to text and text to int. My final sql looks like this: update my_table set new_column = column::text::int; Sorry again for screwing up this thread (you see, nothing...

To ceco ! Argh.. Sorry for being a jackass - That's how it goes when you post a question while you're on the way out of the door ;) Thanks for the answer. However, when running the update commmand, I get the following error: ERROR: column "temp_qty" is of type integer but expression is of...

I'm running postgesql 7.4.1 on a FreeBSD system. I've been so stupid as define an incorrect datatype for field (set varchar instead of int) - the table already has loads od data so I cannot just drop and re-create. Is there a way of changing the type ? Or perhaps create a new column, copy over...

Well, yes - there is a SP4 for 1.80. (That's pre XP) See here: http://support.citrix.com/kb/entry.jspa?entryID=2501&categoryID=124 /mich