Re: MD5 in cfm is not correct
CF 7.0.2 gives me the correct output as well. ~| 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:259743 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: date format problem
Are you using cfqueryparam's to query the database? That should fix it as far as I know. If you can only do it with a string containing '/mm/dd' kinda format you can have a look at the SET DATEFORMAT option, assuming you are using MS SQL. You'd probably need SET DATEFORMAT ymd in that case. hi, i am getting a very strange error with the dateformat i get the date out of the database which is a timestamp, i format it to dd/mm/ in order to display on screen i then try to convert it to /mm/dd in order to query the database but i am noticing that if the day is below 12 then it produces the format /dd/mm, if the day is above 12 then it produces the correct format /mm/dd has anyone seen this error or know how i can get around it thanks ~| 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:258199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Sorting a structure more than one time
As Robertson-Ravo, Neil (RX) points out (although the resulting 'sorted' isn't a struct) you are not sorting the original struct. You are just returning a sorted array of keys. I guess you'll need some other way of doing this. From the naming of the keys in your struct it looks as if the data is from a database somehow stored in a struct. Can't you output the resulting query (and do a QoQ for 'extra' sorting?) ~| 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:255966 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Search-function on website
If you used Verity in CF 5, did you use the K2 engine or the VDK engine? The K2 engine is much better in many respects, and if I recall correctly, CFMX 6.x uses K2 instead of VDK. I don't realy recall any specific choice that I made. K2 sounds the most familiar, but that may be because it's used in later versions of CF. If you want to search PDFs using SQL Server's full-text functionality, you can do that with a little work: http://www.adobe.com/support/downloads/detail.jsp?ftpID=2611 Interesting link, I'll look into that. However, I don't know how well that works with large numbers of PDF documents, since I haven't done it myself. If not for the PDF part, I'd unhesitatingly recommend SQL Server full-text indexing over Verity. Well the thing that bugs me the most of the SQL Server full-text search is the fact that it doesn't search on parts of words. I can't really think of a good example in English, but Dutch works just as well (only you don't understand the words): Take these three words that appear in texts of different pages: zetel, zetels, restzetel(s). Now if you search for 'zetel' you are presented with the pages with 'zetel' and 'zetels' if you use a prefix (*) notation in your CONTAINS. However restzetel or restzetels does not come up at all. LIKE '%zetel%' would of course yield all of these results, which is a desired result, but of course I would like a ranking kinda like this: zetel zetels restzetel restzetels. Well.. that being said, I guess I'll have to look into verity again. See if the results are somewhat better this time. Thanks for your response. ~| 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:252174 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Search-function on website
I was wondering if any of you have any thoughts on the implementation of a 'search-function' on a website. It would only be a fairly simple input field and some ranked search results. The website content comes directly from the database btw. So far I've used and come up with some scenario's: * Simple 'LIKE' clause and a query. Works fairly well, however ranking is not really an option and PDFs etc are not searched at all of course. * Full-Text search (MS-SQL 2000). Has some cool features, ranking is great, however only searches on complete words, complete phrases or words starting with a certain prefix. Some of the more advanced options such as FORMSOF, NEAR etc, are not used at all since it's only a simple HTML-input field. * Verity: In short: I hate it. I've worked with it in CF5 and found it to be error-prone, not really maintenance-friendly and giving crappy results. I haven't used it on CF6, so it may have improved (please tell me if it has :-) ). I don't have CF7 (CF6) so the added categorization-functions are not available btw. Now that I think about it, maybe I should give Verity another shot (especially since it searches the PDFs etc as well).. But maybe someone else has a better idea? ~| 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:252045 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Bitwise operators
I would probably have a look at this http://java.sun.com/j2se/1.4.2/docs/api/java/math/BigInteger.html xFlags = createObject( java, java.math.BigInteger ).init( 9223372036854775808 ); That's 2^63 if you didn't quite get that immediately ;-) I dunno this is untested, top of my head code, but I think it should work. The BigInteger has a lot of bit-functions as methods, but you probably need to make all your masks 2^0 ... 2^63 BigIntegers as well to use them. Maybe this helps, I'm not sure whether I'm on the right track answer-wise =) ~| 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:251460 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
What is the use of structFind? (CFMX)
In CFMX 6+: I'm just wondering, is there any reason why I would use structFind( xStruct, 'key' ) over xStruct[key]? or the other way around? ~| 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:250836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: What is the use of structFind? (CFMX)
Neither have I.. I came across structFind in someone elses code. And yes, my guess is it's all the same to Java as well. btw: xStruct[variableWithFieldNameInIt] works just as well and is a little cleaner if you ask me. =) Of couse we could always use the Macromedia Livedoc Examples way (*): --- xStruct[#evaluate( de( #variableWithFieldNameInIt# ))#] --- (*) Sorry this is just a random rant towards the usually overkill on pounds and quotes in their examples. I haven't used StructFind in a while, but one use might be if you're storing the name of the field you want to access in a variable: structFind(xStruct, variableWithFieldNameInIt); Although this ... xStruct['#variableWithFieldNameInIt#'] .. works too, so I dunno. I'd bet my left leg that the compiler treats them both the same. ~| 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:250874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Getting today''''''''''''''''s orders?
*sigh* how about someone fixed that little bug that doubles the amount of quotes every time you post via the form on the site? ~| 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:250559 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Arrays
Either way it's a bug (IMHO). Only checking if a certain element in an array (or array of arrays) exists should by no means expand the array right? Susan, A two dimensional array in CF is actually an array of arrays. Each of the arrays can end up being a differnt size. I think that may be your problem. Kevin Roche ~| 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:248995 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Tag and Attribute Case
Pretty much the same here :-) although I'd go for tbl_lowercase nowadays (or else my collegue would beat me up.. he's bigger than I am). Oh and CFCs are TitleCamelCase. You represent hope for all of us ;) Anyway, on topic, I practice and preach - cf-tags in lowercase, - functions and variables in camelCase() - SQL keywords in UPPERCASE, tablenames and the such in tbl_camelCase I also prefix my variables with there data type (although CF is not typed) like tablename_nID and tablename_sField Mingo. James Holmes wrote: Hey, geek is apparently sexy now ;-) I even wear the shirt that says: SELECT * FROM USERS WHERE CLUE 0 0 rows returned ~| 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:248714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Declaring SQL variables
Assuming you're using MS-SQL (not sure about other DBs), and assuming you're only trying to 'get' the data into the variables: Your variable should start with an '@'. DECLARE @DeletedAreaName VARCHAR(50); DECLARE @DeletedLft INTEGER; DECLARE @DeletedRgt INTEGER; SELECT TOP 1 @DeletedAreaName = SiteAreaName, @DeletedLft = Lft, @DeletedRgt = Rgt FROM directoryLinks WHERE SiteAreaName = '#ARGUMENTS.SiteAreaName#' Oh and I'd use cfqueryparam, but you may have stripped that for the sake of brevity. Auke ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244619 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: CF Declaring SQL variables
Hi Auke, I think this would have worked but I'm getting a CURSOR error: 'VARCHAR' is not a recognized CURSOR option. I've come across this error a few times before and don't really understand it and the way to fix it. Any ideas. I think only CURSORs are allowed names without a leading '@'. Most likely you are declaring your variables like this: DECLARE DeletedAreaName VARCHAR(50); instead of DECLARE @DeletedAreaName VARCHAR(50); Because (I think) you are declaring the variable without the starting '@', MS-SQL assumes it's a cursor, and therefore complains about the VARCHAR that follows it. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244625 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Paste from Word Insanity!
My bet would be the use of different character sets such as ISO-8859-1, UTF-8 etc. Another thing to look at (especially with the amp; quot; en ' signs are the encoding you use to do the post to the 'sister-site'. Apart from some HTMLEditFormat-ing there shouldn't be much replacing that needs to be done with the output from the FCK editor. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244653 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: eday calendar
This seems to be the successor and is available from Adobe Exchange: http://www.adobe.com/cfusion/exchange/index.cfm#view=sn106viewName=Exchange%20Search%20Detailsloc=en_usauthorid=34423092page=0scrollPos=0subcatid=0snid=sn106itemnumber=1extid=1001423catid=0 In case that doesn't work: try searching on 'calendarInfusion' on the Adobe Exchange. GIYF ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244701 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: eday calendar
This seems to be the successor and is available from Adobe Exchange: http://www.adobe.com/cfusion/exchange/index.cfm#view=sn106viewName=Exchange%20Search%20Detailsloc=en_usauthorid=34423092page=0scrollPos=0subcatid=0snid=sn106itemnumber=1extid=1001423catid=0 In case that doesn't work: try searching on 'calendarInfusion' on the Adobe Exchange. GIYF ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:244702 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: host does not offer cf mappings
I am tied to a host who does not offer CF Mappings. They say ColdFusion mappings will not function on our system due to its hybrid architecture. You *could* of course download a CFC to create the mappings anyway :-) http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=22 However I can imagine that they're not gonna like that too much. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243704 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfloop query= bug?
Can we agree that with the code above, the expected output would be: Outside Loop: a = 1 , Inside Loop: a = 1 , a = 1 , a = 1 , a = 1 , a = 1 , Outside Loop: b = 2 , Inside Loop: b = 2 , b = 2 , b = 2 , b = 2 , b = 2 , Outside Loop: c = 3 , Inside Loop: c = 3 , c = 3 , c = 3 , c = 3 , c = 3 , Outside Loop: d = 4 , Inside Loop: d = 4 , d = 4 , d = 4 , d = 4 , d = 4 , Outside Loop: e = 5 , Inside Loop: e = 5 , e = 5 , e = 5 , e = 5 , e = 5 , What do you just think? Actually my output gives just that. (CFMX 7,0,1,116466). CFMX 6 indeed gives the correct currentrow and the wrong values. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243431 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfoutput with groups and a startrow
I'm trying to output a grouped query using a startrow and maxrows. Something like this: table cfoutput query=myQuery startrow=#StartRow# maxrows=10 group=Foo tr td#myQuery.Foo#/td td cfoutput #myQuery.Bar# /cfoutput /td /tr /cfoutput /table I haven't tested this (don't have the time right now), but you may have to put the maxrows attribute in the inner cfoutput / while maintaining the startrow attribute at the outer cfoutput / loop. Hmm thinking about that some more: that wouldn't really work well as it would probably give you a maximum of 10 rows for every 'group'. Starting at row '5' while specifying startrow=11 doesn't make much sense either way I guess. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243413 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfoutputs in fckEditor
I am integrating fckEditor in to my companies product. I have encountered an issue where fckEditor is automaticly inserting cfoutput tags in to the content of the textarea. Do any of you know where this comes from and/or how to disable it? You sure that there aren't any HTMLFormatted (i.e. lt;cfoutputgt;) in the value of the hidden form field that FCKEditor uses? Are there any cfoutput / tags in the value that you extract from your database? ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243414 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Tracking hits/impressions DB design Considerations
If you do not need to keep track of IP addresses and dates, I would go this route. If not, then make sure you have your columns as small as possible and maybe purge the info on a regular basis. If you do need that info you do best to have a table like Jabob proposes anyway. Any inserts into a table you yourself proposed doesn't really do any harm to processing. If you need to do a query that counts the number of hits on that table, that will probably slow down as the table grows. So you can do the count (to determine what to show) on 'Jacobs' table' and have the other info in a separate table. OR just analyze your webserver logfiles for that info later on :-) ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243415 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: cfoutputs in fckEditor
You sure that there aren't any HTMLFormatted (i.e. lt;cfoutputgt;) I was trying to 'HTML-escape' that cfoutput. Maybe I should escape it twice: -- You sure that there aren't any HTMLFormatted (i.e. amp;lt;cfoutputamp;gt;) -- PS if that didn't work it still looks the same, and I look rather dumb. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243416 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: WYSIWYG Editor
Agreed ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243157 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Empty String? Works in two environments but not in the third?
The error is [missing string] java.lang.ClassCastException at coldfusion.runtime.ArgumentCollection .init(ArgumentCollection.java:88) at .. This seems to be an error introduced by a ColdFusion hotfix. http://groups.google.com/group/macromedia.coldfusion.cfml_general_discussion/browse_thread/thread/f969266b1a717134/86a35d9a1385f9bd?lnk=stq=java.lang.ClassCastException+at+coldfusion.runtime.ArgumentCollectionrnum=1hl=en#86a35d9a1385f9bd Haven't read all of it, but it seems to have been fixed by another hotfix. This seems to be fixed in hotfix 2 woohoo! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243011 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54