Ye,
I am getting a VERY similar error. Did you ever get resolution on this issue?
I can solve my problem by setting up the DataSource in the CFAdmin as ODBC Socket
connection instead of SQLServer... however I was thinking that JDBC is more
efficient... faster etc.
Brian
At 10:53 AM
Kinda weird, but try like so
SELECT A.Name, B.Cost
FROM tableA a
INNER JOIN tableB b
ON (A.ID = B.aID)
WHERE B.aID = 1
Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: Ye Wang [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July
Kinda weird, but try like so
SELECT A.Name, B.Cost
FROM tableA a
INNER JOIN tableB b
ON (A.ID = B.aID)
WHERE B.aID = 1
I don't have an MX machine handy ... curious to know what the error message
was tho... could you post it to the list?
Isaac Dealey
www.turnkey.to
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 2:15 PM
Subject: Re: CFMX SQL - simple query with weird error message
Kinda weird, but try like so
SELECT A.Name, B.Cost
FROM tableA a
INNER JOIN tableB b
ON (A.ID = B.aID)
WHERE B.aID = 1
Ooops! Sorry... nevermind my last post. :)
Isaac Dealey
www.turnkey.to
954-776-0046
__
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
fix it. Can anyone throw some light on this? Thx
-Ye
- Original Message -
From: S. Isaac Dealey [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 2:28 PM
Subject: Re: CFMX SQL - simple query with weird error message
Kinda weird, but try like so
SELECT
Try some like this.. dont think you have specify INNER.. its understood.
IF the Column Names are NAME or COST.. try alias them like below
cfquery name=get_ab datasource=MyDSN
SELECT 'GName'=A.Name, 'GCost'=B.Cost
FROM tableA A JOIN tableB B ON A.ID = B.AID WHERE B.AID = 1
/cfquery
Why do I have a sinking feeling I'm putting my head in a noose here? :)
[Macromedia][SQLServer JDBC Driver]Value can not be converted to
requested type.
Considering this error message and the fact that it's a select statement
where you don't have anything but the single hard-coded (1) being
Ye Wang wrote:
We just installed CFMX on a brand new server, W2k with SQL 2000. Most
CF5 codes worked and no problems with stored procedures so far, except a
few errors on simple queries. One of them was quite weird.
Name : VARCHAR(128)
Cost: real
tableA joins tableB on (tableA.ID =
. Or is this just a JDBC problem. This
message of Value can not be converted to requested type. really confused
me.
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 2:46 PM
Subject: Re: CFMX SQL - simple query with weird error
I didnt see you mention anything about Sum(cost) or what not
in your original post..! all you had was a join and where clause..
-Original Message-
From: Ye Wang [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 3:00 PM
To: CF-Talk
Subject: Re: CFMX SQL - simple query with weird
SQL - simple query with weird error message
Why do I have a sinking feeling I'm putting my head in a noose here? :)
[Macromedia][SQLServer JDBC Driver]Value can not be converted to
requested type.
Considering this error message and the fact that it's a select statement
where you don't
PROTECTED]
Sent: Tuesday, July 16, 2002 2:46 PM
Subject: Re: CFMX SQL - simple query with weird error message
Ye Wang wrote:
We just installed CFMX on a brand new server, W2k with SQL 2000. Most
CF5 codes worked and no problems with stored procedures so far, except
a
few errors on simple
-
From: Joe Eugene [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 3:08 PM
Subject: RE: CFMX SQL - simple query with weird error message
I didnt see you mention anything about Sum(cost) or what not
in your original post..! all you had was a join and where clause
both FLOAT and INT are working, but not REAL.
- Original Message -
From: S. Isaac Dealey [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, July 16, 2002 3:07 PM
Subject: Re: CFMX SQL - simple query with weird error message
Ouch, that would be a bummer... Have you tried
15 matches
Mail list logo
