Is it at all possible to display only one of possible duplicate records from a database in a recordset. The field that needs to be recognised as a possible duplicate is a column for names but then needs to show the one with the highest score only.Fields are name and total (numerical). Currently I have only a basic recorset which is all that was needed until now:
SELECT * FROM leaderboard ORDER BY total DESC
I have a form to enter details about companies into a access DB, it all works fine the way it is set up except this one small problem.
The same company details can be entered again by mistake and take a new record set. Now what I need to know is how to stop this from happening, do I use ASP code to check the DB (if so could someone tell me how it is done) or do I set this up in the Access DB itself.
What I want to happen is if the same company details are entered then the user gets a warning telling them that that company has already been entered.
As part of a data input script, I ask for a user name to be input into an Access DB field called surprisingly, "UserName". I would like to ensure that username is not duplicated. How do I do that before inserting the data. My example show in the incomplete script below doesn't work? Code:
View Replies View RelatedWhat i have is a form that puts data into a DB. But what i need is for the page to display the reference a field in the row the data has just been entered.Does anyone know how to do this?
View Replies View RelatedI have a booking page that the user enters 2 addresses date and time etc
what I need is the option for the user to select multiple date entries for
the same journey or maybe multiple days ie they want to travel the same
journey every Monday or every weekday etc.
i m making a page on login basis, i hve an access datbse, after login user will enter a code which is already store in datbase, then form checks if this code is in databse if found then it will show some other records in databse, otherwse disply msg, user enter data in fields, after completing data cursor must go to code agian for another record, this data entry is in bulk, mean 200 recrds or more in one session, so may be i use batch procdure, then form save the records, same time a link on pge to edit this record, or if no code availble , operator can add new records
View Replies View RelatedI'm building a data entry and search tool. I've created a basic search facility and it seems to work ok but I don't know the code to create 'data entry' buttons. I want something that looks the same as the search facility but the submit button creates an entry in the databaseCan anyone give my the relevant commandscode?
View Replies View RelatedI have an ASP page that allows the user to input specific fields which in turn update a database. I have managed to get this working although I have one more question.
Can I format the fields so they are not all in a line. Maybe two per line. THis was the user can see all the fields at once without scrolling right and left. Code:
This is about a simple form validation in asp using javascript.there is one field called invoice_number which requires an unique invoice number as input. Whenever user inputs duplicate values message should pop up as warning on submit of the form. A sql fetches all the invoice nos. from database into an array using getrows.how do i use the result of getrows in javascript to perform client side validation
View Replies View Relatedhow to control numeric entry into a textbox? so that no other character is allowed only numbers and decimal?
View Replies View Relatedwhats the best way for me to validate the data that has been put into a form on my page?
View Replies View RelatedI have a DB with 3 fields.
ID
Name
EMail
If I write an entry into this DB, Name and EMail, the ID is auto increment. How can I detect what ID has been created ? I want a user to submit details to me, they get the ID as a ticket number ?
i have a question and comment page for students to comment on tests. each question is set with an auto-ID number.
I have the comments saved to access database but it only holds one comment, or record to the question with the ID number. Everytime someone makes a new comment, the other comment is lost and it only shows one comment. I use the <%=objRS("comment")%> and it will show that one comment, but I need away to show all comments to each individual question. Is there someway I can alter the database (comment table) or that <%=("comment")%> command to show all coments by the question id number?
used to other languages and using ASP for a particular project. Is there a way in which I can remove the first element from an array and then return the array with remaining elements intact?
View Replies View RelatedDoes anyone know how I can use asp to access a specific entry in a microsoft access database table without having to run a search of the entire database? I figure this can be done with the primary key, but I'm not sure how to do it. I've looked for tutorials, but none seem to deal with this.
View Replies View RelatedI am having considerable difficulty figuring out how to delete more than one entry in my online database at a time. I thought I had it
Sub Delete()
SET Conn = SERVER.CREATEOBJECT("ADODB.Connection")
Conn.OPEN "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("/db/database.mdb")
sqlWhere = ""
aSelected = request.form("Select")
sqlWhere = "ProspectId IN ('" & aSelected & "')"
sql = "Delete * from tblProspect where " & sqlWhere
Conn.Execute sql
Conn.Close
Set Conn = Nothing
RESPONSE.REDIRECT("prospects.asp")
End Sub
I need to write an ASP page that will allow a user to paste in data from an Excel spreadsheet. The data will only be in one column. I'm not a web programmer and would like some advice on the best way to do this.
I have a page working using a text area and some JavaScript to parse the data entries using the split function. This seems to work ok but I wondered if anyone could suggest a better way?
I have successfully created a master detail page for this database, now I want to create an form to update the database.
When I created the form and tried to view it, I got this error
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/dlrc_resources/book_list/book_entry.asp, line 113
Line 113 is : Code:
Linkpoint central does this with their payment gateway as a securty measure... you cannot post a sale request unless it comes from a specific address, that you specify in their management console. (which im pretty sure its checks the referer page.)
View Replies View RelatedHow do I change a blank database entry, so when I retrieve it blank I output a string say <i>N/A</i> into a table? Currently I have an if/elseif/else like this.Code:
if tf.name = "ID" then
Response.write(bla bla)
else if tf.value = null then
Response.write(bla bla)
else
Response.write(bla bla)
end if
*Note, where the word null is, I have also used the string "" and it still does not work.
We are creating a multi-region ASP application which will be using SQL Server 2000. As our users exist in multiple location i.e. UK, US, Australia how can we distinguish that the date the user is entering is captured correctly i.e. no confusion with DD/MM/YYYY format.
I guess to remove database ambiguity I am going to use the format YYYYMMDD format but how do I know in the first place when the user entered 01/06/2006 that the user meant 1st June 2006 or 6th Jan 2006.
I have a database with multiple records which are often updated. I am trying to display the latest entry in a certain way (with css div styles) and then list the rest of the entries another, less elaborate way.
Is there a good / preferred way to do this? Right now I have it so that it SELECTS TOP 1, displays that in a certain DIV, and then SELECTS * - however what is wrong with this is that it displays the first record twice.
I have a string of ASP code that writes a new database entry into my SQL server table. Is there a function that I can run directly after the database entry code, that can tell me if the data was successfully entered? Eg of current code:
SQLCode = "INSERT INTO GarProductList VALUES (" & "'" & App_Name & "'" & ", " & "'" & Option_Number & "'" & ")"
response.write "SQL Code is: " & SQLCode & "<br>"
Set objRS = MyConn.Execute (SQLCode)
<< perhaps call certain function here to verify SQL table was updated? >>
If database update successful -> function should return 1 If database update fails -> function should return 0 ... or something like that. In any case, some exception response should be returned.
I have a form in which a textbox is filled using a pop-up page. This pop-up page has a selection of values created dynamically from an access table. I need to know how to get the values selected from the pop-up back to the main form. Can anyone guide me in the right direction.
View Replies View RelatedIve got an asp website which has a news function. Its pulling through info and a pic ref to a url on the server that in turn puts it onto a page.
My problem is that i only want to show this picture if there is a record in that news item (some news items willnot require a pic) - at the moment its coming up as a broken picture link. Is there a way of showing it only if that record in the table is filled in? Code:
when i want to insert my data into my table but i encounter the following error
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Violation of PRIMARY KEY constraint 'PK_sDetail'. Cannot insert duplicate key in object 'sDetail'.
/fsearch/InsertTable.asp, line 153
sql = "Insert into sDetail values('" & semyear & "','" & sem & "','" _
& modulecode & "','" & tutorial & "','" _
& semday & "','" & startTime & "','" _
& endTime & "','" & location & "','" _
& roomno & "','" & tutor & "')"
oConn.execute sql 'line 153
how to solve this error can anyone help ?
HOw can I prevent my users from entering more the a certain number of characters into a field? Could I get a similar example as I have a limitted knowdlege.
View Replies View Relatedhave form on asp page with an email address field, when the user enters
their email address I want it to populate another field automatically on the
same page, some kind of OnBlur event. Have worked extensively with dropdown
OnChange events but cant get my head around this one.
I have a table layed out in SQL 2000 like the following:
Username Date Hours Period
john 1/1 10 1
john 1/2 20 1
How simple is it for me to build a data entry form in ASP that would display this with input boxs for the hours field. The problem is I need it to span left to right on th eweb page.
Period 1
1/1 1/2 etc------------>
box box
SUBMIT BUTTON.
The key to the look would be the current period.
I have asp project where large volume of data entry would be done. I am
trying to find out if there is any tool that can allow me to build asp
application where the forms would be like excel spreadsheet.
For example, now my 1st page is a search page, i use it to search for all records that has the same Business_unit, so it goes to a second page where a table of the records is shown.
Now this page has a link to a 3rd page, where i wan an exact duplicate of the second page, is it feasible, is there anyway to display the exact saem table on the 3rd page?
I have a signup form.
I would like to be able to check for duplicate entries during the signup.
E.g. Check for duplicate
1. Usernames
2. Phone numbers
How could this be achieved ?
My code basically is two fold.
1. A recordset that checks
if not recordset.bof and not recordset.eof then
'do something. And redirect to say the value exists
end if
2. Run a SP to do an insert and authentication
My table in the database may contain duplicate records, which means except
the primary key (auto_increment) field is unique, all or almost of all the
fields are with the same content. How can I select them to display and
delete them?