Hi There,
I have a table with 3 rows. 1st has the table/column headers, 2nd contains
the column data and the 3rd is where the loop for the SQL statement lies.
I also have a JS sort function on there (which int complete, but thats
another post/story) which sorts the data A-Z or Z-A. The problem i am having
is that the loop row (which isnt visible on the ASP page, as its ASP) is
being sorted as well.
Rather than excluding the row from sorting, i was wondering if i could scrap
it altogether?, but when i try and move the loop out of the row, all the
data goes crazy, all over the shop.
Basically, where can i put the RS.Movenext Loop statement that will still
dsiplay the data still in the same way in my table (rather than the last
row)
I appreciated this is a weird question, if you would like me to post the
code for my table thats fine.
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me. www.bradflack.com 5  1452 
On Thu, 25 Mar 2004 16:18:03 -0000, "Fawke101"
<gu*@ANTIbradflack.SPAMcom> wrote: Hi There,
I have a table with 3 rows. 1st has the table/column headers, 2nd contains
the column data and the 3rd is where the loop for the SQL statement lies.
I also have a JS sort function on there (which int complete, but thats
another post/story) which sorts the data A-Z or Z-A. The problem i am having
is that the loop row (which isnt visible on the ASP page, as its ASP) is
being sorted as well.
Rather than excluding the row from sorting, i was wondering if i could scrap
it altogether?, but when i try and move the loop out of the row, all the
data goes crazy, all over the shop.
Basically, where can i put the RS.Movenext Loop statement that will still
dsiplay the data still in the same way in my table (rather than the last
row)
I appreciated this is a weird question, if you would like me to post the
code for my table thats fine.
More than fine, probably required. Though it may be a client side
issue.
Jeff
OK, below is the code for the entire table (inc. ASP functions)
If you build it in dreamweaver or something it should show you what its all
about - note the extra row for the end of loop.
Sorry, its alot of code....
*****
<table width="700" align="center" id="dataTable" name="dataTable"cols="8">
<tr>
<td width="279"><a href="javascript : sortTable(0)"><div
align="left"></div><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Manager </strong></font></div></a></td>
<td width="10"><div align="left"><font color="#003399" size="1"
face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td width="88"><a href="javascript : sortTable(2)"><div
align="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Total</strong></font></div></a></td>
<td width="22"><div align="left"><font color="#003399" size="1"
face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td width="15"><font color="#003399" size="1" face="Verdana,
Arial, Helvetica, sans-serif"> </font></td>
<td width="116"><!---<a href="javascript : sortTable(5)">---><div
align="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Income<br>
All Clients </strong></font></div><!---</a>---></td>
<td width="17"><font color="#003399" size="1" face="Verdana,
Arial, Helvetica, sans-serif"> </font></td>
<td width="117"><!---<a href="javascript : sortTable(7)">---><div
align="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Income <br>
New</strong></font></div><!---</a>---></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif">
<%Dim RS, strArea
strArea = Replace(Session("lstArea"),"'","''")
Set RS = DataConnection.Execute("SELECT manager, all_customers, income,
income_new_customers FROM vw_Summary_Area WHERE vw_Summary_Area.Area='" &
strArea & "'")
do until RS.EOF
%>
<a href= "summary_manager.asp?manager=<%=RS("manager")% >">
<% =RS("manager")%>
</a>
</font>
</td>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif"> </font></td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =RS("all_customers")%>
<em></em></font></div></td>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif"> </font></td>
<td> </td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =formatcurrency(RS("income"),2)%>
</font></div></td>
<td> </td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =formatcurrency(RS("income_new_customers"),2)%>
</font></div></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif">
<%RS.MoveNext
Loop%>
</font></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
*****
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me. www.bradflack.com
"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:40**************@msnews.microsoft.com... On Thu, 25 Mar 2004 16:18:03 -0000, "Fawke101"
<gu*@ANTIbradflack.SPAMcom> wrote:
Hi There,
I have a table with 3 rows. 1st has the table/column headers, 2nd
containsthe column data and the 3rd is where the loop for the SQL statement lies.
I also have a JS sort function on there (which int complete, but thats
another post/story) which sorts the data A-Z or Z-A. The problem i am
havingis that the loop row (which isnt visible on the ASP page, as its ASP) is
being sorted as well.
Rather than excluding the row from sorting, i was wondering if i could
scrapit altogether?, but when i try and move the loop out of the row, all the
data goes crazy, all over the shop.
Basically, where can i put the RS.Movenext Loop statement that will still
dsiplay the data still in the same way in my table (rather than the last
row)
I appreciated this is a weird question, if you would like me to post the
code for my table thats fine.
More than fine, probably required. Though it may be a client side
issue.
Jeff
On Thu, 25 Mar 2004 17:14:34 -0000, "Fawke101"
<gu*@ANTIbradflack.SPAMcom> wrote: OK, below is the code for the entire table (inc. ASP functions)
If you build it in dreamweaver or something it should show you what its all
about - note the extra row for the end of loop.
Sorry, its alot of code....
I think the problem is that you have a single table sorted client side
and should have the ASP outside the table. You put the code to create
the recordset and start the loop right in a table cell, which doesn't
make sense to do. I suspect you've used a Javascript sortTable script
similar to the one at:
http://javascript.internet.com/forms...ata-table.html
Which unfortunately isn't written in the example to sort dynamically
derived data.
If it were me, I'd dispense with using DreamWeaver for coding since
you end up with munged code like this, along with extraneous trash
like the "<div align="left"></div>" in your first table cell, which is
absolutley useless code. Proper use of CSS would eliminate 90% of the
HTML in this code snippet as well. Most egregious is 12 lines of code
to create a table row with empty cells except for the first cell
containing the ASP "<%RS.MoveNext Loop%>".
Let's see if we can rewrite some of this code. Comments are in line,
and this replaces your entire code which I left quoted below. Watch
for possible line wrap.
---] Begin Code [---
<!--
Put the normal HTML code for starting the page here, along with
the Javascript block for the sortTable function.
-->
<!--
Use styles for the table header row and data rows, to eliminate
the redundant formatting codes. DreamWeaver does suck at producing
simple clean code.
-->
<style>
TH { color: #004080; font-size: small; font-family: "Verdana, Arial,
Helvetica, sans-serif"; font-weight: bold; }
TD { color: #000000; font-size: normal; font-family: "Verdana, Arial,
Helvetica, sans-serif";}
</style>
<%
' Get your record set before beginning to create the table
Dim RS, strArea
strArea = Replace(Session("lstArea"),"'","''")
Set RS = DataConnection.Execute("SELECT manager, all_customers,
income,
income_new_customers FROM vw_Summary_Area WHERE
vw_Summary_Area.Area='" &
strArea & "'")
%>
<!-- Create the table and header row in HTML -->
<table width="700" align="center" id="dataTable" name="dataTable">
<tr>
<th><a href="javascript: sortTable(0)">Manager</a></th>
<th><a href="javascript: sortTable(2)">Total</a></th>
<th>Income<br>All Clients</th>
<th>Income<br>New</th>
</tr>
<%
' Loop for the data rows within the table
do until RS.EOF
' Assign record set item to variables
strManager = RS("manager")
strAllCustomers = RS("all_customers")
intIncome = formatcurrency(RS("income"),2)
intIncomeNewCustomers = formatcurrency(RS("income_new_customers"),2)
' Build the rows dynamically in ASP
Response.Write "<tr>" & VbCrLf
Response.Write "<td><a href='summary_manager.asp?manager="
Response.Write strManager & ">" & strManager & "</a></td>" & VbCrLf
Response.Write "<td>" & strManager & "</td>" & VbCrLf
Response.Write "<td>" & intIncome & "</td>" & VbCrLf
Response.Write "<td>" & intIncomeNewCustomers & "</td>" & VbCrLf
Response.Write "</tr>" & VbCrLf
RS.MoveNext
Loop
%>
</table>
<!-- Finish up with HTML code to end the page -->
---] End Code [---
Note that I haven't tested this, don't know if it will format
correctly and I may have a typo in here. In otherwords, if your
system explodes in a fireball, it's not my fault you ran this without
checking it. :)
Jeff
*****
<table width="700" align="center" id="dataTable" name="dataTable"cols="8">
<tr>
<td width="279"><a href="javascript: sortTable(0)"><div
align="left"></div><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Manager </strong></font></div></a></td>
<td width="10"><div align="left"><font color="#003399" size="1"
face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td width="88"><a href="javascript: sortTable(2)"><div
align="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Total</strong></font></div></a></td>
<td width="22"><div align="left"><font color="#003399" size="1"
face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td width="15"><font color="#003399" size="1" face="Verdana,
Arial, Helvetica, sans-serif"> </font></td>
<td width="116"><!---<a href="javascript: sortTable(5)">---><div
align="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Income<br>
All Clients </strong></font></div><!---</a>---></td>
<td width="17"><font color="#003399" size="1" face="Verdana,
Arial, Helvetica, sans-serif"> </font></td>
<td width="117"><!---<a href="javascript: sortTable(7)">---><div
align="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Income <br>
New</strong></font></div><!---</a>---></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif">
<%Dim RS, strArea
strArea = Replace(Session("lstArea"),"'","''")
Set RS = DataConnection.Execute("SELECT manager, all_customers, income,
income_new_customers FROM vw_Summary_Area WHERE vw_Summary_Area.Area='" &
strArea & "'")
do until RS.EOF
%>
<a href= "summary_manager.asp?manager=<%=RS("manager")% >">
<% =RS("manager")%>
</a>
</font>
</td>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif"> </font></td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =RS("all_customers")%>
<em></em></font></div></td>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif"> </font></td>
<td> </td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =formatcurrency(RS("income"),2)%>
</font></div></td>
<td> </td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =formatcurrency(RS("income_new_customers"),2)%>
</font></div></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif">
<%RS.MoveNext
Loop%>
</font></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
*****
Yes! Post the code.
"Fawke101" <gu*@ANTIbradflack.SPAMcom> wrote in message
news:Oq**************@TK2MSFTNGP12.phx.gbl... Hi There,
I have a table with 3 rows. 1st has the table/column headers, 2nd contains
the column data and the 3rd is where the loop for the SQL statement lies.
I also have a JS sort function on there (which int complete, but thats
another post/story) which sorts the data A-Z or Z-A. The problem i am
having is that the loop row (which isnt visible on the ASP page, as its ASP) is
being sorted as well.
Rather than excluding the row from sorting, i was wondering if i could
scrap it altogether?, but when i try and move the loop out of the row, all the
data goes crazy, all over the shop.
Basically, where can i put the RS.Movenext Loop statement that will still
dsiplay the data still in the same way in my table (rather than the last
row)
I appreciated this is a weird question, if you would like me to post the
code for my table thats fine.
--
Thanks in advance
Fawke
Please remove ANTI and SPAM
from my email address before emailing me.
www.bradflack.com
OK thanks for that,
All working now.
I have been using DW since i started web development, and i agree. As soon
as you have to start delving around in the code it looks well messy.
I managed to sort it eventually by editing my current code. Rather than
re-writing all my pages.
Thanks however as i will build my ASP apps dynamically in the future. I am
new to ASP so apologies for appearing nieve.
Thanks again
--
Fawke
Please remove ANTI and SPAM
from my email address before emailing me. www.bradflack.com
"Jeff Cochran" <jc*************@naplesgov.com> wrote in message
news:40***************@msnews.microsoft.com... On Thu, 25 Mar 2004 17:14:34 -0000, "Fawke101"
<gu*@ANTIbradflack.SPAMcom> wrote:
OK, below is the code for the entire table (inc. ASP functions)
If you build it in dreamweaver or something it should show you what its
allabout - note the extra row for the end of loop.
Sorry, its alot of code....
I think the problem is that you have a single table sorted client side
and should have the ASP outside the table. You put the code to create
the recordset and start the loop right in a table cell, which doesn't
make sense to do. I suspect you've used a Javascript sortTable script
similar to the one at:
http://javascript.internet.com/forms...ata-table.html
Which unfortunately isn't written in the example to sort dynamically
derived data.
If it were me, I'd dispense with using DreamWeaver for coding since
you end up with munged code like this, along with extraneous trash
like the "<div align="left"></div>" in your first table cell, which is
absolutley useless code. Proper use of CSS would eliminate 90% of the
HTML in this code snippet as well. Most egregious is 12 lines of code
to create a table row with empty cells except for the first cell
containing the ASP "<%RS.MoveNext Loop%>".
Let's see if we can rewrite some of this code. Comments are in line,
and this replaces your entire code which I left quoted below. Watch
for possible line wrap.
---] Begin Code [---
<!--
Put the normal HTML code for starting the page here, along with
the Javascript block for the sortTable function.
-->
<!--
Use styles for the table header row and data rows, to eliminate
the redundant formatting codes. DreamWeaver does suck at producing
simple clean code.
-->
<style>
TH { color: #004080; font-size: small; font-family: "Verdana, Arial,
Helvetica, sans-serif"; font-weight: bold; }
TD { color: #000000; font-size: normal; font-family: "Verdana, Arial,
Helvetica, sans-serif";}
</style>
<%
' Get your record set before beginning to create the table
Dim RS, strArea
strArea = Replace(Session("lstArea"),"'","''")
Set RS = DataConnection.Execute("SELECT manager, all_customers,
income,
income_new_customers FROM vw_Summary_Area WHERE
vw_Summary_Area.Area='" &
strArea & "'")
%>
<!-- Create the table and header row in HTML -->
<table width="700" align="center" id="dataTable" name="dataTable">
<tr>
<th><a href="javascript: sortTable(0)">Manager</a></th>
<th><a href="javascript: sortTable(2)">Total</a></th>
<th>Income<br>All Clients</th>
<th>Income<br>New</th>
</tr>
<%
' Loop for the data rows within the table
do until RS.EOF
' Assign record set item to variables
strManager = RS("manager")
strAllCustomers = RS("all_customers")
intIncome = formatcurrency(RS("income"),2)
intIncomeNewCustomers = formatcurrency(RS("income_new_customers"),2)
' Build the rows dynamically in ASP
Response.Write "<tr>" & VbCrLf
Response.Write "<td><a href='summary_manager.asp?manager="
Response.Write strManager & ">" & strManager & "</a></td>" & VbCrLf
Response.Write "<td>" & strManager & "</td>" & VbCrLf
Response.Write "<td>" & intIncome & "</td>" & VbCrLf
Response.Write "<td>" & intIncomeNewCustomers & "</td>" & VbCrLf
Response.Write "</tr>" & VbCrLf
RS.MoveNext
Loop
%>
</table>
<!-- Finish up with HTML code to end the page -->
---] End Code [---
Note that I haven't tested this, don't know if it will format
correctly and I may have a typo in here. In otherwords, if your
system explodes in a fireball, it's not my fault you ran this without
checking it. :)
Jeff
*****
<table width="700" align="center" id="dataTable"
name="dataTable"cols="8"> <tr>
<td width="279"><a href="javascript: sortTable(0)"><div
align="left"></div><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Manager </strong></font></div></a></td>
<td width="10"><div align="left"><font color="#003399"
size="1"face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td width="88"><a href="javascript: sortTable(2)"><div
align="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Total</strong></font></div></a></td>
<td width="22"><div align="left"><font color="#003399"
size="1"face="Verdana, Arial, Helvetica, sans-serif"></font></div></td>
<td width="15"><font color="#003399" size="1" face="Verdana,
Arial, Helvetica, sans-serif"> </font></td>
<td width="116"><!---<a href="javascript:
sortTable(5)">---><divalign="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Income<br>
All Clients </strong></font></div><!---</a>---></td>
<td width="17"><font color="#003399" size="1" face="Verdana,
Arial, Helvetica, sans-serif"> </font></td>
<td width="117"><!---<a href="javascript:
sortTable(7)">---><divalign="right"><font color="#004080" size="1" face="Verdana, Arial,
Helvetica, sans-serif"><strong>Income <br>
New</strong></font></div><!---</a>---></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif">
<%Dim RS, strArea
strArea = Replace(Session("lstArea"),"'","''")
Set RS = DataConnection.Execute("SELECT manager, all_customers, income,
income_new_customers FROM vw_Summary_Area WHERE vw_Summary_Area.Area='" &
strArea & "'")
do until RS.EOF
%>
<a href= "summary_manager.asp?manager=<%=RS("manager")% >">
<% =RS("manager")%>
</a>
</font>
</td>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif"> </font></td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =RS("all_customers")%>
<em></em></font></div></td>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif"> </font></td>
<td> </td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =formatcurrency(RS("income"),2)%>
</font></div></td>
<td> </td>
<td><div align="right"><font color="#000000" size="2"
face="Verdana, Arial, Helvetica, sans-serif">
<% =formatcurrency(RS("income_new_customers"),2)%>
</font></div></td>
</tr>
<tr>
<td><font color="#000000" size="2" face="Verdana, Arial,
Helvetica, sans-serif">
<%RS.MoveNext
Loop%>
</font></td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
***** This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: jason |
last post by:
Access 2000:
I have a customer-inventory table I need to loop through and compile a list
of all the inventory items the customer is tracking. The problem I am
finding is that a simple loop...
|
by: Jim |
last post by:
Im getting way too many rows retured..what its trying to do is insert
a 0 for revenue for months 7 - 12 (aka July through December) for each
of these cost centers for each payor type..Im getting a...
|
by: ben |
last post by:
i have a bit of code, that works absolutely fine as is, but seems over
complicated/long winded. is there anyway to shorten/simplify it?
the code is below. description of it: it's like strcpy in...
|
by: ssantamariagarcia |
last post by:
I have found a problem while using a while statement and a linked list.
I had never met this matter before....and I am wondering that if you
have , please tell me what it is wrong.
I am...
|
by: Aaron Ackerman |
last post by:
What is the sytax for exiting a for loop in C#?
|
by: Jeremy Wood |
last post by:
Hello everyone;
I'm kind of new to VB and I am currently reading "Microsoft Visual Basic
..NET Step by Step" by Michael Halvorson. It's a great book and has been
very easy to read. The last...
|
by: Frederick Gotham |
last post by:
Is the domestic usage of the C "for" loop inefficient when it comes to
simple incrementation? Here's a very simple program that prints out the
bit-numbers in a byte.
#include <stdio.h>
#include...
|
by: saytri |
last post by:
I have a problem with do while loop. I am displaying a dialogue box where a person should enter the type of quiz he had performed. The problem is that the user should enter only the following 3...
|
by: dp_pearce |
last post by:
I have some code that takes data from an Access database and processes
it into text files for another application. At the moment, I am using
a number of loops that are pretty slow. I am not a...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
