Re: variables.instance vs cfproperty in beans

thanks alot dave, just to clarify, will any variables defined with the cfproperty tag automatically be private to the cfcomponent,just like function arguments are private just to that function? thanks we are creating beans and have noticed in tutorials that some The CFPROPERTY tag doesn't

Re: variables.instance vs cfproperty in beans

ok got ya, thanks dave richard just to clarify, will any variables defined with the cfproperty tag automatically be private to the cfcomponent,just like function arguments are private just to that function? No. The CFPROPERTY tag doesn't define variables, it documents them. If you have a

Re: CFC and MG2 where does validation fit in?

thanks jaime. wow i didnt even know about cfcdev but looks amazing :) thanks again richard Richard, There was a ton of discussion on this just recently - maybe on CFCDEV - so there might be a bit of validation fatigue out there. On the upside, you should find rich pickings in the list

xml include not working

hi, i am trying to include one xml file into another can anyone tell me what i am doing wrong please: event-handlers include template=/re_base_mg/config/event_handlers/MainControllerEventHandlers.xml / /event-handlers i am getting no errors but when i run the

Re: xml include not working

hi, i have just joined the model glue group, thanks for the link also i tried your suggestion dan but also didnt work unfortunately :( thanks for your responses richard Richard, It is not an event handler so should not go in that section - try it right under your opening modelglue Dan

mac address and additional protection

hi we have a debate that we need some expert advice on!!! our software is going to be used by university institutions. when tailoring the package we want to limit it to a certain amount of users. however there is nothing stopping them from creating a login and providing that same login to

Re: CFC and MG2 where does validation fit in?

hi, does anyone have any ideas on this? thanks richard Hi we have hit a little sticking point with CFC's and model glue 2. we have an object named subject. we have created a DAO to handle single record db work and a GW to handle all multiple record db work. we also have a service

Re: mac address and additional protection

really good points, thanks your right its just a matter of us monitoring it and getting the internal software to flag us if anything is happening thanks for the replies hi we have a debate that we need some expert advice on!!! our software is going to be used by university institutions.

Re: cfc scenario help

thanks Nathan, the way you explained it is so understandable. very much appreciated and glad to know we are on the right track :) Hey richard, I think it sounds like you're doing a good job so far. What I would do from here is, in your test object, add a getProjects() method and in the

CFC and MG2 where does validation fit in?

Hi we have hit a little sticking point with CFC's and model glue 2. we have an object named subject. we have created a DAO to handle single record db work and a GW to handle all multiple record db work. we also have a service cfc to handle the DAO and GW CFC's. we also have a controller for

Re: fusebox vs model glue

hi, apologies for the delayed thanks! - but thanks very much there are some excellent points here and really made me understand. seeing as we are doing everything to understand OO and change our applications into OO it sounds like we should stick with it - it is really helping us understand

making functions global in model glue

hi i am making my first model glue application and just want to know if i have got the following right: i want to make my reusable functions (e.g. cflib functions arrayconcat etc...) global to all of my cfc's so that i can access them at any time. am i right in thinking that i would create a

Re: making functions global in model glue

thanks very much, i am actually using model glue 2, yet we are only just starting to use it - would you recommend that we start leaning model glue 3 - is there many changes and also benefits? thanks for your help richard Joe added a helpers scope in MG 3 to make it easier to work with UDF

Re: making functions global in model glue

, no one would be hurt. On Fri, Sep 5, 2008 at 1:42 PM, Richard White [EMAIL PROTECTED] wrote: thanks very much, i am actually using model glue 2, yet we are only just starting to use it - would you recommend that we start leaning model glue 3 - is there many changes and also benefits

cfc scenario help

Hi, we have been doing alot of work on understanding OO development using CFC's and model glue. we have one issue that we don't quite understand and hope someone can help to simplify the problem: we have 2 objects: projects, and tests we have ensured that each of these objects have a DAO cfc

Re: Query of Queries error

i had a similar problem and turned out to be that one of the values in the order by clause was empty - cf seems to mistake it for a empty string and therefore was producing the same error you are experiencing... check all values in the problem column to ensure there are no empty values i also

Re: making functions global in model glue

excellent, thanks for your help ray richard Sure, I've done that before. I'll have a util.cfc that others CFCs use for misc crap. -- === Raymond Camden, VP of Software Dev, Broadchoice Email : [EMAIL PROTECTED] Blog :

fusebox vs model glue

hi we have just reviewed model glue, and have also looked into fusebox very briefly is fusebox similiar to model glue? and if so is it a case of using one or the other? and if so then what are your feelings on which one is better? thanks for your help richard

