How to remove "No Records Returned"?

[Guest_imported]

I would like to know how do I remove the "No Records Returned" statment after I have entered a value into the database.

Thanks in advance!

 

[MalcolmW]

This is SQL Server syntax for getting rid of the similar message "(0 row(s) affected)"

set nocount on
select * from table
where 0 = 1

 

[Guest_imported]

Thanks,

However, I would like to know if I am using this correctly

INSERT INTO QREPORT (CUSTOMER)
VALUES ('%%CUSTOMER%%')
set nocount on
select QReport.Customer from table
where 0 = 1

 

[MikeLacey]

I think that:
[tt]
INSERT INTO QREPORT (CUSTOMER)
[tab]select QReport.Customer from table
[tab]where 0 = 1
[/tt]
will do what you want.

 

[listener22]

In Malcolm's posting of the 30th,
set nocount on is what turns off the message
and
select * from table
where 0 = 1
is the example he gave of a query that demonstrates
that set nocount on works.

(Since the condition where 0 = 1
returns no records.)

 

[Guest_imported]

Thank you all,

Just one more question, I would like to know whether I can use SQL in Microsoft FrontPage. If not, what other ways I can let the user enter data and access the data (I am using MS Access for the data) while using Miscrosoft FrontPage to design my webpage?
|-0 Thanks again!

 

[samoff]

I think now may be the time to start looking into Active Server Pages. As a first steptowrds that, I'd break out of Frontpage and start coding the HTML from scratch. Once you've got HTML sorted then get a book on ASP and you'll find it falls into place quite easily.