antoshka — Fri, 23 Jan 2004 05:42:21 +0000

if you want to use a restricted word (like insert, select, time, etc) as your database/field name, you will need to treat it differenty in your scripts. in MS SQL put brackets around it:

UPDATE users SET [time]=25;

in MySQL use back quotes:

UPDATE users SET `time`=25;

Abhishek Reddy — Thu, 08 Jan 2004 14:23:57 +0000

Excellent!

dhotchin — Thu, 08 Jan 2004 14:08:54 +0000

It works!!!!!!!!!!! It works!!!!!!! It didnt have the "everyone" on the database and now it works. You have put a smile on my face. thank you so ever so much!!!! you learn new things everyday!!!!!

dhotchin — Thu, 08 Jan 2004 14:00:04 +0000

I shall have a go. Thanks for the help again. I posted the same message on other forums, this is the only forum were people do help each other!!!

Abhishek Reddy — Thu, 08 Jan 2004 13:57:19 +0000

You may run into the problem again. Try the solution given here: http://support.codecharge.com/kb_article.asp?s_prod=2&article_id=4
or here: http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=107

... and if it still gives you that error, you'll have to reboot and give it a try.

dhotchin — Thu, 08 Jan 2004 13:55:34 +0000

No its still coming up with that same error as above. I'm i doing something wrong? I'm doing it the same way i use to. two pages. One called results.asp (with a Dynamic table) and diary_add.asp (Record Insertion Form) When i have inserted a record it should work then send them back to results.asp. But it dont....

dhotchin — Thu, 08 Jan 2004 13:49:23 +0000

cool. I change the colums, create a new database and new pages, but now it seems to be coming up with an (0x80004005) Operation must use an updateable query.

Im going to try again.

Abhishek Reddy — Thu, 08 Jan 2004 13:40:19 +0000

If your host allows, I'd recommend you use a different database for each different project. Unless the "projects" are under one umbrella -- like you might have a sales record, a customer list, and a daily log for a computer store.

Just keep in mind that Access is a weak DB and can become mercurial even with a few simultaneous connections.

dhotchin — Thu, 08 Jan 2004 13:31:57 +0000

All that i wanted to do was an insertion form, so that the user would add the time and date in to a diary,which is the hole datbase thing.
Just one last thing: Is it best to use one table in a database for each project. At the moment i use loads of diffurant tables but in the same database.for example. I have a diary, weblink database, computer fault report, which uses a lot of tables and there will be more.

Abhishek Reddy — Thu, 08 Jan 2004 13:25:34 +0000

No problems. Too bad it took so long... should've Googled earlier.

Btw, my Sams books seems to suggest using separate columns as you're doing now, if you still want to use the dates and times. I guess I'm just used to keeping it in one from PHP/MySQL.

Here's two lists you might find useful later. ASP/databases reserved keywords and MS SQL reserved keywords.