Ask a Question related to Coldfusion Database Access, Design and Development.
-
myersonconsulting #1
Data truncation in SELECT
Hi all. I'm executing a simple SELECT statement to return the value that's been
stored as a LONGTEXT in a mySQL db. The code to insert the data works fine (its
length in the database is ~355K as it should be), but when I retrieve it from
the db it is shortened to its first ~45K bytes. Any thoughts? Many thanks.
myersonconsulting Guest
-
XML select data by value
I am looking to select XML in flash from an external XML file by a tag's value. var xnRoot:XMLNode = this.firstChild.firstChild.firstChild; How... -
Trouble with truncation error when loading data from a file
The table has many columns, but it includes a column like: CREATE TABLE f ( ... `x` DECIMAL(10,2) DEFAULT NULL, ... ) ENGINE=InnoDB; I use... -
Data Truncation error
Hello, I have CF MX 7, developer version Database is MySQL v. 4.1.12 Every 15 days I receive new ASCII files which contains data which have to... -
getting data from select name-option value
I can?t seem to solve this problem. On my First page (index) I create a query that populates an option value (or list) box. When the user selects a... -
Data Base Select
I have an ActiveX control and some data base results on the same web page. I want to respond to an event and change the results from the data base... -
JMGibson3 #2 Re: Data truncation in SELECT
Cold Fusion Administrator Data Source page for your database, enable the
'Enable retrieval of long text ' box if you truly want everything or bump up
the 'Long Text Buffer Size' if you just want a higher Trunc value.
JMGibson3 Guest
-
myersonconsulting #3 Re: Data truncation in SELECT
Originally posted by: JMGibson3 Cold Fusion Administrator Data Source page for
your database, enable the 'Enable retrieval of long text ' box if you truly
want everything or bump up the 'Long Text Buffer Size' if you just want a
higher Trunc value. That is it. In my case, I had to contact support for my
web host, but that did the trick. Thanks!
myersonconsulting Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
