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_01C01F32.D35C6ED0
Content-Type: text/plain;
charset="iso-8859-1"
Shane,
I am only using application variables to store the next primary key id of
the relevant database table (must be application wide) and use it as a look
up value to the individual booking structures (session variables). If you
stored these id's in a session var too you could have many users trying to
add records with the same id! Does that all make sense?
Rich
-----Original Message-----
From: Shane Pitts [mailto:[EMAIL PROTECTED]]
Sent: 15 September 2000 17:24
To: RICHARD MOGER
Subject: RE: Best way adding cf structure to existing database
structure?
Definately don't use application variables. Use either client, or session.
If you start setting customer specific variables as app vars, everyone that
logs in now has those same vars. client and session vars are specific to
that user, and each have their own up's and downs. I typically use session
vars where I want them to last for a length of time, then expire, and I use
client vars, where I want to hold something for a little bit and delete it
at will.
Shane
-----Original Message-----
From: RICHARD MOGER [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 15, 2000 10:18 AM
To: Cf-Talk@Houseoffusion. Com (E-mail)
Subject: Best way adding cf structure to existing database structure?
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_01C01F30.74D8B7A8
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C01F30.74D8B7A8"
------_=_NextPart_001_01C01F30.74D8B7A8
Content-Type: text/plain;
charset="iso-8859-1"
Hi All,
*takesdeepbreath*
I'm building a cf intranet based holiday reservations system. The bookings
are created in cf Array structures i.e. each booking is composed of
components (car, flights, accom). Each one of these is a structure eg for
car component (car typeid, cost, sale, startdate, enddate etc.). Some of
these component structures then contain arrays eg flight component, a given
flight can contain various nos. of passengers, each of which is in turn
another structure.
My problem is, what is the best way to insert these structures into an SQL
database. The whole structure must be inserted into various related tables
in the database, making sure that the ids all correspond in related tables.
For example when adding flights I need to write flight component record to
database then write the id of record just written to passengers table when
I write the passengers relating to that flight to the passengers table.
confused yet?
My solution is to use application variables....
When I create a new component in cf memory, run 'getnextidfromtable' query
to get next id number from relevant db table. Then store this number in the
newly created component AND store this number plus 1 in an application
variable holding the next id for that table. For subsequent new cf
components created in memory check the existence of the
application.ids.flighttable, if it exists use this number and increment else
run 'getidfromtable' query again.
I'm sure there is more than one way to skin this cat, any suggestions
welcome before I walk the rocky road ....
Any warnings and advice on record locking issues would be appreciated too.
(30 users).
Regards
Rich
------_=_NextPart_001_01C01F30.74D8B7A8
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> </DIV>
<DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana size=2>Hi
All,</FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2>*takesdeepbreath*</FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana size=2>I'm building a
cf intranet based holiday reservations system. The bookings are created
in
cf Array structures i.e. each booking is composed of components (car,
flights,
accom). Each one of these is a structure eg for car component (car typeid,
cost,
sale, startdate, enddate etc.). Some of these component structures then
contain
arrays eg flight component, a given flight can contain various nos. of
passengers, each of which is in turn another structure. </FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana><FONT size=2>My
problem
is, what is the best way to insert these structures into an SQL database.
The
whole structure must be inserted into various related tables in the
database,
making sure that the ids all correspond in related tables. For example when
adding flights I need to write flight component record to database
then
write the id of record just written to passengers table when I write
the
passengers relating to that flight to the passengers table. confused
yet?<SPAN
class=020250716-15092000> </SPAN></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana size=2>My solution is
to
use application variables....</FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana size=2>When I create
a
new component in cf memory, run 'getnextidfromtable' query to get next id
number
from relevant db table. Then store this number in the newly created
component
AND store this number plus 1 in an application variable holding the next id
for
that table. For subsequent new cf components created in memory check the
existence of the application.ids.flighttable, if it exists use this number
and
increment else run 'getidfromtable' query again.</FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana size=2>I'm sure there
is
more than one way to skin this cat, any suggestions welcome before I walk
the
rocky road ....</FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana size=2>Any warnings
and
advice on record locking issues would be appreciated too. (30
users).</FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana size=2>Regards
</FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2>Rich</FONT></SPAN></DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=860081115-15092000><FONT face=Verdana
size=2></FONT></SPAN> </DIV></DIV>
<DIV> </DIV></BODY></HTML>
------_=_NextPart_001_01C01F30.74D8B7A8--
------_=_NextPart_000_01C01F30.74D8B7A8
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_01C01F30.74D8B7A8--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
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.
------_=_NextPart_000_01C01F32.D35C6ED0
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_01C01F32.D35C6ED0--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
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.
