Ask a Question related to Coldfusion Database Access, Design and Development.
-
ferse #1
ColdFusion+cfquery+Oracle+CLOB+"Query of Query"
Error message is:
Query Of Queries runtime error.
Unsupported SQL type "java.sql.Types.CLOB".
My database table:
RESMIGAZETEFIHRISTI:
TARIH NOT NULL DATE
METIN NOT NULL NCLOB
My ColdFusion code is:
<!-- fun -->
<cfquery datasource="yonetim_tr" name="qryResmiGazeteler">
select
METIN
from
RESMIGAZETEFIHRISTI
where
TRUNC(TARIH) >= TRUNC(<cfqueryparam
value="#LSParseDateTime(varibles.tarih)#" cfsqltype="cf_sql_timestamp"/>)
</cfquery>
<!-- error occur on this --->
<cfquery name="qryResmiGazetelerAlt" dbtype="query">
SELECT
METIN
FROM
qryResmiGazeteler
</cfquery>
System Information:
ColdFusion 7.0 MX
Oracle 9i (database character set is Unicode)
How can I resolve this problem?
<cfquery datasource="yonetim_tr" name="qryResmiGazeteler">
select
METIN
from
RESMIGAZETEFIHRISTI
where
TRUNC(TARIH) >= TRUNC(<cfqueryparam
value="#LSParseDateTime(varibles.tarih)#" cfsqltype="cf_sql_date"/>)
</cfquery>
<cfquery name="qryResmiGazetelerAlt" dbtype="query">
SELECT
METIN
FROM
qryResmiGazeteler
</cfquery>
ferse Guest
-
#39052 [NEW]: pdo::query with "show slave/master status"
From: xing at mac dot com Operating system: Linux PHP version: 5.1.6 PHP Bug Type: PDO related Bug description: pdo::query... -
#39052 [Opn->Fbk]: pdo::query with "show slave/master status"
ID: 39052 Updated by: tony2001@php.net Reported By: xing at mac dot com -Status: Open +Status: ... -
Oracle problem - escaping "&" in query
I am having an issue with utilizing the escape clause in CF against an Oracle db. I am trying to select data from a table where the "where" clause... -
long query time, oracle clob data type
I am getting some very long query times (+8 hours) on a very simple query where the fields are not null. This is using ColdFusion MX7, just a... -
cfgrid inside a <cfoutput query="myQuery" group="GROUP">
Is it possible to use a cfgrid inside a cfoutput with a query and a group. When I try do that I get the following error: INVALID_CHARACTER_ERR:...



Reply With Quote

