More asp/sql ...

[Agent_Embryo]

So far, so good.

Here's a few problems I face in the development of my free asp forum.

* I can't seem to get paging to work. Have no clue how to do this, I'm thinking I might have to rewrite parts of my scripts.

* Counting replies to topics...do I have to query the database once for every topic (the topics are listed by a loop)???

If anyone is interested in helping me develop this thing, pm me and I might send you the code.

[dragonb]

What do you mean by paging? Like showing a certain number of topics per page?

As for the reply count, not sure how your database is setup, but how about just having a field in the database where you keep an updated count. Then this could be grabbed at the same time you get all the topics and easily displayed in your loop. I think that would be far better than making a database call to count the replies everytime through the loop. With a lot of topics that could get fairly slow.

dragonb

[Agent_Embryo]

Yes, that is a good idea. I did something similar with the "last updated order" thing...

With Paging I mean displaying a certain number of topics on one page, yes.

EDIT:

Also I'd like help with making the database more secure. As it is now, anyone who knows the database name can download it and access the records = Usernames and Passwords. I'm planning on converting the database to MySQL instead of Access(developing the database is so much easier in Access, at least for me).

[dragonb]

here's link to a page type thing done in php.
Don't worry, they are fairly similar, if you don't fully understand the syntax, you should be able to figure out the idea, and it's really not too complicated, although you may have to rewrite some of the code you've done already.

As for security, mysql requires user and passwords to use the database. And then you can usually put the asp file that contains the password outside of your website path, and just include it inside your code. So, it's basically as secure as your machine.(almost)

and, I agree with you that it's easier to design in access. I used to do it that way, but found myself using mysql more and more, and access less, so now I just design on paper.

dragonb