Database Results

[Stephen Corcoran]

All,
I'm trying to use the 'GetDate()' string to search for events within a
database. Each time I try to enter it, frontpage automatically generates
quotes around it, causing an error. Is there anyway to enter this in the
database results wizard without frontpage putting quotes around it?

thanks.

steve

 

[Stefan B Rusynko]

What 'GetDate()' string?
- is it an ASP function?
Where in the DBRW?

--

_____________________________________________
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
_____________________________________________


| All,
| I'm trying to use the 'GetDate()' string to search for events within a
| database. Each time I try to enter it, frontpage automatically generates
| quotes around it, causing an error. Is there anyway to enter this in the
| database results wizard without frontpage putting quotes around it?
|
| thanks.
|
| steve
|
|

 

[Stephen Corcoran]

In frontpage, you click on insert, database, results.. when I add criteria
to display data, i want to add the GetDate() function (it's a sql query
function).. but when i add that, it puts quotes around it. I can delete the
quotes in the code, but frontpage puts them back. Is there a better way to
do it?

What i'm trying to do is display a list of events in the future.. any past
results wouldnt show up. Is there another way?

thanks.

 

[Kathleen Anderson [MVP - FrontPage]]

SELECT * FROM calendar WHERE (event_date>Date());

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

In frontpage, you click on insert, database, results.. when I add criteria
to display data, i want to add the GetDate() function (it's a sql query
function).. but when i add that, it puts quotes around it. I can delete
the quotes in the code, but frontpage puts them back. Is there a better
way to do it?

What i'm trying to do is display a list of events in the future.. any past
results wouldnt show up. Is there another way?

thanks.

What 'GetDate()' string?
- is it an ASP function?
Where in the DBRW?

--

_____________________________________________
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
_____________________________________________


| All,
| I'm trying to use the 'GetDate()' string to search for events within a
| database. Each time I try to enter it, frontpage automatically
generates
| quotes around it, causing an error. Is there anyway to enter this in
the
| database results wizard without frontpage putting quotes around it?
|
| thanks.
|
| steve
|
|

 

[Stephen Corcoran]

Thanks.. but is there a way to do it within the frontpage database wizard?
(I'm trying to teach non-tech people to do this).

thanks.

SELECT * FROM calendar WHERE (event_date>Date());

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

In frontpage, you click on insert, database, results.. when I add
criteria to display data, i want to add the GetDate() function (it's a
sql query function).. but when i add that, it puts quotes around it. I
can delete the quotes in the code, but frontpage puts them back. Is there
a better way to do it?

What i'm trying to do is display a list of events in the future.. any
past results wouldnt show up. Is there another way?

thanks.

What 'GetDate()' string?
- is it an ASP function?
Where in the DBRW?

--

_____________________________________________
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
_____________________________________________


| All,
| I'm trying to use the 'GetDate()' string to search for events within a
| database. Each time I try to enter it, frontpage automatically
generates
| quotes around it, causing an error. Is there anyway to enter this in
the
| database results wizard without frontpage putting quotes around it?
|
| thanks.
|
| steve
|
|

 

[Kathleen Anderson [MVP - FrontPage]]

Yes. Select Custom Query in the wizard and paste your SQL into the dialog
box.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

Thanks.. but is there a way to do it within the frontpage database wizard?
(I'm trying to teach non-tech people to do this).

thanks.

SELECT * FROM calendar WHERE (event_date>Date());

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

In frontpage, you click on insert, database, results.. when I add
criteria to display data, i want to add the GetDate() function (it's a
sql query function).. but when i add that, it puts quotes around it. I
can delete the quotes in the code, but frontpage puts them back. Is
there a better way to do it?

What i'm trying to do is display a list of events in the future.. any
past results wouldnt show up. Is there another way?

thanks.


What 'GetDate()' string?
- is it an ASP function?
Where in the DBRW?

--

_____________________________________________
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
_____________________________________________


| All,
| I'm trying to use the 'GetDate()' string to search for events within
a
| database. Each time I try to enter it, frontpage automatically
generates
| quotes around it, causing an error. Is there anyway to enter this in
the
| database results wizard without frontpage putting quotes around it?
|
| thanks.
|
| steve
|
|