the err msg of "Invalid object name 'CDN100'" seems to suggest that the driver
may be expecting something like [dbName].[dbOwner].[tableName] notation, try
that, I know JDBC driver likes that; also, everyone else's notes all make some
sense...
>CF5.0 - SQL2k
>
>I am getting a "Base table not found" error on a table that I know (and can
>prove) is there.
>In the following code, the SELECT apparently works as the cfdump displays
>the column names (the table is empty) and doesn't throw an error, but the
>INSERT gives me this error:
>ODBC Error Code = S0002 (Base table not found)
>
>[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'CDN100'.
>
>
>
>The error occurred while processing an element with a general identifier of
>(CFQUERY), occupying document position (13:1) to (13:46)
>
>Can anyone please point out the obvious, or otherwise tell me where I might
>start looking?
>
><cfquery name="q1" datasource="XXXXX">
> SELECT * FROM CDN100
></cfquery>
>
><cfdump var="#q1#">
>
><cfquery name="Ins_1" datasource="XXXXX">
> INSERT CDN100
> ('Date_Added','Name','Title','Company','Phone','Email')
> VALUES(
> #Now()#,
> <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#FORM.fullname#">, etc.,
>etc.,
> )
></cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294261
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
