RE: brain far

2001-09-06 Thread Christopher Olive
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

Re: brain far

2001-09-05 Thread Bruce Sorge
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 &

Re: brain far

2001-09-05 Thread Bruce Sorge
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

RE: brain far

2001-09-05 Thread James Maltby
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

RE: brain far

2001-09-05 Thread Stephen Moretti
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

RE: brain far

2001-09-05 Thread Matthew W Jones
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

RE: brain far

2001-09-05 Thread Alex Santantonio
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

RE: brain far

2001-09-05 Thread Alistair Davidson
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

RE: brain far

2001-09-05 Thread Brian Ferrigno
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

Re: brain far

2001-09-05 Thread Don Vawter
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

RE: brain far

2001-09-05 Thread Alex Santantonio
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