Now of course if anyone knows how to do this in straight SQL I would appreciate that also.
Bob
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Ok here is what I'm trying to do. I have a query that sometimes there aren't enought records passed through. So I figured I would make some code that would create a query with my own recordset to put a value of 0 for the missed records so that it will match up with another display. Then afterwards I wanted to use query of query to union the 2 queries so then there will be one query with the right amount of records. The issue I have is that java tells me there is no way to combin them because they are of the wrong value. I manually filled in everything myself so that the values were exactly the same as the displayed query, but I can't cast anything in coldfusion so how do I fix this?
Now of course if anyone knows how to do this in straight SQL I would appreciate that also.
Bob
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
![]()
Now of course if anyone knows how to do this in straight SQL I would appreciate that also.
Bob
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
