[devtalk] ASP help

[Portman]

Update - I got an email from the website owner today to tell me that an 
error is popping up on the main website. The strange thing is that I 
have been working only on the test site. Is there a way to find out if 
someone is messing with the site? I suspected as much when the sign up 
suddenly stopped working, but how can I tell for sure?

TIAA,
Riva

Rich Hanson wrote:
> 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
>>
>>     
>
> _______________________________________________
> devtalk mailing list
> devtalk at lists.preshweb.co.uk
> http://lists.preshweb.co.uk/mailman/listinfo/devtalk
>
>