jxl borders and border styles

Hi i am trying to format an excel file using jxl api however i cannot seem to work out how to set the borders and border styles. i know it is possible as they are available in the jxl.format library but cannot work out how to apply them to a cell i want to set a border to think and dark blue

cfeclipse firefox interface browser

Hi we have tried to make the internal built in browser in cfeclipse to firefox 3 but it doesnt change, it always uses IE as the built in web browser. we have tried this by going to windows -- preference -- general -- web browser -- then check firefox or windows -- preference -- cfeclipse

cfeclipse and ftp

Hi we are just making the move from dreamweaver to cfeclipse and think its great!!! except the ftp doesnt seem to be as straight forward as it is in dreamweaver! we have seen that there are various ways of uploading files to our site but none of them seem to work through our cfeclipse and

Re: cfeclipse and ftp

thanks for your feedback, seems really strange that it is now on version 3.3 and people are still having problems with ftp - which i would be sure would be a fundamental feature in an application like this. well we will still be using dreamweaver for developing our interfaces as it has all the

Re: jsmx and progress bar

hi does anyone have any ideas on how to achieve this? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j

Re: jsmx and progress bar

? For loading content? For users RSVPing? Richard White wrote: hi does anyone have any ideas on how to achieve this? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get

Re: jsmx and progress bar

Hi Josh we are doing something very complex actually that has so many different things that could effect the time it takes. jsmx only passes back information when it is done but if we could get it to pass back at various stages in the cycle then it would be perfect we are generating a

Re: jsmx and progress bar

very good point about the estimated time being better than nothing. i haven't read anything anywhere else that suggests how to do this, and also as suggested cfflush may not be the right option for this scenario, so until something else is available then i think your option may be best josh

best way to get this data out of query

hi i have a query of a query which has the columns: subjectID, testOccasionID, and x amount of columns additional that i will not always know what they are named i need to be able to query this as follows: only return those rows where the subject has more than 1 test occasion thats the first

Re: simple select query not working

thanks for all your help ben nadal managed to identify the problem as being the column types and using the following casting worked fine: CAST(qu_82_tb_89_split_0_split_T_Ht AS DECIMAL) = CAST(142.2 AS DECIMAL) ~| Adobe®

simple select query not working

hi i have a query in cf and want to run another very simple query on it and for some reason it is not getting the data that i know is in there: first i am running this query (i am using query of query for these queries): select qu_80_tb_89_split_0_split_T_Wt from mergedColumnsQuery where

Re: simple select query not working

yes i have dumped out the query named mergedColumnsQuery just before i run the cfquery select statement on that query and it does contain a row with the data that i am trying to select would it have anything to do with column types? thanks Hmmm... if it is a query of query, then you are

Re: simple select query not working

hi brad, even if i leave out that column and just add the select statement: select qu_80_tb_89_split_0_split_T_Wt from mergedColumnsQuery where subjectID = 447 and projectID = 36 and testOccasionID = 2 and qu_82_tb_89_split_0_split_T_Ht = 142.2; it still doesnt find the row - and just before i

Re: simple select query not working

thanks Qing, getting there now!!! after what you said i commented them out one by one and it only fails when it gets to the last column which is: and qu_82_tb_89_split_0_split_T_Ht = 142.2; so i then used a function i got from cflibs called queryColumnTypes and found that the column is a

Re: simple select query not working

sees a better way of doing this and that this may be unreliable i will appreciate it, as i dont know how else to compare an integer column with no data? thanks Richard White wrote: yes i have dumped out the query named mergedColumnsQuery just before i run the cfquery select statement

Re: simple select query not working

Try: LEN(RTRIM(LTRIM(my_integer_column))) = 0 thanks ill use this ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j

Re: simple select query not working

thanks for your help anyway Qing, i cannot work this out either, i cannot see why the first one would work but not the second thanks Wow. That is wild! I have never experienced where a column is one data type in a SQL server table and then changed to something else after CF pulls it...

Re: simple select query not working

dont know if it may apply but to get that column i did a left join with another query and then from that query i did a union with another query so i will backtrack through all of these to see at what point it is changed and see where i can fix it thanks

Re: simple select query not working

i tried changing all the columns to data types of varchar and then to query this data by surrounding the where clause data with '' and this now produces an error saying: Error casting an object of type to an incompatible type. This usually indicates a programming error in Java, although it

cflayoutarea 'oncollapse' event?

hi, we have an interface that uses cflayout and cflayout areas tags that splits the interface into 2 sections. we need to run some code when the user clicks the collapse button '' that collapses the left section. does anyone know how we can do this, such as an event handler thanks

