popular collection of scripts for all

• Categories
• Tags

WiredNow.net: SQL Reserved Words Hits: 15 ***** 0.0 jOmniGate Hits: 9 ***** 0.0 Create a Fully Functional, Multifeatured ASP Shopping Basket Hits: 12 ***** 0.0 DB_Browser Hits: 14 ***** 0.0 It is an often problem with jOmniGate is an O/R-mapper This article explains how to DB_Browser is a CGI tool for database intergration when for timespending and design and program a developers working with a you use a reserved word. reusable development of multifunctional shopping relational database. It Often asked why a script databased applications cart application using easily facilitates does not work and it quite without using sql or SQL Server, ASP, and searching, editing, and often comes down the the any database-specific ODBC. Source code available adding tables within a author setting a field name language. By using for download. database, as well as as a reserved word, jOmniGate-api your programs   directly querying the confusing SQL and will run without any changes   database using SQL in making debugging hard. To the same with MySql,   a web-browser form. While it solve this problem here is a Oracle, interbase and   can be used as a regular quick list of the SQL others. jOmniGate supports   interface to database data Reserved Words. automatic table-creation and   itself, it works well as a   -update, automatic mapping   supplemental tool for   between java-classes and   developers creating their   db-tables and much more.   own primary interface. Date: Aug, 28 2003 Date: Sep, 20 2001 Date: Apr, 13 2001 Date: Dec, 04 2000

Top 21 PHP Programming Mistakes - Part 2: Seven Serious Mistakes Hits: 9 ***** 0.0 Insert Using SQL Hits: 14 ***** 0.0 Adding Site Registration using SQL Server and ASP Hits: 13 ***** 0.0 Short guide to DBI Hits: 16 ***** 0.0 In this second part of the This short tutorial One of the most powerful Here's how to get started series, it describes 7 demonstrates how to insert enhancements for any site is using SQL and common mistakes in PHP data into a SQL database to establish community and SQL-driven databases from programming that will lead using SQL statements. personalization features. In Perl. Main topics include: to drastically slower run   our new series, we are going General information about times and less secure   to demonstrate how to add relational databases, About scripts, in addition to less   community and SQL, What DBI is For, maintainable code. Topics   personalization features to Example of How to Use DBI, covered: Not Following Basic   your web-site. The first Cached Queries, and Naming Conventions (Variable   step to reach this goal is Transactions. Naming, Function Naming),   to allow user registration.   Databases & SQL   In this first article, we   (Misapplying database   show you how to add user   functions, Misusing   registration to your site   SQL: Not Fetching What   using SQL Server and   You Need, Misusing   ASP.   SQL: Not Fetching What       You Need), Lack of Error       Checking, Overusing OO,       Misusing Regular       Expressions, Programming PHP       Like It Was Some Other       Language, and Not Being       Security Conscious (System       Call Security, Checking an       e-mail address).       Date: Oct, 21 2000 Date: Oct, 13 2000 Date: Aug, 11 2000 Date: May, 12 2000