RE: pulling wrong dates from database

2002-04-18 Thread Trusz, Andrew

Won't  --#DateFormat(GetEventtoUpdate.BeginDate, mm/dd/)#-- pick up
the same date variable each time it is used? As opposed to
#DateFormat(GetEventtoUpdate.Internet.BeginDate, mm/dd/)#, for
example.


snip
-Original Message-
From: Judy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:10 AM
To: CF-Talk
Subject: pulling wrong dates from database


I have an SQL database with several tables in it. The Events table is the
main one and contains the primary key ID and is an AutoNumber; it is related
to each of the other tables: Dates, Internet, Intranet, PPrint which all
contain their own ID field and contain the fields BeginDate and EndDate. All
relationships are set up as  one-to-many.

When I access the form for an event, all the beginning and ending dates on
the form are the same. I can't figure out what the problem with my code is.
Hopefully, someone can tell me what I've done wrong here.

/snip
  _
Signup for the Fusion Authority news alert and keep up with the latest news
in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: pulling wrong dates from database

2002-04-18 Thread Judy

Andrew,

I originally had it that way, not referring to each BeginDate with it's
table name - that's what I thought the problem was to begin with, that I
needed to include the tablename.BeginDate, but that didn't help.

Each set of dates could be different and are going into different tables;
i.e. the dates we print an event description in the paper could be different
than the dates we want to advertise the event on the internet.

Judy

- Original Message -
From: Trusz, Andrew [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 18, 2002 11:59 AM
Subject: RE: pulling wrong dates from database


 Won't  --#DateFormat(GetEventtoUpdate.BeginDate, mm/dd/)#-- pick
up
 the same date variable each time it is used? As opposed to
 #DateFormat(GetEventtoUpdate.Internet.BeginDate, mm/dd/)#, for
 example.


 snip
 -Original Message-
 From: Judy [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, April 18, 2002 11:10 AM
 To: CF-Talk
 Subject: pulling wrong dates from database


 I have an SQL database with several tables in it. The Events table is the
 main one and contains the primary key ID and is an AutoNumber; it is
related
 to each of the other tables: Dates, Internet, Intranet, PPrint which all
 contain their own ID field and contain the fields BeginDate and EndDate.
All
 relationships are set up as  one-to-many.

 When I access the form for an event, all the beginning and ending dates on
 the form are the same. I can't figure out what the problem with my code
is.
 Hopefully, someone can tell me what I've done wrong here.

 /snip
   _
 Signup for the Fusion Authority news alert and keep up with the latest
news
 in ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
 
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists