What wiki software do you recommend?
Just as the title suggests, what wiki software (DokuWiki, MediaWiki, etc…) do you suggest to run?  The purpose of this is nothing more than to make a remote note-taking sort of scenario, so it’s not something for anyone but me to be used.  I know I could do my own thing and stuff, but I’d [...]

Answer Question   |  March 19, 2011  3:02 AM
Linux, MongoDB, MySQL, MySQL 5.0, PHP, Wikis

help with access database
Searched high and low and while there are many internet posts addressing this topic, none seem to be geared low enough for this ubernubee. I have 2 tables, one lists various addresses and associated file numbers, the file numbers are unique and the primary key in the table. The other table lists various property details [...]

Answer Question   |  March 16, 2011  6:03 PM
Access 2007, Access Database, ComboBox, Parameters, Refresh Report parameters

Updating a SQL Server record in a large table
We are using SQL Server 2005 and I have an SQL DB on it with 270,876 records in it. There is a PRIMARY KEY defined on the first field called RecordID (Identity field). The index name is PK_ListOfFiles_as_of_3-7-2011. If I execute the following command from the Query Window on the server it takes a really [...]

Answer Question   |  March 22, 2011  1:42 PM
INSERT statement, SQL 2005, SQL Database, SQL Server

AS400 – SQL
I want to use Functions in Update Queries Set operation Update File Set FName = Substring(Name,1,10) Where EmpNo = 99 How to perform this one using SQL Queries    

Answer Question   |  March 15, 2011  6:47 AM
AS/400 SQL, AS400 - SQL Queries, SQL queries, SQL Query

Active Access Database on Sharepoint
How can I load an active Access Database onto a Sharepoint Site? I need to make it open a new page and have each individual be able to enter information into it when they click on the link.

Answer Question   |  March 15, 2011  7:52 PM
Access Database, Access Database Sharepoint, SharePoint

Get your free IT book: The Rails 3 Way
Here’s your chance to win “The Bible for Ruby on Rails Application Development”! There are two ways to get your copy of the book that “strips complexity from the development process,” answer one of four questions and post the link to your answer in the discussion section below. Another way to enter the contest is [...]

Answer Question   |  March 14, 2011  4:08 PM
AS/400, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows 7, Windows Server

Access 2003 IIF Function?
I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle’s use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending [...]

Answer Question   |  March 11, 2011  2:45 PM
Access 2003, Access 2003 forms, Form, IIF, Subform

Junk characters in CSV conversion through CPYTOIMPF
Hi, I am sending data from iseries to excel through CPYTOIMPF i’ve used this command in CLLE, in query output there is a char field value is ’01.03.2011′ but when i see in output by wrklnk temp it shows some junk data in this field . RUNQRY     QRY(ADO150Q) CPYTOIMPF  FROMFILE(ADO150F) TOSTMF(/temp/tst.csv) +                  MBROPT(*REPLACE) STMFCODPAG(*PCASCII) [...]

Answer Question   |  March 15, 2011  10:05 AM
AS/400, CLLE, CPYTOIMPF, CSV, CSV file format, RUNQRY

Access 2003 report printing
We’ve been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we’ve used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the [...]

Answer Question   |  April 12, 2011  6:15 PM
Access, Access 2003, Access 2007, Access 2007 printing, Access Database

Earning badges pays off – TODAY!
We recently announced that the IT Knowledge Exchange Badge Program is beginning its reward phase, meaning that you can earn great prizes just for doing what you’ve already been doing in the community! Initially we planned to send out a first-time prize for everyone who has been active in the past six months and has [...]

Answer Question   |  March 28, 2011  4:32 PM
AS/400, Badges, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, ITKE Feedback, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Free IT Book: Ubuntu Unleashed, 2011 Edition
“Ubuntu Unleashed 2011 Edition presents advanced coverage of the popular Ubuntu distribution of Linux. Windows users, Mac users, and Linux enthusiasts have been increasingly turning to Ubuntu for a user-friendly and easy-to-use Linux distribution that remains useful to power users.” To win this great resource, which includes Ubuntu 10.10 on DVD and a free upgrade [...]

