A PHP Error was encountered

Severity: 8192

Message: Methods with the same name as their class will not be constructors in a future version of PHP; Waterfall_Cache has a deprecated constructor

Filename: _common/waterfall_cache.php

Line Number: 47

A PHP Error was encountered

Severity: 8192

Message: Methods with the same name as their class will not be constructors in a future version of PHP; Cache_System has a deprecated constructor

Filename: _common/waterfall_cache.php

Line Number: 194

A PHP Error was encountered

Severity: 8192

Message: Methods with the same name as their class will not be constructors in a future version of PHP; Memcache_Cache_System has a deprecated constructor

Filename: _common/waterfall_cache.php

Line Number: 275

A PHP Error was encountered

Severity: 8192

Message: Methods with the same name as their class will not be constructors in a future version of PHP; Filesystem_Cache_System has a deprecated constructor

Filename: _common/waterfall_cache.php

Line Number: 440

A PHP Error was encountered

Severity: 8192

Message: Methods with the same name as their class will not be constructors in a future version of PHP; APC_Cache_System has a deprecated constructor

Filename: _common/waterfall_cache.php

Line Number: 628

Quotes in SQL (Those Darn Things!) Page 2

Quotes in SQL (Those Darn Things!) Page 2


Download the authoritative guide: Data Center Guide: Optimizing Your Data Center Strategy

Download the authoritative guide: Cloud Computing: Using the Cloud for Competitive Advantage

Watkins
corner.jpg (739 bytes) Quotes in SQL (Those Darn Things!) corner2.jpg (786 bytes)

Back to the article: Click here

Please enter a string that contains single quotes in the text box below. Normal output will display the string without the function described on the previous page. Modified output runs the string through the function and adds single quotes as needed.



Dim strQuery
Dim strTextBox
strTextBox = request.form("strTown")
strQuery = "SELECT * FROM table WHERE town='" & strQuery & "';"


OUTPUT: <%=strOutput%>

This article was originally published on Aug 10, 1999
Page 2 of 2

Thanks for your registration, follow us on our social networks to keep up-to-date