Hi Dave
Its not the length of the string, it seems to be all the special characters
in the string you are trying to store.
Here is a possible quick (but ugly solution)
<! - - - big ugly formfield - - ->
<CFSET list = "Originals = 1; 1-sided = 1; 2-sided =
0; Finished Size: 8.5 x 11; Stock: 20 lb. bond; Stock Colour: White;
Stock Finish: laser; INKS; 1st Front Colour:Black; Staple: corner; Fold:
letter; Copy In; Drilling: 3 Standard; Pad in: 100's; Spiral Binding:
red; Shrink Wrap: 100's; Use numbering in: red; Start numbering at:
1000; End numbering at: 2000; Perforate; Score; Slip
Sheet">
<cfquery name="adddata" datasource="dave" dbtype="ODBC">
Insert into thetable
(ITEMDESCRIPTION,
ITEMLANGUAGE,
ITEMNAME,
ITEMNOTES)
Values
('Main Test Form for testing purposes',
'English',
'Test Form',
'#ToBase64(List)#'
)
</cfquery>
<h2>success</h2>
then to view it....
<cfquery name="getdata" datasource="dave" dbtype="ODBC">
SELECT yourstuff
FROM thetable
</cfquery>
<cfoutput QUERY="getdata">
<cfset dataBinary = #toBinary(yourstuff)#>
<cfset strnotes = #toString(dataBinary)# >
#strnotes#
</cfoutput>
imperfect..but it allows you to keep that format for your notes.
or alter your db to break up those values...
HTH
Dave Seddon (p) 997-1803
Internet Software Support Specialist
Workplace Information Directorate, HRDC-DRHC
e-mail: [EMAIL PROTECTED]
Web: http://labour.hrdc-drhc.gc.ca
---------- Original Text ----------
From: "Dave Boehm" <[EMAIL PROTECTED]>, on 2002-05-14 8:44 AM:
Has anyone ever been able to use a memo field. I can't save anything
that has more than 255 characters to an Access 2000 database from
ColdFusion 4.5. I posted a similar question yesterday with no usable
response. My long text buffer size is set to the default 64k.
David Boehm
M&T Printing Group
907 Frederick St.
Kitchener, ON
N2B 2B9
(519) 571-0101
[EMAIL PROTECTED]
-
You are subscribed to the CFUGToronto CFTALK ListSRV.
This message has been posted by: [EMAIL PROTECTED]
To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/
Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/
This System has been donated by Infopreneur, Inc.
(http://www.infopreneur.net)
