Can ASP Table Display 200 Columns, 500,000 Rows?

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.

View Replies


ADVERTISEMENT

How To Display Data In 3 Columns By 4 Rows Format

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.

View Replies View Related

Write Rows Not Columns Or Add Line Break After Non-empy Recordset

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:

View Replies View Related

Displaying All Columns In A Table

What I want to do is list all of the columns in a table from a MYSQL database.. How would i go about this? I already know about select *, what I want to do is write them all down.

View Replies View Related

Display Only 3 <td> Columns

I want to display a table with 3 columns only. The cells will be populated with database fields requested from a queryString .

The actual Access field value is either "Y" or null. If a "Y" value is true then I want the Field.Name to be displayed.

Anyway, the table has 40 possible columns so I'd like to limit it to display
only 3 columns: I can generate the field names below: Code:

View Replies View Related

How To Sort A Table Based On 3 Columns?

I have a Table with 10 columns and would like to sort this based on columns 2, 7, 5, respectively. I thought my code :

objRS.Open "SELECT * FROM MyTable ORDER BY col2, col7 col5", MyDB, , , adCmdText
should work, but didn't. How do I do that?

View Replies View Related

Display Records In 2 Columns

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?

View Replies View Related

Complete Function To Create Table And Columns

I have been looking everywhere, and can't find a complete function to create tables and columns in access .mdb from ASP, while adding columns that are missing in tables that already exist, can anyone post a link or the code to such function?

View Replies View Related

Dynamic Table With Content Seperated Into 2 Columns

i am just trying to build a table that will put content into 2 columns. Ideally, if there were 20 hits, 1-10 would be in column 1 and then 11-20 would appear in column 2...i just can't seem to figure it out. I had started by getting a recordcount, and dividing it by 2, but things got a little fuzzy after that.

View Replies View Related

Display Info In Three Straight Columns

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).


<%=John%><%=Doe%><%=Incognito Street 3%> <br>

<%=Jane%><%=Doe%><%=Leaf Street 13%> <br>

<%=Pete%><%=Wilkins%><%=Tree Street 8%> <br>

View Replies View Related

Display Info In Three Straight Columns

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>

View Replies View Related

Display Data In Multiple Columns

I have let say 100 record from database, then I wanted to display in 4 columns, so each column will have 25 records. hot to d that?

View Replies View Related

How Many Rows Are There In Table

adoRS.Open "select * from table_name"

numField = adoRS.Fields.Count
response.write("Number of Filed of table_name = "&numFiled)

how will i know how many rows are there in table_name? is there a

numRows = adoRS.Rows.Count

any help with this?

View Replies View Related

Alternating Table Rows...

How do I do alternating table rows? I'm just using the:

[vbs]

rs.movenext
loop
[/vbs]

method...so, it's in a table...I looked on ASP101, but that's the wrong kind've database setup I have...

How do I do it? It should look like:

[vbs]
<tr>
<td class="Alt1"></td>
<td class="Alt1"></td>
</tr>
<tr>
<td class="Alt3"></td>
<td class="Alt3"></td>
</tr>
[/vbs]

View Replies View Related

Dynamic Table Rows

I have an ASP VBScript page with a dynamic table.
Each row contains a dynamic price, a qty field, and a total. The total on each row changes (onChange() ) when a qty is entered (this works fine).
I now need to total up the 'total' fields and put a 'GrandTotal' into a variable for later

View Replies View Related

Table Rows And Recordsets

I'm wondering if it's possible to write recordsets into HTML table cells, say, 3 columns wide using a loop? I've tried it but obviously I need to get 3 records out at a time so I can't detect the end of file. Any ideas?

View Replies View Related

Alternating Table Rows

a way that i can alternate the colours of my table rows?I know that you can do it in .net if there is a fairly simple way to do it in standard asp.

View Replies View Related

Having Trouble Getting Openschema To Work To Report Table/columns Names

