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
   
 
Category:  None Item Group:  SVN trunk (dev code)
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>
Group Member
Wed 13 Aug 2008 12:53:39 PM UTC, comment #3: 

what would be the correct pgsql way for this ?

 Pascal Vilarem <maat>
Group 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>
Group 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>
Group 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>
Group 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

    Copyright © 2024 Free Software Foundation, Inc.
    Verbatim copying and distribution of this entire article is permitted in any medium, provided this notice is preserved.
    The Levitating, Meditating, Flute-playing Gnu logo is a GNU GPL'ed image provided by the Nevrax Design Team.
    Page source code

    Powered by Savane 3.14-f13d.
    Corresponding source code