Tags → Function In Sql

Getdataarray

A function which returns an array containing data specified in an SQL statement using GetRows. Includes measures to help combat SQL injection.

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Linux
• 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

txtSQL

txtSQL (pronounced &"text-sequel&") is a class containing a variety of functions designed to mimic a database system, using only regular text files. It is object-oriented and can be looked at as sort of a framework in creating large...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux,
  • Windows,
  • FreeBSD,
  • Mac OSX,
  • Sun Solaris
• Licenses
  • GPL

Buy and Sell

Have your visitors buy and sell through your site. In less then 5 minutes you have this complete function running at your site, It''s totally ready to go. It uses access 2000 database, dynamic dropdown boxes, ability to search products, advanced...

• Categories
  • ASP →
  • Scripts and Components →
  • E-Commerce →
  • Shopping Carts
• Platforms
  • Linux
• Licenses
  • Freeware

Easy Result Browser

This function returns an array of 3 values that makes browsing through your SQL results, or any other list of results, very easy. The navigation bar looks very similar to ones used in most sites [ &<&<6 7 8 9 10&>&...

• Categories
  • PHP →
  • Scripts and Programs →
  • Database Tools
• Platforms
  • Linux
• Licenses
  • Freeware

Formatting Date/Time value in SQL query

Learn how to use MySQL embedded function to format Date/Time field value just right in the SQL query string. For example another way is to use PHP, but it is slower and inconvenient. This tutorial will show you both examples for the same goal.

• Categories
  • PHP →
  • Tips and Tutorials →
  • Database-Related
• Platforms
  • Linux
• Licenses
  • Freeware

SPROC Function Builder

SPROC Function Builder is a really handy windows app designed to take the backache out of writing functions to access SQL Server stored procedures. Written in .NET this application is small, easy to use and very effective. It is not limited to any ...

• Categories
  • ASP →
  • Software
• Platforms
  • Linux
• Licenses
  • Freeware

access2asp

access2asp is a conversion tool for access databases that converts your db to clean, commented pro asp /asp.net code. It produces a ''front end'' and an ''admin'' section with ability to view,search,add, edit and delete. Also prod...

• Categories
  • ASP →
  • Scripts and Components →
  • Database Tools
• Platforms
  • Windows
• Licenses
  • Commercial License

Top 21 PHP Programming Mistakes - Part 2: Seven Serious Mistakes

In this second part of the series, it describes 7 common mistakes in PHP programming that will lead to drastically slower run times and less secure scripts, in addition to less maintainable code. Topics covered: Not Following Basic Naming Conventions...

• Categories
  • PHP →
  • Tips and Tutorials →
  • Development
• Platforms
  • Linux
• Licenses
  • Freeware

Page:

• 1
• 2
• Next