Reset To Default In SQL
Is it possible to reset a SQL field to it's default setting? For example, someone changes FIELD1 to "John Doe" and the the default is "YOUR NAME". Can I reset it back to "YOUR NAME" somehow?
View RepliesIs it possible to reset a SQL field to it's default setting? For example, someone changes FIELD1 to "John Doe" and the the default is "YOUR NAME". Can I reset it back to "YOUR NAME" somehow?
View RepliesI'm using serverXMLHTTP to retrieve pages, but in some cases its throwing "The connection with the server was reset" back to me, im not completly sure what the message means, when i used other variations of the the http component i get similair errors, though sometimes it pulls through (once every so many'th times)
View Replies View RelatedHow can i reset the combo box or <select> in asp?
View Replies View RelatedI have a a reset button on my page but when i press it nothing happens? Why is this?
(input name="Reset" type="reset" id="reset" value="Reset" />
This is the message i get when we have our application running using our own ISAPI code, it desapears when we don use the ISAPI filter, Can anyone help, It seems IIS assumes that we have a virus as stated by microsoft Message
IIS ADMIN SERVICE TERMINATED UEXPECTEDLY XTIMES EVENT ID
7031
SMTP SERVICE TERMINATED UNEXPECTEDLY XTIMES EVENT ID 7031
FTP SERVICE TERMINATED UNEXPECTEDLY XTIMES EVENT ID 7031
It only happens when we are using our own ISAPI FILTERS .
I've been trying to reset a variable from a popup window. I want to be able to provide member stats for a message board but every time I click on a different member the first members stats keep getting displayed. The variable needs to be reset after the popup window is closed but I don't really know which way to go about it. I've tried methods such as member="" and stuff like that but I've still got the same problem.
function info()
{
window.open ('member.asp?username=<%=sectionRS( "Username" )%>','website', config='height=300,width=400,toolbar=no,menubar=no ,scrollbars=yes,resizable=no,location=no,directori es=no,status=no');
}
I have a form on which I have a INPUT Type='Reset'. On clicking this button all the fields on the form should reset except a few. Is it possible to do this by setting some property of the control or do I have to specifically write code form that?
View Replies View RelatedI have a search page where i have like 10 combo boxes and some radio buttons and check boxes.
Now when the page loads, i do some selection in the combo boxes and when i press reset button it clears all data in the form elements.
But when i select things in combo boxes and do a search by clicking OK button then the search results are displayed there and now if i want to clear all the form elements , i tried to click reset button, but when ever i did a search ie click ok button and after than press reset button reset button is not clearing the form elements.
Does anyone know of a way through asp code to drop a users application
connection and prompt them for their credentials? I would like to offer the
ability to log into the application with different NT username and password
with them having to close and re-open their browser. I am using basic
athentication for my application.
I created a new database using the Frontpage 2003 wizard. Everything works Fine but I would like to have the option to Delete the database (What I mean is anything that was puyt in to get rid of it.) after they are done putting in what they have to put in. Is there a way to do this I can't find one.
View Replies View RelatedWhen a user goes through our online purchasing system and their session
information gets recorded, when proceeding to our next page and then
clicking the back button in their browser, the session variables are reset.
Its not that the session is timing out or being forced to end when visiting
the next page (or when reloading the previous page), but regardless, the
variables are reset.
This is a problem because during the purchasing procedure several items from
the order go missing, meaning the purchase doesn't go through properly.
Any ideas why a simple back button press in the browser by a user would
cause a session to be reset?
is there a small command that resets a whole accessdatabase? I need a code that deletes all records in a database. Does anyone know how I can do this?
View Replies View RelatedThe LDAP is located on the mainframe. I can successfully select records using some ASP (Classic) script. I choose to use ASP classic because there are very few examples I
could find of using the directory services other than the MS AD.
Anywho, as I said I can select the LDAP record using a mixture of SQL and LDAP dialects but now I am at a standstill. I have been asked to create a form to reset the passwords on both the mainframe and the network at the same time.
The actual user accounts on the mainframe exist in RACF and the "field" I need to access is racfPassword, could this be accomplished via a SQL Update command using the same mix of SQL and LDAP dialects?
i use nt user authentication on our iis 5.0 webserver. user get a login popup for username/password when they connect to the website. i also use session handling which works fine. the session ends when the user uses my logoff process.
but unfortunately, the remote_user server variable is still filled with the username. so the user can just call the website again and he does not get the username/passwort pop up. is there a possibility to empty/reset/destroy the remote_user servervariable
(maybe on client side, cookie)?
My website uses cookies to persist a certain amount of data on the client. However, occasionally the cookies will disappear or be set to an empty string for no discernable reason. It does not happen in our development environment at all, but does happen in our production environment. We looked at all the likely settings and they were identical on both the production and live servers.
We set the cookie domain properly and the cookie path.
Has anyone seen similar behavior? And if so, what did you do about it? What IIS settings should I be looking at? Could it be a service pack that was installed on one machine but not another?
Do you know how to reset session.timeout after user click to extend the session timeout?
For example, default session.timeout is 20 mins and 2 mins before will ask whether extend working on the site or logout.
Is there anyway to reset cookies values when window closes?
View Replies View RelatedI have very weird problem on my server, when I run this function: Code:
View Replies View RelatedI have an asp form. The page is kind long. After user scroll down and make some change on the items, the form needs to be refreshed with new selections (some controls may disabled based on the selection).
My question is, each time after the refresh, the form always go back to the top position. Since the form is quiet long. User may get frustrated if he/she have to scroll down the page to find the current position each time after make a selection change. Is there a way to remember the document postion before refresh the form, and reset the position after the refresh? I guess some javascript code may be able to do it. But so far I have no clue at all.
I'm using the detailsview to perform edit and insert of new records via an
object datasource.
If an error occurs on the insert, I want to preserve the data the operator
tried to input, along with my error messages. Currently, it appears that the
detailsview is trying to rebind after the error, to the empty/null detail
item(on insert it is null), and thus I lose all the operator's input. Can
someone suggest the proper way for me to achieve the persistence I'm looking
for?
I have an Access table with (among others) a number type field.
I'm building a web form which will add a new record to the same table. My problem is as follows:
I need to retrieve the (number) value from the previous record and increase it by 1 when submitting the new record. Also, this number should reset to 1 whenever a new year occurs.
Was that clear?
if for list box, check box or radio button. in asp. how can i write to make it a default value??
View Replies View RelatedI'm using a binary stream to send down a file from the web server. I've been having trouble with IE and getting it to recognize my file. I've added the filename as a paramater(?filename=file.jpgw) to handle IE's mime type mangling, but I'm still having trouble with IE's default Save As Type being HTML. When we send down a jpgw (geo-jpeg) file IE wants to save it as an HTML file. I've got the correct filename showing in the Filename box, and if I choose the All Files option from the Save As Type drop down then the file is saved with the correct extension. I'd like to have the All Files option choosen by default. I know it's just a couple of clicks but we have some noivce users that can't seem to get that
View Replies View RelatedI wrote an application that generates reports.It then presents a page where
I click a button [javascript:print()] to open the print page. However, I
have a fixed printer and would like to know how to print to the default
printer without me clicking anything. So the page will just load up and
print. Or when I click a button. I just don't want the select printer screen
to pop up. Much similar to clicking the print button on top of the address
bar in Internet Explorer.
my new site uses default.asp, instead of using index.asp. this is how my old site was done. now i get error 500. is this because it is trying to find index.asp or because my database isn;t workjing properly? i'm tired and being stupid i think. it's reall probably the database, but i just want to make sure in my sleep deprived state.
View Replies View RelatedI have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
I'm facing a peculiar problem..I've multiple text fields in a form.
One of the text object(named-A) is getting populated with the help of some JavaScript code written in the ASP page .
Now, when I click the "Reset" button, all the text objects are getting cleared of their content,EXCEPT "A".
I want to make it so that when the user is looking at a rendered ASP page
and they hit the ENTER key, one of the buttons on the form gets "clicked".
In other words I want for the user to not have to click on the button, and
just hit ENTER instead. How do I specify the button?
This is the code for a combo box, and I would like to make certain value the default value, so that appears unless users select somthing else.
call rs.Open("SELECT * FROM Trim.dbo.luDecisionMaker ORDER BY DecisionMakerName" _
, myCon)
do while not rs.EOF
Response.Write("<OPTION value=" & rs("DecisionMakerID"))
if rs("DecisionMakerID") = nDecisionMaker then
Response.Write(" selected")
end if
Response.Write(">" & _
rs("DecisionMakerName") & "</OPTION>" & Chr(10))
rs.MoveNext
loop
rs.Close
It comes from a table and has PropertyDetailsID(1,2,3,4) and PropertyDetailsname(Fee, 5,10,Other) and for example "Fee" needs to be the dafault value.
If a new user is added to the database through a webform, and they would usually have immediate access to member only services, is there a way to make them nonactive in a MS access db until an admin activates them?
View Replies View RelatedI am wanting to compress/zip a file up on the server and email it. Is there a default component that should be installed on the server that will compress/zip files? If not is there FREE ones that anyone would suggest?
View Replies View Relatedwith "select @@IDENTITY" i get the value of the last field insered.. i would
like to get also the field.name
Is it possible to add a default include file to every ASP-page servered on IIS? So I do not have to modify every page.
View Replies View Related