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!

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

Recent content by dirkg

  1. dirkg

    Function to return table depending on IF-statement

    I didn't know that the name wasn't PL SQL...in any case I'm using SQL Server
  2. dirkg

    Function to return table depending on IF-statement

    Hello, I'm pretty new in PL SQL. What I want to do is to create a function that executes a different query depending on an IF-statement. Here's what I thought it would be: ALTER FUNCTION dbo.fct_Person_Client_Permission_Check_2 (@PersonID int, @ClientID int, @SecurityLevel int) RETURNS TABLE...
  3. dirkg

    style.display = 'inline' problem in Mozilla

    found it: I have to use document.getElementById('FilterLine1').style.display = ''; instaed of document.getElementById('FilterLine1').style.display = 'inline'; Just to let you know in case you were encountering the same problem...
  4. dirkg

    style.display = 'inline' problem in Mozilla

    Hello, I have a problem with the javascript in the following page: http://helpdesk.dixys.com/tm/todo/todolistdbgen.html If you click the Show Filter button in IE it works fine: you can hide and show the filter. In mozilla however the layout is completely changing: colums are switching, new...
  5. dirkg

    CSS height=100% in Mozilla

    found it: the problem was the <form></form> tag which was placed around the table
  6. dirkg

    CSS height=100% in Mozilla

    The problem is that on mozilla only something like the top 100px are used for the iframe instead of the whole screen like in IE. So you get a large white area on the bottom of the page that is not used
  7. dirkg

    CSS height=100% in Mozilla

    Hi all, I'm trying to have my application compatible with other browsers than IE, starting with Mozilla but I'm not getting it. I've looked through the forums but I did not find the solution. Therefore I was wondering whether somebody could have a look at the following page...
  8. dirkg

    Timeout expired

    The thing is that when this problem occurs, I get a Timeout on every table which I try to update, even if it has only 10 records. The largest table in the database has about 5000 records, all tables have at least a primary index.
  9. dirkg

    Timeout expired

    I have this really ennoying problem with my SQL Server database that I use as database for a network on the Internet (www.it2.be): usually it works fine but lately it starts to give the following error: Microsoft OLE DB Provider for SQL Server error '80040e31' Timeout expired This error only...
  10. dirkg

    Performance difference between CursorLocation=adUseClient and GetRows?

    Hi all, I'm optimizing my asp-application with a SQL Server 2000 database. I was wondering whether there's a difference between opening a recordset with rst.CursorLocation = adUseClient Set rst = Server.CreateObject(&quot;ADODB.Recordset&quot;) rst.CursorLocation = adUseClient rst.Open...
  11. dirkg

    Netscape problem

    no I didn't...:-(, the problem still exists...
  12. dirkg

    Netscape problem

    I tried it but the problem isn't solved :-(
  13. dirkg

    Netscape problem

    Hi all, could anyone tell me why this code does not work in Netscape? <script language=&quot;JavaScript&quot;><!-- if ((screen.availWidth <950) || (screen.availHeight < 720)) { document.write('<object classid=&quot;clsid:D27CDB6E-AE6D-11cf-96B8-444553540000&quot...
  14. dirkg

    Retrieve new autonumber_ID from stored procedure

    Thanks Andy, that was indeed what I needed, works perfectly :-)
  15. dirkg

    Pagecount does not work with Command object

    Meanwhile I found the solution: I have to open the recordset using the following command: rst.open objCmd,, adOpenStatic , adLockOptimistic ,adCmdStoredProc See also thread thread333-410054 where I was pointed to the article that helped me. Greetz, Dirk

Part and Inventory Search

Back
Top