300 points asp call database

Connect to the database:

set conn="")

driver=;database=hbmarket;server=database server address; uid=sa;pwd=Password"

set rs="")

Show data: An example, you can try it out.

set rs="")

sql="select * from marketdata "

The number of records per page is set to 5

curpage="curpage")'Pass the POST parameter of the URL to the curpage variable.

if curpage="" then curpage=1'When the page number pass fails, you skip directly to the first page.

Specify the curpage variable as the current page.

rs("displayorder")=rs("displayorder")+1

Browse transaction history.

Intermediaries. Belong to the urban area.

Community. Area.

Price. Unit price.

Area segments. Belongs to the real estate.

Closing date. The precinct to which it belongs

The region to which it belongs. The partition to which it belongs.

for i= 1 to

if then

exit for

end if'Use the for loop and the if condition statement to display only the number of entries set by pagesize on a page.

zhongjie=rs("Intermediaries. ")

chengqu=rs("Belong to the urban area. ")

xiaoqu=rs("Community. ")

mianji=rs("Area. ")

zongjia=rs("Price. ")

danjia=rs("Unit price. ")

mianjiduan=rs("Area segments. ")

loupan=rs("Belongs to the real estate. ")

riqi=rs("Closing date. ")

pianqu=rs("The precinct to which it belongs ")

daqu=rs("The region to which it belongs. ")

fenqu=rs("The partition to which it belongs. ")

zhongjie%>

chengqu%>

xiaoqu%>

mianji%>

zongjia%>

danjia%>

mianjiduan%>

loupan%>

riqi%>

pianqu%>

daqu%>

fenqu%>

if curpage=1 then%>

Home. %else%>

Home. %end if%>

if last page. %else%>

Last. end if%>

Current page <%=curpage%> A total of <%=> pages were found<%=> records).

Sorry, we didn't find any eligible transaction data, please click the "Back" button on your browser to check if your query conditions are correct, thank you! ")

end if

I have to make it up to someone else, and I'm really speechless to you.

Then I'll make it up for you, but it's done. What a return.

I'm speechless, if you know how to asp basics, you will definitely write ...... yourself

If you don't understand what exactly you want to call, let me tell you about the principle:

Link the database on the home page first, link to the database, and then call accordingly according to the table and fields where the document is located! Because your main plane and database table information is not provided, I can't write it to you here**, if you don't understand, add me hi to help you deal with it!

Thanks for adopting!

Browser - Tools - Internat Options - Advanced - Remove the check mark in front of the display friendly http error.

Then run it again to see the specific error message.

id=request("id"This sentence is useless. Comment it out.

sql="select id from news where"

sql="select * from news"

From simple to complex. All right?

If you're using the XP operating system, and you're still using Ghost, then I'm introducing you to this.

You'll be able to solve the problems you're currently experiencing.

<%dim pic,pics

pic="**Address**Address**Address**Address**Address=split(pic,"$$$")for i=0 to ubound(pics)pics(i) &"

next> if you don't want that **address1|**Address 2 continues to be split by split.

Put |and the previous **address n to remove it.

The two cousins have a Sen Sun username

select , from info left join thour on order by

Upstairs is the correct solution, you should set the number of queried records in the SQL query statement, select top n *

n indicates the number of calls.

Do not change it in this line **, set the number of records to be queried in the previous SQL query statement, or specify the number of records per page of pagination, or modify the loop statement to jump out of the loop when certain conditions are reached.

You have to look at the specific ** to know what's going on.

sql="select * from info where and pic<> order by desc"order by here should have a field name pic<> appended to it''

pic<> you mean it's not empty, right?

Null is a string that needs to be expressed in quotation marks, and the SQL statement has a double quotation mark on the outside, so you should write it as a pic <>''That's it.