Take a look at this sql statement _html/css_WEB-ITnose

"SELECT top " lastrow " t.message_id,t.user_id,t.message_title,t.message_content,t.message_time from message_info t where t.message_id not in (select top " firstrow " message_id from message_info)");


It’s OK to remove top “firstrow”, but after removing it, I can’t query it. I’m a novice, please give me some advice and a solution.
I’m using the access database

Reply to the discussion (solution)

Ask the master for answers

First write a statement that can be executed in acceee
Copy the sentence into C# and use placeholder Replace the variable to be changed
var sql = string.Format("SELECT top {0}....",lastrow,);

c# is not java

Waiting for experts online

The query exceeds two columns

Wrong, it is more than one column
in The content can only have one column

"SELECT top " lastrow " t.message_id,t.user_id,t.message_title,t.message_content,t.message_time from message_info t where t.message_id not in(select top " firstrow " message_id from message_info)");

changed to

"SELECT top '" lastrow "' t.message_id,t.user_id,t.message_title,t.message_content,t.message_time from message_info t where t.message_id not in(select top " firstrow " message_id from message_info )");

It's useless for you, but I solved the problem myself. After asking for an answer, I closed the post
/jsp/addmessage.jsp?uid=<%=userinfo .getUser_id() %>
This is a hyperlink. I don’t want uid=<%=userinfo.getUser_id() %> to be output in the address bar. How can I hide it? Waiting online

It's useless for you, but I solved the problem myself. After asking for an answer, I will post it
/jsp/addmessage.jsp?uid=<%= userinfo.getUser_id() %>
This is a hyperlink. I don’t want uid=<%=userinfo.getUser_id() %> to be output in the address bar. How can I hide it? Waiting online

It is the get method, so you need to use it. If not, just use post and try ajax

I want to leave a message?
This is the entire link , how to change it, please give me the code