Search results for query: *

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

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...

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...

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...

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

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

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...

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.

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...

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...

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

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

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...

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

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

Thanks again Mike! The first article helped me. I just have to open the recordset with this command: rst.open objCmd,, adOpenStatic , adLockOptimistic ,adCmdStoredProc instead of using set rst = objCmd.Ececute() Now it works perfectly. Greetz, Dirk

pageing is actually quite easy to implement when you have the recordset opened with the right locks. Check faq333-186 for an example. Greetz, Dirk

Divide the output over different pages. When you use the connectionobject to open a recordset you can specify the locktype and cursortype so that paging is possible (e.g. rst.Open strSQL, objConn, adOpenStatic , adLockOptimistic ,adCmdStoredProc) but I don't know how to specify this when using...

Thanks Mike, apparently you can use text descriptions instead of numbers so that solved my problem: with objCmd .commandText = &quot;sp_rentEstSearch&quot; .CommandType = adCmdStoredProc .parameters(&quot;@ParameterName1&quot;) = request(&quot;locCode&quot;)...

Hi, I open a recordset using the command object. I can assign a pagesize to it but not retrieve the pagesize (always returns 0). I use the command object to open my stored procedure because in that way I can name my parameters. However I can not assign how the recordset needs to be opened and...