We use Oracle here too..
instead of CAST()
use to_number()
select * from foo
where goo = to_number('#MyVar#')
On 3/20/07, Bryan Stevenson <[EMAIL PROTECTED]> wrote:
> > What DB are you using?
>
> Oracle....9i I beleive
>
> Bryan Stevenson B.Comm.
> VP & Director of E-Commerce Development
> Electric Edge Systems Group Inc.
> phone: 250.480.0642
> fax: 250.480.1264
> cell: 250.920.8830
> e-mail: [EMAIL PROTECTED]
> web: www.electricedgesystems.com
>
> Notice:
> This message, including any attachments, is confidential and may contain
> information that is privileged or exempt from disclosure. It is intended
> only for the person to whom it is addressed unless expressly authorized
> otherwise by the sender. If you are not an authorized recipient, please
> notify the sender immediately and permanently destroy all copies of this
> message and attachments.
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:273126
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
