The error seems to be error due to space or character set
=============== =============== ============ - 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
10  5052  acoder 16,027
Recognized Expert Moderator MVP
You should be using cfqueryparam for all inputs into the database.
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>
acoder 16,027
Recognized Expert Moderator MVP
This seems like a database error. Try the same query in your database directly and see if you still get the error.
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
:)
acoder 16,027
Recognized Expert Moderator MVP
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.
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
acoder 16,027
Recognized Expert Moderator MVP
Which database are you using?
MYSQL 5.0
table is set with MYISAM
character set == latin1
latin1_swedish_ ci
acoder 16,027
Recognized Expert Moderator MVP
Ask in the MySQL forum. I'll leave this thread here in case the problem persists in your Coldfusion application.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Humber Consumer |
last post by:
I have a bunch of .HTML files . Each html file has help specific to a
dialog box of windows form app.
I want to make use of help provider to provide help.
So I set index.HTML as the namespace of helpprovide. Now my problem is
that I don't know how to lauch /activate the proper .htm file when
user presses F1 on different dialogs. There is no keyword etc.
One option is to compile these html files to .chm format and then
create keywords...
|
by: Ben Amada |
last post by:
Hello,
A partner is going to be creating some HTML files that I plan on converting
to user controls (UC) and dynamically load at runtime. I'm guessing Visual
Studio doesn't come with some utililty to convert HTML files to UCs? IOW,
I'll have to manually convert each HTML file to a UC? I've never used user
controls before, so I'm wondering what I need to add and remove to each UC
(or HTML file) to make this work. For instance, I...
|
by: VK |
last post by:
Hi,
After the response on my request from W3C I'm still unclear about Tidy
vs. Validator discrepansies. That started with <IFRAME> issue, but
there is more as I know. Anyway, this very basic HTML page:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Strict//EN"
"http://www.w3.org/TR/html401/strict.dtd">
<html>
<head>
|
by: Giedrius |
last post by:
hi,
i have an idea to make admin tool on home computer, that would generate html
files using some kind of templates and database data and put these generated
html files to public web server, witch doesn't have running asp.net, using
ftp access.
why i need so?
because:
1) my project doesn't need to receive any data from browsing customers, it
will be only company news, info about new products - so it's enough to have
static html on...
|
by: D`Jinn Deegee |
last post by:
I have 5 html files say
file1.html
file2.html
:
:
file5.html
Now I have another html file (main.html) where I want to use 1 html
| | |
by: Klaus Jensen |
last post by:
Hi
I face this challenge:
An existing site with 50000+ html-files needs to be protected by a custom
login-system which has two goals:
1. Protect HTML-content (authentication required)
2. If the same username is used by two persons at the same time, they have
to be logged out (when a login is used, other users currently logged in
|
by: Zoro |
last post by:
My task is to read html files from disk and save them onto SQL Server
database field. I have created an nvarchar(max) field to hold them.
The problem is that some characters, particularly html entities, and
French/German special characters are lost and/or replaced by a
question mark.
This is really frustrating. I have tried using StreamReader with ALL
the encodings available and none work correctly. Each encoding handles
some characters...
|
by: msg2ajay |
last post by:
hello,
i am very new to Ajax i have tried an example but it showing some error can anybady tell me where i am doing mistake... my coding is as follows
ajax.html:
-----------
<html><body><script type="text/javascript">
function ajaxFunction()
{
var xmlHttp;
|
by: Gary Hasler |
last post by:
I want apache to parse all .html files for php code. Our 'real' web
server is rented from ICDsoft ( php 5 on Apache on Linux whatever), and
their instruction is to add the following to the .htaccess file:
AddHandler application/x-httpd-php .html
....which works great.
However, our local in-office server for testing and viewing our sites is
Apache 2.0.55 with PHP 4.4.4 on Windows XP Pro. I have read everything
I can find, and have...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
