[devtalk] ASP help

[Rich Hanson]

The main problem as Robert points out is that you are setting the 
setting the input email address into variable SSNum but then querying 
using strEmail.

Replace all references to SSNum with strEmail and it should work.

  strEmail = Request.Querystring("email")
  response.write Request.Querystring("email")
  if RegEx.Test(strEmail) = TRUE then
     strEmail = Replace(strEmail, "<","")
     strEmail = Replace(strEmail, ">","")
     Response.Write strEmail & " - TRUE"
     response.write "True"
   end if
   if RegEx.Test(strEmail) = FALSE then
     response.write "False"
   end if
   Set RegEx = NOTHING

Something to understand about ASP is that you're writing your code (most 
of the time) in VBScript and using ASP Objects. For database access you 
are using ADO objects.

Microsoft has a online reference for VBScript here
http://msdn.microsoft.com/en-us/library/t0aew7h6%28VS.85%29.aspx



Robert Hoenig wrote:
> The first thing I see is your setting the SSNum variable with Email but your
> querying on strEmail?  The second thing would be remove the
> rsCheckEmailH.BOF and just use rsCheckEmailH.EOF.  I think if you change to
> populating strEmail instead of SSNum.
> 
> I've found this site very useful when doing ASP
> http://www.asp101.com/samples/
> 
> -----Original Message-----
> From: devtalk-bounces at lists.preshweb.co.uk
> [mailto:devtalk-bounces at lists.preshweb.co.uk] On Behalf Of Portman
> Sent: Monday, October 26, 2009 8:33 AM
> To: New home for the wdvltalk community
> Subject: Re: [devtalk] ASP help
> 
> Can you point me to some documentation? I'm learning as I go and want to
> make sure I don't mess anything up.
> 
> Thanks,
> Riva
> 
> David Precious wrote:
>> A stored procedure is almost certainly overkill and unnecessary 
>> complexity for what Riva needs; simply doing the queries properly, 
>> passing values via bind parameters rather than simply interpolating 
>> vars into the SQL will take care of it perfectly well.
> _______________________________________________
> devtalk mailing list
> devtalk at lists.preshweb.co.uk
> http://lists.preshweb.co.uk/mailman/listinfo/devtalk
> 
> _______________________________________________
> devtalk mailing list
> devtalk at lists.preshweb.co.uk
> http://lists.preshweb.co.uk/mailman/listinfo/devtalk
>