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)"
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)"
how to find all the cities in the US and relate them to their state? I want to have a drop down that goes from state to city. i.e. I choose Illinois from a drop-down, then the next drop-down is populated with all the cities in Illinois.
I have all the states in my db, but how would I go about finding all the cities? I have been googling this for awhile, but no luck. Is it an xml feed?
where i can get my hands on a script whereby, i pick the state, and a second dropdown appears with the relevant cities?
View Replies View RelatedMaking a site where I need a list of all the countries (which is easy to get) and a list of the major provences, states and/or cities within each of the countries. Does anyone know where I could find this info.I just dont feel like inputting info from my coffee table atlas for 6 or 7 weeks.
View Replies View RelatedI have a string called EmployeeName. This variable has the first and lastname of the employee.I would like to know if it is possible to extract the lastname into another variable for searching.
View Replies View RelatedIf I had a field which is let's say "123 Abc Street" and I would want to seperate the street number from the street name. I formulated this in excel:
=MID(A1,SEARCH(" ",A1,1)+1,LEN(A1)-SEARCH(" ",A1,1))
Where A1 is the cell...
Is the syntax the same in ASP?
Also I want to use this on a field called "Address" in my database, and then sort by the results of this formula. So could I do something like this:
SELECT * FROM Properties_tbl ORDER BY MID(Address,SEARCH(" ",Address,1)+1,LEN(Address)-SEARCH(" ",Address,1))
Did anyone know how to do the seperate? when i search "aaa" keyword from database. and their is 100 result i want to seperate it to dispaly 20 result perpage. like the search engine 1.
View Replies View RelatedI am working on a page which listing all product in one page, by should be in 2 column rather than just one.
PS: I can do show up all products in 1 column by do while not loo,...
can anyone reply with some simple asp code, just the code for seperate the listing in 2 column...
I just want to include a function in a seperate file so i can have it on a bunch of pages. What tag should i use?
View Replies View RelatedI want to have a page that has several links on it, each link will do a different search on a database. Now I know how I can achieve this using different pages. (a.asp b.asp c.asp etc etc for example) however i've noticed a lot of webpage that just use one search.asp page and then the id changes for example the address will be search.asp?id=1 for example, hope this makes sense.
View Replies View RelatedI have a dbase containing login details for 21,000 members. I also have a
forum that I am about to implement.
When the user gets to the main site, he has to login (this is done by
checking his credentials against DB1) When he is logged in, all his details
are stored in session variables. Clicking on the forum link will take him to
the forum where he has to log-in or register. Currently, the forum checks
cookies to see if there is a valid name and password and then checks these
against it's own DB (herein called DB2) or requires the user to
login/register
I plan to modify the forum so that the login is bypassed and the forum
accepts the current session name and password as the login. (This is so that
all names on the site main site, chat, forum etc are uniform, i.e Dave47 in
a chat room, is Dave47 in the forum, is Dave47 in the members area etc)
so...what I need to do (if you're still with me) is.
When a new user registers on the main site, his details are put into DB1
*and* DB2. , can I have two data sources open at once?
The reason I need two DBs is that the information in DB1 is a lot less than
is needed by the forum in DB2.
Also how can I copy selected fields from DB1 (name, password for existing
users) into DB2? like I said..there's 21,000 and to do it manually would
take forever.
I have a textarea that displays the values from the recordset. But how can I display each value in a seperate line
While not rsHires.EOF
Response.Write rsHires("Emp_Name") & "
"
rsHires.MoveNext
wend
I tried <br> too, but they get printed into the textarea.
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 RelatedIt 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.
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.
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 Relatedwe'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.
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?
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?
View Replies View RelatedI'm wanting to know how I can plug in a session state provider into ASP.NET. Currently you can use either the in-process, stateServer or SQL stores. Is the provider interface open and where is it documented? I've seen that Mono does provide their own state servers but I'm not sure if this is using standard provider interfaces.
View Replies View RelatedIs it possible to store session state for each separate user in a separate process? We have a COM component that we want to use that is not thread safe and has to be isolated. We would like to store this in a separate process for each user.
View Replies View RelatedI used KB 308150 as a guide to create a virtual directory shared by a few webstores that my company hosts. The virtual folder and websites reside on the same box. The shared directory includes code files used by all the webstores.
The problem - when a user adds items to the shopping cart, ***sometimes*** the session variables get reset and all cart information is lost. I can't consistently make the error occur - it seems to be random.
Also, if you have any different ideas on how to share code between many websites...I'm all ears.