I would never every uses space in your database Naming Convention. But if u
do want to just put [] around The Cube.
E.g
OPENQUERY([My Cube],
>From Rif
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: 22 November 2000 18:40
To: CF-Talk
Subject: Re: RIF Please read concerning Cube
Looks like you're trying to query a table called "The Cube". In most
RDBMS's, this is not a valid table name. Change it to something like
TheCube or The_Cube.
--
Billy Cravens
[EMAIL PROTECTED]
Edward Peloke wrote:
>
> Rif,
>
> I tried your code and seem to be able to get to the linked server but I
now
> get an error or incorrect syntax near cube.
>
> **********************************
> Error Diagnostic Information
> OLEDB Error Code = 170
>
> Line 3: Incorrect syntax near 'Cube'.
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (2:1) to (2:48).
> *************************************
>
> Here is the mdx statement I want to execute:
> SELECT ({[Measures].[MeasuresLevel].Members}) ON COLUMNS FROM [The Cube]
>
> '* Here is the code generating the error
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <cfquery datasource="The Cube" Name="My Cube">
> set quoted_identifier on
> SELECT o."[Measures].[Unit Sales]" as C, o."[Promotion Media].[Media
> Type].[MEMBER_CAPTION]" AS R
> FROM OPENQUERY(My Cube,
> 'select
> {Measures.[Unit Sales]} on columns,
> order(except([Promotion Media].[Media Type].members,{[Promotion
> Media].[Media Type].[No Media]}),[Measures].[Unit Sales],DESC) on rows
> from Sales)
> ')
>
> as o
> set quoted_identifier off
> </CFQUERY>
> <html>
> <head>
> <title>Untitled</title>
> </head>
> <body>
>
> <table>
> <tr>
> <td>Unit Sales</td>
> <td>Media Type</td>
> </tr>
> <cfoutput query="OLAPTEST">
> <tr>
> <td>#OLAPTEST.C#</td>
> <td>#OLAPTEST.R#</td>
> </tr>
> </cfoutput>
> </table>
>
> </body>
> </html>
>
> Thanks,
> Eddie
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
