Web Wiz NewsPad - Error in DELETE_ACCOUNT.ASP

Print Page | Close Window

Error in DELETE_ACCOUNT.ASP - mysql version

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz NewsPad
Forum Description: Support forum for the Web Wiz NewsPad application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27002
Printed Date: 29 March 2026 at 4:23am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error in DELETE_ACCOUNT.ASP - mysql version

Posted By: jack24
Subject: Error in DELETE_ACCOUNT.ASP - mysql version
Date Posted: 17 February 2009 at 10:03pm

in line 74, if the database is mySQL, exist a error:

'Initalise the strSQL variable with an SQL statement to query the database

strSQL = "SELECT TOP 1 " & strDbTable & "Members.* " & _

"FROM " & strDbTable & "Members " & _

"WHERE " & strDbTable & "Members.ID_Code = '" & strUserID & "';"

change for

strSQL = "SELECT " & strDbTable & "Members.* " & _

"FROM " & strDbTable & "Members " & _

"WHERE " & strDbTable & "Members.ID_Code = '" & strUserID & " LIMIT 1;"