I think you just need some single quotes around your text datatype input
values. ie: '#desc#'...
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 11:48 AM
To: CF-Talk
Subject: RE: Just curious possible problem
I get the following error
I changed the name in my database and the problem cleared up.
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 20, 2002 6:56 AM
To: CF-Talk
Subject: RE: Just curious possible problem
I think you just need some single quotes around your text datatype
I noticed if I have a set of text example: s3 10 X 50 120 pcs. I have
this in an access database without the quotes, but when I try to copy that
information to anew table it stops where the first space begins. So when I
am looking at what copied into the new table is just s3.. What am I doing
-Talk
Subject: Just curious possible problem
I noticed if I have a set of text example: s3 10 X 50 120 pcs. I have
this in an access database without the quotes, but when I try to copy that
information to anew table it stops where the first space begins. So when I
am looking at what copied
-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:35 AM
To: CF-Talk
Subject: RE: Just curious possible problem
What code are you using to perform the copy?
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http
whats the length of the destination field?
- j
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 10:35 AM
To: CF-Talk
Subject: Just curious possible problem
I noticed if I have a set of text example: s3 10 X 50 120 pcs. I have
They are both identical at: 50
-Original Message-
From: Jim Curran [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 9:57 AM
To: CF-Talk
Subject: RE: Just curious possible problem
whats the length of the destination field?
- j
-Original Message-
From: Webmaster
of
table fields otherwise you'll be putting data into teh wrong fields.
hth
Doug
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2002 15:52
To: CF-Talk
Subject: RE: Just curious possible problem
I place the info in a form and then do this cfinsert
CFINSERT
thanks I will try it..
-Original Message-
From: Douglas McKenzie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 10:16 AM
To: CF-Talk
Subject: RE: Just curious possible problem
try using sql so it would look like this:
cfquery etcetc...
INSERT INTO soldSteel
(list
the list of
table fields otherwise you'll be putting data into teh wrong fields.
hth
Doug
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2002 15:52
To: CF-Talk
Subject: RE: Just curious possible problem
I place the info in a form and then do this cfinsert
.
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2002 16:48
To: CF-Talk
Subject: RE: Just curious possible problem
I get the following error when I try to do it that way.. My query is at the
bottom.
Error Occurred While Processing Request
Error Diagnostic
.
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: 19 September 2002 16:48
To: CF-Talk
Subject: RE: Just curious possible problem
I get the following error when I try to do it that way.. My query is at the
bottom.
Error Occurred While Processing Request
Error
-Original Message-
From: Douglas McKenzie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 19, 2002 10:53 AM
To: CF-Talk
Subject: RE: Just curious possible problem
OK, try this:
cfquery DATASOURCE=brinventory name=insert
INSERT INTO soldSteel
(type_id, desc, typeid, width, weight
13 matches
Mail list logo