anyone see anything diff that needs to be added (its 441am im sure im missing something
<!--- get message list --->
<cfquery name="qGetXMLlist" datasource="#dsn#" username="#un#" password="#pw#">
SELECT *
FROM guestbook
ORDER BY postdatetime desc
</cfquery>
<!--- get message count --->
<cfparam name="PageNum_qGetXMLlist" default="1">
<cfset MaxRows_qGetXMLlist=25>
<cfset
StartRow_qGetXMLlist=Min((PageNum_qGetXMLlist-1)*MaxRows_qGetXMLlist+1,Max(qGetXMLlist.RecordCount,1))>
<cfset
EndRow_qGetXMLlist=Min(StartRow_qGetXMLlist+MaxRows_qGetXMLlist-1,qGetXMLlist.RecordCount)>
<cfset TotalPages_qGetXMLlist=Ceiling(qGetXMLlist.RecordCount/MaxRows_qGetXMLlist)>
<cfxml variable="messagesXML">
<threads PageCount="<cfoutput>#EndRow_qGetXMLlist#</cfoutput>"
RecordCount="<cfoutput>#qGetXMLlist.RecordCount#</cfoutput>">
<cfoutput query="qGetXMLlist">
<message>
<subject>#subject#</subject>
<number>#number#</number>
<email>#email#</email>
<url>#url#</url>
<body><![CDATA[#message#]]></body>
<sex>#sex#</sex>
<reply><![CDATA[#reply#]]></reply>
<icon>#icon#</icon>
<posted>#postdatetime#</posted>
<face>#face#</face>
<username>#username#</username>
<icq>#icq#</icq>
</message>
</cfoutput>
</threads>
</cfxml>
<cffile
action="write"
file="#ExpandPath('messages.xml')#"
output="#ToString(messagesXML)#">
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Protect your mail server with built in anti-virus protection. It's not only good for
you, it's good for everybody.
http://www.houseoffusion.com/banners/view.cfm?bannerid=39
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182794
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
