Unfortunately, good intentions don't always produce alike results.
How about if the bot replies to messages matching "newbie", "novice" and "beginner"
in the subject? They most likely tend to be from beginners, and online manual
and/or list archives are pretty much perfect solutions for their iss
: Am I the only one that equates these robot replies with
: spam? Most of
: them are as meaningful as talking to micro$oft.
:
: Yeah, I filter them on input and they go to trash, but
: silence can be
: taken as consent which might be construed as endorsement.
:
:I want to make a sql query in mysql, with a concat (||) known i Oracle
:world.
:
:Like this.
:
:select numer ||','|| text from Table:
Instead, try the following:
SELECT CONCAT(number, ',', text) FROM Table;
-
Before
If i have a single quote (') inside the /* */ comments,
it gives me a syntax error. Why?
Thanks
--
sherzodR
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
:Lets say the image is 400 x 300 px and I would like tor resize the image to
:40 x 30.
:Is there a way without php or similar?
Go with ImageMagick. It has a imaging resizing and cropping functions
:
:Maybe someone has done this already and can give me a hint on that.
:
:Thanx in advance,
<%@ page import="java.sql.*" %>
Connection connection = null;
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
connection = DriverManager.getConnection(
"jdbc:mysql://localhost/sherzodr_cdbaza?user=sherzodr_cdbaza&password
: after timing the program that was targeting MySQL on different platforms
: the results are (client program running always from the same box that is not
: hosting MySQL):
:
: Windows NT - 25 sec (Intel P-III)
: Linux - 27 sec (Intel P-III)
: Solaris 2.7 - 1 min 40 sec (Ul
: I've got a database already populated with data and need to add a
: sequential numerical "id" field as a key. (as one would with an auto
: increment field)
:
: Is there a straightforward sql statement that will do this?
ALTER TABLE t_name ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT
I have a column with a date in the future. Trying to figure out a query
that would tell me how many days, mins left till that date.
I'm realy tired, and can't think right now :(
-
Before posting, please check:
http://www.my
Try to install it using .rpm. I believe Redhat and Madrake packages all
have perl-mysql libraries.
Good luck
franky wrote:
franky: I have all the time the same error, I try different value but nothing is
franky: right!
franky: in the Perl Makefile.PL command i receive this message:
fr
Hmm, I can't aggree with having two password columns, one raw password and
another is encrypted. It just doesn't make any sence. Why do you need to
encrypt the password in that case, don't you still have the original
password in yoru database? It just defeats the whole purpose of
authentication.
zach: How can I retrieve the decrypted password in a SELECT statement?
You can't!
If you want them to deal with forgotten passwords, here is a standard way:
Whenever they submit their email addresses to retrieve their passwords,
just generate a random password, and send it to the user's emai
Hello list
I've been working on Amazon clone for a client, except it doesn't sell
books, but helps them to advertise. You can take a look at it at:
http://www.ultracgis.com/UltraBooks
The client vanished into thin air, and now I am left with this program,
and don't konw what I can do with it.
You need to have some sort of unique identifier, like a primary key.
And all the tables should agree upon that
Defryn, Guy wrote:
DG: Date: Tue, 18 Dec 2001 10:37:41 +1300
DG: From: "Defryn, Guy" <[EMAIL PROTECTED]>
DG: To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
DG: Subject:
DBI Version: 1.19
DBD::mysql Version: 2.0416
Rich Duzenbury wrote:
RD: Date: Fri, 14 Dec 2001 19:45:02 -0600
RD: From: Rich Duzenbury <[EMAIL PROTECTED]>
RD: To: sherzodR <[EMAIL PROTECTED]>
RD: Cc: [EMAIL PROTECTED]
RD: Subject: Re: dbi accessor for mysql_ins
$dbh->mysql_insertid()
Rich Duzenbury wrote:
RD: Date: Fri, 14 Dec 2001 14:15:36 -0600
RD: From: Rich Duzenbury <[EMAIL PROTECTED]>
RD: To: [EMAIL PROTECTED]
RD: Subject: dbi accessor for mysql_insertid
RD:
RD: Statement handles appear to have an accessor method to ret
As far as I know, not yet
Joel Wickard wrote:
JW: Date: Fri, 14 Dec 2001 12:50:39 -0800
JW: From: Joel Wickard <[EMAIL PROTECTED]>
JW: To: [EMAIL PROTECTED]
JW: Subject: sub selects
JW:
JW: can you perform sub selects in mysql?
JW:
JW:
JW: --
If you want to check before creating a table:
CREATE TABLE IF NOT EXISTS table_name;
If you want to do it before deleting:
DELETE TABLE IF EXISTS table_name;
[EMAIL PROTECTED] wrote:
: Date: Fri, 14 Dec 2001 11:34:26 -0500
: From: [EMAIL PROTECTED]
: To: [EMAIL PROTECTED]
Create temporary files instead, in that case you don't have to worry
about DROPing the tables, they will get dropped as soon as the mysql
session is closed.
Girish Nath wrote:
GN: Date: Fri, 14 Dec 2001 15:29:38 -
GN: From: Girish Nath <[EMAIL PROTECTED]>
GN: To: Johnny Withe
JK: What I really want it to return however, is an array of hashes. According
JK: to the Perl DBI API, this method does exactly that if you pass it a hash
JK: slice reference argument. Can anyone provide some sample code for doing
JK: this?
my $rows = $dbh->selectall_hashref("S
SELECT * FORM table_name WHERE ID IS NULL LIMIT 1;
Steve Osborne wrote:
SO: Date: Thu, 13 Dec 2001 12:47:26 -0800
SO: From: Steve Osborne <[EMAIL PROTECTED]>
SO: To: "MySQL (E-mail)" <[EMAIL PROTECTED]>
SO: Subject: SELECT'ing only 1st matching row
SO:
SO: Is there a way
perl scripts running under mod_perl environment ( with the help of
Apache::Registry) will be using new database handler ($dbh) at each
connection, unless you install Apache::DBI, which keeps the database
handle open throughout the Apache process.
Etienne Marcotte wrote:
EM: Date: Thu, 13
CREATE TABLE IF NOT EXISTS table_name (
id NOT NULL AUTO_INCREMENT PRIMARY KEY,
value VARCHAR(30) );
Mohamed Abd El-Samei Mohamed wrote:
MAEM: Date: Thu, 13 Dec 2001 13:59:46 +0200
MAEM: From: Mohamed Abd El-Samei Mohamed <[EMAIL PROTECTED]>
MAEM: To: [EMAIL PROTEC
When you're insering a new password:
INSERT INTO user SET password=PASSWORD('secret');
But you can't retrieve the original password. If a user forgets/looses
his/her password, just reset a password with something else, and send
him/her that new password
And when you want to check an inputted p
No, it's not accepting NULL if it was declared as NOT NULL.
It's just accepting an empty sting ( "" ).
CREATE TABLE test (t VARCHAR(10) NOT NULL);
INSERT INTO test SET t = NULL;
INSERT INTO test SET t = '';
First insert will tell you what you're waiting for. And the second one
will do what you
I spent some time to do it w/ one query, but I couldn't figure out. So
I am throwing an example in Perl (the best way I could think of)
my $pending = $dbh->selectrow_arrayref(qq/
SELECT pending_2.ordno
FROM pending_2, ordersearch_2
WHERE pending_2.ordno=ordersearch_2.ordn
Try to browse the database of this list, there was a huge conversation on
that about 6-7 month ago.
--
The way I see it, if you declare something portable, you'll always be
wrong, and if you declare it non-portable, you'll always be right. :-)
-- Larry Wall in <[EMAIL PROTECTE
As far as I know, you can't do tht. What you could do instead is
have one Primary Key col and make another one UNIQUE.
I did that several times, and it does work!
--
What they need to teach in school is for people to think for themselves. :-)
-- Larry Wall in <[EMAIL PROTECTED]>
It means you're connecting to the server as an annonymous user.
If you have a username to connect to the server, run the following
query:
mysql> show grants for your_user_name@localhost;
and it will show you all the priveleges that you have for specific
databases and tables. That's the best wa
using? Perl, C, PHP?
Anyways, whenever the query to retrieve the content is passed,
along w/ that query pass the following:
update cnt_table set count=count+1 where story_id=1341234
Good luck
--
sherzodR <[EMAIL PROTECTED]>
use CGI::S
ribe.php
JF:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
ad, e-mail <[EMAIL PROTECTED]>
JA: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
JA: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JA:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
ns:http://www.mysql.com/manual.php (the manual)
ns:http://lists.mysql.com/ (the list archive)
ns:
ns: To request this thread, e-mail <[EMAIL PROTECTED]>
ns: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
ns: Trouble unsubscribing? Try: http://lists.my
D]>
B: To: [EMAIL PROTECTED]
B: Date: Fri, 30 Nov 2001 10:22:34 GMT
B: Subject: Re: html ina text feild
B:
B: >
B: > sherzodR writes:
B: >
B: > > No, you don't have to change the type of field. If you want more HTML
B: > > embedded,
://lists.mysql.com/php/unsubscribe.php
J:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arch
this thread, e-mail <[EMAIL PROTECTED]>
WW: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
WW: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
WW:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
---
l.com/manual.php (the manual)
W:http://lists.mysql.com/ (the list archive)
W:
W: To request this thread, e-mail <[EMAIL PROTECTED]>
W: To unsubscribe, e-mail <[EMAIL PROTECTED]>
W: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscri
7; into the file 'dbname.sql'
:
:Tyler Longren
:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
list archive)
GN:
GN: To request this thread, e-mail <[EMAIL PROTECTED]>
GN: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
GN: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GN:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
---
le unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MG:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql
com/ (the list archive)
PD:
PD: To request this thread, e-mail <[EMAIL PROTECTED]>
PD: To unsubscribe, e-mail
<[EMAIL PROTECTED]>
PD: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PD:
--
sherzodR <[EMAIL PROTECTED]>
use CG
the tmpdir as someone else
C: helpfully suggested but it was close: it was the data directory... I
C: moved it off to a larger partition, symlinked it back and voila!
C:
C: Thanks, all
C: --Cindy
C:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
-
manually?
Morten:
--
sherzodR <[EMAIL PROTECTED]>
use CGI::Session;
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this
manual)
:http://lists.mysql.com/ (the list archive)
:
: To request this thread, e-mail <[EMAIL PROTECTED]>
: To unsubscribe, e-mail <[EMAIL PROTECTED]>
: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
:
--
sherzodR <[E
I keep getting that error too. But I couldn't figure out the cause. So I
just used Apache::DBI for persistent DB connection ( you can't do that
unless your scripts are running under mod_perl )
--
sherzodR
On Mon, 26 Nov 2001, Chris Mason wrote:
>I have a lot of databased websit
To be more specific, everytime you use $dbh->prepare(...), after you're
done with'em, do $sth->finish(); That should solve the problem.
Good luck
--
sherzodR
On Mon, 26 Nov 2001, Colin Faber wrote:
>You've failed to close your prepare() statements with finish()
&
it for you (available at w3c.org)
Good luck
--
sherzodR
On Mon, 26 Nov 2001, Amer Neely wrote:
>I've read with interest the posts on Netscape not rendering HTML
>correctly. I can add my experience to that thread, but I use Perl not
>PHP to generate the HTML. Some very strange thin
Well, to do date calculations, use DATE_SUB() and DATE_ADD() functions.
To convert to some other functions, use DATE_FORMAT() function. For
templates that DATE_FORMAT() needs, please refer to documentation.
There're bunch of'em
--
sherzodR
On Mon, 26 Nov 2001, Thomas Spahni wrote
Check out DATE_SUB() and DATE_ADD() functions. Those are the one to do
the trick.
sherzodR
On Mon, 26 Nov 2001, Julio Faerman wrote:
>Hi !
>I have a table with 2 coluns with time values , for example, colum START
>("2001-11-20 23:34:03" , for example) and STOP ("20
Use "%" instead of "*"
cheers
--
sherzodR
On 26 Nov 2001, Harald Fuchs wrote:
>According to the manual, section "New Features of Full-text Search to
>Appear in MySQL 4.0":
>
>* `*' is a truncation operator.
>
>The query
> SELECT COUNT
)
cheers
--
sherzodR
On Mon, 26 Nov 2001, Wakan wrote:
>Hi,
>I'd like to ask for a reply to this (I hope not stupid) question:
>is there a way to set permanently relationship between tables,
>so in that way when I ask for something, Mysql automatically
>joins all tables involve
Does it throw an error message or output isn't what you expected?
In any event, did you try it with "HAVING"?
I couldn't notice anything wrong from what you have there
Cheers
--
sherzodR
On Mon, 26 Nov 2001, Eva Fransson wrote:
>I have an application with man
om1921.htm
Cheers
--
sherzodR
On Mon, 26 Nov 2001, Giulio Borrini - Netbuilder wrote:
>Hi guys,
>
>is there a method in mysql to do a search engines like query and order the
>results
>by relevance?
>i taken a look at MATCH ... AGAINST function but i'm not sure that it's
53 matches
Mail list logo