what I want to make actually is to take the results of a search engine that I use, which are in form of HTML or ASP and transport that results in a DataBase. For example, I wont to place as registrations in the DataBase the equivalents URLs and their descriptions from the results of search. I use MS Access, code asp, HTML , Javascript .
QUESTION! How can I insert the content from an HTML or ASP page into a dataBase? How can I determine from what point to what point a string it will be entered in the first cell of table and afterwards in the next and next ....
OK - I have a shopping basket with data in a database. Once the person has successfully completed their order I want to be able to send them an email with the products ordered roughly in the following format:
Product Price Quantity
prod1 £6.99 1 prod2 £5.99 2 Postage £0.50
Total whatever..I'm lazy
Formatting would be a little different (just spacing out the prod table a little more.
Any ideas or links to scripts that do this?. I've been looking for a while now but have had no luck in finding a solution. I just want to send a text email (and not html).
The other thing is that on the last page but one, this shopping basket is displayed. Is there anyway I could capture the html data from that page, store it in a session variable and then generate the email after the order has been completed (so sort of like sending a mirror of that page)? In that case having a HTML formatted email would be ok.
My client has various Access databases that they want to be able to access (using MS Access, not through ASP pages). I thought I'd be able to create the link from an HTML page but when I do that and click the link, the file is downloaded to the local temp folder. I want the database to open directly from the web server, and then changes must be saved.
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:
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:
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 ....
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....
I'm trying to add logging to my web application, but I found a strange problem. Whenever I execute a Server.Redirect(Page1.asp) I can use the request.ServerVariables("SCRIPT_NAME") to get the current page name. However, if I use Server.Transfer(Page1.asp), the value of the server variable equals the refering page (In this case default.asp). How do I get the value of the working page regardless of the transfer method.
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
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.
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?
I'm currently writing an asp page . There are many variables inside i want to transfer to another asp pages to use them. They are just normal variables calculated in this page (not variables received with http query ), therefore i dont know how to receive and use them in a new asp page.
--------------------------------------------- The Execute method allows you to call another ASP page from inside an ASP page. When the called ASP page completes its tasks, you are then returned to the calling ASP page. The overall effect is very similar to a function or subroutine call. Any text or output from the called ASP page will be displayed on the calling ASP page. The Execute method is a more useful alternative to using server-side includes.
In contrast, the Transfer method allows you to transfer from one ASP page to another without returning to the calling ASP page.
There is one mandatory argument. ---------------------------------------------
Fair enough does what I need it to. However, I've run into a glitch. I understand the point about it being like calling a sub which means anything set within the executed page will be considered local and so anything set within it won't work in the calling page. What I don't understand is why the executed page can't read objects which have been set in the calling page before the execute???
to download my asp page to the client. The download process works great but when I open the .doc file it is missing the image included within the html <img> tag of the .asp page. How do I get the image to come down with the text?
I have a table having 3 columns. There is a checkbox for each line. I need to get those lines whose checkboxes are checked, and show those lines to another webpage. Is there any way to do that? My concern is that all information in the table are in <tb></tb> pairs without any name tag. Any idea?
I am looking for a way to pass an ADO recordset that has been retrieved in an ASP page to another HTML-page. Is there someone who can provide me with a small sample or a link to see how this is done?
I have a ASP Page[inline frame in an html page] that does login to a database.
When the user visits the site, the first attempt to login will always failed and session is broken. Login name and password are correct though.
Only when the user re-try agian he/sge is then able to login to the site successfully. Can anyone tell me what could had caused the first time login failure?
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
I have a web form page that passes values to an asp page, in which an email is sent to the customer with those values. The email functionality works fine. But I also want to display these values on a separate "thank you" web page after that.
What is the code to make those values display in the "thank you" web page? Does this involve adding code to the asp page and the "thank you" html page as well?
how to convert a database table into an html file via FSO and whether more seasoned asp programmers recommned this route. The main reason I am attempting to do this is becuase we are constantly being told by so-called marketing gurus that 'html' pages are more search engine friendly. Code:
I have a database feild that I need to have html code entered into. Short of getting the clients the copy and paste code into <textarea>, is there a simple wysiwyg editor to do the job?? or another way?
I have done search on the board (and google too) to find a way to display properly my HTML code that are already inside the text in my database like < br > and < i > and so on. but when I see the result in my browser (using ASP) I see the HTML coding and not the result of the code.
I have found here in the Funky Functions in ASP thread probably something useful but I cant make it work (second post, the one made by aspapp).
I developed the asp page which shows the all transaction records of the particular day in tabular form.But the probelm is that when i take print preview of the page directly from broswer ,print result takes more than one page so i want to reprint report header and then rest of records
I am using ASP to generate an HTML table from a database. I use FSO to output a file with an XLS extension then open it. I can set the column width and row height; I can set the font family, size, and weight. I know I can include formulas in a "cell".
What else can I do when I generate the table that will take effect when the file is opened in Excel? I'd like to do things like autofit and sorting. The client does allow Office Automation on the server so I can't write to Excel directly.
I have a html form, and I like to know how to capture the values in the form after the user hit the submit button. How do I capture these values in an ASP page?
I have developed a HTML page containing form and table having some fields, Now What I want is that when I Click on Submit Button then all of the Form Fields should be email to a particular email address just like as they r on the form. So my problem is that i have created an ASP page containing code about to pick data form form fields n send it to email address i mentioned, But i dun know how to request an ASP page in a html page, Iam using
Just after the table creation but it doens;t work because when i click on submit it ask me to save or open MailForm.asp. So is there anyone who can explain me how to run this file directly with in html page or how to use asp code in html page.