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.
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:
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
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:
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.
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.
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?
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?
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%>
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:
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:
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.
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.
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:
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:
I want to add a include file from the original folder level from the "inc" folder. The file of where the include will be used is located within the folder named Layer3 folder.
How do I add in the include referencing the file. Do i just use".."
For every folder level i want to go up to gain access to the file? Do i just continue to add ".."?
My web designer created my site with a header include or something to that effect. My question is this: How do I change each page title to what I would like for SEO purposes? When I put the desired title onto each page, my includes/header.asp file "overwrites" the desired title; thus, every static page has the same title. Creating separate include files would work but would take forever. I have even tried leaving the title tag blank in the includes.asp file and add the desired title to each static page, but the title tag doesn't end up in the <head>, just the <body> tag.
I've a big include asp file with a lot of function and subs, some of them with a long html code embebed, in this intranet and I'm not sure if I should break it in a several include files in order to improve the performance.
My question is:
leave it as it is because all that code runs into memory only once , say at log in, or break it in several others, in order to access the code that really is to be accessed.
I have a table that I am using as a main skeleton for all my pages to use. The problems is that I want other pages to be inserted into a specific cell.
I have a skeleton.asp with 2 rows and 2 columns. I will create pages like company.asp which will have just text in them and they will use the include tag and include the skeleton.asp.
The problem is that I want the text only page to be inserted into the lower right cell on the table in the skeleton.asp. I have seen it done many times but I cannot remember what the tag was that you put in the cell to put the include contents there.
I have a page that uses includes.It has 1 include to bring in a header, 1 for the menu, and then there is a content area.
This content area I need to change.So, for example, the link would be index.asp page=aPage.asp and it would load my page that page witht the header and menu and for the content area include aPage.asp.
What is the script I can do this with. I tried simply using Response.Write and then just righting the <! #include --> tag with the right page in there, but it just writes that without parsing it and including that page.
I have an include, which is used as the header of my site, that has a bit of CSS coding in it. The CSS code along with an unordered list creates an expandable menu. The include works great when you view it at its URL, but the menu doesn't expand when a person has to access dynamic pages.
I have found out that the problem is that when the file is included the code is not inside the <head> tags, so thus the menu doesn't perform, or expand. Is there any snippet of code that could automatically put the CSS inside the <head> tags?
I have made my asp pages but the left side navigation menu I want to be an include so if I ever change a link it's easy to update them all by changing the nav.asp file. How can I include the nav.asp file on the other asp sites like adminpanel.asp .
Can someone comment on the use of SSIs? Do these place a lot of strain on the server? Also, are "virtual" includes or "file" include directives more efficient?
I am writing a mail order site using includes and nested includes for ASP code. I have no idea if this is rendered without error in all browsers. Does anyone have any idea on this? Code:
I have a main file (asp), from which I include 2 different asp files. The second included asp file references an array element deefined and populated in the first include asp file. However, the array value is not being resolved in the second include.
This is not on a Windows server, but rather a UNIX server. However, the host provider claims ASP and SSI support.
saddled with using an <IFRAME> area on a classic asp page from the designer, so I'm trying to find out the following.
on that page I usually use the <IFRAME> to hold a simple HTML page, that the client will have access to from my CMS program so they can make edits, updates etc.
but, one page has a search functionality, written in classic ASP and using MS-Access dbase to find members of the association etc.
when I put the asp search page inside the <IFRAME> src , it wont show? ie -- <iframe src="findlawyer.asp" frameborder="No" width="756" height="427" id="iFrame" vspace="10">
-- should mean that the page findlawyer.asp should show up inside the holding ASP page (called simply find.asp)
why? when I look at the findlawyer.asp page online it shows up perfectly and works perfectly too....yet inside the <IFRAME> it refuses to show up???
Is there any way to dynamically generate an include file based on a variable passed to the asp page via a url ?- so for example:
Person x clicks on a url - that ur directs them to template.asp (template.asp has no code in it other than page title etc and <!--#include file="<%variable%>" --> )
Once in template.asp the page loads the include file that is relevant to the companies website that the link was clicked from.
In that include file will be the correct form and stylesheet setting for that company.
What we are trying to do is achieve a global template file which multiple customers can direct peo[ple through and all the data is therefore stored in one central repository.
The file displayed when they reach template.asp will depend on the url they clicked. Basically how can i get the url to pass the variable which the include file will then load??
