SQL Server Code From An ASP Page
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.
View Replies
ADVERTISEMENT
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.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
I am think to write a code that will need more then 2 servers.
Can anyone give me some information to do code like that?
Like yahoo, google, msn.
View Replies
View Related
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++
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
I've got all these great books and code samples from the internet, but when I try to use them, they don't work!
For example, the following code ignores all the code in the frmTest_OnSubmit, and proceeds to go to the next form as if everything is ok: Code:
View Replies
View Related
Anyone have server side code to password validation?
View Replies
View Related
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?
View Replies
View Related
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.
How can I do this?
View Replies
View Related
How can i get the source code of a web page through asp code?
View Replies
View Related
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?
View Replies
View Related
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 %>.
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
Is ASP page compiled or interpreted by the web Server and what about the internet explorer how it deal with HTML and other realted pages?
View Replies
View Related
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...
View Replies
View Related
I need an asp code/page to run in the background and execute periodically/full time. This code must do some actions based upon time intervals.
For example, The code must keep running and must send an email every 6 hrs. ASP is preferrable.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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: ....
View Replies
View Related
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:
pageAddress = "http://~/clientDBQuery.aspx";
WebRequest request = WebRequest.Create (pageAddress);
and got the following error:
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.
What's the right way to handle this situation?
View Replies
View Related
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?
View Replies
View Related
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).
View Replies
View Related
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?
View Replies
View Related
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>
but then .
View Replies
View Related
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.
View Replies
View Related
Manipulate your asp code in whatever editor floats your boat, but try your code in IIS without your ide and see what happens.
View Replies
View Related
What is the default time out on an Active Server Page?
View Replies
View Related
