jmrodri wrote: > why is this a BAD query? I think this was done on purpose to return the > issue_date as date. > > jesus > >
The query was 'bad' because evidently date is a reserved word. Try to do anything as 'select id as date from rhnServer'. Wont' work. Feel free to look at the referenced bug for the sql error. -Justin > > > > Sent to you by jmrodri via Google Reader: > > > > > > 489775 - fixing listERrata api due to bad query > > <http://git.fedoraproject.org/git/?p=spacewalk.git;a=commitdiff;h=f69734cdefad18cb49501c50d256f1f452a4804f> > > via Fedora Hosted Git Repositories - spacewalk.git/rss log > <http://git.fedoraproject.org/git/?p=spacewalk.git;a=summary> by Justin > Sherrill <[email protected]> on 3/12/09 > > 489775 - fixing listERrata api due to bad query > > * [D > > <http://git.fedoraproject.org/git/?p=spacewalk.git;a=blobdiff;f=java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml;fp=java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml;h=be24d9d3e07c13e51805d98f83fc690e607f7e9d;hp=04eff4ec153d0972952f847c62265af028ef4947;hb=f69734cdefad18cb49501c50d256f1f452a4804f;hpb=651abe6d8754ee18f969308b8e6b68e86f08f271>H > > <http://git.fedoraproject.org/git/?p=spacewalk.git;a=history;f=java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml;h=f69734cdefad18cb49501c50d256f1f452a4804f>] > java/code/src/com/redhat/rhn/common/db/datasource/xml/Errata_queries.xml > > > > > > > Things you can do from here: > > * Subscribe to Fedora Hosted Git Repositories - spacewalk.git/rss > log > > <http://www.google.com/reader/view/feed%2Fhttp%3A%2F%2Fgit.fedoraproject.org%2Fgit%2F%3Fp%3Dspacewalk.git%3Ba%3Drss?source=email> > using *Google Reader* > * Get started using Google Reader > <http://www.google.com/reader/?source=email> to easily keep up > with *all your favorite sites* > > > > > > ------------------------------------------------------------------------ > > _______________________________________________ > Spacewalk-devel mailing list > [email protected] > https://www.redhat.com/mailman/listinfo/spacewalk-devel -- Justin Sherrill, RHCA 1801 Varisty Drive. Software Engineer Raleigh, NC 27603 Red Hat, Inc. _______________________________________________ Spacewalk-devel mailing list [email protected] https://www.redhat.com/mailman/listinfo/spacewalk-devel
