At 22.47 08/11/2001, Jesse Noller wrote:
> 1: Loaded cfstudio 5 (I generally don't use cfstudio) and tried view
>the pgsql datasource before I changed the driver. Worked fine. Dunno what up
>with other configurations.
>
> 2: In cfstudio 5, Tried it again with the new driver, worked fine.
Could you try a simple test inserting and selecting long text?
CREATE TABLE test (
id_test integer,
a text
);
INSERT INTO test(id_test, a) VALUES (1,'test');
text_large.cfm
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>TEST</title>
</head>
<body>
<cfif cgi.request_method IS "POST">
<cfquery name="qry_upd" datasource="test" dbtype="ODBC">
UPDATE test
SET a = '#form.a#'
WHERE id_test = 1
</cfquery>
</cfif>
<cfquery name="qry_test" datasource="test" dbtype="ODBC">
SELECT a
FROM test
WHERE id_test = 1
</cfquery>
<form action="text_large.cfm" method="post">
<textarea cols="50" rows="50" name="a">
<cfoutput query="qry_test">
#a#
</cfoutput>
</textarea>
<input type="submit" name="vai" value="GO">
</form>
</body>
</html>
--------------------------------------------------
FABIO SERRA - faser(at)faser.net
PGP available
--------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
