Dear me, is not reserve word. Looks like I've to install MX
again to resolve this issue.
-Original Message-
From: Sam Farmer [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 20:26
To: CF-Talk
Subject: Re: Shall I start Pulling my Hair
I've used aliases long
ent: Tuesday, December 03, 2002 10:23 AM
Subject: Shall I start Pulling my Hair
> Whats wrong with this simple code
>
>
> Select J_Sname.AccountNumber AS DetailField1
> From J_Sname
> Where ID = '12'
>
>
>
> #myQuery.DetailField1#
>
>
It works for SQLServer DSN but not for ODBC SOCKET.
-Original Message-
From: Simon Stanlake [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 16:22
To: CF-Talk
Subject: RE: Shall I start Pulling my Hair
on oracle test works
select name as thisisthefieldname1
.
I would check the JDBC implementation to see if alias of more than 12
characters is supported.
good luck,
simon
-Original Message-
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 03, 2002 8:00 AM
To: CF-Talk
Subject: RE: Shall I start Pulling my Hair
ID is varchar.
ID is varchar..
It goes to IF and gives error on DETAILFIELD1. Just make simple query
with alias of more than 10 chars and test.
-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 15:49
To: CF-Talk
Subject: Re: Shall I start Pulling my Hair
First check to see if the field ID is a numeric or TEXT field.
if it is Numeric then the WHERE line should be:
WHERE ID = 12 not '12'
Single Quotes are not used in numeric fields.
Then I would also change the output line to read:
#myQuery.Detailfield1#
NO RECORDS
>>> [EMAIL PROTECTED] 1
CFDUMP gives me DETAILFIEL (it trims last two chars).
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]]
Sent: 03 December 2002 15:34
To: CF-Talk
Subject: RE: Shall I start Pulling my Hair
What do you get when you cfdump the query? Or output
#myQuery.columnList
ally is the Force, and a powerful ally it is." - Yoda
> -Original Message-
> From: Shahzad.Butt [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 03, 2002 9:23 AM
> To: CF-Talk
> Subject: Shall I start Pulling my Hair
>
>
> Whats wrong with t
Whats wrong with this simple code
Select J_Sname.AccountNumber AS DetailField1
From J_Sname
Where ID = '12'
#myQuery.DetailField1#
It gives error
'Element DETAILFIELD1 is undefined in myQuery. '
But if I use DETAILFIE1 (or anyother letter not more than 10 characters)
instea
9 matches
Mail list logo