dbpath = "D:Pure-Flo IntranetdatabaseEngDB.mdb"
set objConn=Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" & dbpath
objConn.Open

Set rsSchema = objConn.OpenSchema(adSchemaTables)
Do Until rsSchema.EOF
If rsSchema.Fields("TABLE_TYPE") = "TABLE" Then
Response.Write rsSchema.Fields("TABLE_NAME") & "<br />"
End If
rsSchema.MoveNext
Loop
rsSchema.Close
set rsSchema = Nothing

just a simple example of what i'm trying to do. its supposed to list the names of all the tables in the database, but instead its returning the following error:

ADODB.Connection error '800a0cb3'

Object or provider is not capable of performing requested operation.

View Replies View Related

How Do You Add Several Rows To The Same Table With An Update Button!!!

I'm trying to update several rows to the same table of a datbase using ASP & an access database.

But I can't seem to get it working. I can get it working for one row but more than that won't work. The amount of rows that need to updated is never the same.

View Replies View Related

Split Color On Rows In Table

I am creating a table with two rows(one of which is the header), and 8 column headings. In the 2nd row, i am trying to apply 3 different colours that span various length across the row. I want the row to loop adding one colour directly to the end of another, but adding this to the correct length of colspan for each colour.

The code below is what i have done so far, but i only get a blue colour in the 3rds cell.
Eventually i would like to have a variable length of row, as i do not yet know how many rows i need (this will be dependant on something else). But i would like the colour method to be applied to each row.

Also i need to be able to make colspan variable so after each loop, it will be updated by the new column amount ....

View Replies View Related

Adding Rows To Database Table Thro ASP

I want to add a row to library table. Table has total 7 fields. But I
want to create the new row with 5 field data. When I run the following query
in MS Access

strQ = "INSERT into library (index,title,author,itemtype,createdate) VALUES
('B-096','Hihihihihi','hello','Book','07/18/04')"

It successfully adds the row. But same thing I am trying with the following
ASP code. It gives error, saying syntax error in INSERT into statement. Code:

View Replies View Related

DISPLAY NUMBER OF AFFECTED ROWS(odbc_?)

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:

View Replies View Related

How To Trigger OnChange Or OnClick Events For Multiple Rows In Table??

I can trigger these events successfully if table only has one row:

Sub InputField_OnChange()
......
End Sub

But, these events cannot be fired if table has more than one row, why?

View Replies View Related

Integrating Asp Into A Table To Auto Generate Rows From A Select Statement

Im running a select statement to a database and wish to display the relevant records into a table. For some reason, its not liking this - can someone see why, and or tell me an easier way to produce an 'automatically generating' table of results.

<% @language="vbscript" %>
<% Option Explicit %>
<% Response.Buffer=True %>
<html>
<head>
<title>Search Results</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="#FFFFFF" text="#000000">
<!-- #include file="dbConn.asp" -->
<!-- #include file="adovbs.inc"-->
<h1>Your search results returned the following popup messages:</h1>
<% Dim msgtype, title, message, url
msgtype=request.form("type")
title=request.form("title")
message=request.form("msg")
url=request.form("URL")

Dim adoDB, adors, strSQL
set adoDB = Server.CreateObject("ADODB.Connection")
adoDB.Open strConnection
set adoRS = Server.CreateObject("ADODB.RecordSet")
strSQL="SELECT PID,P_TITLE,P_MSG,P_URL,P_TYPE FROM POPUP WHERE ("
If msgtype <> "" then
strSQL=strSQL & "P_TYPE='" & msgtype & "' "
If title <> "" then
strSQL=strSQL & "OR P_TITLE LIKE '%" & title & "%' "
If message <> "" then
strSQL=strSQL & "OR P_MSG LIKE '%" & message & "%' "
If url <> "" then
strSQL=strSQL & "OR P_URL LIKE '%" & url & "%' "
End if
strSQL=strSQL & ")"


