Is there a way to test pieces of this module or get specific errors? I'm sure I've just done something stupid, but I can't track it down... Does anyone notice anything specifically wrong with what I've done thus far? (All I get is the pushpin in the middle of a blue screen that says "fetching." As always, any help at all is very much appreciated. Thanks!
Custom Query: (I've tested this Enterprise Manager, and it returns the expected DataSet)
SELECT 0 AS SourceID,'' AS GUID,'' AS Address,0 AS IconIndex,Longitude, Latitude,'' AS Description,1 AS SequenceNumber,'' AS SequenceInfo,1 AS ZoomShow,0 AS ZoomHide,1 AS SummaryCount,'' AS ActionPlot,'' AS ActionClick,'' AS ActionOpen,1 AS FailedGeo,0 AS isUser FROM Shop WHERE ShopNumber=@ShopNumber
Connection String: (this connection is used throughout the rest of the DNN site)
Provider=sqloledb;Data Source=[ADDRESS];Initial Catalog=[DB Name];User ID=[uid];Password=[pwd];
Query Variable:
Type - <QueryString>
Source - ShopNumber
Target - @ShopNumber
Left - <null>
Right - <null>
EmptyValue - 4023
Security - selected
URL QueryString - .../Map.aspx?ShopNumber=xxxx
Map API key appears to also be properly registered.