Re: (ot) Anyone looking for a UX / UI Expert in Los Angeles?

[Larry Lyons]

At the risk of Michael D getting ticked off at us I'll at to the OT. Why not 
post his info to CF-Jobs?

regards,
larry

> Really sorry about the Off Topic, but I guess some of you will be 
> dealing with this.  
> 
> A good friend and ex coleague of mine is moving to LA this week and I 
> know he is awesome in the UX / UI areas of web development. Anyone out 
> there looking for someone with those skills over in LA?
> 
> Many thanks for reading!
> 
> Mark Drew
> Railo Technologies UK
> Professional Open Source
> skype:mark_railo
> email:m...@getrailo.com
> gtalk:m...@getrailo.com
> tel:  +44 7971 85  22 96
> tel (int):+13474485715
> web:  http://www.getrailo.co


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338964
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: (ot) Anyone looking for a UX / UI Expert in Los Angeles?

[John M Bliss]

Not personally but here're 1,200 of them:
http://www.indeed.com/jobs?q=%22user+experience%22+OR+%22user+interface%22&l=Los+Angeles,+CA

I
also found 50 on linkedin.com

On Mon, Nov 8, 2010 at 9:14 AM, Mark Drew  wrote:

>
> Really sorry about the Off Topic, but I guess some of you will be dealing
> with this.
>
> A good friend and ex coleague of mine is moving to LA this week and I know
> he is awesome in the UX / UI areas of web development. Anyone out there
> looking for someone with those skills over in LA?
>
> Many thanks for reading!
>
> Mark Drew
> Railo Technologies UK
> Professional Open Source
> skype:  mark_railo
> email:  m...@getrailo.com
> gtalk:  m...@getrailo.com
> tel:+44 7971 85  22 96
> tel (int):  +13474485715
> web:http://www.getrailo.co
>
>
> 

~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338942
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

(ot) Anyone looking for a UX / UI Expert in Los Angeles?

[Mark Drew]

Really sorry about the Off Topic, but I guess some of you will be dealing with 
this.  

A good friend and ex coleague of mine is moving to LA this week and I know he 
is awesome in the UX / UI areas of web development. Anyone out there looking 
for someone with those skills over in LA?

Many thanks for reading!

Mark Drew
Railo Technologies UK
Professional Open Source
skype:  mark_railo
email:  m...@getrailo.com
gtalk:  m...@getrailo.com
tel:+44 7971 85  22 96
tel (int):  +13474485715
web:http://www.getrailo.co


~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338941
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: expert sql challenge

[Judah McAuley]

On Tue, Apr 14, 2009 at 3:47 PM, Barney Boisvert  wrote:
> Did they have an example of a query equivalent to mine that uses the
> data function?  Because it seems like that'd probably be more
> efficient than going through an XML process.

MSDN actually used almost exactly what you wrote. If you go to the MSDN page:
http://msdn.microsoft.com/en-us/library/ms189885(SQL.90).aspx

And look down for "C. Generating a value list using PATH mode" it
shows their example.

The only real difference is that they were using AS "data()" which I
am not familiar with. It might be because the result returned from the
subquery in their example is being put into a tsql variable and then
used in another xml path query.

Here is the subquery in their example:

 (SELECT ProductID as "data()"
   FROM   Production.Product
   WHERE  Production.Product.ProductModelID =
  Production.ProductModel.ProductModelID
   FOR XML PATH ('')) as "@ProductIDs"

Cheers
Judah


> On Tue, Apr 14, 2009 at 3:13 PM, Judah McAuley  wrote:
>>
>> Barney, that TSQL is brilliant. I've never used the Stuff function and
>> had only used FOR XML PATH when generating xml. I had to go look at
>> the books online and sure enough they have an example turning results
>> into a value list in the same way that you are although they do the
>> select as data(). I'm not familiar with the data() function and why
>> they would use it but your query doesn't Would you mind elaborating?
>>
>> And for those interested in what I'm talking about his Barney's use of
>> FOR XML PATH, the msdn reference is here:
>> http://msdn.microsoft.com/en-us/library/ms189885(SQL.90).aspx
>>
>> Thanks,
>> Judah
>>
>> On Tue, Apr 14, 2009 at 1:20 PM, Barney Boisvert  wrote:
>>>
>>> Here you go.  Note that they're not really semantically equivalent,
>>> they just happen to return the same results.  The approach for
>>> obtaining the result is completely different, and the MS SQL one,
>>> while less direct for the actual comma separate list creation, is far
>>> more expressive for what you're actually trying to accomplish (i.e.
>>> uses a correlated subquery instead of a grouped join).
>>>
>>> MySQL:
>>> select name, group_concat(phone) as phones
>>> from client
>>>  inner join phone on client.id = phone.clientId
>>> group by name
>>>
>>> MS SQL Server:
>>> select name,
>>> stuff((
>>>  select distinct ',' + phone
>>>  from phone
>>>  where clientId = client.id
>>>  for xml path ('')
>>> ), 1, 1, '') as phones
>>> from client
>>>
>>> cheers,
>>> barneyb
>>>
>>> On Tue, Apr 14, 2009 at 12:31 PM, C. Hatton Humphrey
>>>  wrote:
>>>>
>>>> Is there a MSSQL version of that puppy?
>>>>
>>>> On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews  
>>>> wrote:
>>>>>
>>>>> Nice. So group_concat works sort of like ColdFusion's valuelist method. 
>>>>> Very
>>>>> nice indeed!
>>>>>
>>>>> -Original Message-
>>>>> From: Richard White [mailto:rich...@j7is.co.uk]
>>>>> Sent: Tuesday, April 14, 2009 2:59 PM
>>>>> To: cf-talk
>>>>> Subject: Re: expert sql challenge
>>>>>
>>>>>
>>>>> thanks for all your replies.
>>>>>
>>>>> barney, yes we are using mysql and didnt even know about the qroup_concat.
>>>>> it works like a dream and where this task was taking 23 seconds to 
>>>>> complete
>>>>> it is now taking a matter of milliseconds :)
>>>>>
>>>>> fantastic and thanks once again for all your replies :)
>>>>>
>>>>>>What DB are you using?  If it's MySQL, you can use this:
>>>>>>
>>>>>>select client.name, group_concat(clientphone.number) as phone numbers
>>>>>>from client
>>>>>>  left outer join clientphone on client.id = clientphone.clientId group
>>>>>>by client.name
>>>>>>
>>>>>>If it's MS SQL Server you can use a subquery with FOR XML PATH and
>>>>>>STUFF to approximate the same functionality.  Don't know about other
>>>>>>platforms.
>>>>>>
>>>>>>At the very least, pull a single recordset with the same JOIN as above,
>>>>>>but no GROUP BY, and then you can do the "rollup" in a single CFOUTPUT
>>>>>>loop.  That'll save you a lot of trips to the DB, and therefor a lot of
>>>>>>wasted time.
>>>>>>
>>>>>>cheers,
>>>>>>barneyb
>>>>>>
>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321600
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[Barney Boisvert]

I don't know about the data function.  I try to avoid SQL Server when
I can.  ;)  We use it for some projects with MySQL's query language
wasn't rich enough to express certain types of queries, but in general
I use MySQL when possible.

Did they have an example of a query equivalent to mine that uses the
data function?  Because it seems like that'd probably be more
efficient than going through an XML process.

cheers,
barneyb

On Tue, Apr 14, 2009 at 3:13 PM, Judah McAuley  wrote:
>
> Barney, that TSQL is brilliant. I've never used the Stuff function and
> had only used FOR XML PATH when generating xml. I had to go look at
> the books online and sure enough they have an example turning results
> into a value list in the same way that you are although they do the
> select as data(). I'm not familiar with the data() function and why
> they would use it but your query doesn't Would you mind elaborating?
>
> And for those interested in what I'm talking about his Barney's use of
> FOR XML PATH, the msdn reference is here:
> http://msdn.microsoft.com/en-us/library/ms189885(SQL.90).aspx
>
> Thanks,
> Judah
>
> On Tue, Apr 14, 2009 at 1:20 PM, Barney Boisvert  wrote:
>>
>> Here you go.  Note that they're not really semantically equivalent,
>> they just happen to return the same results.  The approach for
>> obtaining the result is completely different, and the MS SQL one,
>> while less direct for the actual comma separate list creation, is far
>> more expressive for what you're actually trying to accomplish (i.e.
>> uses a correlated subquery instead of a grouped join).
>>
>> MySQL:
>> select name, group_concat(phone) as phones
>> from client
>>  inner join phone on client.id = phone.clientId
>> group by name
>>
>> MS SQL Server:
>> select name,
>> stuff((
>>  select distinct ',' + phone
>>  from phone
>>  where clientId = client.id
>>  for xml path ('')
>> ), 1, 1, '') as phones
>> from client
>>
>> cheers,
>> barneyb
>>
>> On Tue, Apr 14, 2009 at 12:31 PM, C. Hatton Humphrey
>>  wrote:
>>>
>>> Is there a MSSQL version of that puppy?
>>>
>>> On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews  
>>> wrote:
>>>>
>>>> Nice. So group_concat works sort of like ColdFusion's valuelist method. 
>>>> Very
>>>> nice indeed!
>>>>
>>>> -Original Message-
>>>> From: Richard White [mailto:rich...@j7is.co.uk]
>>>> Sent: Tuesday, April 14, 2009 2:59 PM
>>>> To: cf-talk
>>>> Subject: Re: expert sql challenge
>>>>
>>>>
>>>> thanks for all your replies.
>>>>
>>>> barney, yes we are using mysql and didnt even know about the qroup_concat.
>>>> it works like a dream and where this task was taking 23 seconds to complete
>>>> it is now taking a matter of milliseconds :)
>>>>
>>>> fantastic and thanks once again for all your replies :)
>>>>
>>>>>What DB are you using?  If it's MySQL, you can use this:
>>>>>
>>>>>select client.name, group_concat(clientphone.number) as phone numbers
>>>>>from client
>>>>>  left outer join clientphone on client.id = clientphone.clientId group
>>>>>by client.name
>>>>>
>>>>>If it's MS SQL Server you can use a subquery with FOR XML PATH and
>>>>>STUFF to approximate the same functionality.  Don't know about other
>>>>>platforms.
>>>>>
>>>>>At the very least, pull a single recordset with the same JOIN as above,
>>>>>but no GROUP BY, and then you can do the "rollup" in a single CFOUTPUT
>>>>>loop.  That'll save you a lot of trips to the DB, and therefor a lot of
>>>>>wasted time.
>>>>>
>>>>>cheers,
>>>>>barneyb
>>>>>
>>>>>
>>>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321599
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[Judah McAuley]

Barney, that TSQL is brilliant. I've never used the Stuff function and
had only used FOR XML PATH when generating xml. I had to go look at
the books online and sure enough they have an example turning results
into a value list in the same way that you are although they do the
select as data(). I'm not familiar with the data() function and why
they would use it but your query doesn't Would you mind elaborating?

And for those interested in what I'm talking about his Barney's use of
FOR XML PATH, the msdn reference is here:
http://msdn.microsoft.com/en-us/library/ms189885(SQL.90).aspx

Thanks,
Judah

On Tue, Apr 14, 2009 at 1:20 PM, Barney Boisvert  wrote:
>
> Here you go.  Note that they're not really semantically equivalent,
> they just happen to return the same results.  The approach for
> obtaining the result is completely different, and the MS SQL one,
> while less direct for the actual comma separate list creation, is far
> more expressive for what you're actually trying to accomplish (i.e.
> uses a correlated subquery instead of a grouped join).
>
> MySQL:
> select name, group_concat(phone) as phones
> from client
>  inner join phone on client.id = phone.clientId
> group by name
>
> MS SQL Server:
> select name,
> stuff((
>  select distinct ',' + phone
>  from phone
>  where clientId = client.id
>  for xml path ('')
> ), 1, 1, '') as phones
> from client
>
> cheers,
> barneyb
>
> On Tue, Apr 14, 2009 at 12:31 PM, C. Hatton Humphrey
>  wrote:
>>
>> Is there a MSSQL version of that puppy?
>>
>> On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews  
>> wrote:
>>>
>>> Nice. So group_concat works sort of like ColdFusion's valuelist method. Very
>>> nice indeed!
>>>
>>> -Original Message-
>>> From: Richard White [mailto:rich...@j7is.co.uk]
>>> Sent: Tuesday, April 14, 2009 2:59 PM
>>> To: cf-talk
>>> Subject: Re: expert sql challenge
>>>
>>>
>>> thanks for all your replies.
>>>
>>> barney, yes we are using mysql and didnt even know about the qroup_concat.
>>> it works like a dream and where this task was taking 23 seconds to complete
>>> it is now taking a matter of milliseconds :)
>>>
>>> fantastic and thanks once again for all your replies :)
>>>
>>>>What DB are you using?  If it's MySQL, you can use this:
>>>>
>>>>select client.name, group_concat(clientphone.number) as phone numbers
>>>>from client
>>>>  left outer join clientphone on client.id = clientphone.clientId group
>>>>by client.name
>>>>
>>>>If it's MS SQL Server you can use a subquery with FOR XML PATH and
>>>>STUFF to approximate the same functionality.  Don't know about other
>>>>platforms.
>>>>
>>>>At the very least, pull a single recordset with the same JOIN as above,
>>>>but no GROUP BY, and then you can do the "rollup" in a single CFOUTPUT
>>>>loop.  That'll save you a lot of trips to the DB, and therefor a lot of
>>>>wasted time.
>>>>
>>>>cheers,
>>>>barneyb
>>>>
>>>>
>>>>>
>>>
>>>
>>>
>>>
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321596
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: expert sql challenge

