I would like to know if and how it would be possible to create an
entry-screen that allows the user to enter data in a database, using a
spreadsheet/table-like entry screen. The screen would start of having
headers for each column/field and an empty row underneath. When each column
in the row is filled in, the user must have an option to add another row.
I'm look for the code/explanation that helps me set up the entry screen, and
the ASP code to add the entered data in the database.
I can imagine that each entered row is added to the table when a new row is
added, or a button is pressed and then the screen refreshes with the newly
entered information and a new row...
I am having a problem with entering long ammounts of information (roughly 400 characters) into a database. The database field is set to memo.
Seems that whenever I want to enter strange characters it gives me an error. (I need to enter strange characters for an important reason).
Also I am having some problems with using ASP on Netscape (not testing...just clients are having problems). Does anybody have an idea of whats going on??
I have a page where the user logins in and is taken to another page. On this page i want them to insert data into another table within my database.
At the moment however it just enters data into the database once. I'm assuming it�s because I don't have a recordset set up. How do get the ID of the user so that it will insert the new data into the relevant recordset.
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 want 2 create a survey Web Form that people can fill in. I then want the data entered to be saved to an Excel spreadsheet located on a server.
Can .ASP handle this kind of task? and if so does anyone know the code required to perform this function?
The data entered will be RAW and the .ASP (or whatever required programming) will need 2 process and convert the data into the spreadsheet.
Also, would it be possible to run this from a stand alone machine so that the web form, .ASP and spreadsheet are all contained on the machine and have no outside influences?
I am using VBScript - (asp pages) I want the person to enter a Part Number into a field Example R3HAA0001-CP But the person may not know the whole Part Number and enter
Example 3HAA
I want to use a wild card to make sure the person gets the correct Part Number. I want to stay on the same screen, list the Part Number and Description - now if the person doesn't know the whole number and enters only a partial - I want all of the Part Numbers that match the criteria.
I have two tables, one called tblManufacturers and one called tblModels. tblManufacturers is already populated but now I have to enter the following models which correspond to the ID of the manufacturer into the tblModels table. Any ideas of how I can do this. Code:
I have a database feild that I need to have html code entered into. Short of getting the clients the copy and paste code into <textarea>, is there a simple wysiwyg editor to do the job?? or another way?
i try to make three textboxes to enter the date,but the problem is , when they enter the data base they enter like this 10,12,1980. so it will not be accepted by the date field
I have a few forms and find that people are intering all sorts of information into them that we dont want. Is there a way to stop people from entering things like ()*&^%$#@!+_=><"':; and so in into the forms.
A form example on the site is basic. Something like this.
I want to use asp to assign a css class to <td> tag. I was thinking an If statement, but i've not come across trying to assign a class to a table cell before! I want the cell background to be highlighted red determined by a database table with - yes or null. (null remains white, yes - red) At the moment it simple like this: Code:
I need to figure out how to make ASP add in the appropriate style sheet. Basically I want it to look, see what page it is on and say, 'Ok ... if this is the home page, use this style sheet ... if it is not, use this other style sheet.'
I'm trying to write a style sheet switcher for myself in asp. The code sits on every page. I've so far managed to cobble the following: This block sits in the head: Code:
I am storing content in a database, and when a text field is updated I am adding a line "Updated by <username> at <date and time>" inside the text field.
Now what I would like to do is to apply a dynamic style to that line by using a span.
<span style="<%=UpdateStyle%>">Updated by <username> at <date and time></span> where UpdateStyle would be an ASP variable like "font-weight:bold;color:red" etc, so how that line is displayed is amendable at any time from within an include file.
Well obviously using <%=UpdateStyle%> didn't work ... I also tried defining it as a javascript variable and calling it using document.write, but that didn't work either.
I am having trouble with css style sheet with asp code, everything was working till I put extra of css code in there, and I got error message state expected end statement,
I am currently undertaking a project where I have to make the page layout and colour scheme customisable to the user. I have therefore created the different style sheets for both colour schemes and layouts. Each user within the backend database has a field for layout and colour scheme. I need the system, when a user loggs in, to check the field value of both of these, and apply the relevant CSS sheet to every page within the site thereafter.
I have already tryed using cookies, but becasue it is for a school, many users will use multiple machines so that wouldnt work.
Further to a question I posted a few weeks back - i'm devloping a site for our company where visitors can vist product sections, and pick catalogues they want - currently they can only go to one section, pick catalogues, order them, then move onto another section - problem is this. The powers that be want a more 'shopping basket' style - where customers can browse all the sections and pick as they go - and order them all together. In a 'shopping basket' styleee - so does anyone know of any good shopping basket style tutorials?
I am trying to make my result set print out the results in the same style as a calendar or photo album. I am actually making a photo album, and I can only print the results in list format. I would like to have 3 or 4 results per table row. Then once I have 3 or 4 results across a new row in the table will start. Code:
Anybody have any experience of a decent explorer style tree view system which is database driven?At the minute I'm using ASP Tree View (www.CompuSolve-Technology.co.uk) but it's not really the best.It has to work with a database (MS SQL Server).
It there a standardized process of working with text files that follow the typical INI file pattern with sections within it designated with square brackets? I am looking at needing to read in some of these into the DB and then editing in the DB and writing the files back out again. As an example they would have sections like this:
I have this file called "inc_BreadCrumbs.asp" basically this is a Navigation include file as breadcrumbs style, and I inserted this to every page in my site. It works fine but one thing I cant configure is that:
It displays the file names as for example: search.asp or results.asp etc... But i want it to display as SEARCH or RESULTS etc... How to implement this? Can it display only page title name or something else how can you change it? Code:
I'm using the above lines to generate a spreadsheet from a recordset. One of the recordset fields has HTML data.
Whenever the spreadsheet is generated,it will place some of the HTML data into new rows. Same appropriate column,but different rows. Is there a way around this?Is there an easy to create a DBF or CSV file that would work?
i am having a problemn thinking on a solution to make a web application. This is the scenario: I have to make an application that should catch some user data on the screen and pass it to a database. Here is the problemn: the data that the user will pass is huge. I am talking about some columns and 27 rows.
3 rows as caption rows and the other 24 to get the data. How can i do that? I thought about making columns with textboxes (with ids like R1C1, R2C2, R1C4...) in a dynamic table inside a form and submit it.
But the boss wants an excel spreadsheet look into it. I am relutant about using OWC because first, i don't know if the users will have the office installed and secondly because if they do have office installed, how can i know what version of office is everybody using? Code:
It will grab any style attribute within HTML that uses double quotes, and put it in the re.Matches collection.Now, I want to include single quotes into this regular expression. Here's what I have so far:
