Will pay for support

[HugoSchmidt]

I am an above average SQL Programmer with a high (nearly expert) skill in Cold
Fusion. There is no peer around me that I can ask a question and get an
answer. I posted a question the other day, and still have not heard back. Are
there any Cold Fusion and/or SQL (preferably SQL, because that is my biggest
hurdle) Experts that I can pay to give me top level support. It can be on a
per instance or monthly basis.

Please advise.

[Sojovi]

Let's start for free. What was your question ? If it's very dificult I'll charge you a fee.. 8-)

Regards

[HugoSchmidt]

I like your style. I think you can feel my frustration.

Ok, so here goes, a user is uploading a text file (via a form post), the file
then needs to be put into an NTEXT field. It used to work great, but now that
the files are getting bigger (54kb) it is truncating the info. I have heard
that there is a limit to the amount of text in a genergic INSERT statement. So
my question is this, is there a way to "open" up that restriction to allow more
characters using the INSERT statement? I have tried using the BULK INSERT and
the BCP commands, and they all truncate what I am inserting.

Once inserted, how can I make sure that what went in, is all of it. From what
I undestand, if I do a SELECT myText FROM Table1 then it may not return the
WHOLE content.

[philh]

(NB comments are MSSQL-specific)

Apparently even WRITETEXT has a 120KB limitation. If you're brave you can
write some DB-Library stuff using dbwritetext, which is limited to 2GB input.

Check BOL for more info.

Good luck.

[HugoSchmidt]

What is BOL?

[Sojovi]

I don0t know what dB you are using, but supposing MS SQL server.
You don't have limitations in the qty of bytes you can insert in a
insert/update statement in a NTEXT/TEXT/IMAGE column (the limitations is the
size 2 GB).
The posibilities to insert a big chunk of text can be INSERT, BULK INSERT,
DTS, each one has it's advantages and disadvantages.

The problem cames when you want to retrieve the content of a NTEXT. If the
size is small, no problem. If the size is bigger, it depends in the API (odbc,
oledb). I.E., in CF, when you create a datasource and you'll use BLOB fields,
you have to check an option that says smoething like "enable retrieve large
fields..." don't remember exactly and you'll fix the problem about it.
In ASP the solution is putting the BLOBL field in the last position of the
select columns, and so on..

I think you believe that SQL is truncating when you insert because you can't
retrieve the content, but check the option in the datasource in the CF admin.

Well, nothing more I can remember by now.

Regards

[PaulH *ACE*]

HugoSchmidt wrote:

> What is BOL?

Books-on-Line, you're very best resource for sql server. it comes free w/the db.
install it, use it & you won't need any sql server peers.

did you turn on the CLOB/BLOB settings for that dsn (under the "advanced" menu)?
i've stuffed monster-thumping big files into sql server via cf & returned them ok.

[HugoSchmidt]

Sojovi, YOU ROCK!!!!

That was it. Silly me for thinking that something like that would default to
"no" I am sure it is to speed up some performance. Anyway, I turned both on,
ran my select statement and TA-DA it was done.

philh,
When I have some spare time in my already overloaded life, I'll read throught
BOL. For now, I am going to take blatent advantage of all of your knowledge!
:-D

Thanks!