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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get the answers you are looking for on the ColdFusion Labs
Forum direct from active programmers and developers.
http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294248
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
