Search results for query: *

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

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

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

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("ADODB.Recordset") rst.CursorLocation = adUseClient rst.Open...

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

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

Hi, I have a table which holds a single key ID. ID is an autonumber. I wonder whether it is possible to retrieve the newly assigned ID from a record directly as a return value from the stored procedure I use to append the new record. Thanks a lot in advance for your help. Greetz, Dirk

Hi all, I'm looking for a good host for my asp-website with SQL Server database. I think that prices for such kind of hosting in the US are much more competitive than here in Belgium. The problem is that I don't know the market so I wouldn't know who are the cowboys and who are the qualiative...

Hi all, I always use stored procedures to retrieve, update,... data. However the list of parameters can be sometimes quite large. With the current synthax I use, I always have to make sure the paramaters I pass are in the same order as they are stated in the stored procedure. However I do not...

Hi all, I have a strange (at least to me :-s) problem. I have an ASP-page that ran perfectly. Then I added to some buttons a rollover and now it seems as the ASP-server stops generating the page at a certain point. You can see the two pages here: The page without rollover...

Hi all, I'm quite a newbie in SQL Server. I just upgraded an Access-application to an Access Project using SQL Server. I have SQL Server 2000 but I'm wondering if it would give any problems when I want to install this application (Access Project Front-end and SQL Server Backend) at a client's...

Hi, I am trying to replicate a database with a database that is located on an FTP-server. First I created the master database and replica on my computer. The I moved the master to the FTP server. When I want to replicate my local copy however with the master over FTP I get the following error...

Hi all, I have set up IIS since I'm making some asp-pages and need to test them on my PC. It used to work fine but now I can load 2 or 3 pages and after that all asp-pages take hours to load. Do you have any idea what can be the reason for this? Thanks a lot in advance. Greetz, Dirk

Hi all, I have created an extended Access-application (a lot of table, code, forms and reports) and I would like to know what the effort it is to transform it to SQL server. I really have no idea how difficult or easy it is. I know that you can use SQL Server as backend and Access as frontend...

I have on the one hand a table with the following two fields: Task - Simulation_Quantity Task is the Key. The I have a group by query that collects for each task the average quantity on a certain period. The outcome of that query gives me also two fields: Task - Avg_Quantity whereas there's...

Hi, I have a continuous form on which I use Conditional Formatting for several controls. However when I open or requery the form, not all the cels are properly formatted. For some controls only some rows are formatted properly, for other none of them is formatted as it should be. Then som of the...

Hi all, I have two continuous forms. On the one form I have a field in the form footer which has as Control Source &quot;=Sum([WorkingTime])&quot; On that form there's also a field called WorkingTime that has as Control Source &quot;WorkingTime&quot;. On that form the sum works fine, also when...

Hi all, I would like to create a custom menu bar starting from my switchboard table. Does anyone has a good example on this? I was able to create a menu via code, to add some items but not to place this items in the right order, under the right submenu's and give the the appropriate properties...

Hi, it appears that my queries always run twice. When I open a query where I use a custome made function in, you can see it loading since the data are apearing one after the other. But when all the list is shown, it disappears again and starts running again. I have placed some debug.print in...