jsmx and progress bar

hi, does anyone know if there is a progress bar that can be used with jsmx thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: left outer join on query of query function

Not necessarily. How many records are in joinQuery? It should just have one, empty record. The point of the first query is to get the columns, but not to select any records; the empty record is created directly below it. oh yes your right joinquery shouldnt have any records basically i am trying

query of query timing out

hi is there any reason why a basic query of query with only if statements and no loops would make the jrun processor shoot up and for it to eventually time out thanks ~| Adobe® ColdFusion® 8 software 8 is the most important

Re: query of query timing out

hi is there any reason why a basic query of query with only if statements and no loops would make the jrun processor shoot up and for it to eventually time out thanks this is the code: cfquery name=newQuery dbtype=query select query.subjectID cfif queryType neq subject

Re: query of query timing out

i have noticed that if i run the query without the line: mergedColumnsQuery.#currentColumn# and if i dont add the mergedColumnsQuery query onto the from line then it works fine but when i add these then it actually doesnt even time it, it just keeps on loading the page and doesnt ever stop and

Re: query of query timing out

thanks Jochem, no wonder is was timing out!!! thanks for spotting that Richard White wrote: cfquery name=newQuery dbtype=query select query.subjectID ,mergedColumnsQuery.#currentColumn# from query, mergedColumnsQuery /cfabort This is an unconstrained / cartesian join. Make

Re: query of query timing out

i am getting the exact same problem with the following query but cannot see why it is taking so long and what is missing - would also appreciate your help with this one: cfquery name= dbtype=query select

Re: query of query timing out

ok thanks brad, i have taken it out of the from list, you learn something new everyday i hadnt realised that by putting that in there that it would think that i am joining it, even if i had not specified any columns from that query but would still attempt to join it. to be honest i thought i

Re: query of query timing out

your right, i wish they would support so much more in QoQ. i have read that it was not meant to be used in the way that so many people are now trying to use it. but i hope they realise that they have started the need for something that can really help people out and they should really satisfy

Re: left outer join on query of query function

ok im getting there and have narrowed it down to 1 more problem - i hope!! the problem is coming from the second part of the union where i am trying to find the rows that are eliminated in the first inner join part this problem only stems from the fact that i have more than 1 primary key if i

Re: left outer join on query of query function

Hi Brad, i thought that would work but not producing the result as expected, it still returns no rows on 2 queries where i know queryb has 15 rows that are not in querya therefore it should be returning those 15 but is not thanks This is off the top of head, but what if you did: where not

Re: left outer join on query of query function

thanks for the description brad, yes sorry i wrote it wrong they do exists in query a and not in query b so i want to find those that exist in querya and not in query b. however your example is quite detailed and shows that the 'where not ()' clause should do the trick so there must be

Re: left outer join on query of query function

thanks brad no i hadn't omitted them for simplicity, i will try that as well then thanks again you have been really helpful, will let you know what happens Ok, good luck. Note: I had to fiddle a little bit for my example to work. For instance, there needed to be () around the output of the

Re: left outer join on query of query function

actually just looked at my real example and i do have the brackets!!! i think tiredness is getting me now, ill stop till tomorrow and try again, i find sometimes just taking my mind away from it makes it easier when i come back thanks again richard thanks brad no i hadn't omitted them for

Re: left outer join on query of query function

i see, thanks for your help dave, i am actually trying to do this on more than 1 primary key and it is not producing any errors when i add the joinquery.* but it is producing 2 times more rows than i expect, so it must be me missing a where clause somewhere. seeing as you also indicate this

left outer join on query of query function

hi, i have been following the following link that discusses how to do a left outer join on a query of query: http://www.bealearts.co.uk/blog/2007/06/20/how-to-do-an-outer-join-in-query-of-queries/ this is the code that is meant to do it: cfquery name=”joinQuery” dbtype=”query”

Re: left outer join on query of query function

thanks Dave, i basically have just copied and pasted the code from the link i pasted above: do you have any idea how to rectify this or even if this would work. the guy indicates that his code is the finished product but now that credibility is lost, so just wondering whether you think it is

JExcelAPI and grouping

hi we are using the JExcelAPI to populate a spreadsheet and wondering if anyone knows how to group rows using the group and outline function in ms excel through the JExcelAPI. thanks richard ~| Adobe® ColdFusion® 8

cfquery function to do this?

Hi i have a query in coldfusion and one of the columns has a list of data: for example col1 col2 - 1 0,1,2,3 2 1,6,7 i want to run a query where i pass it a list and it returns any row that has any item in that list for example i want to run a query that

