[thelist] Netscape Only error using CF and Oracle *

[Raymond K. Camden]

All ColdFusion does is pass the stuff (SQL) to your DB. ColdFusion doesn't
have a SQL engine it itself. (Actually, CF 5, which was announced at the Dev
Conf in early November, -will- have CFSQL, which will allow you to write a
query against an existing query.)

=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Allaire

Email   : jedimaster at allaire.com
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda


> -----Original Message-----
> From: thelist-admin at lists.evolt.org
> [mailto:thelist-admin at lists.evolt.org]On Behalf Of Herzog, Ari
> Sent: Monday, November 20, 2000 2:23 PM
> To: 'thelist at lists.evolt.org'
> Subject: RE: [thelist] Netscape Only error using CF and Oracle *
>
>
> Right, but if you are using a <cfquery></cfquery> tag,
> then you are using CF's SQL, and not Oracle's.
>
> Or no?
>
> -----Original Message-----
> From: Raymond K. Camden [mailto:rcamden at allaire.com]
> Sent: Monday, November 20, 2000 2:21 PM
> To: thelist at lists.evolt.org
> Subject: RE: [thelist] Netscape Only error using CF and Oracle *
>
>
> Are you sure about that? I'm no Oracle expert but I believe their SET
> commands work the same as everyone elses, ie, the original SET
> FOO='FOO',BLAH='Foo' format was correct.
>
> CFUPDATE is only used if you want CF to handle the SQL for you, and it's
> normally only used when you have a 1-1 correlation of form fields and db
> fields.