Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - database column
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

database column

 Post Reply Post Reply
Author
somy View Drop Down
Newbie
Newbie
Avatar

Joined: 05 April 2003
Location: Egypt
Status: Offline
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote somy Quote  Post ReplyReply Direct Link To This Post Topic: database column
    Posted: 23 April 2003 at 5:00pm

hello there,

i used v7beta 2 , then i upgraded to the new verion7.

it worked by adding the missing columns..

But the problems now that when i post a new topic it gives me the following error

Microsoft VBScript runtime error '800a005e'

Invalid use of Null: 'CInt'

/forum/forum_topics.asp, line 377

i found that was because i inserted the column " Moved_ID" in the "tbl topic" table and i made all = 0 ,

so when i make a new posts, the cell won't get any value and the value ==Nul

so how to make the cell auto number??

and will that work later???

Back to Top
somy View Drop Down
Newbie
Newbie
Avatar

Joined: 05 April 2003
Location: Egypt
Status: Offline
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote somy Quote  Post ReplyReply Direct Link To This Post Posted: 23 April 2003 at 5:09pm

how to make default 0 for the column

Back to Top
somy View Drop Down
Newbie
Newbie
Avatar

Joined: 05 April 2003
Location: Egypt
Status: Offline
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote somy Quote  Post ReplyReply Direct Link To This Post Posted: 24 April 2003 at 5:14am

All that i need how to make the default of an column equal 0 in the database file Access ,.....Plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 24 April 2003 at 5:18am

You haven't said if you are using access or SQL server.

With access in design view for the table select the Moved_ID field and down the bottom in the properties box set the default value to 0

Back to Top
somy View Drop Down
Newbie
Newbie
Avatar

Joined: 05 April 2003
Location: Egypt
Status: Offline
Points: 22
Post Options Post Options   Thanks (0) Thanks(0)   Quote somy Quote  Post ReplyReply Direct Link To This Post Posted: 25 April 2003 at 3:04pm
thanks -boRg-
it worked , i used access
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.