RE: Inserting a delimited list into a database

2002-02-28 Thread Jake Munson
t; From: Jake Munson [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, 28 February 2002 10:47 am > > To: CF-Talk > > Subject: Inserting a delimited list into a database > > > > > > I have a form that returns a comma delimited list of > > numbers from some checkboxes

Re: RE: Inserting a delimited list into a database

2002-02-27 Thread Bryan Stevenson
ahhh yes..but reusable code..portability ;-) Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com

Re: RE: Inserting a delimited list into a database

2002-02-27 Thread ksuh
In SQL Server, the semicolon is not needed. - Original Message - From: Bryan Stevenson <[EMAIL PROTECTED]> Date: Wednesday, February 27, 2002 3:23 pm Subject: Re: RE: Inserting a delimited list into a database > and don't forget the semicolon after the SQL statement to se

Re: RE: Inserting a delimited list into a database

2002-02-27 Thread Bryan Stevenson
MAIL PROTECTED]> Sent: Wednesday, February 27, 2002 2:11 PM Subject: Re: RE: Inserting a delimited list into a database > In addition, if you want to reduce your database calls, you can alway > s > > do: > > > > > INSERT INTO [update] (log_id, server) > VALUES (#l

Re: RE: Inserting a delimited list into a database

2002-02-27 Thread ksuh
n the insert statement with tags. - Original Message - From: Matthew Walker <[EMAIL PROTECTED]> Date: Wednesday, February 27, 2002 3:07 pm Subject: RE: Inserting a delimited list into a database > Hey ho! The problem is having a table called Update! Try wrapping > [

RE: Inserting a delimited list into a database

2002-02-27 Thread Matthew Walker
Hey ho! The problem is having a table called Update! Try wrapping [] around update. > -Original Message- > From: Jake Munson [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 28 February 2002 10:47 am > To: CF-Talk > Subject: Inserting a delimited list into a database > >

Re: Inserting a delimited list into a database

2002-02-27 Thread Jerry Johnson
What data types are log_id, server? They are both numbers, yes? Jerry Johnson >>> [EMAIL PROTECTED] 02/27/02 04:47PM >>> I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for ea

RE: Inserting a delimited list into a database

2002-02-27 Thread Steve Oliver
nal Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 4:47 PM To: CF-Talk Subject: Inserting a delimited list into a database I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able

RE: Inserting a delimited list into a database

2002-02-27 Thread Costas Piliotis
Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:47 PM To: CF-Talk Subject: Inserting a delimited list into a database I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I wan

RE: Inserting a delimited list into a database

2002-02-27 Thread Costas Piliotis
om: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 27, 2002 1:47 PM To: CF-Talk Subject: Inserting a delimited list into a database I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new

Inserting a delimited list into a database

2002-02-27 Thread Jake Munson
I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for each checkbox that was checked in my form. I figured that if I used a list loop based on my checkbox list, that I could have