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
I have a Javascript function which dynamically generates rows containing a List box having fixed options. Whenever i add a new row through my function the previously selected values in List box are not getting retained. This works fine in IE6 but not in FireFox 1.0 PR. This feature i am implementing using ASP and Javascript.
View Replies View RelatedadoRS.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?
I've made a form on a php page, where one of the fields is automatically filled in dynamically from the page it is referred from. That part is working find, it pulls up the product model number from the page it is referred from. Now, when it is submitted it runs an asp script to send a confirmation email to them, then sends an email to me with the information collected from the form. That still works as well. So, finally, here is my problem and question:
I cannot get the variable that the form pulls up automatically using php, to be passed into the asp script and sent through the email. All other variables work.
Is that because the script that is used to send the email is asp - yeet the variable is pulled from php? I would think because it puts a dynamic figure, and submits it, that it would becomes static. I'm not sure what the issue is here.
I have a form on an asp page and need to dynamically add rows to it and then be able to insert the dynamic cells to a SQL database.
I have tried this with JAvascript and have kind of hit a wall. Any ideas how to do it with ASP instead? I want to add the next row when a user exits the last cell in the existing row.
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'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 Relateda 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 a web page form that I would like to use some ASP code in. As it stands right now I have a text box (field) that is straight HTML.I want to use the number that is put into the field to generate that number of rows in a table further down in the form.So I am posing this question how would I go about doing this.I am able to use ASP and Javascript (if need be).Or should I start over and code the entire form in ASP?
View Replies View RelatedI have a web page form that I would like to use some ASP code in. As it stands right now I have a text box (field) that is straight HTML. I want to use the number that is put into the field to generate that number of rows in a table further down in the form. how would I go about doing this. I am able to use ASP and Javascript (if need be). Or should I start over and code the entire form in ASP?
View Replies View RelatedI am trying to add rows to a table dynamically, using JScript. Can I someone
explain, how to add events to the newly added cells/ rows? Following code
does not fire the onmousemove event. Code:
Depending on a value in a recordset, is it possible to write the table cell background colour. for example:
If "win" is the value, bkgrd will be "green"
If "draw" is the value bkgrd will be "yellow"
If "lose" is the value bkgrd will be "red"
I have a dynamic table, with a column named "player" in this column is NBA player names - generated from a statistic database. I am hoping to be able to create a link on the players name that will direct the webuser to a profile page like the following:
http://sports.espn.go.com/nba/players/profile?statsId=3282
I am having trouble becasue the stat page is not by the player name but a numbered ID.
I tried using a player search like follows:
<a href=http://www.tsn.ca/nba/player_list.asp?name=<%=(Blair.Fields.Item("IDPlayer").Value)%>&Submit=GO ><%=(Blair.Fields.Item("IDPlayer").Value)%></a></td>
When I do this it only seems to search for the first name.
I have a dynamic table which is checking data from Access database and filling up the table appropriately. In my development environment of Windows 2000, the table displays properly but after hosting (that same source file), the table is not displayed. The error occurs at the following point:
Code:
<font face="Verdana" Size = "2"><td width="70px" height="25px" align="center" <%=colorBG(weekNr,dayLoop,intPeriodStart)%>
</font></td>
The host server is using windows 2003, what could be the problem?
I have a dynamic table, with a column named "player" in this column is NBA player names - generated from a statistic database.
I am hoping to be able to create a link on the players name that will direct the webuser to a profile page like the following: Code:
I have an .asp page that contains a drop down menu, that when a selection is made, reformats the page to one of 22 different .asp pages. When clicked, the drop-down disappears and the options from it are formatted as a list on the left hand side of the page.
I need to format this so the list is in 3 columns, with the secection bold. I think I need about 4 if..then statements, but I've never done this before...here's the specific code, the code for the drop-down is first, then the code for the "quick link" list: Code:
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 Related1) I build a Html Table dynamically (Header Row, and then 2 rows with data
All 2 rows have 2 cells: cell(0) contains a delete button (ASP Button),
cell(1) contains a HTML Text box
2) On Form Load and get some data from a dataset and then from it's contents
build the page
At this point the page is rendered and 2 rows are displayed. There is an Add
button that a user can click to add another row to the table. This works fine
and the row is added.
Now if the user clicks the delete button in row 2 the form is posted back, I
rebuild the page, and then in the click event for the delete button remove
the row from the table and the dataset. All appears to be fine at this point.
Now if the user clicks the add button again another row is added, but this
time row 2's textbox has the wrong value. It appears to be related to the
view state. I think the view state somehow is not getting cleared when the
row is removed.
I code that creates a calendar for each month and then it displays events from that month that are stored in a db. I need to loop through my recordset and display all the events, but I can't quite figure out how to do it. I am thinking I need to do an array. But I am not really sure.... any ideas. Here is where you can view the calendar. Code:
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 ....
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)?
Does any one know a good site where I can go to learn how to let the user determine how many rows they want to display?
View Replies View RelatedIn the table MYSQL I have this sequence of rows:
CODE===========NAME
610=============ASSI
610=============ASSI
610=============ASSI
610=============ASSI
619=============ASSI-9
619=============ASSI-9
619=============ASSI-9
I like to see:
ASSI
and query that counts for all rows like ASSI ...
My idea is to have a web form that a user can add extra fields if needed.
Example would be a form that a user would add ComputerName, IP, and at least
one row of data say Application, Vendor, Contact. Then they need to add two
more rows of the same data (App,Ven,Cont). So I guess some sort of
dynamically adding more fields for more data entry. The point being you
don't have an idea how may there really are to add. Then on the database
side I would guess one table to hold the IdentNumber,ComputerName, IP and
another table for the IdentNumber, App,Ven,Cont.
I have a database used by another application, i want to be able to manipulate the data stored in the database, the problem is that the way the information is stored its awkward(assume this is purposely so), but i cannot change the db structure at all, so heres my problem: Each Person in this database will have multiple comments stored against them:
ID | CommentCode | LineNum | ValueData
1234 COMM1 1 Something about thi
1234 COMM1 2 s person seperated ov
1234 COMM1 3 er multiple lines
1234 COMM2 1 Something else about
1234 COMM2 2 them
What i want to do is circle through the recordset and combine the multiple lines of the same comment, any ideas/examples?
When I do a query that I know has 2 rows, I get rs.recordcount equals -1. Same thing when it's just one row. I need something that gives me the number of rows.
View Replies View RelatedI was wondering if anybody could advise me how to return just 100 rows from a database query. In Cold Fusion I'd use the maxrows function, but not sure how to do in ASP (or can I do it in just SQL?). My code is thus :
' Retrieve last 100 records. Query then run through the query building a string
Set objRetrieve = objConn.Execute("SELECT Players_ID, Players_Name, Players_Score FROM Players ORDER BY Players_Score DESC")