which algorithm is used in HTTPS?
HTTPS (Hypertext Transfer Protocol over Secure Socket Layer, or HTTP over SSL) is a Web protocol developed by Netscape and built into browser applications that encrypts and decrypts user page requests as well as the pages that are returned by the Web server. HTTPS doesn’t specify one specific encryption algorithm, or cipher, to use. The [...]
View Answer
| July 8, 2008 9:04 PM
HTTPS, SSL, Web development
HTTPS (Hypertext Transfer Protocol over Secure Socket Layer, or HTTP over SSL) is a Web protocol developed by Netscape and built into browser applications that encrypts and decrypts user page requests as well as the pages that are returned by the Web server. HTTPS doesn’t specify one specific encryption algorithm, or cipher, to use. The [...]
View Answer
| July 8, 2008 9:04 PM
HTTPS, SSL, Web development
Explaining certain functions in SQL
The MOD function in T/SQL is actually the % which is the modulo operator. From Books OnLine: <pre>Returns the remainder of one number divided by another. SELECT 38 / 5 AS Integer, 38 % 5 AS Remainder ;</pre> The ROUND function takes a number with a decimal place and rounds it to the nearest while [...]
View Answer
| July 8, 2008 6:38 PM
Functions, SQL, SQL statements
The MOD function in T/SQL is actually the % which is the modulo operator. From Books OnLine: <pre>Returns the remainder of one number divided by another. SELECT 38 / 5 AS Integer, 38 % 5 AS Remainder ;</pre> The ROUND function takes a number with a decimal place and rounds it to the nearest while [...]
View Answer
| July 8, 2008 6:38 PM
Functions, SQL, SQL statements
Having trouble writing the output of a CmdLine entry for the dsquery utility
In a DOS prompt situation or with batch files I like to use this: [command] > sample.txt Does this help?
View Answer
| July 8, 2008 4:20 PM
Active Directory, VBScript
In a DOS prompt situation or with batch files I like to use this: [command] > sample.txt Does this help?
View Answer
| July 8, 2008 4:20 PM
Active Directory, VBScript
Batch debug
Hi, You can use STRSRVJOB to put the job into “service mode”, then use STRISDB the same way as you would normally, but without calling the program :- STRISDB PGM(Yourlib/Yourpgm) INVPGM(*NO) Once your program gets called by the batch job, the interactive debugger should start up allowing you to work the same way you do [...]
View Answer
| July 8, 2008 3:52 PM
Batch debugging, Debugging
Hi, You can use STRSRVJOB to put the job into “service mode”, then use STRISDB the same way as you would normally, but without calling the program :- STRISDB PGM(Yourlib/Yourpgm) INVPGM(*NO) Once your program gets called by the batch job, the interactive debugger should start up allowing you to work the same way you do [...]
View Answer
| July 8, 2008 3:52 PM
Batch debugging, Debugging
SQL: Using a column created in the SELECT in the WHERE CLAUSE
Sorry, I had a typing error in the question. I ment to say …”with ‘AS’ in the SELECT clause”… Ray You need to use the origional Column name and not the alias when referencing the column as part of the WHERE clause. For Example: <pre>SELECT Col3-Col1 AS Value1 FROM YourTable WHERE Col3-Col1 > 3</pre> Alternatively, [...]
View Answer
| July 8, 2008 3:52 PM
SELECT statement, SQL, SQL statements
Sorry, I had a typing error in the question. I ment to say …”with ‘AS’ in the SELECT clause”… Ray You need to use the origional Column name and not the alias when referencing the column as part of the WHERE clause. For Example: <pre>SELECT Col3-Col1 AS Value1 FROM YourTable WHERE Col3-Col1 > 3</pre> Alternatively, [...]
View Answer
| July 8, 2008 3:52 PM
SELECT statement, SQL, SQL statements
Excluding Data Usin NOT IN
Use Charindex to find position of ‘[' I have put the first line into a variable (@c) but this will work if you use column name instead of variable declare @c varchar(300) set @c='Allow CREATOR OWNER [Full Control]‘ select Left(@c,Len(@c)- CHARINDEX ( ‘[', @c COLLATE Latin1_General_BIN)) as FullName, Right(@c,Len(@c)- CHARINDEX ( '[', @c COLLATE Latin1_General_BIN)) [...]
View Answer
| July 8, 2008 3:32 PM
SQL Server permissions, SQL Server reporting, SQL statements
Use Charindex to find position of ‘[' I have put the first line into a variable (@c) but this will work if you use column name instead of variable declare @c varchar(300) set @c='Allow CREATOR OWNER [Full Control]‘ select Left(@c,Len(@c)- CHARINDEX ( ‘[', @c COLLATE Latin1_General_BIN)) as FullName, Right(@c,Len(@c)- CHARINDEX ( '[', @c COLLATE Latin1_General_BIN)) [...]
View Answer
| July 8, 2008 3:32 PM
SQL Server permissions, SQL Server reporting, SQL statements
where does in memory the contant variable in C get store?
Technically, variables of this type are considered Static constants (static const). When executing, these would be created in ROM. As you know, PC’s don’t have ROM, so the stack is mimicked in RAM. This mimicking is actually the process of grouping the static constant variables with other variables in RAM that are static but are [...]
View Answer
| July 8, 2008 1:38 PM
C++, Const statement, Variables
Technically, variables of this type are considered Static constants (static const). When executing, these would be created in ROM. As you know, PC’s don’t have ROM, so the stack is mimicked in RAM. This mimicking is actually the process of grouping the static constant variables with other variables in RAM that are static but are [...]
View Answer
| July 8, 2008 1:38 PM
C++, Const statement, Variables
Create a sequence called Store_seq with the following values: increment by 10, start with 500
VB RD, your questions appear very similar to questions from a course or exam. If so, this community isn’t the place to request help for that type of thing. If you have attempted to code a solution and failed, then post your code and ask for advice or assistance for the problem that has you [...]
View Answer
| July 8, 2008 12:54 PM
SQL Query, SQL sequences
VB RD, your questions appear very similar to questions from a course or exam. If so, this community isn’t the place to request help for that type of thing. If you have attempted to code a solution and failed, then post your code and ask for advice or assistance for the problem that has you [...]
View Answer
| July 8, 2008 12:54 PM
SQL Query, SQL sequences
Device DiscoveryinNetwork
This <a href=”http://search.cpan.org/~wmarq/SNMP-Util-1.8/Util.pm”>perl script example</a> may help. This <a href=”http://www.enterprisenetworkingplanet.com/netos/article.php/3697071″>article</a> may also give some guidance for this activity.
View Answer
| July 8, 2008 11:32 AM
Device discovery, Networking, Perl
This <a href=”http://search.cpan.org/~wmarq/SNMP-Util-1.8/Util.pm”>perl script example</a> may help. This <a href=”http://www.enterprisenetworkingplanet.com/netos/article.php/3697071″>article</a> may also give some guidance for this activity.
View Answer
| July 8, 2008 11:32 AM
Device discovery, Networking, Perl
i upgraded my vb6 database from sql 2000 to sql 2005 server.The same vb code is not working.What changes should i make in the code sothat it can work in sql 2005??
You’ll want to change out to using the SQL 2005 OLE driver. All the T/SQL code should work fine. At a prior company we had a VB6 application which was using a SQL 2000 database. We upgraded to SQL 2005 with no problem. We were using about 98% stored procedures. What errors are you getting, [...]
View Answer
| July 8, 2008 8:09 AM
Software maintenance, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB, Visual Basic 6
You’ll want to change out to using the SQL 2005 OLE driver. All the T/SQL code should work fine. At a prior company we had a VB6 application which was using a SQL 2000 database. We upgraded to SQL 2005 with no problem. We were using about 98% stored procedures. What errors are you getting, [...]
View Answer
| July 8, 2008 8:09 AM
Software maintenance, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB, Visual Basic 6
How to count all the unique users for Domains from all NAB groups.
Among the nearly infinite numbers of doing this, here are some ideas. Create a copy of the view “Groups.” Call the new view “Group Members Full”. Delete all the columns except the Group column. Add a new Categorized column before Group. Call that column “Name.” Choose the field Members as the contents for the column. [...]
View Answer
| July 7, 2008 2:30 PM
Application development, Developing secure applications, Lotus, Lotus Domino, NAB
Among the nearly infinite numbers of doing this, here are some ideas. Create a copy of the view “Groups.” Call the new view “Group Members Full”. Delete all the columns except the Group column. Add a new Categorized column before Group. Call that column “Name.” Choose the field Members as the contents for the column. [...]
View Answer
| July 7, 2008 2:30 PM
Application development, Developing secure applications, Lotus, Lotus Domino, NAB
Intercept the Paste command in VB.NET
Try adding the function to the OnChange event or the MouseClick event (I think that both exist).
View Answer
| July 6, 2008 8:09 PM
Development, VB.NET, Visual Basic .NET
Try adding the function to the OnChange event or the MouseClick event (I think that both exist).
View Answer
| July 6, 2008 8:09 PM
Development, VB.NET, Visual Basic .NET
Recording cell value changes to another cell in excel using a macro
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 14, 2013 10:31 AM
Excel 2003, Excel macros
Thank you for visiting ITKE. We are happy to help you with solving specific IT questions, but need as much information as possible to do so. Let us know about the problem you are trying to solve, how you are approaching it and what work you’ve done so far, and we can help guide you [...]
View Answer
| May 14, 2013 10:31 AM
Excel 2003, Excel macros
How to call a COBOL program from Java
Hi, I’m not a java person and it’s been mnay years since I’ve used COBOL, so maybe I’m stating the obvious here, but if the user doesn’t select CANCEL, then you should do a COMMIT to apply your changes. I’m also assuming that your data files are journalled as necessary to work correctly within the [...]
View Answer
| July 4, 2008 12:03 PM
COBOL, Java, Web services
Hi, I’m not a java person and it’s been mnay years since I’ve used COBOL, so maybe I’m stating the obvious here, but if the user doesn’t select CANCEL, then you should do a COMMIT to apply your changes. I’m also assuming that your data files are journalled as necessary to work correctly within the [...]
View Answer
| July 4, 2008 12:03 PM
COBOL, Java, Web services
Linked Servers????
Check out a product called Spiceworks….works great for me and includes a help desk…. From Ritchie1: the linked server idea should required the least amount of work on your part if the data is already stored in a sql server database. There is no need to write an application to parse it etc then put [...]
View Answer
| July 4, 2008 9:46 AM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003
Check out a product called Spiceworks….works great for me and includes a help desk…. From Ritchie1: the linked server idea should required the least amount of work on your part if the data is already stored in a sql server database. There is no need to write an application to parse it etc then put [...]
View Answer
| July 4, 2008 9:46 AM
Database, Enterprise Manager, Linked servers, SQL, Windows Server, Windows Server 2003
Creating and importing data into a relational database
Start with getting your all your requirements laid out. After you have them, you can start dealing with your database design. You may want to see if your group has someone with some more design experience as it sounds like your database design may be rather complex. This probably isn’t the best database to be [...]
View Answer
| July 4, 2008 9:30 AM
C#, Microsoft Excel, Relational database management software
Start with getting your all your requirements laid out. After you have them, you can start dealing with your database design. You may want to see if your group has someone with some more design experience as it sounds like your database design may be rather complex. This probably isn’t the best database to be [...]
View Answer
| July 4, 2008 9:30 AM
C#, Microsoft Excel, Relational database management software
Concentrate more than two fields together into one field in SQL
SQL Server doesn’t have the STRIP and CONCATINATION functions which were mentioned in the prior version of the answer. You use the + sign to join the strings together, something like this. <pre>SELECT FirstName + ', ' + CASE WHEN MiddleName IS NULL THEN '' ELSE MiddleName + ', ' END + LastName FROM YourTable</pre> [...]
View Answer
| April 19, 2013 9:06 AM
Concatenate, CSV, SQL, SQL Server
SQL Server doesn’t have the STRIP and CONCATINATION functions which were mentioned in the prior version of the answer. You use the + sign to join the strings together, something like this. <pre>SELECT FirstName + ', ' + CASE WHEN MiddleName IS NULL THEN '' ELSE MiddleName + ', ' END + LastName FROM YourTable</pre> [...]
View Answer
| April 19, 2013 9:06 AM
Concatenate, CSV, SQL, SQL Server
Mainframe COBOL – The OVERFLOW Condition.
I believe there is an ON SIZE ERROR option which allows the application to do a function, such as DISPLAY ……. I think you need to specify this in the source code – and unfortunately, the only way to implement this is to search/add this option to your source code. You might want to look [...]
View Answer
| July 3, 2008 2:45 PM
COBOL, Error handling, Programming Languages, z/OS
I believe there is an ON SIZE ERROR option which allows the application to do a function, such as DISPLAY ……. I think you need to specify this in the source code – and unfortunately, the only way to implement this is to search/add this option to your source code. You might want to look [...]
View Answer
| July 3, 2008 2:45 PM
COBOL, Error handling, Programming Languages, z/OS
Is SAP generates any signal for outside application(Such as visual Basic) after generating Picking List (MB26) ?
there are multiple ways to generate a signal for a non-SAP application, or to interact directly with a non SAP application. BAPI / BADi can be used to communicate directly from an external program (usually, but not limited to a C variant) and an SAP structure of Function. This is a to and fro type [...]
View Answer
| July 3, 2008 3:52 AM
Picking List, SAP, Visual Basic
there are multiple ways to generate a signal for a non-SAP application, or to interact directly with a non SAP application. BAPI / BADi can be used to communicate directly from an external program (usually, but not limited to a C variant) and an SAP structure of Function. This is a to and fro type [...]
View Answer
| July 3, 2008 3:52 AM
Picking List, SAP, Visual Basic
Javascript calendar display works fine in IE7 & FF, but not in Opera.
This only took a couple of min. to track down, so ignore the other members’ non-answers. They shouldn’t get points for that. There seems to be a bug in Opera (might be fixed in 9.5) when using the Date constructor with 0: <pre>var lastDate = new Date(String(monthNum+1)+”/0/”+String(yearNum));</pre> In FF and IE this sets the date [...]
View Answer
| July 2, 2008 8:27 PM
Calendar, firefox, IE7, JavaScript, Opera, Web development
This only took a couple of min. to track down, so ignore the other members’ non-answers. They shouldn’t get points for that. There seems to be a bug in Opera (might be fixed in 9.5) when using the Date constructor with 0: <pre>var lastDate = new Date(String(monthNum+1)+”/0/”+String(yearNum));</pre> In FF and IE this sets the date [...]
View Answer
| July 2, 2008 8:27 PM
Calendar, firefox, IE7, JavaScript, Opera, Web development
