This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_000_01C02151.2EEA0972
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C02151.2EEA0972"
------_=_NextPart_001_01C02151.2EEA0972
Content-Type: text/plain;
charset="iso-8859-1"
Hi,
I am building an app that has a fairly complex cf structure used to hold a
holiday booking in memory. When the booking is saved this structure needs to
be inserted into the relevant tables in a sql 7 database. What is the most
secure way to do these inserts in bulk and keep the id's unique, bearing in
mind that many inserts will be related and require the record id to be
returned after the insert?
Also, can I loop around an insert query to add variable numbers of records
from a structure to the same database table, see example.
What is the recommended limit for inserts using cftransction, the structures
that I want to insert en masse could total maybe 40 insert queries, is this
too much!
I've also considered keeping the next table id numbers for a given
application stored in application variables, hopefully avoiding simultaneous
inserting problems.
Any experience of these issues would be greatly appreciated.
Rich
------_=_NextPart_001_01C02151.2EEA0972
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV>Hi, </DIV>
<DIV>
<P>I am building an app that has a fairly complex cf structure used to hold a
holiday booking in memory. When the booking is saved this structure needs to be
inserted into the relevant tables in a sql 7 database. What is the most secure
way to do these inserts in bulk and keep the id's unique, bearing in mind that
many inserts will be related and require the record id to be returned after the
insert?
<P>Also, can I loop around an insert query to add variable numbers of records
from a structure to the same database table, see example.
<P>What is the recommended limit for inserts using cftransction, the structures
that I want to insert en masse could total maybe 40<SPAN
class=750550909-18092000> insert queries</SPAN>, is this too much!
<P>I've also considered keeping the next table id numbers for a given
application stored in application variables, hopefully avoiding simultaneous
inserting problems.
<P>Any experience of these issues would be greatly appreciated. </P>
<P><SPAN class=750550909-18092000><FONT face=Verdana
size=2>Rich</FONT></SPAN></P></DIV>
<DIV> </DIV></BODY></HTML>
------_=_NextPart_001_01C02151.2EEA0972--
------_=_NextPart_000_01C02151.2EEA0972
Content-Type: application/octet-stream;
name="Richard Moger (E-mail).vcf"
Content-Disposition: attachment;
filename="Richard Moger (E-mail).vcf"
BEGIN:VCARD
VERSION:2.1
N:Moger;Richard
FN:Richard Moger (E-mail)
ORG:James Villa Holidays Ltd
TITLE:IT Manager
TEL;WORK;VOICE:+44 (01732) 840846
TEL;CELL;VOICE:+44 (0777) 953 8192
TEL;WORK;FAX:+44 (01732) 872093
ADR;WORK;ENCODING=QUOTED-PRINTABLE:;;Regents Court=0D=0ALondon
Road;Addington;Kent;ME19 5PL;United Kingdom
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Regents Court=0D=0ALondon Road=0D=0AAddington,
Kent ME19 5PL=0D=0AUnited Kin=
gdom
EMAIL;PREF;INTERNET:[EMAIL PROTECTED]
REV:20000707T003119Z
END:VCARD
------_=_NextPart_000_01C02151.2EEA0972--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
