Many to one asp guestbook, please give me the simplest asp guestbook

To maintain a one-to-one guestbook database, it should look like this: (Table 1) ID content and other auxiliary items, such as time, IP, poster......Then add a table to the database. Name it casually.

id contentid content (Table 2) id is the primary key, let it be automatically numbered, contentid is the ID in the database table to get the message, that is, the above id, that is, id(Table 1)=content(Table 2).

When each message is displayed (that is, when reading content (Table 1), the contents of ContentID (Table 2) equal to the ID of the message number (Table 1) are also displayed.

You can achieve the following effects:

Table 1: ID content

id contentid content

Well, you can make it appear as:

Complete! Achieved the effect, right?

There is a pure ASP instant messaging system, which is a new generation of customer service communication system, which is more transparent, more confidential, cheaper and cheaper, and can win more business opportunities for you.

Online and information sound spring tie prompts, chat content automatically pops up, chat and offline message automatic switching processing, and more active users, access records, webmaster tools and other auxiliary tools.

How much are you plugging in? You fix the ** with numbers, try it.

set rs="")

sql,conn,2,3 '1 and 1 are read-only data, 1 and 3 are inserted data, and 2 and 3 are modified data.

You try sql,conn,1,3

Try this. sql="select top 1 * from book"

Your coding is too non-specimate.

rs("IP address")=userip

rs("Show No")=showcontentrs("Contents")="newcount")

Is the database being opened read-only?

Isn't the hint clear? There is a problem with the characters you obtained to form an SQL statement. It may be that you have encountered a null character or that there is a type mismatch. Before you execute the SQL statement, you can use to output the SQL statement.

Syntax error of the insert into statement. , line 115.

What is line 115?,What's the key thing I didn't post.。

Suspect your IIS isn't getting it right. Write a test to see if there is a problem with your IIS.

hello world!")%>

If there is no problem, is there a field in your database that is named after Chinese characters? It is recommended to change it to English or pinyin.

If it's just using Chinese characters, the string of your first SQL command seems to be missing a double quotation mark!

Question for you:

First, what is your system?

Second, is your IIS set up correctly? Settings, mainly refers to the setting of permissions, especially the permissions of the database, are they set to full access?

If, you think, on your own computer, there is still a problem, then, you can upload it to the web space to see.

I'm the sad king of the question.,That number can't add questions.,Well,That's it.,Upload to the Internet and don't display.,The database uses access.,Full access.,Let's talk about it first.,Are there any mistakes with my three files? If there is a mistake, help me correct it, good, add points

Check the type definition of the field in the database!

If the encoding is UTF-8, add it.

language="vbscript" codepage="65001"%>

If it's GB2312, add it.

language="vbscript" codepage="936"%>

Add this to the top line of the file.

It's best to add to every one!

Is it that the table you designed has a numeric field type? Double-check! It should be this question!

Create a check as follows:

dim query_badword,form_badword,i,err_message,err_web,name

--Define the head ---

err_message = 1 'Solution: 1 = prompt message, 2 = turn to the page, 3 = prompt first and then turn.

err_web = "" 'The page that you turn to when you make an error.

query_badword="'‖and‖select‖update‖chr‖delete‖%20from‖;‖insert‖mid‖master.‖set‖chr(37)‖="

In this section define the get illegal argument, which is used"‖"number interval.

form_badword="'‖%‖#‖(‖=" 'In this section the definition of the post illegal parameter, used"‖"number interval.

--Define the end ---

on error resume next

--Filtering for get query value.

if <>"" then

chk_badword=split(query_badword,"‖")

for each query_name in

for i=0 to ubound(chk_badword)

if instr(lcase(,chk_badword(i))<0 then

select case err_message

case "1"

case "2"

case "3"

end select

end if

nextnext

end if

--Filter the single value of the post table.

if <>"" then

chk_badword=split(form_badword,"‖")

for each name in

for i=0 to ubound(chk_badword)

if instr(lcase(,chk_badword(i))<0 then

select case err_message

case "1"

case "2"

case "3"

end select

end if

nextnext

end if

I quote it on that page of the form.

You can test and change it.

There are two ways to do this, one is to have a tag in the HTML that makes the rest of the HTML think of it as text and not as html**, but almost no one uses this method.

Mainstream method: %="This is a test of the htmlencode method. < br> will not start a new line here. ")%>

DVBBS implements HTML** filtering in its own way.

I've sent you a very detailed one.

The answer has been sent to you.