SQL Text Columns

[John Keane]

Using SQL Server 7.0 and ColdFusion 4.0.1, how can I get the complete field
value of a text column.  A SELECT will give me the first 1,000 characters and
anything beyond that is truncated.

CFQUERY DATASOURCE="DS1" NAME="rsTEXT"
SELECT PRODUCT_DESCRIPTION FROM tblProduct WHERE product_id = 001
/CFQUERY

Thanks

John Keane
EMail: [EMAIL PROTECTED]
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

CFFILE error

[John Keane]

I have been around the block with this error and at the moment am very
frustrated.

First the line of code:

CFFILE ACTION="upload" FILEFIELD="filMessage" DESTINATION="#SavePath#"
NAMECONFLICT="overwrite"

The error:

The form field specified in the CFFILE tag (FILMESSAGE) does not contain an
uploaded file.  Please be sure you have specified the correct form field name.

filMessage contains C:\BIN\HPFILES\EMAEM.MSG

Any help would be greatly appreciated.

Thanks

John Keane
[EMAIL PROTECTED]

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.