Skip to main content
M
masoud_amen
Known Participant
March 14, 2008
Question

sql & coldfiusion

  • March 14, 2008
  • 1 reply
  • 255 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
March 14, 2008
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.

M
masoud_amenAuthor
Known Participant
March 14, 2008
thanks.I will try that :)
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices