Skip to main content
Participant
November 19, 2009
Question

operation in 2 tables

  • November 19, 2009
  • 1 reply
  • 374 views

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

    This topic has been closed for replies.

    1 reply

    Inspiring
    November 19, 2009
    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.

    Nazi370Author
    Participant
    November 19, 2009

    to determine the value point bas

    ed on marks tables...

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

    Inspiring
    November 19, 2009

    Hi,

    Can you please post your working code here?.