I am having a bit of trouble with classic asp and tables.
I want to loop through a recordset (easy enough) but I want to display the records in a table with only 3 records in a table row. So in other words each table row needs to have 3 items then a new table row is created dynamically until recordset.eof
Item 1 Item 2 Item 3
Item 4 Item 5.......until eof..
I am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
I am having a problem with displaying information. I believe that it's a problem with the table....
View Replies View Relatedi want to show records from the database in such a manner that three records will show on on TABLE ROW. and then the next three on next table row and then next 3 on third table row. So nine records on one page. and there will be link for next link to move to next page.
I have some paging idea and i know how to move to next page but i dont know how to display records by limiting the columns of the rows. Like in the past i used to show all the records by either increasing the rows or by increasing the columns of the tables by using loop. but now i want to show records in such manner that limits both the rows and columns.
i have a set of details in the database that looks like this: Code:
Name Number
-------------------------
ABC 123456
ABC 128556
ABC 125559
DFF 559851
DFF 448715
DFF 154873
how do i select then in such a way that they are display like this on the asp page:
Code:
ABC
-------------------
123456
128556
125559
DFF
--------------------
559851
448715
154873
I would like to display the data in a table like first 50 records in a column and next 50 records in another columns.
View Replies View RelatedWhat 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 RelatedSay i have 100 rows in a table and i make a query:"Select * from table", i will get all the 100 rows displayed, but what i want to do is to display 20rows in a page and then have 'Next' and 'Previous' links to navigate through the records 20 by 20. This is in fact exactly as in this forum where only 20 posts are displayed sorted by most recent ones and so on.
View Replies View RelatedI am trying to expand/shrink a table when a user clicks/unclicks on a button, checkbox, or link. I have searched all over and can't find anything that will help me out. Does anyone have any good code examples for me to work with? I am sure I need a combination of ASP and Javascript function / onclick event.
View Replies View RelatedI want to display data like the following:
<table>
<tr>
<td>1 to 10 records</td><td>11 to 20 records</td><td>21 to 30 records</td>
</tr>
<tr>
<td>31 to 40 records</td><td>41 to 50 records</td><td>51 to 60 records</td>
</tr>
</table>
I tried with rowcount it is displaying in a row ancontinully with if conditions also. how to do this or any example script.
I have a results table that is 5 columns wide. the recordset is returned with 48 items. I have no problem displaying 5 per row until I hit the last row where i get a ADODB.Field error '80020009'.Either BOF or EOF is True, or the current record has been deleted.Requested operation requires a current record.how do I close of the table row when I reach the EOF?
i.e
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 4 5
1 2 3 * *
I need to display empty cells (in place of the *'s)or end the row when there is no data to fill it...how is this done?
I need to solve this as part of a class project. It is designed to simply read a SQL table and display the data in the browser. But it will only show one record based on ID at a time. So if I have multiple records with the same ID such as page.asp?ID=9734, it would show all records using that ID in the browser. Code:
View Replies View RelatedI'm trying to display three columns in a table row, then I want to create a new row with three columns until there are no more records to display. Unfortunately, my code only displays one column in each row: Code:
View Replies View RelatedI am calling the values from a table and displaying them in a table, no biggie, i have not used a for loop to create the Html table, rather i have created it myself using a for loop so i can specify the table values i want.
What i am calling from the table is All of the fixtures for the football games in a season but i want to put a seperator or insert a spece of some sort just to seperate the fixtures by date otherwise it just comes out in a long list of fixtures, no nice on the eyes.
here is the code from selecting the data form the table to displaying it:
I have a recordset that displays hundreds of records, I would like to display a row number next to each record in the order of 1, 2, 3 etc.
View Replies View RelatedI am having an issue figuring out the correct syntax and possible SQL code to display data from one table (CustEndPoints) with a DropDownList used for a GridView to get data from another table. I have been playing with Joins, which is probably correct, as well as ControlParameters. Code:
View Replies View Relatedhave 2 tables that show boat information
Table 1 shows make model price etc
Table 2 shows the information for the images
I have joined the 2 tables as below
Select *
From tbl1, tbl2
Where tbl1.id = tbl2.id
Because there are more that one picture for some of the boats it displays each image as a seperate record
I just want it to show 1 image for each record
Is this possible??
I want to display a series of records grouped by nested years and months, e.g.:
2004
December
Record1
Record2
Record3
November
Record4
Record5
...
...
2003
This would be based off of a date value stored with each item in the
recordset.
Does someone have a snip of nested looping script to break this down by
date in this manner? Code:
On the first ASP page I have a form (checkbox) with 20+ different categories. After the user clicks on a few of them, they all have to be transfered on the second ASP page in HTML table. My problem:
If user selects only three categories, they should represent themselves in three differenst columns in my html table(something like Column-Name). If he selects 4, - four differesnt columns in the same table, etc.
So the table has to be 'dynamic'. It should have the same number of categories that the user selected on the first page. Could it be done? After that I should populate every category from a recordset and I know now how to do that.
Basically I have the following SQL statement:
Quote: sqlConnect = "SELECT Users.User_ID, Users.Password, Users.Username, Event.Event_ID FROM Users LEFT JOIN Event ON Users.User_ID = Event.Admin_ID where Username = '" & Username & "'"
set rs= Server.CreateObject ("ADODB.Recordset")
rs.open sqlconnect, objconn, 3, 3
where username is an ASP variable of the username.
When I run this and I try to access a field from event I get an error i.e.
Quote: if rs("Event.Event_ID")<>")" then
session("admin")= rs("Event.Event_ID")
end if
Does anyone know what is wrong?!?!?! It doesn't seem to be able to pick up the fields from the event table?
I am in the process of rewriting my table formats for an Access Project that was created. I now need to get the data from 1 table and transfer to a second table.
I created a page that creates the record set, I then loop through that record set and need to run an update statement to a second table, however, I get the following message:
Microsoft JET Database Engine (0x80004005)
Could not use ''; file already in use.
/BusPlanTest/updBusPlan.asp, line 17
Below is the code I am using: Code:
I have an interesting problem and am looking for some advice. I am
hoping to build an asp whereby records are pulled from SQL Server. These
records will be merely file locations for thumbnail images I hope to display
in a grid.
Rather than having a grid be constructed row-to-row, I was
wondering if it is at all possible to dynamically construct this grid as a
table of thumbnails whereby each cell (perhaps 5-6 columns across)
represents one record? I have no idea how one would construct this loop that
spans columns AND rows rather than just rows.
I'm having trouble with the recordset object. I'm trying to use the "RecordCount" aspect of the recordset but it keeps diplaying "-1". How do I get it to show the total count of records?
View Replies View RelatedI have aproblem to transfer a data from table x to table y based on id. Its mean when 2 table have same id all data table x must move to table y. I don't know which command need to use is it insert into or update?
<%
Dim conn
Dim rs
Dim MYSQL,MYSQL2
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
Set cmd = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "DSN=prmm;UID=administrator;pwd=sa"
conn.Open
startdate=request("tarikh1")
enddate=request("tarikh2")
MYSQL = "SELECT * FROM table_x where paymentdate between '" & tarikh1 & "' and '" & tarikh2 & "'"
rs.open MYSQL,conn ....
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have a table with many txt boxes which i have inside a form with a submit button to an update page which adds all the details to a db. The problem is i have a another table inside the first e.g. table 2. i want to be able to update table2 by clicking a second submit button that would update it. Is it possible to have a form within a form or how can i do it??
Also i need to update the entire table in one go. For exampple if i have 3 records in table2 i want to be able to update them all by clicking the one update button. Code:
I have the following code but this is inserting manually. I want to make a query from table 1 and automatically enter the records into table 2. What needs to be modified? Code:
View Replies View RelatedHave an app which dynamically creates table rows depending on records, these can be several hundred (don't ask). Hence a very long page at time. Each row includes a hyper link to a new page, and a link back to the original page.
Is there any method (maybe via js) where on leaving the second page l can redirect the browser to the table row the end user clicked on? Hence the bookmarking. Can do this via Visual Basic on the desktop app, but can't work it out on the web app.
I have a table produced with names across the top and services down the left hand side with boxes for numbers for people who recieve services then the info is written into a table in an access db. That works fine and here is that code:
View Replies View RelatedI have two tables. Table A has 20,000 records, Table B has 2,000 records. Table A is what needs to be updated from the data in Table B. Only some fields will be updated and of course, only some records - both tables have the same field as a ClientID so matching up records should be easy.
Anyways, been a while since I have used ASP to work on things like this but would like to work through this one. I understand the process I believe, it is just how to make it go on to the next record once it has finished updating the first.
Basically, I was thinking of having it set up to reaad the top record from Table B, update applicable data in Table A. Delete that record in Table B. Move on to the next.
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. Code:
Hello I have a page for registering users.
I am reciveing this error:
The following errors occured:
- An error occured. -2147217904 : No value given for one or more required parameters.
there are students and teachers. therefore I have 3 tables one for logins and one for staff and on for students.
I have a form designed to capeture the need information.
in the code I am runing an if and elseif statmetn to determin the tables. I then insert the userid and password into the login table.
then i enter the remaining information into ither the staff or student table. what i am trying to do is select the perimary number that is generated as the userid and passeword are enterd. and add this to the second table. Code:
I want MS Access 2000 database column of table 1 = column of table 2. This is what I was doing: Code:
View Replies View Related