RE: Dynamic Insert

2003-02-26 Thread Everett, Al
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 (

RE: Dynamic Insert

2003-02-26 Thread Jillian Carroll
> -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#&

RE: Dynamic Insert

2003-02-26 Thread Everett, Al
, 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

RE: dynamic insert query

2004-07-13 Thread Pascal Peters
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

Re: dynamic insert query

2004-07-13 Thread C. Hatton Humphrey
> > 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

RE: dynamic insert loop

2004-07-13 Thread Micha Schopman
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

Re: Dynamic Insert Query Issue

2002-04-02 Thread Frank Mamone
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

RE: Dynamic Insert/Update - Still not working

2003-02-27 Thread Kennerly, Rick H CIV
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:/

RE: Dynamic Insert/Update - Still not working

2003-02-27 Thread Bruce, Rodney S HQISEC/Veridian IT Services
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&

RE: Dynamic Insert/Update - Still not working

2003-02-27 Thread Bruce, Rodney S HQISEC/Veridian IT Services
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