[devtalk] ASP help

[Robert Hoenig]

Check the modified dates of the files in production.  Unfortunately you
really can't tell who's working on them unless you have some sort of source
control for them. 

-----Original Message-----
From: devtalk-bounces at lists.preshweb.co.uk
[mailto:devtalk-bounces at lists.preshweb.co.uk] On Behalf Of Portman
Sent: Tuesday, October 27, 2009 6:24 AM
To: New home for the wdvltalk community
Subject: Re: [devtalk] ASP help

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