Noob Questions

i've been searching on internet , trying many different things form work properly. have form need keep track of time takes user fill out. use #timeformat(now())# @ all? database name surveyinfo , #filltime# used in table record survey fill out time.

i need function set table percentages of answers recorded. ex: 50% satisfied
my code wrong i'll include show i'm naming everything.

<cfquery name="getquery" datasource="surveyinfo">
select count(satisfied) satisfied, count(serviceuse) serviceuse
from table1
</cfquery>

<cfset satisfiedtotal = (#getquery.satisfied#)>
<cfset serviceusetotal = (#getquery.serviceuse#)>
<cfset satisfiedyes = (#getquery.satisfied#/#satisfiedtotal#)*100>
<cfset satisfiedno = (#getquery.satisfied#/#satisfiedtotal#)*100>
<cfset satisfiedsomewhat = (#getquery.satisfied#/#satisfiedtotal#)*100>
<cfset serviceusewd = (#getquery.serviceuse#/#serviceusetotal#)*100>
<cfset serviceusesd = (#getquery.serviceuse#/#serviceusetotal#)*100>
<cfset serviceuseas = (#getquery.serviceuse#/#serviceusetotal#)*100>
<cfset serviceuseis = (#getquery.serviceuse#/#serviceusetotal#)*100>
<cfset serviceusets = (#getquery.serviceuse#/#serviceusetotal#)*100>
<cfset serviceuseo = (#getquery.serviceuse#/#serviceusetotal#)*100>
<cfoutput>
<tr>
<td>completely satisfied service: </td>
<td>#numberformat(satisfiedyes,"__")# %</td>
</tr>
<tr>
<td>not satisfied service: </td>
<td>#numberformat(satisfiedno,"__")# %</td>
</tr>
<tr>
<td>somewhat satisfied service: </td>
<td>#numberformat(satisfiedsomewhat,"__")# %</td>
</tr>
<tr>
<td>web development </td>
<td>#numberformat(serviceusewd,"__")# %</td>
</tr>
<tr>
<td>software development: </td>
<td>#numberformat(serviceusesd,"__")# %</td>
</tr>
<tr>
<td>accounting software: </td>
<td>#numberformat(serviceuseas,"__")# %</td>
</tr>
<tr>
<td>inventory system: </td>
<td>#numberformat(serviceuseis,"__")# %</td>
</tr>
<tr>
<td>tracking system: </td>
<td>#numberformat(serviceusets,"__")# %</td>
</tr>
<tr>
<td>other: </td>
<td>#numberformat(serviceuseo,"__")# %</td>
</tr>
</cfoutput>

to calculate time takes user complete form, use cold fusion's now() function twice. run on form page , store value session variable or hidden form field. run again on action page , use datediff interval. not use dateformat or timeformat. have uses , isn't 1 of them.

for 2nd part, 1 rule of normalization not store calculated values. if store questions, answers, etc, should able calculate things need on fly.

More discussions in Getting Started

adobe