Skip to main content
June 29, 2006
Answered

Relationships in coldfusion

Hi everybody:
I need some tutorials about making cfm application connected to a relational database. I need to set some One-To-One, Many-To-Many and One-To_Many relationships in my coldfusion application but I don't know how.
Please let me know where I can find some information about setting these relationships in coldfusion.
Thanks
Benign
    This topic is closed to new replies. Start a new post to keep the conversation going.
    Dan_BracukCorrect answer
    Inspiring
    June 30, 2006
    So in other words, you need to learn how to write sql. I have heard good things about the book, Teach Yourself SQL in 10 Minutes by Ben Forta.

    6 replies

    Inspiring
    July 3, 2006
    >>Teach Yourself SQL in 10 Minutes by Ben Forta.

    Ridiculous idea that you could, in ten minutes, learn sql, and a very
    unremarkable book too. This stuff is important, best to learn it at least
    half seriously! In contrast, the SQL in 21 days, also by Sams, is actually
    very good, especially good for those who know zero about SQL and related
    concepts.




    "Dan Bracuk" <webforumsuser@macromedia.com> wrote in message
    news:e83796$ndh$1@forums.macromedia.com...
    > So in other words, you need to learn how to write sql. I have heard good
    things about the book, Teach Yourself SQL in 10 Minutes by Ben Forta.


    Translate
    Dan_BracukCorrect answer
    Inspiring
    June 30, 2006
    So in other words, you need to learn how to write sql. I have heard good things about the book, Teach Yourself SQL in 10 Minutes by Ben Forta.
    Translate
    Inspiring
    June 30, 2006
    What you are asking about is called data modelling, a concept where you normalize your database. Look for books, courses, tutorials, etc about this.
    Translate
    Inspiring
    June 29, 2006
    Strange question. One does not set any relationships in ColdFusion.
    One usually sets relationships in the relational database management
    system of their choice. Then queries this database with stand SQL
    syntax. Are you asking how you create joins in SQL? Or how you design
    a database schema? Or what?

    Benign wrote:
    > Hi everybody:
    > I need some tutorials about making cfm application connected to a relational
    > database. I need to set some One-To-One, Many-To-Many and One-To_Many
    > relationships in my coldfusion application but I don't know how.
    > Please let me know where I can find some information about setting these
    > relationships in coldfusion.
    > Thanks
    > Benign
    >
    Translate
    June 30, 2006
    Hi:
    Thanks for the reply.
    As a matter of fact I need to know how you create joins in SQL? and then how to put it in .cfm pages.
    Thanks
    Benign
    Translate