Rich,
You are right on the money - it's the UPPER function. I have access to SQL 7
and Oracle 8i, how do I go about transferring the acccess db to one of them?
Also, is there a way to use SQL or ORacle instead of the sybase database for
spectra?
Hassan Khawaja
Web Applications Developer
[EMAIL PROTECTED]
----- Original Message -----
From: "Richard Ragan" <[EMAIL PROTECTED]>
To: "Spectra-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 11, 2000 11:01 AM
Subject: Re: Getting Errors in Forta's new Spectra Book
> Most likely this is a complaint about the UPPER function. When the book
> was written Spectra ran OK on Access DB's by the time it actually
> published, Allaire no longer supported Access as a DB for Spectra.
> If this is your problem and you have access to some other DB, I
> would suggest using it. There are some workarounds/patches
> you can make to Spectra to get it to limp along on Access but
> that is not a preferred route.
>
> Cheers, Rich Ragan
>
> ----- Original Message -----
> From: Hassan Khawaja <[EMAIL PROTECTED]>
> To: Spectra-Talk <[EMAIL PROTECTED]>
> Sent: Monday, December 11, 2000 9:04 AM
> Subject: Getting Errors in Forta's new Spectra Book
>
>
> > Hello all,
> >
> > I installed Spectra just fine and started copying the files from Forta's
CD
> > in the book in their respective folders, as mentioned in the readme
file.
> > Moving on to creating the A2Z application, I chose A2Z datasource and
hit
> > ok, it gave me an error, something wrong with CFQUERY, I can't recall
> > exactly what (I'll post the exact error once I get back to the spectra
box).
> > The datasource was verified thru the CFadmin, so that couldnt be a
problem.
> >
> > Also the book mentions listing 6.3 (from memory, could be wrong on the
> > number) as the application.cfm file to initialize your app, but it was
> > entirely missing.
> >
> > Hassan Khawaja
> > Web Applications Developer
> > [EMAIL PROTECTED]
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