[Barney Boisvert]

Here you go.  Note that they're not really semantically equivalent,
they just happen to return the same results.  The approach for
obtaining the result is completely different, and the MS SQL one,
while less direct for the actual comma separate list creation, is far
more expressive for what you're actually trying to accomplish (i.e.
uses a correlated subquery instead of a grouped join).

MySQL:
select name, group_concat(phone) as phones
from client
  inner join phone on client.id = phone.clientId
group by name

MS SQL Server:
select name,
stuff((
  select distinct ',' + phone
  from phone
  where clientId = client.id
  for xml path ('')
), 1, 1, '') as phones
from client

cheers,
barneyb

On Tue, Apr 14, 2009 at 12:31 PM, C. Hatton Humphrey
 wrote:
>
> Is there a MSSQL version of that puppy?
>
> On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews  
> wrote:
>>
>> Nice. So group_concat works sort of like ColdFusion's valuelist method. Very
>> nice indeed!
>>
>> -Original Message-
>> From: Richard White [mailto:rich...@j7is.co.uk]
>> Sent: Tuesday, April 14, 2009 2:59 PM
>> To: cf-talk
>> Subject: Re: expert sql challenge
>>
>>
>> thanks for all your replies.
>>
>> barney, yes we are using mysql and didnt even know about the qroup_concat.
>> it works like a dream and where this task was taking 23 seconds to complete
>> it is now taking a matter of milliseconds :)
>>
>> fantastic and thanks once again for all your replies :)
>>
>>>What DB are you using?  If it's MySQL, you can use this:
>>>
>>>select client.name, group_concat(clientphone.number) as phone numbers
>>>from client
>>>  left outer join clientphone on client.id = clientphone.clientId group
>>>by client.name
>>>
>>>If it's MS SQL Server you can use a subquery with FOR XML PATH and
>>>STUFF to approximate the same functionality.  Don't know about other
>>>platforms.
>>>
>>>At the very least, pull a single recordset with the same JOIN as above,
>>>but no GROUP BY, and then you can do the "rollup" in a single CFOUTPUT
>>>loop.  That'll save you a lot of trips to the DB, and therefor a lot of
>>>wasted time.
>>>
>>>cheers,
>>>barneyb
>>>
>>>
>>>>
>>
>>
>>
>>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321593
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[Scott Stroz]

Here is an Oracle UDF (for lack of a better description) that I just found.

create or replace function join
(
  p_cursor sys_refcursor,
  p_del varchar2 := ','
) return varchar2
is
  l_value varchar2(32767);
  l_result varchar2(32767);
begin
  loop
  fetch p_cursor into l_value;
  exit when p_cursor%notfound;
  if l_result is not null then
  l_result := l_result || p_del;
  end if;
  l_result := l_result || l_value;
  end loop;
  return l_result;
end join;

Syntax: join(cursor(select name form users)).  If you eant to change the
default delim (which is a comma) you would do this: join(cursor(select name
form users), '|')
On Tue, Apr 14, 2009 at 3:31 PM, C. Hatton Humphrey wrote:

>
> Is there a MSSQL version of that puppy?
>
> On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews 
> wrote:
> >
> > Nice. So group_concat works sort of like ColdFusion's valuelist method.
> Very
> > nice indeed!
> >
> > -Original Message-
> > From: Richard White [mailto:rich...@j7is.co.uk]
> > Sent: Tuesday, April 14, 2009 2:59 PM
> > To: cf-talk
> > Subject: Re: expert sql challenge
> >
> >
> > thanks for all your replies.
> >
> > barney, yes we are using mysql and didnt even know about the
> qroup_concat.
> > it works like a dream and where this task was taking 23 seconds to
> complete
> > it is now taking a matter of milliseconds :)
> >
> > fantastic and thanks once again for all your replies :)
> >
> >>What DB are you using?  If it's MySQL, you can use this:
> >>
> >>select client.name, group_concat(clientphone.number) as phone numbers
> >>from client
> >>  left outer join clientphone on client.id = clientphone.clientId group
> >>by client.name
> >>
> >>If it's MS SQL Server you can use a subquery with FOR XML PATH and
> >>STUFF to approximate the same functionality.  Don't know about other
> >>platforms.
> >>
> >>At the very least, pull a single recordset with the same JOIN as above,
> >>but no GROUP BY, and then you can do the "rollup" in a single CFOUTPUT
> >>loop.  That'll save you a lot of trips to the DB, and therefor a lot of
> >>wasted time.
> >>
> >>cheers,
> >>barneyb
> >>
> >>
> >>>
> >
> >
> >
> >
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321592
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[C. Hatton Humphrey]

Is there a MSSQL version of that puppy?

On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews  wrote:
>
> Nice. So group_concat works sort of like ColdFusion's valuelist method. Very
> nice indeed!
>
> -Original Message-
> From: Richard White [mailto:rich...@j7is.co.uk]
> Sent: Tuesday, April 14, 2009 2:59 PM
> To: cf-talk
> Subject: Re: expert sql challenge
>
>
> thanks for all your replies.
>
> barney, yes we are using mysql and didnt even know about the qroup_concat.
> it works like a dream and where this task was taking 23 seconds to complete
> it is now taking a matter of milliseconds :)
>
> fantastic and thanks once again for all your replies :)
>
>>What DB are you using?  If it's MySQL, you can use this:
>>
>>select client.name, group_concat(clientphone.number) as phone numbers
>>from client
>>  left outer join clientphone on client.id = clientphone.clientId group
>>by client.name
>>
>>If it's MS SQL Server you can use a subquery with FOR XML PATH and
>>STUFF to approximate the same functionality.  Don't know about other
>>platforms.
>>
>>At the very least, pull a single recordset with the same JOIN as above,
>>but no GROUP BY, and then you can do the "rollup" in a single CFOUTPUT
>>loop.  That'll save you a lot of trips to the DB, and therefor a lot of
>>wasted time.
>>
>>cheers,
>>barneyb
>>
>>
>>>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321589
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: expert sql challenge

[Andy Matthews]

Nice. So group_concat works sort of like ColdFusion's valuelist method. Very
nice indeed! 

-Original Message-
From: Richard White [mailto:rich...@j7is.co.uk] 
Sent: Tuesday, April 14, 2009 2:59 PM
To: cf-talk
Subject: Re: expert sql challenge


thanks for all your replies. 

barney, yes we are using mysql and didnt even know about the qroup_concat.
it works like a dream and where this task was taking 23 seconds to complete
it is now taking a matter of milliseconds :)

fantastic and thanks once again for all your replies :)

>What DB are you using?  If it's MySQL, you can use this:
>
>select client.name, group_concat(clientphone.number) as phone numbers 
>from client
>  left outer join clientphone on client.id = clientphone.clientId group 
>by client.name
>
>If it's MS SQL Server you can use a subquery with FOR XML PATH and 
>STUFF to approximate the same functionality.  Don't know about other 
>platforms.
>
>At the very least, pull a single recordset with the same JOIN as above, 
>but no GROUP BY, and then you can do the "rollup" in a single CFOUTPUT 
>loop.  That'll save you a lot of trips to the DB, and therefor a lot of 
>wasted time.
>
>cheers,
>barneyb
>
>
>> 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321587
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[Richard White]

thanks for all your replies. 

barney, yes we are using mysql and didnt even know about the qroup_concat. it 
works like a dream and where this task was taking 23 seconds to complete it is 
now taking a matter of milliseconds :)

fantastic and thanks once again for all your replies :)

>What DB are you using?  If it's MySQL, you can use this:
>
>select client.name, group_concat(clientphone.number) as phone numbers
>from client
>  left outer join clientphone on client.id = clientphone.clientId
>group by client.name
>
>If it's MS SQL Server you can use a subquery with FOR XML PATH and
>STUFF to approximate the same functionality.  Don't know about other
>platforms.
>
>At the very least, pull a single recordset with the same JOIN as
>above, but no GROUP BY, and then you can do the "rollup" in a single
>CFOUTPUT loop.  That'll save you a lot of trips to the DB, and
>therefor a lot of wasted time.
>
>cheers,
>barneyb
>
>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321586
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[Dominic Watson]

There isn't really an efficient way to get a comma separated list in
one column with your DB query. However, there is a far more efficient
method that uses a single query and groups the output:


  SELECT c.clientId, c.firstname, c.lastname, t.number
  FROM client c
  LEFT JOIN clientPhoneNumber t ON t.clientId = c.clientId


...

#firstname# #lastname# numbers: #number#

...

Its a shame you can't do group on the cfloop tag but its a wonderful
thing that saves you in these kinds of cases.

Dominic

2009/4/14 Richard White :
>
> Hi
>
> we have a relational database and one task is taking far too long but we 
> cannot see any way to improve it, although i do feel there is a way to 
> massively improve it... so would like some expert help on this
>
> we have a normal table which has a One-to-Many table coming off of it...
>
> table 1 is client details (one to one table), and table 2 is client telephone 
> numbers (one to many table and has the clientid as a foreign key)
>
> we need to process a query that contains all the client details that have the 
> telephone numbers put into one cell and separated by commas
>
> for example, this is the output query that we need
> client details | telephone numbers
> 
> mr client 1    | 123456789,234567891,21342
> mr client 2    | 583736245,828262u82
>
> we have no idea if there is a way to ask SQL to combine the one to many 
> telephone numbers into one cell and seperate them by commas
>
> for now we are getting all clients. then in a seperate query we are getting 
> all telephone numbers.
>
> we then add a column to the clients query.
>
> then we run an outer loop to loop through all clients, and an inner loop that 
> runs through all the telephone numbers, and appending the telephone number to 
> the client if the client ids in both queries match.
>
> this seems a very long way around it but are not sure if there is a better way
>
> we would appreciate any suggestions to improve this
>
> thanks
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321585
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[ColdFusion Developer]

Have you looked into StoredProcs?  Push the load off the web server onto the
SQL Server (or Oracle whichever)



On Tue, Apr 14, 2009 at 3:38 PM, Richard White  wrote:

>
> Hi
>
> we have a relational database and one task is taking far too long but we
> cannot see any way to improve it, although i do feel there is a way to
> massively improve it... so would like some expert help on this
>
> we have a normal table which has a One-to-Many table coming off of it...
>
> table 1 is client details (one to one table), and table 2 is client
> telephone numbers (one to many table and has the clientid as a foreign key)
>
> we need to process a query that contains all the client details that have
> the telephone numbers put into one cell and separated by commas
>
> for example, this is the output query that we need
> client details | telephone numbers
> 
> mr client 1| 123456789,234567891,21342
> mr client 2| 583736245,828262u82
>
> we have no idea if there is a way to ask SQL to combine the one to many
> telephone numbers into one cell and seperate them by commas
>
> for now we are getting all clients. then in a seperate query we are getting
> all telephone numbers.
>
> we then add a column to the clients query.
>
> then we run an outer loop to loop through all clients, and an inner loop
> that runs through all the telephone numbers, and appending the telephone
> number to the client if the client ids in both queries match.
>
> this seems a very long way around it but are not sure if there is a better
> way
>
> we would appreciate any suggestions to improve this
>
> thanks
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321584
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[Scott Stroz]

The easiest way is use a JOIN to get a query that will have a phone number
on each row, then use the 'group' attribute of  to display them
correctly.

On Tue, Apr 14, 2009 at 3:38 PM, Richard White  wrote:

>
> Hi
>
> we have a relational database and one task is taking far too long but we
> cannot see any way to improve it, although i do feel there is a way to
> massively improve it... so would like some expert help on this
>
> we have a normal table which has a One-to-Many table coming off of it...
>
> table 1 is client details (one to one table), and table 2 is client
> telephone numbers (one to many table and has the clientid as a foreign key)
>
> we need to process a query that contains all the client details that have
> the telephone numbers put into one cell and separated by commas
>
> for example, this is the output query that we need
> client details | telephone numbers
> 
> mr client 1| 123456789,234567891,21342
> mr client 2| 583736245,828262u82
>
> we have no idea if there is a way to ask SQL to combine the one to many
> telephone numbers into one cell and seperate them by commas
>
> for now we are getting all clients. then in a seperate query we are getting
> all telephone numbers.
>
> we then add a column to the clients query.
>
> then we run an outer loop to loop through all clients, and an inner loop
> that runs through all the telephone numbers, and appending the telephone
> number to the client if the client ids in both queries match.
>
> this seems a very long way around it but are not sure if there is a better
> way
>
> we would appreciate any suggestions to improve this
>
> thanks
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321583
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: expert sql challenge

