Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old March 18th, 2005, 12:32 PM
Authorized User
 
Join Date: May 2004
Location: , , .
Posts: 28
Thanks: 0
Thanked 1 Time in 1 Post
Default HTTP Request.

We have written a small asp page to accept an HTTP request, pass the request onto an Oracle database for processing and then return the results.

This works find when we call it using HTTP/1.0 but if we use HTTP/1.1 or above it doesn't work.

Here's the code.

<%@ LANGUAGE=JSCRIPT%>

<%

var strSQL;
var strRequest;
var dbConnection, strConnect;
strConnect = Application("ecentre_ConnStr");
dbConnection = Server.CreateObject("ADODB.Connection");
dbConnection.Open(strConnect);

var doc = new ActiveXObject("msxml2.DOMDocument.3.0");
doc.async = false;
doc.resolveExternals = false;
doc.validateOnParse = false;

// Load an XML file into the DOM instance.
doc.load(Request);

strSQL = "SELECT '<TEST>"+ doc.xml +"</TEST>' as out_xml FROM dual";
rspers = Server.CreateObject("ADODB.Recordset");
rspers.Open(strSQL, dbConnection, adOpenStatic, adLockOptimistic);

if (!rspers.EOF) {
   var vout_xml = rspers("out_xml");
}

Response.ContentType="text/xml"
Response.Write(vout_xml);
%>

From what we can work out using anything other than HTTP/1.0 results in a NULL being passed into the Oracle script, so I assume its the doc.load(Request); line thats not doing what it should. As I say with HTTP/1.0 it's fine.

Were an Oracle shop so have little experince with ASP so any advice would be really appreciated.

Thanks in advance

Andrew.



Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Http web request Nadeem ASP.NET 2.0 Professional 5 October 27th, 2008 07:28 AM
xml http request AaronT Ajax 0 May 29th, 2008 11:52 PM
HTTP request works sometimes deBassMan XML 0 June 1st, 2007 08:12 AM
how to send Http request via a trigger kissvineet .NET Web Services 0 October 28th, 2005 04:50 AM
how to send Http request via a trigger kissvineet .NET Web Services 0 October 28th, 2005 04:48 AM



All times are GMT -4. The time now is 08:29 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.