Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Database Management
Reload this Page

Dreamweaver - ASP Error showing Recordset

Discuss Dreamweaver - ASP Error showing Recordset in the Database Management forum on Dev Shed.
Dreamweaver - ASP Error showing Recordset Database Management forum discussing non-database specific SQL. Structured Query Language was designed to be a robust and standardized language for manipulating relational databases.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old April 8th, 2003, 06:22 AM
sanj sanj is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2003
Posts: 128 sanj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 20 h 29 m 19 sec
Reputation Power: 7
Dreamweaver - ASP Error showing Recordset
Hi,

I have 3 questions,

1. Only show 10 highest records used by the Sums
2. Sort by the Sums
3. Display these in a table

I know I can use the repeat region for 10 records only but would like only display the top 10 records in order of cost (sums).

I have a column that has various 'Cost Codes' from departments, and 6 other columns that data faults, voice faults etc that are summed to create 'Sum', I am not sure whether I have done this correctly,

SELECT appold.`Cost Code`, SUM((appold.`Data Units` + (appold.`Voice Units` + (appold.`Data Faults` + (appold.`Voice Faults` + (appold.Telephone + appold.Survey)))))) AS Sums
FROM appold
GROUP BY appold.`Cost Code`
ORDER BY 1 ASC, appold.`Cost Code` DESC

when I click test in the recordset window I see (what is expected) but not in sort order of the Sums:

0840867001 87
0840867002 1352 etc

but when I drag the 'Cost Code' and 'Sums' to a table and use repeat region, it only shows the last record repeated throughout the table?

Also, I'm not sure of how to create the query for only top ten records.

Regards,

Sanjay
Reply With Quote
  #2  
Old April 8th, 2003, 09:00 AM
swampBoogie swampBoogie is offline
Contributing User
Dev Shed Intermediate (1500 - 1999 posts)
  
Join Date: Jan 2003
Location: Paris Uppland
Posts: 1,923 swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 3 Weeks 1 Day 2 h 52 m 52 sec
Reputation Power: 91
I assume that you are using Mysql

Code:
 SELECT appold.`Cost Code`, SUM(appold.`Data Units` + appold.`Voice Units` + appold.`Data Faults` + appold.`Voice Faults` + appold.Telephone + appold.Survey) AS Sums
FROM appold
GROUP BY appold.`Cost Code`
ORDER BY Sums desc , appold.`Cost Code` DESC limit 10
Reply With Quote
  #3  
Old April 8th, 2003, 09:11 AM
sanj sanj is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2003
Posts: 128 sanj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 20 h 29 m 19 sec
Reputation Power: 7
Thanks SwampBoogie for replying,

No I'm using Dreamweaver ASP VBScript to a Access Database.

Regards,

Sanjay
Reply With Quote
  #4  
Old April 8th, 2003, 11:17 AM
swampBoogie swampBoogie is offline
Contributing User
Dev Shed Intermediate (1500 - 1999 posts)
  
Join Date: Jan 2003
Location: Paris Uppland
Posts: 1,923 swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level)swampBoogie User rank is Second Lieutenant (5000 - 10000 Reputation Level) 
Time spent in forums: 3 Weeks 1 Day 2 h 52 m 52 sec
Reputation Power: 91
Why the ` then?

Code:
SELECT top 10 appold.[Cost Code], SUM(appold.[Data Units] + appold.[Voice Units] + appold.[Data Faults] + appold.[Voice Faults] + appold.Telephone + appold.Survey) AS Sums
FROM appold
GROUP BY appold.[Cost Code]
ORDER BY 2 desc , 1 DESC
Reply With Quote
  #5  
Old April 8th, 2003, 12:43 PM
sanj sanj is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Mar 2003
Posts: 128 sanj User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 20 h 29 m 19 sec
Reputation Power: 7
hey Swampboogie thats cool!

I don't know when you should ' and [] - what's the difference?

Also, I'm using this programme that creates a chart from the SQL query, but I get this error:

Error(-2147217900):[Microsoft][ODBC Microsft Access Driver] Syntax error (missing operator) in query expression...

Have you seen this before?

Thanks again,

Sanjay
Last edited by sanj : April 8th, 2003 at 06:58 PM.
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Database Management > Dreamweaver - ASP Error showing Recordset

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump



 Free IT White Papers!
 
How to Present Effectively Online
This white paper offers practical and actionable advice on the key steps that any presenter should consider as they plan and execute a Webinar or online meeting.
 
Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available to the general public with relaxed or non-existent intellectual property restrictions (or arrangement such as the public domain), and is usually developed with the input of many contributors.
 
Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity management.
 
Scalable, Fault-Tolerant NAS for Oracle - The Next Generation
For several years NAS has been evolving as a storage alternative for Oracle databases, and for good reason: NAS is quite often the simplest, most cost-effective storage approach for Oracle. Learn about the benefits that HP's approach to scalable NAS brings to Oracle environments in this comprehensive white paper.
 
Understanding Web Application Security Challenges
This white paper discusses many common threats and preventive measures for Web application security, and explains what you can do to help protect your organization.
 

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2009 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway. 
Stay green...Green IT