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]
