Joel Adams
C3VR Lifetime Member #56
My Link
(click for Texas-sized view!) NCRS
"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
Sounds like your pop up is blocking or your fire wall is restricted.
-Adam Wartell
NCM Lifetime Member #1222
Founder: C3 Vette Registry
C4 Vette Registry, C6 Vette Registry
My first Vette, now owned by JB79:
Joel Adams
C3VR Lifetime Member #56
My Link
(click for Texas-sized view!) NCRS
"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
Joel Adams
C3VR Lifetime Member #56
My Link
(click for Texas-sized view!) NCRS
"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
Joel Adams
C3VR Lifetime Member #56
My Link
(click for Texas-sized view!) NCRS
"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"
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?
-Adam Wartell
NCM Lifetime Member #1222
Founder: C3 Vette Registry
C4 Vette Registry, C6 Vette Registry
My first Vette, now owned by JB79:
Joel Adams
C3VR Lifetime Member #56
My Link
(click for Texas-sized view!) NCRS
"Money can't buy happiness -- but somehow it's more comforting to cry in a CORVETTE than in a Kia"