RE: Join problem

ow join on @clean_array... Aloha => Beau. -Original Message- From: Vincent Lee [mailto:vjlee_us@;yahoo.com] Sent: Thursday, October 17, 2002 1:48 AM To: [EMAIL PROTECTED] Subject: Join problem Hello All, I've got a problem with the JOIN function I've got a list of columns that

Join problem

Hello All, I've got a problem with the JOIN function I've got a list of columns that gets returned from the database. I push the column values into an array and then join them with a comma. The problem is that JOIN puts a comma in the first value. How do I get rid of the comma in the first val

Re: creating a string on the fly

; } --- Rob <[EMAIL PROTECTED]> wrote: > Sorry Vincent I'm not sure what you're meaning. > > You've written GetColumns ($table). Does it return > an array of column names > as it should? > - Original Message - > From: "Vincent Lee&q

Re: creating a string on the fly

--- Rob <[EMAIL PROTECTED]> wrote: > Sorry Vincent I'm not sure what you're meaning. > > You've written GetColumns ($table). Does it return > an array of column names > as it should? > - Original Message - > From: "Vincent Lee" <

RE: creating a string on the fly

t;, " if $n++; print $column; } print ") FROM $table;\n"; } Which may be enough for you. GetTables() and GetColumns() are the first part, and I can't say any more about what these might do without knowing more about what interface you have with the database

Re: creating a string on the fly

M $table;\n"; >} > >Which may be enough for you. > > >GetTables() and GetColumns() are the first part, and I can't say any more >about what these might do without knowing more about what interface you have >with the database. > >HTH > >Rob > >---

Re: creating a string on the fly

>Bring the answer back to the mail group so that others can learn. > >Cheers, > >Rob > >- Original Message - >From: "Vincent Lee" <[EMAIL PROTECTED]> >To: "Rob" <[EMAIL PROTECTED]> >Sent: Tuesday, October 15, 2002 3:03 PM >Subject:

creating a string on the fly

Can someone help me with some basic logic? I have an array with unique tablenames from a DB catalog view TABNAME --- Org Employee Dept Each of these tablenames has columns in a hash array For example, ORG would have 3 columns and the array would be as follows: ORG ID ORG COL1 ORG COL2

Help with Hash Arrays

Can someone help me with this? I have a query in a database that queries the columns from the SYSCAT.COLUMNS table of either Oracle or DB2. I want to be able to print the columns in a string as follows: Col1, col2, col3...etc. depending on the table. How would I do this? = Regards, Vinc

Creating string on the fly

Can someone help me with some basic logic? I have an array with unique tablenames from a DB catalog view TABNAME --- Org Employee Dept Each of these tablenames has columns in a hash array For example, ORG would have 3 columns and the array would be as follows: ORG ID ORG COL1 ORG COL2