[SQL] Make C file for create type

Hallo, I found a problem making new data type kata,expecially when make the C file ,can anyone help me solve it. This error occur when I'm compiling the C file : /usr/lib/gcc-lib/i586-suse-linux/3.3.1/../../../crt1.o(.text+0x18): In function `_start': ../sysdeps/i386/elf/start.S:98: undefined ref

[SQL] 'select where' using multiple columns.

Hi, I've googled around for this but can't see a decent way of doing this : I've got a persons name which is being stored say in 3 columns :- Title, Forename_1, Forename_2, Surname. I want to allow a search say for 'John Smith'. Problem is I can't just break it up into forename and surname b

Re: [SQL] 'select where' using multiple columns.

Hi. Rob Kirkbride wrote: > I've googled around for this but can't see a decent way of doing this : > > I've got a persons name which is being stored say in 3 columns :- > Title, Forename_1, Forename_2, Surname. I want to allow a search say for > 'John Smith'. Problem is I can't just break it up

Re: [SQL] 'select where' using multiple columns.

RK> Hi, RK> I've googled around for this but can't see a decent way of doing this : RK> I've got a persons name which is being stored say in 3 columns :- RK> Title, Forename_1, Forename_2, Surname. I want to allow a search say for RK> 'John Smith'. Problem is I can't just break it up into fo

Re: [SQL] 'select where' using multiple columns.

Ian Johannesen wrote: Hi. Rob Kirkbride wrote: I've got a persons name which is being stored say in 3 columns :- Title, Forename_1, Forename_2, Surname. I want to allow a search say for 'John Smith'. Problem is I can't just break it up into forename and surname because I won't also know. I

Re: [SQL] 'select where' using multiple columns.

Is there a way to do something like a 'select * where forename_1,forename_2,surname like '%String%' ?? You could try the following, but it won't get a medal for performance... SELECT * FROM xpto WHERE forename_1 LIKE '%String%' OR forename_2 LIKE '%String%' OR surname LIKE '%String%'

Re: [SQL] Make C file for create type

Louise Catherine wrote: Hallo, I found a problem making new data type kata,expecially when make the C file ,can anyone help me solve it. This error occur when I'm compiling the C file : /usr/lib/gcc-lib/i586-suse-linux/3.3.1/../../../crt1.o(.text+0x18): In function `_start': ../sysdeps/i386/el

[SQL] sum but not grouped by?

I have the ff data: id | date | hours AAA07-01-2005 3 AAA07-02-2005 4 BBB07-01-2005 6 BBB07-02-2005 2 BBB07-03-2005 7 Would it be possible to get the ff: id | date | hours | id_t

Re: [SQL] sum but not grouped by?

Quoting Henry Ortega <[EMAIL PROTECTED]>: > I have the ff data: > > id | date | hours > AAA07-01-2005 3 > AAA07-02-2005 4 > BBB07-01-2005 6 > BBB07-02-2005 2 > BBB07-03-2005 7 > > Would it be possible to

Re: [SQL] sum but not grouped by?

Is it possible at all to do this without any joins or subselect? On 8/5/05, Mischa Sandberg <[EMAIL PROTECTED]> wrote: > Quoting Henry Ortega <[EMAIL PROTECTED]>: > > > I have the ff data: > > > > id | date | hours > > AAA07-01-2005 3 > > AAA07-02-2005

Re: [SQL] sum but not grouped by?

On Fri, 05 Aug 2005 19:53:14 +0200, Henry Ortega <[EMAIL PROTECTED]> wrote: Is it possible at all to do this without any joins or subselect? I don't think so. You could always hide them in a view... ---(end of broadcast)--- TIP

[SQL] how to use column name with Case-sensitive with out usig ""

how can i use create table myName( myColumnName varchar(32) ); select myColumnName from myColumnName ; instead create table "myName" ( "myColumnName" varchar(32) ); select "myColumnName" from "myColumnName" ; _ Express yours