| Author |
 Topic  |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
 Posted - 03 August 2008 : 06:21:36
|
I am getting this error,
Can anyone help me with it?
quote:
Current:
Max: 2
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.22-log]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 'sDownloads.gif' AND A_MEMBER_ID = 2' at line 1
/incAvatarFunctions.asp, line 492
< |
|
|
Carefree
Advanced Member
Philippines
4222 Posts |
Posted - 03 August 2008 : 08:44:20
|
| Educated guess: you don't have the path for the avatars configured correctly.< |
 |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 04 August 2008 : 01:28:38
|
| Well its always worked before and nothing has been changed, anyone know what the path should be so I can check?< |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 21 August 2008 : 18:07:08
|
| I dont like to bunp my own posts, but can anyone help me with this?< |
|
|
|
Etymon
Advanced Member
United States
2396 Posts |
Posted - 21 August 2008 : 18:44:59
|
Are both the member id and the image still in the database?
Do this:
Add the following below this code:
strSql = strSql & "WHERE A_URL LIKE '%" & avatarFolderPath & privateFolderName & "/" & ThisAvatar & "' AND A_MEMBER_ID = " & ThisUser
Response.Write "<br>"
Response.Write "avatarFolderPath = " & avatarFolderPath & "<br>"
Response.Write "privateFolderName = " & privateFolderName & "<br>"
Response.Write "ThisAvatar = " & ThisAvatar & "<br>"
Response.Write "ThisUser = " & ThisUser & "<br>"
Response.Write "strSql = " & strSql & "<br>"
Response.End
The above will tell you what each variable's value is.
Below is the code you are working with, right?
' =======================================================================
' === Checks Current Avatar in DB for Current Record ===
' =======================================================================
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< |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 23 August 2008 : 12:23:54
|
| Oh I have no idea what the avatar is, I have not got an avatar set up on my account.< |
|
|
|
Carefree
Advanced Member
Philippines
4222 Posts |
Posted - 23 August 2008 : 14:09:57
|
| The inclusion of the @ sign in the filename indicates a email address. Poor thing is probably confused.< |
|
|
|
thelodger
Junior Member
United Kingdom
296 Posts |
Posted - 23 August 2008 : 14:59:17
|
| Yeah, I found the file via ftp, problem is, when I try to delete it, it says the file isn't there, so I deleted all of them, now its showing 4 files as above but slightly diferent, and even though there are showing in the folder when I try to delete them via ftp, it just says file(s) not found, this has got me totally stumped, anyone have any ideas?< |
|
|
| |
Topic |
|
Topic Locked
