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.
>
>
>
> -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.
>
>
> _
> 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