Hi Mike,
Your post does not indicate that it is desirable or necessary to create a
separate page for each store. Just because they have different ID numbers
does not necessitate that they have different pages. One of my apps has many
(10+) clients in about 40k records. If one or more of the clients want
something special/extra I can (for a price) provide it. Otherwise they all
see the same data pages/formats, but of course only their data. I just use
the ID to Select(filter) the records they see. I capture the ID in a session
variable (or you can use a CFCookie)on the first page and use that in any
CFQueries on that or other pages. For instance if they want to search their
data by city, I search by the their ID + the city they input. If they want
to search by last name I search by their ID + the Last name the input, etc.
Good luck.
Regards,
Paige
----- Original Message -----
From: "Mike Weaver" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 24, 2000 2:30 AM
Subject: NEWBIE REQUESTS HELP
> This is a multi-part message in MIME format.
>
> ------=_NextPart_000_0014_01BFF4FE.097694A0
> Content-Type: text/plain;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> I have a situation where I have 5 different companies which use the same =
> application with the only difference being that the items in a select =
> box must change depending on company. The 5 companies however are =
> comprised of multiple stores. The store ID designates the company via =
> 1xx series. 2xx. series 3xx series, etc. Will I have to develop a =
> separate page for each company, or is there a way to determine the =
> select variables based on the initial store input ID of xxx? Multiple =
> stored and retrieved records in the database and it's tables are based =
> on the store ID
>
> Any assistance appreciated!!!!!
>
> Mike
>
> ------=_NextPart_000_0014_01BFF4FE.097694A0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=3DContent-Type content=3D"text/html; =
> charset=3Diso-8859-1">
> <META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR>
> <STYLE></STYLE>
> </HEAD>
> <BODY bgColor=3D#ffffff>
> <DIV><FONT face=3DArial size=3D2>I have a situation where I have 5 =
> different=20
> companies which use the same application with the only difference being =
> that the=20
> items in a select box must change depending on company. The 5 companies =
> however=20
> are comprised of multiple stores. The store ID designates the =
> company via=20
> 1xx series. 2xx. series 3xx series, etc. Will I have to develop a =
> separate=20
> page for each company, or is there a way to determine the select =
> variables based=20
> on the initial store input ID of xxx? Multiple stored and retrieved =
> records=20
> in the database and it's tables are based on the store =
> ID</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Any assistance =
> appreciated!!!!!</FONT></DIV>
> <DIV><FONT face=3DArial size=3D2></FONT> </DIV>
> <DIV><FONT face=3DArial size=3D2>Mike</FONT></DIV></BODY></HTML>
>
> ------=_NextPart_000_0014_01BFF4FE.097694A0--
>
> --------------------------------------------------------------------------
----
> 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.
>
------------------------------------------------------------------------------
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.
