Inserting into two tables 1

[PTmon]

I have a from that submits text and one image. I want to submit the text into one table, and the image name and foreign key into a different table. What I have does the first insert, the second insert doesn't happen, but I get no errors.

<cfquery name="addEditorial" datasource="#application.dsn#">
  Declare @intFK int
  INSERT INTO tblArticles(dtmEntered,dtPublication,strArticleTitle,txtArticle)
VALUES(#CreateODBCDateTime(Now())#,convert(datetime,'#Form.dtPublication#'),'#Form.strArticleTitle#','#Form.txtArticle#')
SET @intFK = Scope_Identity()
INSERT INTO tblImages(intArticleIDFK,strImageName,intSortOrder)
VALUES(@intFK,'#session.strImageName#',1)
</cfquery>

SQL 2000 database, coldfusion 5 server.
Thanks,
pt

putting the "new" in "newb".....

 

[r937]

instead of

SET @intFK = Scope_Identity()

try

SELECT SCOPE_IDENTITY() AS @intFK


test what you have inside the CFQUERY in Query Analyzer first


r937.com | rudy.ca

 

[PTmon]

thanks
pt

putting the "new" in "newb".....