I discovered the issue... apparently the SQL DISTINCT doesn't play friendly with the Access Memo field

Daniel Elmore wrote:

You might want to check the datasource settings in the CF admin. Under the
advanced tab at the bottom you should see a maximum character limit, make
sure it's not to low.

-Daniel


-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jake McKee Sent: Tuesday, March 01, 2005 7:15 AM To: [email protected] Subject: Access Memo field issues

All,

I recently was testing BlogFusion 4.0a1 and noticed that suddenly one of my queries was truncating one of my #variable# outputs. I'm using Access while I test, and things have been fine up until now. The field in question is in the database correctly, but when running my query, this memo field is truncating at or around 255 characters. In other parts of the application, I'm able to pull out this data (ALL the data) and display just fine.

Any idea what's up?

Jake

----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm




----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm










----------------------------------------------------------
To post, send email to [email protected]
To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm





Reply via email to