String Concatenation (Memory Buffer)

20Jul06

While working with a certain web application, I just found my self trapped on a string concatination problem. What I’m tryin’ to do is concatenate 2 strings and assigning the output to the first string. My code goes something like this:

PSEUDO CODE
var myString=””;
for(i=1;myQuery.recordCount;i++){
     myString = myString & myQuery.record[i];
}
note:
Let say myQuery is a SQL query which returns
all [...]

Filed under: Programming   |  Leave a Comment
Tags: memory buffer, String Concatenation

SQL Union All

20Jul06

I was working in this certain module last week wherein I will create a web app page that will generate monthly reports. Everything was fine and I manage to do it with an ease until the boss checks my work, On the report generated, there was a certain field column wherein NULL values are present, [...]

Filed under: SQL   |  Leave a Comment
Tags: SQL, Union