State Reason For No Record Match
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.
View Replies
ADVERTISEMENT
What causes this error:
Microsoft VBScript runtime error '800a01fb'An exception occurred: 'open'
It occours only sometimes
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
part of this code works but it seems to ignore the password check, any ideas?
If Request.Form("PuafoPassword") = Request.Form("RePassword") Then
strError = strError & "Passwords don't match.<br>" & vbNewLine
Else
If rspuafo.EOF and rspuafo.BOF Then
Response.Redirect ("thankyou.asp")
Response.End
Else
strError = "Username already exists, please choose another one" & vbNewLine
View Replies
View Related
If i am querying from a database with code like: Code:
Set oRs=server.CreateObject("adodb.recordset")
strSQL = "SELECT * FROM tblInfo WHERE Name = '" & request("name") & "' OR State = '" & request("state") & "' OR Zip = '" & request("zip") & "' "
oRs.Open strSQL, conn
Do while not oRs.EOF
Response.Write "<tr><td>" & oRs ("Name") & "</td><td> " & oRs ("State") & "</td><td>" & oRs ("Zip") & "</td>
oRs.MoveNext
loop
how can i diplay the results that match all three catories before partial matches?
View Replies
View Related
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.
View Replies
View Related
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&"'
but is shows the wide result
View Replies
View Related
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?
View Replies
View Related
can any one help me to read the datas from the excel sheet and match it with the database.i will be thankful to you if u provide me a sample code.
View Replies
View Related
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?
View Replies
View Related
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:
View Replies
View Related
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
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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.
This is the offending line:
Application["PageCounter"] = (int)Application["PageCounter"] + 1;
I downloaded the code from the book's website. I get the same result.
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
I have an asp/javascript page. The page has several hidden layers. When the user clicks a button, a layer becomes visible.
How can I check the state of a layer to see if it is hidden or not in asp code?
View Replies
View Related
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:
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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 ?
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
I am trying to Seperate the City and State from one table row to another table row:
Field is name LANDMARK with valeus as Atlanta, GA
Want to get
City = Atlanta
State = GA
into two sperate fields
This is what I have
"STATE = "Right ("LANDMARK",2)"
View Replies
View Related
I am trying to Seperate the City and State from one table row to another table row:
Field is name LANDMARK with valeus as Atlanta, GA
Want to get
City = Atlanta
State = GA
into two sperate fields
This is what I have
"STATE = "Right ("LANDMARK",2)"
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related