-
Problem displaying dbColGraph
I`m trying to display a numerical value as a bar chart, but I get the following error:
Microsoft OLE DB Provider for ODBC Drivers error `80040e14`
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression `max(Total Points)`.
/busmktsupp/_database/Market_Intel/market_intel_CRM_total.asp, line 22
My code is as follows:
<html>
<head>
<title>Market Intelligence CRM Sales Tracking</title>
</head>
<body>
<h1 align="center">Market Intelligence CRM Sales Tracking</h1>
<%
Set MyDb = Server.CreateObject("ASPdb.Pro")
MyDb.dbMDB = Server.MapPath("MarketIntel.mdb")
MyDb.dbColor = "7,auto"
MyDb.dbMode = "grid"
MyDb.dbGridTableTag = "CELLSPACING=4"
MyDb.dbGridHideFlds = "1,2"
MyDb.dbImageDir = "../images/"
MyDb.dbColGraph = "MarketIntel,Total Points,400,,bluebar.gif,8;"
MyDb.dbColGraph = "MarketIntel,Total Points,400,20,bluebar.gif,8;"
MyDb.dbStatusBar = "false"
MyDb.dbNavigation = "none"
MyDb.dbSQL = "SELECT * FROM TotalPoints"
MyDb.ASPdbPro
%>
</body>
</html>
The table TotalPoints is a table derived from a Make-Table query which includes 4 fields: CRM Name,Cntract,MonthtoMonth, and Total Points.
Any help as to how to correct this problem?
-
Problem displaying dbColGraph (reply)
I actually only have 1 dbColGraph line in the code (I don`t know how that other one got in there). The Total Points field will display as a number if the dbColGraph line is taken out.
On 10/4/98 6:44:58 PM, Ralph Asbury wrote:
> I`m trying to display a numerical value as a bar chart, but I get the
> following error:
Microsoft OLE DB Provider for ODBC Drivers error
> `80040e14`
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error
> (missing operator) in query expression `max(Total Points)`.
>
/busmktsupp/_database/Market_Intel/market_intel_CRM_total.asp, line 22
>
My code is as follows:
<html>
<head>
<title>Market Intelligence
> CRM Sales Tracking</title>
</head>
<body>
<h1 align="center">Market
> Intelligence CRM Sales Tracking</h1>
<%
Set MyDb =
> Server.CreateObject("ASPdb.Pro")
MyDb.dbMDB =
> Server.MapPath("MarketIntel.mdb")
MyDb.dbColor = "7,auto"
MyDb.dbMode =
> "grid"
MyDb.dbGridTableTag = "CELLSPACING=4"
MyDb.dbGridHideFlds =
> "1,2"
MyDb.dbImageDir = "../images/"
MyDb.dbColGraph = "MarketIntel,Total
> Points,400,,bluebar.gif,8;"
MyDb.dbColGraph = "MarketIntel,Total
> Points,400,20,bluebar.gif,8;"
MyDb.dbStatusBar =
> "false"
MyDb.dbNavigation = "none"
MyDb.dbSQL = "SELECT * FROM
> TotalPoints"
MyDb.ASPdbPro
%>
</body>
</html>
The table TotalPoints
> is a table derived from a Make-Table query which includes 4 fields: CRM
> Name,Cntract,MonthtoMonth, and Total Points.
Any help as to how to
> correct this problem?
-
Problem displaying dbColGraph (reply)
Hi Ralph,
The problem is with your field name having a space in it. It`s screwing up the MAX() function we`re trying to do on that field (for scaling purposes). Rename your field to remove the blank and everything will work.
John
On 10/4/98 6:44:58 PM, Ralph Asbury wrote:
> I`m trying to display a numerical value as a bar chart, but I get the
> following error:
Microsoft OLE DB Provider for ODBC Drivers error
> `80040e14`
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error
> (missing operator) in query expression `max(Total Points)`.
>
/busmktsupp/_database/Market_Intel/market_intel_CRM_total.asp, line 22
>
My code is as follows:
<html>
<head>
<title>Market Intelligence
> CRM Sales Tracking</title>
</head>
<body>
<h1 align="center">Market
> Intelligence CRM Sales Tracking</h1>
<%
Set MyDb =
> Server.CreateObject("ASPdb.Pro")
MyDb.dbMDB =
> Server.MapPath("MarketIntel.mdb")
MyDb.dbColor = "7,auto"
MyDb.dbMode =
> "grid"
MyDb.dbGridTableTag = "CELLSPACING=4"
MyDb.dbGridHideFlds =
> "1,2"
MyDb.dbImageDir = "../images/"
MyDb.dbColGraph = "MarketIntel,Total
> Points,400,,bluebar.gif,8;"
MyDb.dbColGraph = "MarketIntel,Total
> Points,400,20,bluebar.gif,8;"
MyDb.dbStatusBar =
> "false"
MyDb.dbNavigation = "none"
MyDb.dbSQL = "SELECT * FROM
> TotalPoints"
MyDb.ASPdbPro
%>
</body>
</html>
The table TotalPoints
> is a table derived from a Make-Table query which includes 4 fields: CRM
> Name,Cntract,MonthtoMonth, and Total Points.
Any help as to how to
> correct this problem?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|