When we work with date and/or time values in MySQL, it’s always easy to use built-in MySQL functions such as NOW(), DATE_ADD(), TIMESTAMP() etc… Now imagine you have to pass date/time values to MySQL from PHP variables. First time I tried that, it didn’t work out so easy for me. Yes, if you simply take […]
Author: kubilay
T-SQL: Concatenate Multiple Rows of a Column into One Cell
Simple: You have a column and you want to take all rows as one cell. So that you can do searching, ordering, whatever you like. Solution: Declare a variable, in this case VARCHAR or NVARCHAR, then SELECT the variable by equaling [itself] plus [column name] plus [your seperation char]. Here’s the code snippet:
Asp.Net Server Side: How to get Iframe’s Parent Window Url?
In Asp.Net server sided button’s click event, I somehow needed to find parent window url of an iframe, which means the url you see in the address bar of your web browser. Let’s think of 2 pages: Parent.aspx and Child.aspx. Child.aspx is loading to an iframe in Parent.aspx. If you have a button in Child.aspx, […]