Snitz Forums 2000 - getting member

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Community Forums

Code Support: ASP.NET (Non-Forum Related)

getting member_ID

New Topic

Topic Locked

Printer Friendly

Author

Topic

Alfred
Senior Member

USA
1527 Posts

Posted - 11 December 2003 : 22:13:24

I wrote:

quote:
strSql = "select MEMBER_ID from FORUM_MEMBERS WHERE M_NAME = " & myPoints("commander") & ""
set myCOMMANDER = my_Conn.Execute(strSql)

I verified that the variable for commander is present, but I get this error:

quote:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/BG/forums/Admin_Games_update_handler.asp, line 236

What am I doing wrong?

Alfred
The Battle Group
CREDO

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 11 December 2003 : 22:16:09

strSql = "select MEMBER_ID from FORUM_MEMBERS WHERE M_NAME = '" & myPoints("commander") & "'"

Bits in red are what your missing.

Kiwihosting.Net - The Forum Hosting Specialists

Edited by - Gremlin on 11 December 2003 22:16:42

Alfred
Senior Member

USA
1527 Posts

Posted - 11 December 2003 : 22:26:21

Thanks, Gremlin!
When will I remember this?!

Alfred
The Battle Group
CREDO

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 11 December 2003 : 22:30:48

Write things down that you regularly have problems with in a notebook so you can refer back to them, I used to do that for years until things finally "stuck" in my head.

Kiwihosting.Net - The Forum Hosting Specialists

Alfred
Senior Member

USA
1527 Posts

Posted - 11 December 2003 : 22:43:20

Good idea, thanks.
Of course, the notebook would be rather big in my case!

Alfred
The Battle Group
CREDO

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.16 seconds.