RE: DBI indexing question

2003-06-04 Thread Kristofer Hoch
CURDATE() has to be selected SELECT(CURDATE()); --- Bob Showalter <[EMAIL PROTECTED]> wrote: > Greenhalgh David wrote: > > ... > > Second question. If I use the following: > > > > my $query="CURDATE()"; > > my $sth->prepare($query); > > $sth->execute; > > > > I understand that $sth now just conta

Re: DBI indexing question

2003-06-04 Thread Greenhalgh David
The second one. (Except if you delete the largest number(s); they will be reused.) Second question. If I use the following: my $query="CURDATE()"; my $sth->prepare($query); $sth->execute; I understand that $sth now just contains the reference to the result of the query. Where is the value of the q

RE: DBI indexing question

2003-06-04 Thread Bob Showalter
Greenhalgh David wrote: > ... > Second question. If I use the following: > > my $query="CURDATE()"; > my $sth->prepare($query); > $sth->execute; > > I understand that $sth now just contains the reference to the result > of the query. Where is the value of the query (which should be today's > date

Re: DBI indexing question

2003-06-04 Thread Andrew Brosnan
On 6/3/03 at 8:09 PM, [EMAIL PROTECTED] (Greenhalgh David) wrote: > > This is more of a MySQL question than a cgi one, you can say that again > Are there any circumstances in which that vacant ID "5" will be > re-used, or will the ID continue to count up to 255 and then generate > errors? The

DBI indexing question

2003-06-04 Thread Greenhalgh David
Hi all, I just came across this list's archives getting the answer to a problem. Now I have my own questions to ask! This is more of a MySQL question than a cgi one, with luck someone will know the answer. I am managing a database from a set of cgi's, each entry in the database has an ID defin