Sorry I was using that as an example, it was actually this
left(problemlog.description, 40) AS ResultField5, now what else could it be.
Robert Everland III
Web Developer
Dixon Ticonderoga
-Original Message-
From: Chapman, Katrina [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 20, 2000 2:01 PM
To: CF-Talk
Subject: RE: Weirdest Access problem ever
You should rename the field desc as that is a reserved word and your ODBC
connection may be choking on it. Try naming it something like description.
I know it's more typing but you'll have fewer headaches. BTW this should
also fix your problem.
--K
-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 20, 2000 10:05 AM
To: CF-Talk
Subject: Wierdest Access problem ever
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
What happened was the left function completely screwed the query. Has anyone
had this problem before? I thought access supported this function, was it a
fluke as to why it was working before? I took it out and put it in CF to do
it, but I am sure it would be just a little faster if Access was doing it.
Robert Everland III
Web Developer
Dixon Ticonderoga
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]