Could somebody preeeeze help me find my way into the "Live Chat" room? I have been a member of C3VR since '03, and I have NEVER been able to join in the fun. I've had this same trouble with 3 different 'puters, so I'm pretty sure it's not that. I usually can at least get to the 'sign in' page, but no further. To-nite, tho, I get a new kick in the a#*!
If someone can "talk" me thru it, I'd really 'preciate it. I just
know you're all in there talking bad about ME!

This is what I'm getting to-nite, when I click on the "Live Chat" icon:

There was an error! It has been reported to the system administrator. It you continue to get this message for more than 1 day, please send an email to support@VR.com

Error 424: Object required


Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'Username = 'Adams' Apple';'.

/netchatter/login.asp, line 16

Adams' Apple38630.7852893519

Sounds like your pop up is blocking or your fire wall is restricted.

 

Try now. I think I fixed it.

Thanx, guys!!!

Get some sleep now....    

Just some info for others who might have had this same problem Adam & Mike(Iron82) helped to solve the mystery(or decided to finally let me play with the "Big Dogs" ).
It was the fact that my screen name, Adams' Apple has an apostrophy in it. Seems the software didn't recognize/accept this type of data. Only took 2years to to discover this 'glitch'!!
Just kiddin, guys!

Thanks for the help on this, Adam & Mike!!! I really enjoyed being able to join in a little last nite. (I think Mike wanted to drive me even closer to the brink, cause he would I/M me at the same time I was "chatting", causing a considerable amount of cornfusion on my part, which, in reality, ain't all that hard to do! )
btw.....who put the fat, nekkid chick on my desktop? Adams' Apple38632.7912384259

Huh? Adams' Apple38632.7922222222

Stephane,

You are right about it being an issue with SQL Server.

As a programmer, I know all too well about the ' in SQL Queries causing a failier.  And when I coded the majority of the pages for this site, I made sure to account for it.  However, I did not write the code for the Chat Room. Apparently that person didn't account for ' in a user name.

The unfortunate part for Adams' Apple, was that he wasn't getting an error message that he could tell me about, and my site didn't report any errors (again, probably because I didn't write that code).

So, for Stephane and other techies... here's the fix:

strSQL = "SELECT * FROM Users WHERE UserName = '" & replace(strUserName, "'", "''") & "'"

Which causes each single ' to turn into two ' right next to each other like this: ''

That tells the database to use the '' as a single ' in the user name and not as part of the database query command.

Everyone confused now?