Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Member_id not updating in Sql7		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

juliemac
Starting Member

12 Posts
Posted - 08 August 2002 :  09:03:58  Show Profile
When registering a new user, the code is not detecting or providing the next id.
The Col (member_id) is set so that something must be in there (not null).
>>Invalid use of Null: 'cint'
forum/inc_functions.asp, line 910<<
No member_id is found.

Any help appreciated guys!

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 08 August 2002 :  09:05:58  Show Profile  Visit HuwR's Homepage
sounds to me like you have upsized an access db to sql server.

You will need to edit your SQL db, and reinstate all the Identity fields in all the required tables.

either that, or delete all your tables and do thetransfer correctly
Go to Top of Page

juliemac
Starting Member

12 Posts
Posted - 08 August 2002 :  09:12:47  Show Profile
Man your fast. I'll delete what is in the database and try again. Thanks :)
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 08 August 2002 :  09:16:29  Show Profile  Visit HuwR's Homepage
if you look in this forum, there are some posts detailing how you shold do it so as not to get problems
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 08 August 2002 :  09:42:53  Show Profile  Send ruirib a Yahoo! Message
Here you have a detailed upgrade path:http://forum.snitz.com/forum/topic.asp?TOPIC_ID=31144
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20595 Posts
Posted - 08 August 2002 :  10:03:42  Show Profile  Visit HuwR's Homepage
thanks ruirib, havn'e got time to go hunting for stuff at the moment (even though its much faster)
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 08 August 2002 :  10:09:14  Show Profile  Send ruirib a Yahoo! Message
No prob, I really have most of this recurring stuff bookmarked .

-------------------------------------------------
Installation Guide | Do's and Dont's | MODs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07