Re: Column names with spaces

2003-07-25 Thread Jim McAtee
uot; <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 10:17 PM Subject: Re: Column names with spaces > You can alias the table name in the select statement, or you might be able > to do: > > queryName["CREATE TABLE"][1] > - Original Message - > From: &qu

RE: Column names with spaces

2003-07-25 Thread Jim Davis
Access the query using array notation as in: QueryName["Column Name"][RowNumber] Jim Davis > -Original Message- > From: Jim McAtee [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2003 11:34 PM > To: CF-Talk > Subject: Column names with spaces > > How do you display a query column tha

Re: Column names with spaces

2003-07-25 Thread Kwang Suh
You can alias the table name in the select statement, or you might be able to do: queryName["CREATE TABLE"][1] - Original Message - From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 9:34 PM Subject: Column names with spaces > How do you

Re: Column names with spaces

2003-07-25 Thread Jim McAtee
; Sent: Friday, July 25, 2003 9:45 PM Subject: RE: Column names with spaces > not sure you can? although, maybe its possible...in sql server i dont > think > you can, but maybe in mysql you can, good luck!! > > tony > > -Original Message- > From: Jim McAtee [mailto:[EMA

RE: Column names with spaces

2003-07-25 Thread Tony Weeg
not sure you can? although, maybe its possible...in sql server i dont think you can, but maybe in mysql you can, good luck!! tony -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 11:34 PM To: CF-Talk Subject: Column names with spaces How do you