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/yyyy")#"-- pick up > the same date variable each time it is used? As opposed to > "#DateFormat(GetEventtoUpdate.Internet.BeginDate, "mm/dd/yyyy")#", 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