cfmenu styling
I'm trying to style a menu, horizontal style where the top-level menu items have a blue back ground and white text and all sub-menus from there are white background blue text. I am not having any luck, I've looked through many blogs and examples on how to hack that css but have not found a way to do what I am trying to do. If anyone knows of blog or site that has a tutorial on how to do this it would be appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
loop with wddx2cfml in it.
I am looping through a result set that has form data that is wddx encrypted and url encoded. I am getting the following error when looping through the result set. ErrorType: java.lang.ClassCastException with a Diagnostics of 'null null'. For debugging purpuoses I am only returning one record. If I use the cfoutput or cfloop with the query attribute I get the error. If I don't use either of those and just use queryname.field it works. Any ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfform and named anchors
I'm working with cfforms with a format of flash. Is it possible to used named anchors with pages in a tabnavigator or an accordion form group? ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293688 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFML in a string
If you had cfset str=cfmenu name=testcfmenuitem display=Test/cfmenuitem/cfmenu If you just put a cfoutput#str#/cfoutput the menu is not generated but when you look at the source code of the web page, the menu code is in it as cfmenu name=testcfmenuitem display=Test/cfmenuitem/cfmenu. How would you out put that and have cf display the menu? ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288924 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFML in a string
I tried that and I'm still not accomplishing what I want. Here is a link to another post I have that explains what I am trying to do. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:53469 ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfmenu and cfmenuitem error/problem
I'll explain this the best I can. I am experimenting with the cf8 cfmenu and cfmenuitem tags. I use two tables in a database, one for menus and the other menu items. Each menu item has 3 key fields, menuID, itemID, and parentID. Obviously menuID is which menu the item belongs, itemID is just a unique indentifier for the specific item, and parentId is optional. The parentID field would hold the itemID of an item that the specific item belongs to. So think family tree. Ex: Grandpa(top level menu items) has son and daughter (menu items in the grandpa menuitem), daughter has two childer, child1 and child2 (menu items under daughter). Grandpa Son (menuid = grandpa, and parentid is empty) Daughter (menuid = grandpa, and parentid is empty) Child1 (parentid = Daughter) Child2 (parentid = Daughter) I use two functions in a cfc to build the navigation, buildNavBar and buildMenu. This is how it is suppose to work. The buildNavBar function queries the database for the main menus. It outputs the cfmenu tag, and the starts looping through the main menus record set and outputs the opening cfmenuitem tag for the menu. After the cfmenuitem tag I invoke the buildMenu function to build the specific menu. After the invoke I close the cfmenuitem tag. And after the loop the menu is closed (/cfmen). The buildMenu function essentially performs the same way. It has two arguments, mid and iid, mid for menuid and iid for item id. The query that is run can run two different ways. If no itemID is passed to the function. I query the menu items table for all items that have the menu id as their menu id along with an empty parent id (would grab the Son and Daughter values in the example above). If the result returned has a record count I start looping through it. I output the opening menu item tag, then self-call the buildMenu function passing the menu id and the item id of the current item. I then close the cfmenuitem tag. This function would keep calling itself to find any children for a specific item and keep going down until it finds no more children items. As I said that is how it is suppose to work, how ever that is not what is happening. I receive a cfmenuitem must have parent cfmenu or cfmenuitem tag. error. If I modify the functions to build a string, dump the string to the screen, copy and create a new cfm page with the code in string, the menu is build correct. If I comment out the call to the buildMenu function in the buildNavBar function, the main menu items are build fine and the menu displays. The error occurs in the call to the buildMenu function from the buildNavBar function. The two functions are below. Any help/a direction to go would be greatly appreciated. cffunction name=buildNavBar access=public returntype=void output=yes cfinvoke component=components.queries method=getMainMenus returnvariable=mainmenus /cfinvoke cfmenu name=navbar type=horizontal menustyle=height:20px;font-family:Garamond;font-size:15;font-weight:bold; cfoutput query=mainmenus cfmenuitem display=#mainmenus.menu_title# cfinvoke component=components.functions method=buildMenu cfinvokeargument name=menuid value=#mainmenus.menu_id# /cfinvoke /cfmenuitem /cfoutput /cfmenu /cffunction !--- Build Menu --- cffunction name=buildMenu access=public output=yes returntype=void cfargument name=mid type=string required=yes cfargument name=iid type=string required=no default= !--- Call get menu items function --- cfinvoke component=components.queries method=getItems returnvariable=items cfinvokeargument name=mid value=#arguments.mid# cfif trim(arguments.iid) is not cfinvokeargument name=iid value=#arguments.iid# /cfif /cfinvoke cfif items.RecordCount gt 0 cfoutput query=items cfmenuitem display=#items.text# cfinvoke component=components.functions method=buildMenu cfinvokeargument name=mid value=#arguments.mid# cfinvokeargument name=iid value=#items.iid# /cfinvoke /cfmenuitem /cfoutput /cfif /cffunction ~| Get involved in the latest ColdFusion
cfform and preservedata
I have a self submitting form with the preservedata attribute set to true. This form submits twice. Once to retrieve user information (name) when the user tabs off the user id field and the second time when they complete the form. It works like I want it to in Firefox but in IE the retrieved values are not displaying in the corresponding input fields. When retrieving the user's name after the first submit those name values are being lost because of the preservedata attribute taking what was submitted rather then the new values that were retrieved. Any ideas why in IE the new values are not being taken? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283084 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem with pattern attribute on cfinput
I am using a regular expression to validate a field for alpha characters only and spaces. (pattern=[A-Za-z\s]+ If I type leadership1, that will not pass and I will get the prompt that there is an error. If I type L1, I get the prompt that there is an error. However if I type Leasdership1, that passes and I get no prompt. Any ideas? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282364 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Problem with pattern attribute on cfinput
I am using a regular expression to validate a field for alpha characters only and spaces. (pattern=[A-Za-z\s]+ If I type leadership1, that will not pass and I will get the prompt that there is an error. If I type L1, I get the prompt that there is an error. However if I type Leasdership1, that passes and I get no prompt. Any ideas? ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Conditiial form requirements
I am writing a form has a Project Type radio selection. Values being New or Existing. If the Project type is Existing a text field needs to be required with that would contain the existing projects code, if it is a New project that field should not be required. I'm having trouble figuring this one out. ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
getAuthUser() not working
In my application.cfm file I have session management and client management turned on I do not specify the loginstorage so it is using cookies to store login information. With the cflogin tags I call a custom tag I wrote to handle the authentication. I pass it the user name and password received from the login form and if authenticated I use the cfloginuser tag with in the custom tag. I can log in just fine and use the secure section of my site, I can find the cookie set by the cfloginuser tag, but the getAuthUser() function returns an empty string. I have also verified that I am not passing an empty string to the cfloginuser tag for the name attribute. Any ideas? ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfindex
I am trying to run the cfindex tag on a collection that is on a different cf server then where the code is running. All the documentation I see says for the collection attribute but the name of the collection or the fully qualified path. I'm using the default path when creating the collection and then when running the cfindex action=update I'm using the UNC qualified path (\\[server name\[path]\[name of collection]. I get a collection does not exist error. Any Ideas or Thoughts? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269779 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfindex
It does ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
UNC collection path for cfindex
I have code that allows users to upload new files. And when uploaded I have that file added to the collection. Is it possible to index a collection that is on a different server the code executing. Ex: Server 1 has the upload code, and you are uploading to the file/files to Server 2 where the collection is also at. ex code on server 1 cfindex collection=\\server2\collection\[collection name] action=UPDATE type=file key=[path to file (unc)] I have tried several attempts but have not had success. The file gets moved fine using the unc method for the path of the file just no lock with the collection. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269664 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: UNC collection path for cfindex
Our Network admin says it is already running that way. Any other ideas? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269678 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFLDAP and Account Lockout
When using cfldap, does the authentication inherrit a networks security policy. Ex: Account lockout after five invalid log in attemps, etc... ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269500 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
CFGrid data not showing
I have never used cfgrid before, and I have followed the coldfusion mx 7 documentation examples, and I have read through some articles on the macromedias developer community on using cfgrid but I am still having an issue. I'm query test data, and would like to have it editable in the cfgrid. The form gets generated but none of the data returned by the query shows up in the grid. Here is my code. cfquery datasource=test name=list select * from list /cfquery cfform format=flash cfgrid format=flash name=List query=list selectmode=edit /cfgrid /cfform If I do a cfdump of the query I see all the data it is just not showing up in the grid. I'm not sure if i'm missing something or what is going on. If anyone can help I would really appreciate it. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269295 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFGrid data not showing
Couple of stabs in the dark. You might change your query name and/or cfgrid name. Both of them are 'list', which might be causing a conflict. Second, you should name the form. It's optional, but a lot of JS stuff requires it (there's a lot of background JS in cfforms). Third, there's an option in the CFAdmin for displaying flash form errors, and it's off by default. A lot of times you're getting an error but you don't see it (it does show up in the logs, though). On 2/9/07, Michael Beins [EMAIL PROTECTED] wrote: Here is the new code. cfquery datasource=test name=list select * from Email_list /cfquery cfform format=flash name=emaillist cfgrid format=flash name=email query=list selectmode=edit /cfgrid /cfform And I turned on the debugging setting, but no error is showing up. A grid is generated but there is no data in it. It has colomun names and few empty rows. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFGrid data not showing
Oops, I don't know why I didn't see this before...you need to add your columns using cfgridcolumn. http://cfquickdocs.com/?getDoc=cfgridcolumn They go between your cfgrid tags. On 2/9/07, Michael Beins [EMAIL PROTECTED] wrote: Technically you don't you have to. If you specify just the query attribute in the cfgrid tag, and no cfgridcolumns it defaults to creating a column for column in the result set of the query. I also did try useng the cfgridcolumn but still no data is present in the grid. It shows the correct format. Just none of the data that you see when you do a cfdump of the result shows in the grid. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFGrid data not showing
Technically you don't you have to. If you specify just the query attribute in the cfgrid tag, and no cfgridcolumns it defaults to creating a column for column in the result set of the query. Hmm, didn't know that. Still stabbing in the dark...maybe you need to select real columns in your query, instead of 'select * from'? If that still doesn't work, you should look in your CF logs to see if you find any errors. I can't remember which log, but I've found flash form errors in one log one day, and then in another one another day. Kind of off topic, there are a lot of really cool examples and articles on flash forms at this site: http://www.asfusion.com/ -- My Sites: Finally figured it out the help of our admin. The problem was the mapping to CFIDE folder. The mapping was wrong and therefore could not find all of the proper files. Hence not working correctly but also not creating an error. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Query of Query Error
In my code I am running two cfsearches. The results from the second search need to appear at the top of the results from the first search. So I append them to the first set and manually set the score and the rank so can force the results to the top in a query of a query. That is where I am getting the error, but it only happens at certain times. The query of the query is a basic query, select * from sResults order by Score desc, Rank desc. In my search I can search for wage cost, ââ¬Ålabor marketââ¬Â, or wager and it works just fine, if I try searching for wage, wages, or labor it bombs. The error I get is java.lang.ClassCastException which the line it is on is the beginning line of query of the query. If I take the sort by Rank desc everything works, but then my results are not quite the way I would like them. cfsearch collection=collection1 name=sResults criteria=#client.criteria# categorytree=#variables.cattree# status=info cfsearch collection=collection2 name=sResults2 criteria=#client.criteria# status=info2 cfif sResults2.RecordCount gt 0 cfset rrank = sResults.RecordCount + 1 cfoutput query=sResults2 cfset temp = QueryAddRow(sResults) cfset temp = QuerySetCell(sResults, KEY, expandpath(sResults2.Custom1)) cfset temp = QuerySetCell(sResults, Rank, variables.rrank) cfset temp = QuerySetCelL(sResults, Score, 1.) cfset temp = QuerySetCell(sResults, Summary, sResults2.Summary) cfset temp = QuerySetCell(sResults, Title, sResults2.Title) cfset temp = QuerySetCell(sResults, URL, sResults2.Custom1) cfset temp = QuerySetCell(sResults, Custom1, sResults2.Key) cfset rrank = rrank + 1 /cfoutput /cfif cfif sResults.RecordCount gt 0 cfquery dbtype=query name=results select * from sResults order by Score desc, Rank desc /cfquery cfwddx action=CFML2WDDX input=#results# output=client.qoqResults /cfif ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Resolved: Query of Query Error
This issue has been resolved, thanks everyone for your help. In my code I am running two cfsearches. The results from the second search need to appear at the top of the results from the first search. So I append them to the first set and manually set the score and the rank so can force the results to the top in a query of a query. That is where I am getting the error, but it only happens at certain times. The query of the query is a basic query, select * from sResults order by Score desc, Rank desc. In my search I can search for wage cost, ââ¬Ålabor marketââ¬?, or wager and it works just fine, if I try searching for wage, wages, or labor it bombs. The error I get is java.lang.ClassCastException which the line it is on is the beginning line of query of the query. If I take the sort by Rank desc everything works, but then my results are not quite the way I would like them. cfsearch collection=collection1 name=sResults criteria=#client.criteria# categorytree=#variables.cattree# status=info cfsearch collection=collection2 name=sResults2 criteria=#client.criteria# status=info2 cfif sResults2.RecordCount gt 0 cfset rrank = sResults.RecordCount + 1 cfoutput query=sResults2 cfset temp = QueryAddRow(sResults) cfset temp = QuerySetCell(sResults, KEY, expandpath(sResults2. Custom1)) cfset temp = QuerySetCell(sResults, Rank, variables.rrank) cfset temp = QuerySetCelL(sResults, Score, 1.) cfset temp = QuerySetCell(sResults, Summary, sResults2.Summary) cfset temp = QuerySetCell(sResults, Title, sResults2.Title) cfset temp = QuerySetCell(sResults, URL, sResults2.Custom1) cfset temp = QuerySetCell(sResults, Custom1, sResults2.Key) cfset rrank = rrank + 1 /cfoutput /cfif cfif sResults.RecordCount gt 0 cfquery dbtype=query name=results select * from sResults order by Score desc, Rank desc /cfquery cfwddx action=CFML2WDDX input=#results# output=client. qoqResults /cfif ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260241 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query of Query Error
Thank you Ben, that solved my problem as far as I know. Try this to take care of data casting issues: http://www.bennadel.com/index.cfm?dax=blog:237.view When setting the score set the value using JavaCast( float, 1. ). Hope that helps. .. Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -Original Message- From: Michael Beins [mailto:[EMAIL PROTECTED] Sent: Monday, November 13, 2006 7:46 AM To: CF-Talk Subject: Query of Query Error In my code I am running two cfsearches. The results from the second search need to appear at the top of the results from the first search. So I append them to the first set and manually set the score and the rank so can force the results to the top in a query of a query. That is where I am getting the error, but it only happens at certain times. The query of the query is a basic query, select * from sResults order by Score desc, Rank desc. In my search I can search for wage cost, ââ'¬Ålabor marketââ'¬?, or wager and it works just fine, if I try searching for wage, wages, or labor it bombs. The error I get is java.lang.ClassCastException which the line it is on is the beginning line of query of the query. If I take the sort by Rank desc everything works, but then my results are not quite the way I would like them. cfsearch collection=collection1 name=sResults criteria=#client.criteria# categorytree=#variables.cattree# status=info cfsearch collection=collection2 name=sResults2 criteria=#client.criteria# status=info2 cfif sResults2.RecordCount gt 0 cfset rrank = sResults.RecordCount + 1 cfoutput query=sResults2 cfset temp = QueryAddRow(sResults) cfset temp = QuerySetCell(sResults, KEY, expandpath(sResults2. Custom1)) cfset temp = QuerySetCell(sResults, Rank, variables.rrank) cfset temp = QuerySetCelL(sResults, Score, 1.) cfset temp = QuerySetCell(sResults, Summary, sResults2.Summary) cfset temp = QuerySetCell(sResults, Title, sResults2.Title) cfset temp = QuerySetCell(sResults, URL, sResults2.Custom1) cfset temp = QuerySetCell(sResults, Custom1, sResults2.Key) cfset rrank = rrank + 1 /cfoutput /cfif cfif sResults.RecordCount gt 0 cfquery dbtype=query name=results select * from sResults order by Score desc, Rank desc /cfquery cfwddx action=CFML2WDDX input=#results# output=client. qoqResults /cfif ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260240 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
