Gregory,
Something jogs in my memory regarding a max char length that the JDBC/ODBC
driver can handle for the varchar/memo datatype. Check on the Allaire web
site documentation and see if you can find it. I remember reading somewhere
that there were some limitations on the max size some of SQLServer's
datatypes, as some of SQLServer's datatypes are not true ANSI SQL datatypes
(typical MS). But I cannot remember where I read this, or if it was a
ODBC/JDBC driver limitation or a JDBC limitation.
Sorry I could not be of more help, but maybe someone else on this board can
put their finger on this issue.
Celeste
-----Original Message-----
From: Gregory Price [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 6:19 PM
To: JRun-Talk
Subject: SQL Server Memo Insert problem
Hey,
I'm a ColdFusion / Jrun convert and could use a little help... Having
trouble getting a large record to update (datatype varchar, 8000 character
limit) using jrun. A small entry into the subsiquent textarea works no
problem, but when I insert text over about 3500 characters I get a
"JspTagException: [Microsoft][ODBC SQL Server Driver]String data, right
truncation"
The string data, right truncation had me double checking the datatype and
trying the insert of like characteristics in ColdFusion and it worked like a
champ. So that tells me it is in the jsp or Jrun Driver or something... not
in the database itself. The code I am using for the insert is :
<%@ taglib uri="jruntags" prefix="jrun" %>
<% String news_ID= request.getParameter("news_ID"); %>
<% String newsletter_ID= request.getParameter("newsletter_ID"); %>
<% String heading= request.getParameter("heading"); %>
<% String entry= request.getParameter("entry"); %>
<% String enteredby=request.getParameter("enteredby"); %>
<% String newslettermonth= request.getParameter("newslettermonth"); %>
<% String newsletteryear= request.getParameter("newsletteryear"); %>
<jrun:sql datasrc="afdallas" id="allnews">
INSERT INTO news (newsletter_ID, heading, entry, enteredby)
VALUES (
<jrun:sqlparam value="<%= newsletter_ID %>" />,
<jrun:sqlparam value="<%= heading %>" />,
<jrun:sqlparam value="<%= entry %>" />,
<jrun:sqlparam value="<%= enteredby %>" />
)
</jrun:sql>
This, of course, comes from a form submitted by virtue of method="post".
The problem occurs upon submission of the "entry" field... I am using these
settings to connect:
sun.jdbc.odbc.JdbcOdbcDriver
jdbc:odbc:afdallas
I am new at this, and look forward to participating in this list... thanks
in advance for any help you can throw my way...
Thanks
Greg Price
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
