Hi cf-talk, On Thu, 12 Apr 2001, at 10:49:13 [GMT -0700] you wrote:
FJ> I'm trying to use cfinsert for the first time after using SQL queries. I
FJ> can get it to work with a local Access Database, no problem. But when I try
FJ> to use the Oracle database on the server, it asks for:
FJ> table names must be qualified with the database name and table owner, as in
FJ> 'customers.dbo.orders'
FJ> I know this is basic...and I'm probably overlooking something REALLY simple.
FJ> But I just can't figure it out!
FJ> TIA --
FJ> Jennifer Francis
FJ> AT&T Wireless
FJ> * [EMAIL PROTECTED]
Jennifer,
I just went through this with Oracle and gave up on CFINSERT.
Through advice from this group I went to using SQL query and my life
is much better.
Example as:
<cfquery datasource="#application.dsn#">
INSERT INTO NEWS (headline, blurb, news, live, top)
VALUES('#headline#', '#blurb#', '#news#', '#live#', '#top#')
</cfquery>
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
------------------------
Internet Guns For Hire
(603) 356-0768
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
