Re: Design decision on generating data

2002-04-12 Thread Carl Schmidt
s not be displayed. Any thoughts? Carl On Fri, 12 Apr 2002, Christopher Thompson wrote: > On Friday 12 April 2002 8:10 pm, Carl Schmidt wrote: > > I have a form where a user enters some numbers into text boxes. Some of > > the text boxes can be left blank. The business logic

Design decision on generating data

2002-04-12 Thread Carl Schmidt
I have a form where a user enters some numbers into text boxes. Some of the text boxes can be left blank. The business logic receives all variables to all text boxes. Should I : 1.) Validate on the page for the presence of a value, and if not, set the corresponding value to -1 (it will never b

Locking tables

2002-04-12 Thread Carl Schmidt
Sorry about the mutli post of this, but I got some mail daemon errors, so I'm sending again to make sure. The question is below. Carl -- Forwarded message -- Date: Fri, 12 Apr 2002 10:20:37 -0400 From: Carl Schmidt <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subje

Locking tables

2002-04-12 Thread Carl Schmidt
I understand that at some point, a sql table that has been locked by someone will automatically be unlocked, but I'm a little unclear as to the circumstances. Say at the beginning of a function I open a connection, lock a table, and then close the connection. Then, perhaps a few lines down in th

Setting a default time in mysql table def

2002-04-08 Thread Carl Schmidt
If I set a mysql table def time to default like so: eventTime time NOT NULL DEFAULT '0'; Will it default to the current time like the TIMESTAMP does? If not, is it possible with something like CURTIME() to make this happen? Carl --

Follow up question to table types

2002-04-07 Thread Carl Schmidt
One thing did occur to me though. I was looking at the syntax for actually creating a database on the mysql server. I wanted to make sure that those table types that are installed with mysql do not have to be specified as _available_ to tables in a particular database. In other words, when a da

Re: Converting table types

2002-04-07 Thread Carl Schmidt
raid | NO| | have_ssl | NO| +---+---+ 6 rows in set (0.00 sec) mysql> Looks to pretty clear like it ain't there. Carl On Sun, 7 Apr 2002, Paul DuBois wrote: > At 20:23 -0400 4/7/02, Carl Schmidt wrote: > >I don't believe my web host has eith

Converting table types

2002-04-07 Thread Carl Schmidt
I don't believe my web host has either InnoDB or BDB installed on their system so I ran some tests here: mysql> alter table Development_EventType TYPE=INNODB; Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 That's the result I get, but when I do a table dump, the typ

FOREIGN KEY Constraints

2002-04-07 Thread Carl Schmidt
>From the mysql docs, it looks like you can only use foreign keys if your tables are type InnoDB. Is this correct? Carl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Re: Index a primary key

2002-04-06 Thread Carl Schmidt
. However, it prompted me to ask the question, are primary keys already optimized for some sort of indexing and searching? So then I emailed the list. Carl On Sat, 6 Apr 2002, Paul DuBois wrote: > At 18:28 -0500 4/6/02, Carl Schmidt wrote: > >On Sun, 7 Apr 2002 [EMAIL PROTECT

Re: Index a primary key

2002-04-06 Thread Carl Schmidt
On Sun, 7 Apr 2002 [EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query > > If you just reply to this message, and includ