Well a even better way is to use stored procedures in this case. Provide
all the data at once, and use tSQL to insert this code. This should only
require one call instead of many to the database.
Micha Schopman
Software Engineer
Modern Media, Databankweg 12 M, 3821 AL Amersfoort
Tel 033-453537
> > Just wondering how I can go about building a dynamic insert query ???
> >
> > I need to loop over a structure and insert the items into another
> > database based on the type of item in the query column.
> >
> > The requirement for the looping, is that I don't know how many items
> > will ever
Some more info or some code would be good!
Pascal
> -Original Message-
> From: Brant Winter [mailto:[EMAIL PROTECTED]
> Sent: 13 July 2004 12:18
> To: CF-Talk
> Subject: dynamic insert query
>
> > Just wondering how I can go about building a dynamic insert query
???
> >
> > I need to loop
Ignore my last msg, miss read this one
-Original Message-
From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 11:39 AM
To: CF-Talk
Subject: RE: Dynamic Insert/Update - Still not working
Have you tried a bit of logic like:
checked>
R
Have you tried:
checked>
or
checked>
-Original Message-
From: Kennerly, Rick H CIV [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 27, 2003 11:39 AM
To: CF-Talk
Subject: RE: Dynamic Insert/Update - Still not working
Have you tried a bit of logic like:
checked&
Have you tried a bit of logic like:
checked>
Rick
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http:/
, February 26, 2003 12:02 PM
> To: CF-Talk
> Subject: RE: Dynamic Insert
>
>
> Al,
>
> Thanks! That gets me off on that part.
>
> Next question:
>
> I need to pull the values out so I have an 'update' form. You'll see
> that I'm list
> -Original Message-
> From: Everett, Al [mailto:[EMAIL PROTECTED]
> Sent: February 26, 2003 9:04 AM
> To: CF-Talk
> Subject: RE: Dynamic Insert
>
>
> Change:
>
> #org_abbr# name="org_id" value="#list.id#&
Change:
#org_abbr#
To:
#org_abbr#
Then on your action page your Form.org_id field will be a comma-delimited
list of org_id's.
Then you can just do this:
INSERT INTO org_admin
(
How about if you make the unused fields on your form invisible and give them
a value which you can detect on your processing page and set them to null. A
little more work on the form generation side.
Another way to do it is to use a set if Isdefined("Form.Adresses_X") on the
processing page and
10 matches
Mail list logo