Re: query object error

Thanks - problem solved (and simpler than StuctUpdate, too!) :-) > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/gr

RE: query object error

> -Original Message- > From: Kamru Miah [mailto:k.m...@csl.gov.uk] > Sent: 30 June 2009 12:08 > To: cf-talk > Subject: Re: query object error > > > I just realised that the 'role' query form a include file is > returntype="struct", and

Re: query object error

I just realised that the 'role' query form a include file is returntype="struct", and not returntype="query" - dah! So now the question is, how do I insert a value to the 'positions' cell of the structure, please? >Could you show more of your code. This works for me. > >Oh and you don't need

RE: query object error

Could you show more of your code. This works for me. Oh and you don't need to assign to a temp var when using QuerySetCell. Adrian > -Original Message- > From: Kamru Miah [mailto:k.m...@csl.gov.uk] > Sent: 30 June 2009 11:43 > To: cf-talk > Subject: query object error > > > I am using

RE: Query Object

Coincidentally, I just wrote about this in response to someone else's question. Not sure if any of this would help you: http://www.bennadel.com/blog/674-Ask-Ben-Adding-A-Column-From-Second-Que ry-To-First-Query.htm OR: http://www.bennadel.com/index.cfm?dax=blog:674.view This doesn't talk about "

RE: Query Object

QueryAddColumn -Original Message- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Thursday, May 03, 2007 8:02 AM To: CF-Talk Subject: Query Object Hello Guys, Is it possible to loop through a query object and add additional columns containing calculated data? I'm s

Re: Query Object

> > Is it possible to loop through a query object and add additional columns > containing calculated data? QueryAddColumn() http://www.cfquickdocs.com/?getDoc=queryaddcolumn -- Thanks, Tom Tom McNeer MediumCool http://www.mediumcool.com 1735 Johnson Road NE Atlanta, GA 30306 404.589.0560

Re: Query Object from CSV to Database

If the user you are connecting as has the power, you can issue the LOAD DATA command from within a cf query, I think, which would probably be the easiest. HSSQLDB is a pure java database- With HSSQLDB, you can download all the CSV files into one directory, and then run normal SQL commands agains

Re: Query Object from CSV to Database

The load data query can only be used on SQL prompt, i think. I will try it though using stored proc or directly but i read that somewhere tht we can only run on prompt > I thought load data had been around since version 4. Am I wrong? I > was thinking you could use load data to do the import an

Re: Query Object from CSV to Database

