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 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 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.
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 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.
i often to make a user interface in access for data entry using Grid view. is there a possibility to make Data Entry user interface using Grid in ASP?
View Replies View RelatedI have a large classic ASP web application which needs to now support chinese
character entry (I don't have to worry about the UI yet - the data entry
people can read english). Other than changing the database fields over to
"N" data types, do I need to do anything to the actual entry fields (input,
textbox) on the various forms to be able to capture the information. Some
users will be entering the information in english, while others will be
translating the same info into chinese as they enter it.
I know this is probably much easier in .net, but we have yet made that
transition. Now that 2.0 is available, it should be much more viable.
Would like to know What is SSL and how do i implement it on my web page. The OS is Windows.
Help needed ASAP.
I am looking to implement i18n with our current software which is based on the web that has an international client base. So for this we need to support other language (mainly chinese, japanese, indonesia)
My company have told me that the i18n would do this for us and to research into it (http://www.debian.org/doc/manuals/intro-i18n/ch-intro.en.html#s-intro-concepts). I myself think that this will not do the translations for us and think that we need to re-write it for the site with the help of translators.
I have researched into this over the past few days and found articles on the web and case studies but it still hasnt cleared up what I am trying to achieve. So I was wondering if anybody has any previous experience in using this in ASP or even VB.
I want to start studying CRM implementation, I already studied E-business management, what should I learn to be able to understand CRM implementation?
View Replies View RelatedI have been happily reading through the sticky best practices and changing my bad habits ( no more SELECT * from me now!) to better ones.
I found the bit about functions and then the article on The Real Basics of Functions In ASP and following that I got the drop down box function to work.
I have lots of forms with lots of dropdown boxes - some are dependant (and working beautifully because of the help here) and some are not dependant on anything, so I thought is would be best to use the drop down box function.
At the moment I have a few other functions that I have gotten from elsewhere, and they are in include files like pcaseFunction.asp etc. I only include these files on the pages where I use the functions.
Is this good practice, or should I put them all into one file? Calling the function multiple times on one page, will this be a problem?
I have an intranet site that controls equipments flow for three companies.
Recently one of the key users of one company asked me if the manual input they use to track the equipments and use the functions of the system could be replaced for a bar code scan...
So the basic idea is to add an icon beside the manual input that locate the equipment, as an option to use bar code scan pistol instead of typing.
There is some example of this kind of implementation, if its even possible?
Could you show me the way, like choosing the right bar code standard, how to control scan`s API from asp, etc?
What 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 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 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.
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 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: