Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

DotNetNuke Marketplace
  Need Help?  
Professional technical support for DotNetNuke is available from DotNetNuke Corporation.
 


  Ads  
r2i.ntegrated
 


  Sponsors  

Meet Our Sponsors

Click here to go to dev.live.com for Windows Live developer resources
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Map Module [Lea...  Custom Data Connection, please help
Previous Previous
 
Next Next
New Post 6/5/2008 11:35 AM
User is offline delphiman
4 posts
10th Ranked


Custom Data Connection, please help 

I created a new table in SQL and setup all the fields needed. So I connect to this table wihtno problem and display the points on the map with no problem. But in my table I have fields: Firstname, Lastname, Description

I can get Description field to display on the popup marker but I can't get Firstname and Last name to display

How do I display these two fields on popup marker dynamically?
 
New Post 6/7/2008 5:12 AM
User is offline Kevin Schreiner
58 posts
10th Ranked


Re: Custom Data Connection, please help 

As indicated by the map documentation, you  only have access to the known field names that exist within the core table. This WILL be changing soon to incorporate display and use of additional columns from your custom source. Generally what you would do here currently is concatenate your results via the query:

Select '<span>' + Firstname + ' ' + LastName + '</span><br/><span>' + Description + '</span>' as Description

 


Kevin M Schreiner
[P] 410.327.0007 [F] 410.327.4082 | info@r2integrated.com
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Map Module [Lea...  Custom Data Connection, please help
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.
 


Jetkey Smart Map
Smart Map is an AJAX powered Google Map module that displays driving directions, proximity search results and data from your own databases. Smart Map reads GPX (GPS data) files, GeoRSS feeds, and KML data. You can pass any querystring parameter to Smart Map and into your own custom queries to control what data displays on the map.
smartmap.jetkey.com 		DNNSpired.com
Inspired to extend DotNetNuke®, everyday.
www.DNNSpired.com 		TMA Resources
TMA Resources is a software company providing eBusiness solutions for the Association market.
www.tmaresources.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP