you tried ToString() on it?
Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world ---------------------------------------------------------------------- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! ---------------------------------------------------------------------- ---------------------------------------------------------------------- Mark Smyth <[EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> ology.com> cc: Subject: RE: [ cf-dev ] SQL Server Binary 24/06/2003 14:52 Please respond to dev sure, its a simple insert. Working fine without the binary field -on the form set the var <cfset session.test=myQuery.Company_ID[1]> <cfoutput>#isbinary(session.test)#</cfoutput> -returns true -insert into the db on action page <cfquery name="insert" datasource="webstore_SS"> insert into company (company_id, company_name, account_code, address_1, address_2, address_3, zip, country, phone, fax) values ('#session.test#','#form.company_name#','#form.account_code#',' #form.address _1#','#form.address_2#','#form.address_3#','#form.zip#','#form.country#',' #f orm.phone#','#form.fax#') </cfquery> -returns tthe following error message: ByteArray objects cannot be converted to strings. The error occurred in C:\CFusionMX\wwwroot\admin\advanced\company_detail.cfm: line 115 113 : (company_id, company_name, account_code, address_1, address_2, address_3, zip, country, phone, fax) 114 : values 115 : ('#session.test#','#form.company_name#','#form.account_code#',' #form.address _1#','#form.address_2#','#form.address_3#','#form.zip#','#form.country#',' #f orm.phone#','#form.fax#') 116 : </cfquery> 117 : done<cfabort> -The field company_id is binary, 8, - same as the table its being retrieved from -The following cfquery works without error (without the binary field) <cfquery name="insert" datasource="webstore_SS"> insert into company (company_name, account_code, address_1, address_2, address_3, zip, country, phone, fax) values ('#form.company_name#','#form.account_code#','#form.address_1#',' #form.addre ss_2#','#form.address_3#','#form.zip#','#form.country#','#form.phone#',' #for m.fax#') </cfquery> -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
