Field Length Help

[canswim]

I added a new field to my database:

<CFQUERY NAME="addColumn" DATASOURCE="#APPLICATION.dsn#"
USERNAME="#APPLICATION.dbuser#" PASSWORD="#APPLICATION.dbpass#">
ALTER TABLE users
ADD user_info varchar(1000);
</CFQUERY>

Then I tried to add data to the field in the databse:

<CFQUERY NAME="updateUser" DATASOURCE="#APPLICATION.dsn#"
USERNAME="#APPLICATION.dbuser#" PASSWORD="#APPLICATION.dbpass#">
UPDATE users
SET
user_info = "Robert has over 10 years experience in the trade show and
marketing industries. His expertise and experience in these areas, produces an
advantageous relationship for our clients. Due to his knowledge of the area
Robert understands the delicate intricacies that need to be managed and
fulfilled to execute an effective and efficient campaign. Robert's passion for
perfection in all projects ensures our clients, the best elements of each
aspect of a new marketing project. His experience and knowledge is passed on to
the client by his ability to recognize the advantages and disadvantages of
marketing techniques/resources, from products to sales personnel
personalities."
WHERE user_ID = 11
</CFQUERY>

But when I do I get this error message:
-------------------------------------------------------------

Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]The identifier that starts with
&apos;Robert has over 10 years experience in the trade show and marketing
industries. His expertise and experience in these areas, pro&apos; is too long.
Maximum length is 128.

The error occurred in
\\10.0.0.112\boxinc.ca\public\admin2112\scripts\up dateUsers.cfm: line 30

28 : </CFIF>
29 :
30 : <CFQUERY NAME="updateUser" DATASOURCE="#APPLICATION.dsn#"
USERNAME="#APPLICATION.dbuser#" PASSWORD="#APPLICATION.dbpass#">
31 : UPDATE users
32 : SET




--------------------------------------------------------------------------------

SQL UPDATE users SET user_info = "Robert has over 10 years experience in
the trade show and marketing industries. His expertise and experience in these
areas, produces an advantageous relationship for our clients. Due to his
knowledge of the area Robert understands the delicate intricacies that need to
be managed and fulfilled to execute an effective and efficient campaign.
Robert's passion for perfection in all projects ensures our clients, the best
elements of each aspect of a new marketing project. His experience and
knowledge is passed on to the client by his ability to recognize the advantages
and disadvantages of marketing techniques/resources, from products to sales
personnel personalities." WHERE user_ID = 11




Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]The identifier that starts with
&apos;Robert has over 10 years experience in the trade show and marketing
industries. His expertise and experience in these areas, pro&apos; is too long.
Maximum length is 128.

The error occurred in
\\10.0.0.112\boxinc.ca\public\admin2112\scripts\up dateUsers.cfm: line 30

28 : </CFIF>
29 :
30 : <CFQUERY NAME="updateUser" DATASOURCE="#APPLICATION.dsn#"
USERNAME="#APPLICATION.dbuser#" PASSWORD="#APPLICATION.dbpass#">
31 : UPDATE users
32 : SET




--------------------------------------------------------------------------------

SQL UPDATE users SET user_info = "Robert has over 10 years experience in
the trade show and marketing industries. His expertise and experience in these
areas, produces an advantageous relationship for our clients. Due to his
knowledge of the area Robert understands the delicate intricacies that need to
be managed and fulfilled to execute an effective and efficient campaign.
Robert's passion for perfection in all projects ensures our clients, the best
elements of each aspect of a new marketing project. His experience and
knowledge is passed on to the client by his ability to recognize the advantages
and disadvantages of marketing techniques/resources, from products to sales
personnel personalities." WHERE user_ID = 11
DATASOURCE boxinc_boxinc_ca
VENDORERRORCODE 103
SQLSTATE HY000
-------------------------------------------------------------

Please help! Why does it tell me the max length is 128 when i specified
varchar(1000)?

[paross1]

First of all, you are surrounding your text with double quotes. Also, I noticed that you have a single quote in the middle of your text (Robert's passion ).

Phil

[canswim]

yes that was it, thanks Robert i figured it out once i went back and looked at it again..I hate wasting time on such silly mistakes.

Mike