Creating A ColdFusion Guestbook - Page 4

This file is only ever called by the Flash movie, so we don't really need to do a check for the existence of variables beforehand. They will already exist.

So here we go. Set your datasource.

The variable 'todo' is used in both calls and if it is set to 'sign'.

then let's sign the guestbook by inserting a new entry. All the information we need comes directly from the Flash movie.

        
        INSERT INTO guestbooktbl(visitorFullname,comment,
                dateOfMessage,live,visitorEmail,homepageURL)
         VALUES(NULL'#name#',
        NULL'#comment#',
        #CreateODBCDateTime(Now())#,
        1,
        NULL'#email#',
        NULL'#url#')

    

Now let's read all the entries in the database and store the results in order of the date they were entered. Most recent first.

    SELECT *
    FROM guestbooktbl
    WHERE live=1
    ORDER BY dateOfMessage DESC

That's the database done with. Now set up a couple of variables Flash needs.