I wonder if the string function javacast(type,variable) is any good here?
just a guess...haven't needed to do much with QoQ myself... cheers barry.b > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of TRACEY, > Darren > Sent: Tuesday, 22 March 2005 4: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/
