Tags → If Sql Statement

MySQL to CSV Download

Extracts data from MySQL. Uses a MySQL table name or SQL statement to determine what data to extract. Formats the data into comma-delimited format, csv. Automatically translates invalid characters, such as &" to valid characters. Quotes col...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Sun Solaris
• Licenses
  • Commercial License

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

SQLView (DotNetNuke Module)

Features include: - specify sql query as a select from a table, view or stored procedure - sorting ascending/descending on each column - customizable formatting for the grid, header row, even row and odd row - display an additional header ...

• Categories
  • ASP.NET →
  • Software
• Platforms
  • Windows
• Licenses
  • Freeware

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