Hi When u say HSSQLDB you mean ?? Can you tell me any capability you know that can make my process faster. I am using so many file operations 1> Reading CSV from FTP and upload 2> Then storing in MySQL DB 3>Another query to get the values and doing some operation on those values ( for that i a

Re: Query Object from CSV to Database

On 2/28/07, Deepak Gupta wrote: > Thanks a lot Man.. it worked... Sweet! Glad I could help. If you have access to createObject, HSSQLDB has some excellent CSV handling capabilities. Plows right through stuff that you can't, for whatever reason, import using cfhttp. BTW, cfhttp will take CSV an

Re: Query Object from CSV to Database

I thought load data had been around since version 4. Am I wrong? I was thinking you could use load data to do the import and skip the read query and looping altogether. If you don't think that would work, take a look at Dinner's suggestion above. Janet ~

Re: Query Object from CSV to Database

This more like a dynamic query..columns on the fly and all that stuff. even the stored proc failed on few ocassions. Because they are new in MYSQL 5 >>>What is your database type? >>> >>>Janet >> >>MYSQL > >Doesn't mySQL have a utility for loading csv files? Load Data or something... > >Janet ~

Re: Query Object from CSV to Database

Thanks a lot Man.. it worked... >On 2/28/07, Deepak Gupta <[EMAIL PROTECTED]> wrote: > >Cut and paste a bit of your other code (but don't tell anyone I said to >do that!) with a tweak or two: > > > > > >listAppend(rowVals,'"#csvdata[colName][csvdata.currentRow]#"')> > > > >INSERT I

Re: Query Object from CSV to Database

>>What is your database type? >> >>Janet > >MYSQL Doesn't mySQL have a utility for loading csv files? Load Data or something... Janet ~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free

Re: Query Object from CSV to Database

>What is your database type? > >Janet MYSQL ~| 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.c

Re: Query Object from CSV to Database

What is your database type? Janet ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups

Re: Query Object from CSV to Database

On 2/28/07, Deepak Gupta <[EMAIL PROTECTED]> wrote: > > Hi > > > > I am doing this > > > > > > SELECT * FROM #LocalFilePath# > > > > > > I have here the query CSVdata, this is basicaly converting CSV to > > query and now I have to insert this query in the database. I already > > have a dummy tab

Re: Query Object from CSV to Database

> Hi > > I am doing this > > > SELECT * FROM #LocalFilePath# > > > I have here the query CSVdata, this is basicaly converting CSV to > query and now I have to insert this query in the database. I already > have a dummy table with these column names in the database.her

RE: Query object contained within a Query object

>>I suspect it has more to do with the fact that people have specific >>expectations about what's in a query object than anything else. People have >>a two-dimensional mental model of what a recordset is, and nesting one >>recordset within another would break that model. You may very well be righ

Re: Query object contained within a Query object

>>> Claude Schneegans >The result would be the same, but the sub-query would not have to be >copied into the main query, and there would be a difference on performance. I would think that the sub-queries would not be "copied" into the main query. In java, objects like structures are passed by r

Re: Query object contained within a Query object

>>While I am aware of most of the alternatives, I'm more interested in understanding the pratical reasons why this method is not used. There would definitely be a performance problem, especially if the sub-queries are big queries. Although I didn't try it, I think one of these alternative would

Re: Query object contained within a Query object

Dave Watts wrote: > recordset within another would break that model. In any case, I haven't yet > encountered a need to use this construct, so this discussion is fairly > academic to me. well i could see the benefit for something like the cfpop query's mail headers (though as a structure rather th

RE: Query object contained within a Query object

> For the purposes of my question ... "yes" ;-)While I am > aware of most of the alternatives, I'm more interested in > understanding the pratical reasons why this method is not > used. I suspect it has more to do with the fact that people have specific expectations about what's in a query obj

Re: Query object contained within a Query object

>Claude Schneegans >That is the question. >One can sure use loops on queries inside loops on queries, but do we >need to store them inside each others ? For the purposes of my question ... "yes" ;-)While I am aware of most of the alternatives, I'm more interested in understanding the pratical re

Re: Query object contained within a Query object

>I think my biggest problem with doing this is, the performance cost of >query objects. Aside from file handling query objects seem to be one >of the worst performing objects in coldfusion. > >Adam H Yes, I would expect query objects to be more expensive than an arrays. Any stats/links or explan

Re: Query object contained within a Query object

>>and am wondering if there is a good reason why. That is the question. One can sure use loops on queries inside loops on queries, but do we need to store them inside each others ? ~| Logware (www.logware.us): a new and conven

Re: Query object contained within a Query object

I think my biggest problem with doing this is, the performance cost of query objects. Aside from file handling query objects seem to be one of the worst performing objects in coldfusion. Adam H On 7/21/05, HOFLee _ <[EMAIL PROTECTED]> wrote: > Thank you both for your responses. > > >>Personnally

Re: Query object contained within a Query object

Thank you both for your responses. >>Personnally, I'd be more interested in hearing "why this would be a *good* >>idea?" Primarily because query objects can be used with the cfoutput/cfloop tags which IMO provide a simpler and cleaner method for accessing the related information than structure

Re: Query object contained within a Query object

>>Because anybody looking at the code wouldn't at first understand what is >>going on. I don't think this is a good reason. If somebody looking at "" is not able to understand what's being done, he better not have access to the code anyway. Personnally, I'd be more interested in hearing "why th

RE: Query object contained within a Query object

Because anybody looking at the code wouldn't at first understand what is going on. If you do something weird to it, it will cost more to matain that particular piece of code. That's why. Jared Clinton NEC Business Solutions. -Original Message- From: Lee _ [mailto:[EMAIL PROTECTED] Sen

Re: Query Object coldfusion.sql.QueryTable

That's the reason you DONT use undocumented features in the first place.. On Mon, 31 Jan 2005 19:42:30 +0100, xxx xxx <[EMAIL PROTECTED]> wrote: > Does anyone know if the undocumented feature still work with > ColdFusion MX 7 (Blackstone)? ~

Re: Query Object coldfusion.sql.QueryTable

Well macromedia has publically made it known that MX 7 is basically a bunch of addons to the MX 6 engine so you could make a some what sound assumption that it will work but...its not documented so no garuantees... just my 2 cents... Adam H On Mon, 31 Jan 2005 15:10:26 -0500, Dave Watts <[EMAIL

RE: Query Object coldfusion.sql.QueryTable

> I found this great article about the undocumented ColdFusion > query object: > > > Does anyone know if the undocumented feature still work with > ColdFusion MX 7 (Blackstone)? If they did, they'd be under NDA and couldn't answer your questio