Someone will probably have a more thorough answer, but I have run into problems with any hints at conversion or calculations in Q of Q. If at all possible, I would convert your string to an integer (or visa versa) in the original query to compare in your Q of Q. I had to explicitly extract the Year, Month and Day from my date in my original query to compare, as running the same extraction bailed my Q of Q.
Chad -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of TRACEY, Darren Sent: Tuesday, 22 March 2005 5:25 PM To: CFAussie Mailing List Subject: [cfaussie] QofQ data casting We've got a problem with Query of Queries. We need to compare 2 values. One is an integer and comes from an MS SQL query and the other is a string that is returned from a verity quiery, that was put in as an integer but is being returned as a string. QofQ throws an error. How do you cast the string out of Verity as an integer so that QofQ can compare it to an integer? Or is there some other way to be doing this? Regards Darren Tracey Systems Analyst HR Systems and FastTrack, Web and Integration Services p: + 61 7 3232 4091 (x64091) f: + 61 7 3232 4744 e: [EMAIL PROTECTED] l: Lvl 3, 388 Queen St Brisbane QLD 4000 m: Suncorp IPC IT048, GPO Box 1453, Brisbane QLD 4000 ------------------------------------------------------------------------ ----------- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities "Suncorp". Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 13 11 55 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
