I have an ASP that I use send information to a remote server that validate a customers phone#. When I receive the response I would fist like to hide it from the customer and take the customers to the next page and utilize the information that was sent by the remote server.
I'm trying to pull a listing of customers for which no orders appear in the order table.
table names are "customers" and "orders" both tables contain a column named "idCustomer"
I thought performing a subquery that would sum up the total of order numbers would give me a means by which I could determine this, but I'm still getting incorrect results.
select customers.idcustomer,customers.customercompany, Orders.idorder,Orders.idcustomer,orders.orderDate from customers inner join orders on customers.idcustomer = orders.idcustomer where customers.idcustomer in(select count(idorder) as totalorders from orders where orders.idcustomer = customers.idcustomer and totalorders = 0)
In my access db i have a table that stores subscribed customers tbl_subscription contains firstname, lastname, email, how can i send email to all the subscribed customers or if i can choose who i can send to?
I created a web page from Excel2000, using "Save as web page..."...Publish function. then, I moved htm file to my IIS web server. Then I added a form control, and submit button.
How can get the data on the excel file using ASP from server side? For example, the value of Cell(1,2), Cell(2,3)....
What I want to be able to do is create a user control that will display an entire page page within it. Does anyone know how to do this or better yet have any same code?
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 have an ActiveX control in my ASP page that has not been signed yet, so currently just for testing I set the Security for Intranet to "Low". When I run the ASP page on my machine (the IIS is in my machine), I have no problem, except the page prompted me with "An ActiveX control on this page might be unsafe to interact with other parts of the page. Do you want to allow this interaction?"
But, when I run the ASP page on another machine (even though the other machine is also a development machine that already has the ActiveX control and I set the Security for Intranet to "Low"), it did not prompt me the above message, and I got an error when accesing any method of the AX control (e.g Object doesn't support this property or method 'myAXControl.method').
Is this because I have to create a CAB file and mark the AX control as safe for scripting ?To create a CAB file for this AX control, do I need to create my own VB AX Control project that contains this control and then create a cab file for this VB project ?
This is a standard ASP application that has several pages at the root withthe global.asa. I set a session variable session("accountid") = "123456" within an asp page and then response.redirect to the next page and immediately response.write session("accountid") and I get back nothing.
But if I set a session variable session("accountid") = "123456" within an asp page and response.redirect to a page in a sub directory and immediately response.write session("accountid") I get back 123456 on the screen.
I am having a problem with a site that I am developing - my aim is for it to validate as XHTML Strict however, I am running into a couple of problems validating it; in my Response.Write ASP script, I am not including " 's to define page element tags as they keep throwing up errors in the page. Code:
I've a strange problem with Windows Vista, running an ASP page on local machine (http://localhost/test.asp), the page does not give me any error but the asp code is not executed (simple code : <% response.write("hello") %), it show me a blank page, I think I've put all the setttings correctly, but maybe I must do something obvious to fix that.
I encounter a page reload situation in ASP. It is I need a way to differentiate whether the current page - "Application_Result.asp" got reloaded itself when user click on the browserRefresh button or is requested by the previous page "Application_Form.asp".
I tried using <%if Request.ServerVariables("REQUEST_METHOD") = "POST" then%> <!--it is requested from "Application_Form.asp, do something--> <%else%> <!--Application_Result.asp refreshed itself(such as user clicks on the browser Refresh button, do something else--> <%end if%>
However, in both cases, the IF statement above all evaluated as true. how to differentiate this two different behavior (Page Refresh versus Page requested by another Page) ?
I have page for user to update his/her details. What i want is after idle for more than 20 mins, the page will redirect to login page automatically. So that the user knows that his/her session already expired and need to login again.
But it doesn't working. This is because if he/she update the details (after idle more than 20 mins), and click the Submit button, it will go to login page and all the data will be lost. Code:
I am working with a developer, on two portions to a site, he is working in PHP and my work is done in ASP.
Is it possible for my pages to request data from a cookie that was written by his pages that are PHP but residing on the same server? Just want to make sure before I spend too much time planning out the development on my end.
I have an application which allow users to search our database. Quite a lot of search fields pull data from other tables. I don't want to populate the dropdowns (total 14 of them) from the database everytime as it slow the page load.
Instead I would like to have a link next to the text field which a user and click and the choices can be displayed and whatever the user click in the pop up I want to transfer it to the text box and close the popup.
For example there is a Textbox called country. The user can either type in the country name or click on the link which will pull all the countries from table in the database and which ever country user selects, the textbox is popluated with the country name and the pop up closes automatically. Code:
I'm trying to write an asp page line by line, as one would create a text file, only my file will end in .asp.
One line simply writes a close ASP code tag, or
FILECONTENTS=FILECONTENTS & "%>"
When this line processed, an error occurs saying that the string was never terminated because the asp page attempting to write this line of code to a NEW asp page reads that close ASP tag (%>), as an actual close asp tag for itself, instead of a STRING value.
How do I write this %> symbol to a new asp file, while still maintaining its purpose to close a group of asp code in the newly created page?
But as i carry some data from previous previous page, when i use (window.opener.location = window.opener.location), it can't capture my data as it just load the page. It will pop up error as no data captured :
Microsoft VBScript runtime error '800a000d' Type mismatch: '[string: ""]'
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 am facing a problem with CrystalReports for visual basic.Net 2003. I have passed almost through all the problems but still i get a message when i view some reports "Page header or footer longer then a page".
I am using ASP.net with VB and the developing muchien is running windows XP. the program works correctly to my computer but when i transfer it to the server machine i get the error .
The server machine is running windows 2000 server. It has the service pack on it and framework 1.1 with all the updates. Does anyone have a clwe?
What is the best way to lead customer from a regular page to a secured page?
Regularly, we use absolute path. say first ,a customer is on this regular page for general information: http://xxxdomain.com/index.html, then customer decides to buy something from our site. Then our program will provide an absolute path like this: https://xxxdomain.com/buy.asp.
Recently I am doing migration and feel that the absolute path is not convenient for program migration and domain merge. So I am wodering if there is any other way to do it? any suggestions and comments?
I have a form.htm page where the user enters an ID to retrieve addresses. Then PAGE1.ASP displays the addresses. From here the user selects an address and submits. Then PAGE3.ASP brings back further information. My question is how do I use one field from the address information on PAGE2.ASP to display on PAGE3.ASP? I know how to do it with textboxs and such but cant get RS data to hope page to page. I get no errors or anthing.
On PAGE2.ASP I have : <input type="hidden" name="CLIENTHIDDEN" value="<%=RS1("CICL_LNG_NM") %>"></td>
On PAGE3.ASP I have: clientname = request.form("CLIENTHIDDEN")
and to display: <td class=rt width="110" height="1">Business Name:</td><td width="849" class=rt height="1"><% =clientname%></td>
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?
Is there a way I can make my server's 404 page display even when a correct page is requested?
Here's what I'm doing: on a certain page, the requestor's IP number is checked. If the number is an intranet number (192.168.x.x or 10.x.x.x), then the user is allowed to see the page. Otherwise, I want the 404 page to appear, as if the page doesn't even exist.
I write a page in HTML ,user can print it I want to fix page size in print page set up to (legal) that doesn't need user every time change option how I can do this.
I am in the process of developing an application and would like to hide the query strings in the URLs. I want to POST data to a page then validate the data. If there is an error I have to send data back via a long query string. Is there anyway to POST data between pages programmatically?
I have a page (with a form on it) and when the form is submitted, if there is an error the page is redirected to an error page (i.e. your attempt was unsuccessful..etc) Once the user is redirected to the error page, after a few seconds the page automatically takes him back to the previous page he/she was on.
This is exactly what I want, HOWEVER, when the user is redirected back to the previous page, I would like for the page to be refreshed so the form can be cleared without the user having to click a reset button or anything like that. Does anyone have any clues to how may be able to go about achieving this?
I'm using Windows 2000 Pro SP4 and Office 2000 Pro Sp3.
I have some dynamic database pages that I do not want a user to see from their local cache of pervious visits to this page.
When these individual pages are called, I would always want them refreshed from the server. This is no matter what setting is used by the local browser.
The closest KB article I found was Q200131, but that was not helpful to me.
If a page by page determination of an automatic server refresh (rather than local cache refresh) is not possible, may I just set my entire web to be a forced server refresh for every page, thereby superceding the user's local browser settings.
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?
I have code that gets its values from a Request.Form it then inputs the data into the Database.The problem is when I do A Response.Redirect back to the original page I would like to pass a value back to a hidden field in the original page. Psudo Code
index.asp ---> User enters data from drop downs ---> values get passed to insertintodb.asp ----> then ----> Repsonse.Redirect's back to index.asp where I would like to get the values from the insert statement back into this page as hidden field so It can be passed to another page based upon the users next actions.
Well, it was my experience that the generated stuff didn't work, but I didn't want to make a definitive statement and have someone more knowledgeable come through and tell me how wrong I was.
So now I'll agree: DON'T use Word to generage your code. It is a very bad idea, and for what (it looks like) you're trying to do, it is so easy that writing it in notepad would only take a few minutes, and be much nicer.
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: