Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JasonXie

    database designer

    Hi, All: Can anyone tell me which software or tool can be used to draw the EER diagram and finally convert them to a set of relation tables satisfying the normalization ? Many thanks in advance.
  2. JasonXie

    Query Rewrite

    Many thanks.
  3. JasonXie

    Nested query

    Hummmmmm, moonhearts, hummmmm, OOOOOOOdd, Anyway, try to use a nested query. For example, If you have got these: Q1 : select sum(amount) as qtr1 from sales where date in (Jan, Feb, Mar) ( or something like this ) Q2: select sum(amount) as qtr2 from sales where date in (Apr, May, Jun) ...
  4. JasonXie

    Query Rewrite

    Hello,All: I am playing Oracle Enterprise Edition 8.1.7 and want to get familiar with it espacially materialized views and query re-write. First, I used SQL-Plus and defined a materialized view by using the following : create materialized view first_summary pctfree 0 tablespace...
  5. JasonXie

    Nested query

    Hello,All: As we all know, a simple query S_q is of a standard form, i.e. select ... from ... where... group by ... having ... sorted by ... Actually, a nested query N_q may contain other simple queries with standard form (or even other nested queries) in the where clause/from clause/having...
  6. JasonXie

    How many queries?

    Hello, All: These might be stupid questions. First: For a given table with 10 attributes, without knowing the type of the attributes, without knowing any specified requirements, how many queries can be generated on this single table by using as many combinations of SQL query keywords as...
  7. JasonXie

    Hi, everyone: Can anyone tell

    I think you may want to create a script which can change the registry key such as adding key, changing value. If so, you can check the kix web site to get details. Cheers,
  8. JasonXie

    Restrict the number of connects to OLAP Server ?

    Hello, again : We have installed the OLAP Server on one server. However, we do worry about the server will crash under too many connections. Is it possible to limit the number of connections to the OLAP Server ? And How ? Many thanks in advance.
  9. JasonXie

    Command for adding users into the OLAP Administrators Group

    Hello, Can anyone point out whether there is a way to use a command/script to add users into OLAP Administrators Group ? Including adding "everyone" of the local machine into the group ? Many thanks in advance.
  10. JasonXie

    How to control the number of connections to OLAP Server ?

    Hello, again : We have installed the OLAP Server on one server. However, we do worry about the server will crash under too many connections. Is it possible to limit the number of connections to the OLAP Server ? And How ? Many thanks in advance.
  11. JasonXie

    script for adding users into OLAP Administrators Group?

    Hello, Can anyone point out whether there is a way to use a script to add users into OLAP Administrators Group ? Such as adding "everyone" of the local machine into the group ? Many thanks in advance.
  12. JasonXie

    Internal Error 25003 when ghosting down

    All right . I fixed it. add switch -ntc- and everything is ok. Hopefully, this may help others.
  13. JasonXie

    Internal Error 25003 when ghosting down

    The client PC used by students has three partition. One is the ghost boot partition, one is Windows2000 boot partition. The last is a temp partition which can be used to save students' work temporarily. I only need to create an image for the Windows2000 boot partition which is 10G with 50%...
  14. JasonXie

    Internal Error 25003 when ghosting down

    Hello, All: The problem happened if the image was bigger than 2G and had to span. The ghost version is 6.51. The server platform is NT4 SP6a. The client platform is Windows 2000 professional. Is there anyone who met the same problem and fixed it? Many thanks in advance.
  15. JasonXie

    command line for setting up ODBC DSN ?

    Hello All, I am running NT4.0 Server and Win2000 Server. I know how to use odbcad32.exe (GUI) to add DSNs one by one. It is really boring if you are going to add many many DSNs, isn't it ? I am wondering whether there is a way to use command lines to do that ,i.e., creat a batch file to add...
  16. JasonXie

    What are the properties of IFrame in Netscape 6?

    I know Netscape6 now can support IFrame but ignoes the layer. But I don't know the properties of IFrame in Netscape 6. The syntax in IE5 to get the content of an IFrame is the below: temp = document.frames['myIFrame'].document.body.innerHTML I tried to convert it to suit the Netscape 6 but...
  17. JasonXie

    what is the relative javascript for Netscape 6?

    My script can work fine on IE4 or 5 and Netscape 4.7. Since Netscape6 ignores "Layer" and support "IFrame", I have to transfer the script to suit Netscape6. What I am confusing is that even through Netscape 6 supports "IFrame", but why the below script can't work...
  18. JasonXie

    Why does Netscape reload the current page while resizing the window?

    It is very annoy ! When I resized the broswer, Netscape always reloaded the current page. It caused the variables on the current page had been initialised again. IE doesn't do that. How can I stop Netscape reloading the page while resizing the broswer window?
  19. JasonXie

    why couldn't the Netscape layer show the content correctly?

    Hi,Jaredn: I am trying to change the position dynamically by Javascript. However, I have got another problem that is how to get the details about the screen resolution by script. The resolution is the main element for calculating the position dynamically. Can you give me a clue ? Thank you very...
  20. JasonXie

    why couldn't the Netscape layer show the content correctly?

    I tried to use layer to load an external file. I would like the position of the layer be relative rather than absolute. So, I used javascript to create the layer and put the javascript in a cell of a table. I hope the layer can be shown in the right way and it can load the external file...

Part and Inventory Search

Back
Top