Updating SQL Data In Web Broswer Address Bar?
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?
View Replies
ADVERTISEMENT
I have a page that allow user to update their contents of their address book.
When users click on a button on the page, a new window will pop-out with all the address book contacts. User will select one of the option and i will retrieve the values on put them into the main page without re-loading the page.
To achieve the above effect, is it better to combine
a) ASP with Java Script or
b) ASP with VBScript
View Replies
View Related
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 Replies
View Related
How 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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
What I am trying to do is create a page on my company's internet site so that our customers can fill out a form, click a submit button and then have the data they entered be emailed to me. I have already created the form within Dreamweaver MX. How do I setup the Submit button to automatically email the information to me?
View Replies
View Related
I'm really new to this and want to submit the data entered in a form to my email address. My problem is that I get the email but none of the data is being "grabbed" so although I get the headers I don't actually receive any of the information I really need.
What am I dong wrong? - this is my code:.....
View Replies
View Related
I have a resume form with four separate pages,and on the last page when you submit the form I need it to gather all the information inputed to be sent to an email address.
View Replies
View Related
Permission denied. Address 'zzz.zzz.z.zzz' is not an allowable remote socket address.
What is the significance of this error, and what should be looked into to fix the problem?
(if this is of relevance: My sandbox is localhost.. so zzz.zzz.z.zzz is internal ip)
View Replies
View Related
has anyone got a function or subroutine which will remove blank out or remove email addresses.
i've wrote a function which will remove valid email addresses, it's pseudo addresses such as "blah @ blah.com" or "blah_at_blah_dot_com" or "blah_at_blah_._com"
the function is basically to stop users posting an email address in a message.
View Replies
View Related
Well, my script consists in check if the typed code doesn't exist in the DATABASE, but thats not the problem... the problem is that the PAGE1.ASP (that check the code) redirects to the ADD.ASP that will add those codes to the database!
Response.Redirect("add.asp?cod_1=" + cod_1 + "&cod_2=" + cod_2 + "&cod_3=" + cod_3 + "&cod_4=" + cod_4 + "&cod_5=" + cod_5 + "&sexo1=" + sexo1 + "&sexo2=" + sexo2 + "&sexo3=" + sexo3 + "&sexo4=" + sexo4 + "&sexo5=" + sexo5)
That's the line in page1.asp that redirects to the add.asp. So, when the database is completed empty and, the page1.asp checks that there ins't any problem with it and redirect to the add.asp that doesn't update my database!! So, it continues without any record. But, if the database has, at least, one record, the script works normally without any problem!
Another thing that I noticed is that when I, manually, type the adress Http://127.0.0.1/add.asp?cod_1=176096, for example, and the the database is empty, the script does the UPDATE and adds the code to the table!
I have no idea that the problem is. Does any one have a clue?
The goes the add.asp script: ....
View Replies
View Related
I'm not sure if this is an ASP thing, a IIS thing, or a GoDaddy (where my domain is registerd and forwarded from) thing...
First I'll start by saying I run my own Windows XP web server and do all the coding myself..
I've noticed in the past (and never really gave it much thought, because the site works fine), that when I switch pages within my site, that the URL line is not always updated.
For example, I go into the pictures section, view a few pictures, then select the "Home" tab... The URL will stay with the variables that were passed when I was viewing the pictures. Therefore, if I do a "refresh", the page goes back to the pictures I was previously looking at, not the home page.
I've tried this on multiple computers at multiple sites, and with multiple browsers... And seems to happen rather consistantly...
Anyone have any thoughts?
View Replies
View Related
I am looking at updating a notes part of my data base. I am calling two fields (first name and last) from the data base and putting them into read only text box (as i dont want the details changing). All of this is contained within a form. I am also calling a feild from the database called notes which originally has been inserted using a <textarea> tag. The problem i face is that you cant put values into a <textarea> (ie. i can put data from the database into the value tag of a textbox but <textarea> doesn't have a value tag). Due to this i am putting existing notes onto the page as text. Under this i have do have a <textarea> to put the new notes in.
The problem i have is that i some how need to store the existing data in the notes field and then add it to the new notes that i will be adding. I just don't know how to put the data i am getting from the notes field in the database into a variable.
View Replies
View Related
Having problems writing an update script because in one of my fields I'm adding a chunk of HTML that contains ' characters. Obviously this throws up an error. How do I get around this?
View Replies
View Related
I'm trying to create and assign variables with the values from my db but can't work out the code getting my " & ' mixed up.
i = 1
do until i = 6 or rsSet.EOF
rBlock(i) = rsSet("rBlock'" & (i) & "'")
i= i + 1
rsSet.MoveNext
loop
View Replies
View Related
whats better ADO or SQL
for example, an INSERT statement or an objrecordset.update blah blah?
same with .net
should I C# to update or SQL
View Replies
View Related
I have an XML file which i'm trying to append elements to using an html form and ASP with javascript scripting inside the ASP file. Code:
View Replies
View Related
I have a function below that works fine. It takes a XML dox parses it, etc.
What I need to do is after the update of a record, I need to query the same table again for another record. If it finds this second record, I need to update it.
The problem is I can't get it to work, mostly because I don't completely understand the .open() method. Can I requery and the test for the existance of a returned record - if so how? Code:
View Replies
View Related
I placed a post a couple of weeks ago discussing how I was having trouble using ASP and the XMLDOM to differentiate between the text content of Parent and Child Nodes in an XML file.
ie:
IF PARENT.text > "" Then
'Do Something with PARENT.text
ElseIf CHILD.text > "" Then
'Do something with the CHILD.text
End If
The problem being that I couldn't differentiate between the text values of PARENT and CHILD.
I've managed to work around that problem in a fashion but I'm begining to think that I'm going about this with the entirely wrong approach.
All I want to do is edit the following XML file through ASP: * Note that there are attributes with values and some nodes and child nodes have text values as well Code:
View Replies
View Related
I am trying to configure Visual Interdev 6 (running windows xp professional) for debugging. However, while I run a utility viddbg.exe, the debugstatus file shows the following error message.
ASP.DLL Version Information
--------------------------------------------------------
Location: C:WINDOWSSystem32inetsrvasp.dll
FileVersion query failed
File Size: 339456 bytes
VID Debugging requires 4.02.0622 (330448 bytes) or greater. What is the best way to handle this problem.
View Replies
View Related
I was give a site that was created on vb/asp and the owner want the site to b. be a asp.net web site, how difficult is for the site to be updated with the new .net technology?
View Replies
View Related
I get this error message:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Expected query name after EXECUTE.
I tried hard but nothing, I have a same example working, but when I changed just the field names...it didn't work!! Code:
View Replies
View Related
It it possible to get the MAC Address of the client PC using ASP. Also can I
get the HDD ID/Serial Number also using asp?
View Replies
View Related
i want to get the ipaddress,and the country name of a webpage
visitor,using asp.Net(C#).if anyone knows about it
View Replies
View Related
Is it possible to ban an IP address from global.asa, or by another method?
On a shared server, I'm seeing someone from China that appears to be trying to access my
site illegally (trying to access server root via cgi-bin).
Can I test for the user from global.asa and then execute a Response.End? Or is there
another way?
View Replies
View Related
What is the best way to pull a pc's Mac Address from a web page?
View Replies
View Related
Currently, I want to get the IP address from giving hostname in the Active Server Page. I know the hostname, I want to get the IP address via hostname in an ASP page.
View Replies
View Related
It it possible to get the MAC Address of the client PC using ASP. Also can I get the HDD ID/Serial Number also using asp?
View Replies
View Related
How can I get the IP Address of the system that the client uses through ASP. I used Request.ServerVariables("REMOTE_ADDR")to get the IP Address, but that always prints 129.0.0.0 as IP address but that's not the IP Address of the system. Tell me if there is if there is any other alternative.
View Replies
View Related
How can I retireve the IP Address in ASP as a string ?
View Replies
View Related
How do i pick the MAC address of a network card using ASP. Is it possible to identify a system e.g the mother board ID or processor using ASP or any other object.
View Replies
View Related
How do you find a Mac (Hardware) address using vb scipt in asp?
View Replies
View Related
