Changing web server can access back office app through local host but not when it is on DMZ
We have a Windows 2003 web server, a SQL database, and a Sonic Wall. The existing web server is to be replaced. We can see and log into our back office application on the new server when we are looking at local host but when we put it into the DMZ we cannot log into [...]
Answer Question
| November 19, 2012 11:04 AM
DMZ, SQL Database, Windows Web Server 2003
We have a Windows 2003 web server, a SQL database, and a Sonic Wall. The existing web server is to be replaced. We can see and log into our back office application on the new server when we are looking at local host but when we put it into the DMZ we cannot log into [...]
Answer Question
| November 19, 2012 11:04 AM
DMZ, SQL Database, Windows Web Server 2003
Automation of PO expiation
Hi, My name is sreenu, and am working currently working on Maximo 5.2 ERP for procurement process. Question: – can we automate the process of PO copy expiation when the PO gets approved by the final approver by auto mailing process, rather than sending it manually to the supplier for expiation which is consume of [...]
Answer Question
| November 19, 2012 9:11 AM
ERP, Maximo 5.2
Hi, My name is sreenu, and am working currently working on Maximo 5.2 ERP for procurement process. Question: – can we automate the process of PO copy expiation when the PO gets approved by the final approver by auto mailing process, rather than sending it manually to the supplier for expiation which is consume of [...]
Answer Question
| November 19, 2012 9:11 AM
ERP, Maximo 5.2
Microsoft Outlook – attachments in weekly meetings from different email accounts
I have a WIN7 and Office 2010 installed. I use a personal email address – Exchange server and I have added to my Outlook a different mailbox – Exchange server, which is installed on a different machine under Outlook 2007. Let’s say my default email account is A, and the other email in B (which [...]
Answer Question
| November 19, 2012 2:16 AM
Microsoft Outlook 2010, Microsoft Outlook Calendar
I have a WIN7 and Office 2010 installed. I use a personal email address – Exchange server and I have added to my Outlook a different mailbox – Exchange server, which is installed on a different machine under Outlook 2007. Let’s say my default email account is A, and the other email in B (which [...]
Answer Question
| November 19, 2012 2:16 AM
Microsoft Outlook 2010, Microsoft Outlook Calendar
Why is my app so slow when writing from VB to Excel
What I use: An app where following procedure has to be run approx 100.000 times… it takes 5 minutes! It should go faster. Question=how? Dim Record as string Dim oExcel As Microsoft.Office.Interop.Excel.Application Dim EXCBook As Object, Range as object oExcel = New Microsoft.Office.Interop.Excel.Application EXCBook = oExcel.Workbooks.Open(TxtFolder.Text & “FBL.xlt”) Record = strLine & vbTab & strSort [...]
Answer Question
| November 19, 2012 2:37 PM
Microsoft Excel, Visual Basic
What I use: An app where following procedure has to be run approx 100.000 times… it takes 5 minutes! It should go faster. Question=how? Dim Record as string Dim oExcel As Microsoft.Office.Interop.Excel.Application Dim EXCBook As Object, Range as object oExcel = New Microsoft.Office.Interop.Excel.Application EXCBook = oExcel.Workbooks.Open(TxtFolder.Text & “FBL.xlt”) Record = strLine & vbTab & strSort [...]
Answer Question
| November 19, 2012 2:37 PM
Microsoft Excel, Visual Basic
Login for Tiger Ed
If I forgot my screen name and password for the Tiger Ed. Is there a way I can reset it or find out what it was?
Answer Question
| November 19, 2012 1:51 PM
Login, Login password
If I forgot my screen name and password for the Tiger Ed. Is there a way I can reset it or find out what it was?
Answer Question
| November 19, 2012 1:51 PM
Login, Login password
Encryption in PHP
How do I encrypt the URL in PHP?
Answer Question
| November 19, 2012 12:51 PM
PHP, PHP Coding
How do I encrypt the URL in PHP?
Answer Question
| November 19, 2012 12:51 PM
PHP, PHP Coding
About PHP code
I created a code for login. When the user name and password is correct, it redirects to another page. The problem is when a user logs in, the redirected page’s URL is seen. I don’t want the redirected page’s URL to be visible to users. What can I do? Please help.
Answer Question
| November 19, 2012 12:30 PM
PHP, PHP Coding
I created a code for login. When the user name and password is correct, it redirects to another page. The problem is when a user logs in, the redirected page’s URL is seen. I don’t want the redirected page’s URL to be visible to users. What can I do? Please help.
Answer Question
| November 19, 2012 12:30 PM
PHP, PHP Coding
SQL query
I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y….and so [...]
Answer Question
| November 18, 2012 10:36 AM
SQL 2008, SQL Server 2008
I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y….and so [...]
Answer Question
| November 18, 2012 10:36 AM
SQL 2008, SQL Server 2008
CPYF
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
How to access Exchange Server live
I have installed Exchange Server 2003 on a server which has a private IP like 192.168.1.4 now I want to access this server outside the domain which I created with a public IP 182.180.76.46 and access live and send and receive mails from other domains.
Answer Question
| November 19, 2012 6:34 PM
Exchange 2003, Exchange Server 2003
I have installed Exchange Server 2003 on a server which has a private IP like 192.168.1.4 now I want to access this server outside the domain which I created with a public IP 182.180.76.46 and access live and send and receive mails from other domains.
Answer Question
| November 19, 2012 6:34 PM
Exchange 2003, Exchange Server 2003
Communication Engineer career and certification options
I have got two bachelor of science degrees: in electrical engineering and computer science, from a university in africa. I have experience in public telephone switch (such as DMS 100 from Nortel, AXE-0 from Ericsson) and PABX (Alcatel OmniPCX 4400). What do you advise me I need to do to get employment opportunities and advance [...]
Answer Question
| November 17, 2012 7:08 AM
Career and training options
I have got two bachelor of science degrees: in electrical engineering and computer science, from a university in africa. I have experience in public telephone switch (such as DMS 100 from Nortel, AXE-0 from Ericsson) and PABX (Alcatel OmniPCX 4400). What do you advise me I need to do to get employment opportunities and advance [...]
Answer Question
| November 17, 2012 7:08 AM
Career and training options
Software
What is software? Why we use? Why it necessary to be update?
Answer Question
| November 19, 2012 4:41 AM
Software, Software development
What is software? Why we use? Why it necessary to be update?
Answer Question
| November 19, 2012 4:41 AM
Software, Software development
Microsoft Excel
Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and [...]
Answer Question
| November 19, 2012 12:47 AM
Microsoft Excel, microsoft excel functions
Gents: Could you please assist me in the below case: 1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one). 2- Excel B (target) has a special header and colors and contains 4 columns and [...]
Answer Question
| November 19, 2012 12:47 AM
Microsoft Excel, microsoft excel functions
Table setup
I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date – Quote # – Customer – Cust Quote # – Part # – Part Name – Quote Due Date – Qty – [...]
Answer Question
| November 19, 2012 11:39 PM
Microsoft Access, Microsoft Access spreadsheet
I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date – Quote # – Customer – Cust Quote # – Part # – Part Name – Quote Due Date – Qty – [...]
Answer Question
| November 19, 2012 11:39 PM
Microsoft Access, Microsoft Access spreadsheet
Find and Replace
I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?
Answer Question
| November 19, 2012 11:30 PM
Microsoft Excel 2010, microsoft excel functions
I have a spread sheet where I need to replace the space between each word with a hyphen. Since find & replace does not recognize space, is there another way to do this?
Answer Question
| November 19, 2012 11:30 PM
Microsoft Excel 2010, microsoft excel functions
Tax entity
What is the Tax Entity Field used for in the F0006?
Answer Question
| November 19, 2012 11:00 PM
JDE 9.0, JDE fields
What is the Tax Entity Field used for in the F0006?
Answer Question
| November 19, 2012 11:00 PM
JDE 9.0, JDE fields
How to convert QF file to Word document?
How do I convert QF file to Word 2010?
Answer Question
| November 19, 2012 10:02 PM
Microsoft Word 2010, QF File
How do I convert QF file to Word 2010?
Answer Question
| November 19, 2012 10:02 PM
Microsoft Word 2010, QF File
Lotus Code Needed
I’m trying to complete an @If statement to compare two fields in Input Validation. Field One: SL_1 (Values only can be 0 to 24) Field Two: D_1 (Values only can be 0 or 1) Current Code: @If((@ToNumber(D_1) > 1); @Failure(“Sunday needs to be a 0 or 1″);@Success) Additional Code Needed: If SL_1 = 0; D_1 [...]
Answer Question
| November 16, 2012 7:56 PM
Lotus Notes 8.1, Lotus Notes Fields
I’m trying to complete an @If statement to compare two fields in Input Validation. Field One: SL_1 (Values only can be 0 to 24) Field Two: D_1 (Values only can be 0 or 1) Current Code: @If((@ToNumber(D_1) > 1); @Failure(“Sunday needs to be a 0 or 1″);@Success) Additional Code Needed: If SL_1 = 0; D_1 [...]
Answer Question
| November 16, 2012 7:56 PM
Lotus Notes 8.1, Lotus Notes Fields
Link for Windows Server 2008 interview questions
Forward link where I get more knowledge for the Windows 2008 Server.
Answer Question
| November 16, 2012 5:08 PM
Windows Server 2008
Forward link where I get more knowledge for the Windows 2008 Server.
Answer Question
| November 16, 2012 5:08 PM
Windows Server 2008
Parameter Manipulation – Turning ‘abc’ type string into a number
I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ‘ – ‘ || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN ODS_OWNER.ORGANIZATIONAL_UNITS OU1 ON AD1.OU_CODE = OU1.OU_CODE WHERE PE1.POSITION_LEVEL = 1 AND COALESCE(PE1.END_DATE, CAST(’01/JAN/1753′ AS DATE)) = CAST(’01/JAN/1753′ AS DATE) –PE1.END_DATE [...]
Answer Question
| November 16, 2012 4:17 PM
Microsoft Visual Studio, ORA
I have the following code being used in a parameter: SELECT OU1.OU_CODE AS PROCESS_LEVEL , RTRIM(OU1.OU_CODE) || ‘ – ‘ || AD1.DEPARTMENT_NAME AS Description FROM ODS_OWNER.POSITION_ASSIGNMENTS PE1 JOIN ODS_OWNER.ADMIN_DEPARTMENTS AD1 ON PE1.DEPARTMENT_ID = AD1.DEPARTMENT_ID JOIN ODS_OWNER.ORGANIZATIONAL_UNITS OU1 ON AD1.OU_CODE = OU1.OU_CODE WHERE PE1.POSITION_LEVEL = 1 AND COALESCE(PE1.END_DATE, CAST(’01/JAN/1753′ AS DATE)) = CAST(’01/JAN/1753′ AS DATE) –PE1.END_DATE [...]
Answer Question
| November 16, 2012 4:17 PM
Microsoft Visual Studio, ORA
