I'd like to write a bunch of queries from a SQL Server 2000 database in my ASP page and have a way of copying this information into an excel workbook in specific cells. Writing the queries isn't the problem, I just need to place it in a file in different specific cells.
Is there a way to do this? Do you have to use VBA code or something? the *.iqy technique isn't going to work, cause I have to place the data in a sepcific excel file, in sepcific cells. I am not sure how to do this or if it's possibly, if anyone has any
ideas on where to start or find some sample code I'd REALLY appreciate it.
When I send a database to server it changes all of my special charters to unicod charterset, I suposed that server is on american charter set, I would like it to change to central europien windows - 1250 code page, is it posible and how? it is very importand to me.
I am having problems with IIS running ASP code against a MySQL database. Everything works fine in Internet Explorer but anytime I use Netscape 7.2 (or Mozilla), it always asks me for a Username and Password.
I can not get Netscape 7.2 to work with IIS so I was wondering if there is another server that I can download to my machine that will allow me to run ASP code against a MySQL database. Does anyone have any recommendations?
I need to read a SQL Server table into a Web Page and within the Web Page to permit my users to make changes to the records, delete or add new records and then save the entire contents back to the SQL Server table back.
The functionality I am looking is almost the same as In the SQL Enterprise Manager whereby I can choose a table open the table and then return all rows and I can maintain the same and save it back to the SQL Server table. I want almost a similar web interface to such a functionality.
Even if not a generic functionality as the SQL Enterprise Manager table maintenance appreciate if somebody can share the code with a sample how I can do it in ASP pages + T-SQL if need be.
Could anyone tell me whether either, ASP, or ASP.NET/VB.net or ASP.NET/C# enable me to create a web application with no source code available to be seen by the clients people.
I read something about dll's an using Visual studio.net in another post,Iprefer vb.net or c# cos I am familiar with vb an c# is supposed to be easier than c++
Is it possible to run a Server Side function from JavaScript? I have a dropdown list that executes some javascript in the onChange event, but I need it to query a database after it does so.
I plan to allow users to upload jpegs using the <input type="file"> I understand one needs to install an ASP componenet on the server to handle the upload.
I have an installation executable from CBUupload that is freeware, which apparently can do the job. Also there are a number of options I can purchase. Has anyone any experience with installing these components on a host site?
We have a report page which deals with more than 3000 records and 80 columns. The records are displayed on a third party control VS flexgrid versioned 7.0.
Currently we are having a client side array populated from the server side using response.write . Is there any other means to optimize the performance on this page?
One of the fields ("Description") in my MSAccess database table contain text formated by HTML tags (<b>, <i>, etc) I now need to display it on asp page, but not as formated text, but as it is stored in my database:
Not like Description of this product is good.
but as <b>Description</b> of this product <i>is</i> good.
I just inhereted a website. I made a change to a simple SQL string in a ..aspx.vb page. If I don't have Visual Studio, is there a way to "publish" the pages and show my changes?
I am trying to call a field value from my database - which gets open in an included file (all work on database must be done in that included file), if i use response.write(rst("pagename") it would print fine in the page when I call the sub i.e <% call pageNameFind() %>
But i want to get the field value to appear like this <% PageTitle = pagename %> where pagename comes from the included sub pageNameFind pagename = rst("pagename")
It doesn't pick this up however - how would I do this? This value will then be sent on to another included file at later stage. and I must have the <% PageTitle = myvalue %>.
I got this book for some time. I need to download the source code for this book. However, Wrox, the publisher, does not have download code for this book. Could anybody suggest any site from where I can get the download of source code for this book?
The most pressing issue at the moment is that my browser does not display the page; it displays the ASP code. I built the page for a questionnaire that was going to be placed on my schools server so that participants could access it online, but I submitted my request too late in the semester.
I decided that the best course of action was to collect these data offline using the computers that I had bought for my lab. The laptops are running Windows 2000 Professional and are using IIS. After configuring ISS and Dreamweaver MX, I built the questionnaire. Then, I uploaded the questionnaire to the “server”—the wwwroot folder.
Now, the index page (the instructions to the questionnaire) opens flawlessly, but when the link to the questionnaire is pressed to open the ASP page, the browser displays the code and not the questionnaire itself.
When I explained this problem to people, they tell me that my server does not support server site scripting, but I’m using a Windows machine, using Windows server software, and Windows database software (Access 2000). Moreover, when I preview the page through Dreamweaver MX, Internet Explorer displays it without a problem. Code:
How can I hide VB Script code in the ASP Page? Even though the display.asp includes the script_functions.asp, when I click on View Source from IE, I can still the VB Script code? What can I do to hide the code from the people who use display.asp?
I need code to capture a users ip address once they agree to a disclaimer (a form yes/no). If the user states no a message telling them they do not have access and a redirect back to the home page.
I need to put the ip address along with the date a sql server database. I am lost as to how to code this and also how to set it up in my directories.
The employees who use it are not allowed access to the server it's requried to sit on which means that my username and password have to be included in the logon.asp page which I HATE! So when this fails, it publishes my usernanme and password on the screen for the user to see...brilliant!
Since nobody is willing to create a dummy account is there a way that I can keep that line of code from displaying if in error? I've added the code to this thread...
inserting dynamic page code in .html page? i.e. i would like to insert a code which will display links. where my homepage link extension is .html. if it is .asp it would have been very easy. and also i would have worked fine. but now the problem is the homepage index file extension is .html.
so if i insert the code it is not displaying the links. i tried inserting the code in a separate file and saved as file.inc and gave the link from home page <!--#include file="file.inc"--> but still the link is not showing and not working.
I tried to display an error detail on my webpage when I got an "HTTP 500 Internal Server Error" of my .asp page, but I was failed I did setup in IIS so it will display debug error on my asp page as well as setting up my browser internet option.
Can you help me how to set it up so I am able to see the error detail on my browser when I get "HTTP 500 Internal Server Error" ( Currently, I just got a blank page with "HTTP 500 Internal Server Error" in the web page title)I run IIS 5.0 and window professional xp browser.
I check to see if a certain submission button is asking for removal. If the removal is true, I update a recordset's delete column. This has been tested and it works. However, now I'd like to prompt the user to make sure that he/she wants to remove the record. Here's the code: ....
I'm developing a Web App using C#. I want a page in the app to refer to another page in the app. I tried to create a web request with the page address below:
Exception Details: System.UriFormatException: Invalid URI: The hostname could not be parsed.
What is the syntax for referring to a page on the current site so I don't have to change it when it's published?
When I used the following page address:
pageAddress = "http://clientDBQuery.aspx";
I didn't get the parsing error but the debugger didn't stop on a break point I set in the LoadPage method. This seems to occurr because it goes to a page on my ISP which doesn't exist.
I have a server page that has served an HTML page with a "Cancel" button on it, BUT this server page has not completed and is running a 15-30 second process before it completes. I want the browser user to be able to terminate the page before the server process has finished.
What I tried was an onClick event that issue a "location.href..." in hopes that this would load this referenced page, etc. but I have found that the browser waits until the server process had compled before executing the "location.href". is there some way that I can "signal" the server to stop processing so that I can go to the "location.href" page; or is there some other way?
How would I go about displaying a plain text page that is located on a website that is not my own? For example... my site is www.x.com and www.y.com has a news article at http://www.y.com/article1.asp and i want to "include" this file on a page located on my site (www.x.com).
I have a set of ASP pages. The pages are hosted on IIS as a seperate application with their own global.asa. I have another web server (custom made by our development team) running on another port (say 6550) on the same machine where IIS is running. This web server is running inside a Win32/MFC DLL. I am looking for a way to achieve the following.
1. A user opens one of the ASP pages hosted on IIS in his browser.
2. On the server side IIS starts processing the ASP script.
3. The ASP script needs to pass the query string parameters to my DLL. My DLL will perform some operations and change some internal data values and will inform the ASP script about the success or failure.
4. The ASP script will send a response back to the user browser depending on the success or failure value returned from the DLL. It would most probably redirect the user browser (Response.Redirect) to another ASP page.
I am concerned about how to talk to my DLL. I have two options in my mind.
1. I can create an ActiveX. ASP script will create an instance of the ActiveX which will talk to my DLL by calling the appropriate functions and return the success or failure value to ASP script.
2. I can somehow call the custom web server (which is running inside my DLL) from inside the ASP script, passing it the query string parameters via a URL.
Because the web server is running inside my DLL, it can perform same operations and can change same values which I can perform and change using the DLL interface functions. And then my custom web server can return the success or failure value to the ASP script.
Option 1 is clear to me. I want to know whether option 2 is possible or not. Can I call my custom web server from the ASP script such that the ASP script does not use Response.Redirect?
Can the ASP script call a URL pointing to my custom web server, wait for my web server to do its processing and return the success or failure to the ASP script, and then redirect the user browser to another page depending on the success or failure value returned from my web server?
I need a search engine for my web. The service Index Server (for web) is started (win 2K) but i don't know how to make an ASP page for that. I can make a form like this:
<form ACTION="/asp/search_v2/query2.asp" METHOD="POST"> <table WIDTH="500" bordercolor="#FFFFFF"> <td>Give what you want to search:</td> </tr> <td><input TYPE="TEXT" NAME="SearchString" SIZE="65" MAXLENGTH="100" VALUE=""></td> <td><input TYPE="SUBMIT" NAME="Action" VALUE="Go"></td> </form>
We are trying to get an .asp page to post to an access database. the page is viewable, and the form boxes can be filled in. Upon submission of the data a confirmation page is then to show.
What happens is the data is inserted into the page, but upon submission an HTTP 500 Internal server error appears.
if we uncheck show friendly http errors in IE there is still no more info to go on.