Snitz Forums 2000 - M

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Help Groups for Snitz Forums 2000 Users

Help: General / Classic ASP versions(v3.4.XX)

M_Sex problem

New Topic

Topic Locked

Printer Friendly

Author

Topic

philsbbs
Junior Member

United Kingdom
397 Posts

Posted - 19 March 2005 : 10:36:36

Hi,

For some reason the following code will note pick up only members that have M_SEX = Male
===================================================================
'## Forum_SQL - Find all records with the search criteria in them
strSql = "SELECT " &strMemberTablePrefix & "MEMBERS.M_SEX, "&strMemberTablePrefix & "MEMBERS.M_HANDLE, "&strMemberTablePrefix & "MEMBERS.M_FIRSTNAME, " &strMemberTablePrefix & "MEMBERS.M_LASTNAME, "&strMemberTablePrefix & "MEMBERS.M_COMMENTS "
strSql = strSql & " FROM " &strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_SEX = Male "
strSql = strSql & "ORDER BY " & strMemberTablePrefix & "MEMBERS.M_SEX ASC"
===================================================================

If I remove the where line the report will fine.

What is wrong ??

I've I query the database via sql :

SELECT FORUM_MEMBERS.MEMBER_ID, FORUM_MEMBERS.M_SEX
FROM `Z:\phil\leamington`.FORUM_MEMBERS FORUM_MEMBERS
WHERE (FORUM_MEMBERS.M_SEX='Male')

There is no problems.

Can anyone help.

Phil

chumbawumba
Junior Member

United Kingdom
304 Posts

Posted - 19 March 2005 : 11:13:03

don't you need delimiters (') like in your second example?

strSql = strSql & " WHERE " & strMemberTablePrefix & "MEMBERS.M_SEX = 'Male' "