Escape Asp Tags
Is it possible to escape asp tags so i can add em to another variable like this:
text = "<% downloads="&cats&" %>"
ADVERTISEMENT
Escape SQL
I working on a ASP project (usually I'm a PHP guy) and I wanted to encode a string to make it safe for a SQL insert. Is there a function built into ASP for that or do I just need to replace single quotes?
View Replies View RelatedEscape Charters?
the problem is in database the name of customer displays like
%mike O' lee but user want to see name like mike O lee.
How can i do it in asp script.
ESCAPE CHARACTER
I'm having a problem finding/using an escape character with this ASP/JScript application I'm creating. Basically I have text sometimes that has apostrophes or double quotations in them, but they won't be INSERTED unless I manually take them out.
Ex: INSERT INTO tbl1 (vendor,reason) VALUES (81,"This is only a test, but there is an apostrophe and it's only going to make things worse.")
That apostrophe in "it's" is kiling everything. I've used the replace method to change it to " ' ", but that STILL doesn't work. I can't find MS SQL's ESCAPE CHARACTER. I've tried several directions of the backslash, but no luck.
Escape Character??
I am trying to only have a link show if there is a certin value in the DB. This is what I am trying:
<% if (rsWelcome.Fields.Item("access_level").Value) = "admin" then
response.Write("| - <a href="sps_main.asp">Sales Training Support </a>-")
end if %>
BUT... this is the error I get:
Expected ')'
/sta/topnav_test.asp, line 9 response.Write("| - <a href="sps_main.asp">Sales Training Support </a>-") How do I use quotes in a "response" and have the app server ignore them??
EncodeURIComponent Vs. Escape
I've a problem reading querystring parameters that are 'uri encoded'. Anyone
has a solution for this?
To reproduce the problem, create a classic ASP containing the following code:
-----------------------
<p>Value sent via querystring: <%=
Server.HTMLEncode(Request.QueryString("value")) %></p>
<input id="input" />
<button id="submit" onclick="window.location.assign('Test.asp?value=' +
encodeURIComponent(input.value));">submit</button>
-----------------------
Now, enter the value "Dré" and submit. The page will show the value "Dré",
but I except Request.QueryString("value") to return the original value, i.e.
"Dré".
Escape Quotes
I'm still having trouble getting some of my data being returned properly when people use quotes. (ex ProjectName contents being - the "primary" project - The double quotes are the main issue. I am using a function for the single quote and it seems to have resolved the issue.
Code:
Term = trim (Term)
if Term <> "" then
Term = Replace (Term, chr (39), chr (39) & chr (39))
end if
If Term <> "" then
I use this just when passing strings from a form. I tried altering it and using chr (34) for a double quote but it didn't work.
Escape Characters
When chucking data in cookie you cannot use certain characters in this example ‘ : ‘ . To get around this you use escape and unescape. Trying to use the escape as such:
Response.Cookies("Lines")("URL4") = escape("http://www.ASP101.com")
Gives the following result:
URL4=http%3A//www.ASP101.com
Which I don't think does anything to help. So using it like this:
Response.Cookies("Lines")("URL4") = "escape(http://www.ASP101.com)"
Gives the following result:
URL4=escape(http://www.ASP101.com)
Which is the correct result apart from the ‘escape' actually appearing.
Escape Characters Like "
im tryin to do this:
response.write("<body topmargin='0' leftmargin='0' onLoad='window.resize('" & width & "', '" & height & "')'>")
i need to run it like this though:
response.write("<body topmargin='0' leftmargin='0' onLoad="window.resize('" & width & "', '" & height & "')">")
in php i can replace it like onLoad = "window.resize
is there something like that in asp?
Escape Char Information
is escape char in asp script and how we can encode the url in asp script?
View Replies View RelatedFunction To Escape SQL Strings
I've been looking for it for a while. I found it a week back by accident, but didn't need to use it then. It's a function that escapes SQL strings so that if there is a ' in the string it will escape it for you. I can remeber the name of it.
View Replies View RelatedASP Double Quote Escape
Here's the line I need to insert into an ASP page.
<script Language="JavaScript" src="/blarg.js"></script></head>
Right now it throws off the asp include with the quotes.
How Does One Escape The & Character In Oracle?
Info
DB: Oracle(9i), where I generate query strings programatically and send them to the DB server.
I have rtfm'd and googled this extensively, but I have not found how to properly esacape the ampersand character in an oracle query (I'm NOT using the SQL+ command line interface).
Oracle uses the & character to denote a variable substitution, and unfortunately one of the fields I must query has data that contains the & character. I need to know how to escape the & character in my query strings so that Oracle will treat it as a string literal. Code:
Auto-escape INSERT Statement
I have a 'memo' form field being entered into an access database.If people put in characters other then text (Quotes, operators, etc) then I get an insert error:
----
User Input: oh let's see - a va
Error:
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression ''oh let's see - a va', 'No additional comments submitted')'.
----
Is there a way to get this into the database? In php, I would simply use the function 'addslashes()' (escaping the string) - is there a similar function in ASP or am I doing something else wrong?
Access INSERT Escape Character
I am inserting records into an Access table using the OleDbCommand class. The insert values come from a basic web form with text boxes. If the values contain ' or " it creates a problem. What is the proper way to escape these characters? Surely there's a built-in function for it somewhere.
View Replies View RelatedMp3 Tags
Is it possible to edit mp3 tags? If I rip my CD to mp3 files, can I use ASP to edit the album,artist, year, title, etc information based on the data I store on my own SQL Server?
Images And ALT Tags
Does anyone know how I can place ALT tags on images which are driven by ASP and a database. (So each image has a separate alt tag).
e.g.
This is a image of a ball
This is a image of a Boot
Reading Mp3 ID3 Tags?
i was wondering if any one could give me some info on how to get mp3 ID3 tags in ASP?
I've seen it done, but don't really have any idea how,
just looking for info like song lenth, bitrate, and so on.
Reading DIV Tags
I have a function in ASP and I want to read a DIV tag. Any ideas? I know
the syntax but when I apply it, doesn't work.
INPUT Tags
I have found that places double quotes ' "text" ' around text inside (INPUT) tags results in everything after the initial quote, '"' gets truncated.
I'm passing the form information to another form to allow the user to look over and validate what they're submitting, then they will click the submit
button to send it all along.
I'm finding that in the validation form, the quoted text inside the (INPUT) tag gets truncated. However, the quoted text inside a TEXTAREA tag does not.
ASP In Body Tags
i've got a problem with asp tags in the <body>.Looks like this:
<body <%if len(request.form("field1")) > 0 AND len(variable1) > 0 then %>onload="javascript:testSite1();"<% elseif len(request.form("field2")) > 0 AND len(variable2) > 0 then %>onload=":javascript:testSite2();"<% end if%>>
Now is on the top of my site written: 0 AND len(variable1) > 0 then %>onload="javascript:testSite1();" 0 AND len(variable2) > 0 then %>onload="javascript:test and the caption is not on the top of the site!
Custom Tags
i have a table that users are inserting custom tages ,it looks like :
user_id type value
1 99 television
2 98 beach
3 99 coldplay
etc.
now i have to make a search which will show all the users that typed the same value from the same type .i dont want the query to be a textual query (slow ...)what is the right way to do it ?how can i make a query that JOINs to tables from 2 different databases?
Nesting Of <% %> Tags
can I nest <% %> tags?
This is what I want to do:
This statment
<td width="<%response.write span%> %"><img src=<% response.write "'/images/" & trim(records.Fields("c1_image")) & "'" %> height=100>
Generates this HTML code
<td width="16%"><img src='/images/rlm04.bmp' height=100>
SO FAR , SO GOOD...
This statement:
<% response.write "(" & """" & "c" & i & "_image" & """" & ")" %>
generates this:
("c1_image")
CAN YOU SEE WHERE I'M GOING WITH THIS?
I need the field name in my records.fields statement to be avariable based on a loop counter....NESTED <% %> tags, or response.write or whatever.
META Tags...
I want to my site be searchable by Internet search engines such as: Google, Altavista, Yahoo, Lycos...
Because that, I've putted four META tags: author, robots, keywords and description into my .asp page...
However, my searching by keywords I've putted in doesn't work... In other words, I've got nothing which in connection with my site... Would you be so kind to advise me how to do that and what's wrong with my approach... My META tags section is Code:
Using Span Tags
I have 4 response writes in a row and I want to distinguish between them better, so I want to wrap them in a span tag. What is the correct syntax. Code:
Response.Write (rsGlogbook("Thedate"))
Before
Code:
Response.Write (<span class=""post-date"">rsGlogbook("Thedate")</span>)
After, but it didnt work.
Data Between Two Tags
I want print the text between two tags. I have seen this function by kodkrash in the "funky functions" topic.it works great when you use something like:
<title>text</title>
but it doesn't work if you use something like
<td id="yada">
loem ipsum........
amet...
</td>
are there any way of printing this text between such tags.
Dynamic # Of Asp:Image Tags?
I have the following code:
while (sqlDR.Read())
{
lblImages.Text += "<a href="" + strCMSImageDir + sqlDR["picture_url"].ToString() + "">" +
"<img src="" + strCMSImageDir + sqlDR["picture_thumbnail_url"] + "" /></a>";
}
Which generates the following HTML:
Code:....
Convert HTML Tags
i wanna convert the HTML tags in the Textarea with help of the ASP code. Means i m getting some value form DB which comes in the format of
------------
this is text <br><br><ul><li> list-1 value</li><li>list-2 val</li></ul>
------------
i wanna conversion of the above text in textarea
Filter HTML Tags
I need to know if there is a standard aproach in ASP ( or any other ) to filter HTML tags. I mean, filter any cross-site scripting code.
View Replies View RelatedRemove The Content In Between Tags
How can I remove the content in between tags? I have a page that has
several custom tags: <!--tag:1--> Content 1 <!--/tag:1--> <br>
<!--tag:2--> Content 2 <!--/tag:2--> <br> <!--tag:3--> Content 3
<!--/tag:3--> If I only wanted to see the contents of tag 2 for
example, how could I strip out 1 and 3?
Filter HTML Tags
I have constructed a simple guestbook application using ASP and a SQL server backend. My problem is that when a person post a message and it displays on the site, if they paste HTML code or any other scripting languages in there, it will post and execute on the site which is what I don't want to happen.
Is there a way or a script out there using ASP that when the user post the message it will scan for key scripting tags and filter them out?
Creating Meta Tags
I would like one of my clients to dynamically insert meta/title tags into their ASP driven site. Caveat, I am no webmaster, but rather a more ecommerce oriented consultant. I know this can be easily accomplished. But, their webmaster claims it isn't possible.
View Replies View RelatedFilter Html-tags
im building a small messageboard and i want to filter all html-tags except these ones:
<b> <i> <img.........> <font....>
how to build such a reg exp pattern?