n, 5 Mar 2007 15:29:24 +1100
Subject: [cfaussie] Re: query question
>
> For starters column names should NEVER have spaces in them. An
> underscore perhaps "_" but not spaces. You need to have that
> rectified. Dang newbie database designers.
>
> What db are you
: Monday, 5 March 2007 3:34 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: query question
Even though you shouldn't use spaces in your column names you can
reference them by placing square brackets around the column name.
SELECT [the column]
FROM Table
-Original Message-
ay, 5 March 2007 3:29 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: query question
For starters column names should NEVER have spaces in them. An
underscore perhaps "_" but not spaces. You need to have that
rectified. Dang newbie database designers.
What db are you using (think
3:29 PM
To: cfaussie@googlegroups.com
Subject: [cfaussie] Re: query question
For starters column names should NEVER have spaces in them. An
underscore perhaps "_" but not spaces. You need to have that
rectified. Dang newbie database designers.
What db are you using (thinking MSAccess or somet
queryName['column name'][row number]
Will let you access anything you want.
> -Original Message-
> From: cfaussie@googlegroups.com
> [mailto:[EMAIL PROTECTED] On Behalf Of skateboard.com.au
> Sent: Monday, 5 March 2007 3:27 PM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] quer
For starters column names should NEVER have spaces in them. An
underscore perhaps "_" but not spaces. You need to have that
rectified. Dang newbie database designers.
What db are you using (thinking MSAccess or something equally pitiful).
Use CFDUMP var="QueryName" for detailed info on your quer