I am having trouble with my search function in Firefox. Works in IE but not in
Firefox.
I am doing a cfdump for form.search and when I do a search and for lets say
"Title" it works fine in IE but then in Firefox i get "Title,search" which
doesnt pull anything.
Any Ideas? Thank You
I have a form.search that outputs for the first page then for pages after that
it sets searchhold as the variable.
<cfparam name="sort_search" default="">
<cfif NOT IsDefined("searchhold")>
<cfquery name="qVideo" datasource="green">
SELECT *
FROM dbo.video
Where tags LIKE <cfqueryparam value="%#form.search#%"
cfsqltype="cf_sql_clob">
OR title LIKE <cfqueryparam value="%#form.search#%"
cfsqltype="cf_sql_clob">
AND show = '2'
</cfquery>
<cfset searchhold = #form.search#>
<cfelseif sort_search is "VideoDate">
<cfquery name="qVideo" datasource="green">
SELECT *
FROM dbo.video
Where tags LIKE <cfqueryparam value="%#searchhold#%"
cfsqltype="cf_sql_clob">
OR title LIKE <cfqueryparam value="%#searchhold#%"
cfsqltype="cf_sql_clob">
AND show = '2'
Order by views desc
</cfquery>
<cfelseif sort_search is "VideoViews">
<cfquery name="qVideo" datasource="green">
SELECT *
FROM dbo.video
Where tags LIKE <cfqueryparam value="%#searchhold#%"
cfsqltype="cf_sql_clob">
OR title LIKE <cfqueryparam value="%#searchhold#%"
cfsqltype="cf_sql_clob">
AND show = '2'
Order by date desc
</cfquery>
<cfelse>
<cfquery name="qVideo" datasource="green">
SELECT *
FROM dbo.video
Where tags LIKE <cfqueryparam value="%#searchhold#%"
cfsqltype="cf_sql_clob">
OR title LIKE <cfqueryparam value="%#searchhold#%"
cfsqltype="cf_sql_clob">
AND show = '2'
</cfquery>
</cfif>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318427
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
