You could use the XMLHTTP object (from msxml3) to post data to the webpage. With this component, you can do a HTTP POST request to your webpage, and send data with the request. It's something like
Dim objXmlHttp As MSXML2.XMLHTTP
Set objXmlHttp = New MSXML2.XMLHTTP
objXmlHttp.Open...
JOLESEN: BTS has no built-in functionality to extract data from SQL Server, so please explain to me how to do this with no coding at all...
Like ryebread says, get the SQL Server Adapter, or use a preprocessor or a custom functoid in the BTS mapper. Good luck!
<webguru>iqof188</webguru>
There is of course the utility called convert.js, which converts xsd schemas to xdr schemas. It should be somewhere in teh BTS installation dir (can't remember where exactly)
<webguru>iqof188</webguru>
Why do you want BizTalk to do this? Do you know when to use BizTalk? You can use any app to extract the records you want, and then send it (through HTTP, SMTP, FTP of any other protocol) to BizTalk. What exactly do you want?
<webguru>iqof188</webguru>
Hi. I have some troubles getting the example from an O'Reilly book to work. The first part of the code is like this:
<%@ WebService Language="C#" Class="PubsWS.PubsWS" %>
namespace PubsWS
{
using System;
using System.Data;
using System.Data.OleDB...
localhost is the same as 127.0.0.1. It is the machine CF is installed on. Up until version 4.5 (I'm not sure about version 5.0) example apps can only be viewed when you work locally on the machine CF is installed on. Try this, it should work.
<webguru>iqof188</webguru>
Put target="_top" inside your link (<a href="somepage.asp" target="_top"> or <form target="_top">). That should do the trick for you.
<webguru>iqof188</webguru>
I'm not sure what you want to do, but you can always use the CREATE TABLE statement in SQL (also in a CFQUERY). But I'm not sure that's a good idea. Maybe you can use structures (they look a lot like db tables...) to hold the data, or maybe even WDDX packets. Anyway, please be more specific on...
One thing you can do is use the textfile as a datasource. With CFHTTP you can use a textfile as datasource. Just provide a name (this will be the query name), a delimiter for the columns, a textqualifier which indicated where one row starts and ends, and the names of the columns in a...
<cfmail> works just like <cfoutput>, so in the mail your code generates, the value of i.longtext will be displayed, not #i.longtext#. Looks to me like your code will work, test it. Good luck.
<webguru>iqof188</webguru>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.