Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged query

1 1450 posted 16 years ago by vagrantradio
1 1336 posted 16 years ago by PCurd
This method runs a SQL query and returns the first result (the query is expected to return exactly one record and one field).
0 1346 posted 16 years ago by CaptainProton
This method creates a query with a given name and given SQL. Note: Requires the deleteQuery(String) method.
0 1299 posted 16 years ago by CaptainProton
This method deletes a query with a given name. Note: Requires the queryExists(String) method.
0 1189 posted 16 years ago by CaptainProton
This method checks whether a query with the given name exists.
0 1294 posted 16 years ago by CaptainProton
0 1419 posted 16 years ago by wearetherock
0 1324 posted 16 years ago by fatihturan
If you need to list all of the MySQL databases managed by Plesk along with their corresponding domains and login credentials, you can use this query:
1 1639 posted 16 years ago by tobewan
Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.
1 1699 posted 16 years ago by BFTrick
0 1364 posted 16 years ago by gfazioli
Dead simple, but often forgotten.
1 1792 posted 16 years ago by rengber
3 1777 posted 16 years ago by nkm
This line can be added to 'backend', 'frontend', 'listen' directives in the HAProxy config. It will redirect all requests for /books/mysql to /books.php?title=mysql
0 2416 posted 16 years ago by alexwilliams
This will only work in FF 3.5 and web-kit browsers. (post 06/20/2009)
0 1436 posted 16 years ago by adamdecaf
0 1632 posted 16 years ago by iloveitaly
More of a setQueryString
0 1421 posted 16 years ago by iloveitaly
This is an example piece of code that will load a SubSonic collection into the "col1" object. The collection class is told to look for the column "VendorId" in the products table and pull it based based on the matching supplied vendorId.
0 1443 posted 17 years ago by mordecaix7
Magic quotes for incoming GET/POST/Cookie data. This feature has been DEPRECATED as of PHP 5.3.0 and REMOVED as of PHP 6.0.0. Relying on this feature is highly discouraged.
0 1457 posted 17 years ago by lzyy
1 1617 posted 17 years ago by apro2000
2 1409 posted 17 years ago by blubadger
This is sometimes not the best solution to a server caching your css files. But if you want to force a stubborn server to serve the most recent css file to the browser this seems to work. Could slow things down a touch, but for small css files not...
1 2087 posted 17 years ago by jadedbat