Re: cfquery not returning results with apostrophe

thanks, although the problem is there is no error to catch. when we run a cfdump of the query, the sql is as follows: SELECT viewname, categoryname FROM views LEFT OUTER JOIN viewcategories on views.categoryid = viewcategories.categoryid GROUP BY viewname HAVING 0 = 0 AND categoryname IN

Re: cfquery not returning results with apostrophe

thanks for everyones help, its now solved! the reason i am building it through a string is because it is interacting with various extjs grids, which apply filters. i have a generic function that creates the havingclause to filter the data. i ran the havingclause through a loop printing out 1

coldfusion forums?

when i first started using coldfusion (3 years ago) the houseoffusion.com forum really helped. At that time the forum was buzzing and it seemed every minute new posts or replies were going up. i cant help but notice these days it has slowed down, and just wondering what could be the cause of

Re: coldfusion forums?

There may be less traffic but your questions still get answered do they not? yes definitely, just meant as a discussion point, and wondering if i was maybe missing something new :) -- Russ Michaels www.cfmldeveloper.com - Supporting the CF community since 1999 FREE ColdFusion/Railo hosting

Re: saving row order in grid

ExtJS grid ;) The only example i have found in ExtJS is sending the server the index's of the items being dragged (and the item they are being dragged to) and then server code that runs through all other rows adding or minusing their positions. this works great but if i drag an item from row

Re: cfdocument and flashpaper (link to flash if not installed)

does anyone know a way around this? surely cfdocument has some form of support for this? thanks Hi, I am using cfdocument with format flashpaper. however, if users do not have flash installed instead of informing them of this and providing them with a link to download flash, the

Re: cfdocument and flashpaper (link to flash if not installed)

similarly can it detect whether the user had adobe reader installed? thanks Hi, I am using cfdocument with format flashpaper. however, if users do not have flash installed instead of informing them of this and providing them with a link to download flash, the system is showing the

cfspreadsheet dateformat

Hi we have a query that uses dates in format of -mm-dd, however when we place that query into a cfspreadsheet we would like to format those dates into dd/mm/. is there a way to do this within the cfspreadsheet tag? thanks

saving row order in grid

Hi, We have a grid of approx 1000 rows. the users want to be able to drag and drop the items into a specific order. Is there a way you guys would save this in the database with as little code as possible. we thought of having an integer column to store the order value (1,2,3,4,5,etc...),

cfdocument and flashpaper (link to flash if not installed)

Hi, I am using cfdocument with format flashpaper. however, if users do not have flash installed instead of informing them of this and providing them with a link to download flash, the system is showing the download window. is there anyway to inform the user of this problem and provide them

Re: query add row at top of query

thanks to all posts, and thanks Ria, i like this method :) You can refer to this link to appendQuery http://www.bennadel.com/blog/114-ColdFusion-QueryAppend-qOne-qTwo-. htm I guess you should go with method one as of my understanding. Posting example here. appendQuery.cfm cfquery

query add row at top of query

hi i have a query which has sort criteria applied at mysql level. i want to add a row at the top of the query after mysql has finished with it. If i use the queryaddrow method it adds the row to the bottom of the query is there anyway to get it to add it as the first item? thanks

Re: query add row at top of query

thanks, although would that not just overwrite the data in row 1? cfquery name=GetParks datasource=cfdocexamples cachedwithin=#CreateTimeSpan(0, 6, 0, 0)# SELECT PARKNAME, REGION, STATE FROM Parks Where REGION = 'Southeast Region' ORDER BY

logout and back button

hi, i am storing user data in the session scope. when the user logs out it runs a structclear(session) and a cflocation back to the login page. in the application.cfc onrequeststart function it checks if the user information exists in the session and if not runs a cflocation back to the

Re: logout and back button

yes i have scanned alot of the web, and also seen this post although this code does not work. probably out of date as its 3 years old. is this what you use? how do you guys handle this situation? http://www.hunlock. com/blogs/Mastering_The_Back_Button_With_Javascripthttp://www.hunlock.

