The following removes any unwanted apostrophes before being inserted into an sql database:
Articletext = replace(articleText,"'","''")
..but if I need to remove all quotation marks, this doesnt work:
Articletext = replace(articleText,""","''") Code:
When do you use quotation marks around values in an SQL Statement, and when do you ignore the quotation marks completely?
View Replies View RelatedI have a number of records I need to display in a list box (dynamic) - some have quotation marks and the system chokes on them.. whats an easy way to overcome this?
View Replies View RelatedI am trying to copy an uploaded document from one directory to another. The uploaded file (attach1) will be dynamically named. The resulting file (LName) name is based on a last name field. I have the following code but I cannot figure out how to deal with the issue of quotation amrks. Should I escape them or do I use another method?
dim fs
set fs=Server.CreateObject("Scripting.FileSystemObject")
fs.MoveFile "E:Inetpubwwwrootuploads<%=(frmSend.Fields.Item("attach1").Value)%>.doc","E:Inetpubwwwrootuploads
amed<%=(frmSend.Fields.Item("LName").Value)%>.doc"
set fs=nothing
I can't seem to find the right way to do this, how do I get ASP to ignore a quotation mark in a string? " doesn't work.
View Replies View RelatedJust like my other post about quotation marks not appearing,I am having trouble with foot marks (').
They are going in as ' but are appearing on the user's end of the database as ` Minor.
Just wonder how you guys handle the single quatation marks when you write the value of a text input into SQL server.
View Replies View RelatedI originally believe this was a database issue untill I tried to run this using just pure forms.
Issue. I have a form (basic form) and at one of the steps.. the user inputs an article name (and in this case.. there is a set of doublequotes used in this name).
I used the name ( In "Search" of the three Ethical Reviews )
<input type="text" name="Article">
Now I filled in the rest of the data Including a large section with just paragraphs of text that includes quotations marks, slashes, etc etc.
I click the submit button which Transfers all this information into a review page. The review page is another asp page that merely drags all the info from the last page and displays it on the screen for re-editing. Example Code:
I am working on building an asp forum, (I have posted a few times with questions ) and it works for the most part now, but I am trying to fix some things.
I am storing posts in a memo field. Originally it was text fields, but 255 characters is just not good enough.
Now, posts are saved fine except for 2 things:
1/ " and ' cause errors. These are causing conflicts with my INSERT SQL statement that is made. How would you get around this problem, I wonder?
2/ New lines etc are not being put into the memi field. I can live without this for the time being, but at some point I will want to implement posts being outputted in the same format they were inputted. Any advice on how to deal with this issue?
When the quote mark (") is the last character on a string, it does not output on input boxes because the application reads it as the end of the value. How can I get the quote mark to appear in input boxes?
View Replies View RelatedI am working on a date function, which takes a YYYY-MM-DD input and splits it into dd,mm,yyyy format. e.g:
string1 = "2006-10-20"
Function stripDate(str)
str_len = len(str)
if str_len = 10 then
str = replace(str, "-","")
str_yr = left(str,4)
str2 = right(str,4)
str_mo = left(str2,2)
str_dy = right(str2,2)
stripDate = str_dy & "," & str_mo & "," & str_yr
else
Exit Function
end if
End Function
test = stripDate(string1)
sample output: 20,10,2006
I then want to pass the sample output into another function, but in order to do that, the date variables must be split with speech marks as follows:
"20","10","2006"
but I can't work out how to include that in the stripDate function so that it wraps the variables in speech marks. Whenever I try to include the speech marks the code returns the usual error about unterminated string constants e.g. if I replace the final line of the above function with this:
I'm asked to do Quotation and Invoive modules using asp. To come out with the Quotation or Invoice will not be a problem but I think printing them from the browser will be a problem. The quotation should be formated and printed as if it printed using excel with proper alignment and if the details exceeds the first page it should have the closing line and the next page should have the table header ect.I'm not sure whether this is possible to print in this way from the browser.
If this is not achievable I'm thinking of creating an excel file put all the data inside and open it for the user to print it from excel.Could anyone guide me which will be better way.If creating excel file is a better option sample script.
how can i decline a ' character in asp?
View Replies View RelatedOne thing I've started to notice lately is that asp seems to be very sensitive to how quotation marks are layered. Does anyone know where I can find out when to use double quotes and when to use single quotes? Code:
SelectSQLB = "SELECT * FROM TeamRosters WHERE IDNumber = Session(' 'TeamMember' & LoopCounter')"
Is the line that's giving me trouble and I'm not really sure how to layer it. Every logical combination I've tried has produced a different sort of error. Note that TeamMember# is a session variable and loopcounter is a local variable used to select which TeamMember# session variable to use. Before I've noticed that pretty much it works like this: " ' ' " but that was for two layers deep. What's the syntax for going three layers in?
I am looking for a way that I can trap the single quotation mark. If an
encoder uses single quotation mark on a textbox field, it always give me an
error because I use single quotes on the SQL statement.
what is the easiest way to display Yes/No, True/Falst, On/Off MS Access fields as check marks on an ASP page? it would be either checked or unchecked.
View Replies View RelatedI read that the "?" caracter can make you trouble with some search spiders. Although I know the Spiders are upgrading to evade this indexing problem, it is still an obstacle for some search engines.How can you refrain from using "?" in urls, for example, in a dinamically runned site?. Some CMS do it replacing that caracter with the slash bar "/", that is more spider-friendly.
In brief:
1. Is "?" still giving problems?
2. In case it's still making problems. How can I replace it?
Does Anybody Know Howto Switch All Positive Signs(+) For Negitive Signs(-) And Negitive Signs For Positives?
View Replies View Relatedthat is generated by a database that I don't have access to?
So, I use a database drived store. It is not open source, so I do not have access to adjust the HTML that is generated.
Unfortunately, the code is fairly messy, and contains un-necessary breaks, paragraphs, and other code that I don't want there! A lot of it I've been able to adjust with css, but the biggest thing that bugs me, is that there is a table and a td that are at a set width. It is set at 'width=550'. I would like to either remove that, or change it to 'width=95%'.
Is there anyway I can accomplish this? What I do is create a template .htm page that the asp uses. Is there anything I can do in the .htm to replace or remove this HTML? Javascript? A snippet of ASP code? Or should I just learn to live with it?
I need to replace some dynamical content away from a text, only static thing
is that it starts with <!-- Start dynamic --> and ends with <!-- End dynamic
-->. How do i dynamical remove these two tags and all the content between
them?
I'm sure this isn't difficult, but it's Friday afternoon (!).
I'm trying to use a regular expression to match html tags in a string
and convert them to lower case. It's the RegExp object that I'm
struggling with rather then expression syntax.
So far I have this ('HELP!' denotes where I'm stuck):
private function recoverHTML(sHtml)
dim oRegExp
set oRegExp = new RegExp
oRegExp.IgnoreCase = False
oRegExp.Global = True
oRegExp.Pattern = "<(.*?)>"
sHtml = oRegExp.Replace(sHtml, HELP!)
set oRegExp = nothing
end function
I'm thinking of something like this:
"<" & lcase($1) & ">"
What syntax do I need here?
With hosting for clans, more so then not, the clan tags contain charactures
like + { [ in front of the tag letters.
what I am having a problem with is if it starts with a +, it isn't picking
up the name correctly. If in a sql statement, it looks for a tag that starts
with a +, it won't find it. And sometimes, when it is supposed to move the
tag over in a bracket, it moves it without the +.
for example, +EcK+ is the tag, it will either not find it, or move it over
as EcK without the +'s.
is there any way around this?
i know for some strings, such as things with ' you can use
replace (request.form("var"), "'", "''")
I put in some code to keep apostrophes from being a problem. However, on the
display page, they have double quotes. What am I doing wrong?
Here is the code on the page which captures the data from the form, right
before it gets entered into the database:
------------------------------------------
strInternalDesc =
Replace(Replace(Trim(Request.Form("InternalDesc")),"'","''"),vbCrLf,"<br>")
------------------------------------------
then, on the page where it gets displayed, I get:
I want to mask part of a field upon displaying it. field name is "IP", how do I mast the first 4 characters with "*" symbols?
View Replies View RelatedI have a printer friendly page script, that outputs the text less any includes, it works well in IE, but firefox grabs the "'<%@LANGUAGE="VBSCRIPT" %>" and outputs it to the print version page. SO i get a nice printer version - but with <%@LANGUAGE="VBSCRIPT" %> at the top.
Does anyone know how to write a conditional region like:after <body> if string is "<%@LANGUAGE="VBSCRIPT" %>" replace with ""?
i am having trouble getting my REPLACE fn. to replace whole words only. basically, i'm running a 'spelling checker' fn. that uses the REPLACE fn. to find incorrect spellings and replace them. problem is, the fn. seems to replace all instances of a string, and not a whole word only as I intend it to be:
Code as follows:
StrInput = Request.Form("BKM_Search")
StrInput = LCase(StrInput) 'convert all to lowercase
StrInput = Trim(StrInput)'trim all empty space b4 & after string
StrCorrect = Replace(a_StrWrong, a_StrRight,1,1,1)
Let's say I want to replace the word "sea" with "ZZZ" only:
Example input: "Sean has some neat sea shells"
Example output: "ZZZn has some neat ZZZ shells"
I've got an Access database with a memo field with large amounts of text in. In Access forms the text appears with line breaks where the enter key has been pressed. I'm using ASP to display this content on a simple webpage but want it to appear with the same line breaks as in the Access forms.
This is the code that I've got but it doesn't seem to work.
<% Article = rs("Article")
Article2 = Replace(Article, "<br>", chr(13))
%>
<td valign="top" bordercolor="#FFFFFF" bgcolor="#FFFFFF"><div id="ArticleStyle" align="justify">
<% =Article2 %>
</div></td>
Does anyone know how I can detect if a image is missing from the server before the browser tries to render it, I guess this would have to be done via some sort of preloader, the problem being I am the site in question has around 30,000 images and keeping on top of missing images is a impossiblility.
View Replies View RelatedIm looking for a way to replace certain chacters in a variable. this will be used for a file name. currently im using Code:
strFileTitle = Replace(strGuideTitle, " ", "_")
But this only kind of works because as ive erperiented more i also need to remove most chancters which would make an image file name invalid such as : ; / & ' " and a few others which users may enter regulary.
what I'd like to do is have a few style sheets, then have a dropdown box where the user can select a theme and it will switch the style sheet in the link rel= according to which theme they chose. This should be pretty simple but I'm not much of a programmer. Can anyone help me out with the code for this?
View Replies View RelatedI have a code that goes to the url of the company.My problem is that if a company name has a single quote in it,it tries to end the statement.I tried a replace as you will see,but still doesn't work.Heres my code:
Response.Write "<td><center><a href='edit.asp?company="
Response.Write server.URLEncode(replace(rs("Company"),"'","'"))
Response.Write "'>Edit</a></center></td>"
i have a remove user and change password script written, but the only thing they are missing is the actual text file editing part. i have the file open because i have read it, but how can i delete a line that matches with 'OldLine' and put 'NewLine' where it was with a couple of lines of code?
View Replies View RelatedI'm getting errors and for the life of me I can't remember how to get my "'s to output...
View Replies View Related