Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
ASPVendor (Info Locked Info Locked)
 CJWSoft Support Info : ASPVendor
Subject Info: This item is no longer active.. A d d  -  P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
dr_bones
New User
New User


Joined: February/09/2005
Location: United States
Online Status: Offline
Info: 19
Added: October/21/2005 at 5:51pm | IP Logged Quote dr_bones

Chris -

I am encountering a problem with items showing up.  When I click on a category and then select an item to view I get

THIS ITEM IS NO LONGER ACTIVE
DO NOT CONTACT THIS USER AS THIS ITEM HAS BEEN TURNED OFF
OR THE USER HAS SOLD THE ITEM.

I have verified the item has the item_active check.  For giggles, I even unchecked with the same results.

Thoughts?

Back to Top View dr_bones's Profile Search for other info by dr_bones Visit dr_bones's Homepage
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769
Added: October/21/2005 at 5:57pm | IP Logged Quote cwilliams

I really need more information..

SQL or Access database ?
If Access are you using the newest version of the .mdb file

Is this a new item ?

Show me your connection string ?

perhaps the url to the site as well so I can look around?

things like that that will help me troubleshoot.

If any info is sensative send me a PM..



__________________

Best Regards, Christopher Williams www.CJWSoft.com
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 
dr_bones
New User
New User


Joined: February/09/2005
Location: United States
Online Status: Offline
Info: 19
Added: October/21/2005 at 6:12pm | IP Logged Quote dr_bones

It appears there was a flag problem. When reading it into SQL Server, it converted the True/False in Access to 1/0 in SQL Server.

 

Back to Top View dr_bones's Profile Search for other info by dr_bones Visit dr_bones's Homepage
 
cwilliams
Admin Group
Admin Group
Avatar
CJWSoft Web Software Developer

Joined: April/06/2004
Online Status: Offline
Info: 1769
Added: October/21/2005 at 8:36pm | IP Logged Quote cwilliams

With ASPVendor you must use the SQL scripts we provide with the SQL Version to create the SQL database or else fields will not get set correctly.

I wish you would have told me you were using SQL server. It's important details like that that allow me to help and troubleshoot.

__________________

Best Regards, Christopher Williams www.CJWSoft.com
Back to Top View cwilliams's Profile Search for other info by cwilliams Visit cwilliams's Homepage
 
dr_bones
New User
New User


Joined: February/09/2005
Location: United States
Online Status: Offline
Info: 19
Added: October/21/2005 at 9:24pm | IP Logged Quote dr_bones

sorry for the confusion.  I completely forgot about that flag setup, and how different it is between the two databases.
Back to Top View dr_bones's Profile Search for other info by dr_bones Visit dr_bones's Homepage
 

Sorry, you can NOT post info.
This info has been locked by a info administrator.

  A d d  -  P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area


vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.powerasp.com,www.aspclassifieds.com,www.aspphotogallery.com,www.codewanker.com