Re: logout and back button

thanks, getting there, the following works for safari and firefox but doesnt work for ie: cfheader name=cache-control value=no-cache, no-store, must-revalidate cfheader name=pragma value=no-cache cfheader name=expires value=#getHttpTimeString(now())# META HTTP-EQUIV=CACHE-CONTROL

Re: coldfusion equivalent to php json_encode

ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com Richard White wrote: ~| Order the Adobe Coldfusion Anthology now

coldfusion equivalent to php json_encode

hi we have used php in the past with extjs, when validating data on the server, if something fails we pass back the failure by writing: die(json_encode('reason for failure')); it must be encoded for extjs to use it properly however we cannot seem to find an equivalent in coldfusion, we have

cfquery to json array

hi, is there a quick and easy way to convert a cfquery into a json array. i will be returning the json array to extjs to present in a grid thanks ~| Order the Adobe Coldfusion Anthology now!

Re: cfquery to json array

thanks, sorry dont think i was clear enough, i knew about serializejson but this doesnt work with extjs, in case anyone else stumbles on this post and is interested i found the following: http://blog.cutterscrossing.com/index.cfm/CFQueryReader Google is your friend: Search cfquery to json

Re: cfquery to json array

in fact toJson is even better for th job: http://tojson.riaforge.org/ thanks, sorry dont think i was clear enough, i knew about serializejson but this doesnt work with extjs, in case anyone else stumbles on this post and is interested i found the following:

write to start of text file

hi, is there a way to write text to the start of a text file? thanks ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive:

good forums

hi, i have used this forum whilst learning coldfusion and the community is excellent. I have always had answers to my questions within minutes and has really helped. I am currently very new to extjs and attempting to learn it from scratch. Unfortunately there are many questions I have but

Re: CF, Flex and EXTJS

thanks, that is very useful information :) EXTJs, the version that ships with your CF server, is also free to use in production as it is part of your CF Server license. Don't know about Flex in production. On Thu, Mar 18, 2010 at 1:06 PM, Andy Matthews li...@commadelimited.comwrote:

CF, Flex and EXTJS

Hi we used to use dhtmlx for our interface components but found it was very slow. We were pointed to Ext JS and think it is brilliant. However, we are just wondering where flex fitd in. do you guys use flex instead of ext js, or do you combine the two? we would appreciate any general advice

Re: migrating to coldfusion 9

thanks for the replies, like the sound of the speed increase! :) hi, we are starting the process from migrating our coldfusion 8 applications to a coldfusion 9 server. i havent found issues by searching the web, is there anything we should look out for? thanks

migrating to coldfusion 9

hi, we are starting the process from migrating our coldfusion 8 applications to a coldfusion 9 server. i havent found issues by searching the web, is there anything we should look out for? thanks ~| Want to reach the

Re: migrating to coldfusion 9

sounds good, thanks for your feedback. We have started to move some applications to CF9. No real issues as it was a full Flex frontend other then a few of our own mistakes where we may have left something un var scoped. Which while it cause some errors ( fixed in 5 mins ) are good things

coldfusion for medical research

Hi, our company builds software with coldfusion for charitable institutions/universities who store information for medical research purposes. i understand there is a free license for educational purposes but is there a free or discounted license for this scenario? thanks

cfdocument not working in ie