Re: cfquery function to do this?

hi matt this is a good idea, shame about the leading and trailing commas though this would prove to be a pain, until i can find another solution i will do the loop and use the list find though thanks for your help I had something like this once upon a time. I think I had to manipulate the

Re: cfquery function to do this?

lol, yes it would be if this was a format in the database, in fact i would need to be sacked as well :) - its something built up through coldfusion and i'm storing all the data in a query so i can run various query of query select statements to filter out various information - which is much

null pointer? need your expertise!

Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or

very basic query error???

Hi i have this very simple line of code that i am trying to run in a query of query: select * from query where T_Site like '%,1,%' but i am getting the error: Encountered T_Site. Incorrect conditional expression, Incorrect conditional expression, Lexical error at line 0, column 0.

Re: very basic query error???

hi, i need the commas in the like clause though, how can i get these in there? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: null pointer? need your expertise!

how do i get extra debugging information about the null pointers as just saying it tried to reference a null value isnt helping me find what the issue is? thanks richard Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query

Re: very basic query error???

You aren't by chance storing a comma-delimited list in a single column a database are you? :) hi brad, well not in the database but this particular column in the coldfusion query at this point could have comma delimited lists. this query is something i have created out of various other queries

Re: very basic query error???

i have actually used this in other queries and it does work fine and pulls out the data as required, its just that in this one i am having problems i have managed now to get rid of the error above, its becuase it was trying to change the single quotes to double quotes. so i used the

Re: null pointer? need your expertise!

oh i see, thanks very much josh i will give this a go :) good find! thanks again Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there

Re: null pointer? need your expertise!

that did it! thanks again Josh, good find, i have been tearing my hair out over that all night thanks again Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator

Re: very basic query error???

josh managed to find the solution in this post: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56796 it was down to some cells in that column being null when using the like clause - i had to include where T_Site is not null and now it is working fine You aren't by chance

Re: null pointer? need your expertise!

Take those commas outa there. ?? hi will, i would actually like too, this scenario came up in a previous post i made about the best way to run a query on a particular scenario, the post is: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56792 even though this issue is now

Re: cfinput required=yes not generating pop-up

is this issue arising on your testing server or on the live site? i have had this error occur almost everytime we have changed our hosting company or they have changed our vps over to a new server. we inform them of it and they tell us that they forget to set something on the server i know

mysqldump question

hi we are getting dumps of our mysql database on our server and then dropping the database on our local machine, re-creating the database with the command create database dbname, then when we try to import all data from the dump file it produces an error saying that a certain table (.frm)

array toscript problem if empty

hi i am using the following method to translate coldfusion into javascript arrays: cfoutput var #toscript(array1,jsArray1)#; var #toscript(array2,jsArray2)#; /cfoutput however, these arrays sometimes don't contain any elements and if this is the case then i get a 'missing variable'

Re: array toscript problem if empty

) alert('pos '+i+' is '+data[i]); } /script /cfoutput On Fri, Jun 13, 2008 at 8:18 AM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free

Re: data from coldfusion query to db query

Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Richard White wrote: i must be naive as i have never used the cfinsert but how would i use it in this case as the documentation seems to suggest that it only uses formfields and not the contents of another cf query thanks

Re: data from coldfusion query to db query

, Richard White wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF

data from coldfusion query to db query

Hi, i have built up a ColdFusion query with the use of querynew, queryaddrow etc... the columns i have in this query are identical to a query i have in my mysql database(including the column types) is there a way for me to quickly transfer all the data from the coldfusion query to the mysql

Re: data from coldfusion query to db query

, cfloop over your query and use cfinsert. 3 lines of code. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jun 8, 2008, at 4:19 PM, Richard White wrote

Re: data from coldfusion query to db query

. Wil Genovese One man with courage makes a majority. -Andrew Jackson A fine is a tax for doing wrong. A tax is a fine for doing well. On Jun 8, 2008, at 4:19 PM, Richard White wrote: ~| Adobe® ColdFusion® 8 software 8

Re: left join on query of queries

thats ok mike, very clever idea about the temp table as well thanks again! Sorry, I thought you said if, not how. As another person suggested, you could use nested loops. Or, you could insert into a temp SQL table and run the outer join. m!ke Yes we are aware that they are not supported and

left join on query of queries

hi, does anyone know how i can achieve a left join in a query of queries thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: left join on query of queries

Yes we are aware that they are not supported and we are looking for a workaround. does anyone have any suggestions? thansk Outer joins are not supported in QoQ. You will have to come up with a workaround. Search this list for some suggestions. m!ke hi, does anyone know how i can achieve

