Strike
10-30-2002, 02:07 PM
This is for moobot, for those of you who are familiar with it :)
At any rate, we don't want to restrict the user's choice for factoid key lengths, so we don't hardcode that number anywhere (except in the initial setup for now, but that can be changed and will hopefully be abstracted away to a config option). However, once that number is set, I don't know of a simple way of retrieving it that is portable across SQL databases. I can cheat with MySQL and use the "SHOW" or "DESCRIBE" commands, but there's no analog for those in Postgres (the other main DBMS we are trying to support). I'm still searching for the info, and I'll report back any success I have, but I thought I'd get the question out there in case anyone knew the answer off the top of their head. Thanks.
At any rate, we don't want to restrict the user's choice for factoid key lengths, so we don't hardcode that number anywhere (except in the initial setup for now, but that can be changed and will hopefully be abstracted away to a config option). However, once that number is set, I don't know of a simple way of retrieving it that is portable across SQL databases. I can cheat with MySQL and use the "SHOW" or "DESCRIBE" commands, but there's no analog for those in Postgres (the other main DBMS we are trying to support). I'm still searching for the info, and I'll report back any success I have, but I thought I'd get the question out there in case anyone knew the answer off the top of their head. Thanks.