'DEBUG ONLY!!
'response.write strSQL
'response.end

adoRS.Open strSQL, adoDB
' Loop through the recordset to display the records
Do While Not adoRS.EOF
& " <tr> " &
& " <td> " & Response.Write adoRS.Fields("PID").Value & " </td> "
& " <td> " & Response.Write adoRS.Fields("P_TYPE").Value & " </td>"
& " <td> " & Response.Write adoRS.Fields("P_TITLE").Value & "</td>"
& " <td> " & Response.Write adoRS.Fields("P_MSG").Value & "</td>"
& " <td> " & Response.Write adoRS.Fields("P_URL").Value & "</td></tr>"
adoRS.MoveNext
Loop
& " </table> " &


' Tidy up afterwards
adoRS.Close
Set adoRS = Nothing
adoDB.Close
Set adoDB = Nothing

%>

</body>
</html>

View Replies View Related

Display Records From SQL Table

I'm trying to display records from a table in a sql database.The problem is, every month a new table is created, so I don't know what the name of that table is going to be.
It there a way that I can make sure the sql only reads from the latest created table?

View Replies View Related

Display Txt Into Html Table

i want to convert my txt file into a html table for display . But i dun want it to go through db .

View Replies View Related

Display Data From Different Table

If i created three different type of table. Inside these tables, they might have the same key field's name. Example:

Table A - ExecNo, Month, Year, CustCode
Table B - ExecNo, Month Year, DestCode

as u can see that these two tables have almost the same key field but they r actually keeping different data. how can i list these different data out in an asp page? it is because i am having the problem whereby.

where the table want to display data from table B, it actually misplace by table A . how can i write the sql function to differentiate both of them.

View Replies View Related

Display Textbox For Each Record Retieved From Db From Same Table.

When a selection is made from a list (lstpos) - single selection allowed, (for example a user selecting engineer), it retrieves all the duties (it may b a duty i.e. 1 record OR many duties i.e. more than 1 record) an engineer performs (each one on a different line) from a table and automatically displays text boxes next to each duty so that the user can input "scores" for each duty (rate the engineer).

How to do this?

Next this data needs to be input in a table when the user clicks a button (ADD or OK) in the format :

user duty score

user1 duty1 score1
user1 duty2 score2
user1 duty3 score3
etc...

Anyone has an idea how to do this?

View Replies View Related

Parse A String From A Field And Display In Table

I need to parse a string from a single, semi-colon delimited, 60 character
field (el_text) in a recordset and display the results in a table on a
webpage (ASP)

I can retrieve the recordset from the database and display the field data
results in rows of a table but have the entire 60 character string in one
cell. I need to break that string apart and put each semi-colon delimited
value in it's own cell. Then move to the next record and do the same thing
in the next row of the table. - and so on

I'm using ASP, VB Script with DMSII Database and OLEDB

Does anyone have some code examples on how to break this field apart and
then arrange the data into an html table on a webpage?

View Replies View Related

Count And Display Number Of Records In Table

how can i Count and display number of records in table?

View Replies View Related

Display Records From MS Access Tables As A Total In A Table In A ASP Page

I'm trying to display records from an MS Access DB (*.mdb) in an ASP page (table).. I don't want to display all the records though, I just want to display the total of these records..i.e in my table I would like to show how many calls someone has closed this year..(number)

Joe Bloggs ---> 100 Closed

Is this possible? I was thinking that I need to write an ADO that includes COUNT but I'm not too sure how to write this.. Here's what I have so far: Code:

View Replies View Related

2 Columns

I want to display the results from my database in 2 columns.any easy tutorials or article out there? havent found any easy so far

View Replies View Related

Get The No. Of Columns!

How do I find out how many columns exist in a SQL Server DB table before displaying the records of that table?

Also how do I get all the column names as an array so that I can seperate each column using the Split function?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved