Search results for query: *

Hi I have the following html <table width="100%" border="0" cellpadding = "0" cellspacing = "0" bgcolor="#DCDCC8" > <tr> <td> <img src="banner.jpg" border="0" alt=""> </td> <td> &nbsp </td> </tr> </table> hoping that the height of the table would match that of the image...

Hi, I'm trying to look at having a user's logging into an ASP SQL server APP via authentication/trusted connection alone how is it possible for ASP to connect, using a trusted connection, to SQL server. Authenticating using the clients NT account. Is this possible at all. Cheers

Hi I have a report in on mdb that ~I would like to import/migrate to another mdb. Is there a simple way of achieveing this Cheers

Hi I'm using an ActiveX script. I would like to explicitly declare a variable as a string, but activex scripting does not appear to like dim variable as [string/integer/boolean/whatever] All variables seem to have to be declared as without a datatype essentially making them variants Am I...

Hi we've been having this problem with a server for a couple of months. After a few days of this server having re-booted, I find that when I try and view the SQL Server instances in Enterprise Manager (all instances are registered with sa on my copy of EM), I can view the running server, I can...

Having a bit of mind going blank day I have a parent table Member Membership_no (char(10)) PK First_name (char(30)) Surname (char(30)) and a child table Role_no (char(10)) PK Membership_no (char(10)) FK ...and various other fields I want a query to return the...

I am completely new to access, so this is a complete newbie question I have a report that is bound and has all of its controls bound to a query. I would like to run this report for 2 different sets of criteria one after the other DoCmd.OpenReport reportname 'using first criteria...

Hi I have a script that I'm migrating from IE to FireFox. Some of my mouseover events do not seem to work. The existing code changed the .src of an image by referring to it as an element in the images array document.images[n].src = 'newimage.gif' This code does not appear to work in...

I have inherrited a SQL 7 Database. Although it appears not to support the Syntax Select top n from table. this always results in "incorrect syntax near 10". The database was upgraded apparently from 6.5. @@version displays Microsoft SQL server 7.0 - 7.00.1063. It was my understaing that...

Is there any way to programmatically access the results of the executing an xp_cmdshell 'dir '. I receive a very nice resulting 1 column cursor containing lots of information including all my files and the details of each file, but I woiuld like to be able to fetch through this cursor to...

Hi I have a Database that I have created using the sa account. I wish to create some store procedures. From EM, I selected New Stored Procedure and pasted my text into the edit box and clicked OK. I receive the Error Error 2760: Specified Owner name 'OWNER' either does not exist or does...

Hi, Is there a stored proc, or somewhere in EM that I can find out how much/percentage of a log file (or database file for that matter) is being used Thanks

Hi, We have SQL Server 2000 Standard configured to use memory dynamically. What are the min and max recommendations. We have 1.5 Gb settings are 755 min and 1268 max. We plan to upgrade to 2GB. Is there a rough and ready rule for these settings as a percentage of total available ram (50%...

Hi I'd like to create a cursor that I can Fetch through and update the contents of source tables; but I'm struggle to find an example of an updatable cursor anywhere in the help to get an idea on the syntax. The Help just lists the initial syntax DECLARE cursor_name CURSOR [LOCAL | GLOBAL]...

Does anybody know if this is possible at all using ADO ? I want the first run of my app to create an MDB and tables if not already in existence

I have a couple of questions, firstly what is the concensus on inserting records into a table, do people pass an string containing an insert command with a connection.execute method or use the rs.addnew, assign the fields rs!fld1 = "blah" etc and then do a rs.update Secondly if I have an...

Hi, I have a grid which I am using as a calender. I highlight certain boxes on the grid which have tasks for that day. The way in which I'm doing this is by setting the .col and .row values and then setting the .cellbackcolor property. The problem is that setting the .row or .col...

Hi, does anybody know of a way of determining the number of uncommitted/rolled back transactions in MySQL e.g. in MS SQL-Server syntax Select @@trancount

Could somebody enlighten me to the differences in these functions My understanding document.all[id] = IE4+ document.layers[id] = NS5+ document.getElementById [id] = IE5+ and NS6+ if I want to create a crossbrowser script that refers an elememtn in a DIV or Layer Tag is it safer to use the...

A bit new to Javascript so forgive me if this is a silly question Can you create custom properties on a DOM object. I have a layer that I wish to create an array property for which I will then assign various other child layers into eg PopupObject=PopupFrame.style ...