Darren, Datacasting is possible with dynamic queries by inserting a "dummy row" as the first row... As far as I am aware, ColdFusion MX looks at the first row to learn the data types. Perhaps you could create a new dynamic query and populate it with the verity query, where the first (dummy) row contains all of columns defined as integers.
E.g. QuerySetCell(qData, "Column1" , 0); QuerySetCell(qData, "Column2" , 0); QuerySetCell(qData, "RecordType" , "dummy"); You would of course need to filter out the dummy row, but this should work. Darryl http://dangermoose.blogspot.com [EMAIL PROTECTED] wrote on 22/03/2005 04:24:55 PM: > 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/ To unsubscribe from this email please forward this email to [EMAIL PROTECTED] This email message is confidential and may be privileged. If you are not the intended recipient please forward the email to [EMAIL PROTECTED] and delete the original. ABN AMRO Morgans Limited and its associates hold or may hold securities in the companies/trusts mentioned herein. Any general advice included in this email has been prepared without taking into account your objectives, financial situation or needs. Before acting on the advice, you should consider its appropriateness or discuss with one of our investment advisors. ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant of ASX Group. A principal member of the Financial Planning Association. --- 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/
