 
| Sender: |
|
| Date: |
Fri, 6 Aug 2010 18:49:24 -0400 |
| Reply-To: |
|
| Subject: |
|
| MIME-Version: |
1.0 |
| Content-Transfer-Encoding: |
quoted-printable |
| In-Reply-To: |
|
| Content-Type: |
text/plain; charset="iso-8859-1" |
| From: |
|
| Parts/Attachments: |
|
|
Yes, it does.
You might be able to get away with making it
totext(tonumber({ExhObjXRefs.CaseNumber}));
Jeri
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Chad Petrovay
Sent: Friday, August 06, 2010 6:48 PM
To: [log in to unmask]
Subject: Re: tonumber trouble
Doesn't "tonumber" return a numeric value instead of a string?
Chad Petrovay | Collections Database Administrator
MIM-Musical Instrument Museum | 4725 E. Mayo Boulevard | Phoenix, AZ 85050
480.478.6000 main | 480.478.6058 direct | 480.471.8690 fax | www.themim.org
Blog: www.petrovay.com/tmsblog
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]] On Behalf Of Stephanie Hansen
Sent: Friday, August 06, 2010 3:38 PM
To: [log in to unmask]
Subject: tonumber trouble
Hello,
Hoping one of you crystal gurus out there knows what I'm doing wrong. I keep
getting the error "a string is required here" when I try to turn the string
casenumber into a number so it will sort correctly.
SELECT{?group}
CASE 'LENDER' :{Constituents.AlphaSort}
CASE 'SECTION':{ExhObjXRefs.Section}
CASE'CHECK#': tonumber({ExhObjXRefs.CaseNumber});
Thanks in advance for any help!
Stephanie Hansen
Milwaukee Art Museum
|
|
|
