[thelist] Asp - the case of single quote that wouldn't die...

Tab Alleman talleman at Lumpsum.com
Wed Dec 5 14:00:55 CST 2007


I don't see anything that would cause it.

1)  What does the include call and the stuff around it look like?
2)  Have you found the single quotes in your HTML source being outputted?   Are they near anything else that might yield any other clues?

> -----Original Message-----
> From: thelist-bounces at lists.evolt.org
> [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Paul Bennett
> Sent: Wednesday, December 05, 2007 2:52 PM
> To: thelist at lists.evolt.org
> Subject: [thelist] Asp - the case of single quote that wouldn't die...
> 
> 
> Hi all,
> 
> I'm an ASP noob and encountered the weirdest error last night 
> (still unresolved). Basically when I include a file, I get 2 
> single quote characters (' ') being outputted.
> 
> It only happens with one particular include (code included at 
> the end of this email). The code is very simple and doesn't 
> include any response.write() calls, so I can't for the life 
> of me figure out what is causing this.
> 
> *Any* suggestions welcome:
> (includes/memidcheck.asp)
> -----
> <%
> 
> If IsNumeric(Request.Form("memID")) = False Then
>   error = "Member ID must be a number"
> Else
>   
>   set conn=Server.CreateObject("ADODB.Connection")
>   conn.Provider="Microsoft.Jet.OLEDB.4.0"
>   conn.Open "C:\\[path info removed]\\Database\\MemData24.mdb"
>   
>   strQuery = "SELECT * FROM MemDB WHERE NUMBER = " & 
> Request.Form("memID")
>     
>   Set RS = conn.Execute(strQuery)
>   
>   record = 0
>   while not RS.EOF
>     record = 1
>     
>     txndata2 = RS.fields(1) & ", " & RS.fields(2)
>     RS.MoveNext
>    
>   wend
>   
>   Rs.Close
>   Set Rs = Nothing
>   conn.Close
>   Set conn = Nothing
>   
>   
> End If
> %>
> 
> Regards,
> Paul
> -- 
> 
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
> 
> For unsubscribe and other options, including the Tip Harvester 
> and archives of thelist go to: http://lists.evolt.org 
> Workers of the Web, evolt ! 
> 



More information about the thelist mailing list