November 3, 1999

Deleting Duplicate Rows

Question: I have this table: declare tbl1 (x int,y int,z int); I don’t have a column I could use as a unique key. There are some duplicate rows (not just columns); for example, the row with the values 2,4,7 may occur several times. Is there a simple query I can

Using the History Object to Go to Specific Pages

Question: I am using history objects back(1) ( history.back(1) )method in my HTML application to go to previous screen and it is working alright but I am not able to go back to a second previous screen . I have tried history.back(2), history.back(3), and so forth but it is not

Client-Side Data Binding Is IE-Only

Question: Designing with JavaScript by Nick Heinle talks about using Internet Explorer’s Object tags for simple data binding of CDV databases. Is there a Netscape Embed tag (or other equivalent) that accomplishes the same thing? If not, is there any other way to do cross-browser data binding using JavaScript? Answer:

Dynamically Load a Page From a Frame Into Another

Question: Is there a way I can load a Web page from the top frame into the bottom frame, when a user clicks on a link in the bottom frame? The page should be dynamic as to load whatever page is loaded in the top frame. Answer: You can change

Replace Selected Content

Question: How do I replicate the pasteHTML function supported by Internet Explorer in Netscape? Rewriting the layer isn’t the problem. The problem is determining the position of the text returned by the getSelection(). For example, how would I allow a user to select a piece of text on the screen

Alternate Colors Every Other Row in a Table

Question: I want to present the results of a search in a table with two background colors, so that every other row will change color. How can I do this? Answer: I’m assuming that you’re generating the table rows from some server-side process. You can define style sheet settings for

Integration of Replication and DTS Steps

Question: I am trying to build a warehouse. The steps involved are: Make a snapshot replication of the OLTP onto the staging area. Run a DTS package that makes transformations and loads the data warehouse. Since I want to automate the process, I want to schedule Step 1 and then,

Access CGI Environment Variables

Question: Can JavaScript access CGI environment variables? Once a user has logged into my site, I would like to retrieve the user name from the “REMOTE_USER” variable. Answer: No, there is no straightforward way to make this happen because JavaScript runs within your browser on the client, whereas CGI scripts

JSP Methods

Question: Is there a way to declare and invoke methods in JavaServer Pages? Answer: Methods can be declared in the same way as variables in JavaServerPages. It can help to think of JSP as a convenient syntax fordefining servlets. Any variables or methods that you declare aremembers of the servlet.

No more posts to show