CF MX and Oracle 9i Problem

Çok teşekkürler.
Oyun | Sohbet | Video Sinema | Foto Galeri Eleman | Seni Seviyor

teşekkürler

thanks so much for posting this

> SELECT count(*) FROM tblActivities A
> INNER JOIN
> tblActivityStatus B
> ON
> A.nActivityId=B.nActivityId
> WHERE
> (A.vActivityStatus LIKE 'open' OR A.vActivityStatus LIKE 'new')
> AND
> dplannedenddate<=sysdate
>
> it worked fine in oracle. But when i embedd it in cold fusion i am getting the
> error
> "Complex object types cannot be converted to simple values. "

That error will not be being caused by the query, because it's a CF error,
and there's no CF expressions in the query. All CF is doing with that SQL
is passing it straight to the DB driver; CF itself does not execute any
SQL.

The error should also have highlighted the line of code erroring, and the
exact code it doesn't like (which won't be any of the above).

--
Adam

Hi all,

i wrote this query
SELECT count(*) FROM tblActivities A
INNER JOIN
tblActivityStatus B
ON
A.nActivityId=B.nActivityId
WHERE
(A.vActivityStatus LIKE 'open' OR A.vActivityStatus LIKE 'new')
AND
dplannedenddate<=sysdate

it worked fine in oracle. But when i embedd it in cold fusion i am getting the error
"Complex object types cannot be converted to simple values. "

Hi,

Can you also post your "includes/ChkAdmin.cfm" code too?..

Thanks all for a quick reply


This is the complete code. I have been using different <cfquery> tag for each query then too i am getting the same error.



<cfinclude template="includes/ChkAdmin.cfm">
<cfparam name="marqueeMess" default="Good Morning">

<!---Query to retrieve record of logged in user--->
<cfquery name="qryRec" datasource="#Application.DataSourceName#">
SELECT * FROM tblusers WHERE vQLID like '#Session.QlkId#'
</cfquery>



<cfif login_type EQ "Admin">
<cfquery name="qryRetAllAct" datasource="#Application.DataSourceName#">
SELECT * FROM tblActivities AS A
INNER JOIN
tblActivityStatus AS B
ON
A.nActivityId=B.nActivityId
WHERE
(A.vActivityStatus LIKE 'open' OR vActivityStatus LIKE 'new')
AND
A.dplannedenddate<=#CreateODBCDate(DateFormat(now(),'mm/dd/yyyy'))#
</cfquery>
<cfelse>
<cfquery name="qryRetAllAct" datasource="#Application.DataSourceName#">
SELECT * FROM tblActivities AS A
INNER JOIN
tblActivityStatus AS B
ON
A.nActivityId=B.nActivityId
WHERE
(A.vActivityStatus LIKE 'open' OR vActivityStatus LIKE 'new')
AND
A.dplannedenddate<=#CreateODBCDate(DateFormat(now(),'mm/dd/yyyy'))#
AND
B.vQLID LIKE '#Session.Qlkid#'
</cfquery>
</cfif>






I found that its just because i am executing multiple queries which is not supported in oracle .Is there is any other way around through which i can execute multiple queries apart from storing in another file. As i am using the result of queries and queries are also using the form data.

Plz help its urgent

I get that message a lot. The most frequent reason is that I am missing a comma somewhere.

Without an example of what is failing, it is real hard to offer much advice. Since you are converting from MS SQL Server to Oracle, it could be many things, including things like SQL Server functions that are not compatible with Oracle.

Phil

Hi,

Do you have multiple queries running under a <cfquery> </cfquery> blocks. If so, check whether each statements are separated with ";" (or else) make them as separate queries.