Hi All:
I cannot find what is causing the following error. It is supposed to return counts (e.g.
{"COLUMNS":["SOLICIT","CON
TACT","DEC
EASED","LO
ST"],"DATA
":[[348,38
1,0,0]]})
=================== START ERROR ==========================
===
Detail
[Macromedia][Oracle JDBC Driver][Oracle]ORA-01790: expression must have same datatype as corresponding expression
Extended Info
Tag Context
R:\aihtc\ART_TEST\model\id
ListGenera
tion\idLis
tGeneratio
nDAO.cfc (144)<br>
R:\aihtc\ART_TEST\views\cf
m\exportRe
ports\idLi
stGenerati
on\getSoli
citCount.c
fm (54)<br>
C:\inetpub\wwwroot\MachII\
framework\
ViewContex
t.cfc (107)<br>
C:\inetpub\wwwroot\MachII\
framework\
EventConte
xt.cfc (468)<br>
C:\inetpub\wwwroot\MachII\
framework\
commands\V
iewPageCom
mand.cfc (85)<br>
C:\inetpub\wwwroot\MachII\
framework\
EventHandl
er.cfc (81)<br>
C:\inetpub\wwwroot\MachII\
framework\
RequestHan
dler.cfc (379)<br>
C:\inetpub\wwwroot\MachII\
framework\
RequestHan
dler.cfc (327)<br>
C:\inetpub\wwwroot\MachII\
framework\
RequestHan
dler.cfc (271)<br>
C:\inetpub\wwwroot\MachII\
framework\
RequestHan
dler.cfc (201)<br>
C:\inetpub\wwwroot\MachII\
mach-ii.cf
m (123)<br>
R:\aihtc\ART_TEST\index.cf
m (9)<br>
=================== END ERROR ==========================
===
Here's the trail:
NOTE: Sorry . . . I don't know how to "paste" so that the data scrolls.
1. Clicking on a form (once filled in) - "getSolicitCount.cfm" form below . . .
NOTE: Line 54 is marked.
================= START getSolicitCount.cfm Form ======================
<cfif url.event eq "generateIDLIst">
<cfset db = StructNew() />
<cfset db.dbname = getProperty("dbName")> <!--- getting dbname from machii.xml --->
<cfset db.dbUserName = getProperty("dbUserName")>
<cfset db.dbPassword = getProperty("dbPassword")>
<cfset rootFolder = getProperty("rootFolder")>
<cfset queryToCSV = createObject("component","
#rootFolde
r#.utils.q
ueryToCSV"
).init()/>
<cfoutput>
<cfset idListGenerationObj = createObject("component","
#rootFolde
r#.model.i
dListGener
ation.idLi
stGenerati
onDAO").in
it(db.dbna
me,db.dbUs
erName,db.
dbPassword
)>
</cfoutput>
<cfset getSolicitCount = idListGenerationObj.getIDl
ist(url.ap
pealOrProg
Code,url.i
sSolicit,u
rl.queryID
,url.typeO
fSolicit,u
rl.hiIDObj
,url.from,
url.mailin
gList,url.
contactTyp
e)>
<!--- <cfdump var="#getSolicitCount#"><c
fabort> RETURNS DATA w/ myQuery --->
<cfset columnList = ArraytoList(getSolicitCoun
t.GetColum
nNames())>
<!--- <cfdump var="#columnList#"><cfabor
t> RETURNS COLUMN NAMES --->
<cfset strOutput = queryToCSV.QueryToCSV(
Query=getSolicitCount,
Fields=columnList
<!--- <cfdump var="#strOutput#"><cfabort
> WORKS - COMBINES DATA AND COLUMN NAMES --->
<cfheader name="content-disposition"
value="attachment; filename=contactList.CSV" />
<cfcontent type="text/plain" /><cfoutput>#strOutput#</c
foutput>
<cfelse>
<!--- <cfdump var="#url.event#"><cfabort
> --->
<cfprocessingdirective suppresswhitespace="yes" >
<cfsetting enablecfoutputonly="1" showdebugoutput="0">
<cfcontent type="application/x-javasc
ript">
<cfsilent>
<cfparam name="FORM.appealOrProgCod
e" default="" /> <!--- CHANGED from "appealCode" 4/26/2011 --->
<cfparam name="FORM.isSolicit" default="" />
<cfparam name="FORM.queryID" default="" />
<cfparam name="FORM.typeOfSolicit" default="" />
<cfparam name="FORM.hiIDObj" default="" />
<cfparam name="FORM.from" default="" />
<<<<<<< .mine
<!---<cfdump var="#form#"><cfabort>--->
=======
<!---<cfdump var="#form#"><cfabort> --->
>>>>>>> .r941
<cfset db = StructNew() />
<cfset db.dbname = getProperty("dbName")> <!--- getting dbname from machii.xml --->
<cfset db.dbUserName = getProperty("dbUserName")>
<cfset db.dbPassword = getProperty("dbPassword")>
<cfset rootFolder = getProperty("rootFolder")>
<cfset tmpArray = ArrayNew(1) >
<cfoutput>
<cfset idListGenerationObj = createObject("component","
#rootFolde
r#.model.i
dListGener
ation.idLi
stGenerati
onDAO").in
it(db.dbna
me,db.dbUs
erName,db.
dbPassword
)>
</cfoutput>
LINE 54 <cfset getSolicitCount = idListGenerationObj.getSol
icitCount(
FORM.appea
lOrProgCod
e,FORM.isS
olicit,FOR
M.queryID,
FORM.typeO
fSolicit,F
ORM.hiIDOb
j,FORM.fro
m)>
<!--- <cfdump var="#getSolicitCount#"><c
fabort> --->
<cfset data = serializeJson(getSolicitCo
unt)>
<cfcontent type="application/json" reset="true">
</cfsilent>
<cfoutput>#data# </cfoutput>
</cfprocessingdirective>
</cfif>
====================== END "getSolocitCount.cfm" Form =======================
retSolocitCount.cfm calls the following function (SHOWSTEP4):
==================== START "SHOWSTEP4" FUNCTION ======================
function showStep4(queryID,hiIDObj,
isGenerate
List,from)
document.getElementById('c
ountDetail
sStep4').s
tyle.displ
ay = "block";
document.getElementById('c
ountDetail
sStep5').s
tyle.displ
ay = "block";
if(isGenerateList == 'Yes')
// alert(hiIDObj)
hiIDObj = document.getElementById(hi
IDObj).che
cked
// alert(hiIDObj)
var appealOrProgCode = "";
var typeOfSolicit = "";
var isSolicit = getCheckedValue('isSolicit
YesNoDiv')
if(isSolicit == "Yes") {
var typeOfSolicit = getCheckedValue('typeOfSol
icitations
Div')
//alert(typeOfSolicit)
var isSolicit = getCheckedValue('isSolicit
YesNoDiv')
var appealOrProgCode = document.getElementById('s
olicitYesA
ppealCode'
).value
solicitCountDetails(queryI
D,typeOfSo
licit,appe
alOrProgCo
de,isSolic
it,hiIDObj
,from)
document.cookie = "appealOrProgCode="+docume
nt.getElem
entById('s
olicitYesA
ppealCode'
).value;
document.cookie = "hiIDObj="+hiIDObj;
if (reloadStep4Grid == 0) {
fillmyIDList(queryID,typeO
fSolicit,a
ppealOrPro
gCode,isSo
licit,hiID
Obj,from);
$("#includeMailingList").m
ultiSelect
({ oneOrMoreSelected: '*' });
} else {
$("#list_idListGeneration"
).trigger(
"reloadGri
d");
reloadStep4Grid = 1;
var typeOfSolicit = getCheckedValue('typdOfInf
oNeeded')
var appealOrProgCode = document.getElementById('g
iftAppeals
ProgramDIL
ist1_hdn')
.value
//var appealOrProgCode = document.getElementById('i
ncludeMail
ingList_hd
n').value
var isSolicit = getCheckedValue('isSolicit
YesNoDiv')
;
solicitCountDetails(queryI
D,typeOfSo
licit,appe
alOrProgCo
de,isSolic
it,hiIDObj
,from);
//fillmyIDList(queryID,typ
eOfSolicit
,appealOrP
rogCode,is
Solicit,hi
IDObj,from
);
document.cookie = "appealOrProgCode="+docume
nt.getElem
entById('g
iftAppeals
ProgramDIL
ist1_hdn')
.value;
document.cookie = "hiIDObj="+hiIDObj;
if (reloadStep4Grid == 0) {
fillmyIDList(queryID,typeO
fSolicit,a
ppealOrPro
gCode,isSo
licit,hiID
Obj,from);
$("#includeMailingList").m
ultiSelect
({ oneOrMoreSelected: '*' });
} else {
$("#list_idListGeneration"
).trigger(
"reloadGri
d");
reloadStep4Grid = 1;
if(isGenerateList == 'Yes') {
var mailingList = "xyz";
mailingList = document.getElementById('i
ncludeMail
ingList_hd
n').value
url = "index.cfm?event=generateI
DLIst&quer
yID="+quer
yID+"&type
OfSolicit=
"+typeOfSo
licit+"&ap
pealOrProg
Code="+app
ealOrProgC
ode+"&isSo
licit="+is
Solicit+"&
hiIDObj="+
hiIDObj
+"&from="+from+"&mailingLi
st="+maili
ngList
window.open(url)
function includeHIIDInContactlist(h
iIDObj)
//alert(hiIDObj.checked)
if(hiIDObj.checked)
// alert('Include HiId')
//alert('removeHiID')
function validateAppealCode(fldObj)
var fldValue = fldObj.value;
var fldValuetoText = fldValue.substring(0,5)
if(fldValue.length > 5)
// alert("Appeal code should be max 5 characters")
// document.getElementById('s
olicitYesA
ppealCode'
).value = fldValuetoText
document.getElementById('g
enerateCOu
nt').style
.display = "none";
document.getElementById('i
dMaxLimitE
rrorDispla
y').style.
display = "block";
else if(fldValue.length == 5)
document.getElementById('g
enerateCOu
nt').style
.display = "block";
document.getElementById('i
dMaxLimitE
rrorDispla
