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 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
I'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?
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 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.
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.
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 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.
I've written many pages that emails the content of a web form, but the data formatted very nicely. Is there a way to have the content of the submitted form data via email in XML?
Is this possible to check if a text box on form.htm is in mm/dd/yyyy format before submitting to asp page?
if you enter say 2/2/04 it gives a incorrect date format error. The asp page uses this text box in the select statement for a db2 table query that is a date field.
I will be eternally greatful if someone can provide snippet of code, URL or reference material that shows how to display data in a "n colums * n rows" format.
I am new to ASP and have looked everywhere that I could, but I have not found an example where data can be formatted to be displayed in a 3 * 4 foramt, like many of the professional sites would do (actually rows and columns can be any number of rows and columns) All the examples that I have seen, show data displayed in a top down format.
I need to allow user to save dataset to their computer in Microsoft Money format. I searched internet for help on this but found nothing helpful. I also chatted with MS Online Concierge to no avail.
If you could, please provide pointers to steps how to accomplish this. If you will provide the steps yourself, please be very explicit in what you provide.
I have the tables set up in Access, viewing in column format on ASP pages but now the company wants the schedule reports to be in a wall-calendar type format. I've searched and found calendar scripts but I need one that's creates a table resizable to a report size format. Using the existing MS Access db I've written is also a plus.
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?
I 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
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?