Passing Quotes In A URL Call

I want to dynamically build a call to another asp page and include some
parameters as part of the call. The basic format of the call is something
like::

"<a href='mypage.asp?id=" & theid & "&location='" & thelocation &
"'>GO</a>"

where there is a single quote followed by a double quote following the
...location=... and vica-versa after the variable

My problem is that the variable thelocation can include a single quote or a
double quote. I tried Server.URLEncode and that didn't work. I got a string
that ended up causing a Page Not Found (it encoded the dot in the page name
and that didn't work)

How can I encode the data so that quotes will be accepted in this type of
call?

View Replies


ADVERTISEMENT

Quotes

Can someone help me my quotes in LISTING 2 below? LISTING 1 works fine in
HTML, but I'm having trouble with quotes in LISTING 2 near the javascript
code when trying to response write the entire button code.

LISTING 1: HTML
<INPUT TYPE=BUTTON VALUE="<< Previous <%=iMaxRecords%> Records"
ONCLICK="document.location.href='paging.asp?iPage=<%=iPage-1%>'">

LISTING 2: ASP
Response.Write "<INPUT TYPE=BUTTON VALUE=<< Previous" & iMaxRecords &
"Records ONCLICK="document.location.href=""paging.asp?iPage=" & (iPage -1) &
""">"

View Replies View Related

Quotes In SQL DB

I have a product description in an sql database.which looks like this Do's and Dont's.When i pull it to look at it on the screen it displays fine.But now when i go to move that into another database for the order it only displays Do in the other table. Which means its cutting everything off from the ' forward.Ive tried just about everythign to my knowledge adn i still cannot get this to work.

View Replies View Related

Fix Quotes

help with the fix quotes? For example, I have persons name as Jo'Mario entered as text in a text box, I need to text to go clean without any error because I am generating an error as follows:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

And I think it is due to single quote I am using in the text box.I know there is a coding to fix this problem but not sure of it.

View Replies View Related

Quotes 2

Below in GOOD CODE, I have a mix of ASP/HTML that works. I'm trying to convert the code into all ASP, but I'm failing in BAD CODE. The single quotes are very hard to master.

BAD CODE:

sHTML=sHTML & "bgcolor=" & tblcolor & style=""cursor:default;""
onMouseOver="this.bgColor=""'#e6e6e6'"" onMouseOut="this.bgColor='" &
tblcolor & "'"

GOOD CODE:

<%
If sPageType = "forum" Then %>

bgcolor="<%= tblcolor %>" style="cursor:default;"
onMouseOver="this.bgColor='#e6e6e6'" onMouseOut="this.bgColor='<%= tblcolor
%>'"

<% End If %>>

View Replies View Related

Stock Quotes

I'm currently writing a custom financial app that tracks stock purchases and
values. however, I need help in retrieving stock quotes from the internet. A
20 minute delayed quote is fine. I do not want to revert to "page or screen
scraping".

View Replies View Related

Removing Quotes

I have successfully taken over a number of variables from a .csv file and put them into an .asp page. Unfortunately the .csv file has all these variables enclosed in double quotes i.e "Hello" and appear this way on the .asp page. Is there anyway of removing the double quotes (") from the beginning and end of the variables?
I have tried splitting the individual variables on the " with this
sSeg2 = Split( var1, """ )

but this brings an error..

Unterminated string constant
/iq/groupama/chamber/test3.asp, line 74, column 26
sSeg2 = Split( var1, """ )

View Replies View Related

Need Double Quotes

I am pulling data from a table to create a <select> list. I need to wrap the value= in double quotes. Code:

View Replies View Related

Stripping Out Quotes

My ASP page allows user to enter comments into a form. To avoid
errors I'm having to strip out double quotes before saving to the
database. Is there anyway to encode these so that I can store them
instead, in the way was an URLEncode works?

View Replies View Related

Strings With Quotes In

< input type=text name="PageTitle" id="PageTitle"
value="<%=strPageTitle%>" >

How do I "escape" any quotes, accidental carriage returns etc that are
contained within strPageTitle? Do I have to use a series of replace()
functions, or is there a cunning way that makes it OK?

(Using escape(strPageTitle) fills the box with % signs...)

View Replies View Related

Double Quotes Tag

I have an asp page.I have all the form tags, javascripts etc in that. For e.g In my asp page I have mentioned my form tag as

<form name=frmupdateskill method=post>

and javascript as

<script language=javascript>
some code...
</script>

I send this asp page to my onsite person. When he replaces the old asp page with the one I sent the following are the things I come across. Code:

View Replies View Related

Quotes With Textbox

First Question:

When I try the fallowing I get an error message:

Field1 = Replace(Field1, """, "& quote")

