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 the following problem. As some of you already know (because they already helped me a lot), I am showing data in a table. The first code is correct. It shows my numbers with two digits behind the comma and negative numbers in brackets and in red. Code:
The link for the photos are requested from the server and so the photo appears on screen. I can produce a long list by using the response.write *** & "<br>" or whatever. but is it possible to have it start on the next line after say 5 photos in a line. i.e. where each - is a photo
- - - - - - - - - - - - - - -
rather then - - - - - - - - - - - - - - or - - - - 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
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.
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 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 currently have 2 asp forms on one page, posting to different pages,one an email form, the other an upload. Is it possible that someone could help me with merging them together?The scripts and pages are below on my 3rd post below.
I have just taken over an ASP application that has a form whereby the user on entering details submits it, where an administrator approves the form. lately I have been getting calls from people who on opening a Finalsed Form (non-editable) to copy similiar data to the new form, are finding the new form disapearing and the Finalised form taking on the new data.
Being new to ASP, I am assuming this would be a session thing, considering the Form number is held in a session variable, as are many other fileds of the form? Is this a common "break" in ASP - a user opening another copy of a form and ending up with cross-contamineted data? I havent included intracate details as at this stage I wouldnt know what to include without including the whole 20 pages of 1300+ lines of code...
I Need to collect about 400 pieces of text information (of various types and sizes) in about seven forms in seven different pages and post all the data finally to a database. I would like to know what is the best mechanism to pass data from form1 through form 7.
Users should be able to go to previous pages and edit entered data. Should I pass them as hidden variables or retain them as session variables or are there other more efficient ways to do this?
Also, I want to be able to later retrieve the data and porpulate the forms with the data so that users can edit the data and post it again. I am using ASP to do this (not .net). Any help from a generous programmer?
I have a simple application setup where people can submit a request for a sample of our product to be mailed to them. It's a very simple form with name and address information. I have a page setup where our warehouse guys can pull up current requests and then the plan is to use USPS.com to print shipping lables.
While it's already a big time saver, they're still having to either copy/paste or re-type the information into USPS.com's forms. Knowing the names of the form fields on their site, is there a way I can populate their forms with the data in my recordset from my details page?
For instance, they pull up the current requests and they click into the details page for one of them which lists the person's name and address. If I have the USPS.com page open in another window and on the screen which contains the form fields is there a way to call that page and populate those fields accordingly?
1) This is page built as a form which displays the content of a SQL database (a specific row) for users to update.
2) Each form field contains the actual information that the database has at this time (some Columns May or May not have info in it. No actual way to determine if its NULL or Just Empty).
3) I have the actual row selector based on the Unique ID (autonumber value). Its selected from a previous page and passed through GET.
I have the same layout for a few dozen pages and want to know if there is an asp code or something else that would allow it to load 1x and only the new content reload.
I need a page or set of pages to allow a user to mange the file system under a certain folder. This certain folder will be determined by authentication and db checks. So the user will need to be able to Rename files or folders, Delete files or folders and move files or folders.
I can handle writing the code to do this but I am stuck on a user interface. Does anyone have a good example they would be willing to show me?
I have a lot pages on my web site, and I don't want to go through and make each one. So I want to have a querystring to load each pages layout from my ms access database, and I don't know where to start.
I am currently migrating my MS Access Program to ASP. My only problem is I cannot migrate my report since the layout is different. Is there a way where I can use WYSIWYG format?
I have coded my pages in HTML and named them as ASP. I would like to use a trailing string i.e. domain.com/page.asp@somthing=4 . which pulls from a database of plan names and corresponding prices over a user selected interval. I want to offer pricing over these intervals:
1month 3months 6months 12months 24months
with a percentage discount being offered for each greater length of time. The user should be able to use radio buttons to select how to pay and after this a paypal button should be generated with the designated amount.
Now that I have layed out what my intensions are, does anyone have any ideas of how to complete my goals using ASP? and if ASP will not do the trick does anyone know of a better/differnat way to do this.
I am building my own webpage using HTML, Access DB and ASP. I have built the HTML pages but I have one query. I posted this in HTML forum already and was told to ask here. I have a form that is filled in by the web administrator that must be displayed on main page. It is a timetable for a cinema and the information can be submitted into a database table.
I only want to have a maximum of 3 rows in the table, one for each screen. Is this possible? My other query is when Im extracting the film information from the db table to the users page I want it to look lilke something resembling this:
I am semi-new to ASP. I'm in the process of making several reports and I wanted to condense one of our reports to fit nicely on a web page. This report consists of about 5 different queries.
I want to make a table like the one below in ASP. I thought I would just make a table and go from there but I quickly realized I can't.
I was wondering is there is a way to neaten up or rather seperate the main layout and the asp codes? For example, to have a main.asp(which is solely the design and layout) and include other .asp files that retrives and records the records.
if there's a better way to seperate my asp code from the main layout? like to have an index.asp(solely the layout and design) and just include other .asp files to display the records.
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