sp_ might be invalid for a table name? SP_ is for system procedure IIRC and
SQL may not like it being used as a table name. Try to change the table's name
and see if that does anything.
Can you run the statement in query analyzer manually? At least possibly narrow
down the point of failure.
On Mon, 2 Dec 2002 09:12:33 -0800 (PST) michael firth <[EMAIL PROTECTED]>
wrote:
> 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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
