value (I want the next insert to reuse this number). I
cannot find it in the manual now I need it.
I'm only on the digest list so please (b)cc to me directly.
Gerben Gieling
Patent Information Specialist
Synthon BV
P.O. Box 7071
6503 GN Nijmegen
The Netherlands
phone:+31 24 372770
Sorry,
should be the lpad function:
http://www.mysql.com/doc/en/String_functions.html
LPAD(str,len,padstr)
Returns the string str, left-padded with the string padstr until str is
len characters long. If str is longer than len' then it will be
shortened to len characters.
mysql> SELECT LPAD('hi',
What you want is the rpad function:
http://www.mysql.com/doc/en/String_functions.html
RPAD(str,len,padstr)
Returns the string str, right-padded with the string padstr until str is
len characters long. If str is longer than len' then it will be
shortened to len characters.
mysql> SELECT RPAD('hi'
Perhaps you should create a new table with an id column and a flag
column.
Select the found calls > 5 or <= 5 into that new table and set the flag.
Then do a left join of your t_callog_calls table on the new table
selecting only the rows where the flag is NULL, these should be the rows
not found b
The combination of Access front end with MySQL or PostgreSQL works
great. However there is a disadvantage in using Microsoft Office
applications. If you use Visual Basic code to program the behaviour of
your front end (You probably will). The front end will run great until
the next major update of
