Tags → If Statement In Sql

MyPagina (pagination) class

The page navigation (pagination) of lists with records from a (MySQL) database is often used on a lot of dynamic websites. This class is extremely easy to use in your existing application: just use your own SQL statement and voila you get information...

• Categories
  • PHP →
  • Scripts and Programs →
  • Site Navigation
• Platforms
  • Linux,
  • Windows
• Licenses
  • BSD Style

PositionInQuotes

The PositionInQuotes function returns true or false depending on whether the position in the string you pass into it is between a pair of apostrophes or not. Useful if you''re doing any sort of SQL statement validation etc

• Categories
  • ASP →
  • Scripts and Components →
  • Miscellaneous
• Platforms
  • Linux
• Licenses
  • Freeware

Returning Month of Date in an SQL Table

This is an useful but not known functions. If you wish to learn month of date stored in a database, you may use this function placing in a ''SELECT'' sql statement

• Categories
  • ASP →
  • Tips and Tutorials →
  • Date and Time
• Platforms
  • Linux
• Licenses
  • Freeware

SQL Server Manager

If your database server running Microsoft SQL Server 6.5 is somewhere on the Net, you can t use the Enterprise Manager or ISQL/w (if it is located behind a firewall, as in most cases). Its web interface presented allows you to administer SQL Server v...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware