Hi,

I have built a system which provides a schedule to some of our users. They
can add and remove bookings for any day as they wish.

I've recently been told that some bookings are fixed, and for example,
re-occur everyday at the same time. This allows frequent suppliers to avoid
having to re-book each day.

How do I integrate this?

So far I've made another table just for Fixed Bookings which will list the
SupplierID and time. As it occurs each day, I don't need to add any dates.

But how does the homepage merge the info, with the Bookings table? Can I add
arrays together?

I need it to do this:

  1. List bookings
  2. List Fixed Bookings
  3. Display all as one list, sorted by time

So far it doesn't do number 2.

I'm using Access for the DB, so cannot use triggers to populate the main
table overnight.


Any suggestions anyone? I'm stuck!!


Cheers
Craig.


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

what does the list bookings table have?
 Craig Flannigan wrote:Hi,

I have built a system which provides a schedule to some of our users. They
can add and remove bookings for any day as they wish.

I've recently been told that some bookings are fixed, and for example,
re-occur everyday at the same time. This allows frequent suppliers to avoid
having to re-book each day.

How do I integrate this?

So far I've made another table just for Fixed Bookings which will list the
SupplierID and time. As it occurs each day, I don't need to add any dates.

But how does the homepage merge the info, with the Bookings table? Can I add
arrays together?

I need it to do this:

1. List bookings
2. List Fixed Bookings
3. Display all as one list, sorted by time

So far it doesn't do number 2.

I'm using Access for the DB, so cannot use triggers to populate the main
table overnight.


Any suggestions anyone? I'm stuck!!


Cheers
Craig.


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________



---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes

I have two tables.

Bookings - Contains all bookings (date, time, SupplierID, Bay and Carrier)
FixedBookings - New table (SupplierID, Time)

The Bookings table is used to store the details of when a supplier is
visiting.
The FixedBookings table contains fixed bookings that are the same time each
day for the same supplier.

The reason I need this is so that when the users are booking in suppliers,
they do not book over the time that a Fixed booking is made for.

For example, HP deliver to us at the same time each day, so it's a pain to
have to manually book them in each day, where as some suppliers only come
once a week, and on different days.


I'd like to show the bookings for one day on the page, with the fixed
bookings merged into the same list as if it all came from one table.

Does this make sense?

Cheers
Craig.



-----Original Message-----
From: Vijay G [mailto:happygv@y...]
Sent: 03 September 2002 13:40
To: ASP Databases
Subject: [asp_databases] Re: Suggestions needed!



what does the list bookings table have?
 Craig Flannigan wrote:Hi,

I have built a system which provides a schedule to some of our users. They
can add and remove bookings for any day as they wish.

I've recently been told that some bookings are fixed, and for example,
re-occur everyday at the same time. This allows frequent suppliers to avoid
having to re-book each day.

How do I integrate this?

So far I've made another table just for Fixed Bookings which will list the
SupplierID and time. As it occurs each day, I don't need to add any dates.

But how does the homepage merge the info, with the Bookings table? Can I add
arrays together?

I need it to do this:

1. List bookings
2. List Fixed Bookings
3. Display all as one list, sorted by time

So far it doesn't do number 2.

I'm using Access for the DB, so cannot use triggers to populate the main
table overnight.


Any suggestions anyone? I'm stuck!!


Cheers
Craig.


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________



---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes



_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

One thing I can suggest is to have in the same table. You can set/Alter the DATE Column in BOOKINGS table to have NULL and allow the
rows that appear for BOOKINGS alone to have a value in this field. For those appear in FIXED BOOKINGS, leave the DATE column as
EMPTY/NULL so that only one entry for every FIXED BOOKING SUPPLIERS will be there in the table.

At any point of time, 

1) To display the Bookings List, you can query something like
           Select * from Bookings where date = getdate() order by time

2) To display only the FIXED Bookings list, you can query like
           Select * from Bookings where date is NULL order by time

3) To Display both The bookings together, you can query like
           Select * from Bookings where Date = getdate() or date is NULL order by time

Why I suggested you to have them both in same table is, you may miss out the other fields like Bay and Carrier in FIXEDBOOKING, if I
am correct.

Also there is no need to have a seperate table and merge the results querying both when needed.

In you User Interface, while adding only thing you need to have is keep a Checkbox, to know if it is a FIXED BOOKING or not. If it
is checked, then Leave the DATE Field as empty while inserting the date. Else insert the data with DATE's value too included.

Hope this is simpler and understandable.

Cheers!!!
Vijay G

Craig Flannigan wrote:I have two tables.

Bookings - Contains all bookings (date, time, SupplierID, Bay and Carrier)
FixedBookings - New table (SupplierID, Time)

The Bookings table is used to store the details of when a supplier is
visiting.
The FixedBookings table contains fixed bookings that are the same time each
day for the same supplier.

The reason I need this is so that when the users are booking in suppliers,
they do not book over the time that a Fixed booking is made for.

For example, HP deliver to us at the same time each day, so it's a pain to
have to manually book them in each day, where as some suppliers only come
once a week, and on different days.


I'd like to show the bookings for one day on the page, with the fixed
bookings merged into the same list as if it all came from one table.

Does this make sense?

Cheers
Craig.



-----Original Message-----
From: Vijay G [mailto:happygv@y...]
Sent: 03 September 2002 13:40
To: ASP Databases
Subject: [asp_databases] Re: Suggestions needed!



what does the list bookings table have?
Craig Flannigan wrote:Hi,

I have built a system which provides a schedule to some of our users. They
can add and remove bookings for any day as they wish.

I've recently been told that some bookings are fixed, and for example,
re-occur everyday at the same time. This allows frequent suppliers to avoid
having to re-book each day.

How do I integrate this?

So far I've made another table just for Fixed Bookings which will list the
SupplierID and time. As it occurs each day, I don't need to add any dates.

But how does the homepage merge the info, with the Bookings table? Can I add
arrays together?

I need it to do this:

1. List bookings
2. List Fixed Bookings
3. Display all as one list, sorted by time

So far it doesn't do number 2.

I'm using Access for the DB, so cannot use triggers to populate the main
table overnight.


Any suggestions anyone? I'm stuck!!


Cheers
Craig.


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________



---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes



_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________



---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes

Hi!

Use UNION SELECT if you wanmt to merge information from 2 similar tables:
SELECT field1, field2 from table1
UNION
SELECT field1, field2 from table2

You can also use alias like:
SELECT somefield1 as field1, field2 from table1
UNION
SELECT field1, field2 from table2


I hope I wrote this correctly..have a look in your SQL tutorial about UNION

Hakan

---------- Original Message ----------------------------------
From: "Craig Flannigan" <ckf@k...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date:  Tue, 3 Sep 2002 14:31:51 +0100

>I have two tables.
>
>Bookings - Contains all bookings (date, time, SupplierID, Bay and Carrier)
>FixedBookings - New table (SupplierID, Time)
>
>The Bookings table is used to store the details of when a supplier is
>visiting.
>The FixedBookings table contains fixed bookings that are the same time each
>day for the same supplier.
>
>The reason I need this is so that when the users are booking in suppliers,
>they do not book over the time that a Fixed booking is made for.
>
>For example, HP deliver to us at the same time each day, so it's a pain to
>have to manually book them in each day, where as some suppliers only come
>once a week, and on different days.
>
>
>I'd like to show the bookings for one day on the page, with the fixed
>bookings merged into the same list as if it all came from one table.
>
>Does this make sense?
>
>Cheers
>Craig.
>
>
>
>-----Original Message-----
>From: Vijay G [mailto:happygv@y...]
>Sent: 03 September 2002 13:40
>To: ASP Databases
>Subject: [asp_databases] Re: Suggestions needed!
>
>
>
>what does the list bookings table have?
> Craig Flannigan wrote:Hi,
>
>I have built a system which provides a schedule to some of our users. They
>can add and remove bookings for any day as they wish.
>
>I've recently been told that some bookings are fixed, and for example,
>re-occur everyday at the same time. This allows frequent suppliers to avoid
>having to re-book each day.
>
>How do I integrate this?
>
>So far I've made another table just for Fixed Bookings which will list the
>SupplierID and time. As it occurs each day, I don't need to add any dates.
>
>But how does the homepage merge the info, with the Bookings table? Can I add
>arrays together?
>
>I need it to do this:
>
>1. List bookings
>2. List Fixed Bookings
>3. Display all as one list, sorted by time
>
>So far it doesn't do number 2.
>
>I'm using Access for the DB, so cannot use triggers to populate the main
>table overnight.
>
>
>Any suggestions anyone? I'm stuck!!
>
>
>Cheers
>Craig.
>
>
>_____________________________________________________________________
>Kingfield Heath Ltd. Email Disclaimer
>
>Confidentiality : This email and its attachments are intended for the
>above-named only and may be confidential. If they have come to you in
>error you must take no action based on them, nor must you copy or
>show them to anyone; please reply to this email and highlight the
>error.
>
>Security Warning : Please note that this email has been created in
>the knowledge that the internet is not a 100% secure communications
>medium. We advise that you understand and observe this lack of
>security when emailing us.
>
>Viruses : Although we have taken steps to ensure that this email and
>attachments are free from any virus, we advise that, in keeping with
>good computing practice, the recipient should ensure they are
>actually virus free.
>_____________________________________________________________________
>
>
>
>---------------------------------
>Do You Yahoo!?
>Yahoo! Finance - Get real-time stock quotes
>
>
>
>_____________________________________________________________________
>Kingfield Heath Ltd. Email Disclaimer
>
>Confidentiality : This email and its attachments are intended for the
>above-named only and may be confidential. If they have come to you in
>error you must take no action based on them, nor must you copy or
>show them to anyone; please reply to this email and highlight the
>error.
>
>Security Warning : Please note that this email has been created in
>the knowledge that the internet is not a 100% secure communications
>medium. We advise that you understand and observe this lack of
>security when emailing us.
>
>Viruses : Although we have taken steps to ensure that this email and
>attachments are free from any virus, we advise that, in keeping with
>good computing practice, the recipient should ensure they are
>actually virus free.
>_____________________________________________________________________
>
>

Many thanks for your detailed suggestion Vijay

I'll give it ago.



-----Original Message-----
From: Vijay G [mailto:happygv@y...]
Sent: 03 September 2002 16:34
To: ASP Databases
Subject: [asp_databases] Re: Suggestions needed!



One thing I can suggest is to have in the same table. You can set/Alter the
DATE Column in BOOKINGS table to have NULL and allow the rows that appear
for BOOKINGS alone to have a value in this field. For those appear in FIXED
BOOKINGS, leave the DATE column as EMPTY/NULL so that only one entry for
every FIXED BOOKING SUPPLIERS will be there in the table.

At any point of time,

1) To display the Bookings List, you can query something like
           Select * from Bookings where date = getdate() order by time

2) To display only the FIXED Bookings list, you can query like
           Select * from Bookings where date is NULL order by time

3) To Display both The bookings together, you can query like
           Select * from Bookings where Date = getdate() or date is NULL
order by time

Why I suggested you to have them both in same table is, you may miss out the
other fields like Bay and Carrier in FIXEDBOOKING, if I am correct.

Also there is no need to have a seperate table and merge the results
querying both when needed.

In you User Interface, while adding only thing you need to have is keep a
Checkbox, to know if it is a FIXED BOOKING or not. If it is checked, then
Leave the DATE Field as empty while inserting the date. Else insert the data
with DATE's value too included.

Hope this is simpler and understandable.

Cheers!!!
Vijay G

Craig Flannigan wrote:I have two tables.

Bookings - Contains all bookings (date, time, SupplierID, Bay and Carrier)
FixedBookings - New table (SupplierID, Time)

The Bookings table is used to store the details of when a supplier is
visiting.
The FixedBookings table contains fixed bookings that are the same time each
day for the same supplier.

The reason I need this is so that when the users are booking in suppliers,
they do not book over the time that a Fixed booking is made for.

For example, HP deliver to us at the same time each day, so it's a pain to
have to manually book them in each day, where as some suppliers only come
once a week, and on different days.


I'd like to show the bookings for one day on the page, with the fixed
bookings merged into the same list as if it all came from one table.

Does this make sense?

Cheers
Craig.



-----Original Message-----
From: Vijay G [mailto:happygv@y...]
Sent: 03 September 2002 13:40
To: ASP Databases
Subject: [asp_databases] Re: Suggestions needed!



what does the list bookings table have?
Craig Flannigan wrote:Hi,

I have built a system which provides a schedule to some of our users. They
can add and remove bookings for any day as they wish.

I've recently been told that some bookings are fixed, and for example,
re-occur everyday at the same time. This allows frequent suppliers to avoid
having to re-book each day.

How do I integrate this?

So far I've made another table just for Fixed Bookings which will list the
SupplierID and time. As it occurs each day, I don't need to add any dates.

But how does the homepage merge the info, with the Bookings table? Can I add
arrays together?

I need it to do this:

1. List bookings
2. List Fixed Bookings
3. Display all as one list, sorted by time

So far it doesn't do number 2.

I'm using Access for the DB, so cannot use triggers to populate the main
table overnight.


Any suggestions anyone? I'm stuck!!


Cheers
Craig.


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________



---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes



_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________



---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes



_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________

Thanks.

I forgot about that - will check my SQL books.

Cheers
Craig.

-----Original Message-----
From: Hakan Frennesson [mailto:hakan@c...]
Sent: 03 September 2002 17:37
To: ASP Databases
Subject: [asp_databases] Re: Suggestions needed!


Hi!

Use UNION SELECT if you wanmt to merge information from 2 similar tables:
SELECT field1, field2 from table1
UNION
SELECT field1, field2 from table2

You can also use alias like:
SELECT somefield1 as field1, field2 from table1
UNION
SELECT field1, field2 from table2


I hope I wrote this correctly..have a look in your SQL tutorial about UNION

Hakan

---------- Original Message ----------------------------------
From: "Craig Flannigan" <ckf@k...>
Reply-To: "ASP Databases" <asp_databases@p...>
Date:  Tue, 3 Sep 2002 14:31:51 +0100

>I have two tables.
>
>Bookings - Contains all bookings (date, time, SupplierID, Bay and Carrier)
>FixedBookings - New table (SupplierID, Time)
>
>The Bookings table is used to store the details of when a supplier is
>visiting.
>The FixedBookings table contains fixed bookings that are the same time each
>day for the same supplier.
>
>The reason I need this is so that when the users are booking in suppliers,
>they do not book over the time that a Fixed booking is made for.
>
>For example, HP deliver to us at the same time each day, so it's a pain to
>have to manually book them in each day, where as some suppliers only come
>once a week, and on different days.
>
>
>I'd like to show the bookings for one day on the page, with the fixed
>bookings merged into the same list as if it all came from one table.
>
>Does this make sense?
>
>Cheers
>Craig.
>
>
>
>-----Original Message-----
>From: Vijay G [mailto:happygv@y...]
>Sent: 03 September 2002 13:40
>To: ASP Databases
>Subject: [asp_databases] Re: Suggestions needed!
>
>
>
>what does the list bookings table have?
> Craig Flannigan wrote:Hi,
>
>I have built a system which provides a schedule to some of our users. They
>can add and remove bookings for any day as they wish.
>
>I've recently been told that some bookings are fixed, and for example,
>re-occur everyday at the same time. This allows frequent suppliers to avoid
>having to re-book each day.
>
>How do I integrate this?
>
>So far I've made another table just for Fixed Bookings which will list the
>SupplierID and time. As it occurs each day, I don't need to add any dates.
>
>But how does the homepage merge the info, with the Bookings table? Can I
add
>arrays together?
>
>I need it to do this:
>
>1. List bookings
>2. List Fixed Bookings
>3. Display all as one list, sorted by time
>
>So far it doesn't do number 2.
>
>I'm using Access for the DB, so cannot use triggers to populate the main
>table overnight.
>
>
>Any suggestions anyone? I'm stuck!!
>
>
>Cheers
>Craig.
>
>
>_____________________________________________________________________
>Kingfield Heath Ltd. Email Disclaimer
>
>Confidentiality : This email and its attachments are intended for the
>above-named only and may be confidential. If they have come to you in
>error you must take no action based on them, nor must you copy or
>show them to anyone; please reply to this email and highlight the
>error.
>
>Security Warning : Please note that this email has been created in
>the knowledge that the internet is not a 100% secure communications
>medium. We advise that you understand and observe this lack of
>security when emailing us.
>
>Viruses : Although we have taken steps to ensure that this email and
>attachments are free from any virus, we advise that, in keeping with
>good computing practice, the recipient should ensure they are
>actually virus free.
>_____________________________________________________________________
>
>
>
>---------------------------------
>Do You Yahoo!?
>Yahoo! Finance - Get real-time stock quotes
>
>
>
>_____________________________________________________________________
>Kingfield Heath Ltd. Email Disclaimer
>
>Confidentiality : This email and its attachments are intended for the
>above-named only and may be confidential. If they have come to you in
>error you must take no action based on them, nor must you copy or
>show them to anyone; please reply to this email and highlight the
>error.
>
>Security Warning : Please note that this email has been created in
>the knowledge that the internet is not a 100% secure communications
>medium. We advise that you understand and observe this lack of
>security when emailing us.
>
>Viruses : Although we have taken steps to ensure that this email and
>attachments are free from any virus, we advise that, in keeping with
>good computing practice, the recipient should ensure they are
>actually virus free.
>_____________________________________________________________________
>
>


_____________________________________________________________________
Please contact I.T. Support if you have received this email in error.
This e-mail has been scanned for all viruses by Star Internet.
_____________________________________________________________________


_____________________________________________________________________
Kingfield Heath Ltd. Email Disclaimer

Confidentiality : This email and its attachments are intended for the
above-named only and may be confidential. If they have come to you in
error you must take no action based on them, nor must you copy or
show them to anyone; please reply to this email and highlight the
error.

Security Warning : Please note that this email has been created in
the knowledge that the internet is not a 100% secure communications
medium. We advise that you understand and observe this lack of
security when emailing us.

Viruses : Although we have taken steps to ensure that this email and
attachments are free from any virus, we advise that, in keeping with
good computing practice, the recipient should ensure they are
actually virus free.
_____________________________________________________________________