I had a query of data that needed to be flipped around (Columns as Rows and Rows as Columns). I had a little bit of trouble figuring out the loops so I wanted to share what Paul Kukiel showed me. Paul's Blog is located here: http://blog.kukiel.net/
So to fully explain the problem I have included 2 tables below. The first table is the output of the data that needs to be rotated and the second is the rotated data.
Here is my first MangBlog plugin called feedMe. It is pretty simple being my first plugin. It just allows for a rss feed to be added to the sidebar. You can find instructions on how to install in the readme.txt file or go to the MangBlog homepage.
**This only works on a PodEnabled them**
Let me know if you have any comments or suggestions ;)
This problem has caused me so much pain from hitting my head into a wall... After many-a-moons trying to figure this little problem out I have finally figured out the answer. The following blog posts provided so much useful information and should be looked at if you want further explanation:
CrankyBit - http://blog.crankybit.com/flex-remoting-over-ssl/
BarneyBlog - http://barneyb.com/barneyblog/2007/09/01/flex2-and-3-remoteobjects-over-ssl-with-coldfusion/
So I ran into a little problem with some of my SQL between statements this last week. The new year was causing no data to be shown in some data grids and graphs but only if the between statement included data from 2008. Here is my old between statement and after I will show the fix. It is pretty simple but maybe it will be helpful to someone else.
DOES NOT WORK!!!
| WHERE CONVERT(VARCHAR(10), date, 101) BETWEEN CONVERT(VARCHAR(10), #DateField1#, 101) AND CONVERT(VARCHAR(10), #DateField2#, 101) |
NEW BETWEEN STATEMENT THAT WORKS
| WHERE date BETWEEN CONVERT(VARCHAR(10), #DateField1#, 101) AND CONVERT(VARCHAR(10), #DateField2#, 101) |
For some reason the first CONVERT statement did not like having the range between two different years. Hope this saves someone a couple minutes ;)
MySQL has a really helpful LIMIT feature that allows you to return a specific amount of rows from a query.
SQL Server 2005 doesn't have the LIMIT clause, but there are a few other functions that can be used instead.
First there's the SET ROW COUNT which allows you to specify the number of rows to return. The code below will return 7 Records:
"font-size: 10pt;">SET ROWCOUNT 7
SELECT *
FROM tblMyTable
ORDER BY MyDate
Recent Comments