Second Question:

I have some info stored on Access DB, when i pull it for updates I should print the data as fallow:

<input type="text" name="Field1" value="<%= RS ("Field1") %>" size="20">
All that well and good but the problem occur when "RS ("Field1")" contain a double quote!

Let's say I have:

RS ("Field1") = Hi "guys"....

View Replies View Related

Single Quotes

I've got an HTML page with a series of links that are intended to search a category listing in a database.

for example

link 1 has a querystring of "?subid=Boats"
link 2 has a querystring of "?subid=Cars & Trucks"
link 3 has a querystring of "?subid=Men's & Women's Outerwear"
etc

As long as the subid doesn't contain any single quotes or any special characters such as the "&", my SQL works ok and the records are retrieved. 'm using Request("subid") to get my querystring value.Is there any way I can escape the single quotes or other special characters in the Request("subid") so it won't break the SQL?

View Replies View Related

Quotes In Forms

What is the best way to deal with quotes inside form data that a user is submitting to my page?It screws up my editing feature,in which I'm using a SQL string to edit the data.Adding works with the quotes,as I'm using .addnew for new records.

View Replies View Related

Quotes In A Hyperlink

I just want to write a hyperlink in ASP. getting many errors . can anyone please help me with this.

Response.Write("<font size=2 face=arial><A Class=TableLink href = "
link://cs-dev.verizon.com/cs/aa.asp?K=123&srcserver=Cs" & "onMouseOver=" & """" & "window.status='Case';return true" & """" & "onMouseOut=" & """" & "window.status='';return true" & """" & ">Case:</A></font></td>")

View Replies View Related

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.

View Replies View Related

Quotes From Database

I have a form that asks for the size of a particular object. Sometimes the size is 4" X 8". The problem that arises is when the record is pulled back from a database to a textbox in a form; I get an error with HTML.

I try and place the 4" X 8" into a text box, like <input type="text" name="size" value="4" X 8""> Is there something I can do in ASP to keep this from happening after the client receives the data?

View Replies View Related

Stock Quotes

Does anyone know how to implement a stock quote using ASP on a website? Any sample code or components, etc.

View Replies View Related

Understand Quotes Better

As I get further and further into ASP/VBscript I realize I just don't undertstand how to properly use single/double quotes at the same time. This is really holding me back. If anyone can help me understand this better or know some good articles I would appreciate it. My current problem is adding a logo to my page from the database. What quotes are needed inside my <img> tag. Code:

<img src="/teams/logos/"'"<% response.Write rs("Logo")%>"'"> .

View Replies View Related

Double Quotes

I'm trying to pass data from a <textarea> box to a confirmation page and then pass the same information from the confirmation page to a final page.

When the information gets passed to the final page it is truncating it where there are double quotes. I've tried to do a replace() function to try and escape the quotes out but it's not working.

confirmation page

Code:

<input type="hidden" name="results" value="<%=results%>" />

final page

Code:

results = request.form("results")
results = replace(results,""","""")
results = replace(results,vbcrlf,"<br />")

View Replies View Related

Single Quotes ( ' )

Access 2000 doesn't allow single quote when updating records from the webpage. If the user need to insert for example the name O'neil in a field it will create this error:

Syntax error (missing operator) in query expression ''O'neil', r_add1 ='Auburn', r_add2 =' ', r_city ='AUBURN', r_state ='WA', r_zip ='98001' WHERE r_id =279'.

Is there a script I can use to accept the single quote as part of a string of characters?

View Replies View Related

Converting Smart Quotes, Etc.

I've got a situation where I need to be able to replace "smart quotes" and similar characters that are created (presumably) by Microsoft Word. If you don't already know, smart quotes are those "curly quotes" that curl or angle in toward the text on each side. Here is an example, though I'm not sure how it will display in a browser: “

I thought I had just used a standard replace function in the past for these things, and that seemed to work when the text was coming from a form. However, now I am receiving them from a scraped web page, which I have retrieved using ServerXMLHTTP. In this case, a standard replace is not working.

I've noticed that when I use Server.HTMLEncode on the text, both left and right smart quotes, angled apostrophes, em dashes, etc. all get encoded as &#65535 which tells me something goofy is going on. I don't know if this is a character encoding issue or what. I could just HTMLEncode the string and do a replace on &#65535 but that also encodes other things that I don't want encoded, and there appears to be no such thing as Server.HTMLDecode in classic ASP.

View Replies View Related

Replace Double Quotes

Got a stubborn problem with double quotes

i can replace two single quotes but how do i replace a quotation mark e.g. (") and not ('')


Replace(rstSimple3.Fields("Description"), "''", " ") works

Replace(rstSimple3.Fields("Description"), """, " ") cuases error!

View Replies View Related

Rule For Single Quotes

what is the rule for single quotes around a value name in a strsql?
y do you have to do it sometimes?

View Replies View Related

Include Double Quotes

i want to know how to include double quotes in " "
such as

somevariable=" "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("kb.mdb")" "

note this is example given by me.
i only want to know that
how to include double quotes within double quotes.

View Replies View Related

Inserting Into DB When Data Contains Quotes

I have a form that inserts data into a database...wow, big surprise there, huh? Anywho, my problem is when a user types a word like can't or won't etc.. The single quote obviously throws off the SQL string.

I looked through the forums to see if anyone else had similar problems and I found one. It was suggested to use a replace method upon inserting and then reversing that when reading data from the database. Code:

View Replies View Related

Double Quotes Of Javascrpit

I got to place a loop to create a call to javascript with different ID' s generated by asp like in the following code ...

View Replies View Related

Handle Quotes In Database

What is the best way to handle inserting double and single quotes into a database via input from a form?

It's not a good option to remove them, since I need the text to contain punctuation sometimes. Likewise if I replace them with special characters (e.g.
Code:
& # 34 ; (without the spaces)
) it buggers up any HTML formatting I have in the textbox.

Is the best way to handle this to replace with HTML special characters then replace them back again in the database output?

View Replies View Related

Insterting Quotes Into A Dbase

How can you insert a quote ' or " into a database from a forum without getting an sql error due to the quotes closing, or opening a new field in the sql string.

View Replies View Related

Double Quotes Issue

I have some data string like ~!@#$%'^&(*("}[;asd"> which contains double quote and greater then sign, first I need to insert this value into database, second this inserted value I have display in a textbox by retriving from database, as it has "> at end of the string values are getting discarded.

View Replies View Related

Triple Nested Quotes

Can someone tell me how to write this line so I don't get an error - I've tried various ways to nest the quotes,but I still get an error saying that an ")" is expected.

Code:

response.write("document.write('<form method="post" action="message_send.asp?subject=" & _
Request.QueryString("subject") & "" onsubmit="return preValidate(this);">);")


Is there any other way to feed the result of an ASP function into Javascript other than by getting ASP to write out the JS as above?

View Replies View Related

Double Quotes Within A String

When you want to put double quotes inside a string, how do you verify that the double quotes are not the end to a string? For example, what if you want to write this. Code:

"Response.Write("The words "DEV SHED FORUMS" are in double quotes")

View Replies View Related

Find Smart Quotes

if there is a way to find (to strip or process) smart quotes in text submitted via a form? These don't work:

strOutput = Replace(strOutput, "“", "“") ' left smart quote char as
replace value
strOutput = Replace(strOutput, Chr(147), "“") ' my best guess at where the
left smart quote char is in the charset. I guess the real question is if I submit the page as Unicode is there a way to process it as cp-1252?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved