(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: (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%22l=Los+Angeles,+CA

http://www.indeed.com/jobs?q=%22user+experience%22+OR+%22user+interface%22l=Los+Angeles,+CAI
also found 50 on linkedin.com

On Mon, Nov 8, 2010 at 9:14 AM, Mark Drew mark.d...@gmail.com 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

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

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: 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 rich...@j7is.co.uk 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

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 cfoutput to display them
correctly.

On Tue, Apr 14, 2009 at 3:38 PM, Richard White rich...@j7is.co.uk 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

[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 rich...@j7is.co.uk 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

[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:

cfquery name=qryClients datasource=myDsn
  SELECT c.clientId, c.firstname, c.lastname, t.number
  FROM client c
  LEFT JOIN clientPhoneNumber t ON t.clientId = c.clientId
/cfquery

...
cfoutput query=qryClients group=clientId
#firstname# #lastname# numbers: cfoutput#number#/cfoutput
/cfoutput
...

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 rich...@j7is.co.uk:

 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

[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

[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

[C. Hatton Humphrey]

Is there a MSSQL version of that puppy?

On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews li...@commadelimited.com 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

[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 chumph...@gmail.comwrote:


 Is there a MSSQL version of that puppy?

 On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews li...@commadelimited.com
 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

[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
chumph...@gmail.com wrote:

 Is there a MSSQL version of that puppy?

 On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews li...@commadelimited.com 
 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

[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 bboisv...@gmail.com 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
 chumph...@gmail.com wrote:

 Is there a MSSQL version of that puppy?

 On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews li...@commadelimited.com 
 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]

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 ju...@wiredotter.com 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 bboisv...@gmail.com 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
 chumph...@gmail.com wrote:

 Is there a MSSQL version of that puppy?

 On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews li...@commadelimited.com 
 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]

On Tue, Apr 14, 2009 at 3:47 PM, Barney Boisvert bboisv...@gmail.com 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 ju...@wiredotter.com 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 bboisv...@gmail.com 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
 chumph...@gmail.com wrote:

 Is there a MSSQL version of that puppy?

 On Tue, Apr 14, 2009 at 3:19 PM, Andy Matthews li...@commadelimited.com 
 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: Looking for javascript expert and CF professional worker

[Larry C. Lyons]

What people have been saying about this topic are best set of
arguments for getting requirements docs before anything is coded.That
has saved me more than once.
regards,
larry

On Sat, Jun 14, 2008 at 9:41 PM, James Holmes [EMAIL PROTECTED] wrote:
 Especially putting together the last couple of posts:

  - looking for a decent low-mid cost cold fusion designer/programmer
  - get paid after (THE JOB IS DONE CORRECTLY AND COMPLETELY)
  - Looking for total project cost fair and reasonably.  No per hour

 I've done projects like this; I now refuse to work for anything other
 that per-hour and I charge like a wounded bull. Scope creep always
 causes issues any other way.

 On Sat, Jun 14, 2008 at 11:03 AM, Phillip M. Vector
 [EMAIL PROTECTED] wrote:
 *nods* That wording also sent alarm bells up for me as well.

 Scott Stewart wrote:
 I think the moral of this story is get everything in writing...
 And no one in their right mind should do a fixed priced contract without at
 least a percentage up front...

 While it may not be a scam, it's not anything I'd get involved in just based
 on this sentence:

 Must be trustworthy and get paid after (THE JOB IS DONE CORRECTLY AND
 COMPLETELY)

 --
 mxAjax / CFAjax docs and other useful articles:
 http://www.bifrost.com.au/blog/

 

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

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

RE: Looking for javascript expert and CF professional worker

[Bobby Hartsfield]

+1

..:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com

-Original Message-
From: Larry C. Lyons [mailto:[EMAIL PROTECTED] 
Sent: Sunday, June 15, 2008 3:15 PM
To: CF-Jobs-Talk
Subject: Re: Looking for javascript expert and CF professional worker

What people have been saying about this topic are best set of
arguments for getting requirements docs before anything is coded.That
has saved me more than once.
regards,
larry

On Sat, Jun 14, 2008 at 9:41 PM, James Holmes [EMAIL PROTECTED]
wrote:
 Especially putting together the last couple of posts:

  - looking for a decent low-mid cost cold fusion designer/programmer
  - get paid after (THE JOB IS DONE CORRECTLY AND COMPLETELY)
  - Looking for total project cost fair and reasonably.  No per hour

 I've done projects like this; I now refuse to work for anything other
 that per-hour and I charge like a wounded bull. Scope creep always
 causes issues any other way.

 On Sat, Jun 14, 2008 at 11:03 AM, Phillip M. Vector
 [EMAIL PROTECTED] wrote:
 *nods* That wording also sent alarm bells up for me as well.

 Scott Stewart wrote:
 I think the moral of this story is get everything in writing...
 And no one in their right mind should do a fixed priced contract without
at
 least a percentage up front...

 While it may not be a scam, it's not anything I'd get involved in just
based
 on this sentence:

 Must be trustworthy and get paid after (THE JOB IS DONE CORRECTLY AND
 COMPLETELY)

 --
 mxAjax / CFAjax docs and other useful articles:
 http://www.bifrost.com.au/blog/

 



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

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

Re: Looking for javascript expert and CF professional worker

[Phillip M. Vector]

*nods* That wording also sent alarm bells up for me as well.

Scott Stewart wrote:
 I think the moral of this story is get everything in writing...
 And no one in their right mind should do a fixed priced contract without at
 least a percentage up front... 
 
 While it may not be a scam, it's not anything I'd get involved in just based
 on this sentence:
 
 Must be trustworthy and get paid after (THE JOB IS DONE CORRECTLY AND
 COMPLETELY) 
 
 --
 Scott Stewart
 ColdFusion Developer
 4405 Oakshyre Way
 Raleigh, NC 27616
 (h) 919.874.6229 (c) 703.220.2835
 -Original Message-
 From: Phillip Vector [mailto:[EMAIL PROTECTED] 
 Sent: Wednesday, June 11, 2008 4:33 PM
 To: CF-Jobs-Talk
 Subject: Re: Looking for javascript expert and CF professional worker
 
 Is it just me or does this sound like a scam to anyone else?
 
 On Wed, Jun 11, 2008 at 1:29 PM, Alex Snowden [EMAIL PROTECTED] wrote:
 Hi looking to CF expert who can help me finish my site  Site is
 basically done and now just looking for touch up work so to speak.  Protect
 consist of javascript touchup work...
 Must be trustworthy and  get paid after (THE JOB IS DONE CORRECTLY AND
 COMPLETELY)
 I have gotten burned way to much from designers... as of late
 doing projects the way they feel, flake out, incomplete and lack of
 guidance.  Need a team player and willing to keep work consistant if things
 work out well.  Professionals Like Minded please only apply.  Looking for
 reasonable quotes...
 please leave email and phone number where you can be contacted
 
 
 
 

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

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

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

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

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

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

[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

[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

[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

[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

[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

[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

[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]

something like:

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

cfquery name=q1 ...
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
/cfquery

cfoutput query=q1 goup=product_id
#product_id#
cfif listlen(arraytolist(q1.o_stock_level, ','), ',') gt 0
cfoutput
#product_option_title# : cfif o_stock_level gt 0in
stockcfelsesorry, out of stock/cfif
/cfoutput
cfelse
cfif stock_level gt 0#stock_level# in stockcfelsesorry, out of
stock/cfif
/cfif
/cfoutput


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

[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: 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]

 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]

 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???)

[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???)

[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()? 

root xmlns=foo
  sub1 xmlns=bar
sub2 /
  /sub1
/root

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???)

[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):

cfset coords = XMLSearch(response,
'//*[local-name()=AddressDetails]/*[local-name()=Country]/*[local-name()=AdministrativeArea]/*[local-name()=AdministrativeAreaName
and text() =
England]/following-sibling::*[local-name()=SubAdministrativeArea]/*[local-name()=SubAdministrativeAreaName
and
text()=#county#)]/following-sibling::*[local-name()=Locality]/*[local-name()=LocalityName
and
text()=#town#]/ancestor::*[local-name()=Placemark]/:Point/:coordinates')

How it would look with prefixes:

cfset coords = XMLSearch(response,
'//a:AddressDetails/a:Country/a:AdministrtitaveArea[a:AdministrativeAreaName=England]/following-sibling::a:SubAdministritaveArea[a:
SubAdministritaveAreaName=#county#]/following-sibling::a:Locality[LocalityName=#town#]/ancestor::x:Placemark/x:Point/x:coordinates')

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]

 
  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]

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?
 kml xmlns=http://earth.google.com/kml/2.0;
 Response
  namegodalming, surrey, GB/name
  Status
  code200/code
  requestgeocode/request
  /Status

  Placemark id=p1
  addressGodalming, Surrey, UK/address

 !-- THE TROUBLESOME BIT --
 AddressDetails Accuracy=4 xmlns=urn:oasis:names:tc:ciq:xsdschema:xAL:
 2.0 Country
  CountryNameCodeGB/CountryNameCode
  AdministrativeArea
  AdministrativeAreaNameEngland/AdministrativeAreaName
  SubAdministrativeArea
  SubAdministrativeAreaNameSurrey/SubAdministrativeAreaName
  Locality
  LocalityNameGodalming/LocalityName
  /Locality
  /SubAdministrativeArea
  /AdministrativeArea
  /Country
 /AddressDetails

 Point
  coordinates-0.617529,51.184425,0/coordinates
 /Point
 /Placemark
 /Response
 /kml
 Ok, so doing like this gets a result: cfset foo = XMLSearch(theXml,
 //:Response)
 But this won't: cfset foo = XMLSearch(theXml, //:AddressDetails)

 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

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!):


?xml version=1.0 encoding=UTF-8?
kml xmlns=http://earth.google.com/kml/2.0;
Response
 namegodalming, surrey, GB/name
 Status
 code200/code
 requestgeocode/request
 /Status

 Placemark id=p1
 addressGodalming, Surrey, UK/address

!-- THE TROUBLESOME BIT --
AddressDetails Accuracy=4
xmlns=urn:oasis:names:tc:ciq:xsdschema:xAL:2.0
 Country
 CountryNameCodeGB/CountryNameCode
 AdministrativeArea
 AdministrativeAreaNameEngland/AdministrativeAreaName
 SubAdministrativeArea
 SubAdministrativeAreaNameSurrey/SubAdministrativeAreaName
 Locality
 LocalityNameGodalming/LocalityName
 /Locality
 /SubAdministrativeArea
 /AdministrativeArea
 /Country
/AddressDetails

Point
 coordinates-0.617529,51.184425,0/coordinates
/Point
/Placemark
/Response
/kml
Ok, so doing like this gets a result: cfset foo = XMLSearch(theXml,
//:Response)

But this won't: cfset foo = XMLSearch(theXml, //:AddressDetails)

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]

 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???)

[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???)

[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

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!):


?xml version=1.0 encoding=UTF-8?
kml xmlns=http://earth.google.com/kml/2.0;
Response
 namegodalming, surrey, GB/name
 Status
 code200/code
 requestgeocode/request
 /Status

 Placemark id=p1
 addressGodalming, Surrey, UK/address

!-- THE TROUBLESOME BIT --
AddressDetails Accuracy=4 xmlns=urn:oasis:names:tc:ciq:xsdschema:xAL:2.0
 Country
 CountryNameCodeGB/CountryNameCode
 AdministrativeArea
 AdministrativeAreaNameEngland/AdministrativeAreaName
 SubAdministrativeArea
 SubAdministrativeAreaNameSurrey/SubAdministrativeAreaName
 Locality
 LocalityNameGodalming/LocalityName
 /Locality
 /SubAdministrativeArea
 /AdministrativeArea
 /Country
/AddressDetails

Point
 coordinates-0.617529,51.184425,0/coordinates
/Point
/Placemark
/Response
/kml
Ok, so doing like this gets a result: cfset foo = XMLSearch(theXml,
//:Response)

But this won't: cfset foo = XMLSearch(theXml, //:AddressDetails)

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:295397
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:295398
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 Needed NYC - Short Term

[Behrouz Khashayar]

We currently have a need for a Coldfusion Expert in NYC to help us with 
analysis of upgrading Coldfusion 5 for one of our applications as follows:

Assess the complexity of the upgrade and the issues we may face. 
Assess the effort needed (time and resources) to complete the upgrade.   
Ensure that the upgrade will actually fix the problems we anticipate it will. 
 
Once the analysis is complete, the assignment could be extended to carry out 
the upgrade project.  

 
Please provide me with a copy of your resume as well as your rate and 
availability.
This is an on site position only (not telecommute). No phone calls please. 

Beh Khashayar
[EMAIL PROTECTED]


~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. 
Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV

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

Re: CFHTTP Expert Needed For Problem Today

[Jim Miller]

Here is an update. We still don't have a solution and are willing to pay a good 
deal for this solution. Please see previous posts in this thread for 
description of the project. Here is where we stand:

1) There is a possibility that a custom CFHTTP tag can do this easily. I was 
sent this by the developer of the tag: 

With CFX_HTTP5 (see http://www.cftagstore.com/tags/cfxhttp5.cfm)
this is very easy and I did exactly the same thing a few times.  CFX_HTTP5 
maintains sessions automatically. Therefore, all that stuff with cookies simply 
not needed. The demo tag is a time limited trial that can be downloaded and 
used.

2) I have a login/bidding solution in PHP that I know works, if this helps 
anyone it is at:

http://65.182.215.250/login-bid.zip


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

CFHTTP Expert Needed For Problem Today

[Tch3]

I have code that I need fixed and I'm willing to  pay $250 to the first 
person who gets it (probably a very simple problem). I am  also willing to pay 
$50 
for your time if you solve it and are not the  first to solve it, but are 
within the first five people to solve it. The code,  which is posted below, 
bids 
on ebay and has worked up until  today. eBay periodically their pages/login 
system and our current code is  missing something that logs the user in 
(possibly 
dealing with cookies  and passing a token). This is urgent.  

The code posted below simply makes a CFHTTP Post call to an ebay page, and  
attempts to get back a confirmation page. The problem is with the login, so I  
would suggest if, when you run the code, nothing comes to mind, write a  short 
procedure that just logs into ebay using the test account provided.
 
Please email me at [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])  if you have 
any 
questions, to talk  about this problem, or would like to submit a solution.
 
Code: _http://65.182.215.250/testebay.zip_ 
(http://65.182.215.250/testebay.zip) 
 
 


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

Re: CFHTTP Expert Needed For Problem Today

[s. isaac dealey]

This is a wild stab in the dark, and may have nothing to do
with your issue, but looking at the code I would recommend
changing Find('offerToken=' in your GetToken1 helper
function with FindNoCase. I don't think eBay is likely to
have that string in their page more than once with different
capitalization, but if someone at eBay happened to change
the caps in that string even accidentally, then the
FindNoCase will continue to work. I'll keep looking at this
a bit more and see if I see anything else. 


On Wed, 1 Nov 2006 12:40:30 EST
[EMAIL PROTECTED] wrote:

 I have code that I need fixed and I'm willing to  pay $250 to the first 
 person who gets it (probably a very simple problem). I am  also willing to 
 pay $50 
 for your time if you solve it and are not the  first to solve it, but are 
 within the first five people to solve it. The code,  which is posted below, 
 bids 
 on ebay and has worked up until  today. eBay periodically their pages/login 
 system and our current code is  missing something that logs the user in 
 (possibly 
 dealing with cookies  and passing a token). This is urgent.  
 
 The code posted below simply makes a CFHTTP Post call to an ebay page, and  
 attempts to get back a confirmation page. The problem is with the login, so I 
  
 would suggest if, when you run the code, nothing comes to mind, write a  
 short 
 procedure that just logs into ebay using the test account provided.
  
 Please email me at [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED])  if you have 
 any 
 questions, to talk  about this problem, or would like to submit a solution.
  
 Code: _http://65.182.215.250/testebay.zip_ 
 (http://65.182.215.250/testebay.zip) 
 
-- 
s. isaac dealey512.372.8890
new epoch  isn't it time for a change? 

http://coldfusion.sys-con.com/author/4806Dealey.htm
http://www.fusiontap.com
http://www.turnkey.to


~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

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

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

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

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

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

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!

[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!

[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!

[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!

[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

Expert ColdFusion Developer, looking for telecommuting projects

[Johnny Le]

Merrimack is not out yet and this person already has experience with it.  S/he 
is truly an expert:-)

Sorry, I don't mean to be mean, but I have to say something.  I can't help it.  
Forgive me :-)

Johnny

I am an experienced and advanced certified CF developer/architect,
with almost 7 years CF experience (from CF3 all the way up to
Merrimack)

~|
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:11:2757
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Expert ColdFusion Developer, looking for telecommuting projects

[Aaron Rouse]

Perhaps it is in Beta or Alpha or RC, of course talking about such things I 
am sure is against an NDA

On 8/8/05, Johnny Le [EMAIL PROTECTED] wrote: 
 
 Merrimack is not out yet and this person already has experience with it. 
 S/he is truly an expert:-)
 
 Sorry, I don't mean to be mean, but I have to say something. I can't help 
 it. Forgive me :-)
 
 Johnny
 
 I am an experienced and advanced certified CF developer/architect,
 with almost 7 years CF experience (from CF3 all the way up to
 Merrimack)
 
 

~|
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:11:2758
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

Re: Expert ColdFusion Developer, looking for telecommuting projects

[Jerry Johnson]

It doesn't say up to and including, so it could be argued it means
every version before Merrimack.

And by including Merrimack in the name, it shows s/he to be up on the
next release info.

On 8/8/05, Aaron Rouse [EMAIL PROTECTED] wrote:
 Perhaps it is in Beta or Alpha or RC, of course talking about such things I
 am sure is against an NDA

~|
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:11:2759
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54

RE: Expert ColdFusion Developer, looking for telecommuting projects

[Christopher Watson]

[Moving this to CF-Jobs-Talk.  Hope the leap doesn't confuse anyone.]

OK, it looks like it's time for me to clarify my statements.  Sigh...

I did say _if_ I were in a position..., which means I am not.  I have been.  
But am not now.

I, too, have not worked for a single company that did not have a clause in the 
employment agreement or hiring contract that included additional employment 
stipulations similar to those shared by the initiator of this thread.  And I 
have always abided by those documented policies.  I would want to be very clear 
on these policies prior to accepting any employment, and I would want to be as 
clear about them if I were hiring.

My willingness to work for a company based on cultural stigmas is an entirely 
different matter.  If the pervading attitude is that side work is frowned 
upon, in spite of documented policy that permits it under clearly stated 
conditions, then that's a company I would seriously think about leaving (if 
already there), or not accepting employment from. At the very least, I'd want 
to discuss with my superiors the possibility of revising the policy to be more 
in line with the popular position of management.  The initiator of this thread 
appears to be in such a situation.  His company's policy permits the work, but 
he's running under the cloak of secrecy to evade something of the culture.  Not 
good.

And because you mentioned it, Yes... _If_ I were in a position to make hiring 
decisions, I would want to inquire, tactfully, about a potential contractor's 
primary employer's moonlighting policy. I would not want to make the investment 
in an individual that subsequently may have to comply with a policy that 
prohibits the work I'm hiring him/her for.  But that inquiry would not include 
any request for subjective characterizations of the bent of management at that 
primary employer toward outside work.

Clearly, the initiator of this thread has issues with revealing to his 
superiors the fact that he is looking for outside work.  And in knowing that 
his superiors don't like the idea of that, his ethics are brought into question 
by doing so.  He may not think so, but I do.  Instead, he very much needs to 
approach his superiors and open a dialogue with them on the topic of the 
apparent conflicting stances within the company with regard to outside work.

-Christopher

-Original Message-
From: Jen Perkins [EMAIL PROTECTED]
Sent: Aug 8, 2005 4:24 PM
To: CF-Jobs cf-jobs@houseoffusion.com
Subject: RE: Expert ColdFusion Developer, looking for telecommuting projects

Wow, really?  Because every tech company I've ever worked for has had a
clause like this in the hiring contract.  Every single one.   I generally
don't do contract work on the side because I'd rather have more time for my
family than a few extra bucks in my pocket, but I know lots of people who do
take freelance work on the side (and I've been offered it before, myself).
Do you normally hire people who only freelance, then?  Or do you interrogate
people on their primary employer's moonlighting policy before you hire them?

Jen Perkins
Macromedia Certified ColdFusion Developer

~|
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:11:2760
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/11
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:11
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.11
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

[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 cf-talk@houseoffusion.com
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

[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

[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

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

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: 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 CFPARAM
default= name=url. 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

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

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

[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

[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

[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

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]

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]

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]

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 SourcePrefixDestField 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]

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

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

 
cflock timeout=10 
 throwontimeout=yes 
 type=exclusive 
 scope=server

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

 
cfdump var=#request.result#

 

process.cfc

 
cfcomponent

 cfscript
 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));
 /cfscript

 cffunction access=public 
name=fnExecute 
output=false 
returntype=struct

 
!--- I do nothing ---
cfargument name=myArgument 
type=string 
required=true

 
cftry
!--- I error for test purposes ---
cfoutput#ttt#/cfoutput
cfcatch type=any
 !--- Update isError to true ---
 cfset structUpdate(this.result.error, isError, true)
 !--- Append the error message ---
 cfset this.result.objError.fnAppend( this.result, 'this is the message
' )
/cfcatch
/cftry

 
cfreturn this.result
 /cffunction

 
/cfcomponent


error.cfc

 
cfcomponent displayname=Error 
 hint=I work with errors

 !--- Function ---
 cffunction access=public 
name=fnAppend 
output=false 
returntype=any 
displayname=Error Append 
hint=I append an error message to an array

 
cfargument name=result 
type=struct 
required=true 
displayname=Result Structure 
hint=I am the Result Structure
cfargument name=errorMessage 
type=string 
required=true 
default=There was an error 
displayname=Error Message 
hint=I am the error message to append

 
!--- Append the error and return the array that contains the errors ---
cfreturn arrayAppend(arguments.result.error.myArray,
arguments.errorMessage)
 /cffunction

!--- Function ---
 cffunction access=public 
name=fnConstruct 
output=false 
returntype=struct 
displayname=Error Construct 
hint=I construct error messages

 
cfargument name=result 
type=struct 
required=true 
displayname=Result Structure 
hint=I am the Result Structure

 
!--- Construct the error, if any ---
cfif arguments.result.error.isError
cfset string = pThere are some errors, please correct;/pul
cfloop from=1 to=#arrayLen(arguments.result.error.myArray)#
index=i
 cfset string = string  li#arguments.result.error.myArray[ i
]#/li
/cfloop
cfset string = string  /ul
!--- Update the result structure with the error string ---
cfset structUpdate(arguments.result.error, myString, string)
/cfif

 
cfreturn arguments.result
 /cffunction

!--- Function ---
 cffunction access=public 
name=fnDisplay 
output=true 
returntype=any 
displayname=Error Display 
hint=I display error messages

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

 
!--- Update the displayed property ---
cfscript
structUpdate(arguments.result.error, isDisplayed, true);
/cfscript

 
cfreturn arguments.result
 /cffunction

cffunction access=public 
name=fnClear 
output=false 
returntype=any 
displayname=Error Clear 
hint=I clear error messages

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

 
!--- Clear the array ---
cfreturn arrayClear(arguments.result.error.myArray)
 /cffunction

 
/cfcomponent

 
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?

[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]

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, MD20742-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?

[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, MD20742-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?

[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: 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]

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 tS 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?

[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?

[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?

[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?

[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]