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]
