Re: COLDFUSION AND MYSQL

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 pr

Re: help with syntax of left outer join

smond >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

Re: help with syntax of left outer join

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 wa

help with syntax of left outer join

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

Re: exporting data

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 -

exporting data

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

Re: currency type

quot; <[EMAIL PROTECTED]> >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 mysq

currency type

Hi there Does mysql have a currency type, or is it best to just use a varchar or a float? Thanks Desmond _ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com -

do you need to define not null and unique?

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 AUTO_INCR

RE: graphical interface to mysql on red hat 7.3

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'" <[

RE: help me out here guys... you gotta have a primary key

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

graphical interface to mysql on red hat 7.3

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 th

graphical interface to mysql on red hat 7.3

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 th

graphical interface to mysql on red hat 7.3

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 th

help me out here guys... you gotta have a primary key

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 "linkin

Re: THIS IS NOT AN ADVERTISEMENT

>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.

question about varchars

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

question about varchars

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

Re: Setting up hostname

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 /etc/sysconf

Re: Setting up hostname

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: # D

Setting up hostname

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 stuff.