I had another thought on this thread (see original question below), I followed
instructions from someone's blog on how to set up Oracle 10g express as an
"other" data access connection. Would that be the reason for requiring so many
quotes?
Thanks in advance - Dawn
> I am trying to transfer an application from MSAccess into Oracle 10g.
> I the free version of Oracle 10g Express running locally for
> development purposes before uploading to the test server. I have used
> older versions of Oracle, but never 10g. It has been a while, but I
> do not ever remember having to put everything in quotes before.
> However, the only way I can get table creates and record inserts to
> work is by putting everything in quotes including the table name.
> When I look at examples of other Oracle SQL on the Internet, I'm not
> seeing this format. Is what I am experiencing correct or is there
> some setting I don't know about? Thanks in advance for any advice.
> This is the query I have gotten to work.
>
> <cfquery name="tableCreate" datasource="#session.systemTables#">
> CREATE table "systemRoles" (
> "roleID" NUMBER,
> "description" VARCHAR2(50),
> "viewable" NUMBER,
> "help" VARCHAR2(256),
> "createdDate" DATE,
> "createdBy" NUMBER,
> "modifiedDate" DATE,
> "modifiedBy" NUMBER,
> constraint "systemRoles_PK" primary key ("roleID")
> )
>
> </cfquery>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272221
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
