| Author |
 Topic  |
|
|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 16 October 2013 : 23:36:33
|
Well, this has been working great but now members are receiving this error message below.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 5.1 Driver][mysqld-5.5.28]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's.jpg' AND A_MEMBER_ID = 7' at line 1
/fp/incAvatarFunctions.asp, line 492
Here are lines 482-504 of my incAvatarFunctions.asp
Function isAvatarMatch(ThisAvatar, ThisUser)
Dim strSql, rsGetMembersAvatar
strSql = "SELECT A_URL "
strSql = strSql & "FROM " & strTablePrefix & "AVATAR "
strSql = strSql & "WHERE A_URL LIKE '%" & avatarFolderPath & privateFolderName & "/" & ThisAvatar & "' AND A_MEMBER_ID = " & ThisUser
Set rsGetMembersAvatar = Server.CreateObject("ADODB.Recordset")
'=== Open Database Connection ===
rsGetMembersAvatar.open strSql, my_Conn, adOpenForwardOnly, adLockReadOnly, adCmdText
'=== Check For A Record ===
Select Case (rsGetMembersAvatar.EOF)
Case True: isAvatarMatch = False
Case Else: isAvatarMatch = True
End Select
'=== Clear Memory ===
rsGetMembersAvatar.Close
Set rsGetMembersAvatar = Nothing
Exit Function
End Function
Any help will be so greatly appreciated!
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
|
MaGraham
Senior Member
USA
1297 Posts |
Posted - 16 October 2013 : 23:44:09
|
Never mind! 
I deleted the last few avatars that had been uploaded and was able to upload a picture to the avatar area now.
A member is saying she can now post from her phone. Could that have caused an error like this?
Gee, I didn't think a member would be able to post from their phone. 
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
 |
|
| |
Topic |
|
|
|
