in a jam with SQL and division

[GUJUm0deL]

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...

 

[Databaseguy]

I don't know cold fusion. If it's "normal" SQL syntax, then

select [tbl1Name].[ten_days], [tbl2.name].[answers], from
[tbl1Name].[ten_days]/ [tbl2.name].[answers] AS [NewField] FROM......etc

Don't forget your join statements if your using more than one table.

 

[GUJUm0deL]

Databaseguy, the problem is that CF uses alot of strange SQL coding syntax that i'm not familiar with...I tried to see if Acess can allow me to do the calculation, and in a way it does, but then I don't know how to display that answer to the page... I have not failed; I merely found 100,000 different ways of not succeding...

 

[Databaseguy]

Guess I should learn CF. Sorry, you're beyond me.

 

[GUJUm0deL]

DatabaseGuy, thanx for the help...are you aware of anyother way that I can acheive this?? I have not failed; I merely found 100,000 different ways of not succeding...

 

[THoey]

Guju,

Did you try going to the CF forum? Terry M. Hoey

 

[GUJUm0deL]

Hi th3856, actually we already fixed that problem...me and my co-worker realized we could use the <CFSET> parametere to list calculations...
Thanx for the reply though... I have not failed; I merely found 100,000 different ways of not succeding...

 

[THoey]

Guju, if you can, please post your fix. It may help someone else down the road... Terry M. Hoey

 

[GUJUm0deL]

Sure thing th3856, alwayz glad to help...

<td width=&quot;240&quot; height=&quot;30&quot;><CFSET name_of_value = DetailField7 / DetailField5 * 100>#name_of_value#</td>

Hope this helps anyone else...
I have not failed; I merely found 100,000 different ways of not succeding...