I am not sure if this ever made it to the list because I didn't recieve it back myself so here is the repost:
I am having trouble with a query of query. Is there a known issue with 0 values in query of queries?
I have a result set called getShipping that produces the following result set:
getShipping result set
==============================
18|0|Free Shipping
19|15|2nd Day Air
20|20|3 Day Select
22|25|Next Day Air
Note: 18|0|Free Shipping, the 0 is the value for shipping.
Then I try to run the following query of queries (without ANY other code in between)
SELECT code,rate,description FROM getShipping
And here is it's result set: (Note the 18//Free Shipping the 0 is now gone. I could write some code to look for the "" and then replace it with a 0 but that seems hacked and wanted to know if I am missing something.
Shipping query of queries result set:
====================================
18//Free Shipping
19/15/2nd Day Air
20/20/3 Day Select
22/25/Next Day Air
Paul Giesenhagen
QuillDesign
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]