Quotation Mark Rules
One 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?
View Replies
ADVERTISEMENT
how can i decline a ' character in asp?
View Replies
View Related
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.
View Replies
View Related
This has been puzzling me for very long time and no where has
talked about the scope of a 'On Error Resume Next' statement.
When we program ASP(.NET) pages then we usually like to let
ASP(.NET) stop at errors and report back to us. However there
are parts of our scripts that we know an error will be thrown
and we encapsulate that area inbetween:
On Error Resume Next
Err.Clear
'Try block
If Err.Number Then
'Catch block
End If
On Error GoTo 0
This is similar to the infamous try {} catch(e) {} blocks in
Java/C++, etc.
If we forget the last line 'On Error GoTo 0' then our ASP(.NET)
scripts runs over all errors thrown and we find it hard to
find bugs. So the big question is, does 'On Error Resume Next'
go out of scope when it's written inside a block
(eg. Function)?
Function Function1()
On Error Resume Next
'Our code
End Function
When the Function1 call returns, does the outside calling scope
automatically stays as it was (On Error GoTo 0)?
View Replies
View Related
I am using ("Microsoft.XMLHTTP") to grab content from a site and display it
on my site, the issue I have and have had for weeks now is that on the
original page the sign "£" exists and when I get it to my site it is
displayed as a "?".
If I find the ASC code for the ? and replace on that it still does not work
:-(((
I have tryed all the usual method of fixing this with no success...
anybody had this issue or know where I might start to look to fix it ???
View Replies
View Related
I've created a form where people can request samples of our product to be sent to them. I've created a list page where it lists out all of the current requests that still need shipped. In my database I have a field called shipped with data type yes/no.
I made another page which lists all requests that need shipped based off that shipped field (yes/no.) From this list there's a link to view the details of each record. On that details page I'd like to include a check box that we can simply click to mark the shipped field to yes so that it won't show up on the list of stuff that needs shipped anymore.
View Replies
View Related
I am trying to retrieve arabic fields from sql server 2000 database , the collation for the database is arabic and the content of the column are in arabic but am getting question marks displayed in my ASP web pages when am tring to retrieve the contents of this columns
i have added the following line to my asp page
<meta http-equiv="Content-Type" content="text/html; charset=windows-1256">
but still getting the question marks and not arabic content as they are displayed in the database .
View Replies
View Related
I am having trouble getting the 's and +s on this statement correct. The first select line works as it is supposed to but the 2nd one does not. Can anyone correct this and perhaps tell me/point me in the direction of the rule of thumb for stuff like this?
Code:
<SELECT size="1" name="waste" onChange="window.location='drumsnew.asp?waste='+this.value+' &c_type=<%=Selected_Container_Type%>'+'&c_size=<%=Selected_Container_Size%>';">
<SELECT size="1" name="ctype" onChange="window.location='drumsnew.asp?waste='<%Selected_Waste_Type%>'+'&c_type='+this.value+'&c_size=<%
=Selected_Container_Size%>';">
View Replies
View Related
I am using cdo.message for sending mails I get the data I Hebrew and I send it to the mail the problem is that I get the mail with: question mark "?????????"
Subject
HTMLBody
Sender
Organization
all in question mark
what can i do to see it all in the language Hebrew?
View Replies
View Related
I created a form that puts a text in a sql db just like it is typed in the text field. So when I type: Het potentiëel is dat er .... puts this exact in the database.
An other page takes the value from the db to create a VML/XML based page. but this goes wrong on the words with punctuation marks like ë.
If I look at the source it shows exact what is placed in de db: Code:
View Replies
View Related
When do you use quotation marks around values in an SQL Statement, and when do you ignore the quotation marks completely?
View Replies
View Related
I 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 Related
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 Related
I 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
View Replies
View Related
I get this error messege :
<LI>Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/test/searchlibrary.asp, line 273
line 273 : objRS.Open strSQL, objConn, , , adCmdText
I think my library.mdb has a problem .
View Replies
View Related
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 Related
Just 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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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 Related
I have a form which sends a link from a text field -
<input name=""wishList"" type="hidden" value="<a href='<%=url_link%>?ID=<%=sendID%>&myMonth=<%=sendMonth%>' class='link-onDarkGrey'><%=tripType%> in <%=country%> - <%=mStartDate%></a>">
I need to set a session variable to this value but I think the apostrophies are getting in the way.
session("choices") = request.Form("wishList")
what's the best way to format that lot?
later I want to concatenate several requests so I can display them.
session("choices") = session("choices")&"<br>"&request.Form("wishList")
will this work?
View Replies
View Related
I 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:
View Replies
View Related
