| |
thread by: Steven |
last post Oct 21 '05 by: Steven
Genuine College Degree in 2 Weeks!
Have you ever thought that the only thing stopping you from
a great job and better pay was a few letters behind your name?
Well now you can get them!
BA BSc MA MSc MBA PHD
Within 2 weeks!
|
thread by: anonymous |
last post Oct 21 '05 by: Markus Popp
Hey guys,
Putting it simply, here is my situation
I have one table with records like this:
+--------+------+------+
| index | name | style|
+--------+------+------+
| 1 | 7 | 110 |
| 2 | 23 | 343 |
|
thread by: Sonya Ayala |
last post Oct 21 '05 by: Sonya Ayala
X-Priority: 3
X-MSMail-Priority: Normal
-------=134_0850_7V350V86.96VK945W
Content-Type: text/html;
Content-Transfer-Encoding: quoted-printable
<html><head><style>body{font-family:verdana}</style></head>
<body bgcolor=3D"white" text=3D"brown" leftmargin=3D"10" topmargin=3D"10" =
marginwidth=3D"10" marginheight=3D"10">
|
thread by: g_chime |
last post Oct 20 '05 by: Bill Karwin
I have a large table (~200 columns, ~10 million rows) and I am trying
to query by two float rows, say f1 and f2:
SELECT... FROM large_table WHERE f1 BETWEEN 10.82 AND 113.998 AND f2
BETWEEN -124.99 AND 23.5;
The query is extremely slow; it takes hours.
|
thread by: Rajeev |
last post Oct 19 '05 by: Rajeev
Dear friends,
Apologies in advance if I have mailed the wrong group.
I am conducting a survey on Relational Database usage in organisations
and would like your help. The study is part of my MBA Dissertation.
Could you kindly spare 5 minutes to take part in this survey? Kindly
fill in all parts of the questions.
|
thread by: Dave Brown |
last post Oct 19 '05 by: Dave Brown
Hi All,
Trying to get a simple query going using group by and order by
I need to retrieve the latest record ordered by datetimestamp desc but
grouped by my nodeID column...
my data is thus;
7000802818, 2005-10-10 17:13:43
|
thread by: sedawk |
last post Oct 19 '05 by: Brandon Rohde
I have a table which holds the results from game scores.
It has the following columns:
gameID : team1Score : team2Score
I'd like to produce output that calculates the following:
# Games played
# Wins
# Losses
|
| |
thread by: Jackson |
last post Oct 18 '05 by: Jackson
This is a multi-part message in MIME format.
------=_NextPart_000_0114_01C5D404.3BFD4960
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7Bit
You have 2 options here,
Option 1 - You can put ANY text you want in here.
|
thread by: DG |
last post Oct 18 '05 by: Thomas Bartkus
Hi,
Can anyone advise how to execute multiple statements in a single query
batch. For example-
update customers set customer_name = 'Smith' where customer_name =
'Smyth';
select * from customers;
I can execute each statement individually but get the 'you have an error in
|
thread by: Pras |
last post Oct 18 '05 by: www.1-script.com
SELECT
R.Resource_ID,
R.ResourceName,
R.ResourceGLT_ID,
R.ResourceNiku_Id,
T.Technology_Code AS TechnologyArea,
T2.Technology_Code AS TechnologyArea2,
T3.Technology_Code AS TechnologyArea3,
R.SeatNo,
'' as Location, '' AS Country,
|
thread by: phil |
last post Oct 18 '05 by: phil
I am having a problem with the C api with prepared statements, the data
recorded in the database does not match the data I am sending. It seems to
be some sort of bit shifted version of the data, and I have no idea why.
I am including code I have been using to test this, followed by the output
in the database.
I am using mysql version...
|
thread by: radicool |
last post Oct 18 '05 by: Bill Karwin
What is the User ID and Password for querying Follett's TextLink database.
I am using Adaptive Server Anywhere. If this is not the best group to
ask this, where would be?
|
thread by: Matt |
last post Oct 17 '05 by: Matt
here's some more code i inherited on a project:
function set_background(pic){
if(pic==""){
if(ie4)over.backgroundImage="none";
if(ns6)over.style.backgroundImage="none";
}else{
if(ns4){
over.background.src=pic;
}else if(ie4){
|
thread by: Manish Pandit |
last post Oct 17 '05 by: Manish Pandit
Hi,
I have tried looking for a solution to this problem but no luck. The
thing is, in my system, I have a set of users who have a 'quota'
limiting their usage. They can create n number of tables and put m
number of rows in it, but at the end, their 'usage' can not exceed,
lets say, x MB. My problem is, how to I evaluate the space being...
|
thread by: Matt |
last post Oct 17 '05 by: Matt
I am making a copy of a dB on my local machine so I can work on the
interface. But the username/password combination -- which works on the
"live" site -- doesn't work on my local machine. Is there something
about the PASSWORD() fxn in mysql that is specific to the installation?
|
| |
thread by: Blake Mandelbaum |
last post Oct 16 '05 by: Blake Mandelbaum
bgc
----mDuNni7bWv1kUF0gGK
Content-Type: text/html;
Content-Transfer-Encoding: quoted-printable
<html><head><style type=3Dtext/css>.eyebrow { FONT-WEIGHT: bold; FONT-SIZE=
: 10px; TEXT-TRANSFORM: uppercase; COLOR: #ffffff; FONT-FAMILY: verdana,ar=
ial,helvetica,sans-serif; TEXT-DECORATION: none } A.eyebrow:link { TEXT-DE=
CORATION: none...
|
thread by: Joe Makowiec |
last post Oct 16 '05 by: Markus Popp
MySQL 4.14 on FC4
I have a database for a soccer team; simplified:
Roster
- serial (bigint)
- name (varchar)
goals
- serial (bigint)
- gameNumber (bigint) // for linking to a schedule
|
thread by: J Mox |
last post Oct 16 '05 by: J Mox
Hi, I am creating a user name system in which each user is assigned 100 different types of
permissions. Is it better to create a table with one row for each user and 101 columns (1 for userid
and 100 for permission values) or 3 columns (1 for userid, 1 for permission id, one for permission
value) and then 100 rows for each user or something...
|
thread by: |
last post Oct 15 '05 by: Markus Popp
hi,
How would I query my table to return only the records where the field
'mobile' has a valid mobile telephone number.
Valid meaning begining with 07 and being 11 characters in length.
many thanks,
Dave
|
thread by: Ian Davies |
last post Oct 15 '05 by: Stefan Berglund
Hello
My host does not allow external connections to my MySQL database on their
server from a remote computer. I would like users of my VB application to be
able to add records from a table on said database to their local MySQL
database. Can anyone advise me of my options to solve this one (appart from
changing host)?
Thanks
Ian
|
thread by: Wire |
last post Oct 15 '05 by: Wire
Hello
I want to sum these records on month(datum) and device and get then get
the min and max values and the associated low high date/times
this does not work
select month(datum) as t,device,time_hoog ,max(hoog),time_laag,
min(laag) from weerdavis group by month(datum), device
With this select i get the high value time but not the...
|
thread by: Ian Davies |
last post Oct 14 '05 by: Ralph
Hello
Apologies for posting to so many groups but this one is difficult to
catagorize precisely
The following code worked fine with a connection to an Access database.
However, I have changed over to MySQL and am getting syntax error messages
with my code.
adoSetRS.Open "select , from tSet WHERE StatusID = 1 Order
by Set", db,...
|
thread by: kreeves |
last post Oct 14 '05 by: Gordon Burditt
I am running a long query that has a combination of results.
The results that I'm sorting by is the "Room Number". This room number
could be a number or even something like "Office". (This information
is used for schools, and their rooms aren't always labelled by true
numbers.).
The problem I am having is ... the numbers will not sort...
|
| |
thread by: Greg |
last post Oct 14 '05 by: Greg
Hi All-
I have searched around a bit and haven't found anything that addresses
my exact question...
I have a db that is moderately busy (a couple million records added
over a day, 60-300 db hits per second, average about 120 or so).
The database is in constant use and the server can't be stopped under
normal circumstances.
|
thread by: iksrazal |
last post Oct 14 '05 by: Bill Karwin
Hi all,
My app needs to access two db instances - one running 4.1, and another
running 5.0 so I can use stored procedures. For testing I want to do
this on the same machine.
Question: How can I run 4.1 and 5.0 simultaneously on linux - Suse 9.3
in particular? My goal is to do no harm to my current 4.1 setup. Can
the 4.1 and 5.0 rpm's...
|