A juggling technophile shares personal stories, challenges, humor and perhaps some political commentary.
So are you pulling your hair out because your query of queries is returning an error "Query Of Queries runtime error."? The solution is rather simple. In your query that is feeding your QoQ, you probably have a column that is of datatype nchar. Cast that to a varchar and life will be good. Do the cast in the source query not the QoQ. eg. "CAST(foo AS varchar) AS bar" You’re welcome.
p.s. Yes, you can cast it to the same column name eg. "CAST(foo as varchar) AS bar" Case doesn’t matter.
I am loving working with jqGrid. My latest discovery is the ease at which elements on the grid can be changed. For instance, if you want to change the default "View 1 – 10 of 98" you can do it in either the language file or simply by adding a parameter to the grid:
recordtext: "View {0} – {1} of {2} addwhateveryourwant",
Me: "Noah, do you want to go to your aunt’s wedding?"
Noah, 16: "Uh, I don’t think so."
Me: "Ok. You’ll miss out on going to King’s Island."
Noah: "Why King’s Island?"
Me: "They live there."
Noah: "They do?"
Me: "Yes. You’ve been there."
Noah: "Once!"
Dad fail! Perhaps I have been a bit remiss in traveling my children. I’m thinking it’s time to plan a vacation.
