Tuesday, September 30, 2008

Word 2007 cannot get rid of change tracking in document

OK, We received a document from a client in which they used change tracking and comments for revision control. However, for our needs this wasn’t necessary. In order to get Word to quit displaying markup and comments for the document we had to do the following:

 

1)      On the Reviewing tab, click the Accept all changes.

2)      Also on the reviewing tab, click the Delete all Comments.

 

Once this was done, the markup section of the window was gone and we could save it without the extra BS.

Tuesday, August 26, 2008

HP printers on Linux using HPLIP getting a dbus error on configure

I've been trying to get printing working on my Fedora 7 box and have
been having no luck. I downloaded the latest version of HPLIP from the
HP website and tried to do the install. I kept getting an error while
the script was running the configure command. It kept complaining about
dbus support.

I finally figured out a workaround by eliminating dbus altogether. Watch
the commands it brings on the screen and copy the line that starts with
'./configure'. It will probably be pretty long. Change the following in
the command line:

--enable-fax-support ===> --disable-fax-support
--enable-dbus-support ===> --disable-dbus-support

then manually run the ./configure command.

If successful, do a make, then a make install.


To configure your printer type 'hp-setup' (without quotes) from a
terminal window and use the gui interface to find and add your
printer(s).

Tuesday, August 19, 2008

Fill multiple variables from one select statement in SQL Server

This may not happen very often, but occasionally you may need to fill multiple variables in a stored procedure with the results from a single SELECT statement. Of course, you can run the statement multiple times, but that’s kind of silly and pointless. The easier way is to use the following syntax. NOTE: THIS ONLY WORKS IF THE SELECT STATEMENT RETURNS ONE ROW.

 

DECLARE @VAR1 varchar(50)

DECLARE @VAR2 varchar(50)

DECLARE @VAR3 varchar(50)

 

SELECT @VAR1 = Field1, @VAR2 = Field2, @VAR3 = Field3 FROM SOMETABLE WHERE(SOMEFIELD=’SOMEVALUE’)

 

 

 

As long as you declare your variable to be of the correct type you should end up with the variables filled.

 

 

I had to use this in a trigger because of the need to pass the values to a stored procedure.

 

Later,
Gary