Answer Question   |  March 13, 2011  9:56 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, IT Books, ITKE Contests, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Ubuntu, Virtualization, VoIP, Windows Server

Entry Level IT Credentials
What are currently considered the strongest credentials for someone at the Entry level of IT? Which certification paths provide the most sought after employees? I do realize that there are literally hundreds of pipelines one can go in IT, and each is a personal choice. So what I am looking for is, in as general [...]

Answer Question   |  March 6, 2012  7:58 PM
Certifications, IT, IT career advice, IT careers, IT certification and training, Open IT Forum

Earning Badges Pays Off – Literally!
We told you that payoffs were coming, and they’re finally here! To kick off this exciting new phase of the IT Knowledge Exchange Badge Program, we’re doing a site-wide reward for members who have been active within the past 6 months and have earned at least one badge: $10 Amazon.com gift card to those who [...]

Answer Question   |  March 10, 2011  3:32 PM
AS/400, Badges, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, ITKE, ITKE Community, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Tempdb Size increases and acquires the complete disk space
The issue goes as follows, Tempdb size generally remains around 3GB. One day it starts increasing and acquires the whole of the empty disk space of 29 GB within 15 hours. How can we avoid such kind of situations from happening in future? Any specific reason for such thing to happen? Also the .LDF file [...]

Answer Question   |  November 4, 2011  11:59 AM
Disk space, LDF file size, SIMPLE RECOVERY model, TempDB, Tempdb Size

ODBC connection and IP address
Is there a way to get the IP address of a client/server job attached to QZDASOINIT?  I can see message CPIAD02 in the QZDASOINIT job log which lists the user and IP address and I need to get this information into a CL program which runs each time the user connects to the QZDASOINIT process.  [...]

Answer Question   |  March 8, 2011  11:42 AM
AS/400, CL Program, IP address, ODBC

How do I upload an image or images at runtime in Visual Basic 6
I have designed an interface by which users are soppose to UPLOAD their thier pictures but they cannot do that at RUN TIME. Please help me with the CODE. am using VB6. It is a library registration form with Name, Index, Picture. we are able to update the name and index but unable to UPDATE [...]

Answer Question   |  March 9, 2011  11:14 PM
Database administration, VB 6.0, Visual Basic, Visual Basic 6.0

Selecting Field Defined as L in SQL Server
I am building 4 part SQL select across 4 files using union alls. All 4 files have a date field which is one of the fields I am selecting. My problem is that on one file the date field is defined as L type where the other three files have a date field defined as [...]

Answer Question   |  March 3, 2011  7:06 PM
Date convert, Embedded SQL, Field Defined L, SQL Server development, V6R1

TWO Free IT Books: Multicore Application Programming & The Rails 3 Way
We’ve got two free IT books this week. Since nobody won last week’s The Rails 3 Way, we’re piggybacking the books together. Both contests are currently happening, and winners will be announced Monday, March 7, 2011. The second free IT book, Multicore Application Programming, is a comprehensive, practical guide to high-performance multicore programming for experienced [...]

Answer Question   |  February 28, 2011  6:10 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server

Web development course and Microsoft qualifications
I recently left my job in the UK as a project manager from a niche organisation that provides business services to public service bodies. I am thinking of sharpening my skills by doing some web development training and getting certified with some Microsoft and Adobe products and moving into Web Development project management. I have [...]

Answer Question   |  March 1, 2011  12:04 PM
Apache, Flash CS5, HTML, java script, Linux, MySQL, PHP, Project Management Methodology, SQL Server 2008, Visual Studio 2010, Web development

Crystal Reports XI formula problem
Hi everyone,     It’s been an while since I have used Crystal Reports and am having trouble with a formula… If paid by2/26/2011  12:00:00AM is what I see when I run my program, I don’t need the time, just the date. Here is the formula: “If paid by” & DateAdd (“d”,10,{TransactionTable.InvoiceDate}) Thanks for the help

Answer Question   |  February 25, 2011  8:41 PM
Crystal Report XI, date, Date error, error, formula