IT training for career switch
i am 45, injured, told i must choose a new career. current job was an all around mechanic/electrician fix it guy. while i have been off i have been repairing, upgrading friends computers, desktops, laptops, etc. enjoy it but i dont want to waste my time in a basic coarse. any ideas would be great.
Answer Question
| March 6, 2012 9:07 AM
IT careers, IT training, IT training and certifications, IT training and coursework
i am 45, injured, told i must choose a new career. current job was an all around mechanic/electrician fix it guy. while i have been off i have been repairing, upgrading friends computers, desktops, laptops, etc. enjoy it but i dont want to waste my time in a basic coarse. any ideas would be great.
Answer Question
| March 6, 2012 9:07 AM
IT careers, IT training, IT training and certifications, IT training and coursework
MySql Select multiple columnsfrom distinct rows based on one column
I am building one sql query based on 5 select statements unioned all together. Each select is built as a variable with where clauses based on filters selected by the users. All 5 selects are concatenated together to build the one dynamic query. The one select below needs to be changed to select rows only [...]
Answer Question
| March 28, 2011 6:35 PM
iSeries V6R1, MySQL, SQL statements, V6R1
I am building one sql query based on 5 select statements unioned all together. Each select is built as a variable with where clauses based on filters selected by the users. All 5 selects are concatenated together to build the one dynamic query. The one select below needs to be changed to select rows only [...]
Answer Question
| March 28, 2011 6:35 PM
iSeries V6R1, MySQL, SQL statements, V6R1
Is experience of desktop administration will take into account for a network administrator profile
I am looking to join as a desktop administrator in one of the small company with 2year bond, But am very much interested working on routers and switches i mean on network, I have tried for entry level network administrator in various companies but i couldn’t get it. so finally decided with this plan So [...]
Answer Question
| September 27, 2011 7:16 AM
CCNA, CCNA Certification, Desktop administration, IT careers, Network Associates
I am looking to join as a desktop administrator in one of the small company with 2year bond, But am very much interested working on routers and switches i mean on network, I have tried for entry level network administrator in various companies but i couldn’t get it. so finally decided with this plan So [...]
Answer Question
| September 27, 2011 7:16 AM
CCNA, CCNA Certification, Desktop administration, IT careers, Network Associates
Access 2007 button addition
Hello I have what I assume to be an easy question that hopefully someone can help me out on. I have a form that I need to add a button to that will pop up a box that you can write a description in. It needs to be different for each record that comes up [...]
Answer Question
| March 24, 2011 1:43 PM
Access 2007, Access 2007 forms, Access 2007 functions, Access forms
Hello I have what I assume to be an easy question that hopefully someone can help me out on. I have a form that I need to add a button to that will pop up a box that you can write a description in. It needs to be different for each record that comes up [...]
Answer Question
| March 24, 2011 1:43 PM
Access 2007, Access 2007 forms, Access 2007 functions, Access forms
Free IT Book: The Accidental Administrator: Cisco ASA Security Appliance
This week’s free IT book comes with a bonus interview with the author, Don Crawley! Check out what he has to say about the book, the process, and the joys of being an IT-type personality. Then answer one of the questions below and post the link to your answer in the discussion section for your [...]
Answer Question
| March 24, 2011 2:29 PM
AS/400, Channel, CIO, Cisco ASA, CRM, Database, DataCenter, Development, Don Crawley, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book comes with a bonus interview with the author, Don Crawley! Check out what he has to say about the book, the process, and the joys of being an IT-type personality. Then answer one of the questions below and post the link to your answer in the discussion section for your [...]
Answer Question
| March 24, 2011 2:29 PM
AS/400, Channel, CIO, Cisco ASA, CRM, Database, DataCenter, Development, Don Crawley, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
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
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
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
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
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
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
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
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
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
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
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
“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
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
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
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
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
