my web application has user name and password, whenever user logged in i set his status in database as 1 so that only one user can logged at one time with same login and i
write a code to set status to 0 on logout menu, but if session expired then status will remain 1.
i have written code to set staus to 0 in onSession_End sub but it not work all the time. Sometimes it works and sometimes not. So i m looking for an alternative way of doing it
My web site HTML comes from a database via querystring e.g. page.asp?pid=55. I have a separate asp search page, search.asp. Its output is retrieved by an ajax call from page.asp and its HTML is then neatly wrapped and styled by page.asp.
I want search.asp to recognise if it is not being called via ajax frompage.asp, but directly e.g. via the address bar (and if so, redirect to page.asp). Do I need to put something into the posted string, or (better) is there an asp method that can do this?
The ajax call is function GetSearchPage(st) { var poststr = "searchterm=" + encodeURI(st); makePOSTRequest('/search/search.asp', poststr,'divFullSearchDisplay'); }
Is there a way to detect when this function has finished execution as i want to page a page loader on the page until all the HTML is build and ready for rendering? I have the page loader in a div so when the above function finishes i would like to disable or hide it via Javascript. That bit is fine it's just the how to send a call to the Javascript so the DIV can be hidden is the problem.
I have a logout button for my admin system. I really need on logout, to go back to the login page. This is fine but I also need the session set to false. I could do this via using a secondry page called logout.asp, and place inside that something like session.abandon and a response.redirect. But I do not wish to have a secondry page.
I have tried and tried to "include" this in the blogger template, so that I can update the menu dynamically, without fiddling with a cumbersome blogger template all of the time.
The question is, does anyone know how I can "call" this file in to the template successfully?
When some of the SQL Server stored procedures I have written are called via my Classic ASP page I have written I get the following error in the cell that is supposed to be retrieving a single result:
"ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/Default.asp, line 130"
I have no idea why this could be occuring. Some of the other stored procedures work just fine. Any one have any ideas?
I don't know if this is a truly esoteric question, or not, but I'm wondering how (or even if) you handle a timeout on a transaction within a stored procedure executed in a Stored Procedure?
A theoretical example of the stored procedure (sadly, I'm not allowed to post the actual code):
Create proc sp_testproc @myval int, @outval int OUTPUT as
begin tran
select top 1 @outval= myname from mytable where recid = @myval
update mytable set myname='xxxx' where recid = @myval ...
This is a mix of technologies so I hope I've put this in the right place.
I have a system where people can sign up to a data feed. They place a single line of Javascript on their web page and a formatted banner of products is displayed based on the options they have chosen in their affiliate account.
The original system was built by our developer 3 or 4 years ago, and worked fine. However, he built the system using two ASP files - feed.asp which looks like this: