UE SUBSTR or RTRIM?
I need to get cities’ name from a format like this: Los Angeles, CA New Orleans, LA etc.. I’ve tried: substr(a.air_location, -4) but that gives me the opposite…”, LA” Any suggestions? Thanks.
Answer Question
| May 7, 2009 5:21 AM
InStr function, RTRIM, SUBSTR, Substring
I need to get cities’ name from a format like this: Los Angeles, CA New Orleans, LA etc.. I’ve tried: substr(a.air_location, -4) but that gives me the opposite…”, LA” Any suggestions? Thanks.
Dreamweaver AP Div linking
I am using dreamweaver cs4 and am updating my website from adobe go live. I cannot for the life of me figure out how to link an ap div tag to another page? The link(mapping) does not highlight. Can anyone please help?
Answer Question
| May 7, 2009 12:03 AM
Adobe GoLive, Dreamweaver CS4, Web development
I am using dreamweaver cs4 and am updating my website from adobe go live. I cannot for the life of me figure out how to link an ap div tag to another page? The link(mapping) does not highlight. Can anyone please help?
How to use XML in RPG
Hi All, I want to know if its possible to FTP a file from RPG to any other systems using XML. More precisely, can we use XML to pull the data from RPG and feed it to other systems. If yes, appreciate if you can give some inputs or notes where I can find the [...]
Answer Question
| May 8, 2009 10:20 PM
FTP, RPG, RPGLE, XML
Hi All, I want to know if its possible to FTP a file from RPG to any other systems using XML. More precisely, can we use XML to pull the data from RPG and feed it to other systems. If yes, appreciate if you can give some inputs or notes where I can find the [...]
why does my program not work and then when I run it in debug it works from that point forward
why does my program not work and then when I run it in debug it works from that point forward. Does this have to do with compressing programs when compiling
Answer Question
| May 7, 2009 5:10 PM
Data compression, Debugging
why does my program not work and then when I run it in debug it works from that point forward. Does this have to do with compressing programs when compiling
Switching Between IE8 and IE7 Browser
Hi I Need to test my site on both IE8 and IE7.Curretly i am planing to test my website by using IE8-developer tools-Swich between ‘Browser Mode :IE7 ,Document Mode: IE7 Standards’ to ‘Browser Mode :IE8 ,Document Mode: IE8 Standards’ .Is this reliable , if not I am going to use my old methods like using [...]
Answer Question
| May 6, 2009 5:04 PM
IE7, IE8, Internet Explorer, Internet Explorer 7, Internet Explorer 8, Software testing, Website Testing
Hi I Need to test my site on both IE8 and IE7.Curretly i am planing to test my website by using IE8-developer tools-Swich between ‘Browser Mode :IE7 ,Document Mode: IE7 Standards’ to ‘Browser Mode :IE8 ,Document Mode: IE8 Standards’ .Is this reliable , if not I am going to use my old methods like using [...]
language filter
what language ilter do in vs2005 help is it similar to the dfault language?
Answer Question
| May 7, 2009 3:35 PM
Visual Studio, Visual Studio 2005, VS 2005
what language ilter do in vs2005 help is it similar to the dfault language?
MS Access 2002 Excessive Growth
I have an Access 2002 application that is running VB/DAO to manipulate data and have very few forms. When the application starts its size is about 20,000 KB. After completion of a run 4 hours later, it can grow in size to over 200,000 KB. And as the run progresses, it gets slower and slower [...]
Answer Question
| April 21, 2012 3:23 PM
Access 2002, DAO, Microsoft Access, Microsoft Access Performance, Visual Basic
I have an Access 2002 application that is running VB/DAO to manipulate data and have very few forms. When the application starts its size is about 20,000 KB. After completion of a run 4 hours later, it can grow in size to over 200,000 KB. And as the run progresses, it gets slower and slower [...]
SQL or RPG
Would it be better to use SQL or RPG, to update one field in the file with a value from another field in the same file? I am not that familiar with SQL, only a beginner. My RPG skills are rusty as I’ve not written anything in the last 4 years.
Answer Question
| May 8, 2009 3:22 PM
RPG, SQL
Would it be better to use SQL or RPG, to update one field in the file with a value from another field in the same file? I am not that familiar with SQL, only a beginner. My RPG skills are rusty as I’ve not written anything in the last 4 years.
REXX LOOP for repeated Enter press
Is it possible to code a REXX EXEC to emulate the repeated pressing of the ENTER key with a TSO session? The repeat loop would be set by an externally determined variable value or some form of time elapse logic. THANKS!
Answer Question
| May 8, 2009 11:33 AM
REXX, REXX LOOP, TSO session
Is it possible to code a REXX EXEC to emulate the repeated pressing of the ENTER key with a TSO session? The repeat loop would be set by an externally determined variable value or some form of time elapse logic. THANKS!
What are the steps involved in copying the website from production to preproduction server
what are the steps involved in copying the website from production to preproduction server
Answer Question
| May 6, 2009 11:10 AM
IIS, Production Servers, SQL Server, SQL Server development, Web development
what are the steps involved in copying the website from production to preproduction server
Data Grid View Questions
How can i show the combobox in the datagridview collection. As when i opens a form which has datagridview collection ,it shows combobox as textbox but when i click on specific combobox then it shows that combo box
Answer Question
| June 24, 2011 9:22 AM
Collection, ComboBox, DataGridView
How can i show the combobox in the datagridview collection. As when i opens a form which has datagridview collection ,it shows combobox as textbox but when i click on specific combobox then it shows that combo box
How to open a new email in Lotus Notes using C#
I am writing a .Net c# windows application where I need to open a new email in the Lotus Notes mail client. Any ideas on how this could be done
Answer Question
| May 6, 2009 7:57 PM
.NET, C#, Lotus Notes, Windows Application, WinForms
I am writing a .Net c# windows application where I need to open a new email in the Lotus Notes mail client. Any ideas on how this could be done
I need to Auto Number, Tab, Tab and CR
I have a cell that includes the following information. name[tall] name[short] name[medium] name[tall] name[short] What I need this information to do is, add an ascending number before each name, tab, name, tab, size then carriage return. What I have so far is… Dim fullname As String fullname = input_name.Value Dim withtabs As String = Replace(fullname, [...]
Answer Question
| May 5, 2009 4:22 PM
Visual Basic, Visual Basic Programming
I have a cell that includes the following information. name[tall] name[short] name[medium] name[tall] name[short] What I need this information to do is, add an ascending number before each name, tab, name, tab, size then carriage return. What I have so far is… Dim fullname As String fullname = input_name.Value Dim withtabs As String = Replace(fullname, [...]
empty fields in a query
I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the answers to the specific question. [...]
Answer Question
| May 8, 2009 4:20 PM
CASE statement, NULL, SQL Query
I have a column with answers that people responded to different questions about themseleves. I have another column with the question id that the answer corresponds to. i want to display the answers in separate columns based on which question it corresponds to. Each column should be filled with the answers to the specific question. [...]
What is your highest priority enterprise application that requires a mobile client?
What is your highest priority enterprise application that requires a mobile client? This question is sponsored by RIM.
Answer Question
| May 12, 2009 12:18 PM
Application development, Mobile Application Development, Mobile applications
What is your highest priority enterprise application that requires a mobile client? This question is sponsored by RIM.
JavaScript IF ELSE
I have managed to get the prompt to work, but when i type a number into prompt it displays all outputs on webpage, like nodiscount5%discount etc, could someone please sort my program so it just shows one output, then i can study my errors and learn from it. thankyou. <HTML> <HEAD> <TITLE>Volume Discount</TITLE> <SCRIPT LANGUAGE [...]
Answer Question
| July 26, 2010 11:47 AM
IF ELSE statement, JavaScript, Web development
I have managed to get the prompt to work, but when i type a number into prompt it displays all outputs on webpage, like nodiscount5%discount etc, could someone please sort my program so it just shows one output, then i can study my errors and learn from it. thankyou. <HTML> <HEAD> <TITLE>Volume Discount</TITLE> <SCRIPT LANGUAGE [...]
Tables in DB2 z/OS
In which dataset will I be able to find the default tables of DB2 V9 in Z OS
Answer Question
| April 26, 2011 4:28 AM
DB2, DB2 Everyplace, Mainframe Datasets, Mobile development, z/OS
In which dataset will I be able to find the default tables of DB2 V9 in Z OS
Read/Write ability to MSSQL using FoxPro 2.6 for DOS
Hi All My company has a DOS Based Accounting system running under FPD 2.6 for DOS. We have purchased a project planning package that sits on a SQL server. I need to be able to transfer actuals from our DOS (dbase4) accounting data to MSSQL and also read from MSSQL for reporting purposes. Is this [...]
Answer Question
| May 4, 2009 8:14 PM
FoxPro 2.6, FoxPro 2.6 for DOS, SQL
Hi All My company has a DOS Based Accounting system running under FPD 2.6 for DOS. We have purchased a project planning package that sits on a SQL server. I need to be able to transfer actuals from our DOS (dbase4) accounting data to MSSQL and also read from MSSQL for reporting purposes. Is this [...]
Extract GPO settings using VBScript
I am trying to extract specific GPO settings using VBScript. Does anyone have a sample I can use? Thanks.
Answer Question
| May 7, 2009 7:56 PM
GPO, Group Policy Objects, VBScript
I am trying to extract specific GPO settings using VBScript. Does anyone have a sample I can use? Thanks.
Dummying a dataset with a concatenated list of datasets
I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the [...]
Answer Question
| August 4, 2010 6:16 PM
Concatenate, Database
I have an input of 6 contactenated files and I wish to process with just the 4th file in the list. Will dummying the first 3 and last two still pull in the 4th dataset or by dummying the first in the list in effect dummy all of the inputs in the list? Does the [...]





