This is a multi-part message in MIME format.
------=_NextPart_000_001B_01BFA156.90B36AC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Here's my problem: I populate a listbox with a query that returns part =
descriptions from a text field in an Access database. The user selects a =
description and submits the form. I then do the following in the next =
template:
<cfquery name=3D"addnew" datasource=3D"sourcename">
insert into parts(partnumber,description) =
values('#partnumber#','#description#')
</cfquery>
I receive various errors ie: syntax, access, column doesn't exist or =
data mismatch error, but ONLY when the record I am truying to insert has =
single or double quotes or commas in it.
Example: "Stock Length, 14' 6", with bronze anodizing." or "Bolt, 6 1/2" =
- Stainless Steel" either of these two will cause an error, while "Bolt =
- Long Threads" will insert without a hitch.
I cannot do anything about the way the parts descriptions are added as =
it is in another application that uses that shares the database.
Any suggestions will be appreciated
Terry Troxel
------=_NextPart_000_001B_01BFA156.90B36AC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Here's my problem: I populate a listbox with a query =
that=20
returns part descriptions from a text field in an Access database. The =
user=20
selects a description and submits the form. I then do the following in =
the next=20
template:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2><cfquery name=3D"addnew"=20
datasource=3D"sourcename"><BR> insert into=20
parts(partnumber,description)=20
values('#partnumber#','#description#')</FONT></DIV>
<DIV><FONT size=3D2></cfquery></FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I receive various errors ie: syntax, access, column =
doesn't=20
exist or data mismatch error, but ONLY when the record I am truying =
to=20
insert has single or double quotes or commas in it.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Example: "Stock Length, 14' 6", with bronze =
anodizing."=20
or "Bolt, 6 1/2" - Stainless Steel" either of these two will cause an =
error,=20
while "Bolt - Long Threads" will insert without a hitch.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>I cannot do anything about the way the parts =
descriptions are=20
added as it is in another application that uses that shares the=20
database.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT size=3D2>Any suggestions will be appreciated</FONT></DIV>
<DIV> <FONT size=3D2>Terry Troxel</FONT></DIV></BODY></HTML>
------=_NextPart_000_001B_01BFA156.90B36AC0--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
