Re: Dynamic query help.

2011-11-10 Thread Dave Watts
> Wow, I can't believe I didn't think of using a temporary table to store the > dynamic data while it's being edited, that's a great > idea. I can't use session variables because it's a grid and would be > considered a complex data type. (I was under the > impression that session variables can o

Re: Dynamic query help.

2011-11-10 Thread Ray Meade
Wow, I can't believe I didn't think of using a temporary table to store the dynamic data while it's being edited, that's a great idea. I can't use session variables because it's a grid and would be considered a complex data type. (I was under the impression that session variables can only hold

Re: Dynamic query help.

2011-11-07 Thread Justin Scott
> Thanks Justin, I wasn't aware that a dynamic query was lost > once the page was finished loading. Does the same rule apply > to structures? Yes, that would apply to all variables unless you store them in persistent memory (e.g. database, session scope, write to a file, etc.). In your case I wo

Re: Dynamic query help.

2011-11-07 Thread Russ Michaels
normal variables only exists for the duration of the CF request. you need to use session scope if you want persistence that is specific to each user. On Mon, Nov 7, 2011 at 6:01 PM, Ray Meade wrote: > > Thanks Justin, I wasn't aware that a dynamic query was lost once the page was > finished loa

Re: Dynamic query help.

2011-11-07 Thread Ray Meade
Thanks Justin, I wasn't aware that a dynamic query was lost once the page was finished loading. Does the same rule apply to structures? Perhaps I can use a structure to hold the data and update it as changes are made. Basically, I don't want the physical database being updated until the submit

Re: Dynamic query help.

2011-11-06 Thread Justin Scott
> ...I'm not sure how to update the dynamic query. Hi Ray, I don't know much about the mechanics of your application, but remember that once the HTML has been generated and the page loaded on the client, the ColdFusion process is finished and that dynamic query doesn't exist in memory anymore unt

Dynamic query help.

2011-11-05 Thread Ray Meade
I'm writing an app. for an auto repair shop that has a Flash cfgrid containing quantity, description, price and total cost (the quantity times the price). Right now, the initial total cost is being calculated in a view in the database. I've created a dynamic query (using queryNew) to hold all o