Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 


Friday, November 21, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
GoMap (free module)
Review and discuss the new FREE GoMaps module, Google Maps and DotNetNuke Integration.
Subject: Order By in Custom Query
You are not authorized to post a reply.
 
Author Messages
_mubashir
Welterweight
Posts:33

03/19/2008 7:11 AM Alert 
Hi,
I am using Directory mode and trying to order my points based on a varchar field that I have in my DB. I am using custom query with an Order By clause. But with the 'Order By' clause Map doesnt load any data. Without 'Order By' it works fine.

Any ideas?
regards,
Mubashir
kevinmschreiner
Please Wait...
Posts:749

03/19/2008 2:33 PM Alert 
That is directly related to the way directory mode works. It always will order by the Distance calculation. Therefore - if you add an Order by, another order by will already have been appended. To do what you require, you need to change the source code that fulfills the Directory source population.

Kevin M Schreiner

Business Intelligence Force, Inc. (bi4ce)
You are not authorized to post a reply.
Forums > Bi4ce.Modules > GoMap (free module) > Order By in Custom Query



ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation