Classic ASP Discussion - Why doesnt this work?

Print Page | Close Window

Why doesnt this work?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1148
Printed Date: 29 March 2026 at 5:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Why doesnt this work?

Posted By: Dazz
Subject: Why doesnt this work?
Date Posted: 19 March 2003 at 10:28am

This line wont work to get info from my login database strProfileName has being assigned a value so thats not the problem.

strSQL = "SELECT tblUsers.* FROM tblUsers WHERE tblUsers.UserName = " strProfileName ";"

What do i need to change?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 19 March 2003 at 10:36am

strSQL = "SELECT tblUsers.* FROM tblUsers WHERE tblUsers.UserName = '" & strProfileName & "';"

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting