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
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:
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
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
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'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
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
Since you
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
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
their Price
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
One more thing, very important: I want to specify the Series sort order,
not alphabetically, but by a non-obvious way
(BabyGenesisSuperPredatorMillennium)...
--
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,
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
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 job
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 ...
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 that is presenting a challenge
-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: MySQL ORDER BY or PHP Sort? Oops.
From: René Fournier [EMAIL PROTECTED]
Date: Mon Dec 03, 2001
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: (09) 879 01 67
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 proud of it too
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 user.group /var/lib/mysql/mysql.sock
replace user and group by the user/group
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'm really hurried!
Felipe Baytelman
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
and then
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
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.
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: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 use
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)?
"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 1901
mysql describe main;
++--+--+-+-+---+
-+
| Field | Type | Null | Key | Default | Extra |
Privileges |
28 matches
Mail list logo
