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.
View RepliesI want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View Relatedi want to extract out certain column from my table . can i do it using the checkbox . eg. when i got ten check box then when i select 4 of it . the selected 4 column will appear in my next page . can i do it this way ? or is there any other easier way ?
View Replies View RelatedCan some one tell me that which query should I run to rename a column(field) name of a table in ASP. I am using MS Access database.
View Replies View RelatedI am trying to retrieve a record identity from a SQL Server auto-incremented field on insert statement.
Here is the error I am getting can anyone please help me
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'cwm_Report_Request_Form' when IDENTITY_INSERT is set to OFF.
/cwm/Admin/reportrequest.asp, line 66
here is my code:
Would someone be able to explain the sql image field to me. I was reading about it a little but dont really understand.
I would like to have word documents that can be indexed and searched and i heard the image field with an accompanying char field with the file extension would be the trick. how would i actually get binary files into the image field?
I wanted to write an asp script so users could enter .doc that they could query. I understand basic asp sql inserts.
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.
Any suggestions on where to start?
i have 2 tables and i want the content of the one table where the second tables content doenst exist in the other table.
E.g.
Table 1
id1
1
2
3
4
Table 2
id1
1
4
so i would only get 2 and 3 in table 1.
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
View Replies View Relatedis it possible to add a number in time? i created a code which is something like this
x=date
y=x+2
response.write(y)
but it doesnt work... for example the time is 08:32:05 AM and im going to add 2 minutes the result should be 08:34:05
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).
Within my site is a section for visitors to login. Once they have logged in they are directed to a page which uses frames.
existing code is below:
<frame name="leftFrame" src="computer_store_index.asp" scrolling="auto">
<frame name="mainFrame" src="computer_store.asp" scrolling="auto">
</frameset>
<noframes><body>
</body></noframes>
</html>
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:
View Replies View RelatedI'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)
I wonder if anyone knows about how we can write text on some existing gif or jpg Image and then save them again in the same format.
View Replies View Relatedhow 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.
View Replies View RelatedI 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.
View Replies View RelatedIs 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.
my coding knowledge is limited. How do I add the following..
target="_blank">
to this code...
ImageString = "<img src=""" & Banners("Image") & """ alt=""" & Banners("Hint") & """>"
All I want it to do is open a banner in a new page instead of the existing page.
if it would be possible to convert an existing e-mail form to;
1. Send the e-mail (as it does now...without problems)
2. Copy one folder on the server, to another new folder
Using the username from the e-mail form, as the new foldername?
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".
View Replies View RelatedI'm trying to append an already existent text file, simple enough, but it doesn't seem to be working Code:
View Replies View RelatedI 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..
View Replies View RelatedUsing 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?
View Replies View RelatedThe 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.
But I keep getting the error:
"C:Program FilesEnsimSitedata hewebzstudioInetpubwwwroot golfasiaadminuploadcmdprompt.gif
aspSmartUpload.Fileerror '80040460'
Unable to save file (Error 1120) "
This is the code:....
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.