SQL to Front Page 2003

[hrider1]

Could someone give me the name of a good book that would help me when I
am building taking SQL queries and moveing them in to Frontpage 2003 as an
“ASP†pages? I am not sure of what types of changes need to be done with SQL
statements.

Thanks,
Jim

PS: Also any good web site for help.

 

[Stefan B Rusynko]

You could try here
http://www.w3schools.com/sql/default.asp

--

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


| Could someone give me the name of a good book that would help me when I
| am building taking SQL queries and moveing them in to Frontpage 2003 as an
| “ASP†pages? I am not sure of what types of changes need to be done with SQL
| statements.
|
| Thanks,
| Jim
|
| PS: Also any good web site for help.

 

[hrider1]

Thank you for the link, but any site that help when it come to working with
between dates? And moving the SQL to an ASP page?

 

[Jens Peter Karlsen [FP-MVP]]

SQL is SQL doesn't matter if it is in an ASP page or not.
Moving it is a simple matter of cut and paste.
Dates on the other hand is hard to work with because there are so many
different ways to write them.
The simplest approach is to have separate dropdowns for day, month and
year. That way you know exactly what format you get the date in so it
is easy to convert to DATETIME for storage in the database.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

Thank you for the link, but any site that help when it come to working with
between dates? And moving the SQL to an ASP page?

You could try here
http://www.w3schools.com/sql/default.asp

--

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


| Could someone give me the name of a good book that would help me when I
| am building taking SQL queries and moveing them in to Frontpage 2003 as an
| “ASP� pages? I am not sure of what types of changes need to be done with SQL
| statements.
|
| Thanks,
| Jim
|
| PS: Also any good web site for help.

 

[Stefan B Rusynko]

Post your current SQL date comparison statement

--

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


| Thank you for the link, but any site that help when it come to working with
| between dates? And moving the SQL to an ASP page?
|
| "Stefan B Rusynko" wrote:
|
| > You could try here
| > http://www.w3schools.com/sql/default.asp
| >
| > --
| >
| > _____________________________________________
| > 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
| > _____________________________________________
| >
| >
| > | > | Could someone give me the name of a good book that would help me when I
| > | am building taking SQL queries and moveing them in to Frontpage 2003 as an
| > | “ASP†pages? I am not sure of what types of changes need to be done with SQL
| > | statements.
| > |
| > | Thanks,
| > | Jim
| > |
| > | PS: Also any good web site for help.
| >
| >
| >