hi we have a cfdocument and works fine in firefox but when trying to view in internet explorer it only shows characters e.g. �[�ˏ ���C��_�y�l�fS�6(������{�(D�.�X�1�������� we have tried in pdf and flashpaper with the same

best uk coldfusion hosting?

hi does anyone know of any good coldfusion and MySQL hosting companies in the uk, that offer coldfusion vps's, and offer 24 hour support? thanks richard ~| Want to reach the ColdFusion community with something they want?

Re: special/reserved characters

thanks for your feedback peter so i dont have to stop users from entering certain characters at all if i am using these functions? i would only have to stop them entering any special characters that we use within our code? thanks A very quick summary... Use cfqueryparam tags to insert

Re: coldfusion to setup iis websites

thanks for the replies! hi, is there a way to setup iis websites directly with cf code? thanks richard ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists

coldfusion to setup iis websites

hi, is there a way to setup iis websites directly with cf code? thanks richard ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

javascript and coldfusion

Hi, we are doing a review of the best javascript components libraries to use with coldfusion, e.g. jquery, extjs, dhtmlx, etc... what are your experiences of the above and others? thanks richard ~| Want to reach the

create datasource in cfm page

hi is there a way to create a data source in a cfm page as opposed to the cf administrator thanks richard ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing

Re: create datasource in cfm page

perfect, thanks! hi is there a way to create a data source in a cfm page as opposed to the cf administrator thanks richard ~| Want to reach the ColdFusion community with something they want? Let them know on the House of

Re: javascript and coldfusion

thanks for all your replies... seems then that extjs is good for ui and jquery for adding functionaility and therefore we should know both :) Hi, we are doing a review of the best javascript components libraries to use with coldfusion, e.g. jquery, extjs, dhtmlx, etc... what are

Re: count array element occurences

thanks for your help richard hi is there a way to count an array/list element occurences e.g. list=1,2,12,12 find occurences for '12' would return '2' thanks ~| Want to reach the ColdFusion community with something they

display wingding character code

Hi, we want to display a wingding character code 252 in coldfusion text, how can we do this? we looked into chr() and other methods but so far no luck thanks for your help richard ~| Want to reach the ColdFusion community

Re: display wingding character code

is there no way to place it in a normal string without having the p tag?. Works in IE8, Chrome, but noe in Firefox. cfoutputp style=font-family: Wingdings;#Chr(252)#/p/cfoutput ? ~| Want to reach the ColdFusion community

count array element occurences

hi is there a way to count an array/list element occurences e.g. list=1,2,12,12 find occurences for '12' would return '2' thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House

Re: display wingding character code

yes, unfortunately doesnt work in ff thanks is there no way to place it in a normal string without having the p tag?. Works in IE8, Chrome, but noe in Firefox. cfoutputp style=font-family: Wingdings;#Chr(252)#/p/cfoutput ?

special/reserved characters

hi, i am having a hard time understanding what characters should be allowed and what shouldnt on data entry, and what effects these will have on coldfusion or mysql processing I would appreciate any help in understanding how you guys deal with this, or what you do ensure clashes do not

compare arrays for same

hi is there a function to compare 2 arrays or lists and return the values that exist in both? i have found plenty they return then difference but not for this case thanks ~| Want to reach the ColdFusion community with

Re: compare arrays for same

neat function! thanks to all posts http://cflib.org/udf/listVenn On Thu, Oct 15, 2009 at 6:05 AM, Richard White rich...@j7is.co.uk wrote: ~| Want to reach the ColdFusion community with something they want? Let them know

cfcontent create file

hi we are using cfcontent and rich text to create a word doc as follows: cfcontent type=application/mswordcfoutput{\rtf1\ansi\ansicpg1252\uc1\deff0\stshfdbch0 etc.../cfoutput however when we run the cfm page it brings up the download option, whereas we want to create the file and store it

Re: cfcontent create file

thanks, that is exactly what we wanted richard ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: cfdocument and td widths

is there an alternative way you guys control the exact cm sizes of cells within a cfdocument thanks Hi, we are trying to create a document to print on A4 and trying to control the sizes of the table cells. we have tried controlling the table with in cm's but has not worked. we have

Re: reading text from images

thanks for your advice, we will take a look into that richard Just saw this on the wire yesterday: http://www.labnol.org/internet/perform-ocr-with-google-docs/10059/ Don't know any more about it than that article, but maybe it's helpful.

cfdocument and td widths

Hi, we are trying to create a document to print on A4 and trying to control the sizes of the table cells. we have tried controlling the table with in cm's but has not worked. we have also set the size of the flashpaper in cms and then tried to control the size of the table in percentages but

Re: reading text from images

Thanks for the link jason, we will try this out i also should have mentioned that the scanned writing is handwritten. a company is just becoming computerised and therefore wants all previous handwritten forms to be transferred to digital. we are sure many of you have faced the same problem

reading text from images

hi is there a way in coldfusion to read/scan the text from an image? if not in coldfusion, is there any other means to do this? thanks richard ~| Want to reach the ColdFusion community with something they want? Let them

Re: javascript / coldfusion ajax communication

thanks, your advice and links are clear to understand... so the best option seems to be encodeuricomponent function in js and urldecode function in cf thanks again hi our client side scripting is in javascript and server side code is coldfusion. our javascript sends string data to

Re: javascript / coldfusion ajax communication

does anyone have ideas? hi our client side scripting is in javascript and server side code is coldfusion. our javascript sends string data to coldfusion via url. what is the best way to encode/escape the javascript strings and decode/unescape them in coldfusion thanks

Re: cf_barcode height not working in Firefox:

-block to the span's style, or setting line-height property, helps. iirc, span, by default, is not a block-level element, and thus uses the line-height of its parent for its height... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 25/09/2009 18:50, Richard White wrote

javascript / coldfusion ajax communication

hi our client side scripting is in javascript and server side code is coldfusion. our javascript sends string data to coldfusion via url. what is the best way to encode/escape the javascript strings and decode/unescape them in coldfusion thanks richard

Re: cf_barcode height not working in Firefox:

style=#Attributes.TextFontBottom##Attributes.TextBottom#/span /cfoutput thanks did you try specifying a fixed width in the span's style? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 28/09/2009 20:42, Richard White wrote

cf_barcode height not working in Firefox:

Hi we are using the tag cf_barcode and although we can change the height in IE it is not changing in firefox. The code that sets the height is as follows (note: attributes.barheight). can anyone spot what could be causing this? span

Applications and constant connection

Hi Our company is looking for a solution to a problem we are sure is very common - We have various documents stored within our application on our internet server - our employees connect to the application to access these documents - the problem is... sometimes our employees are at client sites

Re: cf_barcode height not working in Firefox:

. iirc, span, by default, is not a block-level element, and thus uses the line-height of its parent for its height... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ On 25/09/2009 18:50, Richard White wrote: ~| Want to reach

Re: Applications and constant connection

thanks for your replies the 3G seems the best way to go and found there are now 3G/GPRS USB data cards, so this is a combination of both your suggestions :) thanks for your help Hi Our company is looking for a solution to a problem we are sure is very common - We have various

drop down box

hi we want to have a drop down box on a form that has attribute 'required' and a message that displays if no value is select when the form is submitted however, using cfselect automatically makes the first option selected, but we want the user to physically select an option how can we code

Re: drop down box

thanks for your replies, although the problem with having an empty element or an element saying 'Select one of the following' would cause the required=yes validation not to work as they would still be valid options is there no way to get the required=yes validation to work on these

Re: coldfusion barcode

Hi Phillip, We have tried this function (even copied and pasted your code) but altering the height does not work, do you have this problem? ~| Want to reach the ColdFusion community with something they want? Let them know

Re: drop down box

the entire select works looks like this: cfset lookupOptionsArray = listtoarray(Blood,DNA,Other) / cfselect name=sampleType size=1 multiple=no style=width:200px cfloop index=i from=1 to=#arraylen(lookupOptionsArray)# option value=cfoutput#lookupOptionsArray[i]#/cfoutput

Re: drop down box

thanks Jason, although this doesnt seem to work my end. i copied and pasted the code into the form...the combo is empty at first which is great, but when i click on the submit button without selecting anything in the combo it doesnt show me the message Please select a Sample Type to continue.

Re: drop down box

thanks for both your help, i will continue to work out why this is not working on my system, if it is working your end that it has to be something to do with my code!!! thanks again for your help from the docs: Note: This attribute has no effect if you omit the size attribute or set it to

Re: coldfusion barcode

ok thanks I haven't played with it enough to run into the issue. Sorry. On Tue, Sep 22, 2009 at 10:17 AM, Richard White rich...@j7is.co.uk wrote: Hi Phillip, We have tried this function (even copied and pasted your code) but altering the height does not work, do you have

coldfusion barcode

hi our software needs to have the ability to generate a barcode gif and place it on a document. has anyone done this before, and what is the best method? thanks richard ~| Want to reach the ColdFusion community with

Re: coldfusion barcode

-bottom:2px;margin-top:2px;/span !--- space between individual codes --- /cfloop /div span style=#Attributes.TextFontBottom##Attributes. TextBottom#/span /cfoutput On Fri, Sep 18, 2009 at 6:02 AM, Richard White rich...@j7is.co.uk wrote: hi our software

Re: coldfusion barcode

thanks for all the replies and a few options to think about, this will help us a great deal to make sure we choose the right option hi our software needs to have the ability to generate a barcode gif and place it on a document. has anyone done this before, and what is the best

Re: system security question

thanks claude Do you see any potential security issues with this i.e. sql injection via the email As far as SQL injection is concerned, the risk is pretty low with an Access database, since it cannot process multi-statement SQL command. Unless there are tricks I don't know, all SQL injections

system security question

Hi, We would very much appreciate some expert interegation of the following scenario: An ms access database system is setup within an internal network. It has no internet access or entry. It stores sensitive data. However non-sensitive data is passed to it via an email that is collected by

Re: format time to local

thanks for the help and link Richard White wrote: yes good point, also there will be users in usa eventually starting to use it, have you come across this before or seen how others have dealt with this? http://www.sustainablegis.com/blog/cfg11n/index. cfm?mode=catcatid=162AEDB4-20ED

list from array occurences

hi we need to create a list of the string VarChar i.e. VarChar,VarChar,VarChar the amount of list elements is totally dependant on the length of another array which could change. e.g. if theArray length is 3 then the list would be VarChar,VarChar,VarChar else if theArray length is 5 then the

Re: list from array occurences

thanks for the replies, this works perfectly listVar = left(repeatString(VarChar,, arrayLen(arrayVar)), ((8 * arrayLen(arrayVar)) - 1)); that just creates a list of VarChar,VarChar,VarChar, based on the arrayLen() and then removes the final ,.

format time to local

hi we have a website used in uk. and the server is in usa. when files are modified it is of course displaying the est time. i am using the getfileinfo function to get this data but how can i format it to uk time which is 5 hours ahead? if i try to add five to the hours then of course an hour

Re: format time to local

dateadd worked perfect thanks ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive:

Re: format time to local

yes good point, also there will be users in usa eventually starting to use it, have you come across this before or seen how others have dealt with this? thanks Richard White wrote: we have a website used in uk. and the server is in usa. and does DST kick in the same time in your timezone (tz

monitoring users / access points

Hi we are wondering how you guys deal with monitoring users for a web-based application when the pricing model is based around a per user subscription is there techniques of telling whether someone has passed their username and password to one of their colleagues to use. could the pricing

Re: multiple session instances

found out the reason why the onsessionend was not always getting called - i had structclear(session) in the log out code which causes the onsessionend not to fire: here is a good site that i got all the info from to get it working:

multiple session instances

hi i have been using the following code to analyse sessions: var oSession = createObject(java,coldfusion.runtime.SessionTracker); var mySessions= oSession.getSessionCollection(arguments.appName); i have noticed that sometimes a session has multiple instances. for example if i log in to our

Re: Reading Excel Files with Coldfusion

Chad, have you looked into JExcelAPI (http://jexcelapi.sourceforge.net/), it is fantastic at reading and writing Excel documents. in fact we moved to JExcelAPI because we had so many problems with reading and writing data in Excel. sandra was right that it is due to how excel saves the data

Re: email and encrypt

chad, we do almost exactly the same thing and it works fine, not sure why yours would not. this is how we do it: cfset encryptedEmail = encrypt(email,encryptionKey,encryptionAlgorithm,encryptionEncoding) / cfset emailLink = https://#cgi.HTTP_HOST#/Folder/test.cfm?email=#encryptedEmail#;

Re: email and encrypt

could it be that you only have href=test.cfm as when they receive the email it would not know how to interpret that. you would need the full server path as well right? I have a program that emails a user a link to verify their email. So I thought I would take their email and use encrypt

Re: multiple session instances

right i see, thanks do you know of any supported ways of gathering all the active sessions. i know some have suggested to copy the session into the application scope onsessionstart and remove it onsessionend, however this has caused us problems in the past and doesnt always get deleted.

scheduler problem

hi i have a piece of code that runs fine if i navigate direct to the page when i set it up as a scheduled task it doesnt run even though the scheduler.log is telling me that it executed i have checked that it is pointing to the correct file but cannot seem to work out why the code isn't

Re: scheduler problem

Does your page require any sort of login? thanks ben but no, no login required its just a piece of code that is running. i have also checked the exception logs and no errors are being generated. i even try to save a string to a text file on the very first line just to see if it is firing

Re: scheduler problem

Does your page require any sort of login? thanks for your replies, you was right in the first place ben! although the page didnt need a login, there is code in the application.cfc onRequestStart that routes any request back to the login page if the user is currently not logged in. hence it

Re: Using Ajax to populate checkmarks?

Hi Charlie, yes i remember you were :) i have been meaning to look into jquery but have not yet taken the time. i suppose i really need to as must be getting left behind thanks for the advice, again :) ~| Adobe® ColdFusion®

help with a grey area

hi our clients run tests on patients for research purposes. As part of their data protection they are 'told' to not keep personal identifiers (patient first name, last name, dob etc...) in the same database as their test data. we have created a cf application that uses all cf security we

Re: help with a grey area

thanks for all the replies. i agree that it is easier with this to go with the flow and stay within the guidelines that are set... after all the customer is always right.. and as it was mentioned CYA!!! thanks also for your comments roger, we will look into all these regulations too

Re: Using Ajax to populate checkmarks?

What did you use? Or what *would* you recommend we use. we have built various AJAX applications and have always used JSMX (http://www.lalabird.com/) it is very simple to use and many people recommended it to us when we were first looking

cfzip with password

Hi is there a way to password protect a file that we zip up using cfzip i have searched the internet and found lots of things to do with reading a zip file that has a password on it, but nothing to do with actually setting the password when we zip it up thanks

file permissions

Hi i saw someone discussing the need for file permissions on files that write to the file system, but do not understand this subject well enough to know what to do we have a lot of files in one of our applications that write xml and MS Excel spreadsheets and know that we need to set file

2 applications on one server

hi we are trying to place 2 applications on one vps for the first time and would like some guidance on whether there is anything we need to think about in terms of conflicts etc... basically i am confused as to how this works with 2 application.cfc's each one of the applications should be

Re: 2 applications on one server

the application variables of the other application Richard White wrote: basically i am confused as to how this works with 2 application. cfc's each one of the applications should be totally seperate but how does coldfusion know which application.cfc to use and how come they dont

Re: file permissions

thanks dave, it was actually based on your comments in another post that got me thinking about this it was in a post to do with hacking and you said that the person should look through the site and set permissions on any file that writes to the file system. i also want to make sure that if

Re: cfzip with password

ok thanks will look into it is there a way to password protect a file that we zip up using cfzip i have searched the internet and found lots of things to do with reading a zip file that has a password on it, but nothing to do with actually setting the password when we zip it up

<    1   2   3   4   5   6   7   8   9   10   >