Kathleen,
This one works, two sorts but no filter
SELECT CourseEvents.CEV, Courses.Filière, CourseEvents.CCode,
Format([CourseEvents].[Date],'dd\.mm\.yyyy') AS NewDate,
CourseEvents.Time,
Courses.DT, CourseEvents.Lieu, Courses.CTitle, Courses.Niveau,
Courses.CDescrVis, Courses.PProfileVis, Courses.PlAv,
QueryCountParticipants.CountOfCEN AS CEN, [PlAv]-[CountOfCEN] AS Free
FROM Courses INNER JOIN (QueryCountParticipants RIGHT JOIN CourseEvents ON
QueryCountParticipants.CEN = CourseEvents.CEV) ON Courses.CCode =
CourseEvents.CCode
ORDER BY CourseEvents.CEV, CourseEvents.Date;
This one doesn't (see error message at the end, after publishing), all
I
have added is the statement WHERE CourseEvents.Lieu=Bern, note the field
"Lieu" is not displayed in the Results zone
SELECT CourseEvents.CEV, Courses.Filière, CourseEvents.CCode,
Format([CourseEvents].[Date],'dd\.mm\.yyyy') AS NewDate,
CourseEvents.Time,
Courses.DT, CourseEvents.Lieu, Courses.CTitle, Courses.Niveau,
Courses.CDescrVis, Courses.PProfileVis, Courses.PlAv,
QueryCountParticipants.CountOfCEN AS CEN, [PlAv]-[CountOfCEN] AS Free
FROM Courses INNER JOIN (QueryCountParticipants RIGHT JOIN CourseEvents ON
QueryCountParticipants.CEN = CourseEvents.CEV) ON Courses.CCode =
CourseEvents.CCode
WHERE CourseEvents.Lieu=Bern
ORDER BY CourseEvents.CEV, CourseEvents.Date;
Error message
Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers
in
message What does your SQL look like?
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
Hi again Kathleen,
So, I have pasted the SQL statement with your formatting commands
(spiderwebwoman) and for the first time after fighting with this thing,
I
have succeeded in displaying the date column the European way. See
link,
here below (entitled Expr1) - Thank you very much!
http://www.rikki-tikki-tavi.com/cataloguelosinger/displayform.asp
However, I require a filter! I have tried several ways; as soon as I
paste
the SQL code with a filter, in my case "location=Geneva", the database
connection gets broken. And, of course, one cannot use "More
Options"
in
the
Database Result Wizard when using Custom Query.
What I don't understand is that there must be thousands of people in
Europe
wanting to do this simple thing of displaying a date in different
formats.
Microsoft must have thought of this?
Anyway, thank you very much for your help. I am in trouble because I
have
promised this application to a customer but I cannot possibly supply it
with
American dates. Nobody works with them here. Why should this be so
difficult...
All the best to you, Doris
"Kathleen Anderson [MVP - FrontPage]" <
[email protected]>
wrote
in
message If you are just displaying the date - not using it as criteria -
you
could
reformat it in your SELECT statement - see:
http://www.spiderwebwoman.com/tutorials/working_with_dates.htm
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
Hello again,
I have opened the page that displays the date (only one). I do
not
have
the
code
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component.
Do
not
Edit.
FP_LCID = 1033 %>
on the page you mention. I obtained the display of data via the
command
Insert/Database Results. I have looked everywhere for a possibility
to
change the date format. Can't see anything.
The FrontPage generated code I have, has not been tampered with
by
me.
What should I do, do you think? Doris
After thinking about it I don't think it will help to change the
LCID
when
using the DBRW
The DBRW by default appears to resets the LCID in each page to 1033
w/
the
code it adds as
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component.
Do
not Edit.
FP_LCID = 1033 %>
--
_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________
| Try setting the LCID on each page where you display a date or
currency
value.
|
| <%
| Session.LCID = 2055
| %>
|
| --
| ==============================================
| Thomas A. Rowe (Microsoft MVP - FrontPage)
| ==============================================
| If you feel your current issue is a results of installing
| a Service Pack or security update, please contact
| Microsoft Product Support Services:
|
http://support.microsoft.com
| If the problem can be shown to have been caused by a
| security update, then there is usually no charge for the call.
| ==============================================
|
| | > Thanks for coming back so quickly. Done what you suggested. The
global.asa
| > still works! but the months are still in US format. Any ideas?
Regards,
| > Doris
| >
| >
| > | >> The global.asa generated by FP already has a Session_OnStart,
usually
as
| >>
| >> Sub Session_OnStart
| >> FrontPage_StartSession '==FrontPage Generated==
| >> FrontPage_ConvertFromODBC '==FrontPage Generated==
| >> End Sub
| >>
| >> So you can't add another one
| >>
| >> But you could try editing it to be
| >>
| >> Sub Session_OnStart
| >> Session.LCID=2055
| >> FrontPage_StartSession '==FrontPage Generated==
| >> FrontPage_ConvertFromODBC '==FrontPage Generated==
| >> End Sub
| >>
| >> --
| >>
| >> _____________________________________________
| >> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >> "Warning - Using the F1 Key will not break anything!" (-;
| >> To find the best Newsgroup for FrontPage support see:
| >>
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
| >> _____________________________________________
| >>
| >>
message
| > | >> | Hello,
| >> | I am running FP2000 .asp pages with MS Office 2000 Access
database.
| >> | Everything works fine with the exception of the Date
field
which
comes
| > out
| >> | in US rather than European format. See this link
| >> |
http://www.rikki-tikki-tavi.com/cataloguelosinger/displayform.asp
| >> |
| >> | I upload the whole thing to a service provider (with
FrontPage
| > extensions)
| >> |
| >> | My Control Panel settings are European. From having
looked
around,
I
| > think
| >> | its global.asa that needs to be configured. Am I right?
| >> |
| >> | The service provider publishes some code on his webpage but
as
soon
as I
| >> | touch global.asa and upload, the database connection is
no
longer
valid.
| >> | Could you help? Thanks very much.
| >> | Doris
| >> |
| >> | proposed script
| >> | <SCRIPT LANGUAGE=VBScript RUNAT=Server>
| >> | Sub Session_OnStart
| >> | Session.LCID=2055
| >> | End Sub
| >> | </SCRIPT>
| >> |
| >> |
| >>
| >>
| >
| >
|
|
Thanks!