Tweet
As I can see from the stats, visits to The Web Thought have increased quite a lot lately. Despite the fact that almost nobody leaves comment to my articles, I would like to introduce polls. I don't know if you like polls - I usually don't - however, please help me to understand what are the most interesting topics you would like to see in this blog.
So please, cast your vote, using the panel on the right!
Web development, web design and programming.
Wednesday, 16 February 2011
Monday, 14 February 2011
SQL Server: apostrophes in queries
Tweet
Apostrophes ( ' ) in queries might be a big problem. In fact, we usually build our queries without thinking about it, maybe because it's quite unusual to have data containing such strange characters. That leads to difficulties in isolating the cause of an error while executing a query statement, especially when the query worked for a year and then - suddenly - starts giving problems. It is quite common not to think about new data recently entered or updated, and usually we concentrate on the query statement and thus - let me say - waste a lot of time/money.
Apostrophes ( ' ) in queries might be a big problem. In fact, we usually build our queries without thinking about it, maybe because it's quite unusual to have data containing such strange characters. That leads to difficulties in isolating the cause of an error while executing a query statement, especially when the query worked for a year and then - suddenly - starts giving problems. It is quite common not to think about new data recently entered or updated, and usually we concentrate on the query statement and thus - let me say - waste a lot of time/money.
Friday, 11 February 2011
ASP: How to create custom filters for your tabular data
Tweet
Displaying data in a table is the most used and easiest way of publishing information for the user. It is quite common in web app and sites, that a query resulting recordset is displayed in a tabular form.
In this short article I will explain how to apply custom filters to the recordset, based on users requests. In order to show you how to do it, I need to explain a bit where to start. Our table could be something like:
The table could go on with all the products. We are going to create links inside the table to filter data.
Displaying data in a table is the most used and easiest way of publishing information for the user. It is quite common in web app and sites, that a query resulting recordset is displayed in a tabular form.
In this short article I will explain how to apply custom filters to the recordset, based on users requests. In order to show you how to do it, I need to explain a bit where to start. Our table could be something like:
| ID | PRODUCT FAMILY | DESCRIPTION | CODE | COLOUR | TYPE |
| 1 | Bottle | Glass bottle | 1234 | Green | Product |
| 2 | Box | Carton box | 5678 | Brown | Package |
Wednesday, 9 February 2011
ASP: Multilingual web sites (AddHeader, CodePage and CharSet)
Tweet
I've been working with multilingual web sites for a long time and - believe me - they sometimes are not so easy to manage. At the moment, one of the sites I manage, lets the user choose between 8 languages (including Cyrillic).
One of the issues you might have to face when dealing with languages, is how to manage charsets. I know there's a lot of talking about it, especially in relation to specific browsers and characters rendering. The only thing I remember is that it was a real pain! Being completely sure on how the web page was rendered seemed to be almost impossible.
I've been working with multilingual web sites for a long time and - believe me - they sometimes are not so easy to manage. At the moment, one of the sites I manage, lets the user choose between 8 languages (including Cyrillic).
One of the issues you might have to face when dealing with languages, is how to manage charsets. I know there's a lot of talking about it, especially in relation to specific browsers and characters rendering. The only thing I remember is that it was a real pain! Being completely sure on how the web page was rendered seemed to be almost impossible.
Monday, 7 February 2011
Check Browser Compatibility
Tweet
When creating a new web site, it is very important to check browser compatibility. Sometimes customers are not really aware of the implication of that issue, but as developers, we know how important is a good cross browser compatibility. It is undeniable that we cannot have every available browser installed on our testing server, not to say every single version. That is why we have to rely on an external tool in order to actually see how the highest number of browser will render our beautiful new web site.
I discovered a useful site to do it. And I would like to make you aware of it, so that you can use it to test your work.
When creating a new web site, it is very important to check browser compatibility. Sometimes customers are not really aware of the implication of that issue, but as developers, we know how important is a good cross browser compatibility. It is undeniable that we cannot have every available browser installed on our testing server, not to say every single version. That is why we have to rely on an external tool in order to actually see how the highest number of browser will render our beautiful new web site.
I discovered a useful site to do it. And I would like to make you aware of it, so that you can use it to test your work.
Friday, 4 February 2011
jQuery Tools: The missing UI library for the web
Tweet
Today I would like to share a incredibly rich site, where jQuery is used to create useful and ready made tools. The place is:
Today I would like to share a incredibly rich site, where jQuery is used to create useful and ready made tools. The place is:
Wednesday, 2 February 2011
SQL Server: Stored Procedures and variables problem
Tweet
In my last post I published a step-by-step guide to create Stored Procedures in SQL Server using SQL Server Management Studio.
There are some things I would like to add, because in my experience I sometimes got stuck with errors that - when solved - were so easy to pinpoint, while little information can be found in tech forums or generally in tech sites. Specifically there is a common problem with the @query variable and its length.
In my last post I published a step-by-step guide to create Stored Procedures in SQL Server using SQL Server Management Studio.
There are some things I would like to add, because in my experience I sometimes got stuck with errors that - when solved - were so easy to pinpoint, while little information can be found in tech forums or generally in tech sites. Specifically there is a common problem with the @query variable and its length.
Subscribe to:
Posts (Atom)