Yes, all my values were null, and for some reason one of the values passed
showed more null values than what should have been there. So I changed all the
variable names used in cfgrid tag. Now I don't get any error messages, but I
don't get anything at all. Its just an empty grid. I ran the query in mysql
directly with the values passed from the form, and I get 388 rows returned. I
ran the page with query attribute in cfgrid instead of bind attribute and I get
the right result (except that my header is all screwed up, but I will deal with
it later.). But I don't get any result back with bind attribute, and no errors
in the logs or in the AJAX debug window. I don't even see the query execution
in regular cfdebug output either (but i guess thats because of the way bind
calls my query).
I have attached my code for both the query function and the display function.
Please take a look and tell what is it that I am doing wrong. I don't see
anything wrong.
-------------------------------------------
code for query
============================
<cffunction name="get2" access="remote" returntype="struct" hint="Query
database based on user input">
<cfargument name="lib_id" type="numeric" default="0" required="false">
<cfargument name="e_val" type="numeric" default="0.009999"
required="false">
<cfargument name="b_db" type="string" default=""
required="false">
<cfargument name="seq_name" type="string" default="" required="false">
<cfargument name="seq_desc" type="string" default=""
required="false">
<cfargument name="organism" type="string" default=""
required="false">
<cfargument name="page" type="numeric" required="yes">
<cfargument name="pageSize" type="numeric" required="yes">
<cfargument name="gridsortcolumn" type="string" required="no"
default="">
<cfargument name="gridsortdir" type="string" required="no" default="">
<cfset dbLen = listLen(b_db)>
<cfset orCount = 0>
<cfquery name="q" datasource="#application.dsn#">
SELECT distinct
s.sequenceName,
s.sequenceId,
s.sequenceLen,
b.blastDb,
h.hitDef,
h.hitAccession,
h.hitIdentification,
hs.hspEvalue,
(hs.hspPositive/hs.hspAlignLen)*100 as
'perPositive',
(hs.hspIdentity/hs.hspAlignLen)*100 as
'perIdentity',
hs.hspAlignLen,
hs.hspBitScore
FROM library l
inner join
sequenceInfo s on l.libraryId =
s.libraryId
inner join
blast b on s.sequenceId = b.sequenceId
inner join
hit h on b.blastId = h.blastId
inner join
hsp hs on h.hitId = hs.hitId
WHERE hs.hspEvalue <= #e_val#
and b.orf = 0
and s.deleted = 0
and hs.tophitFlag = 1
<cfif libraryId>
and l.libraryId = #lib_id#
</cfif>
<cfif blastDb.length()>
and (
<cfloop index="idx" list="#b_db#">
<cfset orCount = orCount + 1>
b.blastDb = <cfqueryparam
cfsqltype="cf_sql_varchar" value="#idx#">
<cfif orCount lt dbLen>or</cfif>
</cfloop>
)
</cfif>
<cfif seq_desc.length()>
and h.hitDef like '%#seq_desc#%'
</cfif>
<cfif seq_name.length()>
and s.sequenceName like '%#seq_name#%'
</cfif>
<cfif ARGUMENTS.gridsortcolumn NEQ ""
and ARGUMENTS.gridsortdir NEQ "">
ORDER BY #ARGUMENTS.gridsortcolumn#
#ARGUMENTS.gridsortdir#
</cfif>
</cfquery>
<cfreturn QueryConvertForGrid(q,
ARGUMENTS.page,
ARGUMENTS.pageSize)>
</cffunction>
============================================
code for display function..
====================================
<cffunction name="displaySearchResult" returntype="string" hint="Display Basic
search result">
<cfargument name="lib_id" type="numeric" default="0"
required="false">
<cfargument name="e_val" type="numeric" default="0.009999"
required="false">
<cfargument name="b_db" type="string" default=""
required="false">
<cfargument name="seq_name" type="string" default=""
required="false">
<cfargument name="seq_desc" type="string" default=""
required="false">
<cfargument name="organism" type="string" default=""
required="false">
<cfoutput>
<div class="main_body">
<cfform>
<cfgrid format="html"
width="1024"
pageSize="35"
name="sResult"
colheaderbold="yes"
bind="cfc:search.get2({lib_id},
{e_val},
{b_db},
{seq_name},
{seq_desc},
(organism},
{cfgridpage},
{cfgridpagesize},
{cfgridsortcolumn},
{cfgridsortdirection})"
height="500" striperows="yes"
striperowcolor="##EEEEE6">
<cfgridcolumn name="sequenceName" header="Seq. Name">
<cfgridcolumn name="sequenceId" header="Seq. Id">
<cfgridcolumn name="sequenceLen" header="Seq. Len">
<cfgridcolumn name="blastDb" header="Blast DB">
<cfgridcolumn name="hitDef" header="Hit Def">
<cfgridcolumn name="hitAccession" header="Hit
Accession">
<cfgridcolumn name="hitIdentification" header="Hit
Identity">
<cfgridcolumn name="hspEvalue" header="Evalue">
<cfgridcolumn name="perPositive" header="Positive">
<cfgridcolumn name="perIdentity" header="Identity">
<cfgridcolumn
name="hspAlignLen" header="Match Len">
<cfgridcolumn name="hspBitScore" header="Bit Score">
</cfgrid>
</cfform>
</div>
</cfoutput>
<cfreturn "">
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287098
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
