Transfer Database Output To Another Website
Assume that there's a website named www.abc.com. There are 2 ASP files & one MS-Access database file in this site. The 1st ASP file is named "SearchForm.asp" & the 2nd ASP file is named "SearchResult.asp". "SearchForm.asp" houses a Form with a select list & 2 TextBoxes. The select list is populated from a MS-Access database table.
When the Form is submitted, the user is taken to "SearchResult.asp" which retrieves & displays the records that match the criteria that the user selected in the select list & the text they entered in the 2 TextBoxes in "SearchForm.asp".
Now the records that "SearchResult.asp" retrieves & displays - I want to display these records in a ASP file named "ShowData.asp" which exists in another website named www.xyz.com.
Is there any way by which I can display the records generated by www.abc.com/SearchResult.asp in www.xyz.com/ShowData.asp....
View Replies
ADVERTISEMENT
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
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
I tried using the following statements to transfer to html and asp page but i could not
response.redirect("&results('Url')&")
or
Server.Transfer(results("Url"))
pls tell me how can i transfer to html and asp page that i get its url from database...
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
There is no error in the code but can't get output from this code;
<html>
<head>
<title>g</title>
</head>
<% set db=server.CreateObject("ADODB.Connection")
db.Provider="Microsoft.Jet.OLEDB.4.0"
db.open "C:/data/CIS_data.mdb"
VarQuery="SELECT FullName,ICNo FRoM Patient_Details"
set rs=db.Execute(VarQuery) %>
<% Do while NOT rs.EOF %>
<% rs.movenext %>
<% Loop %>
<% rs.close %>
</html>
</head>
View Replies
View Related
I've written the ASP for a sports club database on a website. the problem I've got is that once the details are entered for the sports club onto the database. The inputter can not update their details, they have to email me to do it.
Does anybody know of any code examples I can look at, which will show me how to set up a system, so that people who create a database entry can go back and ammend it at a later date?
View Replies
View Related
For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics.
The benefit of the program is that it stores all kind of information in a central Microsoft Database that easily can be manipulated. A thumbnail of the picture is also stored in de MDB as long binary (jpeg format)
I made a small script that extracts all kind of information of the MDB by use of queries and ASP. This works perfect for string/numerical information.
I am wondering if I can also write the stored (jpg)thumbnail to the asp file so that I have a preview of my picture.
Can this be done? What is the syntax?
I tried already :
Response.BinaryWrite BinData
Where BinData is the contents of the Thumbnail field. When I take a look at the MDB table in design view, the DataType of this field is "OLE object", if I open the table, the contents of the field displays "long binary data".
View Replies
View Related
I am having an Excel where I maintain my data. I want to extract details from a website based on the data that I have in my Excel(i.e login to that website,post the data to the Website and get the details from the page n update it in my excel). How can I do this?
View Replies
View Related
I've published my asp file to the website. I've uploaded all the asp files including access database and it works fine. But the record is not updated until i upload the latest database.
Actually the updated database stored in the my local server. Is it possible to access the database on my local server? It means, user can access all the updated directly.
View Replies
View Related
For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics.
The benefit of the program is that it stores all kind of information in a central Microsoft Database that easily can be manipulated. A thumbnail of the picture is also stored in de MDB as long binary (jpeg format)
I made a small script that extracts all kind of information of the MDB by use of queries and ASP. This works perfect for string/numerical information.
I am wondering if I can also write the stored (jpg)thumbnail to the asp file so that I have a preview of my picture.
Can this be done? What is the syntax?
I tried already:
Response.BinaryWrite BinData
Where BinData is the contents of the Thumbnail field. When I take a look at the MDB table in design view, the DataType of this field is "OLE object", if I open the table, the contents of the field displays "long binary data".....
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 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 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
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
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
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
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
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
