Ask a Question related to ASP, Design and Development.
-
middletree #1
syntax error in replace statement
What's wrong with this code?
strLongDesc =
Replace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC
rLf,"<br>"),"<",<),"<",>)
Background:
This field is a textarea, and I needed to account for apostrophes, which I
had already done, and replaced line breaks with html line breaks on my page
which displays this stuff. That works fine. But then a user entered this
line, pasted from a log file:
SQL Statement: <SELECT * FROM etc., etc.
Which resulted in an actual dropdown box being displayed, and all the rest
of the description after that point was not displayed. So I tried to put in
code to replace the < and > with a < and > and the code I get when the
page loads is:
Microsoft VBScript compilation (0x800A03EA)
Syntax error
/AddToTicket.asp, line 75, column 106
strLongDesc =
Replace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC
rLf,"<br>"),"<",<),"<",>)
----------------------------------------------------------------------------
-----------------------------^
middletree Guest
-
Syntax error in UPDATE statement.
ok i have an update form that i created it is for the admin of the site to add/edit user account info for memebers to login. the form adds or edits... -
Syntax error in INSERT INTO statement
I have a two table setup in fact I am doing the blog tutorial on Macromedia but with Access and asp I have two tables topic and articles I have a... -
Syntax error in Where Statement
Having a problem with what the server says is a syntax error in the Where statement, but cant figure out where it is. <cfif ... -
Syntax Error Update Statement
Can someone tell me what's wrong with this code? I need help. Thanks! It is an update page. FIRST PAGE: LOGIN CHECK <!--- Filename: ... -
Syntax Error In Update Statement
I'm having a problem getting one piece of code to work on my app. It's a simple password change. For some reason, I've been getting the following... -
middletree #2 Re: syntax error in replace statement
Well, I found the problem with the syntax, but now it simply doesn't work.
Here is my code:
strLongDesc =
Replace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC
rLf,"<br>"),"<","<"),">",">")
and of course, I insert strLongDesc into a field in SQL Server, and when I
open it up in SQL Server, it still shows what I typed into the textarea,
which is <select>, whereas I should see <select>
What am I doing wrong?
"middletree" <middletree@htomail.com> wrote in message
news:OcP6PckmDHA.2732@TK2MSFTNGP11.phx.gbl...Replace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC> What's wrong with this code?
>
> strLongDesc =
>page> rLf,"<br>"),"<",<),"<",>)
>
> Background:
> This field is a textarea, and I needed to account for apostrophes, which I
> had already done, and replaced line breaks with html line breaks on myin> which displays this stuff. That works fine. But then a user entered this
> line, pasted from a log file:
> SQL Statement: <SELECT * FROM etc., etc.
>
> Which resulted in an actual dropdown box being displayed, and all the rest
> of the description after that point was not displayed. So I tried to putthe> code to replace the < and > with a < and > and the code I get whenReplace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC> page loads is:
>
> Microsoft VBScript compilation (0x800A03EA)
> Syntax error
> /AddToTicket.asp, line 75, column 106
> strLongDesc =
>--> rLf,"<br>"),"<",<),"<",>)
> --------------------------------------------------------------------------> -----------------------------^
>
>
middletree Guest
-
Aaron Bertrand [MVP] #3 Re: syntax error in replace statement
(a) you need double quotes around "<" and ">"
(b) how about:
strLongDesc = trim(server.HTMLEncode(Request.Form("LongDesc")))
strLongDesc = replace(replace(strLongDesc,"'","''"),VBCrLf,"<br> ")
"middletree" <middletree@htomail.com> wrote in message
news:OcP6PckmDHA.2732@TK2MSFTNGP11.phx.gbl...Replace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC> What's wrong with this code?
>
> strLongDesc =
>page> rLf,"<br>"),"<",<),"<",>)
>
> Background:
> This field is a textarea, and I needed to account for apostrophes, which I
> had already done, and replaced line breaks with html line breaks on myin> which displays this stuff. That works fine. But then a user entered this
> line, pasted from a log file:
> SQL Statement: <SELECT * FROM etc., etc.
>
> Which resulted in an actual dropdown box being displayed, and all the rest
> of the description after that point was not displayed. So I tried to putthe> code to replace the < and > with a < and > and the code I get whenReplace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC> page loads is:
>
> Microsoft VBScript compilation (0x800A03EA)
> Syntax error
> /AddToTicket.asp, line 75, column 106
> strLongDesc =
>--> rLf,"<br>"),"<",<),"<",>)
> --------------------------------------------------------------------------> -----------------------------^
>
>
Aaron Bertrand [MVP] Guest
-
Aaron Bertrand [MVP] #4 Re: syntax error in replace statement
> when I open it up in SQL Server,
Where in SQL Server? Don't use Enterprise Manager for viewing data (e.g.
Return all rows). It is liable to do all sorts of funky things in order to
present the data to you in a "friendly" way (for some other issues see
[url]http://www.aspfaq.com/2455[/url]). Run a SELECT query in Query Analyzer. Also,
response.write(sql) to make sure the replacements were done.
Another piece of friendly advice: store the statement as is, and use
Server.HTMLEncode when you *retrieve* and *display* it. HTML formatting has
little use/place inside the database.
Aaron Bertrand [MVP] Guest
-
middletree #5 Re: syntax error in replace statement
OK, I've not gotten familiar with HTMLEncode. That will take care of the <
and other characters, then?
I'll try it out. Thanks, very much.
I also never knew that that you said about Enterprise Mgr vs. Query analyzer
in the other post. thanks
"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:eVS8skkmDHA.964@TK2MSFTNGP10.phx.gbl...Replace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC> (a) you need double quotes around "<" and ">"
>
> (b) how about:
>
> strLongDesc = trim(server.HTMLEncode(Request.Form("LongDesc")))
> strLongDesc = replace(replace(strLongDesc,"'","''"),VBCrLf,"<br> ")
>
>
>
>
> "middletree" <middletree@htomail.com> wrote in message
> news:OcP6PckmDHA.2732@TK2MSFTNGP11.phx.gbl...>> > What's wrong with this code?
> >
> > strLongDesc =
> >I> > rLf,"<br>"),"<",<),"<",>)
> >
> > Background:
> > This field is a textarea, and I needed to account for apostrophes, whichrest> page> > had already done, and replaced line breaks with html line breaks on my> > which displays this stuff. That works fine. But then a user entered this
> > line, pasted from a log file:
> > SQL Statement: <SELECT * FROM etc., etc.
> >
> > Which resulted in an actual dropdown box being displayed, and all theReplace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC> in> > of the description after that point was not displayed. So I tried to put> the> > code to replace the < and > with a < and > and the code I get when>> > page loads is:
> >
> > Microsoft VBScript compilation (0x800A03EA)
> > Syntax error
> > /AddToTicket.asp, line 75, column 106
> > strLongDesc =
> >>> > rLf,"<br>"),"<",<),"<",>)
> --------------------------------------------------------------------------
> -->> > -----------------------------^
> >
> >
>
middletree Guest
-
middletree #6 Re: syntax error in replace statement
Well, I tried it exactly as you have it in (b) below, and it didn't work.
Also tried it with double quotes around the <, and it still stored my text
of <select> as <select>, which displayed as a dropdown.
"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:eVS8skkmDHA.964@TK2MSFTNGP10.phx.gbl...Replace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC> (a) you need double quotes around "<" and ">"
>
> (b) how about:
>
> strLongDesc = trim(server.HTMLEncode(Request.Form("LongDesc")))
> strLongDesc = replace(replace(strLongDesc,"'","''"),VBCrLf,"<br> ")
>
>
>
>
> "middletree" <middletree@htomail.com> wrote in message
> news:OcP6PckmDHA.2732@TK2MSFTNGP11.phx.gbl...>> > What's wrong with this code?
> >
> > strLongDesc =
> >I> > rLf,"<br>"),"<",<),"<",>)
> >
> > Background:
> > This field is a textarea, and I needed to account for apostrophes, whichrest> page> > had already done, and replaced line breaks with html line breaks on my> > which displays this stuff. That works fine. But then a user entered this
> > line, pasted from a log file:
> > SQL Statement: <SELECT * FROM etc., etc.
> >
> > Which resulted in an actual dropdown box being displayed, and all theReplace(Replace(Replace(Replace(Trim(Request.Form( "LongDesc")),"'","''"),vbC> in> > of the description after that point was not displayed. So I tried to put> the> > code to replace the < and > with a < and > and the code I get when>> > page loads is:
> >
> > Microsoft VBScript compilation (0x800A03EA)
> > Syntax error
> > /AddToTicket.asp, line 75, column 106
> > strLongDesc =
> >>> > rLf,"<br>"),"<",<),"<",>)
> --------------------------------------------------------------------------
> -->> > -----------------------------^
> >
> >
>
middletree Guest
-
middletree #7 Re: syntax error in replace statement
"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:eg8cFokmDHA.988@TK2MSFTNGP10.phx.gbl...to>> > when I open it up in SQL Server,
> Where in SQL Server? Don't use Enterprise Manager for viewing data (e.g.
> Return all rows). It is liable to do all sorts of funky things in orderAs it turned out, the Query A vs. Ent Mgr were both displying correctly, but> present the data to you in a "friendly" way (for some other issues see
> [url]http://www.aspfaq.com/2455[/url]). Run a SELECT query in Query Analyzer. Also,
> response.write(sql) to make sure the replacements were done.
I will make sure i view the data correctly from now on. But the problem is
that the replace function is not working. I verified this per your
suggestion with the response.write statement. It does just fine with the
<br> and quotes. Very puzzling and frustrating
has>
> Another piece of friendly advice: store the statement as is, and use
> Server.HTMLEncode when you *retrieve* and *display* it. HTML formatting> little use/place inside the database.
>
>
middletree Guest
-
Aaron Bertrand [MVP] #8 Re: syntax error in replace statement
Then my guess is there are no < or > characters for replacement? Compare
this to the completed SQL statement:
Response.write(request.form("whatever_the_variable _was"))
"middletree" <middletree@htomail.com> wrote in message
news:#SAj7$kmDHA.2424@TK2MSFTNGP10.phx.gbl...(e.g.> "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> news:eg8cFokmDHA.988@TK2MSFTNGP10.phx.gbl...> >> > > when I open it up in SQL Server,
> > Where in SQL Server? Don't use Enterprise Manager for viewing dataAlso,> to> > Return all rows). It is liable to do all sorts of funky things in order> > present the data to you in a "friendly" way (for some other issues see
> > [url]http://www.aspfaq.com/2455[/url]). Run a SELECT query in Query Analyzer.but>> > response.write(sql) to make sure the replacements were done.
> As it turned out, the Query A vs. Ent Mgr were both displying correctly,> I will make sure i view the data correctly from now on. But the problem is
> that the replace function is not working. I verified this per your
> suggestion with the response.write statement. It does just fine with the
> <br> and quotes. Very puzzling and frustrating
>
>> has> >
> > Another piece of friendly advice: store the statement as is, and use
> > Server.HTMLEncode when you *retrieve* and *display* it. HTML formatting>> > little use/place inside the database.
> >
> >
>
Aaron Bertrand [MVP] Guest
-
middletree #9 Re: syntax error in replace statement
Well, had typed:
<select>
into the textarea, and verified that this is what went in, both by
response.write, and looking into SQL Server.
"Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
news:utW7lClmDHA.2772@TK2MSFTNGP10.phx.gbl...order> Then my guess is there are no < or > characters for replacement? Compare
> this to the completed SQL statement:
>
> Response.write(request.form("whatever_the_variable _was"))
>
>
>
>
> "middletree" <middletree@htomail.com> wrote in message
> news:#SAj7$kmDHA.2424@TK2MSFTNGP10.phx.gbl...> (e.g.> > "Aaron Bertrand [MVP]" <aaron@TRASHaspfaq.com> wrote in message
> > news:eg8cFokmDHA.988@TK2MSFTNGP10.phx.gbl...> > > > when I open it up in SQL Server,
> > >
> > > Where in SQL Server? Don't use Enterprise Manager for viewing data> > > Return all rows). It is liable to do all sorts of funky things inis> Also,> > to> > > present the data to you in a "friendly" way (for some other issues see
> > > [url]http://www.aspfaq.com/2455[/url]). Run a SELECT query in Query Analyzer.> but> >> > > response.write(sql) to make sure the replacements were done.
> > As it turned out, the Query A vs. Ent Mgr were both displying correctly,> > I will make sure i view the data correctly from now on. But the problemformatting> > that the replace function is not working. I verified this per your
> > suggestion with the response.write statement. It does just fine with the
> > <br> and quotes. Very puzzling and frustrating
> >
> >> > >
> > > Another piece of friendly advice: store the statement as is, and use
> > > Server.HTMLEncode when you *retrieve* and *display* it. HTML>> > has> >> > > little use/place inside the database.
> > >
> > >
> >
>
middletree Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
