Use

select * from "pedimentos"

instead. You very likely created table with quoted identifier, so you have
to use it everywhere now.

Roman

On 16:53:36 2007-04-14 "Plutarco" <plutarco_gonzalez@...> wrote:
> Hi, I setup Coldfusion MX 7 to use firebird 2.0
> but have this error message
>
> ---------------------------------------------------------------------
> GDS Exception. 335544569. Dynamic SQL Error SQL error code = -204
> Table unknown PEDIMENTOS At line 1, column 15
>
> The error occurred in C:\Inetpub\wwwroot\iON\prueba.cfm: line 1
> Called from C:\Inetpub\wwwroot\iON\prueba.cfm: line 1
> Called from C:\Inetpub\wwwroot\iON\prueba.cfm: line 1
>
> 1 : <cfquery name="test" datasource="pruebas" username="SYSDBA"
> password="masterkey">
> 2 : select * from pedimentos
> 3 : </cfquery>
>
> SQL select * from pedimentos
> DATASOURCE pruebas
> VENDORERRORCODE 335544569
> SQLSTATE HY000
> ---------------------------------------------------------------------
>
> my datasource "pruebas" (DBfirebird= test.ddi) include table
> named "pedimentos" with two fields "trafico" and "pedimento" I check
> this with IBExpert, but i dont understand GDS Exception
>
> anyone can help me
>
> Many thanks
>
> Plutarco
>
> --- In Firebird-Java@yahoogroups.com, "Mike Hickman" <mikehi@...>
> wrote:
> >
> > Thanks to Claus Heeg and Ramon for replying and setting me on the
> > right track.
> >
> > So easy and logical once when the configuration is pointed out.
> >
> > Many thanks
> >
> > Mike Hickman
> >
> > __________________________________________________________________
> > --- In Firebird-Java@yahoogroups.com, "rockxwre" <rockxwre@> wrote:
> > >
> > > Hi Mike,
> > >
> > > Haven't tried it in MX 7 but in MX 6 you could do the following:
> > >
> > > - copy the necessary jars (jaybird-full-2.1.0.jar and maybe
> more) to
> > > \CFusionMX\wwwroot\WEB-INF\lib folder;
> > > - restart ColdFusion;
> > > - go to the ColdFusion Administrator;
> > > - go to Datasources;
> > > - fill in a Data Source Name, choose the Driver "other" and
> > > click "Add";
> > > - a new form appears, fill in JDBC URL, this is something like:
> > > jdbc:firebirdsql://localhost:3050/<path-to-db>
> > > - fill in the Driver Class: org.firebirdsql.jdbc.FBDriver;
> > > - fill in the Username and Password fields;
> > > - click "Submit";
> > > - check if it works by using the Verify button.
> > >
> > > Done!
> > >
> > > Since there are no big differences on this part in MX 7, I
> expect
> > > this should work for you too.
> > >
> > > Bye,
> > > Ramon
> > >
> > > --- In Firebird-Java@yahoogroups.com, "Mike Hickman" <mikehi@>
> > > wrote:
> > > >
> > > > Does anyone have any experience using the Driver with
> Coldfusion
> > > MX 7 ?
> > > >
> > > > I am testing Coldfusion Developer edition for use with
> Firebird 1.5
> > > > database's.
> > > >
> > > > How do I create a datasource or make available a Firebird
> database
> > > to
> > > > a Coldfusion Server?
> > > >
> > > > I have not used drivers in the past so I have no clue as to
> where
> > > to
> > > > start.
> > > >
> > > > I have downloaded the drivers. What do I do next ?
> > > >
> > > > Assistance/hints appreciated
> > > >
> > >
> >
>
>
>
>
>
> Yahoo! Groups Links
>
>
>