We are running CFM against our Universe DB on AIX. If Excel is working then so should ColdFusion. It looks like a incorrect references in your code. Which Customer# are you selecting? ----------some of our code-----------
<CFSET CustNum = #ID#> <CFQUERY datasource="Eclipse" name="eBalance"> <cftransaction> Select * FROM CUSTOMER WHERE Z_ID = '#CustNum#' </cftransaction> </cfquery> -------------------------------------------- > -----Original Message----- > From: uniVerse mailing list [SMTP:[EMAIL PROTECTED] > Sent: Wednesday, November 10, 2004 4:40 AM > To: [EMAIL PROTECTED] > Subject: [U2] universe and coldfusion compatability? > > Has anyone got coldfusion(mx)v6.1 to work with Universe (v9.6.2.1) or any > version of universe/coldfusion combo? > > We can't get it to access our database so we tried configuring it to > HS.SALES. > With code of > <CFQUERY NAME="cust" DATASOURCE="pcodbc_dsn"> > SELECT * FROM CUSTOMER > </CFQUERY> > > We get the error message of [Macromedia][SequeLink JDBC Driver][ODBC > Socket][Ardent][UVODBC][1401030]Error ID: 27 Severity: ERROR Facility: > DBCAPERR - Line 1, Column 15 (around "CUSTOMER"): SQL Statement referenced > a nonexistent table or view. > > Naturally in excel using the same dsn source it all works hunkydory > > I've seen quite a few similar queries on google and on this list but no > answers or indeed if any posters have ever fixed. > > Ta, > > Andy > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
