P
PaulHilgeman
Each day when the new data is imported, I am now being asked to send
HTTP strings to an external website/database. I can send in fairly
simple XML format, with some of the parameters from my database.
How would I automatically do this? It would be simple enough to run a
query for all jobs added to the database today. Then I need to parse
out certain things like PO Number, Phone Number, Order Number etc, and
generate a string like this:
http://www.website.com/scripts/prog...allOrderNumber=62589&PhoneNumber=xxx-xxx-xxxx
The data like StoreNumber, InstallPO, InstallOrderNumber, Phone Number
all come from the data that is already in an access table.
So, once I get a query made, with all of the pertinent data, how do I
go about sending all of the HTTP GET commands.
Thanks!!!
HTTP strings to an external website/database. I can send in fairly
simple XML format, with some of the parameters from my database.
How would I automatically do this? It would be simple enough to run a
query for all jobs added to the database today. Then I need to parse
out certain things like PO Number, Phone Number, Order Number etc, and
generate a string like this:
http://www.website.com/scripts/prog...allOrderNumber=62589&PhoneNumber=xxx-xxx-xxxx
The data like StoreNumber, InstallPO, InstallOrderNumber, Phone Number
all come from the data that is already in an access table.
So, once I get a query made, with all of the pertinent data, how do I
go about sending all of the HTTP GET commands.
Thanks!!!