Got this reply from the guy the original question came from: Nailed it!! I was thinking only one way, i.e. trying to convert the string from the collection to an int to match the result from the SQL query. If I converted the int in the SQL to a string, the QofQ works. Can you pass on my thanks to Chad.
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 > -----Original Message----- > From: Chad > Sent: Tuesday, 22 March 2005 4:52 PM > To: CFAussie Mailing List > Subject: [cfaussie] RE: QofQ data casting > > 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/ --- 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/
