i have two tables.. i need to copy all the info from one table into another one, which might not be empty.table two includes the fields in table one, plus more.
how does one go about doing this? Also there are a few rows to be copied at a time.
Does anyone have an example? or can you refer me to any other threads?
I want to create another Database using ASP, this I can do. However, what is the easiest way to copy tables from one DB to this new DB?
I dont really want to have to write the SQL to create each table and then to use a 'select into' code for table, especially as I have around 15 tables to do!
how I could copy the URL displayed on the browser..I want to copy this url and store it in the variable.
View Replies View RelatedI got a folder name f1 in server. I need to copy same folder and paste it in same root dorectory. Can any one help with asp code for it ....
View Replies View RelatedI am running into a problem for copying files between 2 different servers.
I am using the following lines of code to do that, but I get a 'permission denied' error
Set fso = Server.CreateObject("Scripting.FileSystemObject")
strSourceFile = "server1file1.doc"
strDestFile = "server2file1.doc"
fso.CopyFile strSourceFile,strDestFile, true
Hi how do i copy a file from the server to the PC?
Const ForWriting=2
strPath = Server.MapPath("datos.xml")
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set oFile = fso.GetFile(strPath)
Set tso = oFile.OpenAsTextStream(ForWriting)
sob=1
CopyFile "datos.xml", file://c:/datos.xml, sob
I'm not sure if this is the right place to put this but, I have 2 servers dev and prod. I want to copy files from dev to prod and I want to run this with windows scheduler every so often. I have an account on the prod and the script has to be run on dev. Is there a way that this can be done
View Replies View RelatedIs there a way, to make a page that gets info from a DB using scripting. then take that page, and copy it to another folder, BUT, not having the script there. making it become all html? so the page would contain html, but would be the result of what was
scripted. so i guess i am saying, that the page would become the source.
how do i copy a file from the server to the PC? I have this code but it says that type mismatch 'CopyFile'
<%
Const ForWriting=2
strPath = Server.MapPath("datos.xml")
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set oFile = fso.GetFile(strPath)
Set tso = oFile.OpenAsTextStream(ForWriting)
sob=1
CopyFile "datos.xml", file://c:/datos.xml, sob
%>
i have a "temp" table and i need to copy all records to the definitive table, since both tables as the exact fields how to do add the recorset "temp" to the recorset "final"? i know that to delet the all recorset is just to call it and then do a rs.delete, but i'm not shure about the code to do this.
View Replies View Relatedi want to copy a file(.jpg, .swf ...) on the web, to my server. how can i
write this function? it should take an url of a file and past the file to my
server in related folder.
I am creating a text file on the server which once created I need to then copy to another directory on the network.
View Replies View RelatedI'm simply trying to copy an intranet database file (VesselConfig.mdb) into the same directory but rename it something else (VesselConfig2.mdb).
Here's the code I have so far: Code:
I have looked on the net, but obvious not in the correct place for this.with this mega tourney site i am working on, i am thinking of several ways to do this efficiently.
so what i want to do, is when a new tourney is created, create a folder on my server that is named the id number of the tourney. this is the easy part.
next, i will have a temp folder with all the tourney files in it, that i would want to copy to the new folder. but i have not found a good way to copy these files.can someone stear me in the right direction?currently, i have been using querystrings to determine the correct id, and it is working fine. i just think that doing it this wat, would be easuer to keep each event seperate.
How can i copy GIF file from another server to my server?
View Replies View RelatedOn one of my client's website customer's are uploading a few files each week using SA-FileUp. My clients wants that each uploaded file to be copied on another website he has got.
Any hint on how to copy one file between domains ? I was thinking about using AspHTTP which is installed on the original server but not on the other end.
I am running into a problem for copying files between 2 different servers. I am using the following lines of code to do that, but I get a 'permission denied' error
Set fso = Server.CreateObject("Scripting.FileSystemObject")
strSourceFile = "server1file1.doc"
strDestFile = "server2file1.doc"
fso.CopyFile strSourceFile,strDestFile, true
Does anyone have any idea if you can set the value of a hiddenfield to be that of a textfield on the same page, when submitted?
View Replies View Relatedhow can i copy i file from server to client side ... any solution or can it be?
View Replies View RelatedThere is a client and a server. They both share a folder structure that is identical. The client is able to copy and import files to and from the server with button click.
The client is running IIS and some local scripts. The client also has a network drive mapped to the SERVER location.
Is there a way I can copy files without running IIS on the clients machine? The server needs to pass the file info to the Client. Also keeping in mind that I can't get IE to open file protocol links.
im trying to create an online doc library for our intranet using a MS Access back end
a form allows the users to enter all the details of the doc and then select the file by using a file browser ( input="file" )
the asp script then copies the file from server A to the intranet
the problem is , is that if the user chooses a mapped drive ( e.g. the S drive ) then it fails - if they use the full drive map then it works fine
SO
Fail : s:stu.txt
Works : stuscomputer estdocsstu.txt
is it becuse the intranet server doesnt know what drive S is ?
I am trying to copy files across servers
I can successfully copy file from server1 to server4
but am not able to copy file from server2 to server4
If I use the code to check for file on server 4
ie
If Fileexists(server4filename) then
response.write("File exists")
else
response.write("File Does not exist")
end if
If I run this code from server1 I get file exists
But if I run the same code from server2 I get file does not exist.
I am logged on as the same user.
Could anyone PLEASE let me know what is the difference on both the servers ie. server 2 and server1.
I'm currently working with an ASP page that populates rows based on a
query for course data by using a DO WHILE NOT EOF loop.
An improvement I'm adding is a dropdown populated by query which shows
each course number, so that the user can populate that course page
with data from a previous course.
My question is: once the data from the previous course is populating
the current course page (after being selected from the aforementioned
dropdown), how can that data be saved to the current course's row in
the table? I've tried pulling the result.querystring to get the
CourseID of the current course, but for some reason the changes don't
save.
Would there be a better way to copy data from one row to another in a
table? I am wanting the user to be able to preview the data as it
populates the form fields before saving, if possible.
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View Relatedif there's a way to copy image files from one server to another using ASP and FSO? Or perhaps some other way to do it? I'm trying to collect information on books, and want to have a picture of the book associated with the description, but I want to be nice and
host the pictures myself, not just link to other people's pictures. Is there a way to do this?
I'm using DW MX 2004 to build an asp based eStore. I have a checkout page created with both the billing and shipping information in the same form. I'd like to add some code and a button to activate it to copy the code to the shipping info (but it can't submit form). Also the State choice is a drop down list based on a recordset. There are other behaviors attached.
View Replies View RelatedWe are running into problems with the script below, whose purpose is to allow users to choose values from drop downs populated by an MS Access DB.
THE RESULTS:
(returns a blank page with only HTML Titles)
THE SCRIPT:
(you may notice this is a modified sample script): Code:
Dreamweaver created code to update to data base. But when testing on website i get the following message. I have no clue what it might be.
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/admin/update.asp, line 111
line 11 is strName.execute
I read it might be forbiden characters in the data base field names or spaces...
but i don't have that. the names are userName, userLevel, ID, Password.
This seems a very complicated task, so I welcome any
input. My boss wants a data grid or matrix of the top 6
orders with ordered items, and products, for a particular
customer and he wants to see it like this:
products down the left side
orders across the top
number of items under the respective order number column
across from the corresponding product.
I hope that makes sense.
I have three tables. Products, Orders, Orderitems. I
don't even know where to start. Many thanks in advance
for any input offered.
how do i get data from a user on one page and display the result on the other page
actually i have written a prgoram that displays a set of checkboxes and based on the checkboxes selected the related data is displayed .but the problem is the data is displayed on the same page below the list of check boxes. Code:
I have a form that has the option to upload a file at the bottom. If you select a file it works fine but if you leave file selection blank the forms bombs. This is not how I want it to work. On the form you need to use ENCTYPE="multipart/form-data" in the form tag.
On the processing page I need to use Set to assign a variable to the form data. I tried using IF on the variable assigned to the file path but it bombs out telling me "This function is not supported". Is there any other way I can check to see if curQes has a value assigned to it?
how to call a csv file into a data array. I was told I can use :
csvArr = split(csvLine, ",")
So long as I have no embedded commas in any field. what Im not clear on is the syntax.
how do I call the csv into the script (so the script knows to use the csv)
I only want to input the following information if it is not a zero length string. Any
ideas on how to do it?
Crate&Barrel = Request.Form("Crate&Barrel")
Crate&Barreladdress = Request.Form("Crate&Barreladdress")