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

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • freddie007
    New Member
    • Sep 2008
    • 20
    #1

    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

    =============== =============== ============
    Code:
    Error Executing Database Query.  
Incorrect string value: '\xC2\x96 Jan...' for column 't61' at row 1  
  
The error occurred in C:\ColdFusion8\wwwroot\JJ8\1_mmm\3mmm_add2_readhtml_action3===.cfm: line 79
 
77 : (type1, t61, add, JJ1)
78 : 	values 
79 : ('#url.aatype1#', '#aacc2#', 'si', '#url.page#')
80 :      </cfquery>
81 : 

 

--------------------------------------------------------------------------------
 
SQLSTATE   HY000 
SQL    insert into tbl_r001 (type1, t61, add, JJ1) values ('addmmm', '<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Yasser Indol, Singapore, 2 years 5 months</title> <script language="Javascript" type="text/Javascript"> var win1=null; function MM_openBrWindow2theURL,winName,features //v2.0 if win1 ifwin1.closed win1=window.opentheURL,winName,features; else win1.focus; else win1=window.opentheURL,winName,features; win1.focus; return false; function print_resumeformObj var summaryFlag = 0; var summaryCheckObj = formObj.summaryCheck
    Tags: None
    • acoder
      Recognized Expert MVP
      • Nov 2006
      • 16032
      #2
      You should be using cfqueryparam for all inputs into the database.

        Comment

        • freddie007
          New Member
          • Sep 2008
          • 20
          #3
          I have tried using the following code == still error



          =============== ======== cf_sql_longvarc har


          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\x 82\xC2\xA0...' for column 't6a' at row 1

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

          77 : (type1, t6a, add, jb1)
          78 : values
          79 : ('#url.aatype1# ', <cfqueryparam value="#aacc2#" cfsqltype="cf_s ql_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\x 82\xC2\xA0...' for column 't6a' at row 1

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

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

            Comment

            • acoder
              Recognized Expert MVP
              • Nov 2006
              • 16032
              #4
              This seems like a database error. Try the same query in your database directly and see if you still get the error.

                Comment

                • freddie007
                  New Member
                  • Sep 2008
                  • 20
                  #5
                  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

                  :)

                    Comment

                    • acoder
                      Recognized Expert MVP
                      • Nov 2006
                      • 16032
                      #6
                      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.

                        Comment

                        • freddie007
                          New Member
                          • Sep 2008
                          • 20
                          #7
                          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

                            Comment

                            • acoder
                              Recognized Expert MVP
                              • Nov 2006
                              • 16032
                              #8
                              Which database are you using?

                                Comment

                                • freddie007
                                  New Member
                                  • Sep 2008
                                  • 20
                                  #9
                                  MYSQL 5.0
                                  table is set with MYISAM

                                  character set == latin1

                                  latin1_swedish_ ci

                                    Comment

                                    • acoder
                                      Recognized Expert MVP
                                      • Nov 2006
                                      • 16032
                                      #10
                                      Ask in the MySQL forum. I'll leave this thread here in case the problem persists in your Coldfusion application.

                                        Comment

                                        • Infotwins
                                          New Member
                                          • Sep 2009
                                          • 1
                                          #11
                                          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

                                            Comment

                                            Previous template Next
                                            Working...