i got it... needed to convert the text column...
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 11:17 AM
To: CF-Talk
Subject: RE: ListGetAt in a SQL Select Statement... is this possible?
nope... that does not work...
-Original
nope... that does not work...
-Original Message-
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 11:10 AM
To: CF-Talk
Subject: Re: ListGetAt in a SQL Select Statement... is this possible?
does SQLServer have the aggregate fuction max()?
if so.. this will
Sent: Wednesday, April 27, 2005 10:42 AM
> To: CF-Talk
> Subject: RE: ListGetAt in a SQL Select Statement... is this possible?
>
> Even so, it is not likely to be over 2 Billion Characters in length is it?
>
>
CTED]
Sent: 27 April 2005 16:00
To: CF-Talk
Subject: RE: ListGetAt in a SQL Select Statement... is this possible?
i agree. while i got ya replying to my emails, what would be the easiest way
to find the longest length of characters within this field and then convert
the 'text' column to
ListGetAt in a SQL Select Statement... is this possible?
Neil, this may work. Are SQL UDF's hard to set up?
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 10:26 AM
To: CF-Talk
Subject: RE: ListGetAt in a SQL Select Statement
o, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 10:42 AM
To: CF-Talk
Subject: RE: ListGetAt in a SQL Select Statement... is this possible?
Even so, it is not likely to be over 2 Billion Characters in length is it?
~~
e issues with using charindex on a 'text' field. ugh
> again...
>
> Che
>
> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 27, 2005 10:28 AM
> To: CF-Talk
> Subject: Re: ListGetAt in a SQL Select Stateme
Even so, it is not likely to be over 2 Billion Characters in length is it?
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: 27 April 2005 15:42
To: CF-Talk
Subject: RE: ListGetAt in a SQL Select Statement... is this possible?
its way more than just an address. and
Neil, this may work. Are SQL UDF's hard to set up?
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 10:26 AM
To: CF-Talk
Subject: RE: ListGetAt in a SQL Select Statement... is this possible?
You can do this easily in SQL S
Dunno...TEXT datatypes don't cast that well - well not implicitly they
don't.
-Original Message-
From: Adam Haskell [mailto:[EMAIL PROTECTED]
Sent: 27 April 2005 15:39
To: CF-Talk
Subject: Re: ListGetAt in a SQL Select Statement... is this possible?
TEXT for an address?
har'.
> i think there would be issues with using charindex on a 'text' field. ugh
> again...
>
> Che
>
> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 27, 2005 10:28 AM
> To: CF-Talk
> Subject: Re:
> i think there would be issues with using charindex on a 'text' field. ugh
> again...
>
> Che
>
> -Original Message-
> From: Greg Morphis [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 27, 2005 10:28 AM
> To: CF-Talk
> Subject: Re: ListGetAt i
: Wednesday, April 27, 2005 10:28 AM
To: CF-Talk
Subject: Re: ListGetAt in a SQL Select Statement... is this possible?
I think you could use pretty much the same thing.. SQLServer has the
substring funstion but uses the Charindex (I think) to find the start
position..
So you might want to try so
-Original Message-
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: 27 April 2005 15:25
To: CF-Talk
Subject: RE: ListGetAt in a SQL Select Statement... is this possible?
Hopefully... I asked this once before a couple of years ago, but frankly,
the solution was a little difficult for
I think you'll have th reverse the charindex to this..
charindex('~',mycol) not the way I have above.
On 4/27/05, Greg Morphis <[EMAIL PROTECTED]> wrote:
> I think you could use pretty much the same thing.. SQLServer has the
> substring funstion but uses the Charindex (I think) to find the start
>
I think you could use pretty much the same thing.. SQLServer has the
substring funstion but uses the Charindex (I think) to find the start
position..
So you might want to try something like :
substring(mycol, charindex(mycol, '~'), len(mycol - charindex(mycol, '~'))
this hasnt been tested, so it m
Hopefully... I asked this once before a couple of years ago, but frankly,
the solution was a little difficult for me to figure out.
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 10:17 AM
To: CF-Talk
Subject: Re: ListGetAt in a SQL Select
I was once told that dealing with a list of data in MSSQL was easier than in
Oracle. Perhaps someone well versed in MSSQL could chime in with a solution.
It probably is not as hard as you think it will be to get done.
On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
>
> Aaron/Greg... I have
: ListGetAt in a SQL Select Statement... is this possible?
What DBMS do you have? Access? I'm sure they have similar functions
On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
> ugh, I knew this would be hard to do withbasic SQL...
>
> -Original Message-
> From: Aar
ay, April 27, 2005 9:53 AM
> To: CF-Talk
> Subject: Re: ListGetAt in a SQL Select Statement... is this possible?
>
> I do it in Oracle through a couple of different ways but almost always
> narrows down to a UDF in Oracle. Comes down to use of the SUBSTR and INSTR
> functions to fin
Sent: Wednesday, April 27, 2005 9:53 AM
> To: CF-Talk
> Subject: Re: ListGetAt in a SQL Select Statement... is this possible?
>
> I do it in Oracle through a couple of different ways but almost always
> narrows down to a UDF in Oracle. Comes down to use of the SUBSTR and INSTR
> f
Of course you could return the whole value and then preform the
listGetAt on the column but like Aaron said, we normally use Oracle
too for things like that. Pull the data correctly out of the DBMS and
no fooling with later
On 4/27/05, Aaron Rouse <[EMAIL PROTECTED]> wrote:
> I do it in Oracle thr
ugh, I knew this would be hard to do withbasic SQL...
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 27, 2005 9:53 AM
To: CF-Talk
Subject: Re: ListGetAt in a SQL Select Statement... is this possible?
I do it in Oracle through a couple of different
I do it in Oracle through a couple of different ways but almost always
narrows down to a UDF in Oracle. Comes down to use of the SUBSTR and INSTR
functions to find positionings to pull out the data.
On 4/27/05, Che Vilnonis <[EMAIL PROTECTED]> wrote:
>
> Is something like this possible in SQL?
Is something like this possible in SQL? If so, how?
SELECT OrderID, listGetAt(FinalBillTo,2,"~") FROM Orders WHERE CustID = 1234
Thanks, Che
~|
Find out how CFTicket can increase your company's customer support
efficiency by
25 matches
Mail list logo