listtoarray?

Hi we have various string values like the following: qu_45_tb_45_split_0_split_q_67 we need to break this string down into 3 array elements and split it based on the string '_split_' if the listtoarray function used this actual sequence to break the string up then we would be given an array:

Re: listtoarray?

cfset myList = Replace('qu_45_tb_45_split_0_split_q_67', '_split', ',') cfset aMyList = ListToArray(myList) On Thu, Jun 5, 2008 at 5:01 PM, Richard White [EMAIL PROTECTED] wrote: excellent thanks very much :) ~| Adobe

mysqldump question

hi, we have been doing mysqldump of our database and realise that it is not doing exactly what we want it to do it is dumping out all the data and if we load into another database then it loads the data in and creates the tables it needs in order to enter the database. however it does not

Re: mysqldump question

On Tue, Jun 3, 2008 at 9:48 AM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k

Re: mysqldump question

with it, but it's simple enough to just do that before loading the script. cheers, barneyb On Tue, Jun 3, 2008 at 10:14 AM, Richard White [EMAIL PROTECTED] wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important

Re: market rates

:) like it On Saturday 31 May 2008, Richard White wrote: we are based in the UK, does anyone know of anywhere we could go to fund out the current market rates for coldfusion and mysql web application developers? Ring a company that offers a CF coding service and pretend your

cfquery returns db tinyint(1) as boolean

hi, after lots of problematic select statements we have realised that if a db column has a type of tinyint(1) and that column in the mysql db has '2' stored in it, then running a cfquery will only return 0 or 1 so we realise that cfquery must convert tinyint(1) columns to boolean we couldn't

Re: cfquery returns db tinyint(1) as boolean

hi dave. yeah we just found that it is a previously submitted bug for mysql jconnector which we use in dreamweaver. to get around it we just changed those columns to smallint(1) thanks after lots of problematic select statements we have realised I don't know if this is a problem specific

Re: cfquery returns db tinyint(1) as boolean

to look it up in the mysql reference manual - i do not remember the details of this setting... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Richard White wrote: ~| Adobe® ColdFusion® 8 software 8 is the most important

recursive functions and cfqueries

hi i am having a problem with a recursive function resetting the contents of a query, so i must be doing it wrong, can anyone spot what i should be doing please, thanks basically i pass in a folderid and query to see if it has any children, if it does then it adds the child and goes on to

Re: recursive functions and cfqueries

good tip, thanks morgan This was also my first inclination. We sometimes add a cfset var local = StructNew() to open a function, then anything that needs to be var'd is just 'scoped' as 'local' (cfset local.myVarredVariable = ) On Mon, Jun 2, 2008 at 4:09 PM, Brad Wood [EMAIL PROTECTED] wrote:

Re: recursive functions and cfqueries

spot on, thanks brad, works perfectly, just so i understand, does this make a difference because then it is creating a new variable each iteration, and if you don't set it then just puts it into the existing variable? i don't use many vars in my code, is that bad practise? thanks again for

Re: recursive functions and cfqueries

thanks brad thats really understandable, much appreciated! Yes, each time the function recurses into itself you want it to start over with a new set of variables specific to that particular run. Unless otherwise specified, your variables such as the query are placed in the variables scope which

market rates

hi, we are based in the UK, does anyone know of anywhere we could go to fund out the current market rates for coldfusion and mysql web application developers? thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most

query on query group by

hi i am trying to run this query of query: cfquery name=newQuery dbtype=query select * from query1 group by column1, column2; /cfquery but it gives me the following error: The column query.column3 is invalid in the SELECT list clause because it is not contained in either an aggregate

Re: cfcs good practise

Excellent thanks Jaime, you have given me a lot to think about. i think its best for me to start looking into these DAO's and refer back to what you have said, and get back to you again with more questions if you don't mind :) thanks again for your help, really appreciate it Richard

Re: powered by and copyright

Ok thanks, in the product we are working on , it does use our own framework in the background therefore how do you write this down. i.e. we have a company name and a product name, therefore is it: [product name] powered by [company name] copyright 2008 all rights reserved or... how do you

Re: powered by and copyright

thanks for all your help. i remembered that someone advised us to add the 'powered by' because parts of our software allows 'whiteboarding' which is to customize the look and feel to the customer, and therefore it appears as if it is their own. so of course we needed a way of showing that it

Re: cfcs good practise

Thanks for your reply Jaime so am i correct in understanding that i should have a project class with methods such as add, remove, find etc... and properties such as name etc... and a test class with much the same methods and attributes, and a materials class, again with much the same

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