AS400 Data Queue – Websphere ESB Integration?
Apexis,<a href=”http://www.apexis.cc”>network camera</a>,surveillance camera,video camera,ip camera,wireless ip camera,best ip camera,<a href=”http://www.apexis.cc”>wifi ip camera</a>,security ip camera,wireless webcam,ip camera online demo. ShenZhen Apexis Electronic Co.,Ltd Website: <a href=”http://www.apexis.cc”>http://www.apexis.cc</a> MSN: apexiswangchao@hotmail.com Email： apexiswangchao@hotmail.com Phone: 86 755 26509569-26509025 Fax: 86 755 26509229
View Answer
| August 20, 2011 2:32 AM
AS/400, Data Queue, ESB, WebSphere
Apexis,<a href=”http://www.apexis.cc”>network camera</a>,surveillance camera,video camera,ip camera,wireless ip camera,best ip camera,<a href=”http://www.apexis.cc”>wifi ip camera</a>,security ip camera,wireless webcam,ip camera online demo. ShenZhen Apexis Electronic Co.,Ltd Website: <a href=”http://www.apexis.cc”>http://www.apexis.cc</a> MSN: apexiswangchao@hotmail.com Email： apexiswangchao@hotmail.com Phone: 86 755 26509569-26509025 Fax: 86 755 26509229
View Answer
| August 20, 2011 2:32 AM
AS/400, Data Queue, ESB, WebSphere
SQL 2008 query: return results where row not in another table
Use the Exists and Not Exists predicates – these are designed for just these kinds of queries. Because the table you want to retrieve has a “like” string compare, it is a little trickier: <pre>select … from #tblExcept te1 where not exists (select 1 from #tblExcept te2, #tblWSErrs twe where — first make sure we [...]
View Answer
| August 18, 2011 6:38 PM
Query, SQL 2008, SQL Query, Subquery
Use the Exists and Not Exists predicates – these are designed for just these kinds of queries. Because the table you want to retrieve has a “like” string compare, it is a little trickier: <pre>select … from #tblExcept te1 where not exists (select 1 from #tblExcept te2, #tblWSErrs twe where — first make sure we [...]
View Answer
| August 18, 2011 6:38 PM
Query, SQL 2008, SQL Query, Subquery
One formula for a single column in Excel 2003
hii i m using ms access 2003 for calculation of closing stock date wise date . for that i have to use three table of opning stock , purchase table, issue table . in which the entry is done date wise date . i have to use the closing stock formula which is closing stock= [...]
View Answer
| August 17, 2011 11:54 AM
Excel 2003, Excel 2003 formulas, Excel formulas
hii i m using ms access 2003 for calculation of closing stock date wise date . for that i have to use three table of opning stock , purchase table, issue table . in which the entry is done date wise date . i have to use the closing stock formula which is closing stock= [...]
View Answer
| August 17, 2011 11:54 AM
Excel 2003, Excel 2003 formulas, Excel formulas
Free IT Book: Fedora and Red Hat Enterprise Linux
Hey All, Check out my answer for <b><a href=”http://itknowledgeexchange.techtarget.com/itanswers/server-2003-adding-mac-and-pc-to-same-domain/#viewquestion”>Windows Server 2003 adding MAC and PC to same domain</a></b>. Hope this helps! Paul NetLock Systems
View Answer
| August 16, 2011 3:39 AM
AS/400, Business Intelligence, 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
Hey All, Check out my answer for <b><a href=”http://itknowledgeexchange.techtarget.com/itanswers/server-2003-adding-mac-and-pc-to-same-domain/#viewquestion”>Windows Server 2003 adding MAC and PC to same domain</a></b>. Hope this helps! Paul NetLock Systems
View Answer
| August 16, 2011 3:39 AM
AS/400, Business Intelligence, 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
How to fix CTL3D32.dll error.
http://pcsupport.about.com/od/findbyerrormessage/a/ctl3d32-dll-not-found-missing-error.htm or Use this tool in safe mode http://simple-pc-help.com/download/repair-tool.php
View Answer
| August 16, 2011 1:33 AM
Error Code CTL3D32, Legacy software, Legacy systems, Office 1997
http://pcsupport.about.com/od/findbyerrormessage/a/ctl3d32-dll-not-found-missing-error.htm or Use this tool in safe mode http://simple-pc-help.com/download/repair-tool.php
View Answer
| August 16, 2011 1:33 AM
Error Code CTL3D32, Legacy software, Legacy systems, Office 1997
Free IT Book: Cisco Firewalls
Hey Guys, It looks like I shot myself in the foot. I guess I didn’t understand the directions lol. In any event, if anyone is interested, I answer the question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/permmissionswindows-7-pro/”><b>Windows 7 Professional permissions</b></a> Thanks Paul NetLock Systems
View Answer
| August 15, 2011 5:15 PM
AS/400, Business Intelligence, 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
Hey Guys, It looks like I shot myself in the foot. I guess I didn’t understand the directions lol. In any event, if anyone is interested, I answer the question <a href=”http://itknowledgeexchange.techtarget.com/itanswers/permmissionswindows-7-pro/”><b>Windows 7 Professional permissions</b></a> Thanks Paul NetLock Systems
View Answer
| August 15, 2011 5:15 PM
AS/400, Business Intelligence, 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
Open IT Forum: What data center fads should be avoided?
The answer is in the question. Avoid Fads. Full stop. ‘Data Centre’ = Computer Bureaux of the early 1970′s ‘Cloud Computing’ – see above. ‘Object oriented’ – refer to ‘subroutines’ ‘Thin Client’ – oh, you mean a terminal…. One of the latest fads si to conduct surveys of course…. Enough..
View Answer
| August 15, 2011 9:40 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Data center design, Data center design and infrastructure, Data Center management, Data center operations, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
The answer is in the question. Avoid Fads. Full stop. ‘Data Centre’ = Computer Bureaux of the early 1970′s ‘Cloud Computing’ – see above. ‘Object oriented’ – refer to ‘subroutines’ ‘Thin Client’ – oh, you mean a terminal…. One of the latest fads si to conduct surveys of course…. Enough..
View Answer
| August 15, 2011 9:40 AM
AS/400, Business Intelligence, Channel, CIO, CRM, Data center design, Data center design and infrastructure, Data Center management, Data center operations, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
To Access the details from gridview all row single cell
foreach (GridViewRow gvr in this.GridView1.Rows) { //get value from template field, //5 is the index of your template field string textboxValue = ((TextBox)gvr.Cells[5].FindControl(“textbox1″)).Text; //update to db method }
View Answer
| August 12, 2011 12:06 PM
.NET, ASP.NET, ASP.NET 3.5, DataGridView
foreach (GridViewRow gvr in this.GridView1.Rows) { //get value from template field, //5 is the index of your template field string textboxValue = ((TextBox)gvr.Cells[5].FindControl(“textbox1″)).Text; //update to db method }
View Answer
| August 12, 2011 12:06 PM
.NET, ASP.NET, ASP.NET 3.5, DataGridView
Log file copy time
Robocopy (free) does this. It has a summary at the end of the log that gives you a bunch of summary statistics.. very helpful!
View Answer
| August 11, 2011 2:05 AM
Batch file, Batch files, Scripts, VB script
Robocopy (free) does this. It has a summary at the end of the log that gives you a bunch of summary statistics.. very helpful!
View Answer
| August 11, 2011 2:05 AM
Batch file, Batch files, Scripts, VB script
Update SQL Server 2005 Scripts
Hello DJ, For the first request, you can use <pre> UPDATE iweb_conf_demo SET Attendee_ribbons = NULL</pre> This will clear ALL information from that field in the table. Also, this step seems unnecessary as you will be replacing the values anyway. For your second request, based on what I could gather about the structure of the [...]
View Answer
| August 10, 2011 3:36 PM
SQL, SQL scripts, SQL Server 2005, SQL Server Scripts
Hello DJ, For the first request, you can use <pre> UPDATE iweb_conf_demo SET Attendee_ribbons = NULL</pre> This will clear ALL information from that field in the table. Also, this step seems unnecessary as you will be replacing the values anyway. For your second request, based on what I could gather about the structure of the [...]
View Answer
| August 10, 2011 3:36 PM
SQL, SQL scripts, SQL Server 2005, SQL Server Scripts
Macro Script on AS/400
Pradeep, are you referring to a Client Access Macro script? Are you calling something from a menu? More details are needed I think… I’ve not used Macros from Client Access a whole lot, but I’m not aware of a way to run them automatically. Your PC would have to be on with an active logged [...]
View Answer
| August 10, 2011 2:43 PM
AS/400, AS/400 macros, Macros
Pradeep, are you referring to a Client Access Macro script? Are you calling something from a menu? More details are needed I think… I’ve not used Macros from Client Access a whole lot, but I’m not aware of a way to run them automatically. Your PC would have to be on with an active logged [...]
View Answer
| August 10, 2011 2:43 PM
AS/400, AS/400 macros, Macros
Drag and drop PDF files in VB 6.0
Certain VB6 controls have “automatic” drag/drop capability. Textbox, Filelistbox & Dirlistbox support OLE drag drop properties. BTW: Carlosdl could run rings around me on this stuff. I just happen to keep a copy of VB6 Unleashed around & looked it up for you. How to actually use them? Wouldn’t have a clue. Gary —– Thanks [...]
View Answer
| August 9, 2011 8:15 PM
PDF, PDF Files, VB 6.0, Visual Basic 6.0
Certain VB6 controls have “automatic” drag/drop capability. Textbox, Filelistbox & Dirlistbox support OLE drag drop properties. BTW: Carlosdl could run rings around me on this stuff. I just happen to keep a copy of VB6 Unleashed around & looked it up for you. How to actually use them? Wouldn’t have a clue. Gary —– Thanks [...]
View Answer
| August 9, 2011 8:15 PM
PDF, PDF Files, VB 6.0, Visual Basic 6.0
Display date in Oracle Toad
Why not to use the Months_Between function: Firstly you should visit <a href=”http://www.sql-performance-tuning.com/oracle-sql-functions/”>this</a> website, where you will find complete list of Oracle sql functions and <a href=”http://www.sql-performance-tuning.com/oracle-date-format/”>this</a> website where you will find complete list of Oracle date format elements. This should also help you for your future work. <b>SQL function MONTHS_BETWEEN</b> The MONTHS_BETWEEN function calculates [...]
View Answer
| August 9, 2011 7:11 AM
Oracle, Oracle Database, TOAD, Toad Data Modeler
Why not to use the Months_Between function: Firstly you should visit <a href=”http://www.sql-performance-tuning.com/oracle-sql-functions/”>this</a> website, where you will find complete list of Oracle sql functions and <a href=”http://www.sql-performance-tuning.com/oracle-date-format/”>this</a> website where you will find complete list of Oracle date format elements. This should also help you for your future work. <b>SQL function MONTHS_BETWEEN</b> The MONTHS_BETWEEN function calculates [...]
View Answer
| August 9, 2011 7:11 AM
Oracle, Oracle Database, TOAD, Toad Data Modeler
Visual Basic executable
You create an installer package including all necessary files. You can use the Package and Deployment wizard for that purpose.
View Answer
| August 8, 2011 1:49 PM
VB 6, Visual Basic, Visual Basic 6.0
You create an installer package including all necessary files. You can use the Package and Deployment wizard for that purpose.
View Answer
| August 8, 2011 1:49 PM
VB 6, Visual Basic, Visual Basic 6.0
Absolute Positioning of controls in ASP.NET 3.5
Drag and drop any control ,go to source for control code. Write the following code at the end of control open tag. and goto designer just move the control where ever u want. Do the same thing for all controls. Or the another way go to menu >Layout>position>Absolute>ok Thanks and regards Shivaprasad ThanksSelvaAnna University
View Answer
| February 11, 2013 5:28 AM
Active Server Pages, ASP.NET, ASP.NET3.5, Interface design, Web development
Drag and drop any control ,go to source for control code. Write the following code at the end of control open tag. and goto designer just move the control where ever u want. Do the same thing for all controls. Or the another way go to menu >Layout>position>Absolute>ok Thanks and regards Shivaprasad ThanksSelvaAnna University
View Answer
| February 11, 2013 5:28 AM
Active Server Pages, ASP.NET, ASP.NET3.5, Interface design, Web development
Open IT Forum: What to consider when building a data center?
Planning ahead is key. Servers are getting smaller and smaller so you’ll need more and more power and cooling available per rack the longer the data center will be up and running. One company I worked at didn’t plan well and could only use 3/4 of each rack in the data center because there wasn’t [...]
View Answer
| August 3, 2011 6:17 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data Center Build, Data center design and infrastructure, Data Center management, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Planning ahead is key. Servers are getting smaller and smaller so you’ll need more and more power and cooling available per rack the longer the data center will be up and running. One company I worked at didn’t plan well and could only use 3/4 of each rack in the data center because there wasn’t [...]
View Answer
| August 3, 2011 6:17 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data Center Build, Data center design and infrastructure, Data Center management, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
How to parse text from a file and paste results into stationery in Notes 6.5
Something like this should add what you want at the current position of the cursor. This is an agent code, if added in a button, it should be slightly different : focus would be on the button instead of in the text. <pre> Sub Initialize Dim oSesion As New NotesSession Dim ouiWS As New NotesUIWorkspace [...]
View Answer
| August 2, 2011 1:48 PM
Lotus Notes, Lotus Notes Script, LotusScript, Parsing
Something like this should add what you want at the current position of the cursor. This is an agent code, if added in a button, it should be slightly different : focus would be on the button instead of in the text. <pre> Sub Initialize Dim oSesion As New NotesSession Dim ouiWS As New NotesUIWorkspace [...]
View Answer
| August 2, 2011 1:48 PM
Lotus Notes, Lotus Notes Script, LotusScript, Parsing
ASP.net SQL Server Need Experienced Webdeveloper
How many month experience person you need?
View Answer
| August 2, 2011 4:45 AM
ASP.NET, C#, CSS, HTML, java script, MS SQL Server, MS Visual Studio
How many month experience person you need?
View Answer
| August 2, 2011 4:45 AM
ASP.NET, C#, CSS, HTML, java script, MS SQL Server, MS Visual Studio
Programming quiz – Excel, VB etc.
First I created a function to take three digits and turn them into a six digit palindrome: Public Function palin(numb As Integer) As Long palin = 100001 * Mid(numb, 1, 1) + 10010 * Mid(numb, 2, 1) + 1100 * Mid(numb, 3, 1) End Function Then I created a sub with a double loop to [...]
View Answer
| August 1, 2011 6:05 PM
C, COBOL, excel, VB
First I created a function to take three digits and turn them into a six digit palindrome: Public Function palin(numb As Integer) As Long palin = 100001 * Mid(numb, 1, 1) + 10010 * Mid(numb, 2, 1) + 1100 * Mid(numb, 3, 1) End Function Then I created a sub with a double loop to [...]
View Answer
| August 1, 2011 6:05 PM
C, COBOL, excel, VB
Passing a Memory Variable from a Form to a Reprt in Access 2007
The reason it doesn’t work is that the variables of a form are not available to a report. If you make a hidden field on the form (for example MyFormReportTitle) and set the title in that field before you run that report, you can reference it in the report. So in the on open event [...]
View Answer
| August 1, 2011 4:15 PM
Variables
The reason it doesn’t work is that the variables of a form are not available to a report. If you make a hidden field on the form (for example MyFormReportTitle) and set the title in that field before you run that report, you can reference it in the report. So in the on open event [...]
View Answer
| August 1, 2011 4:15 PM
Variables
