hotcut — Fri, 22 Jun 2001 17:57:27 +0000

naa, I am writing it all in ASP, just using the database to store the information...
The free bulleting boards are easy to crack... when I make it myself I can controll it all better...

Many servers takes money to give the space on the mySQL servers... The site I am running requires a good speed, thats why I pay for the hosting...

I don't know much SQL no, I know what i need The forum is almost done, just need to add some administarting options and some mods...

~Casper

mairving — Fri, 22 Jun 2001 17:53:33 +0000

Quote: Originally posted by hotcut
heh, yep I am

The intire game I am running
secretsofwar.net
is base on access I know it sucks, but as it is now its my only option... Getting room on a server for an SQL database is expensive you know...

There are several open-source SQL databases. The most popular is MYSQL. It doesn't take any money to get it, just some time to install it and learn it.

Quote: Originally posted by hotcut

I am currently creating my own forum (the free bulletin boards have low security) so I might need some help

So you really don't know much about SQL and yet you know how to write a more secure version of a bulletin board. I am not really understanding that, especially using Access to do so. Also for the most part, some of the free bulletin boards can be secured quite well. Security is a concern but for the most part a cracker would have nothing to gain by hacking a forum site, beyond some passwords and email addresses.

hotcut — Fri, 22 Jun 2001 17:15:28 +0000

heh, yep I am

The intire game I am running
secretsofwar.net
is base on access I know it sucks, but as it is now its my only option... Getting room on a server for an SQL database is expensive you know...

Also, I am not sure what limitations I have in my coding... I will have to figure that out as well...

My database (for the game) is like 40 megs now, and gettting that sort of room on an SQL server is VERY expensive you know...

Peter J. Boettcher — Fri, 22 Jun 2001 17:13:04 +0000

I hope you're not using Access as the back end of your forum (unless it's going to be a very quiet forum)

Access was never meant to be used as a web back end, and can be a real pooper with 25 or more simultaneous users.

hotcut — Fri, 22 Jun 2001 17:09:01 +0000

heh, well the asking questions thing is something I can take care of

I am currently creating my own forum (the free bulletin boards have low security) so I might need some help

I will create a new thread when the time comes, so that others might be able to learn something from it as well

~casper

Mark Hensler — Fri, 22 Jun 2001 17:07:01 +0000

reading, experience, and asking questions

hotcut — Fri, 22 Jun 2001 12:47:21 +0000

Thanks man! Worked A OK!

Now it all works

How do you guys no so much????

Thanks
~Casper

Peter J. Boettcher — Fri, 22 Jun 2001 12:43:49 +0000

You can use the following SQL to alter a column type:

ALTER TABLE TableName
ALTER COLUMN ColumnName char(150) Null

Just replace tablename with your table, columnname with your column and the datatype to whatever you want to use. The Null on the end means that nulls are allowed. If you don't want nulls then replace that with Not Null, but you can only use Not Null if there is no existing Null data in that column.

hotcut — Fri, 22 Jun 2001 07:24:35 +0000

Yea OK, I see what you mean... but can you tell me HOW I change what type of field it is?
Sure I could download it, open it and change it in access, but since its more than 35 megs it will take some time and bandwidth to do...

Do you know the SQL code for changing the type of field, so that I wont have to download?

Thanks
Casper

Mark Hensler — Thu, 21 Jun 2001 22:32:54 +0000

You'll have to go from a VARCHAR to MEMO. 255 is the max that the VARCHAR data type will allow.

The INT data type is for holding integers. I think it has a default of 11 digits.