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

 
 

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

bug #21660: Missing "comma" in query

Submitter:  Sigurd Nes <sigurdne>
Submitted:  Wed 28 Nov 2007 12:11:33 PM UTC
 
Item Group:  SVN trunk (dev code) Category:  None
Severity:  3 - Normal Priority:  5 - Normal
Status:  None Privacy:  Public
Assigned to:  maat Open/Closed:  Open
Component Version:  SVN Operating System:  None
Reproducibility:  None Planned 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 Member
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 Member
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

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

     

     

    No changes have been made to this item

    Back to the top


    Powered by Savane 3.9