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 RepliesadoRS.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?
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]
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
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 RelatedI'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.
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 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 ....
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:
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?
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>
I 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 ....
im building a page which has a few while loops. this means that im inevitably going to end up with about 20 recordsets on the page. will this slow the page down at all? its quite a lot of hits to the database/server. the results the recordsets will be returning wont be that big though.
View Replies View RelatedMy ASP code creates an ADO recordset object on the server.
Later on the same page, I have a javascript code snippet that I use to
dynamically populate a drop-down box based on choices made in another
drop-down box. Can this javascript (or a server-side equivalent)
Is there a way of using multiple recordsets with the same connection?
My recordset at the moment inserts data into the database, and i want to have a drop down box with data already within the database, as well as the insert recordset, is there a way of doing this?
Am having trouble opening multiple recordsets - keep getting the er:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
/eft/postflight4.asp, line 146
Have checked the permissions and the user has full access.
Code:
How do I create a recordset from another?
e.g.
sSQL1="SELECT * FROM ThisTable"
rs1.open sSQL1,conn
sSQL2="Select * from (rs1?) WHERE name='fred' "
rs2.open sSQL2,conn
I create a page which will show me all the Regions from the table "RegionTable" where I have no information (empty fields) in on of the fields RegionDescription or RegionRank.
It is to make my content managing easier. I do not want to see those records which contain all the necessary info (region description and rank).
I tried the following code, but it does not work
qry = "SELECT * FROM RegionTable WHERE RegionDescription="" AND RegionRank="" "
error message is:
([Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1)
Is there a performance advantage to parsing thru a recordset verus using an array?
I'm currently trying to populate a listbox by returning data from my database, then either parsing thru the recordset until I reach the EOF, or putting the data into an array.
I have never sorted a recordset - using rs.Sort - i have no problem sorting it in SQL.
All the tutorials i get say that i have to use a client cursor location, so this is my code:
Let's say you have pages 1 | 2 | 3 | 4 | 5 and you're on page 3. How do you make the code so that 3 will be without url?
View Replies View RelatedAssuming I had a recordset set up like this:
Set rs = Server.CreateObject("ADODB.Recordset")
is it enough to close out the code with
set rs=nothing
or is there a benefit to
rs.close
set rs=nothing ?
im building a site for a clinic. they want to have a calendar which displays the times for each day that are available for appointments.
at the moment i have a calendar on my page. i want to display the correct times for each day. should i use one big recordset that gets all the times/dates from the db or cycle through each day and create a recordset for each day that there are times available (some days the clinic wont be open)?
if i go with the latter option, i could potentially have 30 recordsets open. is there a fast way to execute recordsets.
I have an array of items and for each item I need to find sizes and and for each size I need to find colors The array of items comes from the previous page. Code:
View Replies View RelatedI have a table that is just dumping an entire database data. I would like to have the values of the columns re-sort the data. Not the column heads for the data displayed under the column head varies.
For example, one column, Components, displays 80 components types and another column, Category, displays 40 categories types. When a visitor clicks on one of the component values, it should then display only that data. I've done this before but, it has been a very long time. I remember creating a link surrounding the recordset in my table but what was written.
I have 2 recordsets. One contains all customer info data, the other recordset contains 1 field of customer id's.
How do I create a recordset that contains all customer information (from the 1st recordset)for only the customers in the customer id recordset (2nd recordset)?
I have two different query in my ASP page:
- the first is the list of all my users:
"SELECT DISTINCT lastname, id FROM table1"
- the second is the list of users that join a meeting:
"SELECT DISTINCT lastname, id FROM table1, table2 WHERE table2.codeMeeting = " & Request("code") & " AND table1.id = table2.id"
I want to show all the users in a table (with a FOR loop), with a checkbox that is checked if the users join the meeting (= if users is in the 2° recordset)
How can I do?
I need the IF statement to check 2 recordsets.
If the first recordset has data within then write this to the asp page, If not and the second recordset has data in, then write this to the asp page, then finally if neither of the recordests contain data and are NULL to write 'No Records'
I realize that sometimes you can use recordsets that were never opened (like when you're adding a record to a db) and I realize that you cannot close a recordset such as this.
But for the ones that ARE open, should they be closed first and then set to nothing?
Also,I'm trying to create code that checks if a recordset is open. If so, I wnat to close it. How would I do that?
Is it possible to INNER JOIN two recordsets in ASP?I don't mean the normal JOIN you would use with two tables, but actually join the recordsets in ASP?
View Replies View RelatedIs it possible to move to all the open RS and connections? I open different recordsets on my page and in the end I need to close them and close connection. Problem is I need a function to do that to have it on every page.
Is it possible to travel through all open recordsets like it is possible to travel through all the querystrings and form data?
What is the best way to produce these? Is there a SQL statement thatselects, say, records 30-40 from the results?
View Replies View RelatedI have a record that either says "UP" or "DOWN" . I'd like to associate the "UP" record with an image and a static webpage. I'd like to associate the "DOWN" record with a different image and different link to a static webpage.
View Replies View Related