Only showing chat lobby's where Integration field in Database is NULL

  •  10-05-2005, 12:57 PM

    Only showing chat lobby's where Integration field in Database is NULL

    Hi guys,

    I have got your chat application running well in my app, and I am making use of the open "Integration" column in the chat_lobby table of the database to match chat rooms to sections of my site.

    I do however still have the main chat page which lists all of the chat lobbies available.  I see that the Lobbies are populated to the datalist via a call to

    <code>
    return ChatWebUtility.Api.GetLobbies();
    </code>

    What I was wondering if there is anyway to change the SQL query string called by this function to only select the lobbies where the Integration field is NULL, cause I can't seem to find it in the editable code.  I would imagine that the query would look something like this:

    <code>
    SELECT name, description, announcement, password FROM chat_lobby WHERE integration IS NULL
    </code>

    Any ideas as to how I would achive this?

    Thanks
    Grisbi
View Complete Thread