CFMX7 X Read XML URL write returned data to ODBC

ColdFusion 7 Read XML data from a URL and write the collected data to a ODBC database file. Looking to get this working within 24 hours. This is a sample XML file. <?xml version="1.0" encoding="UTF-8"?> <ticket> <assigned-at type="datetime" nil="true"></assigned-at> <assignee-id type="integer" nil="true"></assignee-id> <assignee-updated-at type="datetime" nil="true"></assignee-updated-at> <created-at type="datetime">2008-04-09T17:37:19Z</created-at> <description>Test Ticket - Do not delete: Test Test</description> <description-html><p>Test Ticket - Do not delete: Test Test</p></description-html> <due-date type="datetime" nil="true"></due-date> <external-id type="integer" nil="true"></external-id> <group-id type="integer">1811</group-id> <id type="integer">23232</id> <linked-id type="integer" nil="true"></linked-id> <nice-id type="integer">70003</nice-id> <organization-id type="integer">432</organization-id> <priority-id type="integer">0</priority-id> <recipient></recipient> <requester-id type="integer">7738</requester-id> <requester-updated-at type="datetime">2008-04-09T17:37:19Z</requester-updated-at> <status-id type="integer">0</status-id> <status-updated-at type="datetime">2008-04-09T17:37:19Z</status-updated-at> <submitter-id type="integer">7738</submitter-id> <ticket-type-id type="integer">0</ticket-type-id> <updated-at type="datetime">2008-04-09T17:37:19Z</updated-at> <via-id type="integer">4</via-id> <score type="integer">288</score> <current-tags>delete test</current-tags> <comments type="array"> <comment> <author-id type="integer">7738</author-id> <created-at type="datetime">2008-04-09T17:37:19Z</created-at> <value>Test Ticket - Do not delete: Test Test</value> <value-reference nil="true"></value-reference> <via-id type="integer">4</via-id> <via-reference-id type="integer" nil="true"></via-reference-id> </comment> </comments> </ticket>