Error while adding html files (read the html sourcecode) & adding into the database!!

The error seems to be error due to space or character set

==========================================

re: Error while adding html files (read the html sourcecode) & adding into the database!!

You should be using cfqueryparam for all inputs into the database.

re: Error while adding html files (read the html sourcecode) & adding into the database!!

I have tried using the following code == still error



======================= cf_sql_longvarchar


The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request
Error Executing Database Query.
Incorrect string value: '\xC2\x82\xC3\x82\xC2\xA0...' for column 't6a' at row 1

The error occurred in C:\ColdFusion8\wwwroot\job8\1_\3mmm_add2_readhtml_ action3===.cfm: line 79

77 : (type1, t6a, add, jb1)
78 : values
79 : ('#url.aatype1#', <cfqueryparam value="#aacc2#" cfsqltype="cf_sql_longvarchar">, 'si', '#url.page#')
80 : </cfquery>
81 :


============================= not sure if cf_sql_text can be used



The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.

Error Occurred While Processing Request
Error Executing Database Query.
Incorrect string value: '\xC2\x82\xC3\x82\xC2\xA0...' for column 't6a' at row 1

The error occurred in C:\ColdFusion8\wwwroot\job8\1_\3mmm_add2_readhtml_ action3===.cfm: line 79

77 : (type1, t6a, add, jb1)
78 : values
79 : ('#url.aatype1#', <cfqueryparam value="#aacc2#" cfsqltype="cf_sql_text">, 'si', '#url.page#')
80 : </cfquery>

re: Error while adding html files (read the html sourcecode) & adding into the database!!

This seems like a database error. Try the same query in your database directly and see if you still get the error.

re: Error while adding html files (read the html sourcecode) & adding into the database!!

good morning
for your info,

the error appears for only some of the database I am adding - only about 5% error, the rest of 95% is ok ( meaning that the database is still receiving the data added, so I am not sure if it is the database error)

Can It be due to the character in the html source code (the file that I am adding) like ﾷ
or some foreign character

:)

re: Error while adding html files (read the html sourcecode) & adding into the database!!

Yes, most likely that's the source of the problem. If you're having problems, in some cases, of inputting directly into the database, then you'll have problems via Coldfusion. Try a simple HTML page with no foreign characters.

If there's no problem with simple pages, then you need to ask in the relevant forum for your database.

re: Error while adding html files (read the html sourcecode) & adding into the database!!

I have look thru the html source code, and it seems to be some foreign type set

and it should be chinese type set. the following at the codes:-


Hui Mian 黎辉勉

It seems to be in unicode (note: it looks different when i posted it here

re: Error while adding html files (read the html sourcecode) & adding into the database!!

Which database are you using?

re: Error while adding html files (read the html sourcecode) & adding into the database!!

MYSQL 5.0
table is set with MYISAM

character set == latin1

latin1_swedish_ci

re: Error while adding html files (read the html sourcecode) & adding into the database!!

Ask in the MySQL forum. I'll leave this thread here in case the problem persists in your Coldfusion application.

re: Error while adding html files (read the html sourcecode) & adding into the database!!

This is a problem that we face regularly with graphical characters that are part of word documents. While the all the special characters from the keyboard can be handled, there are five word processor special characters that are difficult to parse and replace inside html forms. These are two pairs of single and double inverted commas and hyphen. What we have seen is that when a user copies text from a word processor containing these texts, these are not recognised as characters. As a result error is thrown. When we analysed it further, we found that a single inverted comma is actually a normal comma placed in its superscript position. This is really funny. We should recommend to all browsers to deal with these special characters. These special characters copied from word processors must be converted in to corresponding keyboard characters. In fact on Windows the command line window automatically converts all word processor special characters in to keyboard characters. The browsers must embed this facility to overcome this problem