Parent And Child Relationship On Sql Server
(I include a bmp file to make sure u all understand what my problem is)..as U all can see from the bmp I supply with this message.. I got 2 Table which is Master and Child table...the problem is I kindda want to make it like a Parent Child Relationship like In ms Access.
View Replies
ADVERTISEMENT
I have one asp file including another asp file in a seperate folder. The file of the parent is in a read only, but the child is in a write and read file. If i run the child alone you can write with it no problems, but if i try to write with it calling it through the parent it tells me that permission are denied.
So my question is: are file permissions inhereted by the child from the parent? Is there any way of getting around this besides moving the parent into the same folder as the child?
View Replies
View Related
i have 2 asp pages. the parent and the child. the parent has has a value doc_id which is null. and a button to open the child window. it has other variables and input fields.
the child window creates the doc_id.
Now heres the problem. I want to close the child window, and send the doc_id(created in the child) to the doc_id(in the parent). and close the child window.
But keep the original variables in the parent id. (e.g if the user entered their name in the parent window, then opened the child window, then created the doc_id, then closed the child window, i want to parent to have the user name, and the new doc_id)
View Replies
View Related
I am trying to redirect back to a child form after a submit with a file upload and verification of file data. I would like to go back to the form and display a message returning the status of the data. Is that possible? Any suggestions on an alternate? I am using classic ASP, javascript and vbscript.
View Replies
View Related
I have a page which had a text box.
When a user clicks in the text box, by using the onclick event, i am opening a popupwindow with a list box. Now when the user selects a value in this list box, i want to pass that value to the parent window and populate the parent textbox.
View Replies
View Related
I have two menu form elements that need to refelect a parent child relationship. There are 85 zones and 2200 zone-network combinations.
I want to bind the networkid element to an xml datasource that contains only the networks related to that zone. I have read about something like this before but have never implemented it.
create table tblZone ( zoneid int, zonename varchar(20))
create table tblNetwork ( networkid int, zoneid int, networkname varchar(20))
<select name="zoneid" onChange="reloadNetworks()">...</select>
<select name="networkid">...</select>
View Replies
View Related
I have two dropdown boxes, one is a state dropdown (statedrpdwn) and the other is a city dropdown (citydrpdwn). I want the values in the citydrpdwn to be dependent on what is selected in the statedrpdwn.
So when the user selects a state, I want the city drpdwn to only display the cities in that state. How can I do that? I also need to save this information to a database and retrieve it back correctly from the database. How can I do that?
View Replies
View Related
I have a cross-reference table already set up that contains the information about programs that run in our database. It contains the program name, the tables used as inputs and the tables used as outputs. There is a row for each input to a program and a row for each output from a program. Code:
View Replies
View Related
I have an asp page (parent) which opens a new window (child) with "window.open()". What i want is, when the child window is closed with "self.close()" then the parent window has to be refreshed. Any of you guys know how to do this?
View Replies
View Related
This is my coding:
window.opener.location.reload(); window.close();
I don't want the IE to pop up the alert msg to false retry or cancel to reload the page.
I have tried:
1. window.opener.location = window.opener.location
2. window.opener.history.go(0)
But as i carry some data from previous previous page, when i use (window.opener.location = window.opener.location), it can't capture my data as it just load the page. It will pop up error as no data captured :
Microsoft VBScript runtime error '800a000d'
Type mismatch: '[string: ""]'
Any suggestion?
View Replies
View Related
How to use server.mappath() parent folder correctly:
Server.MapPath("../test.asp")
View Replies
View Related
i have a form that pops up based on a click. the popup opens up correctly.
now what i want it to do is this.
1. submit the data to an asp page. that part i got working
2. close the popup box. have that working as well.
3. after processing the data on the asp page, direct to and refresh the
parent page that the popup was created from.
to be more specific....
i have a bracket page, where you click on the winners name to move them
over. works fine. that sends variables to a pop up box, where you enter a
score. that works fine. now when i submit, it only sneds the data to the asp
page, and even though the bottom of the asp page redirects it to the parent
page, it doesn't. it seems like it is trying to redirect to the popup that
doesn't exist anymore, so it does nothing.
View Replies
View Related
1. I have a form, with a textbox and a button. I have to enter a value in the text box and then i have to click the button, which opens a popup window. Here i want to pass the value of the text box which is entered in the parent window to popup window.
I have to use that value in the popup window's form_load event in the Code behind, and i have to take the values from the database using the value which i have entered in the parent window. Code:
View Replies
View Related
If there is three table,
let say A,B and C
C store the B id, and B store the A id
now what i trying to do is search from C table to get result in A
and display the result from A table..
hv any idea?
View Replies
View Related
I have big issue over here....and i seeking help from u all.....well u see I have 2 asp(dreamweaver mx) pages with contained insert data server behaveiour....the problem is the database which connected to these 2 asp pages is contained 2 table which is link relationship....so when try to insert data to the secondary form it came out wit an error stated cannot update or insert data to the table because of contained relationship
View Replies
View Related
I have a web interface where I can upload images. I have two tables, one table holds thumbnail images and the other table holds the full scale version of the thumbnail image. So, in my web application, I have one form that uploads the thumbnail image and inserts all the relevant information into the thumbnail images table.
I have another form that uploads the larger image and inserts all the relevant information into the table that holds the information for full scale version of the image. The problem is how can I relate the thumbnail image to the corresponding full scale image?
I have to insert the thumbnails and larger images in the same sequence so they have the same id numbers. I'm trying to find a way to upload the images in any order and still have the correct relationship between the images.
View Replies
View Related
I need some help optimising my object design. Since one article has 1+
authors, I assume the logical way to represent this is for my Article object
to have a Authors property, of type "array", capable of representing any
number of authors.
The code I have written (below) works, but is very inefficient; if I want
the asp page to fetch a list of 30 authors using GetAuthors(30), there will
be a total of *31* calls to the database - one call in GetArticles(), and
one call to GetAuthors() for EACH article! Code:
View Replies
View Related
I am trying to get my code to delete a related record in a one-to-one relationship. The code I am trying is as follows:
mySQL = "DELETE FROM tblPurchaseOrderLine WHERE ((tblPurchaseOrderLine.lngPurchaseOrderLineID)="& PurchaseID &");"
myRS.Open mySQL, objConn, 1, 3
However, tblPurchaseOrderLine is related to tblAccessoryPackOrderLine of lngPurchaseOrderLineID. Do i need to reference both table in the statement?
View Replies
View Related
I want to display a kind of two-tier one-to-many relationship, for
which, in the olden days, I would have used a series of nested loops
and multiple calls to the db. Code:
View Replies
View Related
I am trying to port PRAX (PHP Record-oriented API for XML) to ASP and have run into a problem. With Microsoft's XML Parser, to get child nodes, the only way I have seen is by calling on obj.childNodes(1). I need to get a child node by name, not by number, since it could be in any order. Is there a way?
If not, I will have to write that part of the code differently by using an array. I don't want to do this because it would make the code more memory intensive and not as powerful as the PRAX implementation.
View Replies
View Related
I have a submit button which opens a child window,and submit parent window to itself and then begins some processing on parent window. On completion there appears close button on parent page.
Can anybody suggest me how to close the child window on the click of close button on parent window and then redirect to other page?
View Replies
View Related
I am trying to dynamically create an xml file. I can make child nodes, but no grand-child nodes ( i dont know if thats proper terminology )
What I Have:
'-------------------------------------------------------
Set objDom = Server.CreateObject("Microsoft.XMLDOM")
Set objRoot = objDom.createElement("Articles")
objDom.appendChild objRoot
Set objChild1 = objDom.createElement("Article1")
objRoot.appendChild objChild1
Set objChild2 = objDom.createElement("Article2")
objRoot.appendChild objChild2
Set objChild3 = objDom.createElement("Article3")
objRoot.appendChild objChild3
Set objPI = objDom.createProcessingInstruction("xml","version='1.0'")
objDom.insertBefore objPI, objDom.childNodes(0)
objDom.Save "c:MyXMLDoc.xml"
'-------------------------------------------------------
What I would like to do, is have each article have nodes : Title, Score, Age
When i try, I get error: Cant have more the one top level element.
View Replies
View Related
I am trying to update and append to an existing XML file. However I seem to be stuck. I am using ASP as my scripting language.
The form fields has the same value as the KEY attribute so all i have to do is loop through the submiting form for its fields and use the name to update the XML via the keys... Code:
View Replies
View Related
i have an aspx page. on that page there is a link that open a new popup page. Popup page contain some text fields. user fills that fields and press OK. By clicking OK I append the textbox values in the DataTable, which is already saved in the session
My Problem is that when that popup windows closes by clicking Ok i want to show that new information in datagrid on the parent page(which opened the popup page[window.open]). i have info in the session, but problem is that when i bind datagrid by using the session Datatable on the parent page.
View Replies
View Related
If I've enabled Parent Paths (PP) in IIS, but have installed the URL Filter
and disallowed ".." and "../" within links, am I covered from the
vulnerabilities of PP's?
This allows me to use PP's in #Include statements, but doesn't allow
visitors to use PP's in their links to access directories on my server.
Is this correct?
View Replies
View Related
I have a software that has generated a code for me, not sure if I'm allowed to give out names of other companies on here so i won't for now. anyways, the code has worked for a long time on my server just fine. Until I got a new server, same operating system and everything, i just cut and paste everything over from the old server to the new one. But for some reason now one of my sites will not let me use ".." in my code.
<!--include file=../2020applicationsconnections.asp-->
I would just place the "2020applicationsconnections.asp" file in the folder my current file is in, but then that messes up all the the linking that the "2020applicationsconnections.asp" file had in it. So is there any phrase, symbol, ect. that i should use to indicate a parent directory in this code? or is there some setting i need to change on my server that was set up on my old one.
View Replies
View Related
I have a page(1) inside a frameset. The frameset opens from another page(2). I want when I change something on page 1(inside the frameset), the page 1 to be reloaded.
View Replies
View Related
I have a popup from the parent window which allwos the user to add in new location. when the lcoation has been added succesfully. then thewindow closes and the parent gets refreshed. In particular, just the location listbox gets updated with the new value. the location listbox i generated from the database using asp.
View Replies
View Related
What do I need to do to write the URLs of the two identical iFrames in the textarea of the parent frame? Well, the iFrames are the same asp file, but the three listboxes in each iFrame make their URLs different. The problem is that upon selecting both iFrames listboxes, the 2nd iFrame cancels out the URL of the first iFrame written on the parent's frame.
View Replies
View Related
How can I access a web.asp code behind class-on from a code behind calss-function in a loaded web usercontrol. A.aspx loads control B.ascx . A's classA.function A displays info to a label on A.aspx .
I want to call classA.functionA from control B's class B.function B so that when I click on a button located on control B, the on click event fires class B function B which then calls class A function A which displays the info.
View Replies
View Related
I have a parent window (default.asp) and on this page I have an IFrame that displays the rest of the menu requests for the site. The url always shows the base url, never other pages because they appear in the IFrame - this is by design.
The content in the IFrame is dynamic and may scroll forever depending on how much data is retrieved from the db. If the user scrolls down the IFrame to view to contents, the top of the default.asp page scrolls with it until it reaches the top of the IFrame.
The problem is that when navigating through the site I can't seem to figure out how to get it to jump to the top of the default.asp page when the page in the IFrame changes. This causes the user to have to scroll up and down throughout the site making it unappealing for navigation reasons.
View Replies
View Related
I know that IIS 6 disables parent paths by default and I see in M@rco's blog that he "hates them with a vengence." The problem with not using them (at least with includes) though, is that your code files cannot be structured in a useful way, otherwise you will not be able to redistribute your code or to move your folders. Code:
View Replies
View Related
is there anyway to get the title of the window that opened a new window? in javascript it would be window.opener.document.title but is it even possible to get that with asp?
View Replies
View Related