Gossamer Forum
Quote Reply
GT::SQL limits?
Hi. I'm trying to write a new table, with 52 fields. I've entered all the codes, and run the plugin install stuff, yet it doesn't create anything. I've done all kinds of error checking, including reporting $GT::SQL::error back , but no matter what I try, it won't add it.

Quite simply, is there a limit? What I may end up having to do is split the creation process into 3 or 4 smaller 'create' statements.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] GT::SQL limits? In reply to
A table with 52 fields sounds like a poor table structure.

I expect you could reduce it significantly using a relational structure.
Quote Reply
Re: [Paul] GT::SQL limits? In reply to
If you have any suggestions, I'm open to them. I basically need a table with a field for every week of the year (i.e 52). Its only going to have 5 maximum entries in it, so I don't think there is going to be a problem with database corruption due to the large number of fields.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Quote Reply
Re: [Andy] GT::SQL limits? In reply to
Why do you need a column for every week?

Why not create an ENUM column for 1 to 52?

Last edited by:

Paul: Jul 28, 2003, 3:26 PM
Quote Reply
Re: [Paul] GT::SQL limits? In reply to
Because every week has to have a value Crazy

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!