The Official Website of AgoraCart and Agora.cgi
AgoraCart.com Demos Download AgoraCart User Manuals & Wiki Gold Members Forum Go Gold Now! Gold Version Memberships
Shop Live Sites | iMegaMall.com | AgoraPros.com | AgoraPay | WebHosting Search | SnooperClick.com Search

AgoraCart.com

• About
• Features
• Download
• Payment Gateways
• Send a Donation
• Founders Club
• BLOG: News & Updates

Showcases & Demos

• AgoraCart Demos
• Shop Live Stores

Downloads & Add-ons

• Gold Version Downloads
• DBwizz Database Mgr.
• AgoraCart.com Store

Help & Support

• User Manuals
• Gold Version Users Forum
• Gold Version Chat
• Tech Support
• Certified Agora Pros
• Certified Designers
• Hire a Freelancer

Gold Version Members

• Member Benefits
• Join Today!
• Gold Members Home
• Gold Version Users Forum
• Gold Version Chat Rooms
• Gold Version Downloads

For Store Owners

• Merchant Accounts
• Cool Resources
• Advertise Here
• "Powered by" Logos
• Web Hosting Search

Misc.

• Contact Us
• MEET's Talking Guide
• The Ancient Greek Agora

AgoraCart Free User Forums

This is the official FAQ and Cool Tips guide For the AgoraCart shopping Cart software


Official Sponsors of the AgoraCart Project:

       


Register • Search • FAQ • Log in

AgoraCart Free User Forums Forum Index » Misc Product / Database » Field sizes

The time now is Mon Apr 28, 25 9:13 am
View previous topic | View next topic
Reply to topic Page 1 of 1
Field sizes
Author Message
johnw
Newbie
Joined: 18 Aug 2005
Posts: 5
Reply with quote
Post Field sizes 
I'm looking for details on the field sizes of the database.

From reading on this board it appears that the USER fields are limited to 128 digits. Is this correct? Can it be altered easily or will I need to learn perl to do that?

I'm also interested in exactly which file holds the database. I know it is a pipe delimited flat text file just don't know where to start looking for it.

I'm building a store and the products have lots of sub-attributes people might want to search on. I was going to use USER2 for this and while I can get away with 2 letter code I'd rather use ASCII words. Just checking the field size before I run off the end of it Smile


Thanks in advance

john
Sat Sep 03, 05 12:39 am View user's profile Send private message Send e-mail
Dan
Guest



Reply with quote
Post  
hell-o
the store/protected folder contains the files that regulate the values of the input boxes in the store manager. in many cases there are two places to change each box while in some cases there is only one.
most people just enter the data directly into the dB. however, this is not a good idea without first correcting the field lenths.
regards,
dan



Last edited by Dan on Sat Sep 03, 05 4:45 pm; edited 1 time in total
Sat Sep 03, 05 5:21 am
johnw
Newbie
Joined: 18 Aug 2005
Posts: 5
Reply with quote
Post  
Hi Dan

Thanks for the warning, if I decide to try this I'll keep in mind that there might be two places to alter the field sizes.

Regards

john
Sat Sep 03, 05 3:27 pm View user's profile Send private message Send e-mail
Display posts from previous:

AgoraCart Free User Forums Forum Index » Misc Product / Database » Field sizes

The time now is Mon Apr 28, 25 9:13 am | All times are GMT - 7 Hours
 
Reply to topic Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
  


Another K-Factor Technologies, Inc. Web Site     © Copyright 1999 - 2005