|
|
Folks,
I'm trying to get data back from my IIS/SQL Server without having to refresh the client's page. I also have to do some calculations on the returned data, which is to be displayed in a table. I'm using Microsoft.XMLHTTP to communicate between the client and server pages as shown below:
<br />
On the client side:<br />
function GetAssyRecs(TheOperator)<br />
{<br />
var szRequest = "";<br />
szRequest += "<TheOperator>" + TheOperator + "</TheOperator>";<br />
szRequest += "";<br />
<br />
var objHTTP = new ActiveXObject("Microsoft.XMLHTTP");<br />
var szURL = "GetAssyRecs.asp";<br />
var szHttpMethod = "POST";<br />
objHTTP.Open(szHttpMethod, szURL, false);<br />
objHTTP.SetRequestHeader("Content-Type", "application/x-www-form-urlencoded");<br />
objHTTP.Send(szRequest);<br />
<br />
var szReply = objHTTP.ResponseText;<br />
alert("status: " + objHTTP.status + " Reply: " + szReply);<br />
}<br />
<br />
On the server side (GetAssyRecs.asp):<br />
<%@ Language=JScript %><br />
<% Response.Expires=0; %><br />
<br />
<%<br />
var adOpenKeyset = 1;<br />
var adPersistXML = 1;<br />
<br />
var objXmlDOM = Server.CreateObject("Microsoft.XMLDOM");<br />
var szXmlRequest = Request.Form;<br />
if (!objXmlDOM.loadXML(szXmlRequest))<br />
{<br />
var sErrMsg = "Invalid XML Request String: " + szXmlRequest;<br />
Response.Write(sErrMsg);<br />
return;<br />
}<br />
<br />
var TheUser = objXmlDOM.selectSingleNode("//TheOperator");<br />
if ((TheUser == null) || (TheUser.text == ""))<br />
{<br />
var sErrMsg = "No TheOperator specified: " + szXmlRequest;<br />
Response.Write(sErrMsg);<br />
return;<br />
}<br />
<br />
var sql="Select idnum, serial_number, rework_done, thedatetime from IDC_OperatorCounts where operator = '" + TheUser.text + "' and thedatetime > dateadd(hh, -13, getdate()) order by thedatetime asc;";<br />
<br />
var conn=Server.CreateObject("adodb.connection");<br />
conn.ConnectionString="driver={SQL Server};server=xidc-mrtline;database=IDC_Xerox;Trusted_Connection=yes";<br />
conn.Open;<br />
var rs=Server.CreateObject("adodb.recordset");<br />
rs.Open (sql,conn,adOpenKeyset);<br />
rs.Save (Response, adPersistXML);<br />
<br />
rs.close;<br />
rs=null;<br />
<br />
conn.Close;<br />
conn=null;<br />
<br />
objXmlDOM = null;<br />
}<br />
%><br />
What I want to do is to cast the returned xml recordset back into an ActiveXObject ("AdoDB.Recordset"), so I can read through the records using the syntax a recordset object offers.
Is this possible?
'til next we type...
HAVE FUN!! -- Jesse
|
|
|
|
|
i need code for richtext editing.. which almost look alike this ;Playout, looks very simple but having more stuff..
and i need rich text editor for text box in the chat..
do you guys have any idea tell me plzzz..;)
and i need one more thing, body onfocus code(java script code that can be given in body tag) for text area...
RaJ
-- modified at 10:07 Friday 31st March, 2006
|
|
|
|
|
|
I'm not sure that this is possible.
I want to check if a file exists on the clients computer.
They are uploading files on my site and I want to give them an errormessage if the file doesn't exist before postback.
|
|
|
|
|
You can use following code
<script type="text/javascript"><br />
function DoesFileExist(sFileName) <br />
{<br />
var objFSO = new ActiveXObject("Scripting.FileSystemObject");<br />
return objFSO.FileExists(sFileName);<br />
}<br />
</script>
Before page is submitted call this function and if it returns true then only submit the page.
Larza123 wrote: Before page is submitted call this function and if it returns true then only submit the page.
|
|
|
|
|
Thanx for the answer but I don't want to use an AcitveX control on the page.
|
|
|
|
|
It's not an ActiveX control, it's just an ActiceX object.
However, that method doesn't work at all. There is no way that you can get any information at all about the client file system using Javascript.
The only way to get access to that information would be to use a component on the page, like an ActiveX control or a Java applet.
---
b { font-weight: normal; }
|
|
|
|
|
Hello Everybody
I need help to under stand the process of upload in ASP. I have downloaded some upload files but I can't under stand the process inside the ASP file can anybody give me a brief introduction about the upload process.
N.Rajakumar B.E.,
Application Developer,
www.newdreamz.tk
|
|
|
|
|
|
Hi i am developing a web app using asp.net and c#, for the home page i need and image with links to the top
ten pages in the site but i have no idea how to go about doin this so i amjust wondering if anyone has any
experience of this and if so how wud i go about doin it or where cud i read how to do it, i have tried to
google it but im not sure what im lookin for
|
|
|
|
|
I don't understand where the link is supose to take you.
<img src="..." onclick="functionName" />
Change the functionName to the script or function that you want to call.
|
|
|
|
|
something happend with the code.
removed should be "onclick"
|
|
|
|
|
Hello...
I am working on a picture and want to make an area on it transparent, but i cannot find the transparent codes.
Can anyone please give me a link or write me the transparent code in hex or RGB?
Thank
QzRz
|
|
|
|
|
Hello...
I am working on a picture and want to make an area on it transparent, but i cannot find the transparent codes.
Can anyone please give me a link or write me the transparent code in hex or RGB?
Thank
Thomas
|
|
|
|
|
How to open .class file? I have Visual Studio.Net and got C and java..
Please help.
Tq.
|
|
|
|
|
Hey All,
I've run it to some problems developing a web service server application in C#. Essentially, everything is fine and runs smoothly, except that when my clients attempt to call several web services at once (which they do, on seperate threads), it appears that IIS is blocking some of them. When running against the Cassini type personal web server in .NET 2.0, there is no problem.
The blocking appears to be on a per client basis. I've adjusted the system.net/ connectionManagement section in my web.config and machine.config, but to no avail, so it doesn't appear to be the 2 connection limit imposed by HTTP 1.1.
Any ideas?
Regards,
Rob Philpott.
|
|
|
|
|
hi all,
this is my first question to this site.
I'm building web applications in asp.net, where i am also entitled to design the pages using User Controls. I have no idea where to start with in html as i am unaware of it, but can understand if anyone could help me with the tables, tr, td, border, nesting tables, assigning heights, widths, styles.., preventing scrollbars in the web page, and the likes of it..
I'd be greatly relieved first and then thankful, if anyone of you could help me out .
Sarkun Raj.J,
sarkunraj@yahoo.com,
SparkleSoft,
Chennai
-- modified at 2:59 Friday 31st March, 2006
|
|
|
|
|
If you are looking for how to create a user control, this link may help:
http://www.15seconds.com/Issue/020319.htm
|
|
|
|
|
Thanks Julianne, for your help
|
|
|
|
|
Hi!
I have a problem with an embedded flash object.
The thing is that I never want the object to be less then 750x850 pixles.
When the broswer window is less then that I want the scrollbars to be shown on the broswer. Otherwise it should stretch to the window size.
So after resize I check the width of the page and then I do the following...
var bookReader = document.getElementById('bookReader');
if (bookReader == null)
return 0;
//If the width is less then 750 or the height is less then 850 we need scrollbars
if (width < 750 || height < 850) {
bookReader.width = 750;
bookReader.height = 850;
} else {
bookReader.style.width = width;
bookReader.style.height = height;
}
This works perfectly in IE but in Firefox the size of the object is it's initial size (750x850)
Any suggestions?
|
|
|
|
|
|
Solved it.
Placed a DIV around it.
Like this,
Then it contained the object and the object size was set to 100%.
Then I resized the DIV and then it worked in Firefox as well...
Cheers!
|
|
|
|
|
I'm trying to fire off a JavaScript but I'm having a problem. Here's what I'm trying to accomplish.
I created an HTML file on the server with a Web Application, I want to open that HTML file in another window which is the receipt.
What I did was created a hidden field on the Web Page and then when I want to call the script, I populate the hidden field with the name of the file containing the receipt. Then in JavaScript I trigger with "onchange", yet it never gets there. Maybe it only will trigger when a user enters something instead of programatically, I don't know.
Here's the JavaScript and the asp entry:
<br />
<!--<br />
function PrintReceipt( )<br />
{<br />
var ReceiptName="";<br />
var URL="";<br />
<br />
ReceiptName = document.Form1.efReceiptName.value;<br />
document.Form1.efResponse.value = "Hey we are here!"<br />
<br />
if (ReceiptName.substring(ReceiptName.length-5, 5) == ".html")<br />
{<br />
URL = location.hostname + ReceiptName;<br />
window.open(URL);<br />
}<br />
<br />
return;<br />
}<br />
The the ASP stuff:
textbox id="efReceiptName" style="DISPLAY: none; Z-INDEX: 116; LEFT: 8px; POSITION: absolute; TOP: 8px" runat="server" Width="105px" onchange="PrintReceipt( );">
Note, I removed the <.asp and </asp" so it posts properly..
I don't receive the "We are here" message or the popup window.
Thank you
Glenn
-- modified at 23:10 Thursday 30th March, 2006
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
