Hi marco
In the administration page of coldfusion, usually something like:
http://domainName/CFIDE/administrator/index.cfm?target=/CFIDE/administrator/welcome.cfm
go to your data sources and click the edit button. THen click the show
advance settings button. Make sure that the Allowed sql
Hi there
I want to do a left outer join but i also have a bunch of where conditions
in my sql statment that i need. Can anyone help me out:
SELECT title, authorName, journalName, journalPages, aname, tname,
avg(ranking)
FROM publications, area, topic, pubTopicInt,
LEFT OUTER
AND
publications.pubID = 3
GROUP BY (publications.pubID);
Thanks
Desmond
From: Desmond Lee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help with syntax of left outer join
Date: Tue, 13 Aug 2002 14:34:06 -0700
Hi there
I want to do a left outer join but i also have a bunch of where conditions
From: Desmond Lee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: help with syntax of left outer join
Date: Tue, 13 Aug 2002 14:34:06 -0700
Hi there
I want to do a left outer join but i also have a bunch of where conditions
in my sql statment that i need. Can anyone help me out:
SELECT
Hi guys
I know that you can import data into a table by using 'load data infile' or
'mysql' import.
however, is there something that allows you to export the create statemtns
for the table schema and the data of a database for backup. SO that if we
reinstall the whole thing from scratch all
Thanks Jeremy :)
From: Jeremy Zawodny [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Desmond Lee [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: exporting data
Date: Fri, 2 Aug 2002 15:59:01 -0700
On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote:
Hi guys
I know
Hi there
Does mysql have a currency type, or is it best to just use a varchar or a
float?
Thanks
Desmond
_
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com
]
Reply-To: [EMAIL PROTECTED]
To: Desmond Lee [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: currency type
Date: Tue, 30 Jul 2002 11:36:30 -0500
Desmond Lee wrote:
Hi there
Does mysql have a currency type, or is it best to just use a varchar or
a
float?
Thanks
Desmond
I
Hello
Just wnated to calrify something here.
If you define your id in a table to be a primary key, do you also need to
define it as 'NOT NULL' and 'UNIQUE'.
I've notice in some examples like the following off the mysql site:
CREATE TABLE animals (
id MEDIUMINT NOT NULL
Hi there
I'm doing fine with the command line interface of mysql, no complaints from
me. Howerver, another team member who knows nothign about mysql is more
familiar with the windows stuff like access. Is there an graphical interface
for mysql on red hat v7.3? I figured i'd ask here because
Hi there
I'm doing fine with the command line interface of mysql, no complaints from
me. Howerver, another team member who knows nothign about mysql is more
familiar with the windows stuff like access. Is there an graphical interface
for mysql on red hat v7.3? I figured i'd ask here because
Hi there
I'm doing fine with the command line interface of mysql, no complaints from
me. Howerver, another team member who knows nothign about mysql is more
familiar with the windows stuff like access. Is there an graphical interface
for mysql on red hat v7.3? I figured i'd ask here because
Hi Eric
I dunno why people make 100 field tables, sounds a little harsh. I'll keep
you in mind the next time i wanna make a 100 field table.
Anyways, just to let you know mysql 4 will be supporting foreign key
constraints. And yes thoes other db technologies like postGrep already
support key
Ya... i'll give it a try, thanks :)
But do you know of any free graphical interfaces for linux that are not
browser based?
Thanks again (fast reply to )
desmond
From: Shashank Tripathi [EMAIL PROTECTED]
To: 'Desmond Lee' [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: RE: graphical interface
k
This is seems ridiculous to me,.. but i'll let you tell me if i'm just being
stubborn.
So, one of my associates has made a linking table (some people also call it
intersection table, cross tab table, but i believe that the propper way to
model a many to many relationship is via a
Hello there
Mysql documentation says the following:
values are stored using only as many characters as are needed, plus one
byte to record the length. Values are not padded; instead, trailing spaces
are removed when values are stored.
So, then would there be anything wrong with making all
Hello there
Mysql documentation says the following:
values are stored using only as many characters as are needed, plus one
byte to record the length. Values are not padded; instead, trailing spaces
are removed when values are stored.
So, then would there be anything wrong with making all
From: [EMAIL PROTECTED]
To: Desmond Lee [EMAIL PROTECTED]
Subject: Re: THIS IS NOT AN ADVERTISEMENT Date: Thu, 25 Jul 2002 03:37:48
+0200
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one
Hi
Thanks for all your help, much appreciated.
I edited my both the /etc/resolv.conf and /etc/hosts to include the line
'hostname 142.135.134.154'
of course, that's not my real ip addy. Am i suppose to edit these files? or
did you mean to edit the /etc/sysconfig/network file. THe
Hi there
Thanks for your reply.
check your system configuration ...
just run from shell script : hostname
and what does it show you ...
WHen i run 'hostname' i get my ip address shown to me.
and then check your /etc/hosts and /etc/resolv.conf
my /etc/hosts has the following in it:
# Do
Hi guys
I just managed to install mysql... yippy
But, i had to use the '--force option' when executing the
/usr/local/mysql/scripts/mysql_install_db .
I got a message saying that i needed to configure the hostname latter on.
So, now that mysql is isntalled i need to set up the hostname
21 matches
Mail list logo