anup001
asked on
Error : String or binary data would be truncated.
I am trying to submit some form values to the database
However i am getting an error when i insert something like (E. Jensen) or N/o . or such special characters in text fields like street. The error is
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.
The error occurred in E:\docs_secure\icepe\addhv p.cfm: line 9
7 : values('#EVALUATE('form.si tename')#' ,'#EVALUAT E('form.st reet')#',' #EVALUATE( 'form.city ')#','#EVA LUATE('for m.region') #'
8 : ,'#EVALUATE('form.county') #','#EVALU ATE('form. zip')#','# EVALUATE(' form.state ')#','#EVA LUATE('for m.colocato r')#',
9 : '#EVALUATE('form.siteowner ')#','#EVA LUATE('for m.hvpowner ')#','#EVA LUATE('for m.hvptype' )#','#EVAL UATE('form .phone')#' ,'#EVALUAT E('form.no te')#')
10 : </cfquery>
11 : <cfquery name="getsid1" datasource="#dbdsn#" username="#dbuser#" password="#dbpw#">
-------------------------- ---------- ---------- ---------- ---------- ---------- ----
SQL insert into site_info (sitename,street,city,regi on,county, zip,state, colocator_ name,sowne r_name,own er_hvp,typ e_of_hvp,p hone_no,no te) values('McCall','Leonard Avenue, (E. Jensen )','Fresno','' ,'','','CA','Larry Duba', 'PGE','Unknown','None','26 8-0441','' )
DATASOURCE sqldatas
VENDORERRORCODE 8152
SQLSTATE 22001
What do i need to do here?
However i am getting an error when i insert something like (E. Jensen) or N/o . or such special characters in text fields like street. The error is
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.
The error occurred in E:\docs_secure\icepe\addhv
7 : values('#EVALUATE('form.si
8 : ,'#EVALUATE('form.county')
9 : '#EVALUATE('form.siteowner
10 : </cfquery>
11 : <cfquery name="getsid1" datasource="#dbdsn#" username="#dbuser#" password="#dbpw#">
--------------------------
SQL insert into site_info (sitename,street,city,regi
DATASOURCE sqldatas
VENDORERRORCODE 8152
SQLSTATE 22001
What do i need to do here?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hope that Helps!