bugphpGroupWare - Bugs: bug #21660, Missing "comma" in query

 
 

You are not allowed to post comments on this tracker with your current authentification level.

bug #21660: Missing "comma" in query

Submitted by:  Sigurd Nes <sigurdne>
Submitted on:  Wed 28 Nov 2007 12:11:33 PM UTC  
 
Item Group: SVN trunk (dev code)Category: None
Severity: 3 - NormalPriority: 5 - Normal
Status: NonePrivacy: Public
Assigned to: Pascal Vilarem <maat>Open/Closed: Open
Component Version: SVNOperating System: None
Reproducibility: NonePlanned Release: None
Fixed Release: 

Wed 13 Aug 2008 04:10:03 PM UTC, comment #4:

It would be:

$sql="SELECT ged_history.*, ged_elements.name, ged_elements.reference, ged_elements.description as descriptione, ";
$sql.="ged_versions.major, ged_versions.minor, ged_versions.description as descriptionv ";

Regards

Sigurd

Sigurd Nes <sigurdne>
Project Member
Wed 13 Aug 2008 12:53:39 PM UTC, comment #3:

what would be the correct pgsql way for this ?

Pascal Vilarem <maat>
Project MemberIn charge of this item.
Wed 13 Aug 2008 12:49:46 PM UTC, comment #2:

Ah that explains it.
I'm afraid that won't work on postgresql - one has to spell it out.

Regards

Sigurd

Sigurd Nes <sigurdne>
Project Member
Wed 13 Aug 2008 09:31:44 AM UTC, comment #1:

ged_versions.status finalstatus means "as finalstatus" : comma is not missing here.

What database are you using please ?

Pascal Vilarem <maat>
Project MemberIn charge of this item.
Wed 28 Nov 2007 12:11:33 PM UTC, original submission:

Tiny error:

[file] => /path/to/phpgroupware/ged/inc/class.ged_dm.inc.php
[line] => 2824

ERROR: syntax error at or near "finalstatus"
LINE 1: SELECT ged_history.*, ged_versions.status finalstatus, ged_v...

Regards

Sigurd

Sigurd Nes <sigurdne>
Project Member

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -unavailable- added by maat (Posted a comment)
  • -unavailable- added by sigurdne (Submitted the item)
  •  

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    No Changes Have Been Made to This Item

    Back to the top


    Powered by Savane 3.1-cleanup