As some of you know, I am experiencing some technical difficulties communicating with the database. Apparently Flash or PHP doesn't like the field name "fulltext" as a querying call to my database. Problem with that is: It is entirely pointless to have a PopUp window (read: page after "read" link) if all the text is on the front page. Argue all you like about the superiority of having full text on the front page, I WONT HEAR IT. Here is some code (albeit chopped up) to keep you readers entertained.

var gw:NetConnection = new NetConnection;

var respondAll:Responder = new Responder(onResult, onFault);

var $url:String = "youllneverknow/gateway.php";

var $q:String = "SELECT content_id FROM content_frontpage";

var $r:String = "SELECT title, created, fulltext , id FROM content";

gw.connect($url);

gw.call("db_Q.getDB", respondAll, $q);

gw.call("db_Q.getDB", respondFrontpage, $r);

function onResult(responds:Object):void {

articles = responds.serverInfo.initialData; //Thank you Mr. Brimelow

for (var i in articles) {

//blog feed is a boring Class, it only assembles the list, nothing special

blogFeed.addListItem(articles[i][3], new Array(articles[i][0],articles[1][1],articles[i][2]));

}

}

I send "SELECT title, created, intro, id FROM content" to the amfphp service. It successfully returns an array with all the fixins. When i send "SELECT title, created, fulltext , id FROM rgm_content" to the same service it craps out and returns a 1069 error. HOWEVER! once i changed the name "fulltext" to "fulltext1" and send "SELECT title, created, fulltext1 , id FROM rgm_content" everything is fine and dandy. If you have any solution please send me an email at: nsmith@rendergardenmedia.com i will soon work on getting commenting up and running.

UPDATE: commenting now works. give it to me.