operation in 2 tables

[Nazi370]

hello.

i have 2 tables :

1. marks

2. grad

let say i have column pointValue for the grad and i want to use it, how do we retrieve it from the database..

im trying this :

<cfif qd.marks GTE qGetGrade.to_kysMark>
    <cfset value= qGetGrade.Point_value>   
    <cfset total_value = total_value + value>

</cfif>

but the result unfavorable.. any suggestion? thanks

[Daverms]

but the result unfavorable.. any suggestion? thanks

Could you please let us know what you actually trying to acheive?. Also please post the complete code if possible.

[Nazi370]

to determine the value point bas

ed on marks tables...

for eg. if the marks = 40, then the value point is 2.33 ..

[Daverms]

Hi,

Can you please post your working code here?.

[Nazi370]

query in queries.. LOL

QoQ Problem.. any suggestion or tutorial? thanks..

i have to use 2 query for comparison.. joining table is not the choice since there are no equal value between both tables..

//loop

    <cfoutput query='qd' >

...

    <cfif qd.marks GT qGetGrade.to_kysMark>
    <cfset Point_value = qGetGrade.Point_value >   

     </cfoutput>

//no loop

    <cfoutput>

...

    <cfif qd.marks GT qGetGrade.to_kysMark>
    <cfset Point_value = qGetGrade.Point_value >   

     </cfoutput>