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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
how can i Count and display number of records in table?
View Replies
View Related
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
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
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