Wow! You mean I actually got one right! Great. Now I can't get out of the office... my head's too big.
Chad who suffers from forum-post envy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of TRACEY, Darren Sent: Wednesday, 23 March 2005 12:55 PM To: CFAussie Mailing List Subject: [cfaussie] RE: QofQ data casting 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/ --- 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/
