sql & coldfiusion

[masoud_amen]

Hi.I have created a view nemed View_Detail_Order_Product in SQL and I'd like to use the fields in my code.what is the syntax for that?
thanks

[Newsgroup_User]

masoud_amen wrote:
> Hi.I have created a view nemed View_Detail_Order_Product in SQL and I'd like to use the fields in my code.what is the syntax for that?
> thanks
>


SELECT aField, bField, cField

FROM View_Detail_Order_Product


Once created a view is just another kind of table.

[masoud_amen]

thanks.I will try that 🙂