In the real query I do this, it is access 97 with the latest CF and lastest
MDAC.
Robert Everland III
Web Developer
Dixon Ticonderoga
-----Original Message-----
From: pan [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 20, 2000 3:17 PM
To: CF-Talk
Subject: Re: Wierdest Access problem ever
From: "Robert Everland" <[EMAIL PROTECTED]>
> Alright here is what happened. I had a query that was working
> perfectly for sometime. It basically did this
> Select left(desc,40)
> From Here
> Where 1=1
In Acc2k this works ...
SELECT left(this_text,8) as leftText
FROM URL
WHERE 0=0;
works in a cf query too
try aliasing your function
Pan
(your column is text, eh?)
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