[Barney Boisvert]

What DB are you using?  If it's MySQL, you can use this:

select client.name, group_concat(clientphone.number) as phone numbers
from client
  left outer join clientphone on client.id = clientphone.clientId
group by client.name

If it's MS SQL Server you can use a subquery with FOR XML PATH and
STUFF to approximate the same functionality.  Don't know about other
platforms.

At the very least, pull a single recordset with the same JOIN as
above, but no GROUP BY, and then you can do the "rollup" in a single
CFOUTPUT loop.  That'll save you a lot of trips to the DB, and
therefor a lot of wasted time.

cheers,
barneyb

On Tue, Apr 14, 2009 at 12:38 PM, Richard White  wrote:
>
> Hi
>
> we have a relational database and one task is taking far too long but we 
> cannot see any way to improve it, although i do feel there is a way to 
> massively improve it... so would like some expert help on this
>
> we have a normal table which has a One-to-Many table coming off of it...
>
> table 1 is client details (one to one table), and table 2 is client telephone 
> numbers (one to many table and has the clientid as a foreign key)
>
> we need to process a query that contains all the client details that have the 
> telephone numbers put into one cell and separated by commas
>
> for example, this is the output query that we need
> client details | telephone numbers
> 
> mr client 1    | 123456789,234567891,21342
> mr client 2    | 583736245,828262u82
>
> we have no idea if there is a way to ask SQL to combine the one to many 
> telephone numbers into one cell and seperate them by commas
>
> for now we are getting all clients. then in a seperate query we are getting 
> all telephone numbers.
>
> we then add a column to the clients query.
>
> then we run an outer loop to loop through all clients, and an inner loop that 
> runs through all the telephone numbers, and appending the telephone number to 
> the client if the client ids in both queries match.
>
> this seems a very long way around it but are not sure if there is a better way
>
> we would appreciate any suggestions to improve this
>
> thanks
>
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321582
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

expert sql challenge

[Richard White]

Hi

we have a relational database and one task is taking far too long but we cannot 
see any way to improve it, although i do feel there is a way to massively 
improve it... so would like some expert help on this

we have a normal table which has a One-to-Many table coming off of it... 

table 1 is client details (one to one table), and table 2 is client telephone 
numbers (one to many table and has the clientid as a foreign key)

we need to process a query that contains all the client details that have the 
telephone numbers put into one cell and separated by commas

for example, this is the output query that we need
client details | telephone numbers

mr client 1| 123456789,234567891,21342
mr client 2| 583736245,828262u82

we have no idea if there is a way to ask SQL to combine the one to many 
telephone numbers into one cell and seperate them by commas

for now we are getting all clients. then in a seperate query we are getting all 
telephone numbers. 

we then add a column to the clients query.

then we run an outer loop to loop through all clients, and an inner loop that 
runs through all the telephone numbers, and appending the telephone number to 
the client if the client ids in both queries match.

this seems a very long way around it but are not sure if there is a better way

we would appreciate any suggestions to improve this

thanks




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321581
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: COLDFUSION EXPERT WANTED

[Rey Bango]

Karin,

You posted a similar posting about 5 times on CF-Jobs and now you're 
posting it here. CF-Talk is *NOT* for job postings and I would urge you 
to please read the list rules to ensure you understand what content is 
acceptable.

Rey...

Karin Kelly wrote:
> Position Title:   Sr. Web Developer   
>   
> Department:  Information Technology   
> 
> Location:Piscataway, NJ
> 
> Reports to:  IT Manager
> 
> 
> Position Summary:
> Apply cutting-edge technology to solve challenging business problems and 
> maximize IT’s value to the organization.  Oversee the administration of the 
> web portal, develop custom applications in a web environment, manipulation of 
> data between platforms, systems analysis to assist organization in process 
> automation and re-engineering initiatives. Additional activities related to 
> technology projects either in an advisory or participant role may be 
> required. 
>  
> Position Duties and Responsibilities:
> 1.Responsible for the complete design, development, testing and 
> deployment of custom written web applications and services
> 2.Comprehensive experience with structuring, developing, and implementing 
> interactive web sites with a content management back-end
> 3.Work with database administrator to design, develop, and update 
> databases as they relate to Web applications
> 4.Knowledge of database development
> 5.Resolve browser compatibility issues
> 6.Diagnose and troubleshoot problems with existing, web applications
> 7.Monitor and report on Web site traffic and performance
> 8.Develop web services and middle-tier objects
> 9.In-depth knowledge of latest .NET technologies, methodologies, 
> development environments and source control techniques
> 10.   Solid understanding of application development methodologies and 
> life-cycle
> 11.   Experience in gathering and analyzing business requirements
> 12.   Experience in defining functional requirements
> 13.   Experience with computer graphics
>  
> Required:
> 5+ years related work experience.
> Good communication and organizational skills.
> Highly self motivated and directed.
> Keen attention to detail
> Proven analytical and problem-solving abilities
> Ability to effectively prioritize and execute tasks in a high-pressure 
> environment
> Experience working in a small, team-oriented, collaborative environment, 
> preferably in the manufacturing and sales support industry.
>  
> Required Technical Skills:
> Software:
> ColdFusion MX 7.0, Java, Macromedia Studio 8,  DreamWeaver MX, Flash MX, 
> Fireworks MX, SQL Server 2000/2003, Microsoft Office 2000/2003, Microsoft 
> Visio, Adobe Acrobat, Adobe Illustrator, Adobe Photoshop, Internet Explorer, 
> Windows 2000/XP, Windows 2000/2003 Server, TCP/IP.
> 
> Programming Languages:
> ColdFusion 7.0, CSS, HTML, DHTML, Java, JavaScript, XML, Flash, Flex, SQL, 
> ActionScript (not required but nice to have).
> 
> Salary:
> This is a full time, permanent position which includes medical/dental 
> benefits, 401K, and Paid-Time-Off.  Salary is commensurate with experience.
> 
> All interested should forward a resume in word format, along with salary 
> requirements to: [EMAIL PROTECTED]
> 
> 
> 
> 
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302489
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

COLDFUSION EXPERT WANTED

[Karin Kelly]

Position Title:   Sr. Web Developer 

Department:Information Technology   

Location:  Piscataway, NJ

Reports to:IT Manager


Position Summary:
Apply cutting-edge technology to solve challenging business problems and 
maximize IT’s value to the organization.  Oversee the administration of the 
web portal, develop custom applications in a web environment, manipulation of 
data between platforms, systems analysis to assist organization in process 
automation and re-engineering initiatives. Additional activities related to 
technology projects either in an advisory or participant role may be required. 
 
Position Duties and Responsibilities:
1.  Responsible for the complete design, development, testing and 
deployment of custom written web applications and services
2.  Comprehensive experience with structuring, developing, and implementing 
interactive web sites with a content management back-end
3.  Work with database administrator to design, develop, and update 
databases as they relate to Web applications
4.  Knowledge of database development
5.  Resolve browser compatibility issues
6.  Diagnose and troubleshoot problems with existing, web applications
7.  Monitor and report on Web site traffic and performance
8.  Develop web services and middle-tier objects
9.  In-depth knowledge of latest .NET technologies, methodologies, 
development environments and source control techniques
10. Solid understanding of application development methodologies and 
life-cycle
11. Experience in gathering and analyzing business requirements
12. Experience in defining functional requirements
13. Experience with computer graphics
 
Required:
5+ years related work experience.
Good communication and organizational skills.
Highly self motivated and directed.
Keen attention to detail
Proven analytical and problem-solving abilities
Ability to effectively prioritize and execute tasks in a high-pressure 
environment
Experience working in a small, team-oriented, collaborative environment, 
preferably in the manufacturing and sales support industry.
 
Required Technical Skills:
Software:
ColdFusion MX 7.0, Java, Macromedia Studio 8,  DreamWeaver MX, Flash MX, 
Fireworks MX, SQL Server 2000/2003, Microsoft Office 2000/2003, Microsoft 
Visio, Adobe Acrobat, Adobe Illustrator, Adobe Photoshop, Internet Explorer, 
Windows 2000/XP, Windows 2000/2003 Server, TCP/IP.

Programming Languages:
ColdFusion 7.0, CSS, HTML, DHTML, Java, JavaScript, XML, Flash, Flex, SQL, 
ActionScript (not required but nice to have).

Salary:
This is a full time, permanent position which includes medical/dental benefits, 
401K, and Paid-Time-Off.  Salary is commensurate with experience.

All interested should forward a resume in word format, along with salary 
requirements to: [EMAIL PROTECTED]




~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302482
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: product query - need an expert

[Greg Morphis]

Yeah that just seemed like the logical thing to do..
Have a good one!

On Tue, Apr 1, 2008 at 12:02 AM, Mike Little <[EMAIL PROTECTED]> wrote:
> ok guys, i think all is resolved quite nicely. am now inputting all stock 
> levels in just the product_to_product_options (thank god for those table 
> aliases!!) table.
>
>  this has made is so much easier. simply doing a SUM of the stock levels to 
> see if a product has positive stock levels.
>
>  thanks all for your help.
>
>
>  

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302417
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: product query - need an expert

[Mike Little]

ok guys, i think all is resolved quite nicely. am now inputting all stock 
levels in just the product_to_product_options (thank god for those table 
aliases!!) table.

this has made is so much easier. simply doing a SUM of the stock levels to see 
if a product has positive stock levels.

thanks all for your help. 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302405
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: product query - need an expert

[Azadi Saryev]

something like:

[note: something quick before my first cup of Lao Mountain Coffee...
beware...]


SELECT p.product_id, p.stock_level, ptop.product_options_id,
ptop.stock_level AS o_stock_level, po.product_option_title
FROM products p LEFT JOIN (product_options po INNER JOIN
product_to_product_options ptop ON po.product_options_id =
ptop.product_options_id) ON p.product_id = ptop.product_id
ORDER BY p.product_id



#product_id#


#product_option_title# : in
stocksorry, out of stock


#stock_level# in stocksorry, out of
stock




Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mike Little wrote:
> good question, at this stage being able to display all with like you said - a 
> availability flag would be quite good.
>
>   
>> do you want to display on your summary page only products that are in
>> stock, or all products with 'unavailable' for those out of stock?
>>
>> Azadi Saryev
>> Sabai-dee.com
>> http://www.sabai-dee.com/
>>
>>
>>
>> Mike Little wrote:
>> 
>>> i need to develop a system for displaying products on a summary page.
>>>
>>>
>>>   
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302400
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: product query - need an expert

[Azadi Saryev]

i suppose then left joining your tables and using
cfif|cfelse/cfswitch|cfcase logic at output can do the trick?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mike Little wrote:
> good question, at this stage being able to display all with like you said - a 
> availability flag would be quite good.
>
>   
>> do you want to display on your summary page only products that are in
>> stock, or all products with 'unavailable' for those out of stock?
>>
>> Azadi Saryev
>> Sabai-dee.com
>> http://www.sabai-dee.com/
>>
>>
>>
>> Mike Little wrote:
>> 
>>> i need to develop a system for displaying products on a summary page.
>>>
>>>
>>>   
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302398
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: product query - need an expert

[Azadi Saryev]

