Thanks, that's really weird, about 10 people or so go in successfully and the error message refers to an invalid data type for CF_SQL_INTEGER but the line it refers to is CF_SQL_LONGVARCHAR (it's a mysql TEXT datatype).
Curious. Thanks to everyone who dropped in. Rick Jennifer Gavin-Wear wrote: > Hi rick, > > just tried your link: > > The web site you are accessing has experienced an unexpected error. > Please contact the website administrator. > > The following information is meant for the website developer for debugging > purposes. > > Error Occurred While Processing Request > Invalid data for CFSQLTYPE CF_SQL_INTEGER. > > > The error occurred in /home/opencf/public_html/chat/chat.cfc: line 54 > > 52 : <cfqueryparam cfsqltype="cf_sql_integer" value="3">, > <!--- normal > response.. 2=system action, 3=emote ---> > 53 : <cfqueryparam cfsqltype="cf_sql_varchar" > value="#session.chatCFC.uname#">, > 54 : <cfqueryparam cfsqltype="cf_sql_longvarchar" value="/me > just joined > the room."> > 55 : ) > 56 : </cfquery> > > > > >>>-----Original Message----- >>>From: Rick Root [mailto:[EMAIL PROTECTED] >>>Sent: 14 February 2006 17:47 >>>To: CF-Talk >>>Subject: chat help >>> >>> >>>I'd love it if a few people wouldn't mind coming into my chat room that >>>I'm building with cfajax.... I'd like to see how it reacts with a few >>>people in it. >>> >>>http://www.opensourcecf.com/chat >>> >>>Please choose "Test Room A" >>> >>>thanks. >>> >>>rick >>> >>> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232220 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
