you're missing a closing ) on your values clause.
christopher olive, cio
cresco technologies, inc
http://www.crescotech.com
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 9:54 AM
To: CF-Talk
Subject: brain far
Question,
I am having
Actually I am in the process of converting this site to SP. I am a big fan
of them.
- Original Message -
From: "Matthew W Jones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 10:21 AM
Subject: RE: brain far
&
L PROTECTED]>
Sent: Wednesday, September 05, 2001 9:48 AM
Subject: RE: brain far
> Your brain far is that you are missing your closing ) on the end of the
SQL
> Statement.
>
> -Original Message-
> From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 0
What type of field is Venue_City_ID?
J
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: 05 September 2001 14:54
To: CF-Talk
Subject: brain far
Question,
I am having a brain fart. I am entering information into a database, and one
of the fields takes in a comma sep
Bruce,
> The Venue_City_ID is the comma separated list. The field in the
> DB is a text field (SQL Server 7). When I view the output, I get
> something like '3,4,5'. I would think that this would be OK since
> everything is inside of single quotes. However, I am receiving errors.
>
> ODBC Error
use a stored procedure for your insert
could probably use cfqueryparam also
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 8:54 AM
To: CF-Talk
Subject: brain far
Question,
I am having a brain fart. I am entering information into a d
Your brain far is that you are missing your closing ) on the end of the SQL
Statement.
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 9:54 AM
To: CF-Talk
Subject: brain far
Question,
I am having a brain fart. I am entering information
You need a closing bracket !
INSERT INTO Coupon (Vendor_ID, C_Title, C_Details, C_Inst, C_Valid,
C_Office, Venue_City_ID)
Values (#qGetLastID.LastID#, '#Form.C_Title#', '#Form.C_Details#',
'#Form.C_Inst#', '#Form.C_Valid#', '#Form.C_Office#', '#Form.Venue#')
alistair
Alistair Davidson
Seni
Bruce,
Try closing the parenthesis on your values list. That might do the trick.
INSERT INTO Coupon (Vendor_ID, C_Title, C_Details, C_Inst, C_Valid,
C_Office, Venue_City_ID)
Values (#qGetLastID.LastID#, '#Form.C_Title#', '#Form.C_Details#',
'#Form.C_Inst#', '#Form.C_Valid#', '#Form.C_Office
You left out the closing ) after #form_Venue#')
--^^
Don Vawter
www.cyberroomies.com
[EMAIL PROTECTED]
- Original Message -
From: "Bruce Sorge" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 7:53 AM
Su
Your brain far is that you are missing your closing ) on the end of the SQL
Statement.
-Original Message-
From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 05, 2001 9:54 AM
To: CF-Talk
Subject: brain far
Question,
I am having a brain fart. I am entering information
11 matches
Mail list logo