Which networking job provides the best income and stability?
you are starting out right with your CCNA. Definately do not stop going for your bachelors. You would want to get a Microsoft certification just because Microsoft has 90+ percent of the market. Once you have those skills down I would look into security certifications. Hackers have made a profession out of stealing money from [...]
View Answer
| February 19, 2008 11:51 PM
CCNA, IT careers, IT jobs, Salaries and wages
you are starting out right with your CCNA. Definately do not stop going for your bachelors. You would want to get a Microsoft certification just because Microsoft has 90+ percent of the market. Once you have those skills down I would look into security certifications. Hackers have made a profession out of stealing money from [...]
View Answer
| February 19, 2008 11:51 PM
CCNA, IT careers, IT jobs, Salaries and wages
SQL statement using RRN(file) on join pulling only Max(date) records from second file in iSeries
You need to include the RRN(XTF419) in the GROUP BY clause Kevin C. Ketzler <a href=”http://www.aresgrp.com”>Affiliated</a>
View Answer
| February 18, 2008 3:02 PM
iSeries, JOIN statement, RRN, SQL
You need to include the RRN(XTF419) in the GROUP BY clause Kevin C. Ketzler <a href=”http://www.aresgrp.com”>Affiliated</a>
View Answer
| February 18, 2008 3:02 PM
iSeries, JOIN statement, RRN, SQL
Implementing DBMS
Implementing a Database is easy. You simply select the database platform that you want to use and install the software. However by it self a database platform won’t do much for you. It’s all about what information is stored within the database as to if the information will do you any good. You’ll need to [...]
View Answer
| February 17, 2008 8:26 PM
Database, Database management, DBMS
Implementing a Database is easy. You simply select the database platform that you want to use and install the software. However by it self a database platform won’t do much for you. It’s all about what information is stored within the database as to if the information will do you any good. You’ll need to [...]
View Answer
| February 17, 2008 8:26 PM
Database, Database management, DBMS
The most widely used form of database is a?
Technically today the most often used database is actually Excel. More companies have more of there data in Excel and use Excel to work with that data than any other database platform. As far as actual relational databases go the big players are: DB2, Oracle and Microsoft SQL Server. MySQL is gaining in popularity. There [...]
View Answer
| February 14, 2008 1:03 PM
Database
Technically today the most often used database is actually Excel. More companies have more of there data in Excel and use Excel to work with that data than any other database platform. As far as actual relational databases go the big players are: DB2, Oracle and Microsoft SQL Server. MySQL is gaining in popularity. There [...]
View Answer
| February 14, 2008 1:03 PM
Database
MYSQL/PHP based CMS (Mambo,Joomla) on the 400.
It should work. Erwin L. Early will be covering it this year at COMMON. I will look around and see what I can find out.
View Answer
| February 14, 2008 12:46 AM
AS/400, CMS, Joomla, MAMBO, MySQL, PHP
It should work. Erwin L. Early will be covering it this year at COMMON. I will look around and see what I can find out.
View Answer
| February 14, 2008 12:46 AM
AS/400, CMS, Joomla, MAMBO, MySQL, PHP
trigger to update
The best solution is to not update the primary key value for either table. What result are you trying to get by updating the primary key. If you need to change the value of the primary key, then that column shouldn’t be the primary key.
View Answer
| February 13, 2008 6:18 AM
SQL, Triggers
The best solution is to not update the primary key value for either table. What result are you trying to get by updating the primary key. If you need to change the value of the primary key, then that column shouldn’t be the primary key.
View Answer
| February 13, 2008 6:18 AM
SQL, Triggers
How to manipulate data or values in my tables SQL Server
To see if a value exists in a table you use a SELECT statement. <pre>SELECT * FROM TableName WHERE UserName = ‘The UserName’</pre> When building an appliction you would typically use a stored procedure to handle all data lookups and modification. You would pass the stored procedure the values you want to check. Something like [...]
View Answer
| February 13, 2008 12:02 AM
Database, SQL Server
To see if a value exists in a table you use a SELECT statement. <pre>SELECT * FROM TableName WHERE UserName = ‘The UserName’</pre> When building an appliction you would typically use a stored procedure to handle all data lookups and modification. You would pass the stored procedure the values you want to check. Something like [...]
View Answer
| February 13, 2008 12:02 AM
Database, SQL Server
Access to MySQL – How hard is this going to be?
Odds are his application is going to be very complex if he’s been building it for 14 years. This is probably going to be a very complex task.
View Answer
| February 12, 2008 12:52 AM
Data migration, Microsoft Access, MySQL
Odds are his application is going to be very complex if he’s been building it for 14 years. This is probably going to be a very complex task.
View Answer
| February 12, 2008 12:52 AM
Data migration, Microsoft Access, MySQL
Exporting MS Access data to Oracle
You need to clean your data. The data type which you are using on Oracle probably doesn’t reconise the year 101 as a valid year. You’ll need to get your data into an ANSI standard date format before Oracle (or any RDBMS for that matter) will be able to process it correctly.
View Answer
| February 8, 2008 7:45 PM
Access, ODBC, Oracle
You need to clean your data. The data type which you are using on Oracle probably doesn’t reconise the year 101 as a valid year. You’ll need to get your data into an ANSI standard date format before Oracle (or any RDBMS for that matter) will be able to process it correctly.
View Answer
| February 8, 2008 7:45 PM
Access, ODBC, Oracle
‘m trying to verify that a SQL DATABASE is empty ,
There’s no function, but you can query the system and see what’s in there. SQL 7/2000 To look and see if there are any tables in the database. <pre>SELECT * FROM sysobjects WHERE xtype = ‘U’ and name <> ‘dtproperties’ /*This table is used for the database diagrams, so you don’t want to delete it.*/ [...]
View Answer
| February 8, 2008 7:41 PM
Data/Application Integration, Database, SQL
There’s no function, but you can query the system and see what’s in there. SQL 7/2000 To look and see if there are any tables in the database. <pre>SELECT * FROM sysobjects WHERE xtype = ‘U’ and name <> ‘dtproperties’ /*This table is used for the database diagrams, so you don’t want to delete it.*/ [...]
View Answer
| February 8, 2008 7:41 PM
Data/Application Integration, Database, SQL
Generic database design to store logs of every database change
What you want to monitor and capture, as well as your RDBMS will deturmin how you create your table or tables. These tables are written from the SQL Server point of view. You may need to adjust these for your RDBMS. If you wanted to capture schema changes then a table something like this would [...]
View Answer
| February 8, 2008 7:22 AM
Database, Database design
What you want to monitor and capture, as well as your RDBMS will deturmin how you create your table or tables. These tables are written from the SQL Server point of view. You may need to adjust these for your RDBMS. If you wanted to capture schema changes then a table something like this would [...]
View Answer
| February 8, 2008 7:22 AM
Database, Database design
Community Message: Answer these questions and earn Knowledge Points
You may want to review the links you provided. Some (for instance “What is the purpose of the OPEN command in RPG IV?” under the AS/400 tag) are not functioning. Others have answers in the discusssion section (though not in the answer section).
View Answer
| February 5, 2008 9:55 PM
AS/400, Database, DataCenter, Development, Exchange, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, VoIP
You may want to review the links you provided. Some (for instance “What is the purpose of the OPEN command in RPG IV?” under the AS/400 tag) are not functioning. Others have answers in the discusssion section (though not in the answer section).
View Answer
| February 5, 2008 9:55 PM
AS/400, Database, DataCenter, Development, Exchange, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Security, SQL Server, Storage, VoIP
Visual Basic IF statement…
You need to add in the Form field each time you use the OR function, as without specifying it, the statement does not know what it is evaluating against, hence the error message. i.e. If Forms![OrderProc].DelPostCode Like “BT*” Or Forms![OrderProc].DelPostCode Like “HS*” Then…. That will look very untidy if you add in 20 or statements. [...]
View Answer
| February 5, 2008 3:54 PM
Database, VBA
You need to add in the Form field each time you use the OR function, as without specifying it, the statement does not know what it is evaluating against, hence the error message. i.e. If Forms![OrderProc].DelPostCode Like “BT*” Or Forms![OrderProc].DelPostCode Like “HS*” Then…. That will look very untidy if you add in 20 or statements. [...]
View Answer
| February 5, 2008 3:54 PM
Database, VBA
Passing DataTable to Web Service Function
Grappling with similar problems for Web Services under ASP.NET 2.0x The issue is which objects can be “serialzed” so they go thru Web Services. The dataset is a sure bet. Web Services can pass datasets between themselves and/or client applications (Windows Forms clients or Web Site clients). The dataset can have zero or more data [...]
View Answer
| February 1, 2008 6:04 AM
Database, Web services
Grappling with similar problems for Web Services under ASP.NET 2.0x The issue is which objects can be “serialzed” so they go thru Web Services. The dataset is a sure bet. Web Services can pass datasets between themselves and/or client applications (Windows Forms clients or Web Site clients). The dataset can have zero or more data [...]
View Answer
| February 1, 2008 6:04 AM
Database, Web services
MS Access Query
You will need to try the subquery with inline paramteric joins. but you better had send me your table structure for the determination of actual query. m4atiq, m4atiq@yahoo.com
View Answer
| February 1, 2008 5:24 AM
Microsoft Access, Query
You will need to try the subquery with inline paramteric joins. but you better had send me your table structure for the determination of actual query. m4atiq, m4atiq@yahoo.com
View Answer
| February 1, 2008 5:24 AM
Microsoft Access, Query
retrieving data/tables through ODBC to Oracle
Yes it is. Install the Oracle ODBC drivers, and configure net+. Then you can create a DSN and use that to connect to the Oracle database and use the data in the table(s).
View Answer
| February 1, 2008 2:59 AM
Database, ODBC Oracle Access, Oracle
Yes it is. Install the Oracle ODBC drivers, and configure net+. Then you can create a DSN and use that to connect to the Oracle database and use the data in the table(s).
View Answer
| February 1, 2008 2:59 AM
Database, ODBC Oracle Access, Oracle
Is there a way to Call a Lotus Notes agent from Access code and pass Variables?
Certainly you can invoke an agent from Access — but you can’t pass parameters to an agent, even from within Notes/Domino, other than the NoteID of a saved NotesDocument. That being said, there’s no need to fire an agent — you have to connect to Notes via COM to invoke the agent anyway, and would [...]
View Answer
| January 31, 2008 9:04 PM
Lotus hotspot, Lotus Notes, Microsoft Access, Variables, Windows XP
Certainly you can invoke an agent from Access — but you can’t pass parameters to an agent, even from within Notes/Domino, other than the NoteID of a saved NotesDocument. That being said, there’s no need to fire an agent — you have to connect to Notes via COM to invoke the agent anyway, and would [...]
View Answer
| January 31, 2008 9:04 PM
Lotus hotspot, Lotus Notes, Microsoft Access, Variables, Windows XP
ECPI / ITT Tech (PLEASE HELP!)
If you have zero practical experience or are looking to start off at a base level in a company, then ITT/ECPI will provide you that foot in the door. You will pay a lot of money to get that door open. It won’t pay off for years. You’ll need to bust your ass for the [...]
View Answer
| January 31, 2008 6:44 PM
AAS, ECPI, IT careers
If you have zero practical experience or are looking to start off at a base level in a company, then ITT/ECPI will provide you that foot in the door. You will pay a lot of money to get that door open. It won’t pay off for years. You’ll need to bust your ass for the [...]
View Answer
| January 31, 2008 6:44 PM
AAS, ECPI, IT careers
convert a query from access to sql server 2005
You can order by any column that you wish. In SQL Server the syntax of ORDER BY is like this. <pre>SELECT * FROM Table ORDER BY Col1 ASC, Col3 DESC</pre> All data types use the same syntax. I assume that the ORDER BY would look something like this. <pre>ORDER BY isdate(Obsolete) DESC, isdate(not_relevant) DESC, isdate(assessed), [...]
View Answer
| January 29, 2008 1:35 AM
Microsoft Access, SQL Server 2005
You can order by any column that you wish. In SQL Server the syntax of ORDER BY is like this. <pre>SELECT * FROM Table ORDER BY Col1 ASC, Col3 DESC</pre> All data types use the same syntax. I assume that the ORDER BY would look something like this. <pre>ORDER BY isdate(Obsolete) DESC, isdate(not_relevant) DESC, isdate(assessed), [...]
View Answer
| January 29, 2008 1:35 AM
Microsoft Access, SQL Server 2005
Trying to enter back into a field
These says I’ve seen quite a few BAs working very closly with developers as well as the business units in order to help the business explain the issues that they are seeing with software applications. It’s typically much easer to do this when you have a good understanding of the software used to write the [...]
View Answer
| January 29, 2008 12:24 AM
Analytical tools, IT careers
These says I’ve seen quite a few BAs working very closly with developers as well as the business units in order to help the business explain the issues that they are seeing with software applications. It’s typically much easer to do this when you have a good understanding of the software used to write the [...]
View Answer
| January 29, 2008 12:24 AM
Analytical tools, IT careers
