Is it possible to use Javascript to pull data from a cell within an Excel spreadsheet when the notes form is displayed via a browser ? IE 5.5 or above.
Generally speaking, you can use Javascript to populate data from one window to another. In the terms of a window opened from another window, it’s fairly easy by understanding the proper references. The first window is refered to as the window.opener.document and the second window is strickly the window.document. So to populate you would use [...]
View Answer
| January 12, 2005 6:47 AM
Development, Domino Designer
Generally speaking, you can use Javascript to populate data from one window to another. In the terms of a window opened from another window, it’s fairly easy by understanding the proper references. The first window is refered to as the window.opener.document and the second window is strickly the window.document. So to populate you would use [...]
View Answer
| January 12, 2005 6:47 AM
Development, Domino Designer
COM ports
Our Field Service people require the use of serial ports to communicate with PLC’s. The SIIG, Inc. model lo1037 Single Serial PC Card (Type II/III Card Slot) provides stable communications and cost about $50.00.
View Answer
| January 11, 2005 10:43 AM
DataCenter, Development, Hardware, Networking
Our Field Service people require the use of serial ports to communicate with PLC’s. The SIIG, Inc. model lo1037 Single Serial PC Card (Type II/III Card Slot) provides stable communications and cost about $50.00.
View Answer
| January 11, 2005 10:43 AM
DataCenter, Development, Hardware, Networking
i cant send and receive my mails
Please give the details of what mail server u are using and what error do u get when you open the outlook. Is it only you are not getting mails and what is your set-up. Thanks
View Answer
| January 11, 2005 6:10 AM
Development, Exchange, Networking
Please give the details of what mail server u are using and what error do u get when you open the outlook. Is it only you are not getting mails and what is your set-up. Thanks
View Answer
| January 11, 2005 6:10 AM
Development, Exchange, Networking
Learning VB.net or ASP
The best place to start is: http://lab.msdn.microsoft.com/express/ There’s free downloads of everything you need including the msde of sql server. The development tools are great, but you’ll need to “unlearn” things because many common tasks now take a lot less coding … check out gridview, what a slam dunk. Setting up isn’t exactly easy but [...]
View Answer
| January 10, 2005 8:42 AM
ASP, VB.NET
The best place to start is: http://lab.msdn.microsoft.com/express/ There’s free downloads of everything you need including the msde of sql server. The development tools are great, but you’ll need to “unlearn” things because many common tasks now take a lot less coding … check out gridview, what a slam dunk. Setting up isn’t exactly easy but [...]
View Answer
| January 10, 2005 8:42 AM
ASP, VB.NET
Multi-DataTable Joins
You can do this, but the way is indirect. The key to your path is the ADO.NET DataRelation Class. You can find pre-written help on Microsoft’s support site: 326080 HOW TO: Implement a DataSet JOIN helper class in Visual C# .NET http://support.microsoft.com/default.aspx/kb/326080/EN-US/? Or, 325688 HOWTO: Implement a DataSet JOIN helper class in Visual Basic .NET [...]
View Answer
| January 9, 2005 11:19 PM
Development
You can do this, but the way is indirect. The key to your path is the ADO.NET DataRelation Class. You can find pre-written help on Microsoft’s support site: 326080 HOW TO: Implement a DataSet JOIN helper class in Visual C# .NET http://support.microsoft.com/default.aspx/kb/326080/EN-US/? Or, 325688 HOWTO: Implement a DataSet JOIN helper class in Visual Basic .NET [...]
View Answer
| January 9, 2005 11:19 PM
Development
How to monitor and manage lan gateway from a helius router?
I am not familiar with the Helius Router, but a quick search indicates it is a directway broadcaster. A one to many stream feed. In any case if you want a content manager/blocker and have a choke point (i.e. one point of access to the internet) and this router appears to be it. Setup a [...]
View Answer
| January 9, 2005 11:52 AM
Application software, Auditing, DataCenter, Integration/Connectivity, Linux, Networking Products, Routers, Security, Security management, Servers, System monitoring, System utilities, Unix, Windows 2000 Server, Windows client administration and maintenance, Windows XP
I am not familiar with the Helius Router, but a quick search indicates it is a directway broadcaster. A one to many stream feed. In any case if you want a content manager/blocker and have a choke point (i.e. one point of access to the internet) and this router appears to be it. Setup a [...]
View Answer
| January 9, 2005 11:52 AM
Application software, Auditing, DataCenter, Integration/Connectivity, Linux, Networking Products, Routers, Security, Security management, Servers, System monitoring, System utilities, Unix, Windows 2000 Server, Windows client administration and maintenance, Windows XP
bar code label / advanced form design / printing solutions
We are currently using T.L. Ashford (Barcode/400). It is really greate. It’s easy to learn and use. The installation was done easily. We are using Zebra S600 printers. Basically we didn’t have any major issue with it. There were a few minor issues with printers, but the T.L. Ashford support team are very Knowledgeable and [...]
View Answer
| January 7, 2005 10:23 AM
Application software, CIO, Development, Vendor support, Vendors
We are currently using T.L. Ashford (Barcode/400). It is really greate. It’s easy to learn and use. The installation was done easily. We are using Zebra S600 printers. Basically we didn’t have any major issue with it. There were a few minor issues with printers, but the T.L. Ashford support team are very Knowledgeable and [...]
View Answer
| January 7, 2005 10:23 AM
Application software, CIO, Development, Vendor support, Vendors
Database choice for web application
A – SQL Server. (that is period) Access is good for developement, good for small workgroups, good anywhere the Input/Output/Update is linear and NOT prone to multiple simultaneous requests. SQL Server is scalable, built for simultaneous requests, and an easy fit with ASP.ASP.NET. You said there would be multiple databases – has to be SQL [...]
View Answer
| January 7, 2005 7:25 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services
A – SQL Server. (that is period) Access is good for developement, good for small workgroups, good anywhere the Input/Output/Update is linear and NOT prone to multiple simultaneous requests. SQL Server is scalable, built for simultaneous requests, and an easy fit with ASP.ASP.NET. You said there would be multiple databases – has to be SQL [...]
View Answer
| January 7, 2005 7:25 AM
Database Management Systems, DataCenter, Development, SQL Server, Web development tools, Web services
VS.NET SETUP project for .NET Framework 1.0
In regards to a Visual Studio setup project, I don’t know if it’s possible, b/c I think it uses 1.1 code internally (allowing you to run custom scripts, etc.). Another possibility would be to use something like InnoSetup (which is free). www.jrsoftware.org HTH, John Barone
View Answer
| January 7, 2005 6:41 AM
C, VB.NET, Visual Basic
In regards to a Visual Studio setup project, I don’t know if it’s possible, b/c I think it uses 1.1 code internally (allowing you to run custom scripts, etc.). Another possibility would be to use something like InnoSetup (which is free). www.jrsoftware.org HTH, John Barone
View Answer
| January 7, 2005 6:41 AM
C, VB.NET, Visual Basic
Rexx as400 – IO utility (or how to read more than one file)
This was published in a Club Tech iSeries Programming Tips Newsletter: 4. READING TWO FILES IN A REXX PROGRAM Q: Is it possible to read more than one file in a REXX program? According to the documentation I have read so far, I can specify something such as LineIn(MyFile). I’m working on the iSeries, and [...]
View Answer
| January 6, 2005 9:34 AM
Development
This was published in a Club Tech iSeries Programming Tips Newsletter: 4. READING TWO FILES IN A REXX PROGRAM Q: Is it possible to read more than one file in a REXX program? According to the documentation I have read so far, I can specify something such as LineIn(MyFile). I’m working on the iSeries, and [...]
View Answer
| January 6, 2005 9:34 AM
Development
Dialoge box in Excel
Don’t assign the macro to the command button. Instead, right click on the command button and choose “View Code.” This will open the Microsoft Visual Basic window and start the code for the command button’s click event. The following code should do what you’re looking for: Private Sub CommandButton1_Click If MsgBox (“Do you want to [...]
View Answer
| January 5, 2005 2:43 PM
Visual Basic
Don’t assign the macro to the command button. Instead, right click on the command button and choose “View Code.” This will open the Microsoft Visual Basic window and start the code for the command button’s click event. The following code should do what you’re looking for: Private Sub CommandButton1_Click If MsgBox (“Do you want to [...]
View Answer
| January 5, 2005 2:43 PM
Visual Basic
Access from internet
Hi, I’m a little suspicious you should have to ask this here. There are a number of ways of doing this using a variety of programs. But since you have a proxy on this network, you should be asking the network admin who set this up. The proxy is there for a reason and for [...]
View Answer
| January 4, 2005 7:39 AM
DataCenter, DHCP, DNS, Networking, Networking services, Software Quality Assurance, Tech support
Hi, I’m a little suspicious you should have to ask this here. There are a number of ways of doing this using a variety of programs. But since you have a proxy on this network, you should be asking the network admin who set this up. The proxy is there for a reason and for [...]
View Answer
| January 4, 2005 7:39 AM
DataCenter, DHCP, DNS, Networking, Networking services, Software Quality Assurance, Tech support
Creating Database Trigger
v_SAL EMP2.SAL%TYPE; BEGIN v_SAL := :NEW.SAL; IF v_SAL > 20000 THEN LOOP UPDATE EMP SET SAL = 20000 WHERE EMP.EMPNO = :NEW.EMPNO; END LOOP; END IF; Not knowing Oracle, here is my guess instead of SET SAL = how about SET NEW.SAL =
View Answer
| January 2, 2005 8:52 AM
Development
v_SAL EMP2.SAL%TYPE; BEGIN v_SAL := :NEW.SAL; IF v_SAL > 20000 THEN LOOP UPDATE EMP SET SAL = 20000 WHERE EMP.EMPNO = :NEW.EMPNO; END LOOP; END IF; Not knowing Oracle, here is my guess instead of SET SAL = how about SET NEW.SAL =
View Answer
| January 2, 2005 8:52 AM
Development
Multiple result sets returned from embedded SQL in RPG
Hi to all, I don’t understand very exactly your question, because you refer to an UPDATE statement and, as per my knowledge, for update statements you don’t need neither to declare any cursor nor to fetch records from it. You simply need to execute the SQL command. Depending on your host environment, executing the command [...]
View Answer
| January 2, 2005 5:59 AM
RPG, SQL
Hi to all, I don’t understand very exactly your question, because you refer to an UPDATE statement and, as per my knowledge, for update statements you don’t need neither to declare any cursor nor to fetch records from it. You simply need to execute the SQL command. Depending on your host environment, executing the command [...]
View Answer
| January 2, 2005 5:59 AM
RPG, SQL
Mainframe Testing Tools
I’m currently using Xpediter with IMS and DB2 – both batch and on-line and I have used SmartTest not that long ago, around 2002. I haven’t used CA-InterTest for awhile. I personally think that SmartTest has less of a learning curve than Xpediter. As for Pros and Cons. SmartTest was easy to use both for [...]
View Answer
| December 30, 2004 2:14 PM
390, COBOL, DB2, Functional, Mainframe, Performance/Load, Software testing, Software testing tools
I’m currently using Xpediter with IMS and DB2 – both batch and on-line and I have used SmartTest not that long ago, around 2002. I haven’t used CA-InterTest for awhile. I personally think that SmartTest has less of a learning curve than Xpediter. As for Pros and Cons. SmartTest was easy to use both for [...]
View Answer
| December 30, 2004 2:14 PM
390, COBOL, DB2, Functional, Mainframe, Performance/Load, Software testing, Software testing tools
Zipping a report in CL
Following this link http://homepage1.nifty.com/uzaemon/#download you’ll find a porting of compression library (zlib) for AS/400. This is a zip/unzip command line utility that you can use in your cl program. Hope may this help you. Ciao.
View Answer
| December 29, 2004 3:19 AM
Development
Following this link http://homepage1.nifty.com/uzaemon/#download you’ll find a porting of compression library (zlib) for AS/400. This is a zip/unzip command line utility that you can use in your cl program. Hope may this help you. Ciao.
View Answer
| December 29, 2004 3:19 AM
Development
Importing/copying external EBCDIC files to DB2 on iseries
I’m not an expert on iSeries, but as far as I know EBCDIC has a different conversion table than ASCII. Have you tried the type-of format?.
View Answer
| December 28, 2004 8:12 AM
AS/400, COBOL, DB2, Development
I’m not an expert on iSeries, but as far as I know EBCDIC has a different conversion table than ASCII. Have you tried the type-of format?.
View Answer
| December 28, 2004 8:12 AM
AS/400, COBOL, DB2, Development
PRINTING OVERLAYS FOR MUTIPLE PAGE LETTER
I’m not certain that I understand what you want to do. But if you’re trying to print the back overlay on the front of the next sheet of paper, I don’t believe that will work. What you can do is use page definitions and form definitions to change the overlay which prints on a given [...]
View Answer
| December 27, 2004 8:34 PM
COBOL, DataCenter, Programming Languages, RPG, Visual Basic
I’m not certain that I understand what you want to do. But if you’re trying to print the back overlay on the front of the next sheet of paper, I don’t believe that will work. What you can do is use page definitions and form definitions to change the overlay which prints on a given [...]
View Answer
| December 27, 2004 8:34 PM
COBOL, DataCenter, Programming Languages, RPG, Visual Basic
Windows media audio codec
Rather than try making your machine equal the working machine’s configuration, I might be inclined to delete the sound card hardware device then reboot the machine (with the OS install CD handy) and let PNP install it again. It *should* work after that. This method may give faster resolution to the problem than continuing to [...]
View Answer
| December 27, 2004 11:13 AM
DataCenter, Desktops, Development, ERP, Hardware, Intel PC hardware, Operating system platforms, Tech support, Windows 2000 desktop
Rather than try making your machine equal the working machine’s configuration, I might be inclined to delete the sound card hardware device then reboot the machine (with the OS install CD handy) and let PNP install it again. It *should* work after that. This method may give faster resolution to the problem than continuing to [...]
View Answer
| December 27, 2004 11:13 AM
DataCenter, Desktops, Development, ERP, Hardware, Intel PC hardware, Operating system platforms, Tech support, Windows 2000 desktop
