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 Replieshow 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
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?
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 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 RelatedI 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 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.
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
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 basically created 5 different recordset with names of
ObjRS2 ---> ObjRS6
The code is pretty easy to understand, but I'm missing something
<%
for (i=2;i<=6;i++)
{
%>
all of my HTML code calling the Recordsets....example
<tr>
<td>
<%= objRSi("something")%> <----- the "i" is where i want the counter obviously
</td>
</tr>
}
how would one make this work?
I have a database set up for a survey where in the Answers table I have columns QuestionID, SurveyID, and Answer. Because my survey has about 300 possible questions it's impossible to make a column for each answer. So if I need to select the answers from a specific survey for a specific question and I have about 50 entered in the database my loop will have go keep going for about 15000 times. What I'm trying to find out is if there is a way to create a record set by selecting a survey by it's ID and then when I only have about 300 rows in the record set select answer from the record set using the questionID.
This is to update the answers for the survey. Also, another possibility would be update the recordset and then update the database. Is it possible to do that? Any directions to some code?
Doing a "modify a registry" html, I need to use the content of a recordset as an initial value for a text input , but it does not function the way I need to; this code gives me an error, look:
<input type="text" name="apeynom" size="25" maxlength="20" value=<% ob_rs("apeynom") %> >
the error shown is "Error de Microsoft VBScript en tiempo de ejecución error '800a01c2' Número de argumentos erróneo o asignación de propiedad no válida: 'ob_rs' "
how should be the sintax?
I need to format a recordset into a particular format i.e.
Dim myDataStore
MyDataStore = ...
so that myDataStore =
[ 'record1field1',
'record1field2','record1field3','record1field4','record1field5'], [
'record2field1',
'record2field2','record2field3','record2field4','record2field5'], etc
I can do this OK for 1 record and know I need so kind of loop but am not
sure how to go about for the whole recordset?
i ahve a recordset which takes data from a database using the shape command in a SQL statement. now i want it to show the data in a tabular fom such that the parent field has to it's right the child fields with out repeating the parent field again and again. And this done, the child field in the table should have the grandchild fields to is right and as before without repetition of the child field. and all of this in a tabular form!!!
i use a similar sql statement as below:
SQLTRY = "SHAPE {SELECT * FROM A} APPEND ( ( SHAPE {SELECT * FROM B} APPEND ({SELECT * FROM C} RELATE MachineNum TO MachineNum) AS rsparts) RELATECategoryNum TO CategoryNum)"
I have the following code:
Code:
Set RS = Server.CreateObject("ADODB.RecordSet" )
RS.CursorLocation = 3
RS.Open ("SELECT * FROM " & the_table_name & " WHERE " & job_id_field & "=" & request.querystring("job") &""), cn, adOpenDynamic
Both have connections via the following string:
Code:
set cn = server.createobject("adodb.connection")
cn.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(database_map_path)) & ";"
Only difference is that the newer version has the connection string included in another file, and the "RS.OPEN ..." line on the recordset code gives an error: "Too few parameters". Expected 1.