[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-users] Postgresql CONCAT function
From: |
A.R.Davies |
Subject: |
[Phpgroupware-users] Postgresql CONCAT function |
Date: |
Mon, 28 Jan 2002 11:13:25 +0000 |
User-agent: |
Mozilla/5.0 (Windows; U; Win95; en-US; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1 |
Hello
I'm not sure this is the correct place to post this but here goes.
I am running phpGroupWare on SuSE 7.3 and Postgresql, in the phonelog,
index.php the CONCAT function does not work, pgsql uses '||' to join
strings.
$db1->query("SELECT pl_id, pl_callfrom_id, pl_callfrom_txt,
account_firstname ||
' ' || account_lastname, pl_calldate, pl_status, pl_desc_short FROM
phonelog_en
try, phpgw_accounts where pl_callfor=account_id $query_filters
$query_order");
was :-
$db1->query("SELECT pl_id, pl_callfrom_id, pl_callfrom_txt,
CONCAT(account_first
name, ' ', account_lastname), pl_calldate, pl_status, pl_desc_short FROM
phonelo
g_entry, phpgw_accounts where pl_callfor=account_id $query_filters
$query_order"
);
Regards
Roger
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-users] Postgresql CONCAT function,
A.R.Davies <=