Offices: Difference between revisions

Revision as of 18:12, 3 June 2024

The prepared statement office is not set up for the database ID DataDemo.

Office Address	City	State	Zip

Loading map...

@@ Line 2: / Line 2: @@
 |db = DataDemo
 |query = office
-|data = office_address=office_address, office_city=office_city, office_state=office_state, office_zip=office_zip
+  |data=officeAddress=office_address, officeCity=office_city, officeState=office_state, officeZip=office_zip
 }}
 {| class="wikitable"
@@ Line 8: / Line 8: @@
    {{#for_external_table:
 |{{!}}-
-  {{!}} {{{office_address}}} {{!}}{{!}} [[{{{office_city}}}]] {{!}}{{!}} {{{office_state}}} {{!}}{{!}} {{{office_zip}}}
+  {{!}} {{{officeAddress}}} {{!}}{{!}} [[{{{officeCity}}}]] {{!}}{{!}} {{{officeState}}} {{!}}{{!}} {{{officeZip}}}
    }}
 |}
-{{#display_map:center=Brooklyn, NY}}
+{{#display_map:
+  center=United States
+  | zoom=4
+  | addresses=
+  {{
+    #for_external_table:|{{{officeAddress}}}, {{{officeCity}}} {{{officeState}}} {{{officeZip}}}
+  }}
+}}