I have an Access database; e.g., mydb; with 10 Tables (e.g., tbl1, tbl2, ..., tble10) in my database directory; e.g., fpdb. I need to be able to copy the entire database with tables to another directory, where the name of directory will be provided by the user (therefore I do not know the directory name in advance). How can I make a copy of existing Access DB vis ASP programming.
I'm a newbie to ASP coming from a PHP background and I wonder if there is - well I am sure there is - a command to check for the exists of a file which is on a ftp server (on the same as the file which tests it). Also is there a general site which explains all the asp commands in a logical form like php.net does for PHP
Is there a way to pass a URL parameter from a previous page to the next page (without clicking a hyperlink)? There are 3 pages. user_edit.asp, user_delete.asp, user_delete2.asp. I want to pass the customer_id parameter from user_edit.asp via a hyperlink to user_delete.asp and then after some asp manipulation I want to pass the existing customer_id parameter to the user_delete2.asp page (or again to user_delete.asp) without the user doing anything (such as accessing a hyperlink).
The problem is when the visitor logs out they are directed back to the login page. The login page and all subsequent pages which the visitor may click on within the site also displays the frames. Is there anyway to close the frames?
I have MS Visual Studio 2003 on Windows XP Pro. I have IIS running on this machine and I am trying to debug some existing code which has both ASP and ASP.NET components. When I try and launch the debugger from VS, I am told it can't because the project is of output type class library. The error indicates I should set the start action to start external program or start URL. I tried both of these and cannot seem to get the debugger to attach to the process. However, I can load the webpage and surf to an error which causes another session of VS to come up. Unfortunatly, the error is not one that I can debug because I can not get break points to work and the debugger will only come up when it hits the error. My start page is default.asp and I have tried setting a break point in it to no avail. How can I debug this script?
I have a site which has extensive database activity. What I do is for each procedure I open a connection to the database and close it as and when I leave the procedure. However, in long run I find that some connection to the database is not properly closed causing the site to hang. This has become a big headache for me.
Trying to find what is going wrong I logged opening /closing of connections to the database and found that at some points the connections are not closed resulting in large no. of active connections to the database.
But if I go through the script I cannot really understand why that connection was not closed since the script ensure that the connection is closed before exiting the procedure.
Is there any way where I can check the database may be during night time and close all existing connections to the database. I repeat all my connections to the database are done at the procedure level.
Im trying to write to an existing xml document (changes.xml). If it already exists, which it should, it will just add some child nodes and save the file... if it doesnt exist i want to create it and add the nodes and save the file... problem is it never saves the file to the directory its supposed to. Code:
I'm running into some trouble figuring out how to create a 'project' from an existing asp application.
The ASP app was written entirely with plain text editors. I would like to set up debugging for it, but it seems that in order to debug, I must have a 'projec
I cannot figure out how one might go about this task. The project is rather large (180K lines, and a few hundred files in many different sub-dirs), and I have been playing & researching for about 4 hours now, and I can't figure it out.
Can anyone make a suggestion as to what I must do to get something going (preferably vs2003, but I have VID also)
how to add an existing asp project into VSS? I have never done this before so am not sure even where to begin. Searched a few places online but have not found any suitable documention on this yet. My asp project uses SQL Server 2000.
I have a website which displays information from a database. I would like to add an option that when the user is pressing a button or link, a specific form as a WORD document will open on his desktop filled in specific places with data from the database. The original empty WORD doc is stored on the server.
Is it possible to send data from ASP and put it into a existing template? i don't want to create an excel document I only want to send one piece of information from ASP to the Exisiting Template.
We have created a online quote number genetrator for our sales team and we want it to open the excel quote template and put the quote number on that excel template.
I have this form in which the user insert his details, and chose which detail to add and which not and he can add a new field by his own which doesn't exist before. So this new field is a new column, so I just want to know how to add this column into an existing table.
I'm planning to design a comprehensive shopping cart in asp that will work on different pre-designed html templates. This means that for each html template, the various asp pages like categories (category.asp), products (products.asp), cart (cart.asp) and so on will have same appearance in terms of page background, top logo, company slogan, top links, copyright & privacy statements at bottom, etc. My question is --
Is it possible to divide the html code of a particular template in two parts, like header (header.asp or header.inc) and footer (footer.asp or footer.inc) so that for any asp page, I just include header first followed by asp scripts and then footer ?
If possible, how it is done ? I heard that it is possible in php pages with the help of 'Require' statement. Can anyone suggest any similar page on the web ?
I have a web site in which 7 pages repeat once and again in thousands of folders. Why? because I want to keep, to the user view, the pretty url www.myweb.com/username/pageX.asp.
As you can imagine, this makes maintenance hard, because when I make some update, I have to run a program to spread the change to the xthousands directories.
A solution would be to change the url to www.myweb.com/pageX.asp?u=username but the url wont be so easy to remember, and probably it will not like our users.
My question is, in which way can I simulate this last behaviour, but maintaining the "pretty" url, not only for accessing, but during the navigation. The trick would be to catch the inexisting directory name and pass it to the desired page as a parameter.
I've been reading through all related Excel posts now for about an hour as well as Googling for my answer and I'm getting even more cornfuzed as I go. I have an Existing Excel Spreadsheet, I need to populate certain fields of the form with values from a Database.
I have no problems connecting to my database and pulling up the data, but I have no idea where to begin with opening my existing spreadsheet, then telling it which worksheet to use and then how to populate the fields I need.
I'm not looking for an entire code handout, this is just something that I haven't attempted before in ASP. If someone could just give a quick example of first opening the existing spreadsheet, selecting the correct worksheet and populating 1 field, I think I can figure everything else out from there.
have try to search from the MSDN, i found the namespace "System.Windows.Forms.HtmlWindow" has this function, but the my .NET Framework version 2.0 dont have the object. Moreover, i have try to download the .NET Framework version 2.0 from MSDN. But, it still dont have the "System.Windows.Forms.HtmlWindow".
I have an Excel Template that is filled out in certain senarios. What I want to be able to do is access this existing Excel Template through a webpage, enter nessisary data into the template, and then e-mail these changes to certain people. The original Excel template needs to stay Unfilled out and unmodified once the process is complete. If saving a different copy to e-mail is nessisary that is ok. I have Created the Excel object on the server to be filled with database info from a query, but I'm not sure how to open an current excel document and then email that document onces it is filled out..
Using VS 2003, how can I open an existing (localhost) website so that all of the website files appear in Solution Explorer the way they do with VS 2005?
The scenario is that I need to save the file names of images that people uploaded. If the image file already exists, it should be overwritten with the new image. I got the code from one of the forum posted by freeasphelp.
Are there any existing FREE ASP scripts which permit the uploading of multiple images with the ability to check the image for its type, size and dimensions before accepting the uploads.
Importing EXCEL worksheet into existing ACCESS tables is possible.
Is there any way i could import EXCEL worksheet into an existing ACCESS table using ASP code.Something like, i could upload a EXCEL file from a browser and then it can be imported into an existing table And if possible also check for duplicate keys and update those records. If no records exist then insert them.
I have a question concerning ASP classic. I'm trying to add an existing user in active directory to an AD group using a web-based form. Using regular code to do this, I get a general access denied error, upon which further research told me I needed admin rights in order to accomplish the task.
I vaguely remember an ASP project I worked on in the past where the script itself authenticated to active directory before requesting information. Is it possible to authenticate to AD (as in, authenticating with my username/password which has access to add users to this specific AD group), then continue with the commands that way? I've resurrected a bit of code from that prior project, and attempted to mix the two together: Code:
we want to create some documentation of the architecture in an existing ASP application. Can anyone suggest some document types to use to make it easy to understand the application?
I have an existing classic asp web site running under IIS ( on localhost) I want to start using VS 2003 to edit/debug this project. How do I go about opening this this existing web site with VS 2003?
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
I want to check the database for existing weeks and display all 52 weeks and highlight the ones that match.
So lets say my table has values 3, 8, 48, 52. What I want to do is to compare theese database values whith the 52 weeks (which not is in the database) maybe from a (for i to 52 loop?) and check for certain conditions mainly if the week exists. I would like to avoid placing all 52 weeks in the db. Code: