Nice one Philip, will be checking it out when I get a bit of time :-)
> > Will be putting it to the test later on this afternoon!
> You got any
> > performance info on that?
>
> This REALLY is something "personal" on your setup, you might
> find that your database handles multiple INSERTs rea
> Will be putting it to the test later on this afternoon! You got any
> performance info on that?
This REALLY is something "personal" on your setup, you might find that
your database handles multiple INSERTs really well, especially during
light load, while during heavy load it sucks royally
You
> > > Also, if you're using a database engine that allows TSQL,
> then put
> > > the loop inside the CFQUERY and put a ; at the end of each INSERT
> >
> > This looks like a good tip, can this be done with other Databases as
> > well? i.e. Oracle? Have always coded the loop outside the cfquery
> > Also, if you're using a database engine that allows TSQL,
> > then put the loop inside the CFQUERY and put a ; at the end
> > of each INSERT
>
> This looks like a good tip, can this be done with other Databases as
> well? i.e. Oracle? Have always coded the loop outside the cfquery
> tag, any
Main question first..
> Also, if you're using a database engine that allows TSQL,
> then put the loop inside the CFQUERY and put a ; at the end
> of each INSERT
This looks like a good tip, can this be done with other Databases as
well? i.e. Oracle? Have always coded the loop outside the
>
>
> insert into tblAccomidations (personKey,
> accomitationId) values(pid,x)
>
>
Not forgetting to put #'s around your variables;
insert into tblAccomidations (personKey, accomitationId)
values(#pid#,#x#)
Otherwi
Sorry... Forgot the sql part:
Code like below will produce a form field variable of Accomidations=1,3
in the checkTheBoxes.cfm if Hotel and Bed and Breakfast are both
checked.
Select Multi Boxes
Accomidation Type: Check as many as you want.
1.
Hotel
2. Gu
Code like below will produce a form field variable of Accomidations=1,3
in the checkTheBoxes.cfm if Hotel and Bed and Breakfast are both
checked.
Untitled
Accomidation Type: Check as many as you want.
1.
Hotel
2. Guest
House
3. Bed and
Breakfast
TECTED]
Sent: Monday, June 09, 2003 3:02 PM
To: CF-Talk
Subject: Newbyish Question (FORMS)
Hey,
A bit out of practice, whats the best way to manage mulitple choice 'Search'
forms
Its for an accomodation guide...
I.E.1. Accomodation Types
2. Hotel
3. Guest Houses
Hey,
A bit out of practice, whats the best way to manage mulitple choice 'Search'
forms
Its for an accomodation guide...
I.E.1. Accomodation Types
2. Hotel
3. Guest Houses
4. Bed & Breakfast
5. Self Catering
A user picks 1 & 5 from the checkboxes
How
10 matches
Mail list logo