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]
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/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]
RE: Wierdest Access problem ever
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/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]
Re: Wierdest Access problem ever
[aliasing left function call in select] > In the real query I do this, it is access 97 with the latest CF and lastest > MDAC. > I just happen to have a box with Acc97 still on it and the code works the same as with Acc2k. Maybe something else in the "real query" ? Post more code and I (or someone else) will look at it. Are you thinking mdac? pan 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]
RE: Wierdest Access problem ever
I am thinking MDAC. This is the original code that froze up CF. Could be MDAC or CF SELECT DISTINCT problemlog.TICKET AS ResultField1, problemlog.DATE AS ResultField2, problemlog.TIME AS ResultField3, problemlog.REQNAME AS ResultField4, left(problemlog.description,40) AS ResultField5, problemlog.TICKET AS ID_Field FROM problemlog Where 1=1 And problemlog.ticket = #Form.Crit1_Value# And problemlog.reqname like '%#Form.Crit2_Value#%' Robert Everland III Web Developer Dixon Ticonderoga -Original Message- From: pan [mailto:[EMAIL PROTECTED]] Sent: Friday, October 20, 2000 4:53 PM To: CF-Talk Subject: Re: Wierdest Access problem ever [aliasing left function call in select] > In the real query I do this, it is access 97 with the latest CF and lastest > MDAC. > I just happen to have a box with Acc97 still on it and the code works the same as with Acc2k. Maybe something else in the "real query" ? Post more code and I (or someone else) will look at it. Are you thinking mdac? pan 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]
Re: Wierdest Access problem ever
From: "Robert Everland" <[EMAIL PROTECTED]> > I am thinking MDAC. This is the original code that froze up CF. Could be > MDAC or CF > I can't see anything immediate in the code ... (might try adding a ; after the final ) Might save some time if you deconstruct the query section by section until you get to a part that works and then build it back up until an error appears. Just comment out clauses and keep moving the . I know that's a brute force method, but it is sure. If it is a dataype matching problem, this method will show it fairly quickly. You loaded MDAC 2.6? What is the exact error message? pan SELECT DISTINCT problemlog.TICKET AS ResultField1, problemlog.DATE AS ResultField2, problemlog.TIME AS ResultField3, problemlog.REQNAME AS ResultField4, left(problemlog.description,40) AS ResultField5, problemlog.TICKET AS ID_Field FROM problemlog WHERE 1=1 AND problemlog.ticket = #Form.Crit1_Value# AND problemlog.reqname like '%#Form.Crit2_Value#%' / 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]
RE: Wierdest Access problem ever
There is no error it just hangs completely. If I do the exact same query in RDS it brings back no records. I did find out what the problem is it's the left() function. Description is a memo field if that even makes any difference. Dave Watts, any suggestions? Bob Everland -Original Message- From: pan [mailto:[EMAIL PROTECTED]] Sent: Friday, October 20, 2000 5:26 PM To: CF-Talk Subject: Re: Wierdest Access problem ever From: "Robert Everland" <[EMAIL PROTECTED]> > I am thinking MDAC. This is the original code that froze up CF. Could be > MDAC or CF > I can't see anything immediate in the code ... (might try adding a ; after the final ) Might save some time if you deconstruct the query section by section until you get to a part that works and then build it back up until an error appears. Just comment out clauses and keep moving the . I know that's a brute force method, but it is sure. If it is a dataype matching problem, this method will show it fairly quickly. You loaded MDAC 2.6? What is the exact error message? pan SELECT DISTINCT problemlog.TICKET AS ResultField1, problemlog.DATE AS ResultField2, problemlog.TIME AS ResultField3, problemlog.REQNAME AS ResultField4, left(problemlog.description,40) AS ResultField5, problemlog.TICKET AS ID_Field FROM problemlog WHERE 1=1 AND problemlog.ticket = #Form.Crit1_Value# AND problemlog.reqname like '%#Form.Crit2_Value#%' / 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]