I have a form on a .asp page that when submitted via post to itself its values are grabbed by asp and put into an sql statement. From there the records are generated depending on the criteria selected in the form. What I would like some help or guidance is if no records match the criteria how can I generate a meesage that states which criteria in the request did not match.
So if the form submitted is looking for a home in Michigan, Ranch Style, with 2 car garage, 3 bedrooms, 2 baths, between 1000 to 1500 square feet and there is no record that matches that criteria a response is given that the reason for no match is because the 2 bath criteria didn't match or because the 2 bath and the square footage criteria didn't match.
I have the form working with asp already. When there is no record I have a simple statement that says "sorry, no homes matched your criteria" I would like to state why there was no match.
I have developed an application in asp which is available over intranet. the first page of the site is a login page and allows the users to enter their credentials and login.
The login page is a simple html page. The site works fine , but after quitting if it is left idle for about 30 mins, the next user who tries to login it takes about a minute to process to finally enter the site. after which it again becomes fast.
what can be the reason for the site being slow only when it is accessed after being left idle for some time?
what might be the reason for losing session variables, i was working on a page where i had to stroe a array in a session(trust me that was the only 'way' i could imagine doing it), and i am losing the session variable, its just returning empty values.
Not sure if this is the right place but I need to get this website going and am having problems with the ODBC driver connecting to the SQL server When setting up the driver I am getting a sql error 18452 login failed reason: not associated with a trusted SQL connection I am at a loss as I installed this on another machine and it worked.
I want to know how to make a match for a text , for I'm wan't to search for this in the db . the search i made search only for the exact text user inserted so if the user misspelled the word the search will give him zero result. So i want to seach for any part of the word or if it is aword in aphrase.
hi there i need to display results that do not match those in the database. I have an excel file and i upload it, inserting the records in a temp table. Than i compare the values in the original table and the temp table. All i want is the values that do not match..i did this:Code:
sql = "SELECT TempSerial.SerialNo "&_ "FROM TempSerial, Serial WHERE TempSerial.SerialNo <> Serial.SerialNo "&_ "OrderBY TempSerial.SerialNo;" Set RS = objConn.Execute(sql)
i displayed the records with <%=RS("SerialNo")%> but i get all the records in the temp table displyed.
I have a web page programmed in ASP that creates a calling list based on the user's preferences, which queries the information from a SQL 2000 database. I want the user to be able to select whether to create different lists based on time zones or one list with all time zones.
The user should be able to mix and match time zones. However, I'm not sure how to do this task. An example would be that the user wants east coast and central in one file, then pacific and mountain in another, but it could also be pacific in one and east and mountain in another, and the possibilities go on. The database is set up with all the information needed, but I'm not user how to code in ASP for the different possibilities.
i want to provide exact match. e.g. if user enters pharma machine result only display records containing pharma machine and not records containing either pharma or machine.
database table: company_info
database field: products
user entered search (field name): st
i had tried the following
select * from company_info where products like '"&st&"'
I have a query that accepts input from a form and deletes a row if the form input = the value in the table .if the input is not in the table how do i post to the user that this data was not found in the table?
I want the site to look the same on all browsers. All the tables and stuff are based on percentages but this doesn't fix the images. The images are based to fit 1024x768 but i want them to look the same on every other resolution. Can someone help me with a script?
I currently am using a script which submits full state names to a payment processor. However, the payment processor only accepts 2 digit state names. Does anyone have a premade code for asp that converts state names into 2 digit ones. Code:
It seems that I am assigning to the session rather than comparing against. I want to compare it in the first peice of code but it seems that I am assigning to it. When the user first requests the page they are not a member.Heres my code:
If(Session("IsMember") = "True") then 'Do Nothing End if
'should still not be True
If(Session("IsMember") = "True") then Response.write("IS TRUE") End If
'Response.write is working telling me that the first part of the code assigned to the session
how can i pass state for each user through pages without using session,cookies,hidden form fields,querystring or database, which knowledge base article 175167 refers? i don't want to build a form with hidden fields and get it posted on the client. it seems possible using server variables, response.addheader method, but how can i use it?
I hav developed web application using ASP.net 2.0 there are just 2 pages only. Both are works fine in visual studio. But same when i run on IIS 5.1 ....the page without session variable works fine.
But the page with...even the Sub() with session variable won't works.....even it automatically reaches the last sub of the program.
What are the changes i hav to do in IIS / application or web.config file.
I am learning asp.net using Zak Ruvalcaba's book from Sitepoint. When trying to do the example on application state from chapter 11, i get the following error:
Object reference not set to an instance of an object.
Is there any way a Form can be made automatically not retain its field values after it has been succcessfully posted in classical ASP. Something like the way ASP.Net can perform state management in postbacks automatically.
we've just set up a subdomain,'demos' for one of our projects that normally works fine. on the login page, if the user enters the correct username/pw, we write session info and then response.redirect to the home page. this works for on the normal site, but session state info is dying on the demo subdomain.
i'm sure the session info is being written since i can see it when i response.write the value. also, the response.redirect uses a relative path, so it's not that we're accidentally changing domains.
We have an ASP site that uses a MySQL db backend. Usename/Password authentication is stored in db tables. We are currently using session variables as a means for validation when the user navigates to new pages. Generally speaking, all this does and has worked fine
The issue is with abandoned sessions. For instance..
Joe user clicks the [X] in the upper right hand container, closing out IE or firefox. IIS will not terminate the session for ~ 20minutes(default), leaving these resources unavaliable.
In our situation, (and possibly a different issue) unless the user clicks the [EXIT] button we've provided, not only does the session persist for 20 minutes, the login state saved in the MySQL table stays locked. Before the User can log back in, they need to call us to reset their state.
I'm looking for some kind of solution to address a user exiting the application abnormally. I am not sure of the correct procedural methodology, but I would think that some kind of process or event trigger would run in the background looking to cleanup stale sessions. Code:
I have a problem where the session state will not be enabled on the server. We are using Framework 1.1, a non-Sql Server database, and will be moving the application to a web farm in the future. Is there any way to keep the session state on a relational database that is not Sql Server? If so, how?
I was thinking about disabling session state on some of my pages by doing this: <% @ EnableSessionState = False %>
My question is if I disable the session state will the page still reset the session timeout (eg. back to 20min. default) when that page is loaded? I need it to reset the session timeout.
I'm looking for a working example on how to share session state between ASP and ASP.NET.The solution of Y Yeung of Microsoft seemed to be a good solution but I did not get the asp part working.Anybody tips, tricks, links ?
I have been storing an object as session variable, such as
set session("oRS") = Server.CreateObject("ADODB.Recordset")
The page then redirects to another page. i need to use this object on the called page, but i encounter an error saying 'User session has expired.' On checking with the code, it was found that the sesion variable has not maintained its state for object 'oRS'. Although, session for string type variable are maintained.
i have a form having hyperlink calling the same page.on click on hyperlink i am
submitting form "Onclick=dosubmit(form1);" dosubmit{ document.form1.submit(); } but i am not able to retain session data.how can i retain session data.
I will soon be undergoing a project where I will be migrating four to five web applications, developed in classic ASP, from a single Windows Server 2000 to a web farm that will utilize two, Windows 2003 Servers.
All of the applications utilize user/session management and I know that ASP's built-in session management cannot be carried across multiple servers.
I've been researching products available for purchase out there on the web, which allows you to include new code, which overrides ASP's built-in session management, by using a database to store sessions.
They all advertise that their solutions simply require just one line of code to be added to each ASP pages that uses Sessions, without any other changes to the existing ASP code.
Can someone who has done something similar advise on their experience? Is this really as easy as they are advertising, or are there other issues to take into consideration? Code:
We are running windows 2000 with dot.net framework 1.1 on IIS 5.1. This is an NLB architecture with the session being stored in an SQL DB. We have been coding and deploying using ASP.NET with no problems however the 'powers that be' have recently bought an online booking application which has been coded using classic asp.
We have set the session location in the machin config of the framework stating
mode="SQLServer". Will this ASP use this or continue to store the code InProc?
I am having trouble maintaining Session state between pages within my website. I had someone test the pages on their website and sessions state was maintained between pages, but for some reason, the same pages on my server do not. what might be happening?