I have a simple Form full of Textboxes.The Textboxes get filled from the Database, and the user can edit and click Update to update the info in the Database.My problem is that I don't know how to stop 2 users from messing each other up.(Just to clarify, User 1 gets info, User 2 gets info, User 1 clicks update and then User 2 clicks Update, obviously, all of the User 1's changes got disregarded).
View RepliesHow do i update multiple records?I used to put the values in an array after splitting them.But what i noticed was , if there are values that are seperated with commas in the field value itself then it is taking the field value to be 2 in number.for eg:
if my field1 has value of abcd,defg and my field2 has value 123.When i update my field1 is updated with abcd and filed2 is updated with defg and so on? How can i overcome this?i want the values to be updated correctly into their respective field.
I'm looking for an example ASP (VBscript) which will allow me to modify my data in my SQL server only by using the address bar in a web browser, for example if I typed in the address bar:
update.asp?table=hostnames&criteriafield=hostname&criteriavalue=blah&updatefie ld1=ip&updatevalue1=192.168.1.1
It would update the data for the ipaddress, but if the record it was looking for wasn't there it would then create it.
So the workflow would be something like this:
find record --- NO insert new record
|
| YES
update record
Has anyone seen something like this that is in a script, tutorial, or knows how to do it off the top of their head?
I am doing a project for my HND for a football league and i am at the point where so far everything is goin good but i need to update the League table. For those that dont know how a league table works here it is:
For a Win you get 3 points
A loss u get 0
a Draw u get 1
Any goals u score go into you 'Goals for'
And any scored against you go in your 'Goals against".
Basically i already have some ASP files where the administrator of the system types in the results for games played now i need to update this league table depending on the results. I want to execute something like this:
If HomeScore is greater than AwayScore Then Add 1 to the played field, add 1 to the Wins field, add 3 to the Points field and for the goals for and against i thought it may look something like this:
For = for + "HomeScore'
Against = Against + "AwayScore"
I have absolutely no idea how to do this, i dont know whether to use an Insert statement or an update Statement.
What i am trying to do is Update data in a table with data in another table but i want to update 2 fields in the destination table with data from 1 field in another table.
These are the table i have and their fields:
*CUPFirstRound* - Table1
GameId
GameDate
Home
Away
HomeScore
AwayScore
Winner
There are 8 rows in this table, thereofre the GameID's go from 1 to 8 Code:
How can i detect if a database already has a primary key value that i want to insert. ie. i want to insert 5 into a database that already has a primary key set to 5.
View Replies View RelatedWe have many forms on our site that users can fill out and ask questions, request information etc. but somehow, we receive a lot of junk mails (more than two hundreds) within two weeks through these forms. I don't know hot to stop these junk emails.
View Replies View RelatedI want to make a simple simple asp page. All I want is when the page loads
it does "net stop <service>". The code is below, it is not running as
IUSR_<machine>, I am authenticating as Administrator yet the service does
not stop.
The blank page just loads with no errors and the service remains
running, what am I missing? I am completely new to ASP, I just want one
simple page for this purpose. Code:
I dont want to start the sessions when my asp page is run....how do I do that...can I add something at the start of the page which will not enable the session
View Replies View RelatedI´m programming in ASP. How can I stopp the loop?
View Replies View Relatedhow can i stop execution. in betweeen a few lines of code. i dont want the complete execution of code and in middle i want to stop?
View Replies View Relatedcan a website be secure and not have the https in the begining of the url?
is this true : URL always secure
is this true : URL never secure .
How do you stop Dreamweaver from displaying server side includes in the Design View Window? I use a include to provide my asp pages with a general layout. My machine used to ignore the include statements when I'm in Dreamweaver deign view, but today it just decided to show them. It makes it hard to work on my programs.
View Replies View RelatedI am using two asp pages that have large (up to 1280X1024) background images. The image is the same on both pages, but when I go from one page to another it reloads the image each time and flickers for a second when loading because the file is so large. Is there a nifty way to keep the background image the same across two pages without reloading.
View Replies View RelatedHow do you do the following?
if(true)
response.write "There was a problem."
***STOP HERE***
more code
more code
more code
I have a windows small business server 2003 running IIS 6 to serve asp pages and streaming movie over internet.
Everything was working fine but suddenly the server stop respond to ANY asp request but no problem with html for several hours last night. It serve asp again for awhile
but it stop serving again this morning.
i have a string and i would like to run through this string to find a "."(fullstop), and once found put a break in so that i could continue the rest of the string on the next line.
How can I stop some one from trying to post my form from a remote site.
I am getting some one cycling through usernames trying fpr passwords on a
web site.
Does anybody have ideas how to prevent passwords guessing. I mean I want to define that same person/robot try to guess password and to block it after 3 wrong attempts.
View Replies View RelatedI have just got back into ASP development after a years break and am playing catchup. I am developing a simple page with combo boxes on it, so that when it is processed it searches a database for all records between the chosen entries in the combo boxes.
However I am also trying to stop the page from returning errors when a user clicks submit without choosing any entries from the combo boxes. I am trying to get the page to just re-display itself with a simple error message on the page informing the user that they have to choose an option from both combo boxes.
Is there a way in asp i can avoid a person pressing f5 or doing a refresh?
View Replies View RelatedI have an asp page which when loads, sends notification emails and adds data to a Mysql database.
What i want to stop happening is people refreshing the page or when navigating back to the page using the browser, this script is run again.
I have a page that pulls info from a SQL DB and displays it for the user. Everything is fine now 'cos I only have ten entries in my DB. When finished, there will thousands of records and what I see is an endless scroll or page down for the user. But what I want is to display a MAX of 15 records per page and have the others displayed on following pages.
So how do I get my pages to continue on page 2, 3, X XXX and have it so that clicking on any of the pages jumps to the corresponding page. You can actually see what I am looking for here at sitepoint. In their own case, they have it displayed within page ranges.
I am trying to stop and start the ftp service from an asp page using the niuser account.
my code is simple: shell.run "net start msftpsvc",0,true. ASP page returns no errors but nothing happens. code works in .vbs but not from the webserver (IIS6).Can someone tell me how to do this? I would also like to edit the registry if i can.
I have Windows 2000 Server on an Intel machine. Periodically IIS returns an HTTP 500 error when anybody clicks on an asp script. Regular HTML pages are displayed without a problem. The problem gets corrected whenever I reboot the server.
View Replies View RelatedI can't get the following code to display only two decimal places.
-------------------
ProductPrice.Text = String.Format("{0:c}", ProductDetail.Price)
--------------------
Can someone tell me how i can only show two decimal places and also how i can just show rounded to an integer.
I am creating a news page for a fun website just to learn, it has a simple html form that lets me post new news items to a MSSQL database.
The thing I am trying to do now is have the loop only run about 5 times, so that it displays only the last 5 news items from the database, I will then create an archive page which will display them all.
I have a book that I read and I found the for..next statement and I t would work nicely from what I am reading,
I have an Active Server Page connected to an MS Access database. I use this page to submit information to the database. Among the form fields is a start time and stop time field.
By setting the value of start time to <%=Time()%>, I'm able to collect the start time automatically when the new form is opened. I would also like to collect the stop time by clicking the submit button. Code:
Is there a way to stop an SQL statement once it has been sent to Oracle?
Now I always thought the answer was no, but I have started using the free
(and very good) SQLTools - in which you can start an SQL statement, but you
can also cancel it and SQLTools then stops the execution of the sql on the
oracle box (it does not leave a duff ora process or anything).
I thought this might be useful if we have long running queries on web pages
(due to DB problems for example) and we could have a timeout which will do a
controlled shutdown of the query and the db connection, rather than
server.timeout which leaves an active ora connection - leave too many of
these and you could run out of handles r run up huge CPU-gobbing processes
etc...
I require a program that will allow a user to start the timer when he hits a button and stop the timer when he hits another button. Is there anyway where i can get the difference in Time:
Start time=12:15:54
Stop Time=12:20:12
Difference in time is:00:04:18
is it possible to somehow "jump out of" an ASP page that is executed from
another page via the Server.Execute method?
on the page being executed i have several instances where i need to stop the
execution and immediately shoot back to the calling page without running
through the rest of the code on the executed page. Code:
i have write a simple asp application, which is used to send batch email. the process will running for few hour, it depend on how much email needed to send. however i have a problem in ...........i can't find a way to stop this sending process until it send out
all of the email (or let say unless i reset the iis by in cmd typing iisreset).
i also have try different method such as before it need to send each mail it need to check the session, at that time (during send) user can press a button on the pop up page that change the session value. however this method is not work, it need to wait until the sending process finish.
I'm trying to set up a Windows 2003 server using ASP, and I am find ASP
pages just STOP as if I had called Response.End whenever an undeclared
variable is found. If I turn off Option Explicit, it doesn't happen.
Clearly I can Dim the variable to solve the problem (I mention this in case
some smartaleck decided to propose it as the solution), but it is making
finding undeclared variables very hard! Anyone have any idea what I've
done wrong in my configuration?