Transfer SQL Data
I need to make a table's data available to users. The table is about 150,000 rows x 20 columns. So Excel is out of the question. I think the next common file types would be MDB or DBF. Using ASP, what are the steps to converting this data to one of those file types, then ZIPPING the files for download?
View Replies
ADVERTISEMENT
I am creating a database and it has to be up dated from all over the county.But Unfortunately there are some users who have only telophone connection not internet connection. Is ther any way that I can allow them to up-date my database using telephone line i/o interne.
View Replies
View Related
I would like the value of the textfield from text1 from Select_License.asp to be transfered to swname from License_add.asp when i click on the Next button from Select_License.asp
<html>
<head>
</head>
<body>
<form name="form1" method="post" action="">
<P>
Software: <INPUT name=text1 >
<input type="submit" name="Submit" value="Find">
<%
on error goto 0
If Request.Form("Submit") = "Find" Then
description = Request.Form("text1") .....
View Replies
View Related
Can you pleaseeee let me know if what I am attempting to do is possible? ....and how. I have a Access database at backend of my ASP site. Is there a way in which I can design a page which will pick up only the records modified/added today in one database and add those to another database?
Is transfer of data between two databases possible?
View Replies
View Related
How i can know the data tranfer rate for particulat directory on server using ASP?
View Replies
View Related
Any ideas on how I can set some data in 1.asp, then have 1.asp do a server.transfer (or .execute, come to that) to 2.asp, and have 2.asp access the original data?
I'm aware that the Session object fits the bill but want to avoid using this if I can. Having said that, the nature of the data is very much per-user so things like the application object are definitely inappropriate.
Another way I can do this is redirect/querystring, but the additional roundtrip here is not attractive.
Any other (sensible) methods anyone can think of?
View Replies
View Related
I have an asp page that collects data from a database and then displays it in a table on the page. I also want to be able to put this information into excel. I know how to get the page to load up in excel and then display the data using the following command -:
response.contentType = "application/vnd.ms-excel"
however I want it so that there is an Extra button on the page that the user can press to transfer the data accross. Does anyone know how to do this?
View Replies
View Related
I need some ideas in this if you can please help me.The folllowing is the scenerio:
I have a form which is the normal html with some validations and scripting done in javascript and i have a text box by name ticket no when the user enters a ticket no which exists in my database I need to update all my other form textboxes and textboxes with the data in the database else I need to show a alert that this doent exist in the database.
usually the event handling is done in javascript but now i have to call server side connection I have no clue how to do this.
View Replies
View Related
Our asp programs seem to have different behaviors when users use IE and firefox. One of most annoying things is the data disappearing problem in IE but not in firefox.(Note: Sometimes a search program can run much faster in Firefox than in IE, don't know why)
For example, I have an internal user interface which they can do different product data
entry, the program will use Server.Transfer to different asp program for data entry.
Page1---UserInterface.asp
Select Case Request("Product")
Case "Sel"
Server.transfer("/Virtualdir1/test1.asp ")
Server.Transfer("/Virtualdir2/Test2.asp")
Case "Bear"
Server.Transfer("/Virtualdir3/test3.asp")
Case "IMED"
Server.Transfer("test4.asp")
Case "AC"
Server.Transfer("/Virtualdir4/test5.asp")
Case Else
End Select
When user finished data entry on test1.asp(second page, the web address will still show UserInterface.asp page as you know), click continue, on the third page if they found something typed wrong, if they click back button in the broswer, all data on the second page is gone. This only occurrs in IE, Firefox is fine.
It's very annoying, how can I fix it, if not, is there any other way?
View Replies
View Related
I like to know how to write this specifc function on ASP where the user eg: display a set of records on the webpage. Example the data are ID, Name and address.
Lets say i display the data on the webpage and i set the Name as the <a href>. So when i click on the name, it will move to another page with the id of the specific name. Code:
View Replies
View Related
Any idea what is causing this error? 006~ASP
0230~Server.Transfer Error~The call to Server.Transfer
failed while loading the page.
Just read about benefits of Server.Transfer over
Response.Redirect, replaced, and getting the error.
View Replies
View Related
I have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
View Replies
View Related
I am a new programmer seeking a right way for transferring data between forum to forum, as i am creating a site wich have a page keeping 20's of server controls like drop down list and text boxes the value of ddl2 changging on change of ddl1 and displaying its corresponding value in text box and i have 10 rows in this way and i wanna display all selected values of server controls in next page as report.
View Replies
View Related
I have 2 pages the first one has a text box, beside the text box there is a link when you click the link new window will come, and this window has a table retrieve the employee names from the DB, and these names are links, I need when I select the name should transfare to the first page , How ?
View Replies
View Related
i hope no one is getting sick of my server.execute/transfer questions..
does server.execute return a value? im wondering what happens if an error
occurs in the .asp file that i'm calling with the server.execute command??
is there a value/flag i can set in the case of an error that can be seen
once i return to the calling page? if not i was thinking that i would have
to use a session variable for my error handling.
i want to stay true to the model, view, control architecture so i don't want
to simply redirect in the case of an error - i want to send a value back to
my control page which will decide where to go.
View Replies
View Related
I would like to use Server.Transfer to redirect users to a given page,
while maintaining the state of form fields. This works fine on a single
server.
However, this will be deployed in a load balanced environment. I know
that Session variables and load balanced environments don't mix. Do I
have a cause for concern with Server.Transfer as well?
View Replies
View Related
I would like the value of the textfield from text1 from Select_License.asp to be transfered to swname from License_add.asp when i click on the Next button from Select_License.asp ....
View Replies
View Related
The Transfer method allows you to transfer from inside one ASP page to another ASP page
Is there a similar thing - The Transfer method taht allows you to transfer from inside one ASP page to a DLL.
View Replies
View Related
I m using ASP(not .net) ,I want to use server.transfer from a.asp to a.asp (the same page), but i want to remove all the querystring before transferring the page.........although response.redirect can do, it cannot fulfil some response.write b4 the redirection.
View Replies
View Related
I am using the following statement in my asp page , it doesnt work
server.Transfer(ftp://mymachine/dir1/data.zip)
View Replies
View Related
anyone in here got an idea on how i could transfer a value of a form text to another asp page just by using <a href="">
View Replies
View Related
I'm doing file uploads using the free component ASPSimpleUpload but I have problems of file transfer when the file size is too big or the connection used by the sender is slow.
I'd like to transfer file via FTP from a web page instead of using ASPSimpleUpload. Has somebody already done that and has some code or some links to give me?
View Replies
View Related
Is it possible to transfer a dynamic, asp site built on top of an Access database onto a cd for demonstration purposes?
View Replies
View Related
Currently I have someone wanting to transfer their site, ran in IIS/ASP, to one of my servers so that I can host if for them. I am running Windows 2003 Server with IIS 6. I have a disk that has the files for the site (from root down) I created a new site, put the files in there and configured the properties in IIS, but I only get a 500 (Internal Server Error) error page when it tries to run. I set the home directory, permissions, documents to point to the index.asp file, etc...
View Replies
View Related
How would i embed the Server.Transfer() into the button onClick() event.
I did try this:Code:
<td><input type="button" name="edit" value="Edit" onClick="<%Server.Transfer("edit.asp")%>"/></td>
but this will display the edit.asp page without the need to click on the Edit button.
View Replies
View Related
i just realized that II5 is not with me i am running PWS on win98.so can i use response.redirect so that i can transfer parameters like a variable or a value?
View Replies
View Related
I would like for an ASP page to transfer a text file (from the same
directory the ASP file is in) to another Web server.I don't mind if the code is in ASP or VB.I suspect that there is a way of having an ASP page conduct an FTP session
to transfer the file. would like to do this without a component as I'm looking for source code.
View Replies
View Related
My team would like to use an ASP script to have an automatic transfer of files to our live server happen each evening at a predetermined time. I was looking on the web for a script but all I could find is user driven upload scripts.
Is there anything out there that will facilitate automatic uploads of several folders and files via ASP scripts?
View Replies
View Related
I rescently have asked quite a lot of questions in this forum but I can't help it since I am still quite a newbee at ASP and sometimes just can't get behind a problem. So if somebody has got a solution please post it:
I now have a working cartarray and now want to transfer some of the data from the array into an access database table. Code:
View Replies
View Related
What i would like to be able to do is have two listboxes side by side, one will have all of the main categories and the second will have all of the sub categories in it.
I populate the first list by using this code:
<option value= "<% = rs("cat_id") %>"><% = rs("cat_name") %></option>
Now what i would like to do is when the user double clicks say the second item on the list, the listbox next to it will display all of the items that are under the main category they just double clicked on
View Replies
View Related
I'm looking for an ASP (dotnet is alirght too) File Transfer system for use by internal employees and customers. I need to be able to control access to the system on a user and group basis and allow people to upload and download files.
View Replies
View Related
Does anyone knows of a way to copy some file fro the server to another computer WITHOUT using ftp?
View Replies
View Related
I searched and searched at Google and couldn't find a thing that helped me here...
Many results found for "ASP Upload Script" but what I want is a "ASP Download Script".
In my website, I have a script that authenticates the user (login) and then checks a few informations. But what interests for this topic is what's called next: a file download page.
Of course I could simply ask the user to Save File As in a location I would inform him, but I would like to have a script that would do that for him. It gets the file from the server and transfers it to a default folder in the user's computer.
View Replies
View Related