Can anyone help me with this issue I am having right now? Here is the script I am having difficulty with...what it is doing is extracting the point total from a member defined in the dUser Input Row
Else sPointsSQL = "select M_POINTS from " & strTablePrefix & "MEMBERS " & _ " where M_NAME='" & Request.Form("dUser") & "'" rsPoints.open sPointsSQL, oActiveConnection, 1, 3, 1 If rsPoints Then dUserPoints = rsPoints("M_POINTS") End If rsPoints.Close set rsPoints = nothing if len(dUserPoints&"")=0 then dUserPoints= 0 else dUserPoints = cint(dUserPoints) end if getUserPoints = dUserPoints If cint(WealthAmount) > (getUserPoints) Then
Edited by - TStewartFan on 20 January 2005 20:12:34
Ehm...I guess it's not working? Or do you need an addition? Or do you need to know where to place it? Please be specific, that way the experts will help you faster.
It doesn't pull and save any data from the database. I am trying to pull the Total Amount of Points in for the client side entered Member Name...but it isn't pulling anything. Here is a simple example: Two Fields: a text field and a submit field. Click the submit button and the input info is sent to the db and validated that this is a valid member. I am trying to not only validate the user but also pull the Points Total for that particular user so I may use that information elsewhere throughout the script. But for some reason it ain't working. I have looked over the code...over and over...and can't see why it wouldn't. Thought a fresh pair of eyes could help.