Quite a lot will allow spaces in field names. Alias's won't always help. You will need to use square brackets ['my field name'] as my_better_field_name
MS Access particularly causes me problems. When ever I am tasked to import data from a MS Access database, I just know that whomever made it used spaces and other dumb characters (question marks) in the filenames, especially if the database has come from the HIC (federal gov) or the AMA. So, I keep the statement queryname['stupidfieldname?'][queryname.CurrentRow] handy when using CF to get at the data. Cheers, >>> Mark Ireland <[EMAIL PROTECTED]> 16/10/2007 9:20 am >>> 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 -~----------~----~----~----~------~----~------~--~---