ASP query FROM statement syntax error 10

You can write a sentence below that line.

First test whether it is an output SQL statement, if it is, you can take it out and put it in the database to execute it separately, see if the error is reported, if it is wrong, see what error is reported, and then solve the problem according to the error.

The most suspicious thing in your sentence is the uid.,If you use session to assign a value,,It should be a numeric type.,There's an extra pair of single quotes in the uid in your sentence.,Try to remove it.。

Your "UID" should be numeric type, right? Changed to.

uid=session("uid")

set ws= "")

Say it's wrong here. sql,conn,1,3

uid is an integer and cannot be +""Number.

Take a look**, steps: your site's root directory --> properties --> security --> selection"everyone'Users --> full control, if there are no everyone users, add:

Add --- Advanced --Find Now -> select everyone--- return authorization to him --ok

microsoft jet database engine (0x80040e09)

It cannot be updated. The database or object is read-only.

It's that you don't have permission to modify the table.

You go to the table you want to modify and click Right-Properties--Permissions, and check the corresponding Select Insert. and other permissions on it.

Is the field written incorrectly?

sql="select top 5 * from pinglun where article id="&id&"Order by Leave a comment on desc"

This is basically satisfied.

You can add another sort at the end.

sql="select top 5 * from pinglun where article id="&id&"Order by Leave a Comment Time desc, Comment ID Desc"

Try this.

You have specified the ID and how do you read the first 5 items.

sql=sql&" where shenhe1='1' and (xinghao like...or ..order by id desc

Can you see it.

This parenthesis takes that or as a condition.

You always wrote a few SQL statements,,You can print out the SQL statement first,I preliminarily guess that you may not have executed this SQL sentence,It may be executed to find all the SQL statements,,There is a good table,,shenhe1 field is text or numeric,,This should also be clearly compared

""If you can't see anything, you'll need to see if there's something wrong with your userphoto value.

""In an asp statement, if you want double quotation marks, use two double quotation marks to indicate the ---

if userphoto="" then

Change to if len(userphoto)=0 then try.

if trim("i_brand")) "" thenstrbrand = trim("i_brand"))elseif trim("i_brand")) = "Please select a brand" then

strbrand =("/?w = Sorry, please select the brand! ")exit sub

end if

I hope it will help you with your questions, if you still don't understand anything, you can consult and help you answer!