This topic is locked

Time display errors

9/24/2005 13:16:33
ASPRunnerPro General questions
author

I'm using a dropdown/lookup to insert time values into table. This is the error I keep getting: "Multiple-step operation generated errors. Check each status value."
Any ideas? The format looks fine in the dropdown, but it crashes when I try to save the record.
Thanks!

Sergey Kornilov admin 9/24/2005

What is the dtabase field type and what time value causes this problem?

500321 9/24/2005

I've tried every kind of format setting I can think of. what about something like this?
Select [EventID],

[Title],

[Date],

[Depart Time],

[Event Start],

[Length],

[EventType],

[Location],

[Driver],

[Sponsor],

[Sponsor Homepage],

[Topics],

[Audience Attendees],

[Notes],

[Contact],

[ContactPhone],

[PhoneType],

[ContactEmail],

[OtherContact],

[OtherContactPhone],

[OtherPhoneType],

[Directions],

[MapLink],

Format Date, 'DDDD, MMM DD, YYYY' as fDate,

Format Depart Time, 'H:MM AM/PM' as Depart Time2,

Format Event Start, 'H:MM AM/PM' as Start

From [six_events2]

Sergey Kornilov admin 9/25/2005

How this SQL query relates to lookup wizard issue?