Ah, this looks great. I'll suggest the steps. I'm pretty sure I get it all.
Thanks a bunch (again) Deanna. I owe you at least a beer.
>Been there, had that client. You do still need to keep in mind things like
>whether or not a record is "complete" if they haven't filled everything in,
>when you're storing data like this. And, you might want to consider adding
>something like "Step 2 of 546." to your screens, so people can see how far
>along they are. Though, I still go back to saying that I'm not sure what the
>benefit is to having each on a separate page. You're doing a logic model
>program planning process, right? (Twas pioneered here in Wisconsin.) There
>aren't _that_ many steps to that. I'd at least group all the questions from
>each phase together.
>
>
>Situation Analysis
> vision
> mission
> etc
>
>Inputs
> investment by....
>Outputs
> what we do
> who we reach
>Outcomes
> short term results
> medium term results
> long term results
>
>
>As to putting stuff in session vars - yah, it's pretty easy. You're on 6.1,
>right? So, locking isn't the major conundrum it used to be. You can save
>your whole query results to the session, and then you'd just reference them
>as #session.queryname.columnname.# But, I'm not sure you then update that
>directly. I think you'd have to make it a structure instead, but since each
>query should only have one row of data returned, that's not such a big deal.
>You can just do this sort of thing:
>
><cfif not isdefined("session.test") or structKeyExists(url, "reset")>
> <cfquery name="test"..../>
>
> <cflock scope="session" type="exclusive" timeout="10">
> <cfset session.test = test>
> </cflock>
>
></cfif>
>
>Then, when you update a record, you can just do:
>
> <cflock scope="session" type="exclusive" timeout="10">
> <cfset session.test.mycolumn[1] = form.mycolumn>
> </cflock>
>
>
>
>
>
>
>----- Original Message -----
>From: "daniel kessler" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[email protected]>
>Sent: Thursday, May 19, 2005 12:41 PM
>Subject: Re: form->database->form help needed
>
>
>>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207250
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