not if you ant to be able to display product groups with various options
(i.e. size, colour, etc)...

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mark Fuqua wrote:
> Not an expert and this might be really stupid, but what is the advantage of
> making products with options...why not make each product option a different
> product?  Seems it would simplify what you need to do.
>
> Mark
>
> -Original Message-
> From: Mike Little [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 31, 2008 8:46 PM
> To: CF-Talk
> Subject: product query - need an expert
>
>
> help! i am stuck...
>
> ok, for my product catalogue i have included a basic inventory system.
>
> product
> -
> product_id
> track_stock BIT
> stock_level INT
> reorder_level INT
>
> product_to_product_options
> --
> product_id
> product_options_id
> stock_level INT
> reorder_level INT
>
> product_options
> -
> product_options_id
> product_option_title
>
> basically, if a product has options (eg. small, medium, large) then the
> stock is tracked at the option level. if not then it is tracked at the
> product level.
>
> my big problem is, how do i determine if a product is available for purchase
> eg. it has a stock level of zero - either at the product level or for a
> particular option?
>
> i need to develop a system for displaying products on a summary page.
>
> any help would truly be appreciated.
>
> mike
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302397
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: product query - need an expert

[Mark Fuqua]

Not an expert and this might be really stupid, but what is the advantage of
making products with options...why not make each product option a different
product?  Seems it would simplify what you need to do.

Mark

-Original Message-
From: Mike Little [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31, 2008 8:46 PM
To: CF-Talk
Subject: product query - need an expert


help! i am stuck...

ok, for my product catalogue i have included a basic inventory system.

product
-
product_id
track_stock BIT
stock_level INT
reorder_level INT

product_to_product_options
--
product_id
product_options_id
stock_level INT
reorder_level INT

product_options
-
product_options_id
product_option_title

basically, if a product has options (eg. small, medium, large) then the
stock is tracked at the option level. if not then it is tracked at the
product level.

my big problem is, how do i determine if a product is available for purchase
eg. it has a stock level of zero - either at the product level or for a
particular option?

i need to develop a system for displaying products on a summary page.

any help would truly be appreciated.

mike



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302396
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: product query - need an expert

[Mike Little]

good question, at this stage being able to display all with like you said - a 
availability flag would be quite good.

>do you want to display on your summary page only products that are in
>stock, or all products with 'unavailable' for those out of stock?
>
>Azadi Saryev
>Sabai-dee.com
>http://www.sabai-dee.com/
>
>
>
>Mike Little wrote:
>>
>> i need to develop a system for displaying products on a summary page.
>>
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302395
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: product query - need an expert

[Azadi Saryev]

do you want to display on your summary page only products that are in
stock, or all products with 'unavailable' for those out of stock?

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/



Mike Little wrote:
>
> i need to develop a system for displaying products on a summary page.
>
>   

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302394
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: product query - need an expert

[Greg Morphis]

It wouldn't be null you could make it "0".
Having the product stock in one table would make it easier to maintain also

On Mon, Mar 31, 2008 at 8:12 PM, Mike Little <[EMAIL PROTECTED]> wrote:
> hmmm... yes this could be an option. i was a little unsure of the default 
> record for the ptpo table eg. would it be a good idea to have a null 
> product_options_id?
>
> >Maybe have a default or generic "option", set the id to 0.. That way
> >ALL stock totals will be in one table instead of 2.
> >It'd make it easier to query also.
> >
> >
> >
> >On Mon, Mar 31, 2008 at 7:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
> >>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302393
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: product query - need an expert

[Mike Little]

hmmm... yes this could be an option. i was a little unsure of the default 
record for the ptpo table eg. would it be a good idea to have a null 
product_options_id?

>Maybe have a default or generic "option", set the id to 0.. That way
>ALL stock totals will be in one table instead of 2.
>It'd make it easier to query also.
>
>
>
>On Mon, Mar 31, 2008 at 7:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302392
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: product query - need an expert

[Mike Little]

SQL server mike.

>It might help to know which database you are using (SQL Server?).
>There are many ways to do this, but I don't think you provided enough
>detail to identify the best method. Below is one method.
>
>SELECT 1
>FROM product p
>WHERE product_id  = #id#
>AND
>(stock_level > 0
>OR EXISTS (
>  SELECT 1
>  FROM product_to_product_options ptpo
>  WHERE ptpo.product_id = p.product_id
>  AND ptpo.stock_level > 0
>)
>)
>
>If the query returns a row, then the product is in stock.
>
>Good luck,
>Mike Chabot
>
>On Mon, Mar 31, 2008 at 8:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
>> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302391
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: product query - need an expert

[Greg Morphis]

Maybe have a default or generic "option", set the id to 0.. That way
ALL stock totals will be in one table instead of 2.
It'd make it easier to query also.



On Mon, Mar 31, 2008 at 7:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
> help! i am stuck...
>
> ok, for my product catalogue i have included a basic inventory system.
>
> product
> -
> product_id
> track_stock BIT
> stock_level INT
> reorder_level INT
>
> product_to_product_options
> --
> product_id
> product_options_id
> stock_level INT
> reorder_level INT
>
> product_options
> -
> product_options_id
> product_option_title
>
> basically, if a product has options (eg. small, medium, large) then the stock 
> is tracked at the option level. if not then it is tracked at the product 
> level.
>
> my big problem is, how do i determine if a product is available for purchase 
> eg. it has a stock level of zero - either at the product level or for a 
> particular option?
>
> i need to develop a system for displaying products on a summary page.
>
> any help would truly be appreciated.
>
> mike
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302390
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: product query - need an expert

[Mike Chabot]

It might help to know which database you are using (SQL Server?).
There are many ways to do this, but I don't think you provided enough
detail to identify the best method. Below is one method.

SELECT 1
FROM product p
WHERE product_id  = #id#
AND
(stock_level > 0
OR EXISTS (
  SELECT 1
  FROM product_to_product_options ptpo
  WHERE ptpo.product_id = p.product_id
  AND ptpo.stock_level > 0
)
)

If the query returns a row, then the product is in stock.

Good luck,
Mike Chabot

On Mon, Mar 31, 2008 at 8:45 PM, Mike Little <[EMAIL PROTECTED]> wrote:
> help! i am stuck...
>
> ok, for my product catalogue i have included a basic inventory system.
>
> product
> -
> product_id
> track_stock BIT
> stock_level INT
> reorder_level INT
>
> product_to_product_options
> --
> product_id
> product_options_id
> stock_level INT
> reorder_level INT
>
> product_options
> -
> product_options_id
> product_option_title
>
> basically, if a product has options (eg. small, medium, large) then the stock 
> is tracked at the option level. if not then it is tracked at the product 
> level.
>
> my big problem is, how do i determine if a product is available for purchase 
> eg. it has a stock level of zero - either at the product level or for a 
> particular option?
>
> i need to develop a system for displaying products on a summary page.
>
> any help would truly be appreciated.
>
> mike
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302389
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

product query - need an expert

[Mike Little]

help! i am stuck...

ok, for my product catalogue i have included a basic inventory system.

product
-
product_id
track_stock BIT
stock_level INT
reorder_level INT

product_to_product_options
--
product_id
product_options_id
stock_level INT
reorder_level INT

product_options
-
product_options_id
product_option_title

basically, if a product has options (eg. small, medium, large) then the stock 
is tracked at the option level. if not then it is tracked at the product level.

my big problem is, how do i determine if a product is available for purchase 
eg. it has a stock level of zero - either at the product level or for a 
particular option?

i need to develop a system for displaying products on a summary page.

any help would truly be appreciated.

mike 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302388
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: XML Expert help with namespaces.. (Isaac???)

[s. isaac dealey]

> >
> > It doesn't know how to pick up the sub-node's namespace using
> > namespace-uri()?
> 
> 
> Sure it does. 

Oh I get what you were asking now... Yeah, I haven't even tried to use
XPath to do anything like that outside of XSL. 


-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300781
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: XML Expert help with namespaces.. (Isaac???)

[Dominic Watson]

>
> It doesn't know how to pick up the sub-node's namespace using
> namespace-uri()?


Sure it does. Actually I've been using local-name()="elementName". However,
my XPath statement is reasonably complex and is quite unreadable because of
this. Wouldn't be so bad using some arbritary prefix that was mapped to the
namespace. Here's the XPath (working):



How it would look with prefixes:



Still pretty big but far more readable,

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300773
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: XML Expert help with namespaces.. (Isaac???)

[s. isaac dealey]

> Lol, I'm guessing it can't be done natively then - I'll look into
> what can be done, hopefully make a udf or something.

It doesn't know how to pick up the sub-node's namespace using
namespace-uri()? 


  

  


XMLSearch(packet,"/root/sub1/sub2[namespace-uri()='bar']")

I figured you'd probably already tried this, but I'd be a little
surprised to see it not work. (Unless I'm confused about the question.)

(Apologies for any syntax errors, it's not tested or anything.) 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300761
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: XML Expert help with namespaces.. (Isaac???)

[s. isaac dealey]

> A default namespace has no prefix:
> 
> xmlns="http://somenamespaceURI";
> 
> Dominic's document has two default namespaces: one at the root element, and
> one at a child element. The one at the child element controls the default
> namespace only for its contents.

Oh... thanks Dave, makes a lot of sense now. :) 

Not an issue I've dealt with. 

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300759
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: XML Expert help with namespaces.. (Isaac???)

[Dominic Watson]

>
> It's just as well you didn't, because I don't know how to reference the
> default namespace of a child element in XPath, when it differs from the
> default namespace of the root element
>

Lol, I'm guessing it can't be done natively then - I'll look into what can
be done, hopefully make a udf or something.

Dominic

On 07/03/2008, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > Yep, I remembered you after I posted my original message
> > Dave; should have posted XML Expert Help (Isaac?? Dave???).
>
>
> It's just as well you didn't, because I don't know how to reference the
> default namespace of a child element in XPath, when it differs from the
> default namespace of the root element.
>
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
> http://training.figleaf.com/
>
> WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
> http://www.webmaniacsconference.com/
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300717
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: XML Expert help with namespaces.. (Isaac???)

[Dave Watts]

> Yep, I remembered you after I posted my original message 
> Dave; should have posted XML Expert Help (Isaac?? Dave???).

It's just as well you didn't, because I don't know how to reference the
default namespace of a child element in XPath, when it differs from the
default namespace of the root element.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300716
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: XML Expert help with namespaces.. (Isaac???)

[Dominic Watson]

Yep, I remembered you after I posted my original message Dave; should have
posted XML Expert Help (Isaac?? Dave???).

:p

Is there anyway to map those namespaces in CF do you know?

Dominic

On 07/03/2008, Dave Watts <[EMAIL PROTECTED]> wrote:
>
> > By "default namespace" are you talking about something like the "xsl"
> > namespace that doesn't need to be declared in the xml packet
> > or one where the packet itself contains xmlns:blah="yadda" ?
>
>
> A default namespace has no prefix:
>
> xmlns="http://somenamespaceURI";
>
> Dominic's document has two default namespaces: one at the root element,
> and
> one at a child element. The one at the child element controls the default
> namespace only for its contents.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
>
> Fig Leaf Training: Adobe/Google/Paperthin Certified Partners
> http://training.figleaf.com/
>
> WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
> http://www.webmaniacsconference.com/
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300715
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: XML Expert help with namespaces.. (Isaac???)

[Dave Watts]

> By "default namespace" are you talking about something like the "xsl"
> namespace that doesn't need to be declared in the xml packet 
> or one where the packet itself contains xmlns:blah="yadda" ? 

A default namespace has no prefix:

xmlns="http://somenamespaceURI";

Dominic's document has two default namespaces: one at the root element, and
one at a child element. The one at the child element controls the default
namespace only for its contents.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/

Fig Leaf Training: Adobe/Google/Paperthin Certified Partners 
http://training.figleaf.com/

WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers!
http://www.webmaniacsconference.com/

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300712
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: XML Expert help with namespaces.. (Isaac???)

[s. isaac dealey]

> Ok, so I figured why my xmlSearch was not working - there are two
> default namespaces in the xml and a namespace mapping is required to
> reference them through XPath. After searching for some time on how to
> map namespaces with ColdFusion I gave up and used:
> 
> //[local-name()="AddressDetails"]/* etc
> 
> My XPath query ended up huge and unreadable but it worked. Any ideas
> on how to map namespaces for XPath searches in ColdFusion?

Hey Dom... did I miss a message? :) 

Just noticed this just now -- sorry if it's been a while, I've been a
bit distracted with some other projects. This one may be out of my depth.
By "default namespace" are you talking about something like the "xsl"
namespace that doesn't need to be declared in the xml packet or one
where the packet itself contains xmlns:blah="yadda" ? As long as the
xmlns- declaration is in the packet I *think* you can use
[namespace-uri(.)='yadda'] normally in the xpath statement although I
rarely do just 'cause it makes those xpath statements so large and
there's usually not much risk of ambiguity in the ones I work with. If
there's not an xmlns- declaration in the packet then I'd be stumped. :) 

hth,
ike

-- 
s. isaac dealey  ^  new epoch
 isn't it time for a change? 
 ph: 503.236.3691

http://onTap.riaforge.org/blog



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300709
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: XML Expert help with namespaces.. (Isaac???)

[Dominic Watson]

>
>
> http://www.talkingtree.com/blog/index.cfm/2005/11/18/XmlSearchNoNameNamespace
>

Thanks, I saw that in my search, however it doesn't cover the problem in my
example. This only deals with a single noname namespace. In my example there
are two, one nested in the other. This stops you being able to reference the
elements within the second default namespace with ':elementname'. In this
case you need to map the default namespaces to a prefix before you do your
transformation or search. Not sure CF allows you to do this (haven't found
the answer yet).

Might be something to add to my BetterXML component .

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300631
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: XML Expert help with namespaces.. (Isaac???)

[Dawson, Michael]

This post may help.

http://www.talkingtree.com/blog/index.cfm/2005/11/18/XmlSearchNoNameName
space

m!ke 

-Original Message-
From: Dominic Watson [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 05, 2008 4:50 PM
To: CF-Talk
Subject: XML Expert help with namespaces.. (Isaac???)

I am having trouble searching this xml string returned from the google
maps geocoding service. The reason is to do with the xmlns for the
AddressDetails XML. Here is the xml (I wish I could tab it!):



http://earth.google.com/kml/2.0";>

 godalming, surrey, GB
 
 200
 geocode
 

 
 Godalming, Surrey, UK


 
 GB
 
 England
 
 Surrey
 
 Godalming
 
 
 
 



 -0.617529,51.184425,0




Ok, so doing like this gets a result: 

How should I be referencing the AddressDetails nodes? (I have double
checked case sensitivity, not the problem)

Thanks in advance,

Dominic

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300628
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: XML Expert help with namespaces.. (Isaac???)

[Dominic Watson]

Ok, so I figured why my xmlSearch was not working - there are two default
namespaces in the xml and a namespace mapping is required to reference them
through XPath. After searching for some time on how to map namespaces with
ColdFusion I gave up and used:

//[local-name()="AddressDetails"]/* etc

My XPath query ended up huge and unreadable but it worked. Any ideas on how
to map namespaces for XPath searches in ColdFusion?

Dominic

On 05/03/2008, Dominic Watson <[EMAIL PROTECTED]> wrote:
>
> I am having trouble searching this xml string returned from the google
> maps geocoding service. The reason is to do with the xmlns for the
> AddressDetails XML. Here is the xml (I wish I could tab it!):
>
>
>  xml version="1.0" encoding="UTF-8"?>
> http://earth.google.com/kml/2.0";>
> 
>  godalming, surrey, GB
>  
>  200
>  geocode
>  
>
>  
>  Godalming, Surrey, UK
>
> 
>  
>  GB
>  
>  England
>  
>  Surrey
>  
>  Godalming
>  
>  
>  
>  
> 
>
> 
>  -0.617529,51.184425,0
> 
> 
> 
> 
> Ok, so doing like this gets a result:  "//:Response")
> But this won't: 
>
> How should I be referencing the AddressDetails nodes? (I have double
> checked case sensitivity, not the problem)
>
> Thanks in advance,
>
> Dominic
>
> --
> Blog it up: http://fusion.dominicwatson.co.uk
>



-- 
Blog it up: http://fusion.dominicwatson.co.uk


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300625
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

XML Expert help with namespaces.. (Isaac???)

[Dominic Watson]

I am having trouble searching this xml string returned from the google maps
geocoding service. The reason is to do with the xmlns for the AddressDetails
XML. Here is the xml (I wish I could tab it!):



http://earth.google.com/kml/2.0";>

 godalming, surrey, GB
 
 200
 geocode
 

 
 Godalming, Surrey, UK


 
 GB
 
 England
 
 Surrey
 
 Godalming
 
 
 
 



 -0.617529,51.184425,0




Ok, so doing like this gets a result: 

How should I be referencing the AddressDetails nodes? (I have double checked
case sensitivity, not the problem)

Thanks in advance,

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300592
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Need a coldfusion expert and opinion... I am stranded..HELP

[Mark Phillips]

>On Dec 27, 2007 2:41 AM, Alex Snowden <[EMAIL PROTECTED]> wrote:
>> I have this music website and the designer basically left me stranded.
>> I have been looking for a decent low-mid cost cold fusion designer/programmer
>> for 6 months.
>>
>> I haven't found anyone?  I looked on craigslist, get a freelancer, and even
>> various website forums and no luck.  Pretty much my investment is being 
>> drained.
>> But I constantly find designers who BS and really never do the job as I 
>> wanted.
>
>Alex -
>
>I'm not sure if you've gotten any other replies for this message yet
>or not... your post came through at a time when most that are active
>on this list are sleeping (and those that aren't are working).
>
>First, I would suggest posting your need to the CF-Jobs list, there
>are contractors and firms that monitor that list on a daily basis that
>can contact you regarding the need.  I would offer to help you out but
>my level of commitment would be minimal right now because of other
>commitments.  If you want, I can offer to help make as many changes as
>I can on a "singleton" basis by quote while you look for another
>solution.  My personal rate for contract work is $45/hr which becomes
>the basis for my quotes... however on quote jobs what you're quoted is
>what you pay.
>
>Secondly, I'm sorry that you've had such a hard time finding someone!
>Hopefully this list and the CF-Jobs list can help you out!  You're
>going to find rates that vary wildly - in my own look for contractors
>for my work I've been offered between $30 and $150.  You *will* be
>contacted by a number of agencies as well as individuals but I'm sure
>you're used to that after craigslist and getafreelancer.  To be honest
>I have not found a single reliable resource on either list.
>
>Best of luck!
>
>Regards,
>Hatton Humphrey
>[EMAIL PROTECTED] 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295535
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Need a coldfusion expert and opinion... I am stranded..HELP

[C. Hatton Humphrey]

List -

Apologies for sending this directly... I changed the TO: but
apparently GMail had other ideas.

Hatton

> Alex -
>
> I'm not sure if you've gotten any other replies for this message yet
> or not... your post came through at a time when most that are active
> on this list are sleeping (and those that aren't are working).

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295401
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: Need a coldfusion expert and opinion... I am stranded..HELP

[C. Hatton Humphrey]

On Dec 27, 2007 2:41 AM, Alex Snowden <[EMAIL PROTECTED]> wrote:
> I have this music website and the designer basically left me stranded.
> I have been looking for a decent low-mid cost cold fusion designer/programmer
> for 6 months.
>
> I haven't found anyone?  I looked on craigslist, get a freelancer, and even
> various website forums and no luck.  Pretty much my investment is being 
> drained.
> But I constantly find designers who BS and really never do the job as I 
> wanted.

Alex -

I'm not sure if you've gotten any other replies for this message yet
or not... your post came through at a time when most that are active
on this list are sleeping (and those that aren't are working).

First, I would suggest posting your need to the CF-Jobs list, there
are contractors and firms that monitor that list on a daily basis that
can contact you regarding the need.  I would offer to help you out but
my level of commitment would be minimal right now because of other
commitments.  If you want, I can offer to help make as many changes as
I can on a "singleton" basis by quote while you look for another
solution.  My personal rate for contract work is $45/hr which becomes
the basis for my quotes... however on quote jobs what you're quoted is
what you pay.

Secondly, I'm sorry that you've had such a hard time finding someone!
Hopefully this list and the CF-Jobs list can help you out!  You're
going to find rates that vary wildly - in my own look for contractors
for my work I've been offered between $30 and $150.  You *will* be
contacted by a number of agencies as well as individuals but I'm sure
you're used to that after craigslist and getafreelancer.  To be honest
I have not found a single reliable resource on either list.

Best of luck!

Regards,
Hatton Humphrey
[EMAIL PROTECTED]

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295400
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Need a coldfusion expert and opinion... I am stranded..HELP

[Alex Snowden]

I have this music website and the designer basically left me stranded.  I have 
been looking for a decent low-mid cost cold fusion designer/programmer for 6 
months.

I haven't found anyone?  I looked on craigslist, get a freelancer, and even 
various website forums and no luck.  Pretty much my investment is being 
drained.  But I constantly find designers who BS and really never do the job as 
I wanted. 

Now I know coldfusion is expensive but its almost to a point I am not sure if I 
should switch to PHP, ASP etc.  Just hearing to many negatives about it.  Plus 
finding reliable programmers that work in coldfusion, I heard is more 
expensive, hosting,  etc.
Can someone here please clarify this.

I need a few things done with my sitewhich is already built
1.  New profile layout...and maybe main page
2.  Shopping cart fixed ( think i need to set up goggle checkout and that 
it)... I have the merchant system done
3.  Admin section needs a few add fixes
4   Member Profiles need to be fixed etc... I imagine this goes with the new 
design look
5  Chat/Im and Blogging system fixed
6.  Forum fixed. its like nothing in it
7  Profiles abilty to upload video like youtube or display it...
8.  And user ability to sell music which is already set up but need a right 
layout

I dont think its a lot of work and willing to pay... I paid so much already

Can anyone help

thanks
Alex

[EMAIL PROTECTED]


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295398
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Need a coldfusion expert and opinion... I am stranded..HELP

[Alex Snowden]

I have this music website and the designer basically left me stranded.  I have 
been looking for a decent low-mid cost cold fusion designer/programmer for 6 
months.

I haven't found anyone?  I looked on craigslist, get a freelancer, and even 
various website forums and no luck.  Pretty much my investment is being 
drained.  But I constantly find designers who BS and really never do the job as 
I wanted. 

Now I know coldfusion is expensive but its almost to a point I am not sure if I 
should switch to PHP, ASP etc.  Just hearing to many negatives about it.  Plus 
finding reliable programmers that work in coldfusion, I heard is more 
expensive, hosting,  etc.
Can someone here please clarify this.

I need a few things done with my sitewhich is already built
1.  New profile layout...and maybe main page
2.  Shopping cart fixed ( think i need to set up goggle checkout and that 
it)... I have the merchant system done
3.  Admin section needs a few add fixes
4   Member Profiles need to be fixed etc... I imagine this goes with the new 
design look
5  Chat/Im and Blogging system fixed
6.  Forum fixed. its like nothing in it
7  Profiles abilty to upload video like youtube or display it...
8.  And user ability to sell music which is already set up but need a right 
layout

I dont think its a lot of work and willing to pay... I paid so much already

Can anyone help

thanks
Alex

[EMAIL PROTECTED]


~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295397
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

RE: Usability Expert to Present at Tomorrow's NYCFUG Meeting!

[Ben Nadel]

What has two thumbs and is excited to attend CFUG meetings? This Guy ;)

...
Ben Nadel 
Web Developer
Nylon Technology
350 7th Avenue
Floor 10
New York, NY 10001
212.691.1134 x 14
212.691.3477 fax
www.nylontechnology.com
 
"Some people call me the space cowboy. Some people call me the gangster of
love."

-Original Message-
From: Judith Dinowitz [mailto:[EMAIL PROTECTED] 
Sent: Monday, June 12, 2006 1:48 PM
To: CF-Talk
Subject: OT: Usability Expert to Present at Tomorrow's NYCFUG Meeting!

At the next New York ColdFusion User Group (http://www.nycfug.org) meeting,
find out how to create more effective Web products with the practice of
usability testing. Software project methodology guru Clark Valberg will take
you step-by-step through the process of setting up and conducting a
professional-grade usability test. 

Attend this presentation and discover: 
  a.. The top 10 rules of web usability
  b.. Why usability is so important
  c.. How to make usability testing part of your normal development process
without breaking a sweat.

Three days, five volunteers, and an eye for detail could save your next
client millions ... Join us at the next NYCFUG meeting and learn how!

When? Tuesday, June 13, 2006, 6:30 PM
Where? NYU Medical Center, 550 1st Avenue, NY, NY
Room: Coles 101

Please RSVP on our website (http://www.nycfug.org) to let us know that
you're coming! Refreshments are available.

Judith Dinowitz
Co-Manager
New York ColdFusion User Group (NYCFUG)
http://www.nycfug.org





~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243247
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

OT: Usability Expert to Present at Tomorrow's NYCFUG Meeting!

[Judith Dinowitz]

At the next New York ColdFusion User Group (http://www.nycfug.org) meeting, 
find out how to create more effective Web products with the practice of 
usability testing. Software project methodology guru Clark Valberg will take 
you step-by-step through the process of setting up and conducting a 
professional-grade usability test. 

Attend this presentation and discover: 
  a.. The top 10 rules of web usability 
  b.. Why usability is so important 
  c.. How to make usability testing part of your normal development process 
without breaking a sweat.

Three days, five volunteers, and an eye for detail could save your next client 
millions ... Join us at the next NYCFUG meeting and learn how!

When? Tuesday, June 13, 2006, 6:30 PM
Where? NYU Medical Center, 550 1st Avenue, NY, NY
Room: Coles 101

Please RSVP on our website (http://www.nycfug.org) to let us know that you're 
coming! Refreshments are available.

Judith Dinowitz
Co-Manager
New York ColdFusion User Group (NYCFUG)
http://www.nycfug.org



~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243230
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Expert at debugging stack traces?

[gabriel l smallman]

Then you're my guy. Need to hire some to help me track down a hanging
condition on cfmx 7.0 on win 2.3k. I have tried everything I can think of. I
have installed fusion reactor and have some excellent sample stack traces
but I'm just not that good with diagnosing it from this. 

If your interested just Email me at: [EMAIL PROTECTED]

gabe


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227716
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Need SQL Expert Help!

[jonese]

thanks all!

erj

On 11/11/05, Caroline Wise <[EMAIL PROTECTED]> wrote:
> Oops, I think you wanted it the other way around...
>   select *
> from [tablename]
> where filename not like CAST(uploadID AS VARCHAR(50)) + '.%'
>
>
>  On 11/11/05, Caroline Wise <[EMAIL PROTECTED]> wrote:
> >
> > How about
> >  select *
> > from [tablename]
> > where filename like CAST(uploadID AS VARCHAR(50)) + '.%'
> >  HTH
> >  Caroline Wise
> >  On 11/11/05, jonese <[EMAIL PROTECTED]> wrote:
> > >
> > > we have an upload system that stores an uploadid and then the filename
> > > of the file uploaded.
> > >
> > > the uploadid is just an int (100524) and filename is the uploadID plus
> > > the extention (100524.doc)
> > >
> > > I need a SQL script which will select those records where the uploadid
> > > doesn't equal the filename without the extension...
> > >
> > > anyone have any help / guidance?
> > >
> > > TIA jonese
> > >
> > >
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223979
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Need SQL Expert Help!

[Greg Morphis]

select * from foo
where fooid != substr(file, 1, position('.' in file) - 1);

That works for postgres, if using Oracle use the instr() function
instead of the position() function.


On 11/11/05, Greg Morphis <[EMAIL PROTECTED]> wrote:
> is it always .doc or . followed by a 3 digit extension?
> select * from foo
> where fooid != substr(file, 1, length(file) - 4)
> That works if so...
>
> On 11/11/05, jonese <[EMAIL PROTECTED]> wrote:
> > we have an upload system that stores an uploadid and then the filename
> > of the file uploaded.
> >
> > the uploadid is just an int (100524) and filename is the uploadID plus
> > the extention (100524.doc)
> >
> > I need a SQL script which will select those records where the uploadid
> > doesn't equal the filename without the extension...
> >
> > anyone have any help / guidance?
> >
> > TIA jonese
> >
> > 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223977
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Need SQL Expert Help!

[Caroline Wise]

Oops, I think you wanted it the other way around...
  select *
from [tablename]
where filename not like CAST(uploadID AS VARCHAR(50)) + '.%'


 On 11/11/05, Caroline Wise <[EMAIL PROTECTED]> wrote:
>
> How about
>  select *
> from [tablename]
> where filename like CAST(uploadID AS VARCHAR(50)) + '.%'
>  HTH
>  Caroline Wise
>  On 11/11/05, jonese <[EMAIL PROTECTED]> wrote:
> >
> > we have an upload system that stores an uploadid and then the filename
> > of the file uploaded.
> >
> > the uploadid is just an int (100524) and filename is the uploadID plus
> > the extention (100524.doc)
> >
> > I need a SQL script which will select those records where the uploadid
> > doesn't equal the filename without the extension...
> >
> > anyone have any help / guidance?
> >
> > TIA jonese
> >
> > 

~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223976
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Need SQL Expert Help!

[Caroline Wise]

How about
 select *
from [tablename]
where filename like CAST(uploadID AS VARCHAR(50)) + '.%'
 HTH
 Caroline Wise
 On 11/11/05, jonese <[EMAIL PROTECTED]> wrote:
>
> we have an upload system that stores an uploadid and then the filename
> of the file uploaded.
>
> the uploadid is just an int (100524) and filename is the uploadID plus
> the extention (100524.doc)
>
> I need a SQL script which will select those records where the uploadid
> doesn't equal the filename without the extension...
>
> anyone have any help / guidance?
>
> TIA jonese
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223974
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Need SQL Expert Help!

[Greg Morphis]

is it always .doc or . followed by a 3 digit extension?
select * from foo
where fooid != substr(file, 1, length(file) - 4)
That works if so...

On 11/11/05, jonese <[EMAIL PROTECTED]> wrote:
> we have an upload system that stores an uploadid and then the filename
> of the file uploaded.
>
> the uploadid is just an int (100524) and filename is the uploadID plus
> the extention (100524.doc)
>
> I need a SQL script which will select those records where the uploadid
> doesn't equal the filename without the extension...
>
> anyone have any help / guidance?
>
> TIA jonese
>
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223973
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Need SQL Expert Help!

[Deanna Schneider]

You could do it like this in Oracle. I'd imagine you could swap functions
for sql server:

SELECT id, CASE WHEN idcolumn != TO_NUMBER(SUBSTR(filecolumn,
1,INSTR(filecolumn, '.')-1)) THEN 'bad record' ELSE 'good record' END as
result
FROM yourtable


On 11/11/05, jonese <[EMAIL PROTECTED]> wrote:
>
> we have an upload system that stores an uploadid and then the filename
> of the file uploaded.
>
> the uploadid is just an int (100524) and filename is the uploadID plus
> the extention (100524.doc)
>
> I need a SQL script which will select those records where the uploadid
> doesn't equal the filename without the extension...
>
> anyone have any help / guidance?
>
> TIA jonese
>
>
>


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223970
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Need SQL Expert Help!

[jonese]

we have an upload system that stores an uploadid and then the filename
of the file uploaded.

the uploadid is just an int (100524) and filename is the uploadID plus
the extention (100524.doc)

I need a SQL script which will select those records where the uploadid
doesn't equal the filename without the extension...

anyone have any help / guidance?

TIA jonese

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223966
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Looking for a usability expert

[Rey Bango]

Thanks Mike. I'll look into them.

Rey...

Dawson, Michael wrote:
> http://www.usablenet.com/
> 
> We are getting a sales conf call with this group next week.  They
> contacted us, but I think we, being a university, should really make
> better use of usability and accessibility.
> 
> M!ke 
> 
> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED] 
> Sent: Wednesday, June 15, 2005 10:18 PM
> To: CF-Talk
> Subject: Looking for a usability expert
> 
> Hi all. My company is looking for a usability expert to review our
> shopping process and make recommendations on how to improve it.
> 
> Could anyone make some recommendations?
> 
> Rey..
> 
> --
> http://www.ReyBango.com
> 
> 
> 

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209682
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Looking for a usability expert

[Jim Davis]

> -Original Message-
> From: Rey Bango [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 15, 2005 11:18 PM
> To: CF-Talk
> Subject: Looking for a usability expert
> 
> Hi all. My company is looking for a usability expert to review our
> shopping process and make recommendations on how to improve it.
> 
> Could anyone make some recommendations?
> 
> Rey..

Depending on what you need I may be able to help or, lacking that, could
point you in the direction of somebody who could.

http://www.depressedpress.com/

Jim Davis





~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209665
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Looking for a usability expert

[Adam Churvis]

Ray,

We're almost finished building our new Usability Testing Lab, which enables
us to synchronize video streams of participants' faces and voices (they
verbalize their thoughts as they go through the prescribed tasks) with the
video streams of their screen actions, analyze task metrics, and produce a
live stakeholder's report showing firsthand the key points of difficulty
shared between participants.

I don't have any info on our site about it yet, so if you want to talk about
this feel free to contact me offlist or at 770-446-8866.  We'd love to help
you.

Respectfully,

Adam Phillip Churvis
Member of Team Macromedia
http://www.ProductivityEnhancement.com

Download Plum and other cool development tools,
and get advanced intensive Master-level training:

* C# & ASP.NET for ColdFusion Developers
* ColdFusion MX Master Class
* Advanced Development with CFMX and SQL Server 2000

- Original Message - 
From: "Rey Bango" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Wednesday, June 15, 2005 11:17 PM
Subject: Looking for a usability expert


> Hi all. My company is looking for a usability expert to review our
> shopping process and make recommendations on how to improve it.
>
> Could anyone make some recommendations?
>
> Rey..
>
> -- 
> http://www.ReyBango.com
>
>
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209655
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Looking for a usability expert

[Will Tomlinson]

Rey,

I have one that I use - she's very professional, has extensive experience with 
usability, and has very reasonable rates. Instead of telling you all about her 
here, just email me offlist at [EMAIL PROTECTED] and I'll give you her contact 
info. 

Thanks,
Will


~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209650
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Looking for a usability expert

[Dawson, Michael]

http://www.usablenet.com/

We are getting a sales conf call with this group next week.  They
contacted us, but I think we, being a university, should really make
better use of usability and accessibility.

M!ke 

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, June 15, 2005 10:18 PM
To: CF-Talk
Subject: Looking for a usability expert

Hi all. My company is looking for a usability expert to review our
shopping process and make recommendations on how to improve it.

Could anyone make some recommendations?

Rey..

--
http://www.ReyBango.com


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209638
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Looking for a usability expert

[Parker, Kevin]

Where are you located 



++
Kevin Parker
Web Services Consultant
WorkCover Corporation

p: 08 8233 2548
m: 0418 806 166
e: [EMAIL PROTECTED]
w: www.workcover.com

++

-Original Message-
From: Rey Bango [mailto:[EMAIL PROTECTED] 
Sent: Thursday, 16 June 2005 12:48 PM
To: CF-Talk
Subject: Looking for a usability expert

Hi all. My company is looking for a usability expert to review our
shopping process and make recommendations on how to improve it.

Could anyone make some recommendations?

Rey..

--
http://www.ReyBango.com




~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209637
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Looking for a usability expert

[Rey Bango]

Hi all. My company is looking for a usability expert to review our
shopping process and make recommendations on how to improve it.

Could anyone make some recommendations?

Rey..

-- 
http://www.ReyBango.com


~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209636
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job

[Patrick McGeehan]

I know I have gotten that error message before, either on 4.5 or 5.  I found
this after searching a little while

-

paraming a variable with a scope but without a variable name  will cause
"CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321
" when doing this in Coldfusion 5 or lower.

-

But if my memory serves me I seem to remember in our case it had to do with
having multiple cfapplication tags execute on the same request.  In that
instance it was application.cfm including the application.cfm in the parent
directory.  This will cause, long page loads, terminated page loads, server
crashes, weird error messages.

Not sure if that is it, if that situation went with that error message.  But
I thought it might be worth mentioning.

Patrick








-Original Message-
From: Peter Lakanen [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 2:50 PM
To: CF-Talk
Subject: Have A Client with A Specific Need. Read On to See If You're
the Right CF Expert for the Job


We're getting a variety of errors including CFLOCK's timing out and
references to
CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205642
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job

[Connie DeCinko]

And move over a piece at a time and test.  Maybe if you can duplicate side
by side...
 

-Original Message-
From: Al Musella, DPM [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, May 04, 2005 2:11 PM
To: CF-Talk
Subject: Re: Have A Client with A Specific Need. Read On to See If You're
the Right CF Expert for the Job

Hate to say, but how about moving back to the old servers, to give you time 
to work on the new servers and figure out the problem?
I would then re-format the drive on the new server, and install windows and 
cf again..  then run diagnostics on the new disks.. then test it for a few 
days to see what happens. Make sure the cf settings  are the same.
If that fails, try installing the current version of cf.. it may show 
better error messages.




~|
Find out how CFTicket can increase your company's customer support 
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205612
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job

[Matt Robertson]

Are you flagging long-running templates in CFAdmin?  I assume you 

I seriously doubt this is hardware related, although of course
anything is possible.  Looks to me like a CF setting wasn't set up the
same.  OR the odbc connection is the point of failure (either the
network issue you mention or the new db server itself has issues).

I assume you looked for that stupid variable name to see what its
context is.  If the name is used 1 times you won't get much but if
its used once or thrice you may learn a lot.  Probably you're way
ahead of me on that.

-- 
--mattRobertson--
Janitor, MSB Web Systems
mysecretbase.com

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205610
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job

[Clint Tredway]

I had a client with the same issue... after all was said and done, the
only thing that fixed this was moving to CF 6.1 - using the same code,
the server stopped crashing..

On 5/4/05, Jochem van Dieten <[EMAIL PROTECTED]> wrote:
> Peter Lakanen wrote:
> > As of yesterday, I've got a client who recently moved both their web
> > server and their database server to bigger, more beefy servers and now
> > they can't keep their web site running.
> >
> > It is ColdFusion-driven (version 5) and is mostly (if not entirely)
> > powered by a content mangement system called ActiveMatter.
> >
> > ColdFusion is dying several times a day and is being re-started.  Web
> > site visitors are getting frustrated and the client just wants it all fixed.
> >
> > We're getting a variety of errors including CFLOCK's timing out and
> > references to
> > CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321.
> 
> Do you have configuration details of the old setup? Was it
> running on CF 5 before? Have there been any changes to the
> automatic locking settings for shared scopes?
> 
> >   - Their web site traffic has been steadily growing (thousands of
> > visitors per day) and they may have reached a tipping point whereby
> > thier dynamic, database-driven system can't handle the load.
> 
> I don't buy it. They would have had issues at peak time before
> and they just moved to bigger hardware.
> 
> Jochem
> 
> 

~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble 
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205608
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job

[Al Musella, DPM]

Hate to say, but how about moving back to the old servers, to give you time 
to work on the new servers and figure out the problem?
I would then re-format the drive on the new server, and install windows and 
cf again..  then run diagnostics on the new disks.. then test it for a few 
days to see what happens. Make sure the cf settings  are the same.
If that fails, try installing the current version of cf.. it may show 
better error messages.

At 04:46 PM 5/4/2005, Jochem van Dieten wrote:
>Peter Lakanen wrote:
> > As of yesterday, I've got a client who recently moved both their web
> > server and their database server to bigger, more beefy servers and now
> > they can't keep their web site running.
> >
> > It is ColdFusion-driven (version 5) and is mostly (if not entirely)
> > powered by a content mangement system called ActiveMatter.
> >
> > ColdFusion is dying several times a day and is being re-started.  Web
> > site visitors are getting frustrated and the client just wants it all 
> fixed.
> >
> > We're getting a variety of errors including CFLOCK's timing out and
> > references to
> > 
> CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321.


~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205606
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job

[Jochem van Dieten]

Peter Lakanen wrote:
> As of yesterday, I've got a client who recently moved both their web 
> server and their database server to bigger, more beefy servers and now 
> they can't keep their web site running.
> 
> It is ColdFusion-driven (version 5) and is mostly (if not entirely) 
> powered by a content mangement system called ActiveMatter.
> 
> ColdFusion is dying several times a day and is being re-started.  Web 
> site visitors are getting frustrated and the client just wants it all fixed.
> 
> We're getting a variety of errors including CFLOCK's timing out and 
> references to 
> CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321.

Do you have configuration details of the old setup? Was it 
running on CF 5 before? Have there been any changes to the 
automatic locking settings for shared scopes?


>   - Their web site traffic has been steadily growing (thousands of 
> visitors per day) and they may have reached a tipping point whereby 
> thier dynamic, database-driven system can't handle the load.

I don't buy it. They would have had issues at peak time before 
and they just moved to bigger hardware.

Jochem

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205600
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Have A Client with A Specific Need. Read On to See If You're the Right CF Expert for the Job

[Peter Lakanen]

As of yesterday, I've got a client who recently moved both their web 
server and their database server to bigger, more beefy servers and now 
they can't keep their web site running.

It is ColdFusion-driven (version 5) and is mostly (if not entirely) 
powered by a content mangement system called ActiveMatter.

ColdFusion is dying several times a day and is being re-started.  Web 
site visitors are getting frustrated and the client just wants it all fixed.

We're getting a variety of errors including CFLOCK's timing out and 
references to 
CFTempOnlyForSetVariableNeverUseThisNameInYourCFMLCode1223335654321.

I was brought in to consult on it just yesterday and my early 
prognosis/theory is the problem is due to one of two things (or both):

  - Still mostly unknown (to me) differences between the original system 
architecture and the new.  For example, I know there used to be a 
separate network connection between the web server and the database 
server, but they removed it in the new configuration because they didn't 
think it was needed.  It's not clear to me how many other decisions like 
this were made.

  - Their web site traffic has been steadily growing (thousands of 
visitors per day) and they may have reached a tipping point whereby 
thier dynamic, database-driven system can't handle the load.

Right now, this is total triage work -- akin to fixing the car engine 
while you're driving down the road.

Ideally, I'd like to find someone who is familiar with the ActiveMatter 
system who can provide some recommendations on how to analyze and/or 
scale the system.

If you think you can provide some assistance, please contact me off list 
directly.  FYI, I get the list in digest form and won't see your 
response to the list for six hours.

Thanks!

-peter


-- 
   Peter Lakanen   [EMAIL PROTECTED]
   Platinum Web Development  http://www.platinumweb.com
   1320 Terrace Street  Tallahassee, FL 32303
   850.508.4518   FAX: 850.681.1930

~|
Logware (www.logware.us): a new and convenient web-based time tracking 
application. Start tracking and documenting hours spent on a project or with a 
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205567
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Expert Coder List Needed

[Dave Watts]

> I appologize for posting this message here, but I'm looking 
> for an expert Flash developers list.  I can't seem to get to 
> flash coders at chattyfig.figleaf.com anymore.  You can 
> contact me directly if you like.

The list server was shut down this morning temporarily, because our building
had the power shut off for yearly inspection. It'll be back up shortly.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Expert Coder List Needed

[Orlando . Correa]

I appologize for posting this message here, but I'm looking for an expert Flash developers list.  I can't seem to get to flash coders at chattyfig.figleaf.com anymore.  You can contact me directly if you like.

Thanks
Orlando
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Is there just not a verity expert amongst us? =(...

[Daniel Budde II]

-Original Message-
  From: Daniel Budde II [mailto:[EMAIL PROTECTED]
  Sent: Monday, September 20, 2004 11:58 AM
  To: CF-Talk
  Subject: Vspider, K2 server help

  I believe I am running Vspider correctly, but what I have noticed is if I
  use Vspider or a normal CFindex I am getting the same results.  I am
  indexing a website for a site search feature.  Some of the content is
  dynamic, some of it is static.  Since I understand that Vspider is
supposed
  to do a crawl on the site I was trying to use it, but my results are
  returning no "titles" back and lots of CFMX code.  Makes the results look
  really jumbled.

  Here is my "mappath" file example:

  #SourceField    SourcePrefix DestField    DestPrefix
  VDKVGWKEY   http://localhost URL   http://64.178.36.155

  Here is my Vspider start file example:

  -start http://localhost
  -refresh
  -prefixmap e:\pci_redo1\mappath.txt
  -common c:\CFusionMX\lib\common
  -style c:\CFusionMX\lib\common\style
  -noflowctrl
  -locale english
  -collection c:\cfusionmx\verity\collections\PCIMAIN
  -exclude "*/admin/*" "*/collections/*" "*/convert/*" "*/css/*"
"*/images/*"
  "*/js/*" "*/precastanswers/*" "*/template/*"
  -cgiok
  -loglevel verbose

  Obviously from my example you can see the IP address of the website.  Feel
  free to go there, it is not working completely since it is under
  development.  The page where the verity results are displaying is
  http://64.178.36.155/test.cfm and I am just performing a search with
  criteria being a asterisk to include all the results.

  Thanks in advance for any help,

  Daniel Budde II
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Looking for a Verity expert

[Joe Bernard]

We have Verity K2 server set up and indexing some tables from our database. We refresh the index every 30 minutes with a query.

It works correctly for about 10 minutes after starting the K2 engine, then it begins returning strange result sets. All the cells in the result set are empty strings, except for the score and recordsSearched columns. It will actually return the correct number of rows, but each row consists of nothing but empty strings.

We've tried recreating, repairing, and optimizing.

We also tried switching over to the VDK mode. This fixes the problem but is much slower.

Can someone tell me where I should look to fix this problem?

-Joe
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Some Expert input on this

[Taco Fleur]

I am no expert in Object Oriented Programming, and I'm pretty sure I am
loosing the plot somewhere with the following cfc, I would really appreciate
some expert input from someone (Sean where art thou)..

 
I believe I need to lock any access to the object as its in the server
scope, not sure yet whether it gives better performance creating the object
only once in the server and lock access to it, or recreate the object every
time and not having to lock access to it, I believe its the first one.

 
I think I am losing the plot when we get to
 request.result.objError.fnConstruct( request.result );
 request.result.objError.fnDisplay( request.result );
But I can't really tell you why, but I'm pretty sure its not a good thing
having to pass itself back with request.result

 
Hope someone's still awake..

 

test.cfm

 

// this will eventually only be set once in the server scope
server.objProcess = createObject("component", "process");


 

 throwontimeout="yes" 
 type="exclusive" 
 scope="server">

 
 request.result = server.objProcess.fnExecute( "this string means nothing"
);
 request.result.objError.fnConstruct( request.result );
 request.result.objError.fnDisplay( request.result );
 


 


 

process.cfc

 


 
 this.result = structNew();

 message = structNew();
 structInsert(message, "isDisplayed", false);
 structInsert(message, "isMessage", false);
 structInsert(message, "myArray", arrayNew(1));
 structInsert(message, "myString", "");
 structInsert(this.result, "message", message);

 error = structNew();
 structInsert(error, "isDisplayed", false);
 structInsert(error, "isError", false);
 structInsert(error, "myArray", arrayNew(1));
 structInsert(error, "myString", "");
 structInsert(this.result, "error", error);
 structInsert(this.result, "objError", createObject("component", "error"));
 

 
  name="fnExecute" 
  output="false" 
  returntype="struct">

 
  
  
   type="string" 
   required="true">

 
  
  
  #ttt#
   
    
    
    
    
' )>
   
  

 
  
 

 



error.cfc

 

 hint="I work with errors">

 
 
  name="fnAppend" 
  output="false" 
  returntype="any" 
  displayname="Error Append" 
  hint="I append an error message to an array">

 
  
   type="struct" 
   required="true" 
   displayname="Result Structure" 
   hint="I am the Result Structure">
  
   type="string" 
   required="true" 
   default="There was an error" 
   displayname="Error Message" 
   hint="I am the error message to append">

 
  
  
arguments.errorMessage)>
 


 
  name="fnConstruct" 
  output="false" 
  returntype="struct" 
  displayname="Error Construct" 
  hint="I construct error messages">

 
  
   type="struct" 
   required="true" 
   displayname="Result Structure" 
   hint="I am the Result Structure">

 
  
  
   
   
index="i">
    #arguments.result.error.myArray[ i
]#">
   
   ">
   
   
  

 
  
 


 
  name="fnDisplay" 
  output="true" 
  returntype="any" 
  displayname="Error Display" 
  hint="I display error messages">

 
  
   type="struct" 
   required="true"
   displayname="Result Structure" 
   hint="I am the structure that contains the result">

 
  
  
  structUpdate(arguments.result.error, "isDisplayed", true);
  

 
  
 


  name="fnClear" 
  output="false" 
  returntype="any" 
  displayname="Error Clear" 
  hint="I clear error messages">

 
  
   type="struct" 
   required="true"
   displayname="Result Structure" 
   hint="I am the structure that contains the result">

 
  
  
 

 


 
Taco Fleur

Tell me and I will forget
Show me and I will remember
Teach me and I will learn
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Slightly OT: Graphics expert?

[Ray Champagne]

Thanks to all of you that responded.  I promise that I will post the 
results of what we find as soon as she can compile all the suggestions and 
put them to good use.  It might be a couple of days, but I will post the 
solution for future searches on this thread as soon as we have them.  I may 
be back with more questions too.

This list rocks!

Ray

At 11:09 AM 6/23/2004, you wrote:
>While I know this sounds odd, it's been true for me:
>I've found that if I make my graphic text a .gif and make all but the
>letters transparent and put that in a table, it looks much fuzzier
>than it should.  I'd show ya, but I tend to not do that if I can.  I
>saw it as recently as a month ago.  Now, I just don't use
>transparency in a gif when it's text.  I put a backing on it.
>--
>Daniel Kessler
>
>Department of Public and Community Health
>University of Maryland
>Suite 2387 Valley Drive
>College Park, MD  20742-2611
>301-405-2545 Phone
>www.phi.umd.edu
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Slightly OT: Graphics expert?

[Daniel Kessler]

While I know this sounds odd, it's been true for me:
I've found that if I make my graphic text a .gif and make all but the 
letters transparent and put that in a table, it looks much fuzzier 
than it should.  I'd show ya, but I tend to not do that if I can.  I 
saw it as recently as a month ago.  Now, I just don't use 
transparency in a gif when it's text.  I put a backing on it.
-- 
Daniel Kessler

Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD  20742-2611
301-405-2545 Phone
www.phi.umd.edu
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Slightly OT: Graphics expert?

[Cutter (CF-Talk)]

Ray,

I've followed this thread this morning with my cup of joe, and seen some 
great insight on some of the bigger issues with type and graphics. Adobe 
Photoshop has never really handled fonts very well, especially with the 
web image exports (which is best to port to Image Ready instead of the 
"Save for Web" option IMO). In one tutorial I found on a PS GA's site it 
was suggested to use the "Matte: None" option, especially when working 
with dark type. When I was part owner of a Screen Printing shop our GA 
found that type which was first created in Illustrator, vectorized, then 
imported into PS would work the best (this was in the PS 5 days, and 
Illustrator gave him more flexability with text manipulation as well, 
though the new PS CS edition has brought it a long way). Though it's not 
my tool of choice (nor the two GAs that work here), Fireworks does 
appear to handle web image typography a little better/cleaner (as some 
here have mentioned). I guess we all find the workarounds to the 
limitations of our tools of preference...

Cutter

Ray Champagne wrote:
> Anybody here really good with graphics?  We have a designer here who is
> having a lot of trouble creating text graphics (for navigation, say) that
> are not all fuzzy around the edges.  She swears that she has tried
> everything in Photoshop, filters, etc, but they still look like crap.  The
> way that she is doing them is just not going to fly with professional web
> sites.  So, my question is, does anybody have a surefire way to create
> crisp, non pixelated or fuzzy text graphics in Photoshop that they care to
> share with us?
> 
> BTW, I know about css and rollover effects, etc, but we sometimes need to
> have drop shadows and other effects that I don't think that you can get
> with css.
> 
> Any help or pointers to tutorials that we have not found would be 
> appreciated.
> 
> You can see an example of what I am talking about here:
> 
> http://www.crystalvisionwebdesign.com/test/index2.html
> 
> (ignore the ugly js error - she isn't a programmer by any means)
> 
> Thanks!
> 
> Ray
> 
> =
> Ray Champagne - Senior Application Developer
> CrystalVision Web Site Design and Internet Services
> 603.433.9559
> www.crystalvision.org
> =
> 
> The information contained in this transmission (including any attached
> files) is CONFIDENTIAL and is intended only for the person(s) named
> above. If you received this transmission in error, please delete it
> from your system and notify us immediately. If you are not an intended
> recipient, please note that any use or dissemination of the information
> contained in this transmission (including any attached files) and the
> copying, printing, or retransmission of that information is strictly
> prohibited. You can notify us by return email or by phone at 603.433.9559.
> Thank you.
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Slightly OT: Graphics expert?

[Erik Yowell]

The examples look par for the course as far as anti-aliasing goes with
that particular font. Thin-typed sans almost always come out that way.
Even more so when your drop shadow and color (blue/black) blend
together. try lightening the drop shadow, or change its color, adding
contrasting backgrounds (basic color theory here.), using a reverse
color/font technique or altering the actual font color itself to
something that doesn't bleed quite so much, increasing size and weight
work well too. Heck, personally I'd go for an entirely different font
all together. I can't see your mockup or layout result, so that's about
all there is to comment - massive whitespace can very much skew the eyes
interpretation of color. And remember, good typography is an art in
itself.

As a suggestion - not to be uber-trendy, or anything, but bitmap fonts
work well for nav elements, buttons, etc. due to their crisp legible
nature at small and medium sizes. But then, I guess drop-shadows are
kinda trendy too. go fig.

For example: 
http://atomicmedia.net/singles.php
http://miniml.com/fonts/
http://www.dafont.com/en/bitmap.php?page=1 

Good luck,

 
Erik Yowell
[EMAIL PROTECTED]
http://www.shortfusemedia.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Slightly OT: Graphics expert?

[Erik Yowell]

The examples look par for the course as far as anti-aliasing goes with
that particular font. Thin-typed sans almost always come out that way.
Even more so when your drop shadow and color (blue/black) blend
together. try lightening the drop shadow, or change its color, adding
contrasting backgrounds (basic color theory here.), using a reverse
color/font technique or altering the actual font color itself to
something that doesn't bleed quite so much, increasing size and weight
work well too. Heck, personally I'd go for an entirely different font
all together. I can't see your mockup or layout result, so that's about
all there is to comment - massive whitespace can very much skew the eyes
interpretation of color. And remember, good typography is an art in
itself.

As a suggestion - not to be uber-trendy, or anything, but bitmap fonts
work well for nav elements, buttons, etc. due to their crisp legible
nature at small and medium sizes. But then, I guess drop-shadows are
kinda trendy too. go fig.

For example: 

http://atomicmedia.net/singles.php

http://miniml.com/fonts/

http://www.dafont.com/en/bitmap.php?page=1

Good luck,

Erik Yowell

[EMAIL PROTECTED]

http://www.shortfusemedia.com

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, June 22, 2004 2:05 PM
To: CF-Talk
Subject: Slightly OT: Graphics expert?

Anybody here really good with graphics?  We have a designer here who is 
having a lot of trouble creating text graphics (for navigation, say)
that 
are not all fuzzy around the edges.  She swears that she has tried 
everything in Photoshop, filters, etc, but they still look like crap.
The 
way that she is doing them is just not going to fly with professional
web 
sites.  So, my question is, does anybody have a surefire way to create 
crisp, non pixelated or fuzzy text graphics in Photoshop that they care
to 
share with us?

BTW, I know about css and rollover effects, etc, but we sometimes need
to 
have drop shadows and other effects that I don't think that you can get 
with css.

Any help or pointers to tutorials that we have not found would be
appreciated.

You can see an example of what I am talking about here:

http://www.crystalvisionwebdesign.com/test/index2.html

(ignore the ugly js error - she isn't a programmer by any means)

Thanks!

Ray

=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at
603.433.9559.
Thank you.

  _
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Slightly OT: Graphics expert?

[Ray Champagne]

Hi guys...I am at home right now (my wife hates it when I work from home) 
so I will answer all questions and try all solutions tomorrow and let 
everybody know what happens.  So far, it looks like there are lots of 
things to try and if that doesn't work then we will just fire her!

J/K of course.  Nobody knows everything all the time - that's how you 
learn, IMHO.

Thanks,

Ray

At 07:26 PM 6/22/04, you wrote:
>My partner just asked You mean something like this??
>
>
>http://www.web-architect.co.uk/textexample/
>
>
>Paul
>
>So, as a means of explanation for those of us who are following this 
>thread hoping to learn something.
>
>That was done with No-dithering?  If I understand dithering correctly to 
>be the in-between colors around the edges to make them softer and fuzzier?
>
>Ian
>
>
>Confidentiality Notice:  This message including any
>attachments is for the sole use of the intended
>recipient(s) and may contain confidential and privileged
>information. Any unauthorized review, use, disclosure or
>distribution is prohibited. If you are not the
>intended recipient, please contact the sender and
>delete any copies of this message.
>
>
>
>
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Slightly OT: Graphics expert?

[dana tierney]

yes, dithering is the soft edges on some letters so that curved
letters like C or B will not appear to have jagged edges

- Original Message -
From: Ian Skinner <[EMAIL PROTECTED]>
Date: Tue, 22 Jun 2004 16:26:26 -0700
Subject: RE: Slightly OT: Graphics expert?
To: CF-Talk <[EMAIL PROTECTED]>

My partner just asked You mean something like this??

http://www.web-architect.co.uk/textexample/

Paul

So, as a means of explanation for those of us who are following this
thread hoping to learn something.

That was done with No-dithering?  If I understand dithering correctly
to be the in-between colors around the edges to make them softer and
fuzzier?

Ian

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Slightly OT: Graphics expert?

[Ian Skinner]

My partner just asked You mean something like this??

http://www.web-architect.co.uk/textexample/

Paul

 
So, as a means of explanation for those of us who are following this thread hoping to learn something.

 
That was done with No-dithering?  If I understand dithering correctly to be the in-between colors around the edges to make them softer and fuzzier?

 
Ian

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Slightly OT: Graphics expert?

[Adrocknaphobia]

I think you should hire a new designer.

-Adam

- Original Message -
From: Ray Champagne <[EMAIL PROTECTED]>
Date: Tue, 22 Jun 2004 17:05:17 -0400
Subject: Slightly OT: Graphics expert?
To: CF-Talk <[EMAIL PROTECTED]>

Anybody here really good with graphics?  We have a designer here who is 
having a lot of trouble creating text graphics (for navigation, say) that 
are not all fuzzy around the edges.  She swears that she has tried 
everything in Photoshop, filters, etc, but they still look like crap.  The 
way that she is doing them is just not going to fly with professional web 
sites.  So, my question is, does anybody have a surefire way to create 
crisp, non pixelated or fuzzy text graphics in Photoshop that they care to 
share with us?

BTW, I know about css and rollover effects, etc, but we sometimes need to 
have drop shadows and other effects that I don't think that you can get 
with css.

Any help or pointers to tutorials that we have not found would be appreciated.

You can see an example of what I am talking about here:

http://www.crystalvisionwebdesign.com/test/index2.html

(ignore the ugly js error - she isn't a programmer by any means)

Thanks!

Ray

=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at 603.433.9559.
Thank you.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Slightly OT: Graphics expert?

[Paul Vernon]

My partner just asked You mean something like this??

 
http://www.web-architect.co.uk/textexample/

 
Paul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Slightly OT: Graphics expert?

[Paul Vernon]

My partner does all the GFX work for us. She tells me she needs more
information in order that she can help...

 
Firstly, in your example what font are you using?

 
Secondly, what version of Photoshop do you have?

 
If you have specific questions, send them off list and I'll pass them on!

 
Paul
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Slightly OT: Graphics expert?

[Kevin Graeme]

A lot of it depends on the version of Photoshop you use. More recent
versions include more control over the anti-aliasing used which is the key.
My preference is actually to use Fireworks. In Fireworks I can not only
select from multiple AA options, but can set my own.

-Kevin

- Original Message - 
From: "Ray Champagne"

> Anybody here really good with graphics?  We have a designer here who is
> having a lot of trouble creating text graphics (for navigation, say) that
> are not all fuzzy around the edges.  She swears that she has tried
> everything in Photoshop, filters, etc, but they still look like crap.  The
> way that she is doing them is just not going to fly with professional web
> sites.  So, my question is, does anybody have a surefire way to create
> crisp, non pixelated or fuzzy text graphics in Photoshop that they care to
> share with us?
>
> BTW, I know about css and rollover effects, etc, but we sometimes need to
> have drop shadows and other effects that I don't think that you can get
> with css.
>
> Any help or pointers to tutorials that we have not found would be
appreciated.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Slightly OT: Graphics expert?

[Ben Doom]

> Other than that, there shouldn't be too much else she has to do. The key
> is to play with the anti-aliasing setting for that text layer. If you
> want smooth, graphical text items, they will always be blurry to a
> degree, as that's what anti-aliasing does to get rid of the jaggies.

It's also going to depend on the export filetype and export settings.

I'm not a graphics guru by any stretch of the imagination, but I work 
for one.  He generally exports a number of files before he finds one 
he's happy with.  Generally, we find that a GIF or PNG (where possible) 
with an optimized palette looks best, but that's not always the case.

--Ben
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Slightly OT: Graphics expert?

[Bob Haroche]

I'm no graphics expert either, but what I'll often do is create a text
layer and then clone it and overlay the clone over the original. I
might then lower the opacity of the top level some. I do this in
Fireworks and the effect is to sharpen the text in question.

-
Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Slightly OT: Graphics expert?

[bret]

Ray Champagne wrote:

> Anybody here really good with graphics?  We have a designer here who is
> having a lot of trouble creating text graphics (for navigation, say) that
> are not all fuzzy around the edges.  She swears that she has tried
> everything in Photoshop, filters, etc, but they still look like crap.  The
> way that she is doing them is just not going to fly with professional web
> sites.  So, my question is, does anybody have a surefire way to create
> crisp, non pixelated or fuzzy text graphics in Photoshop that they care to
> share with us?

Do you mean you want it to look like rendered HTML text? Tell her to use 
an HTML-friendly font, lik arial, verdana, etc. Then make sure 
Anti-Aliasing is set to NONE for that text layer. Also, it could just be 
the font she's using. Some fonts don't render well at certain sizes.

Other than that, there shouldn't be too much else she has to do. The key 
is to play with the anti-aliasing setting for that text layer. If you 
want smooth, graphical text items, they will always be blurry to a 
degree, as that's what anti-aliasing does to get rid of the jaggies.

What version of Photoshop? PS 7 and above seem to render text more 
smoothly than older versions, as they do them vector-based.

HTH,

-Bret
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Slightly OT: Graphics expert?

[Ray Champagne]

Anybody here really good with graphics?  We have a designer here who is 
having a lot of trouble creating text graphics (for navigation, say) that 
are not all fuzzy around the edges.  She swears that she has tried 
everything in Photoshop, filters, etc, but they still look like crap.  The 
way that she is doing them is just not going to fly with professional web 
sites.  So, my question is, does anybody have a surefire way to create 
crisp, non pixelated or fuzzy text graphics in Photoshop that they care to 
share with us?

BTW, I know about css and rollover effects, etc, but we sometimes need to 
have drop shadows and other effects that I don't think that you can get 
with css.

Any help or pointers to tutorials that we have not found would be appreciated.

You can see an example of what I am talking about here:

http://www.crystalvisionwebdesign.com/test/index2.html

(ignore the ugly js error - she isn't a programmer by any means)

Thanks!

Ray

=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at 603.433.9559.
Thank you.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: I could use a JS expert right now.

[Scott Brady]

Che Vilnonis wrote:

> i don't believe action is a reserved word.

"action" is a reserved word for form fields, because you can reference 
the "action" value (as in 
field named "action" can cause problems. (Even if you remove the 
"action" attribute from the form tag, I believe the form still has an 
"action".) Of course, with JS "action" isn't the same thing as "Action" 
so I'm not sure if that's actually the issue.

I'd try changing your formfield to be something like "myAction" and see 
if that fixes it.

Scott

-- 
---
Scott Brady
http://www.scottbrady.net/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: I could use a JS expert right now.

[Che Vilnonis]

Nick, et al. See attached for the generated code.

-Original Message-
From: Nick de Voil [mailto:[EMAIL PROTECTED]
Sent: Monday, December 08, 2003 1:08 PM
To: CF-Talk
Subject: Re: I could use a JS expert right now.

Che

> the page still bombs. this sucks.

Can you post the generated source code?

Nick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Re: I could use a JS expert right now.

[Nick de Voil]

Che

> the page still bombs. this sucks.

Can you post the generated source code?

Nick
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: I could use a JS expert right now.

[Che Vilnonis]

i don't believe action is a reserved word.
I removed the action reference from the href and entered a value for the
hidden variable "Action".

the page still bombs. this sucks.
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
  Sent: Monday, December 08, 2003 12:45 PM
  To: CF-Talk
  Subject: RE: I could use a JS expert right now.

  Nick  wrote:
  >> > - Error: document.PageSwitch2.Action has no properties
  >> action is lower case.

  aha!  Action is a reserved word?  I think Che has it as a field name...
  you could also try changing that

  --
  -dc  [ cf5, ora8.1.7, iis5 ]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

RE: I could use a JS expert right now.

[d.a.collie]

Nick  wrote:
>> > - Error: document.PageSwitch2.Action has no properties
>> action is lower case.

aha!  Action is a reserved word?  I think Che has it as a field name...
you could also try changing that

-- 
-dc  [ cf5, ora8.1.7, iis5 ]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]