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 7/16/
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
&g
t; <[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
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 message
>> Ye Wang wrote:
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 w
nt: Tuesday, July 16, 2002 2:43 PM
Subject: Re: CFMX & 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.
>
&g
INT in select statement. 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]>
Sen
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
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
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
SELECT 'GName'=A.Name, 'GCost'=B.Cost
FROM tableA A JOIN tableB B ON A.ID = B.AID WHERE B.AID = 1
Type IV driver doesnt seem to like so
o simple?! I've tried many things
> but cannot 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:
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. http://www.fusionauthority.co
n" <[EMAIL 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
>
> 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.turnk
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
15 matches
Mail list logo
