Ask a Question related to ASP Database, Design and Development.
-
nathan #1
Assistance with SELECT BETWEEN
SELECT area, count(*) * 100/ (select count (*) from traffic) as
[Percent] FROM traffic WHERE datein between "10/1/2003" and
"11/30/2003" GROUP by area
The above SELECT statement work great in query analyzer, but as soon
as i try to use it in an asp page, i get this error:
Microsoft VBScript compilation (0x800A0401) Expected end of statement
First i thought it was the quotes, then a couple of other things, and
well, here i am, throwing myself at the mercy of the masses, any
pushes in the right direction is much appreciated.
nathan Guest
-
#25474 [Bgs]: posting arrays from a select box with multiple select is not working properly
ID: 25474 User updated by: fmuller at cisco dot com -Summary: apache2filter: posting from a multiple select box is not... -
#25474 [Fbk->Opn]: posting arrays from a select box with multiple select is not working properly
ID: 25474 User updated by: fmuller at cisco dot com Reported By: fmuller at cisco dot com -Status: Feedback... -
#25474 [Opn->Fbk]: posting arrays from a select box with multiple select is not working properly
ID: 25474 Updated by: sniper@php.net Reported By: fmuller at cisco dot com -Status: Open +Status: ... -
SQL Assistance - won't select where field is blank.
I'm selecting fields from my main table (ProductData). Each record in that table has a SupplierIndex. There is a field called SubCategory, which... -
SELECT DISTINCT + ORDER BY gives ERROR 145: ORDER BY items mustappear in the select list if SELECT DISTINCT is specified.
Dan, You should be able to do this: SELECT Id, FaxID, ReceivedTime, Pages FROM ( SELECT DISTINCT .Id AS Id, -
TomB #2 Re: Assistance with SELECT BETWEEN
Can you show us your asp code?
Likely it's the quotes around your dates.
"nathan" <n4th4n@hushmail.com> wrote in message
news:908008f8.0311180549.467292ec@posting.google.c om...> SELECT area, count(*) * 100/ (select count (*) from traffic) as
> [Percent] FROM traffic WHERE datein between "10/1/2003" and
> "11/30/2003" GROUP by area
>
> The above SELECT statement work great in query analyzer, but as soon
> as i try to use it in an asp page, i get this error:
>
> Microsoft VBScript compilation (0x800A0401) Expected end of statement
>
> First i thought it was the quotes, then a couple of other things, and
> well, here i am, throwing myself at the mercy of the masses, any
> pushes in the right direction is much appreciated.
TomB Guest
-
n4th4n@hushmail.com #3 Re: Assistance with SELECT BETWEEN
<%
Dim oADOofficer, oRSofficer, sSQLofficer
Dim sHTMLofficer
sHTMLofficer = "<table class=percent><tr><td>"
sSQLofficer = "SELECT officer, count(*) * 100/ (select count (*) from traffic) as [Percent] FROM traffic GROUP by officer"
Set oADOofficer = Server.CreateObject("ADODB.Connection")
oADOofficer.Open "dsn=trafficbranch;uid=sa;"
Set oRSofficer = oADOofficer.Execute(sSQLofficer)
sHTMLofficer = sHTMLofficer & oRSofficer.GetString(,," &n bsp; </td><td>","%</td></tr><tr><td>")
oRSofficer.close
set oRSofficer = nothing
oADOofficer.close
set oADOofficer = nothing
sHTMLofficer = left(sHTMLofficer,len(sHTMLofficer) - 8) & "</table>"
%>
<html><body><%=sHTMLofficer%></body></html>
************************************************** ********************
Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
n4th4n@hushmail.com Guest
-
n4th4n@hushmail.com #4 Re: Assistance with SELECT BETWEEN
Errr, that was the _original_ code, i substituted that select statement for
SELECT area, count(*) * 100/ (select count (*) from traffic) as
[Percent] FROM traffic WHERE datein between "10/1/2003" and
"11/30/2003" GROUP by area
And that didnt seem to want to work
************************************************** ********************
Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
n4th4n@hushmail.com Guest
-
Aaron Bertrand - MVP #5 Re: Assistance with SELECT BETWEEN
> SELECT area, count(*) * 100/ (select count (*) from traffic) as
(1) surround dates in ' not " for SQL Server> [Percent] FROM traffic WHERE datein between "10/1/2003" and
> "11/30/2003" GROUP by area
(2) try to avoid BETWEEN (see [url]http://www.aspfaq.com/2280[/url])
(3) consider using a WITH ROLLUP clause for the total, instead of doing that
huge SELECT COUNT(*) for every group. (e.g. calculate the percentage on the
client.)
Aaron Bertrand - MVP Guest
-
TomB #6 Re: Assistance with SELECT BETWEEN
Can you post your new code. It's saying expected end of statement, so is it
possible you have a line break without a continuation character?
"nathan f" <n4th4n@hushmail.com> wrote in message
news:O7R333drDHA.708@TK2MSFTNGP10.phx.gbl...for> Errr, that was the _original_ code, i substituted that select statementASP.NET resources...>
> SELECT area, count(*) * 100/ (select count (*) from traffic) as
> [Percent] FROM traffic WHERE datein between "10/1/2003" and
> "11/30/2003" GROUP by area
>
> And that didnt seem to want to work
>
> ************************************************** ********************
> Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
> Comprehensive, categorised, searchable collection of links to ASP &
TomB Guest
-
Bob #7 Re: Assistance with SELECT BETWEEN
Try enclosing it in #
Updated:
> SELECT area, count(*) * 100/ (select count (*) from traffic) as
> [Percent] FROM traffic WHERE datein between #10/1/2003# and
> #11/30/2003# GROUP by area
"nathan" <n4th4n@hushmail.com> wrote in message
news:908008f8.0311180549.467292ec@posting.google.c om...> SELECT area, count(*) * 100/ (select count (*) from traffic) as
> [Percent] FROM traffic WHERE datein between "10/1/2003" and
> "11/30/2003" GROUP by area
>
> The above SELECT statement work great in query analyzer, but as soon
> as i try to use it in an asp page, i get this error:
>
> Microsoft VBScript compilation (0x800A0401) Expected end of statement
>
> First i thought it was the quotes, then a couple of other things, and
> well, here i am, throwing myself at the mercy of the masses, any
> pushes in the right direction is much appreciated.
Bob Guest
-
n4th4n@hushmail.com #8 Re: Assistance with SELECT BETWEEN
The single quotes fixed me right up.
You guys are amazing, kings among men.
************************************************** ********************
Sent via Fuzzy Software @ [url]http://www.fuzzysoftware.com/[/url]
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...
n4th4n@hushmail.com Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
