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:
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
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).
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.
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:
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?
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.
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.
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.
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!
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?
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...
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.
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?
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:
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:
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.
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?
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.
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.
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.