Creating Search Pages

[ign09]

Hi all,

I want to create pages to search my database that includes the previous and next links. I have tried everything and this is complely above my head, I am fine with a tutorial if anyone has any but please make sure that the links in the tutorials are working.

Renaldo

[Newsgroup_User]

Do you know how to write your SQL statement to query the DB with what you
are looking for?

[ign09]

This is for Wally Kolcz ,

Yes I know! I am going to search the database for the contents of a the search text field.

[insuractive]

Take a look at:

http://tutorial405.easycfm.com/

and I believe there is also a good article on pagination on Ray Camden's Blog:
http://ray.camdenfamily.com/index.cfm/2006/4/24/ColdFusion-and-Pagination
http://ray.camdenfamily.com/index.cfm/2006/4/26/ColdFusion-and-Pagination--Part-2

Hope that helps.

[ign09]

I have a database called BNET2, I want to search that database for the criteria from the search text field. Then if the results are more than 10 I want to create another page to display those results and so on. Also the page needs previous and next buttons, the other tutorials above I unfortunately don't understand enough to customize it to work for me.

Renaldo