Hi,
I have created a survey titled "Slow Computers and Developer
Productivity" with the aim of finding the possible effects of slow
computer performance on developer productivity, behavior, and ROI for
companies. It is a small survey with only 5 items. I have created this
experimental survey for
Siegfried Heintze wrote:
Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find an
Sorry, I accidentally pasted some garbage at the beginning of that last
email message. Here is what I intended:
I first check to see if the record exists:
SELECT cJobTitle FROM jobtitlecount WHERE fkJobPosting = 209689 AND
dtSnapShot = '2005-06-26'
When I don't find an entry, I try an insert:
IN
I have 2 tables set up in MySQL, one with a dialed number field and
duration, the other with a list of country codes, there names, and the
rates. I am trying to match the dialed number with country code. My
problem is I cannot get the results based on the longest possible match?
I am not even sur
In my last post I noted that I am using Opta driver. Wrong. That was my Ms
SQL driver. I am using
mysql-connector-java-2.0.14-bin
Sorry for confusion.
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
--
> I am changing a database and changing the user and password of an
> existing
> database. when I enter the line.
>
> mysql> insert into user (host, user, password) values ('localhost',
> 'newuser', password ('newpswrd'));
>
> the error 1062: Duplicate entry 'localhost-newuser' for key 1
> mysql>
I'm new to mysql but not databases or programming. I followed Julie
Meloni's PHP fast &easy to learn the basics. However, now that I am going
back through the material and trying to make changes, problems are rising
that I can't solve.
I am changing a database and changing the user and passwor
Sorry... I clicked send before pasting. Here is the function I was talking about.
function approvesignup($lid){
global $prefix, $dbi, $signqid, $ev_title, $ev_location, $ev_descrip, $ev_datetime,
$ev_organizer, $ev_contact, $ev_children, $ev_number, $ev_cost, $ev_phone;
sql_query("INSERT into $p
René,
> I want to select about 25 rows from a table, and sort them by two
> criteria. First, by each row's Series field ("Baby", "Genesis", "Super",
> "Predator", "Millennium" are the various Series, and the order I'd like
> the rows in the array). Within each Series, I'd like the rows sorted by
t
> on that?
>
> otherwise you'll have to use php
>
> -Original Message-
> From: René Fournier [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, December 04, 2001 12:16 PM
> To: Benjamin Pflugmann; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [PHP] Re: MySQ
Hi.
On Mon, Dec 03, 2001 at 06:16:26PM -0700, [EMAIL PROTECTED] wrote:
> The problem is, if I sort by the price field, the ordering of the series
> gets mixed up (since low-end models in higher-end series cost more than
> some higher-end models in lower-end series (confused?? I am :-) If I
>
From: René Fournier <[EMAIL PROTECTED]>
Date: Mon Dec 03, 2001 06:11:23 PM US/Mountain
To: Benjamin Pflugmann <[EMAIL PROTECTED]>
Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Subject: Re: MySQL ORDER BY or PHP Sort? Oops.
Here is the snippet of code th
Hi.
Because you said, Rene, that you already know how to sort according to
one of both criteria, I presume ordering the series column is not the
problem (e.g. because it is an enum or something alike).
Then the solution would simply be to do something like
SELECT * FROM my_table WHERE ... ORDER
This would be pretty ugly, but you could adapt a trick that was posted to
the MySQL list back in Sept.
select * from ... where series != "Baby", series != "Genesis", series !=
"Super", etc.
Like I said, ugly, and I don't know how efficient it would be (probably
not very), but it would get the
Well I think mysql doesnt allow you to do this that simple as mysql
doesnt know how you want to sort it exactly. So my suggestion would be to
give a value to each series, eg. Baby = 1,
Genesis=2,Super=3,Predator=4,Millennium=5 and then order by series.
Cheers
Siim Einfeldt
> One more thing
One more thing, very important: I want to specify the Series sort order,
not alphabetically, but by a non-obvious way
(Baby>Genesis>Super>Predator>Millennium)...
--
I want to select about 25 rows from a table, and sort them by two
criteria. First, by each row's Series field ("Baby", "Gene
I think you should be safe to just restart MySQL
On Wednesday 19 September 2001 08:32 am, Felipe Baytelman wrote:
> Oops... I think I deleted mysql.sock - WHAT CAN I DO?
>
> I'm not a linux guy... I don't fly trough this OS...
>
> Could you help me?
>
> I'
Felipe Baytelman <[EMAIL PROTECTED]> writes:
> Oops... I think I deleted mysql.sock - WHAT CAN I DO?
Restarting mysql should recreate the socket.
--
Trond Eivind Glomsrød
Red Hat, Inc.
-
Before posting, please check
So sprach »Felipe Baytelman« am 2001-09-19 um 10:32:14 -0400 :
> Oops... I think I deleted mysql.sock - WHAT CAN I DO?
Become root, and do:
mksock /var/lib/mysql/mysql.sock
chmod 777 /var/lib/mysql/mysql.sock
chown . /var/lib/mysql/mysql.sock
replace and by the user/group the mysql proc
Felipe Baytelman writes:
> Oops... I think I deleted mysql.sock - WHAT CAN I DO?
Just restart mysqld and it'll be created.
--
Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280
[EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/
Amiga user since '89, and damned pr
Oops... I think I deleted mysql.sock - WHAT CAN I DO?
I'm not a linux guy... I don't fly trough this OS...
Could you help me?
I'm really hurried!
Felipe Baytelman
BayTex Producciones
[EMAIL PROTECTED] http://www.baytex.net ICQ: 8188532
Chile:
Date |Wed, 29 Aug 2001 03:33:45 -0400
>From |[EMAIL PROTECTED]
Hello!
G> so, does this mean:
G> siag works in Mac OS X, but in X Windows, i.e., XonX?
yes.
G> and, do i then have to use MySQL for X Windows (XFree86) system also
G> or can i use the same MySQL i have for/on OS X itself?
you can
so, does this mean:
siag works in Mac OS X, but in X Windows, i.e., XonX?
and, do i then have to use MySQL for X Windows (XFree86) system also
or can i use the same MySQL i have for/on OS X itself?
thank you.
At 12:22 PM +0500 8/29/01, Grigory Bakunov wrote:
>Date |Wed, 29 Aug 2001 03:15:50 -
Date |Wed, 29 Aug 2001 03:15:50 -0400
>From |[EMAIL PROTECTED]
Hello!
G> dumb question: what do i put for macintosh G4/450 OS X?
I all case you need 3 things - X Window, gcc, Mysql.
I use Siag on OS/2, MS Windows and all Unixes - so it's
will work with MacOS X.
i untarred the siag app (very cool, hope it'll work) and dropped in
my home dir.
then i ran ./configure, make and make install...
i got:
checking host system type... configure: error: can not guess host
type; you must specify one
configure: error: ./configure failed for XawM
[ichi:~/apps/siag-
Date |Wed, 29 Aug 2001 00:24:25 -0400
>From |[EMAIL PROTECTED]
Hello!
>>i'd like to ask...
>>if any of you are familar with (File Maker Pro, most recent
>>versions)... how does one go about using MySQL to create a printable
>>report? e.g., where you select the fields you wanted in the report
>i'd like to ask...
>if any of you are familar with (File Maker Pro, most recent
>versions)... how does one go about using MySQL to create a printable
>report? e.g., where you select the fields you wanted in the report
>and then create a layout and page setup for the report, (then print
>it)?
mysql> describe main;
++--+--+-+-+---+
-+
| Field | Type | Null | Key | Default | Extra |
Privileges |
++--+--+-+---
"Scott Dunn" <[EMAIL PROTECTED]> wrote:
> I accidentally crashed 1 of my tables. So I deleted everything in the
table
> and tried to reload the data into the table and now I get this error:
> Query OK, 1 row affected (0.02 sec)
> Records: 1 Deleted: 0 Skipped: 0 Warnings: 5
>
> I have a total of 1
I accidentally crashed 1 of my tables. So I deleted everything in the table
and tried to reload the data into the table and now I get this error:
Query OK, 1 row affected (0.02 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 5
I have a total of 1901 records in this txt file. I puts the first reco
30 matches
Mail list logo