Adding Map to existing page, Help With WHERE Clause
I have the a working detail page that displays multiple Address records based on URL Parameter ID's (1825, 1824,
1823, 1822, 1821): (This is working fine)
-----------------------------------------------
map_sel.cfm?wkRptID=1826&wkRptID_1=1825&wkRptID_2= 1824&wkRpt ID_3=1823&wkRptID_4=1822&wkRptID_5=1821 (this is the URL to display my "selected" records from a previous main page)
- But I cannot get my map query (on the same detail page) to properly "Reference" those URL ID values in my WHERE statement?
- How do I fix my WHERE clause below to correctly filter by these URL ID's only?
- Here is my current map query listed below, but it only outputs the First record (or only one ID)?
-----------------------------------------------------------
<cfparam name="URL.wkRptID" default="1">
<cfquery name="rsMapCust" datasource="salesPipeline">
SELECT wkRptID, wkRptCustName, wkRptBusAdd, wkRptCustCity, wkRptBusSt,
wkRptBusZip
FROM tblWeeklyRpt
WHERE wkRptID IN (<cfqueryparam value="#URL.wkRptID#" cfsqltype="cf_sql_numeric"> )
</cfquery>
-----------------------------------------------------------
I have my Google map below the detail records on my page, and I'm trying to map just those records only.
- Here is a picture of my detail page: MapSelected.jpg
(notice that it maps the first record, but none of the others..?)