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
ADVERTISEMENT
I've got an issue when using an INSERT into MS SQL 2000. The problem is that when I do any insert using the code below, the insert happens 3 times. The query reads something like this...
SET NOCOUNT ON; INSERT INTO xx (xx, xx) VALUES ('xx', 'xx'); SELECT @@IDENTITY AS newID;
I then use the following code to run it and do an update to the new record. One thing to note is that the update is only completed on the last insert that is done, so this doesn't seem to be a problem of the function running multiple times. Code:
View Replies
View Related
Code:
' then set up a query
' -----------------------------------------------
sQuery = "SELECT DISTINCT * from tablename Order By columnA, columnB " ' << insert your own sql here
could someone give an example so I could follow it?
View Replies
View Related
In this my need is three combo dropdown box.
the first one is date(statically from today to another 5 days)
the 2nd one is city(like bangalore,newyork...)
the 3rd one is theaters(like abc,wilson...)
if i select 1st combo value means the related values from 2nd combo will load.
and if i select 2nd combo value means related 3rd combo value will load.
View Replies
View Related
What I'm trying to do is match all buyer requirements in a database table to all available properties in another table. I then want all these matches displayed in a report with the buyer name followed by the relevant matching properties, this should occur until all buyers have been displayed with their matching properties.
The problem is that it only works correctly for the first buyer for which the correct properties are displayed, after that all I get is the buyer names without their matching properties... so it seems to loop perfectly the first time but from then on forgets about the inner loop! Code:
View Replies
View Related
My last (maybe) problem is to make a nested menu (I think is possible only with Java) and I must take the names of the selections from a DB ...
is possible? I can't find documents where is explained how to use MDB files with Java
View Replies
View Related
I have an array of items and for each item I need to find sizes and and for each size I need to find colors The array of items comes from the previous page. Code:
View Replies
View Related
I am using IIS 5.0, ASP and VBScript. I am puzzled by recurrences of errors when I nest subroutines, and I'd like to know if there are rules for that which I don't know. Would functions work better instead? I am not much of a coder.
View Replies
View Related
I'm using the following SHAPE command:
SHAPE {SELECT * FROM Chapters WHERE SchoolID=320}
APPEND ({SELECT * FROM ChapterLink}
RELATE ID TO ChapterID) AS Advisors
({SELECT FirstName, LastName FROM LocalAdvisors }
RELATE UserName TO UserName) AS AdvName
I get an error, "Column (UserName) does not exist in the appropriate rowset", which is correct, the UserName column actually exists in the ChapterLink table. But, I can't figure out how to construct this SHAPE command so that it works like that.
View Replies
View Related
I want to loop through a certain number of records in the recordset and then create a second loop for the remaining records. How do I capture the last record on the first loop to use in the second loop?
View Replies
View Related
I have taken over a program that uses a mixture of javascript and clasic ASP. However i am trying to get rid of the javascript and just use ASP.
However the code uses a nested recordset as the secpnd recordset needs a result from the first to run correctly. I have managed to change the code so that it goes through the first record but I can't get it to loop through the other recordsets. So it writes one results and then just a blanks.
Is it possible to use nested recordsets for more than one result? If not what are my options for fixing this problem?
View Replies
View Related
I am not too sure wats wrong w the if-else statement below!
<%if(grp==grp2)%>
{
<%if (start==req || end==req)%>
{
<%=grp%>
<%=start%>
<%=end%>
}
<%else%>
{
<%="There is no such record found"%>
}
}
<%else%>
{
<%="There is no such record found!"%>
}
<%endif%>
Error: 'else' without 'if'.
else
^
View Replies
View Related
I have an ASP page where I build a html table dynamically by reading a database table and populating the <TD> cells with the fields of each record.
I want the last field to be a html drop down list that contains values read from another db relation in the same db. It would seem to me, (i'm novice) that this would require nesting SQL SELECT Code:
View Replies
View Related
I am trying to produce a results page where the results come from three seperate tables.
e.g. The main query gets a list of results, for each one of those results I need to display data from another table. I have a list of bars, restaurants, hotels etc.
I want to display the details of those in sections (a bar section showing all the bars etc) each one of the bars is ranked by members. When I do this I get a "type mismatch" which I guess comes from the fact I am trying to equate an array to a single value. How do I get round this? Code:
View Replies
View Related
When an HTTP 500.100 occure in IIS 5.0, I was getting redirected to a HTTP 500.100 -'page cannot be displayed' error page when there was an error, but now in IIS 6.0, I get 'Microsoft VBScript runtime error '800a01c2' ' nested within the page.
I'm trying to create my own error messages so it will re-direct to my own error page and send me an email. I used to be able to do this in IIS 5.0 but I can't seem to get it going in IIS 6.0 as it doesn't re-direct to a default error message.how to get IIS 6.0 to work like IIS 5.0, or is there another way of doing it, or is this not even an IIS problem.
View Replies
View Related
I would like to know what I'am doing wrong with this loop & Array's... Keeps over oading but unsure why... Would anyone know why and know a sollution?
ERROR:
Microsoft VBScript runtime (0x800A0009)
Subscript out of range: '6'
CODE:
For Each i in TArrSpl
For Each e in TId_Arr
IF TId_Arr(e) = TArrSpl(i) THEN
' CODE
ELSE
' CODE
END IF
Next
Next
View Replies
View Related
I have to read a XML file in ASP and save the values in a database. I can get this work, but I cannot read some nested nodes of the xml file. This is a part of the XML file: Code:
View Replies
View Related
I am passing values from Supplier_Details.asp to Supplier_Products.asp, when I click to view the details of the supplier I want, their values goe to the other page ( supplier_product)that I want all his products to be displayed.
so far I can pass values and could be displayed, no problem but when it comes to displaying all the products, it;s then where I am stuck, with the previous tutorials ( nested repeat region) I can get it working and I tried to have that example working for all this, so far it;s not, so is it possible to do it ? Code:
View Replies
View Related
I'm working on a new site that has a nearly empty index file (variable
location) that includes a template file (set location) which in turn
includes two data files (variable location dependent on index file's
location). This concept worked in PHP and I'm just playing around with it
in ASP to see if it can make my site management easier because I can't move
to Apache for a while.
It seems that the template file can only include relative to itself and also
with specific paths, but it can't include relative to the original index
file.
View Replies
View Related
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
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
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
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
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
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
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
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
< 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
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
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
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
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
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