SQLStatement
-
It may be somewhat odd to discuss about older technologies, but it has always been interesting to me to know that about. Ok, I have the following as my "filename.htx" file: <%begindetail%> <%enddetail%>
<%LastName%>
<%FirstName%>
<%EMail%>
And here is my "addto.idc" file: Datasource:Address_IDC Template:filename.htx SQLStatement:INSERT INTO Addresses(LastName, FirstName, EMail) VALUES('%FName%', '%LName%', '%Email%') It works fine as it inserts data to database, but I need to display all records stored after the above insertion. What can I do? N.B. SQL Server uses "output inserted" clause to do so but I haven't tested with that. I use Access 2007 as the database. Real Eyes Realize Real Lies.
-
It may be somewhat odd to discuss about older technologies, but it has always been interesting to me to know that about. Ok, I have the following as my "filename.htx" file: <%begindetail%> <%enddetail%>
<%LastName%>
<%FirstName%>
<%EMail%>
And here is my "addto.idc" file: Datasource:Address_IDC Template:filename.htx SQLStatement:INSERT INTO Addresses(LastName, FirstName, EMail) VALUES('%FName%', '%LName%', '%Email%') It works fine as it inserts data to database, but I need to display all records stored after the above insertion. What can I do? N.B. SQL Server uses "output inserted" clause to do so but I haven't tested with that. I use Access 2007 as the database. Real Eyes Realize Real Lies.
-
Where should I post that question? I could also post that in "web development" or "database" section. But the question is also not really related to any of those section above. Real Eyes Realize Real Lies.
-
Where should I post that question? I could also post that in "web development" or "database" section. But the question is also not really related to any of those section above. Real Eyes Realize Real Lies.
Post it in Web development forum since this looks to be a question related to ASP, There you might get correct answer , here most people have either not worked on ASP or have forgotten it long time back ;)