Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hey everyone, I have a situation

Status
Not open for further replies.

GUJUm0deL

Programmer
Jan 16, 2001
3,676
US
Hey everyone, I have a situation here...i'm creating a form in coldfusion using SQL, and I used Access97 to create the DB...what I need to do is take 2 table's from the DB and divide them (divide one form into the other) and display the result of that, on a page...
I thought of using SQL with something like this:

select ten_days, answers, (ten_days/answers)
from forms


Will something like that work?? Is there another way to make this happen?? Simply put, I just want the table ten_days to divide into table answers...and since i'm using CF, its kinda hard to change the querries because CF puts in code i've never seen before...
In advance, thanx...
I have not failed; I merely found 100,000 different ways of not succeding...
 
hey, nevermind we worked it out...and got the solution...if anyone was interested in knowing how to make CF do the division calculation:

<CFSET name_of_value = name1 / name 2> #name_of_value#


I have not failed; I merely found 100,000 different ways of not succeding...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top