Hey gang,
Need help with a sqlserver error when running with coldfusion. The datasource, the
query structure are fine. Also I am able to read data from the sqlserver database,
but when I try to execute a insert statement I get the following error:
OLEDB Error Code = 3621
The statement has been terminated.
SQL = "Insert into Sp_Signup(Email,C_Date) Values('[EMAIL PROTECTED]','12/02/02')"
Data Source = "MFXSP"
The error occurred while processing an element with a general identifier of (CFQUERY),
occupying document position (35:1) to (35:42) in the template file
c:\inetpub\wwwroot\superpetros\SIGNUP.CFM
I have already tryed stopping and starting cfserver and the sqlserver but that doesnt
seem to help. The coldfusion server is on its own machine and sql is on another, yet
the datasource is working.
Also when I created a new table in sql server, it also wouldn't read from that new
table saying it was an invalid object. By the way the coldfusion is ver 5.0 and sql
is ver 7.0.
Thanks,
Michael Firth
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
