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'm sure it sounds kinda nutty to display 200 columns and 500,000 rows of data. But I have been pulling data from a Lotus Notes database into Sql Server for a while now, but Lotus Notes is starting to crack, columns getting corrupted. Can't handle the volume of data and number of columns. Sql Server has no problem. But displaying the data is the big deal. The end users want to be able to scroll acros a page to the colum of their choice, or be able to scroll up or down.
I was thinking of breaking up the table into section, but this would reqire additional clicking to get to the next section of the table. Would it be feasable to have a 200 column table in asp? or should I stick with the section idea? I have to tell my dept something. They started out with Lotus Notes but couldn't query the data. I have been suggesting to migrate the project entirely to Sql Server/IIS. Notes can at least display all the columns.
I have colums in my table named feature1, feature2, feature3, etc.... I would like to write them in my asp document with a line break in between them. I did this: Code:
I'm using Response.ContentType = "application/vnd.ms-excel" to display my SQL filled table in Excel and all the data shows up, but the column formats are not correct. For example, Excel treats my column with data such as "01-80" as date "Jan/1/80" and I want it to stay as a string. How do I specify the column format as text inside my ASP code?
i have a database with 60 records. I display all of them into a single column. What i want to do is to display the records in a table with 2 columns, the half of them into the first left column and the rest 30 to the right column.
I used the RecordCount to count all my records but how will i count the half of them and when the half is reached i will change the column and go to the right one?
how I can display three straight columns (maybe possible to use some kind of tab?) using ASP. Assume the columns contain, first name, second name and address. What should the ASP code look like to get this output? I don�t want to use tables (even though it should look like a table without borders have been used).
I wonder how I can display three straight columns (maybe possible to use some kind of tab?) using ASP. Assume the columns contains, first name, second name and address. I don’t want to use tables (even though the output should look like as if a table with no borders had been used). The code below obviously isn't good enough for that purpose.
<%=John%><%=Doe%><%=Incognito Street 3%> <br> <%=Jane%><%=Doe%><%=Leaf Street 13%> <br> <%=Pete%><%=Wilkins%><%=Tree Street 8%> <br>
i have written a code to change password. it works perfectly i.e. sql query "update is ok", now i want to display number of affected rows that i can inform user if password is changed or not. Code:
I thought its more space efficient of displaying the data in multiple columns (let's say 2 columns for now), instead of one loooooooooong column in a table, are there a simple script of coding that can do just that? How about 3 columns?
I need to have a table with 3 fields whereby the user can input the data and insert into my database using this website. However, I need this table to be dynamic so that after the user input the info for the first row, the user can click on add another row button and another blank row comes out. then the user can input the info for the second row and so on.
I am using ASP in the end to insert the data. I need some advice on how to create this kind of table where the user can click on one button to add another row and then able to insert all data in the entire table into database using asp.
I've looked over the last 2000 posts for info on incorportating an RSS feed on a web page using ASP to control the display - especially which elements are shown and how many items are shown. I found a free ASP script that I hoped would do the job >>>
I am using the query bellow to display some fielsd on my page and am having some problema displaying the data from calltime. I have the field setup in access as short time but when it is displayed on the page it displays as 12:15 AM. How can I remove the AM/PM from the display?
<% notesSQL = "Select * From notes where callID =" &RSupdate("callID") Set RScalls = dbConnection.Execute(notesSQL) Do While Not RScalls.EOF callscounter=callscounter+1 %> <%=rscalls("notes")%> Added by: <%=rscalls("employee")%> on <%=rscalls("notesdate")%> Time Spent: <%= rscalls("calltime") %><br>
In backend access table, I have set date format as medium date i.e. 15/Nov/2007 but in ASP output it shows as 11/15/2007. Can it be displayed as 15/Nov/2007? Also there is a hyperlink .. Code:
But it does not work properly and gives only to output, not CC or subject. I want to make a mailto link which can have to, cc, subject and if possible mail body also.
I currently have a .asp web (using VBScript) that retrieve the date field from my Access database. The format stored in my database is in DD-MMM-YY format.
But when i display it onto the web, it is in MM/DD/YY format. May i know if there is any way i can change the format that i display to DD-MMM-YY , or to a DD-MM-YY format?
What i'm trying to do is delete away some rows of data in a database when a session ends. The codes are shown below. The problem is why the the database dont get deleted even after i set the timeout to 1 (waited for more than 1 minute) or after the script called the Session.Abandon? Code:
I try to display the time from an access db in 12hr clock format. Am I missing something simple? The time is held in the medium date format ie 07.30pm and I'm using:
FormatDateTime(rs("StartTime"), vbshorttime)
but this displays 19:30 instead of 7:30. If I change to vblongtime I get 19:30:00 and if I change the time field format to short time I still get 19:30. What am I doing wrong??!
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'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.
