Updating Numerical Entries
I have made a forum script and I know this is very basic stuff but how do you go about updating a number with an increment of +1.
Access Database - Two Tables - Topic and Replies.
In Topic there is a column called replies. When a user views a topic there is a reply form at the bottom which is processed by reply.asp which add the information entered to the database in the replies field. Also added is subjectid to each reply so I can link the two together.
Either I want to be able to update the reply number in the topic table by +1 in the appropriate subject row (the id is passed on to the reply page) or count the number of alike subjectid's in replies to the subject in topics. What is the best way and how do I update numbers by +1.
View Replies
ADVERTISEMENT
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
Using SQL it's easy to search for part of a string by doing the folowing:
"WHERE strText LIKE '%" & varTest & "%'"
However, is there a way of doing the same thing for a number?
My database has an autogenerated 'fault reference' number, and it has to be searchable.
View Replies
View Related
I am using a Relational database for my site and i have the following tables:
FIXTURES, GAMEDATES
the fields in FIXTURES are:
GameDate
Home
Away
(All of the above are numerical fields)
the fields in GAMEDATES are:
DateID(integer)
GameDate(#Date Field#)
What i have done is in the GAMEDATE field in the FIXTURES table i have used the ID number of the date that i wish to assign to that record - using a LEFT JOIN to display the actual date that is pulled from the GAMEDATES table (That which corresponds to the relevant id used in Fixtures)
The problem is that in some of my code i want to display records using sql and sometimes in the where clause i use the following:
WHERE Fixtures.GameDate<=(Date())
obviously meaning WHERE GAMEDATE is LESS THAN or EQUAL to TODAY.
The thing is when i use the join it does not use the where clause and displays all of the records in the FIXTURES table.
Does any one know how to get around this, i have not received any error messages it just isnt displaying the right data
View Replies
View Related
i'm trying to limit the ammount of entries a user can put in the access database, here is my code:
View Replies
View Related
I have a problem with Insert statement. Though My SQL Statement executed once only, there are 2 records entered in DB. I am using ASP and SQL Server. Does anybody know the solution?
View Replies
View Related
I want to validate client entries into textbox,checkbox
controls etc. can u do this with asp. Like, is there
onchange and onclick and so on for these controls?
View Replies
View Related
A different question though. Is it possible to delete duplicate entries,
where the email address is the same, and only keep one?
i.e..
I got say 4 DB entries, all with the same email address, and I want to
delete 3. How do I do this?
View Replies
View Related
Does anyone know what sort of command I need to use so that if someone posts an entry to my database with a primary key that's already been used, the old entry is overwritten by the new one
View Replies
View Related
Is there a way of checking whether two entries in a form are the same? Like when you have to enter your password in twice. I'm not actually sure whether it's asp. Sorry if I've posted in the wrong place.
View Replies
View Related
I have a database for projects. Some managers are responsible for multiple projects. I want to dynamically populate a list of project managers, choose a manager, and display a complete list of his/her projects. I have a few problems 1) I cannot figure out how to list a project manager's name only once in and 2) I don't have a clue how to compile all the projects for each manager so that when his/her name is chosen it will display all the records.
View Replies
View Related
I have setup a simple site in which users input data to an access database, and then the database results are shown on another page in a table. One of the fields in the databse is Date Added, using the date/time data type.
I would like the table to show new results with a different background colour for a period of time, say one week? Code:
View Replies
View Related
There are a lot of references on the net on how to delete multiple entries in a database by using a checkbox. What I would like to do is add a checkbox to the output of a query (ie. bunch of names).
Then be able to select some of the names by clicking on a checkbox and when submitted, add those checked names to another database (insert). Similar to a shopping cart selecting multiple products but when submitted, it does not add them to the checkout, it adds them to a database as new inserts.
View Replies
View Related
i have a registration form in my website. the requests are going to the database (windows 2003 small business server). I have an other page who the entries are displayied. how i can delete the each entry separately with a button?
View Replies
View Related
I tried the following code to save in a variable, the quantity of entries in my recordset:
if rsEntries.Supports(adApproxPosition) = true then
strCount = rsEntries.RecordCount
end if
It didn't work for me. It's returning a value of -1 and I have close to 100 entries in my recordset. Is there an alternative to this? What code can I use to accomplish that?
View Replies
View Related
I have an ASP app (developed with Interdev 6) which uses
a DTC listbox (server-side) bound to a recordset to allow
the user to make a selection. This works fine until the
number of records in the record set seems to hit a limit
(not determined the exact limit, but seems to be c. 400).
If there are too many records, the app just hangs until
it hits the scripttimeout limit.
I've tried increasing
both the command timout (I'm using an ADO command object
to generate the recordset) and the scripttimeout to no
avail. Does anyone know whether there IS a defined limit
on the number of entries in a listbox? Also, any better
ideas on how to allow the user to select from a large
number of records (> 1000)?
View Replies
View Related
User clicks on a button [BUY NOW], item is added to cart. User can either
continue shopping or view cart. The order here doesn't matter. When user
views cart, two items are added, the one selected and the last one in the
product file. The product file is a CSV file.
The last entry is called BAD-Product. It is a debug entry during site
development so the developer knows the product name is entered wrong, i.e.
misspelled. If the name was omitted an error would occur so there is a
name.
This only happens with Firefox and Netscape. IE experiences no problems.
The last entry is not added.
Accidental temporary solution:
In review of the code, a debug line was put in to make validate the product
item being returned. After saving the page (.asp add item page), the error
disappeared. The debug line was then commented out and the error still has
no resurfaced. Code:
View Replies
View Related
I need to loop the recordset and count the occurrences of each entry. The entries will always be numbers.
If entry = 1 then count(1)=count(1)+1
If entry = 2 then count(2)=count(2)+1
...
If entry = 100 then count(100)=count(100)+1
The problem is that there could be 1-100 (or more) different answers stored in the field so coding 100 IFs will work (as long as noone needs to enter 101) but seems silly. How do I create the array above to look something like:
While...
<%
strField = (Recordset1.Fields.Item("Field").Value)
CntNumInField(strField)=CntNumInField(strField)+1
%>
WEND
The above code returns a "type mismatch"
View Replies
View Related
I have a ASP page that returns and manipulates information from an access table. The information it returns is the figures for each month for certain products.
Basically the page adds up the results returned from each month and then gives a total for the year so far for each product. So we can view the figues for every year back to 2000 to see how the product did. The problem is that when we choose 2006 it returns no values, and I can't see why. The only difference is that for the months that havnt been completed yet - May onwards, there are no entries, not even a '0'. Would this be a problem when adding using the asp page, adding a number to a returned object that contains nothing?
View Replies
View Related
I have a dbase containing login details for 21,000 members. I also have a
forum that I am about to implement.
When the user gets to the main site, he has to login (this is done by
checking his credentials against DB1) When he is logged in, all his details
are stored in session variables. Clicking on the forum link will take him to
the forum where he has to log-in or register. Currently, the forum checks
cookies to see if there is a valid name and password and then checks these
against it's own DB (herein called DB2) or requires the user to
login/register
I plan to modify the forum so that the login is bypassed and the forum
accepts the current session name and password as the login. (This is so that
all names on the site main site, chat, forum etc are uniform, i.e Dave47 in
a chat room, is Dave47 in the forum, is Dave47 in the members area etc)
so...what I need to do (if you're still with me) is.
When a new user registers on the main site, his details are put into DB1
*and* DB2. , can I have two data sources open at once?
The reason I need two DBs is that the information in DB1 is a lot less than
is needed by the forum in DB2.
Also how can I copy selected fields from DB1 (name, password for existing
users) into DB2? like I said..there's 21,000 and to do it manually would
take forever.
View Replies
View Related
Does anybody have a nice method of forcing a user to enter a value into a
form using asp?
I think the best is to have a popup when they hit submit that will stay on
the same page and then just alert the user to enter something in so and so
text box.
View Replies
View Related
I have a database that is for E-Cards. I want it to delete all of the entries that are more than a month old. I have the date stored in a field called "dags" (without the quotes). Please help me on this!
*******************************************
Also, I would also like to have an option for "Send the E-Card Later" and then have the options possible dates. What script(s) could I use to do the actual sending on a later date?
********************************************
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