So which databases allow column name with spaces (and column names that start with 0)? Do you just use an alias? sensiblename AS stupidfieldname?
> From: [EMAIL PROTECTED] > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: spaces in column names > Date: Fri, 12 Oct 2007 06:21:13 +0000 > > > > > On Oct 12, 3:55 pm, "Scott Thornton" > <[EMAIL PROTECTED]> wrote: > > you can use: > > > > queryname['stupidfieldname?'][queryname.CurrentRow] > > Thanks Scott, that's exactly what I needed, it works > > > > > > >>> Stephen M <[EMAIL PROTECTED]> 12/10/2007 3:30 pm >>> > > > > I'm trying to process a result set from a stored proc that contains > > spaces in the column names. > > > > Now, I've asked the db programmer to replace the spaces with > > underscores, just to make it easier for me, but exactly how do you > > reference the values of a column with spaces in the name? Bearing in > > mind that I won't always know the name of the column in advance. > > > > In one example the column name comes out as 03 OCT 2007 TO 10 OCT > > 2007. That will change week to week. > > > > regards, > > Stephen > > > > _________________________________________________________________ It's simple! Sell your car for just $30 at CarPoint.com.au http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---