RE: Cookies

2003-10-01 Thread Dave Watts
 So for website1.domain.com 
 cfcookie name=adminUser value=#form.username# 
 domain=website1.domain.com
 
 And
 Website2.domain.com
 cfcookie name=adminUser value=#form.username# 
 domain=website2.domain.com
 
 Would set them differently .. and if you where on website1 
 with that cookie set, and then tried to go to website2, the 
 cookie would not be available correct?

No, apparently I have it backwards. According to the local test I just ran,
if you omit the DOMAIN attribute, the cookies are host-specific. If you want
the cookies to be available to all hosts within domain.com, you'd set the
DOMAIN attribute to .domain.com (note the leading period).

Sorry for the misdirection.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

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




DWMX Database Connection

2003-10-01 Thread Shahzad.Butt
I've set up RDS and can view my datasourcees in Dreamweaver. Problem is
that the font (font size) is weird and I cannot read anything. I can
click on a datasource by guessing and then i can see tables as well but
font is soweird that I am unable to read anything. Can someone tell me
how to make it readable (under database)?
 
 
Thanks
 
Shahzad.Butt
Ph:+44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
 

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




RE: DWMX Database Connection

2003-10-01 Thread Shahzad.Butt
Problem solved - changed the fonts to SMALL under display - settings -
advance

	-Original Message-
	From: Shahzad.Butt 
	Sent: 01 October 2003 10:21
	To: CF-Talk
	Subject: DWMX Database Connection
	
	
	I've set up RDS and can view my datasourcees in Dreamweaver.
Problem is
	that the font (font size) is weird and I cannot read anything. I
can
	click on a datasource by guessing and then i can see tables as
well but
	font is soweird that I am unable to read anything. Can someone
tell me
	how to make it readable (under database)?
	
	
	Thanks
	
	Shahzad.Butt
	Ph:+44 (0) 1992 701 722
	Fax: +44 (0) 1992 701 604
	
	
_

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




Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread Calvin Ward
The observation is probably one of those, here's another thing that indicates a certain amount of people have an off view of what ColdFusion is and offers, kind of observations...

- Calvin
- Original Message - 
From: Michael T. Tangorre 
To: CF-Talk 
Sent: Tuesday, September 30, 2003 11:21 PM
Subject: RE: CFV: comp.lang.coldfusion Usenet Newsgroup


I don't think it matters, since we all know where they are anyways :-)

-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 6:45 PM
To: CF-Talk
Subject: RE: CFV: comp.lang.coldfusion Usenet Newsgroup


Speaking of more legitimacy -- what's up with chain bookstores always filing
the CF titles under graphic/web design?

I asked an employee of my local Barnes and Nobel the other day and he said
this was a corporate decision.

Personally, it always irks me that CF books aren't in with the programming
books.Maybe we should all start complaining to the chains about this, and
MM -- MM should file its own protests. I think.

H.



~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~

 -Original Message-
 From: Dave Hodder [SMTP:[EMAIL PROTECTED]
 Sent: Saturday, September 27, 2003 12:38 PM
 To: CF-Talk
 Subject: Re: CFV: comp.lang.coldfusion Usenet Newsgroup
 
 Jim McAtee wrote:
 
  There's already a CF newsgroup.Why the need for another?
 
 It's covered in the comp.lang.coldfusion rationale.Some of us on the 
 existing alt.comp.lang.coldfusion group feel a proper comp.* group 
 would give ColdFusion more legitimacy, as well as the group having 
 better propagation, longer message retention periods, etc.
 
 Regards,
 
 Dave
 
_
 
 [ Todays Threads 
 _



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




Breadcrumbs in Cold Fusion

2003-10-01 Thread Deetra Whatley
Good Day,

Does anyone have any code for breadcrumbs in Cold Fusion.

If so and possible may I have a sample of that code.I would like to use breadcrumbs with Cold Fusion in my site.

Thank you.

Deetra Whatley
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Breadcrumbs in Cold Fusion

2003-10-01 Thread Randell B Adkins
What I do is have a CutomTag (BCMenu.cfm).
When needed I call the CustomTag passing 3 parameters:

CF_BCMenu
ItemName=First Link, Second Link, Third Link
ItemLink=aaa.cfm,bbb.cfm,ccc.cfm
ActiveItem=This Page Name

The Custom Tag writes out:
cfloop index=i from=1 to=#ListLen(ATTRIBUTES.ItemName)#
	cfoutput
		a
href="">

img
src="">
	/cfoutput
/cfloop
!--- Output the current page title ---
cfoutput#ATTRIBUTES.ActiveItem#/cfoutput


 [EMAIL PROTECTED] 10/01/03 06:43AM 
Good Day,

Does anyone have any code for breadcrumbs in Cold Fusion.

If so and possible may I have a sample of that code.I would like to
use breadcrumbs with Cold Fusion in my site.

Thank you.

Deetra Whatley

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




Re: Breadcrumbs in Cold Fusion

2003-10-01 Thread Thomas Chiverton
On Wednesday 01 Oct 2003 11:56 am, Randell B Adkins wrote:
 What I do is have a CutomTag (BCMenu.cfm).
 When needed I call the CustomTag passing 3 parameters:

 CF_BCMenu
 ItemName=First Link, Second Link, Third Link
 ItemLink=aaa.cfm,bbb.cfm,ccc.cfm
 ActiveItem=This Page Name

Or you can build it dynamicaly from the path to the current file, or based on 
any parent relationships in your application.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

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




Extract Domain and scriptname seperate

2003-10-01 Thread Ketan Patel
Hi,
I am looking for a way to extract the domain name and the script name to be
seprated.
Eg: Following is my URL
http://www.yourname.com/abc/support.cfm?abc=123

then it should return 2 different valuesseperate
http://www.yourname.com and /abc/support.cfm?abc=123

or
http://www.abc.com/

should return just http://www.abc.com

or

http://www.abc.com

should return just http://www.abc.com



Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com


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




Re: Extract Domain and scriptname seperate

2003-10-01 Thread Randell B Adkins
WHat you are looking for are the following:

CGI.SEVER_NAME = http://www.abc.com

CGI.SCRIPT_NAME = /index.cfm?id=500


 [EMAIL PROTECTED] 10/01/03 07:19AM 
Hi,
I am looking for a way to extract the domain name and the script name
to be
seprated.
Eg: Following is my URL
http://www.yourname.com/abc/support.cfm?abc=123 

then it should return 2 different valuesseperate
http://www.yourname.com and /abc/support.cfm?abc=123

or
http://www.abc.com/ 

should return just http://www.abc.com 

or

http://www.abc.com 

should return just http://www.abc.com 



Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com



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




RE: JDBC, Oracle, and CFMX 6.1 J2EE

2003-10-01 Thread Aidan Whitehall
 [snip]
 Having installed the update, I found that queries that retrieve
several fields, one
 of which is a long, throw the following error 50% of the time when
they're run:
 
 Error Executing Database Query.
 [Macromedia][SequeLink JDBC Driver]Network problem, session aborted
due
 to internal error in remote procedure call, connection closed. 
 [snip]

For the benefit of the archives, following Sean's advice in some
long-forgotten thread dug up yesterday, installing the latest Oracle
JDBC drivers from this page:

 
http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html


resolved the error thrown when retrieving a long char column in Oracle
via cfquery.


Thanks Sean:-)

-- 
Aidan Whitehall mailto:[EMAIL PROTECTED]
Macromedia ColdFusion Developer
Fairbanks Environmental Ltd+44 (0)1695 51775
Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards


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




RE: Extract Domain and scriptname seperate

2003-10-01 Thread Ketan Patel
Hi,
In my case I have a form where people submit a URL and on post I have to
extract this into pieces.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com


-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 7:24 AM
To: CF-Talk
Subject: Re: Extract Domain and scriptname seperate


WHat you are looking for are the following:

CGI.SEVER_NAME = http://www.abc.com

CGI.SCRIPT_NAME = /index.cfm?id=500


 [EMAIL PROTECTED] 10/01/03 07:19AM 
Hi,
I am looking for a way to extract the domain name and the script name
to be
seprated.
Eg: Following is my URL
http://www.yourname.com/abc/support.cfm?abc=123

then it should return 2 different valuesseperate
http://www.yourname.com and /abc/support.cfm?abc=123

or
http://www.abc.com/

should return just http://www.abc.com

or

http://www.abc.com

should return just http://www.abc.com



Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com




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




RE: Need hosting company feedback: UplinkEarth.com

2003-10-01 Thread Erika L. Walker-Arnold
Hatton:
 
Sent you a reply personally as well. Check out CF-Community archives for
some more reviews UplinkEarth.com Rant

Cheers,
Erika

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 11:59 PM
To: CF-Talk
Subject: Need hosting company feedback: UplinkEarth.com


Okay, I'm looking into finding a different host for my site and
something a
friend of mine and I are working on together and I came across
UplinkEarth.com

There plan comparison page:
http://www.uplinkearth.com/virtualHosting.cfm?view=value
(It's a CF page, YAY!)

I'm looking at either their micro or primary plans.Anyone worked with
these guys before?


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




RE: DWMX Database Connection

2003-10-01 Thread Peter Tilbrook
ShazButt?


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




RE: Need hosting company feedback: UplinkEarth.com

2003-10-01 Thread Randell B Adkins
I have about 5 sites with them. Support has been great.
Support turnaround has been within minutes not hours
or days.



 [EMAIL PROTECTED] 10/01/03 07:58AM 
Hatton:
 
Sent you a reply personally as well. Check out CF-Community archives
for
some more reviews UplinkEarth.com Rant

Cheers,
Erika

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 11:59 PM
To: CF-Talk
Subject: Need hosting company feedback: UplinkEarth.com


Okay, I'm looking into finding a different host for my site and
something a
friend of mine and I are working on together and I came across
UplinkEarth.com

There plan comparison page:
http://www.uplinkearth.com/virtualHosting.cfm?view=value 
(It's a CF page, YAY!)

I'm looking at either their micro or primary plans.Anyone worked
with
these guys before?



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




Returning Results from a Stored Proc in Oracle

2003-10-01 Thread Ryan Geesaman
I am trying to use cfstoredproc to return results from Oracle.I have seen a few different suggestions on how to accomplish this, but none have worked.

First Try:
In Oracle --
	PACKAGE STORED_PROC_TEST
	IS
	 TYPE CUSTOM_REF_CURSOR IS REF CURSOR;
	 PROCEDURE get_data(p_criteria IN VARCHAR2,
	p_the_results IN OUT CUSTOM_REF_CURSOR);
	END;
In CF --
 	cfstoredproc procedure=stored_proc_test.get_data datasource=#session.dsn#
		cfprocparam type=in
 cfsqltype=cf_sql_varchar
 value=test
 dbvarname=p_criteria
		cfprocparam type=out
 cfsqltype=cf_sql_refcursor
 variable=p_the_results
		cfprocresult name=dataFromStoredProc
	/cfstoredproc
	This results in The specified SQL type is not supported by this driver.

Second Try:
In Oracle -- same as above
In CF -- second cfprocparam is dropped completely
	This results in wrong number or types of arguments in call to 'GET_DATA'

Any help would be appreciated,
Ryan A. Geesaman
Applications Developer
Penn State College of Medicine
Health Evaluation Sciences
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Need hosting company feedback: UplinkEarth.com

2003-10-01 Thread Randell B Adkins
They do restrict the use of CFFIEL and CFDIRECTORY

HOWEVER, they have their own version which is
good for security. CFX_FileManager.

Overall still have been pleased with them.

 [EMAIL PROTECTED] 10/01/03 08:13AM 
I have about 5 sites with them. Support has been great.
Support turnaround has been within minutes not hours
or days.



 [EMAIL PROTECTED] 10/01/03 07:58AM 
Hatton:
 
Sent you a reply personally as well. Check out CF-Community archives
for
some more reviews UplinkEarth.com Rant

Cheers,
Erika

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, September 30, 2003 11:59 PM
To: CF-Talk
Subject: Need hosting company feedback: UplinkEarth.com


Okay, I'm looking into finding a different host for my site and
something a
friend of mine and I are working on together and I came across
UplinkEarth.com

There plan comparison page:
http://www.uplinkearth.com/virtualHosting.cfm?view=value 
(It's a CF page, YAY!)

I'm looking at either their micro or primary plans.Anyone worked
with
these guys before?




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




cfschedule | scheduled tasks

2003-10-01 Thread Tony Weeg
hi there.

just thinking about how to dynamically send reports to clients on a schedule
and wondering
how solid cfschedule and the scheduled tasks are in cfmx?I mean, does it
barf or slow down
or run into issues at any point in time/related to the amount of scheduled
tasks are requested
to run?if I have 100 clients that want a report @ midnight each Friday
sent to an email, does
cf tend to be the bottleneck?or would you say that they sql server or
email server would be
the bottleneck?any experiences good/bad would be nice :)

thanks!

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

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




OT: Looking for radio station sites

2003-10-01 Thread Mike Kear
I've been asked to do a site plan for a volunteer radio station, and I'm
looking for good, informative, radio station sites. 

My brief is it has to be totally dynamic, because no one technical will be
available on a regular basis to update it.That means I'll be going to run
the site by having people on the station log in and use browser forms to
update database tables to alter the content.

But it's a volunteer station and closely intertwined with the local
community, so I need to make a lot of that part - we're part of the local
community kind of thing.

I have made a plan for much of the site, but I'd love to see what some of
you think are really good radio station sites. 

Any ideas please?



Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.





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




Re: cfschedule | scheduled tasks

2003-10-01 Thread Randell B Adkins
We run a scheduled process via CFSCHEDULE to send approximately 
2,000 emails to members all in one shot. I think we have it set to 
kickoff at 5AM in the morning.

Have had it running for a good while now w/o a problem.

 [EMAIL PROTECTED] 10/01/03 08:42AM 
hi there.

just thinking about how to dynamically send reports to clients on a
schedule
and wondering
how solid cfschedule and the scheduled tasks are in cfmx?I mean, does
it
barf or slow down
or run into issues at any point in time/related to the amount of
scheduled
tasks are requested
to run?if I have 100 clients that want a report @ midnight each
Friday
sent to an email, does
cf tend to be the bottleneck?or would you say that they sql server
or
email server would be
the bottleneck?any experiences good/bad would be nice :)

thanks!

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net 
[EMAIL PROTECTED] 
410.548.2337


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




Re:OT: Looking for radio station sites

2003-10-01 Thread Jeremy Brodie
Mike,

I'm a fan a Launch.com, especally the sections where one can customize their own stations. I think they do a great job, through their influencers section of bringing community based radio to the forefront.

The hard part of course for delivering Internet radio is gathering the content, encoding the content and streaming the content in a way that ads are played at the right time/place (not the technology of picking the actual songs). 

This part is extremely tricky to automate, espcally if you're using Windows Media Server to stream.

Jeremy Brodie
Intelix
an Edgewater Technology Solutions Company

web: http://www.edgewater.com
phone:(703) 815-2500
nasdaq symbol: EDGE


I've been asked to do a site plan for a volunteer radio station, and I'm
looking for good, informative, radio station sites. 

My brief is it has to be totally dynamic, because no one technical will be
available on a regular basis to update it.That means I'll be going to run
the site by having people on the station log in and use browser forms to
update database tables to alter the content.

But it's a volunteer station and closely intertwined with the local
community, so I need to make a lot of that part - we're part of the local
community kind of thing.

I have made a plan for much of the site, but I'd love to see what some of
you think are really good radio station sites. 

Any ideas please?



Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.





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




cacheRealPath question

2003-10-01 Thread Demarco, Alex
We run the full Jrun with CFMX 6.1 deployed within it.Occasionally we get
a problem where CFMX says a file does not exist but it does.Restart the
instance and it is fine for a while.

I found a forum message that says to change this line in your
server/jrun.xml file:

attribute name=cacheRealPathtrue/attribute to false

But this attribute is not present in the jrun.xml file, so my question is
where do I put it in the file? Is there a particular place?

Thanks!

- Alex

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




RE: Extract Domain and scriptname seperate

2003-10-01 Thread A.Little
You could treat the form field as a list delimited by '/', then you'll have
the first 2 list elements will give the protocol and the domain name, and
the remaining list elements would give you the script name and query
string... something like:
 
cfset domain_part = listgetat(form.myurl,1,'/')  '//' 
listgetat(form.myurl,2,'/')
cfset form.myurl = listdeleteat(form.myurl,1,'/')
cfset form.myurl = listdeleteat(form.myurl,1,'/')
cfset script_and_query_part = '/'  form.myurl
 
or you could look at using a regular _expression_.
 
Alex

-Original Message-
From: Ketan Patel [mailto:[EMAIL PROTECTED] 
Sent: 01 October 2003 12:34
To: CF-Talk
Subject: RE: Extract Domain and scriptname seperate


Hi,
In my case I have a form where people submit a URL and on post I have to
extract this into pieces.

Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.comhttp://www.g3group.com
http://www.g3group.com 





_


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




Re: Returning Results from a Stored Proc in Oracle

2003-10-01 Thread Deanna Schneider
Ryan,
Not sure if this changed with MX, but in 5.0, you had to add maxrows=-1 to
your out parameter, so it would look like this:

cfprocparam type=out
cfsqltype=cf_sql_refcursor
variable=p_the_results maxrows=-1 dbvarname=p_the_results

Note that I've also used the dbvarname attribute, though I'm not sure if
it's required.
-d


- Original Message - 
From: Ryan Geesaman [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 7:14 AM
Subject: Returning Results from a Stored Proc in Oracle


 I am trying to use cfstoredproc to return results from Oracle.I have
seen a few different suggestions on how to accomplish this, but none have
worked.

 First Try:
 In Oracle --
 PACKAGE STORED_PROC_TEST
IS
TYPE CUSTOM_REF_CURSOR IS REF CURSOR;
PROCEDURE get_data(p_criteria IN VARCHAR2,
p_the_results IN OUT CUSTOM_REF_CURSOR);
 END;
 In CF --
cfstoredproc procedure=stored_proc_test.get_data
datasource=#session.dsn#
 cfprocparam type=in
 cfsqltype=cf_sql_varchar
 value=test
 dbvarname=p_criteria
 cfprocparam type=out
 cfsqltype=cf_sql_refcursor
 variable=p_the_results
 cfprocresult name=dataFromStoredProc
 /cfstoredproc
 This results in The specified SQL type is not supported by this driver.

 Second Try:
 In Oracle -- same as above
 In CF -- second cfprocparam is dropped completely
 This results in wrong number or types of arguments in call to 'GET_DATA'

 Any help would be appreciated,
 Ryan A. Geesaman
 Applications Developer
 Penn State College of Medicine
 Health Evaluation Sciences

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




Re: Breadcrumbs in Cold Fusion

2003-10-01 Thread GH - CF
Pardon my ignorance  novicenessbut what are breadcrumbs (other 
than the real world thing you use to coat food)

Deetra Whatley wrote:

 Good Day,

 Does anyone have any code for breadcrumbs in Cold Fusion.

 If so and possible may I have a sample of that code.I would like to 
 use breadcrumbs with Cold Fusion in my site.

 Thank you.

 Deetra Whatley
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread Gabriel Robichaud
Well, here in CANADA ;) they always file them in Programming, and sometimes
in Web-Programming hehehehe
 
_
Gabriel Robichaud
Analyste-programmeur
 
Technomedia Formation inc.
1001, boul. De Maisonneuve Ouest 5e tage
Montral (Qubec) H3A 3C8
Tlphone :(514) 287-1561 poste 308
Tlcopieur : (514) 287-1733 
http://www.technomedia.ca
_
 
-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]
Sent: September 30, 2003 6:45 PM
To: CF-Talk
Subject: RE: CFV: comp.lang.coldfusion Usenet Newsgroup
 
Speaking of more legitimacy -- what's up with chain bookstores always filing
the CF titles under graphic/web design?

I asked an employee of my local Barnes and Nobel the other day and he said
this was a corporate decision.

Personally, it always irks me that CF books aren't in with the programming
books.Maybe we should all start complaining to the chains about this, and
MM -- MM should file its own protests. I think.

H.



~~
Howard Owens
Internet Operations Coordinator
Ventura County Star / E.W. Scripps Co.
www.venturacountystar.com
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~

 -Original Message-
 From: Dave Hodder [SMTP:[EMAIL PROTECTED]
 Sent: Saturday, September 27, 2003 12:38 PM
 To: CF-Talk
 Subject: Re: CFV: comp.lang.coldfusion Usenet Newsgroup
 
 Jim McAtee wrote:
 
  There's already a CF newsgroup.Why the need for another?
 
 It's covered in the comp.lang.coldfusion rationale.Some of us on the 
 existing alt.comp.lang.coldfusion group feel a proper comp.* group 
 would give ColdFusion more legitimacy, as well as the group having 
 better propagation, longer message retention periods, etc.
 
 Regards,
 
 Dave
 
_
 
 [ Todays Threads 
_

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




RE: OT: Looking for radio station sites

2003-10-01 Thread Mike Kear
Thanks Jeremy.

 

It's actually a fully-fledged FM station but a community volunteer
organisation.We're not going to be streaming at all - that's far too
expensive.It costs thousands for the bandwidth to stream broadcast quality
content for 24/7.The station has been going for nearly 21 years now, and
for the 21stbirthday we're going to rebuild the site.

 

I've been maintaining it for a while now, and it's all static and pretty
boring really. I had to make a change to the nav bar the other day and
because it's all static, it took me a couple of hours to make and test all
the changes.NO!That has to stop. 

 

SO . dynamic site.Use coldfusion to build the site from a database.Now.
What to put in the site?What would be better to have than we have now?
That's the point I'm at. 

 

 

 

Cheers,

Michael Kear

Windsor, NSW, Australia

AFP Webworks.

 

 

 

 

-Original Message-
From: Jeremy Brodie [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, 1 October 2003 10:56 PM
To: CF-Talk
Subject: Re:OT: Looking for radio station sites

 

Mike,

I'm a fan a Launch.com, especally the sections where one can customize their
own stations. I think they do a great job, through their influencers section
of bringing community based radio to the forefront.

The hard part of course for delivering Internet radio is gathering the
content, encoding the content and streaming the content in a way that ads
are played at the right time/place (not the technology of picking the actual
songs). 

This part is extremely tricky to automate, espcally if you're using Windows
Media Server to stream.

Jeremy Brodie
Intelix
an Edgewater Technology Solutions Company

web: http://www.edgewater.com
phone:(703) 815-2500
nasdaq symbol: EDGE





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




RE: cfschedule | scheduled tasks

2003-10-01 Thread Tony Weeg
so if someone was going to make it so that cfscheduled events were
individual to a user, and then give
the user access to modify/update/delete/change the frequency how would one
make it so that
the tasks scheduled were unique to a user?I know how to get a list of all
of the scheduled tasks
and I know I could keep a record in sql server of each one scheduled, but I
don't really see much
that could be unique so as to indentify to the cf server when the user pulls
up theirs...that its unique
to them...maybe the username field?

any ideas? 


...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 8:47 AM
To: CF-Talk
Subject: Re: cfschedule | scheduled tasks

We run a scheduled process via CFSCHEDULE to send approximately 2,000 emails
to members all in one shot. I think we have it set to kickoff at 5AM in the
morning.

Have had it running for a good while now w/o a problem.

 [EMAIL PROTECTED] 10/01/03 08:42AM 
hi there.

just thinking about how to dynamically send reports to clients on a schedule
and wondering how solid cfschedule and the scheduled tasks are in cfmx?I
mean, does it barf or slow down or run into issues at any point in
time/related to the amount of scheduled tasks are requested to run?if I
have 100 clients that want a report @ midnight each Friday sent to an email,
does cf tend to be the bottleneck?or would you say that they sql server or
email server would be the bottleneck?any experiences good/bad would be
nice :)

thanks!

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337





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




RE: cfschedule | scheduled tasks

2003-10-01 Thread Randell B Adkins
Mark all the tasks starting with their user_ID

such as:A101_SendStatReport

that would mean that User ID 101 has a 
scheduled task called SendStatReport

The A is just a place holder. Nothing more.

The when you need to list all those for the user:

WHERE Scheduled_Task LIKE 'A101_%'

If it were databased or loop through the Task list
and show only those that match the _expression_.

 [EMAIL PROTECTED] 10/01/03 09:11AM 
so if someone was going to make it so that cfscheduled events were
individual to a user, and then give
the user access to modify/update/delete/change the frequency how would
one
make it so that
the tasks scheduled were unique to a user?I know how to get a list of
all
of the scheduled tasks
and I know I could keep a record in sql server of each one scheduled,
but I
don't really see much
that could be unique so as to indentify to the cf server when the user
pulls
up theirs...that its unique
to them...maybe the username field?

any ideas? 


...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net 
[EMAIL PROTECTED] 
410.548.2337

-Original Message-
From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 8:47 AM
To: CF-Talk
Subject: Re: cfschedule | scheduled tasks

We run a scheduled process via CFSCHEDULE to send approximately 2,000
emails
to members all in one shot. I think we have it set to kickoff at 5AM in
the
morning.

Have had it running for a good while now w/o a problem.

 [EMAIL PROTECTED] 10/01/03 08:42AM 
hi there.

just thinking about how to dynamically send reports to clients on a
schedule
and wondering how solid cfschedule and the scheduled tasks are in cfmx?
 I
mean, does it barf or slow down or run into issues at any point in
time/related to the amount of scheduled tasks are requested to run?if
I
have 100 clients that want a report @ midnight each Friday sent to an
email,
does cf tend to be the bottleneck?or would you say that they sql
server or
email server would be the bottleneck?any experiences good/bad would
be
nice :)

thanks!

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net 
[EMAIL PROTECTED] 
410.548.2337






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




RE: Looking for radio station sites

2003-10-01 Thread cfhelp
http://www.corporateradiosucksass.com/main.html
http://www.corporateradiosucksass.com/main.html 

 

 

This is a spin off of http://www.989throck.com/ http://www.989throck.com/


 

They started the site so they could put up all the crap the corporate office
wouldn't let them.

 

 

Rick

 

_

From: Mike Kear [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 7:45 AM
To: CF-Talk

 

I've been asked to do a site plan for a volunteer radio station, and I'm
looking for good, informative, radio station sites. 

My brief is it has to be totally dynamic, because no one technical will be
available on a regular basis to update it.That means I'll be going to run
the site by having people on the station log in and use browser forms to
update database tables to alter the content.

But it's a volunteer station and closely intertwined with the local
community, so I need to make a lot of that part - we're part of the local
community kind of thing.

I have made a plan for much of the site, but I'd love to see what some of
you think are really good radio station sites. 

Any ideas please?



Cheers,
Michael Kear
Windsor, NSW, Australia
AFP Webworks.







_

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




Re: Extract Domain and scriptname seperate

2003-10-01 Thread Calvin Ward
I thought cgi_SERVER_NAME would return : www.abc.com , if that is what the user was accessing with.

- Calvin
- Original Message - 
From: Randell B Adkins 
To: CF-Talk 
Sent: Wednesday, October 01, 2003 7:23 AM
Subject: Re: Extract Domain and scriptname seperate


WHat you are looking for are the following:

CGI.SEVER_NAME = http://www.abc.com

CGI.SCRIPT_NAME = /index.cfm?id=500


 [EMAIL PROTECTED] 10/01/03 07:19AM 
Hi,
I am looking for a way to extract the domain name and the script name
to be
seprated.
Eg: Following is my URL
http://www.yourname.com/abc/support.cfm?abc=123 

then it should return 2 different valuesseperate
http://www.yourname.com and /abc/support.cfm?abc=123

or
http://www.abc.com/ 

should return just http://www.abc.com 

or

http://www.abc.com 

should return just http://www.abc.com 



Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com




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




Re: Extract Domain and scriptname seperate

2003-10-01 Thread Randell B Adkins
Thats what I mean ratehr than the typo of CGI.SEVER_NAME.
However they are having users submit stuff via form.

So I am sure there is another way but I threw something in there
for them:

I am sure someone will post a better example but here is one since
it is a form variable.

If you can be sure they are using the standard naming conventions
for the URL, then to obtain the server name you could do something
like:

cfset myURL = http://www.abc.com/index.cfm?id=5009

CFSET st_num = 1
CFSET sep_num = 0
CFOUTPUT
CFLOOP CONDITION=sep_num NEQ 3
	CFSET st_num = Find(/,myURL,st_num)	
	cfset sep_num = sep_num + 1
	cfset st_num = st_num + 1
/CFLOOP
/CFOUTPUT

CFSET SERVER_INFO = LEFT(myURL,st_num-1)
cfset SCRIPT_INFO = MID(myURL,st_num,LEN(myURL))


 [EMAIL PROTECTED] 10/01/03 09:23AM 
I thought cgi_SERVER_NAME would return : www.abc.com , if that is what
the user was accessing with.

- Calvin
- Original Message - 
From: Randell B Adkins 
To: CF-Talk 
Sent: Wednesday, October 01, 2003 7:23 AM
Subject: Re: Extract Domain and scriptname seperate


WHat you are looking for are the following:

CGI.SEVER_NAME = http://www.abc.com 

CGI.SCRIPT_NAME = /index.cfm?id=500


 [EMAIL PROTECTED] 10/01/03 07:19AM 
Hi,
I am looking for a way to extract the domain name and the script
name
to be
seprated.
Eg: Following is my URL
http://www.yourname.com/abc/support.cfm?abc=123 

then it should return 2 different valuesseperate
http://www.yourname.com and /abc/support.cfm?abc=123

or
http://www.abc.com/ 

should return just http://www.abc.com 

or

http://www.abc.com 

should return just http://www.abc.com 



Ketan Patel
G3 Technology Group, LLC
Graphics III Advertising, Inc.
(410)789-7007 or (800)783-1799
It's Not Creative if it doesn't Sell.
http://www.g3group.com http://www.g3group.com





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




Re: OT: Looking for radio station sites

2003-10-01 Thread Deanna Schneider
Well, our community radio station's site is pretty blah:
http://www.wort-fm.org/

But, the public radio station site isn't bad, and it's a cf site:
http://www.wpr.org/


- Original Message - 
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:08 AM
Subject: RE: OT: Looking for radio station sites


 Thanks Jeremy.



 It's actually a fully-fledged FM station but a community volunteer
 organisation.We're not going to be streaming at all - that's far too
 expensive.It costs thousands for the bandwidth to stream broadcast
quality
 content for 24/7.The station has been going for nearly 21 years now,
and
 for the 21stbirthday we're going to rebuild the site.



 I've been maintaining it for a while now, and it's all static and pretty
 boring really. I had to make a change to the nav bar the other day and
 because it's all static, it took me a couple of hours to make and test all
 the changes.NO!That has to stop.



 SO . dynamic site.Use coldfusion to build the site from a database.
Now.
 What to put in the site?What would be better to have than we have now?
 That's the point I'm at.







 Cheers,

 Michael Kear

 Windsor, NSW, Australia

 AFP Webworks.









 -Original Message-
 From: Jeremy Brodie [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, 1 October 2003 10:56 PM
 To: CF-Talk
 Subject: Re:OT: Looking for radio station sites



 Mike,

 I'm a fan a Launch.com, especally the sections where one can customize
their
 own stations. I think they do a great job, through their influencers
section
 of bringing community based radio to the forefront.

 The hard part of course for delivering Internet radio is gathering the
 content, encoding the content and streaming the content in a way that ads
 are played at the right time/place (not the technology of picking the
actual
 songs).

 This part is extremely tricky to automate, espcally if you're using
Windows
 Media Server to stream.

 Jeremy Brodie
 Intelix
 an Edgewater Technology Solutions Company

 web: http://www.edgewater.com
 phone:(703) 815-2500
 nasdaq symbol: EDGE






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




RE: OT: Looking for radio station sites

2003-10-01 Thread cfhelp
http://www.bbc.co.uk/6music/index.shtml?logo
http://www.bbc.co.uk/6music/index.shtml?logo 

 

Rick

 

_

From: Deanna Schneider [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 8:27 AM
To: CF-Talk

 

Well, our community radio station's site is pretty blah:
http://www.wort-fm.org/ http://www.wort-fm.org/ 

But, the public radio station site isn't bad, and it's a cf site:
http://www.wpr.org/ http://www.wpr.org/ 


- Original Message - 
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:08 AM
Subject: RE: OT: Looking for radio station sites


 Thanks Jeremy.



 It's actually a fully-fledged FM station but a community volunteer
 organisation.We're not going to be streaming at all - that's far too
 expensive.It costs thousands for the bandwidth to stream broadcast
quality
 content for 24/7.The station has been going for nearly 21 years now,
and
 for the 21stbirthday we're going to rebuild the site.



 I've been maintaining it for a while now, and it's all static and pretty
 boring really. I had to make a change to the nav bar the other day and
 because it's all static, it took me a couple of hours to make and test all
 the changes.NO!That has to stop.



 SO . dynamic site.Use coldfusion to build the site from a database.
Now.
 What to put in the site?What would be better to have than we have now?
 That's the point I'm at.







 Cheers,

 Michael Kear

 Windsor, NSW, Australia

 AFP Webworks.









 -Original Message-
 From: Jeremy Brodie [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, 1 October 2003 10:56 PM
 To: CF-Talk
 Subject: Re:OT: Looking for radio station sites



 Mike,

 I'm a fan a Launch.com, especally the sections where one can customize
their
 own stations. I think they do a great job, through their influencers
section
 of bringing community based radio to the forefront.

 The hard part of course for delivering Internet radio is gathering the
 content, encoding the content and streaming the content in a way that ads
 are played at the right time/place (not the technology of picking the
actual
 songs).

 This part is extremely tricky to automate, espcally if you're using
Windows
 Media Server to stream.

 Jeremy Brodie
 Intelix
 an Edgewater Technology Solutions Company

 web: http://www.edgewater.com http://www.edgewater.com 
 phone:(703) 815-2500
 nasdaq symbol: EDGE








_

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




Re:Third-Party Search Engines with Customizeable Results?

2003-10-01 Thread Don
Does you mean...I meant Do you mean or does it mean An editing feature for the forum seems very desirable.

Does you mean giving users the ability of search the whole site or 
search one to many sections?If a user chooses to search the whole 
site, display the results like:

Resultsets:

Section A:
...

Section C:
...

...


If so, and if your database is not that huge (GB bytes and GB bytes), 
you could use SQL-based search engine vs. verity etc.Tie your db 
design to your search engine.Quite doable.Search is one of my 
favorite topics.Shoot me an email at [EMAIL PROTECTED] if 
you'd like to discuss further.

Li, Chunshen (Don)






 We are currently using FreeFind for many of our clients, and it does 

a very nice job of providing search functionality, but our clients 
are 
increasingly asking for something that allows for a customized set of 

search results pages. For instance, several of our clients would like 

a search engine that displays the results by *section* of the website, 

and then by relevance within those sections.

1) Does anyone know of a search engine that does this?
2) What other search engines do people use that they're happy with? 

Kelly Tetterton 
duo | Technical Lead 
One Web Company. 
Twice the Results. 

312.224.9650 | main 
312.224.9648 | direct 
312.224.9651 | fax 

[EMAIL PROTECTED] 
www.duodesign.com 

duoDesign is a Web development and marketing firm that combines 
expertise in design, technology and online promotion to help 
businesses 
and organizations use the Internet marketing channel to greatest 
advantage. 

 



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




RE: OT: Looking for radio station sites

2003-10-01 Thread Benoit Hediard
The radio I listen every day (fantastic playlist organised in 6 channels,
my favorite one is Beat Blender) :
http://www.somafm.com

Two other great internet radio :
http://www.betalounge.com
http://www.groovetech.com (down or dead?)

As for building your own radio :
http://www.live365.com
(example : my own radio is http://www.benorama.com/music)

Have fun!

Benoit Hediard
www.benorama.com

-Message d'origine-
De : cfhelp [mailto:[EMAIL PROTECTED]
Envoy : mercredi 1 octobre 2003 15:38
 : CF-Talk
Objet : RE: OT: Looking for radio station sites


http://www.bbc.co.uk/6music/index.shtml?logo
http://www.bbc.co.uk/6music/index.shtml?logo



Rick



 _

From: Deanna Schneider [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:27 AM
To: CF-Talk



Well, our community radio station's site is pretty blah:
http://www.wort-fm.org/ http://www.wort-fm.org/

But, the public radio station site isn't bad, and it's a cf site:
http://www.wpr.org/ http://www.wpr.org/


- Original Message -
From: Mike Kear [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:08 AM
Subject: RE: OT: Looking for radio station sites


 Thanks Jeremy.



 It's actually a fully-fledged FM station but a community volunteer
 organisation.We're not going to be streaming at all - that's far too
 expensive.It costs thousands for the bandwidth to stream broadcast
quality
 content for 24/7.The station has been going for nearly 21 years now,
and
 for the 21stbirthday we're going to rebuild the site.



 I've been maintaining it for a while now, and it's all static and pretty
 boring really. I had to make a change to the nav bar the other day and
 because it's all static, it took me a couple of hours to make and test
all
 the changes.NO!That has to stop.



 SO . dynamic site.Use coldfusion to build the site from a database.
Now.
 What to put in the site?What would be better to have than we have now?
 That's the point I'm at.







 Cheers,

 Michael Kear

 Windsor, NSW, Australia

 AFP Webworks.









 -Original Message-
 From: Jeremy Brodie [mailto:[EMAIL PROTECTED]
 Sent: Wednesday, 1 October 2003 10:56 PM
 To: CF-Talk
 Subject: Re:OT: Looking for radio station sites



 Mike,

 I'm a fan a Launch.com, especally the sections where one can customize
their
 own stations. I think they do a great job, through their influencers
section
 of bringing community based radio to the forefront.

 The hard part of course for delivering Internet radio is gathering the
 content, encoding the content and streaming the content in a way that
ads
 are played at the right time/place (not the technology of picking the
actual
 songs).

 This part is extremely tricky to automate, espcally if you're using
Windows
 Media Server to stream.

 Jeremy Brodie
 Intelix
 an Edgewater Technology Solutions Company

 web: http://www.edgewater.com http://www.edgewater.com
 phone:(703) 815-2500
 nasdaq symbol: EDGE








 _

[Todays

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




OT: Apache and mod_auth_ldap

2003-10-01 Thread Douglas.Knudsen
abit off topic, but...anyone get LDAP authorisation up and running for Apache 2.0 on Winblows?I've been digging for days and just can't get it to work.

Also, from what i have read, you can't get IIS to auth against an LDAP via basic authentication, correct?I kow you can auth against the AD, but I don't want to go there.

danke

dugOUT¿ 
When I was kidnapped, my parents snapped into action.They rented out my room. -- Woody Allen

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




RE: Returning Results from a Stored Proc in Oracle

2003-10-01 Thread Douglas.Knudsen
I recently got this to work in CFMX against Oracle 9i.Here is my code...sorry its broke up, can't figure out how to get Toad to give me it in one chunk...not enough coffee yet!
 
package def: 
CREATE OR REPLACE PACKAGE PKG_DOUG

AS

TYPE myCursor IS REF CURSOR;

PROCEDURE mySP(inPosnbr IN VARCHAR2, rsCursor OUT myCursor);

END PKG_DOUG;

/

package body:

CREATE OR REPLACE PACKAGE BODY PKG_DOUG

AS

PROCEDURE mySP(inPosnbr IN VARCHAR2, rsCursor OUT myCursor) 

IS

BEGIN

OPEN rsCursor FOR

SELECT 

emplid, posnbr, name

FROM 

pspath

WHERE 

reports_to = inPosnbr

ORDER BY 

name;

END mySP;

END PKG_DOUG;

/

Now the CF code:Note, no need for the maxrows=-1 anymore

cfstoredproc procedure=pkg_doug.mySP datasource=mydsn
 cfprocparam cfsqltype=CF_SQL_VARCHAR dbvarname=inPosnbr value=#form.posnbr#
 cfprocresult name=foo
/cfstoredproc

 

HTH

Doug

-Original Message-
From: Ryan Geesaman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:15 AM
To: CF-Talk
Subject: Returning Results from a Stored Proc in Oracle


I am trying to use cfstoredproc to return results from Oracle.I have seen a few different suggestions on how to accomplish this, but none have worked.

First Try:
In Oracle --
PACKAGE STORED_PROC_TEST
IS
 TYPE CUSTOM_REF_CURSOR IS REF CURSOR;
 PROCEDURE get_data(p_criteria IN VARCHAR2,
p_the_results IN OUT CUSTOM_REF_CURSOR);
END;
In CF --
cfstoredproc procedure=stored_proc_test.get_data datasource=#session.dsn#
cfprocparam type=in
cfsqltype=cf_sql_varchar
value=test
dbvarname=p_criteria
cfprocparam type=out
cfsqltype=cf_sql_refcursor
variable=p_the_results
cfprocresult name=dataFromStoredProc
/cfstoredproc
This results in The specified SQL type is not supported by this driver.

Second Try:
In Oracle -- same as above
In CF -- second cfprocparam is dropped completely
This results in wrong number or types of arguments in call to 'GET_DATA'

Any help would be appreciated,
Ryan A. Geesaman
Applications Developer
Penn State College of Medicine
Health Evaluation Sciences 
_

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




Re[2]: Breadcrumbs in Cold Fusion

2003-10-01 Thread Ubqtous
Randell,

On 10/1/2003 at 09:35, you wrote:

RBA Pardon my ignorance  novicenessbut what are breadcrumbs (other
RBA than the real world thing you use to coat food)

Think Hansel and Gretel

~ Ubqtous ~

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




OT: Freelance Sites

2003-10-01 Thread Brad Roberts
Anyone have suggestions on freelance sites (like rentacoder.com)?I need a
few websites designed, and didn't have much luck with rentacoder.

If you've worked with someone who does nice design work (for a reasonable
price), please send me their username and what site they're on (or how to
get a hold of them).

Thanks,

Brad


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




Re: Returning Results from a Stored Proc in Oracle

2003-10-01 Thread Adam Churvis
If you're looking for a reference on CFMX and Oracle, I cover all this in
detail in The ColdFusion MX Bible, including how to perform compile time
binding of refcursors to explicitly-structured record datatypes (rather than
runtime binding to an entire table structure, which is slower).

Respectfully,

Adam Phillip Churvis
Member of Team Macromedia

Advanced Intensive ColdFusion MX Training
ColdFusion MX Master Class:
September 22 - 26, 2003
http://www.ColdFusionTraining.com

Download CommerceBlocks V2.1 and LoRCAT from
http://www.ProductivityEnhancement.com

The ColdFusion MX Bible is in bookstores now!
- Original Message - 
From: Deanna Schneider [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:04 AM
Subject: Re: Returning Results from a Stored Proc in Oracle


 Ryan,
 Not sure if this changed with MX, but in 5.0, you had to add maxrows=-1
to
 your out parameter, so it would look like this:

 cfprocparam type=out
 cfsqltype=cf_sql_refcursor
 variable=p_the_results maxrows=-1 dbvarname=p_the_results

 Note that I've also used the dbvarname attribute, though I'm not sure if
 it's required.
 -d


 - Original Message - 
 From: Ryan Geesaman [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, October 01, 2003 7:14 AM
 Subject: Returning Results from a Stored Proc in Oracle


  I am trying to use cfstoredproc to return results from Oracle.I have
 seen a few different suggestions on how to accomplish this, but none have
 worked.
 
  First Try:
  In Oracle --
  PACKAGE STORED_PROC_TEST
 IS
 TYPE CUSTOM_REF_CURSOR IS REF CURSOR;
 PROCEDURE get_data(p_criteria IN VARCHAR2,
 p_the_results IN OUT CUSTOM_REF_CURSOR);
  END;
  In CF --
 cfstoredproc procedure=stored_proc_test.get_data
 datasource=#session.dsn#
  cfprocparam type=in
  cfsqltype=cf_sql_varchar
  value=test
  dbvarname=p_criteria
  cfprocparam type=out
  cfsqltype=cf_sql_refcursor
  variable=p_the_results
  cfprocresult name=dataFromStoredProc
  /cfstoredproc
  This results in The specified SQL type is not supported by this
driver.
 
  Second Try:
  In Oracle -- same as above
  In CF -- second cfprocparam is dropped completely
  This results in wrong number or types of arguments in call to
'GET_DATA'
 
  Any help would be appreciated,
  Ryan A. Geesaman
  Applications Developer
  Penn State College of Medicine
  Health Evaluation Sciences


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




Re: Re[2]: Breadcrumbs in Cold Fusion

2003-10-01 Thread Jerry Johnson
Since we have answered the question repeatedly without truly answering it, let me try some specific examples.

Breadcrumbs are often found on the web in the form of a taxonomy/hierarchy.

They can be useful to help create a mental image of the structure of the content. 

For example:

Where are you in an online course?

 Course 111: Section 2: Chapter 6: Review Questions

Where are you in an online catalog?

 Coats: Lightweight Shells: The North Face

Calculating your 401(k) savings:

 Step 1 : Your Info===Step 2 : Your savings=== STEP 3 : YOUR NEEDS=== Step 4 : Your answer

Placing a set of breadcrumbs on a page can serve two purposes:

Identifying where you are in a larger context.
Allow an interface mechanism to move back up the hierarchy by providing links to more general sections.


Does this help at all?

Jerry Johnson

 [EMAIL PROTECTED] 10/01/03 10:17AM 
Randell,

On 10/1/2003 at 09:35, you wrote:

RBA Pardon my ignorance  novicenessbut what are breadcrumbs (other
RBA than the real world thing you use to coat food)

Think Hansel and Gretel

~ Ubqtous ~


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




Re: Extract Domain and scriptname seperate

2003-10-01 Thread Calvin Ward
er, actually I was referring to the lack of http :)

- Calvin
- Original Message - 
From: Randell B Adkins 
To: CF-Talk 
Sent: Wednesday, October 01, 2003 9:24 AM
Subject: Re: Extract Domain and scriptname seperate


Thats what I mean ratehr than the typo of CGI.SEVER_NAME.
However they are having users submit stuff via form.

So I am sure there is another way but I threw something in there
for them:

I am sure someone will post a better example but here is one since
it is a form variable.

If you can be sure they are using the standard naming conventions
for the URL, then to obtain the server name you could do something
like:

cfset myURL = http://www.abc.com/index.cfm?id=5009

CFSET st_num = 1
CFSET sep_num = 0
CFOUTPUT
CFLOOP CONDITION=sep_num NEQ 3
CFSET st_num = Find(/,myURL,st_num) 
cfset sep_num = sep_num + 1
cfset st_num = st_num + 1
/CFLOOP
/CFOUTPUT

CFSET SERVER_INFO = LEFT(myURL,st_num-1)
cfset SCRIPT_INFO = MID(myURL,st_num,LEN(myURL))


 [EMAIL PROTECTED] 10/01/03 09:23AM 
I thought cgi_SERVER_NAME would return : www.abc.com , if that is what
the user was accessing with.

- Calvin
 - Original Message - 
 From: Randell B Adkins 
 To: CF-Talk 
 Sent: Wednesday, October 01, 2003 7:23 AM
 Subject: Re: Extract Domain and scriptname seperate


 WHat you are looking for are the following:

 CGI.SEVER_NAME = http://www.abc.com 

 CGI.SCRIPT_NAME = /index.cfm?id=500


  [EMAIL PROTECTED] 10/01/03 07:19AM 
 Hi,
 I am looking for a way to extract the domain name and the script
name
 to be
 seprated.
 Eg: Following is my URL
 http://www.yourname.com/abc/support.cfm?abc=123 

 then it should return 2 different valuesseperate
 http://www.yourname.com and /abc/support.cfm?abc=123

 or
 http://www.abc.com/ 

 should return just http://www.abc.com 

 or

 http://www.abc.com 

 should return just http://www.abc.com 



 Ketan Patel
 G3 Technology Group, LLC
 Graphics III Advertising, Inc.
 (410)789-7007 or (800)783-1799
 It's Not Creative if it doesn't Sell.
 http://www.g3group.com http://www.g3group.com






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




Settle an argument for me

2003-10-01 Thread Mark Leder
I've been using a UDF called emailAntiSpam, which replaces an email
address in the source code with extended characters which supposedly can't
be crawled and picked up by spambots.

So my address:[EMAIL PROTECTED] would look like:

a
href="">
#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
;#108;#101;#46;#99;#111;#109; target=_blankNotify the
Webmaster/a

My problem, my client thinks they are still being picked up and used for
spam - I also have a robots.txt file set to disallow bot crawling.

I've had both these in place since day one, when the site was posted about 3
months ago.

Does it actually work?

Thanks, Mark 


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




Building a 2 dimensional array from lists (junior question)

2003-10-01 Thread David Adams
I have two lists and I want to combine them into a single two dimensional array, how do I 
do it??

Here are my two lists..

cfset myList1 = apple,banana,orange
cfset myList2 = bird,fish,mammal
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Returning Results from a Stored Proc in Oracle

2003-10-01 Thread Plunkett, Matt
Does your procedure have a body?One thing that can cause problems in
ColdFusion, although probably not the error you are showing, is if you do
not bind all your ref cursors to a valid recordset even when error
conditions result. 
 
Besides that, I have not used an IN OUT ref cursor before from CF.If you
have no reason for keeping it that way, consider making it just an OUT.And
I use variable= instead of dbvarname=.In MX, you are correct that you
do not put a procparam for the ref cursor in.

-Original Message-
From: Ryan Geesaman 
[Plunkett, Matt] 
 
 First Try:
In Oracle --
PACKAGE STORED_PROC_TEST
IS
 TYPE CUSTOM_REF_CURSOR IS REF CURSOR;
 PROCEDURE get_data(p_criteria IN VARCHAR2,
p_the_results IN OUT CUSTOM_REF_CURSOR);
END;
In CF --
cfstoredproc procedure=stored_proc_test.get_data
datasource=#session.dsn#
cfprocparam type=in
cfsqltype=cf_sql_varchar
value=test
dbvarname=p_criteria
cfprocparam type=out
cfsqltype=cf_sql_refcursor
variable=p_the_results
cfprocresult name=dataFromStoredProc



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




Re:Returning Results from a Stored Proc in Oracle - SOLVED

2003-10-01 Thread Ryan Geesaman
I was fairly certain I had tried something similar to this yesterday, but apparently I did something differently because it worked today.Perhaps sleep was the answer.Thanks.

Ryan A. Geesaman
Applications Developer
Penn State College of Medicine
Health Evaluation Sciences 

I recently got this to work in CFMX against Oracle 9i.Here is my 
code...sorry its broke up, can't figure out how to get Toad to give me 
it in one chunk...not enough coffee yet!
 

package def: 
CREATE OR REPLACE PACKAGE PKG_DOUG

AS

TYPE myCursor IS REF CURSOR;

PROCEDURE mySP(inPosnbr IN VARCHAR2, rsCursor OUT myCursor);

END PKG_DOUG;

/

package body:

CREATE OR REPLACE PACKAGE BODY PKG_DOUG

AS

PROCEDURE mySP(inPosnbr IN VARCHAR2, rsCursor OUT myCursor) 

IS

BEGIN

OPEN rsCursor FOR

SELECT 

emplid, posnbr, name

FROM 

pspath

WHERE 

reports_to = inPosnbr

ORDER BY 

name;

END mySP;

END PKG_DOUG;

/

Now the CF code:Note, no need for the maxrows=-1 anymore

cfstoredproc procedure=pkg_doug.mySP datasource=mydsn
 
cfprocparam cfsqltype=CF_SQL_VARCHAR dbvarname=inPosnbr 
value=#form.posnbr#
 
cfprocresult name=foo
/cfstoredproc

 


HTH

Doug

-Original Message-
From: Ryan Geesaman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:15 AM
To: CF-Talk
Subject: Returning Results from a Stored Proc in Oracle


I am trying to use cfstoredproc to return results from Oracle.I 
have seen a few different suggestions on how to accomplish this, but 
none have worked.

First Try:
In Oracle --
PACKAGE STORED_PROC_TEST

IS
 
TYPE CUSTOM_REF_CURSOR IS REF CURSOR;
 
PROCEDURE get_data(p_criteria IN VARCHAR2,

p_the_results IN OUT CUSTOM_REF_CURSOR);
END;
In CF --
cfstoredproc procedure=stored_proc_test.get_data 
datasource=#session.dsn#
cfprocparam type=in
cfsqltype=cf_sql_varchar
value=test
dbvarname=p_criteria
cfprocparam type=out
cfsqltype=cf_sql_refcursor
variable=p_the_results
cfprocresult name=dataFromStoredProc
/cfstoredproc
This results in The specified SQL type is not supported by this 
driver.

Second Try:
In Oracle -- same as above
In CF -- second cfprocparam is dropped completely
This results in wrong number or types of arguments in call to 
'GET_DATA'

Any help would be appreciated,
Ryan A. Geesaman
Applications Developer
Penn State College of Medicine
Health Evaluation Sciences 

_

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




RE: Settle an argument for me

2003-10-01 Thread Shawn Regan
I would say no. But you need to ask yourself. Are these Spam bots smart
enough to reverse the extended chars? If they are setup with this type of
function, then yes I would say they are still picking them up.
 
I would say this is just a guess they are not doing this type of function
while gathering emails.
 
Shawn Regan
Head Applications Developer
pacifictechnologysolutions 

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 7:37 AM
To: CF-Talk
Subject: Settle an argument for me


I've been using a UDF called emailAntiSpam, which replaces an email
address in the source code with extended characters which supposedly can't
be crawled and picked up by spambots.

So my address:[EMAIL PROTECTED] would look like:

a
href="">
#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
;#108;#101;#46;#99;#111;#109; target=_blankNotify the
Webmaster/a

My problem, my client thinks they are still being picked up and used for
spam - I also have a robots.txt file set to disallow bot crawling.

I've had both these in place since day one, when the site was posted about 3
months ago.

Does it actually work?

Thanks, Mark 


_

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




Re: Returning Results from a Stored Proc in Oracle

2003-10-01 Thread Adam Churvis
OOPS!Sent too early!

Basically, in the package header, create RECORD data types dimensioned the
same as the result set row, and use Tablename.Columnname%TYPE as the
datatype specification for each record key:

TYPE recEmployee IS RECORD (
 vCompanyID Company.CompanyID%TYPE,
 vEmployeeSSNEmployee.EmployeeSSN%TYPE,
 vEmployeeName Employee.EmployeeName%TYPE
);

One for each result set.Then specify that your cursor is dimensioned as
this record type:

TYPE curEmployees IS REF CURSOR RETURN recEmployee;

Now, in your package header (as well as in your procedure prototypes inside
the package), specify the cursors as output variables:

PROCEDURE sp_MyProc (
 vSomething IN Char,
 vOtherthing IN Int,
 rsEmployees OUT curEmployees,
 rsOtherRecSet OUT curOtherCursor
);

Inside your procedure, open the cursor:

OPEN rsEmployees FOR
Select ...

So that's your Oracle package in a nutshell.Now onto the procedure call.

In CF5 it was... *strange* to say the least, but in CFMX it's pretty
straightforward:

Call the stored procedure using CFSTOREDPROC in the form
name=PackageName.ProcedureName, specify the input variables (and any
non-cursor output variables) using CFPROCPARAM, then enumerate your
resultsets as normal using CFPROCRESULT.Nothing special to do anymore
other than these things.

If you have any problems, please feel free to call on my any time at
770-446-8866.I'm at your service.

Hope this helps! :)

Respectfully,

Adam Phillip Churvis
Member of Team Macromedia

Advanced Intensive ColdFusion MX Training
ColdFusion MX Master Class:
September 22 - 26, 2003
http://www.ColdFusionTraining.com

Download CommerceBlocks V2.1 and LoRCAT from
http://www.ProductivityEnhancement.com

The ColdFusion MX Bible is in bookstores now!
- Original Message - 
From: Deanna Schneider [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:04 AM
Subject: Re: Returning Results from a Stored Proc in Oracle


 Ryan,
 Not sure if this changed with MX, but in 5.0, you had to add maxrows=-1
to
 your out parameter, so it would look like this:

 cfprocparam type=out
 cfsqltype=cf_sql_refcursor
 variable=p_the_results maxrows=-1 dbvarname=p_the_results

 Note that I've also used the dbvarname attribute, though I'm not sure if
 it's required.
 -d


 - Original Message - 
 From: Ryan Geesaman [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, October 01, 2003 7:14 AM
 Subject: Returning Results from a Stored Proc in Oracle


  I am trying to use cfstoredproc to return results from Oracle.I have
 seen a few different suggestions on how to accomplish this, but none have
 worked.
 
  First Try:
  In Oracle --
  PACKAGE STORED_PROC_TEST
 IS
 TYPE CUSTOM_REF_CURSOR IS REF CURSOR;
 PROCEDURE get_data(p_criteria IN VARCHAR2,
 p_the_results IN OUT CUSTOM_REF_CURSOR);
  END;
  In CF --
 cfstoredproc procedure=stored_proc_test.get_data
 datasource=#session.dsn#
  cfprocparam type=in
  cfsqltype=cf_sql_varchar
  value=test
  dbvarname=p_criteria
  cfprocparam type=out
  cfsqltype=cf_sql_refcursor
  variable=p_the_results
  cfprocresult name=dataFromStoredProc
  /cfstoredproc
  This results in The specified SQL type is not supported by this
driver.
 
  Second Try:
  In Oracle -- same as above
  In CF -- second cfprocparam is dropped completely
  This results in wrong number or types of arguments in call to
'GET_DATA'
 
  Any help would be appreciated,
  Ryan A. Geesaman
  Applications Developer
  Penn State College of Medicine
  Health Evaluation Sciences


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




ot: sql question

2003-10-01 Thread Tony Weeg
how would I use HAVING to select out where the difference between
reportsInDatabase and DistinctTimes is above 15%
im stuck and its just not clicking this morningthanks if you can figure
this out

select r.IpAddressNumber, v.VehicleIp, 
	Count(r.ReportId) as ReportsInDatabase, 
	Count(DISTINCT Time) as DistinctTimes, v.VehicleName, c.companyName
from reportsView r
INNER JOIN 
	vehicletable v
	on v.IpAddressNumber = r.IpAddressNum
INNER JOIN
	companyTable c
	on v.companyIdNumber = c.companyIdNumber
where r.currentDate between '09-29-2003 00:00:00.000'and '09-29-2003
23:59:59.999'
	Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName,
v.VehicleIp, c.companyName
	Order by ReportsInDatabase DESC

im stuck

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

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




RE: Settle an argument for me

2003-10-01 Thread Randell B Adkins
Instead of displaying the email address, why not create a contact form
therefore they would not see the actual email address.

However, I do as well mask my email addresses using JS and such.
But at times I use the forms to eliminate that possibility.

My 2 cents...



 [EMAIL PROTECTED] 10/01/03 10:51AM 
I would say no. But you need to ask yourself. Are these Spam bots
smart
enough to reverse the extended chars? If they are setup with this type
of
function, then yes I would say they are still picking them up.
 
I would say this is just a guess they are not doing this type of
function
while gathering emails.
 
Shawn Regan
Head Applications Developer
pacifictechnologysolutions 

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 7:37 AM
To: CF-Talk
Subject: Settle an argument for me


I've been using a UDF called emailAntiSpam, which replaces an email
address in the source code with extended characters which supposedly
can't
be crawled and picked up by spambots.

So my address:[EMAIL PROTECTED] would look like:

a
href="">
#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
;#108;#101;#46;#99;#111;#109; target=_blankNotify the
Webmaster/a

My problem, my client thinks they are still being picked up and used
for
spam - I also have a robots.txt file set to disallow bot crawling.

I've had both these in place since day one, when the site was posted
about 3
months ago.

Does it actually work?

Thanks, Mark 


_

[ Todays Threads 

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




RE: sql question

2003-10-01 Thread Tony Weeg
something like this?
but im getting this error...

===error text==

Server: Msg 156, Level 15, State 1, Line 13
Incorrect syntax near the keyword 'select'.
Server: Msg 170, Level 15, State 1, Line 13
Line 13: Incorrect syntax near ''.

===error text==

select r.IpAddressNumber, v.VehicleIp, 
Count(r.ReportId) as ReportsInDatabase, 
Count(DISTINCT Time) as DistinctTimes, v.VehicleName, c.companyName
from reportsView r
INNER JOIN 
vehicletable v
on v.IpAddressNumber = r.IpAddressNum
INNER JOIN
companyTable c
on v.companyIdNumber = c.companyIdNumber
where r.currentDate between '09-29-2003 00:00:00.000'and '09-29-2003
23:59:59.999'
Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName, v.VehicleIp,
c.companyName
HAVING select (((reportsInDatabase - distinctTimes) / reportsInDatabase) *
100)  15
Order by ReportsInDatabase DESC 


...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 10:51 AM
To: CF-Talk
Subject: ot: sql question

how would I use HAVING to select out where the difference between
reportsInDatabase and DistinctTimes is above 15% im stuck and its just not
clicking this morningthanks if you can figure this out

select r.IpAddressNumber, v.VehicleIp,
Count(r.ReportId) as ReportsInDatabase, Count(DISTINCT Time) as
DistinctTimes, v.VehicleName, c.companyName from reportsView r INNER JOIN
vehicletable v on v.IpAddressNumber = r.IpAddressNum INNER JOIN companyTable
c on v.companyIdNumber = c.companyIdNumber where r.currentDate between
'09-29-2003 00:00:00.000'and '09-29-2003 23:59:59.999'
Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName, v.VehicleIp,
c.companyName Order by ReportsInDatabase DESC

im stuck

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337




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




Re: Building a 2 dimensional array from lists (junior question)

2003-10-01 Thread Birgit Pauli-Haack
Hi David,

cfset myList1 = apple,banana,orange
cfset myList2 = bird,fish,mammal
cfset CombiArr = ArrayNew(2)

cfloop from=1 to=#ListLen(mylist1)# index=i

cfset CombiArr[i][1]= ListGetAt(myList1,i,,)
cfset CombiArr[i][2]= ListGetAt(myList2,i,,)

/cfloop

cfdump var=#CombiArr#


-- 

Birgit
--

Wednesday, October 1, 2003, 10:38:29 AM, you wrote:

DA I have two lists and I want to combine them into a single two dimensional array, how do I 
DA do it??

DA Here are my two lists..

DA cfset myList1 = apple,banana,orange
DA cfset myList2 = bird,fish,mammal
DA
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Settle an argument for me

2003-10-01 Thread Michael Dinowitz
I wrote an article about it in FA a few issues back explaining the logic and
showing off the code. I have to say that since I implemented it, the amount of
spam I get to certain addresses (addresses only on the HoF site) is way down.
As for robots.txt, that only comes into effect when a robot reads and obeys it.
I've never seen a spambot that obeys it. Reads it, yes. They use the read to see
directories that normally aren't indexed and go to them specifically.


 I've been using a UDF called emailAntiSpam, which replaces an email
 address in the source code with extended characters which supposedly can't
 be crawled and picked up by spambots.

 So my address:[EMAIL PROTECTED] would look like:

 a
 href="">
 #101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
 ;#108;#101;#46;#99;#111;#109; target=_blankNotify the
 Webmaster/a

 My problem, my client thinks they are still being picked up and used for
 spam - I also have a robots.txt file set to disallow bot crawling.

 I've had both these in place since day one, when the site was posted about 3
 months ago.

 Does it actually work?

 Thanks, Mark



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




RE: Settle an argument for me

2003-10-01 Thread cfhelp
OK here is a thought...

 

Instead of masking put the email address in the database. Then build a small
page that pulls the email and launches the email program. To keep a bot from
following the link, confirm that the browser contains Mozilla, MSIE or Opera
(any others), or place a dynamically named cookie on the browser and then
check for it.

 

Your link would just be a href="">

 

 

Rick

 

_

From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 9:52 AM
To: CF-Talk

 

Instead of displaying the email address, why not create a contact form
therefore they would not see the actual email address.

However, I do as well mask my email addresses using JS and such.
But at times I use the forms to eliminate that possibility.

My 2 cents...



 [EMAIL PROTECTED] 10/01/03 10:51AM 
I would say no. But you need to ask yourself. Are these Spam bots
smart
enough to reverse the extended chars? If they are setup with this type
of
function, then yes I would say they are still picking them up.

I would say this is just a guess they are not doing this type of
function
while gathering emails.

Shawn Regan
Head Applications Developer
pacifictechnologysolutions 

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 7:37 AM
To: CF-Talk
Subject: Settle an argument for me


I've been using a UDF called emailAntiSpam, which replaces an email
address in the source code with extended characters which supposedly
can't
be crawled and picked up by spambots.

So my address:[EMAIL PROTECTED] would look like:

a
href="">
#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
;#108;#101;#46;#99;#111;#109; target=_blankNotify the
Webmaster/a

My problem, my client thinks they are still being picked up and used
for
spam - I also have a robots.txt file set to disallow bot crawling.

I've had both these in place since day one, when the site was posted
about 3
months ago.

Does it actually work?

Thanks, Mark 


_

[ Todays Threads 



_

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




Re: Breadcrumbs in Cold Fusion

2003-10-01 Thread Bushy
What about a nice treeview display similar to Microsoft Explorer?

--Original Message Text---
From: Randell B Adkins
Date: Wed, 01 Oct 2003 06:56:43 -0400

What I do is have a CutomTag (BCMenu.cfm).
When needed I call the CustomTag passing 3 parameters:

CF_BCMenu
ItemName=First Link, Second Link, Third Link
ItemLink=aaa.cfm,bbb.cfm,ccc.cfm
ActiveItem=This Page Name

The Custom Tag writes out:
cfloop index=i from=1 to=#ListLen(ATTRIBUTES.ItemName)#
cfoutput
a
href="">

img
src="">
/cfoutput
/cfloop
!--- Output the current page title ---
cfoutput#ATTRIBUTES.ActiveItem#/cfoutput


 [EMAIL PROTECTED] 10/01/03 06:43AM 
Good Day,

Does anyone have any code for breadcrumbs in Cold Fusion.

If so and possible may I have a sample of that code.I would like to
use breadcrumbs with Cold Fusion in my site.

Thank you.

Deetra Whatley

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




Error No. 1450 / Problem encountered accessing system registry ??

2003-10-01 Thread Joe Tartaglia
We just started getting reports that the error shown below has
been cropping up on all sites built with ColdFusion on one of
our servers.The server is running ColdFusion 4.0 and NT4.5

I have not been able to recreate the error but I have had
enough reports to convince me its our problem.

Any help would be greatly appreciated.

Thanks
Joe Tartaglia
High Caliber Solutions
212-684-5553

===
Error Occurred While Processing Request
Error Diagnostic Information
Error attempting to get the client (Client ID = '479799').

A problem was encountered trying to access the system registry. Error number
1450 occurred.

The error occurred while processing an element with a general identifier of
(CFAPPLICATION), occupying document position (17:1) to (22:51).

Date/Time: 09/26/03 23:25:27
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
Remote Address: 65.40.7.126
Template: D:\clients\mbix\index.cfm
===




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




Re: ot: sql question

2003-10-01 Thread Jochem van Dieten
Tony Weeg wrote:
 how would I use HAVING to select out where the difference between
 reportsInDatabase and DistinctTimes is above 15%

 select r.IpAddressNumber, v.VehicleIp, 
 	Count(r.ReportId) as ReportsInDatabase, 
 	Count(DISTINCT Time) as DistinctTimes, v.VehicleName, c.companyName
 from reportsView r
 INNER JOIN 
 	vehicletable v
 	on v.IpAddressNumber = r.IpAddressNum
 INNER JOIN
 	companyTable c
 	on v.companyIdNumber = c.companyIdNumber
 where r.currentDate between '09-29-2003 00:00:00.000'and '09-29-2003
 23:59:59.999'
 	Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName,
 v.VehicleIp, c.companyName
 	Order by ReportsInDatabase DESC

SELECT
	r.IpAddressNumber,
	v.VehicleIp,
	Count(r.ReportId) as ReportsInDatabase,
	Count(DISTINCT Time) as DistinctTimes,
	v.VehicleName,
	c.companyName
FROM
	reportsView r INNER JOIN vehicletable v
		ON v.IpAddressNumber = r.IpAddressNum
	INNER JOIN companyTable c
		ON v.companyIdNumber = c.companyIdNumber
WHERE
	r.currentDate BETWEEN '09-29-2003 00:00:00.000'
		AND '09-29-2003 23:59:59.999'
GROUP BY
	v.IpAddressNumber,
	r.IpAddressNum,
	v.VehicleName,
	v.VehicleIp,
	c.companyName
HAVING
	Abs((ReportsInDatabase-DistinctTimes)/ReportsInDatabase)
		 0.15
ORDER BY
	ReportsInDatabase DESC

Jochem



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




Re: Settle an argument for me

2003-10-01 Thread Thomas Chiverton
On Wednesday 01 Oct 2003 15:37 pm, Mark Leder wrote:
 I've been using a UDF called emailAntiSpam, which replaces an email
 address in the source code with extended characters which supposedly can't
 be crawled and picked up by spambots.
 a
 href="">
;
 #101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#10
5 ;#108;#101;#46;#99;#111;#109; target=_blankNotify the
 Webmaster/a
 Does it actually work?

I don't see any reason why a spamBot would not be able to read that, any more 
than a spam bot would not be able to follow an URL wiht a space (%20) in.

You're better off using some _javascript_ to write the address in at 
displaytime, as @
http://falkensweb.com/contact.html

Note it also uses a disposable address that can be replaced any time, and the 
old spam-infested one removed.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

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




Re: Settle an argument for me

2003-10-01 Thread Jochem van Dieten
Mark Leder wrote:

 I've been using a UDF called emailAntiSpam, which replaces an email
 address in the source code with extended characters which supposedly can't
 be crawled and picked up by spambots.
 
 So my address:[EMAIL PROTECTED] would look like:
 
 a
 href="">
 #101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
 ;#108;#101;#46;#99;#111;#109; target=_blankNotify the
 Webmaster/a
 
 My problem, my client thinks they are still being picked up and used for
 spam - I also have a robots.txt file set to disallow bot crawling.
 
 I've had both these in place since day one, when the site was posted about 3
 months ago.
 
 Does it actually work?

Can you figure out a workaround? If so, it doesn't work.

And if not, I can figure one out for you. If I ever were to cross 
over to the dark side, it would actually be the first thing to 
look for when writing a harvester. If it is important enough to 
obfuscate, it must be real.

Jochem



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




Re: Breadcrumbs in Cold Fusion

2003-10-01 Thread Randell B Adkins
You could use the same style, just tweak the HTML 
that is built around it.

Such as:
img src="" href="">
cfloop ...
nbsp;nbsp;img src="">
href="">
(ATTRIBUTES.ItemName,i)#/strong/abr
/cfloop

Or something like that. Did not test it but if you build the variables
as needed, you can 
display the menu anyway you want with proper coding.


 [EMAIL PROTECTED] 10/01/03 09:18AM 
What about a nice treeview display similar to Microsoft Explorer?

--Original Message Text---
From: Randell B Adkins
Date: Wed, 01 Oct 2003 06:56:43 -0400

What I do is have a CutomTag (BCMenu.cfm).
When needed I call the CustomTag passing 3 parameters:

CF_BCMenu
ItemName=First Link, Second Link, Third Link
ItemLink=aaa.cfm,bbb.cfm,ccc.cfm
ActiveItem=This Page Name

The Custom Tag writes out:
cfloop index=i from=1 to=#ListLen(ATTRIBUTES.ItemName)#
cfoutput
a
href="">

img
src="">
/cfoutput
/cfloop
!--- Output the current page title ---
cfoutput#ATTRIBUTES.ActiveItem#/cfoutput


 [EMAIL PROTECTED] 10/01/03 06:43AM 
Good Day,

Does anyone have any code for breadcrumbs in Cold Fusion.

If so and possible may I have a sample of that code.I would like to
use breadcrumbs with Cold Fusion in my site.

Thank you.

Deetra Whatley


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




Re: Error No. 1450 / Problem encountered accessing system registry ??

2003-10-01 Thread Howie Hamlin
By default CF stores client vars in the system registry.You should probably consider using an ODBC datasource instead.

For now, you should try increasing the max size of the system registry in your server settings.

HTH,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
 Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm 
 Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: Joe Tartaglia 
To: CF-Talk 
Sent: Wednesday, October 01, 2003 11:09 AM
Subject: Error No. 1450 / Problem encountered accessing system registry ??


We just started getting reports that the error shown below has
been cropping up on all sites built with ColdFusion on one of
our servers.The server is running ColdFusion 4.0 and NT4.5

I have not been able to recreate the error but I have had
enough reports to convince me its our problem.

Any help would be greatly appreciated.

Thanks
Joe Tartaglia
High Caliber Solutions
212-684-5553

===
Error Occurred While Processing Request
Error Diagnostic Information
Error attempting to get the client (Client ID = '479799').

A problem was encountered trying to access the system registry. Error number
1450 occurred.

The error occurred while processing an element with a general identifier of
(CFAPPLICATION), occupying document position (17:1) to (22:51).

Date/Time: 09/26/03 23:25:27
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
Remote Address: 65.40.7.126
Template: D:\clients\mbix\index.cfm
===





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




RE: ot: sql question

2003-10-01 Thread Tony Weeg
thank you jochem, that makes sense, I was close, but forgot about the abs
function, which I presume is for absolute number

anyway, now I get this

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'ReportsInDatabase'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'DistinctTimes'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'ReportsInDatabase'. 


...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 11:10 AM
To: CF-Talk
Subject: Re: ot: sql question

Tony Weeg wrote:
 how would I use HAVING to select out where the difference between 
 reportsInDatabase and DistinctTimes is above 15%

 select r.IpAddressNumber, v.VehicleIp,
 Count(r.ReportId) as ReportsInDatabase, Count(DISTINCT Time) as 
 DistinctTimes, v.VehicleName, c.companyName from reportsView r INNER 
 JOIN vehicletable v on v.IpAddressNumber = r.IpAddressNum INNER JOIN 
 companyTable c on v.companyIdNumber = c.companyIdNumber where 
 r.currentDate between '09-29-2003 00:00:00.000'and '09-29-2003 
 23:59:59.999'
 Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName, 
 v.VehicleIp, c.companyName Order by ReportsInDatabase DESC

SELECT
r.IpAddressNumber,
v.VehicleIp,
Count(r.ReportId) as ReportsInDatabase,
Count(DISTINCT Time) as DistinctTimes,
v.VehicleName,
c.companyName
FROM
reportsView r INNER JOIN vehicletable v
ON v.IpAddressNumber = r.IpAddressNum
INNER JOIN companyTable c
ON v.companyIdNumber = c.companyIdNumber WHERE r.currentDate BETWEEN
'09-29-2003 00:00:00.000'
AND '09-29-2003 23:59:59.999'
GROUP BY
v.IpAddressNumber,
r.IpAddressNum,
v.VehicleName,
v.VehicleIp,
c.companyName
HAVING
Abs((ReportsInDatabase-DistinctTimes)/ReportsInDatabase)
 0.15
ORDER BY
ReportsInDatabase DESC

Jochem






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




Re: Error No. 1450 / Problem encountered accessing system registry ??

2003-10-01 Thread Ubqtous
Joe,

On 10/1/2003 at 11:09, you wrote:

JT We just started getting reports that the error shown below has
JT been cropping up on all sites built with ColdFusion on one of
JT our servers.The server is running ColdFusion 4.0 and NT4.5

JT I have not been able to recreate the error but I have had
JT enough reports to convince me its our problem.

JT Any help would be greatly appreciated.

JT Thanks
JT Joe Tartaglia
JT High Caliber Solutions
JT 212-684-5553

JT ===
JT Error Occurred While Processing Request
JT Error Diagnostic Information
JT Error attempting to get the client (Client ID = '479799').

JT A problem was encountered trying to access the system registry. Error number
JT 1450 occurred.

JT The error occurred while processing an element with a general identifier of
JT (CFAPPLICATION), occupying document position (17:1) to (22:51).

JT Date/Time: 09/26/03 23:25:27
JT Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
JT Remote Address: 65.40.7.126
JT Template: D:\clients\mbix\index.cfm
JT ===

The first thing that pops into mind is to make sure you're not writing
client variables to the registry--set up a database instead.


~ Ubqtous ~

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




Compressing Javascript

2003-10-01 Thread Brook Davies
Does anyone know of a UDF or customtag that will compress _javascript_ to cut 
down on file size? I know there are apps that do this, and I would like to 
include this functionality with some of our dynamically generated pages.

Thanks!

Brook Davies


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




RE: Settle an argument for me

2003-10-01 Thread Jim Davis
Basically any method for obfuscation will eventually become useless.
perhaps this one has.
 
The only reason it worked at all, or as long as it did, was because
spam-bots are so stupid. but they are only as stupid as they can be.
Since you're still using a mailto: tag even the dumbest bot would know
there's an email address in there someplace.When enough of them come
in formatted like this even the dumbest spammer will attempt to decode
them - especially since an email address that's protected is an email
address that's used.;^)
 
It could have also been picked up by a manual scan.Many companies
sic interns or cheap labor on relevant sites to collect content
information in a more orderly manner than random collection.This is
why, as a one man tech company, I'm constantly getting mail saying We
heard you may be looking for qualified technical support staff!.
Obviously they 1) know I'm a tech company and 2) know nothing at all
about me beyond that.
 
Jim Davis
 
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 10:37 AM
To: CF-Talk
Subject: Settle an argument for me
 
I've been using a UDF called emailAntiSpam, which replaces an email
address in the source code with extended characters which supposedly
can't
be crawled and picked up by spambots.

So my address:[EMAIL PROTECTED] would look like:

a
href="">
112;
#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;
#105
;#108;#101;#46;#99;#111;#109; target=_blankNotify the
Webmaster/a

My problem, my client thinks they are still being picked up and used for
spam - I also have a robots.txt file set to disallow bot crawling.

I've had both these in place since day one, when the site was posted
about 3
months ago.

Does it actually work?

Thanks, Mark 



_

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




RE: Error No. 1450 / Problem encountered accessing system registry ??

2003-10-01 Thread Mike Brunt
Joe, where are you storing Client Variables? If itÂ’s the Registry that may
be your problem.Check it in ColdFusion Administrator.I strongly
recommend if it is the Registry you change it to a Database as soon as
possible because if the Registry gets corrupted it is not just CF that will
be affected.

Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net

Webapper Web Application Specialists

-Original Message-
From: Joe Tartaglia [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:09 AM
To: CF-Talk
Subject: Error No. 1450 / Problem encountered accessing system registry ??

We just started getting reports that the error shown below has
been cropping up on all sites built with ColdFusion on one of
our servers.The server is running ColdFusion 4.0 and NT4.5

I have not been able to recreate the error but I have had
enough reports to convince me its our problem.

Any help would be greatly appreciated.

Thanks
Joe Tartaglia
High Caliber Solutions
212-684-5553

===
Error Occurred While Processing Request
Error Diagnostic Information
Error attempting to get the client (Client ID = '479799').

A problem was encountered trying to access the system registry. Error number
1450 occurred.

The error occurred while processing an element with a general identifier of
(CFAPPLICATION), occupying document position (17:1) to (22:51).

Date/Time: 09/26/03 23:25:27
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Q312461)
Remote Address: 65.40.7.126
Template: D:\clients\mbix\index.cfm
===





_

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




RE: Compressing Javascript

2003-10-01 Thread Daniel Mackey
Hi,

Have a look at ColdFusion Compactor:

http://free.cftagstore.com/index.cfm/page/viewtag/tagId/14

Regards,
Dan.
-Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 16:30
To: CF-Talk
Subject: Compressing _javascript_


Does anyone know of a UDF or customtag that will compress _javascript_ to
cut
down on file size? I know there are apps that do this, and I would like to
include this functionality with some of our dynamically generated pages.

Thanks!

Brook Davies



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




RE: Settle an argument for me

2003-10-01 Thread Mark Leder
I like this idea, as the email addresses are already in a db.I guess I'm
trying figure out how I would write to check for the browser in this
scenario.
 
Thanks, Mark 

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 11:09 AM
To: CF-Talk
Subject: RE: Settle an argument for me


OK here is a thought...



Instead of masking put the email address in the database. Then build a small
page that pulls the email and launches the email program. To keep a bot from
following the link, confirm that the browser contains Mozilla, MSIE or Opera
(any others), or place a dynamically named cookie on the browser and then
check for it.



Your link would just be a href="">





Rick



_

From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 9:52 AM
To: CF-Talk



Instead of displaying the email address, why not create a contact form
therefore they would not see the actual email address.

However, I do as well mask my email addresses using JS and such.
But at times I use the forms to eliminate that possibility.

My 2 cents...



 [EMAIL PROTECTED] 10/01/03 10:51AM 
I would say no. But you need to ask yourself. Are these Spam bots
smart
enough to reverse the extended chars? If they are setup with this type
of
function, then yes I would say they are still picking them up.

I would say this is just a guess they are not doing this type of
function
while gathering emails.

Shawn Regan
Head Applications Developer
pacifictechnologysolutions 

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 7:37 AM
To: CF-Talk
Subject: Settle an argument for me


I've been using a UDF called emailAntiSpam, which replaces an email
address in the source code with extended characters which supposedly
can't
be crawled and picked up by spambots.

So my address:[EMAIL PROTECTED] would look like:

a
href="">
#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
;#108;#101;#46;#99;#111;#109; target=_blankNotify the
Webmaster/a

My problem, my client thinks they are still being picked up and used
for
spam - I also have a robots.txt file set to disallow bot crawling.

I've had both these in place since day one, when the site was posted
about 3
months ago.

Does it actually work?

Thanks, Mark 


_

[ Todays Threads 



_

[Todays 
_


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




RE: sql question

2003-10-01 Thread Eric Creese
I do not think you need the SELECT

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:56 AM
To: CF-Talk
Subject: RE: sql question


something like this?
but im getting this error...

===error text==

Server: Msg 156, Level 15, State 1, Line 13
Incorrect syntax near the keyword 'select'.
Server: Msg 170, Level 15, State 1, Line 13
Line 13: Incorrect syntax near ''.

===error text==

select r.IpAddressNumber, v.VehicleIp, 
Count(r.ReportId) as ReportsInDatabase, 
Count(DISTINCT Time) as DistinctTimes, v.VehicleName, c.companyName
from reportsView r
INNER JOIN 
vehicletable v
on v.IpAddressNumber = r.IpAddressNum
INNER JOIN
companyTable c
on v.companyIdNumber = c.companyIdNumber
where r.currentDate between '09-29-2003 00:00:00.000'and '09-29-2003
23:59:59.999'
Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName, v.VehicleIp,
c.companyName
HAVING select (((reportsInDatabase - distinctTimes) / reportsInDatabase) *
100)  15
Order by ReportsInDatabase DESC 


...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 10:51 AM
To: CF-Talk
Subject: ot: sql question

how would I use HAVING to select out where the difference between
reportsInDatabase and DistinctTimes is above 15% im stuck and its just not
clicking this morningthanks if you can figure this out

select r.IpAddressNumber, v.VehicleIp,
Count(r.ReportId) as ReportsInDatabase, Count(DISTINCT Time) as
DistinctTimes, v.VehicleName, c.companyName from reportsView r INNER JOIN
vehicletable v on v.IpAddressNumber = r.IpAddressNum INNER JOIN companyTable
c on v.companyIdNumber = c.companyIdNumber where r.currentDate between
'09-29-2003 00:00:00.000'and '09-29-2003 23:59:59.999'
Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName, v.VehicleIp,
c.companyName Order by ReportsInDatabase DESC

im stuck

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337




_

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




RE: Breadcrumbs in Cold Fusion

2003-10-01 Thread Brad Roberts
For a tree view, I built a tag based off of Piet Niederhausen's
cf_traverseTree, which uses Joe Celko's algorithim from his book SQL for
Smarties.
http://www.niederhausen.net/piet/dev/customtags/index.htmlThe code is a
lot simpler... it took me hours to figure it out.And, instead of taking a
query, it takes a stucture.You can still use a query, you just have to
convert it to a structure... I think there's a UDF on cflib.org for this.
Or, you could re-code it to take a query.

For breadcrumbs, I built a UDF that takes a scruct of your pages with
parent/child relationships.The UDF traverses the structure and returns an
array with the pages in order.Then, you can loop over the array and format
your links however you wish.

I use these two tags together in my CMS and they work great.

If anyone's interested, send me an email...

-Brad
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:19 AM
To: CF-Talk
Subject: Re: Breadcrumbs in Cold Fusion


What about a nice treeview display similar to Microsoft Explorer?

--Original Message Text---
From: Randell B Adkins
Date: Wed, 01 Oct 2003 06:56:43 -0400

What I do is have a CutomTag (BCMenu.cfm).
When needed I call the CustomTag passing 3 parameters:

CF_BCMenu
ItemName=First Link, Second Link, Third Link
ItemLink=aaa.cfm,bbb.cfm,ccc.cfm
ActiveItem=This Page Name

The Custom Tag writes out:
cfloop index=i from=1 to=#ListLen(ATTRIBUTES.ItemName)#
cfoutput
a

href="">
Name,i)#/strong/a

img
src="">
/cfoutput
/cfloop
!--- Output the current page title ---
cfoutput#ATTRIBUTES.ActiveItem#/cfoutput


 [EMAIL PROTECTED] 10/01/03 06:43AM 
Good Day,

Does anyone have any code for breadcrumbs in Cold Fusion.

If so and possible may I have a sample of that code.I would like to
use breadcrumbs with Cold Fusion in my site.

Thank you.

Deetra Whatley


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




CFTRANSACTION problem

2003-10-01 Thread Ramesh Deva
Hi,

 

Suddenly I am getting following error in cfm page. 

 

 



Data source Ora8 verification failed. 

 	 

The root cause was that: java.sql.SQLException: Usernames and Passwords for
all the database tags within CFTRANSACTION must be the same. 

 

 

Really that will be greatly appreciate for any suggestions.

 

Thanks

ramesh

 

 


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




RE: CFTRANSACTION problem

2003-10-01 Thread Douglas.Knudsen
You have to have the same DSN, including all UID/PWDs, in all your queries in a cftransaction.
 
Doug

-Original Message-
From: Ramesh Deva [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 11:45 AM
To: CF-Talk
Subject: CFTRANSACTION problem


Hi,



Suddenly I am getting following error in cfm page. 







Data source Ora8 verification failed. 



The root cause was that: java.sql.SQLException: Usernames and Passwords for
all the database tags within CFTRANSACTION must be the same. 





Really that will be greatly appreciate for any suggestions.



Thanks

ramesh






_

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




Re: sql question

2003-10-01 Thread Andrea Galmacci
test subscription

- Original Message - 
From: Eric Creese 
To: CF-Talk 
Sent: Wednesday, October 01, 2003 4:59 PM
Subject: RE: sql question


I do not think you need the SELECT

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:56 AM
To: CF-Talk
Subject: RE: sql question


something like this?
but im getting this error...

===error text==

Server: Msg 156, Level 15, State 1, Line 13
Incorrect syntax near the keyword 'select'.
Server: Msg 170, Level 15, State 1, Line 13
Line 13: Incorrect syntax near ''.

===error text==

select r.IpAddressNumber, v.VehicleIp, 
Count(r.ReportId) as ReportsInDatabase, 
Count(DISTINCT Time) as DistinctTimes, v.VehicleName, c.companyName
from reportsView r
INNER JOIN 
vehicletable v
on v.IpAddressNumber = r.IpAddressNum
INNER JOIN
companyTable c
on v.companyIdNumber = c.companyIdNumber
where r.currentDate between '09-29-2003 00:00:00.000'and '09-29-2003
23:59:59.999'
Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName, v.VehicleIp,
c.companyName
HAVING select (((reportsInDatabase - distinctTimes) / reportsInDatabase) *
100)  15
Order by ReportsInDatabase DESC 


...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 10:51 AM
To: CF-Talk
Subject: ot: sql question

how would I use HAVING to select out where the difference between
reportsInDatabase and DistinctTimes is above 15% im stuck and its just not
clicking this morningthanks if you can figure this out

select r.IpAddressNumber, v.VehicleIp,
Count(r.ReportId) as ReportsInDatabase, Count(DISTINCT Time) as
DistinctTimes, v.VehicleName, c.companyName from reportsView r INNER JOIN
vehicletable v on v.IpAddressNumber = r.IpAddressNum INNER JOIN companyTable
c on v.companyIdNumber = c.companyIdNumber where r.currentDate between
'09-29-2003 00:00:00.000'and '09-29-2003 23:59:59.999'
Group By v.IpAddressNumber, r.IpAddressNum, v.VehicleName, v.VehicleIp,
c.companyName Order by ReportsInDatabase DESC

im stuck

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337




 _

[ Todays Threads 

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




Re: Breadcrumbs in Cold Fusion

2003-10-01 Thread S . Isaac Dealey
I'd recommend using includes...

Assuming you use directories to delineate sections fo the site, each
include (breadcrumb.cfm) would look something like this:

cfinclude template=../breadcrumb.cfm

cfoutput
gt; a href="" name/a
/cfoutput

The advantage of this is that if you change any given breadcrumb link
it will automagically update all pages in your site without having to
edit lots of different templates.

Something similar can be used if your templates are structured
differently, but then all you have to do is include the breadcrumb
template for the current page where you want it.

If you'd like something a bit more structured, have a glance at this
article about how it's done in the onTap framework:

http://www.turnkey.to/ontap/docs/blog.cfm?netaction=viewblogdate=2003
-09-19

hth

s. isaac dealey 972-490-6624

team macromedia volunteerhttp://www.macromedia.com/go/team

chief architect, tapestry cmshttp://products.turnkey.to

onTap is open sourcehttp://www.turnkey.to/ontap


 Good Day,

 Does anyone have any code for breadcrumbs in Cold Fusion.

 If so and possible may I have a sample of that code.I
 would like to use breadcrumbs with Cold Fusion in my site.

 Thank you.

 Deetra Whatley
 ~~

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




RE: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread S . Isaac Dealey
They definately don't belong there... It's funny, I've never seen them
anywhere but in the programming section next to C++ ... (Not popular
enough to be on the end-cap next to XML for Dummies I guess.) But then
it's been a little while since I've seriously been in a book store
looking for CF books.

Though I do think we should complain to Amazon.com for not having a
ColdFusion section on this page:

http://www.amazon.com/exec/obidos/tg/browse/-/4021/ref=br_bx_c_2_4/002
-1274419-3838416



 I don't think it matters, since we all know where they are
 anyways :-)

 -Original Message-
 From: Owens, Howard [mailto:[EMAIL PROTECTED]
 Sent: Tuesday, September 30, 2003 6:45 PM
 To: CF-Talk
 Subject: RE: CFV: comp.lang.coldfusion Usenet Newsgroup


 Speaking of more legitimacy -- what's up with chain
 bookstores always filing
 the CF titles under graphic/web design?

 I asked an employee of my local Barnes and Nobel the other
 day and he said
 this was a corporate decision.

 Personally, it always irks me that CF books aren't in with
 the programming
 books.Maybe we should all start complaining to the
 chains about this, and
 MM -- MM should file its own protests. I think.

 H.



 ~~
 Howard Owens
 Internet Operations Coordinator
 Ventura County Star / E.W. Scripps Co.
 www.venturacountystar.com
 [EMAIL PROTECTED]
 AIM: GoCatGo1956
 ~~

 -Original Message-
 From: Dave Hodder [SMTP:[EMAIL PROTECTED]
 Sent: Saturday, September 27, 2003 12:38 PM
 To: CF-Talk
 Subject: Re: CFV: comp.lang.coldfusion Usenet Newsgroup

 Jim McAtee wrote:

  There's already a CF newsgroup.Why the need for
  another?

 It's covered in the comp.lang.coldfusion rationale.Some
 of us on the
 existing alt.comp.lang.coldfusion group feel a proper
 comp.* group
 would give ColdFusion more legitimacy, as well as the
 group having
 better propagation, longer message retention periods,
 etc.

 Regards,

 Dave

_

 [ Todays Threads
_


 ~~

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




RE: session variables and shopping cart

2003-10-01 Thread mayo
CFID and CFTOKEN are being passed:

sessionmanagement=Yes
setclientcookies=Yes


The funny part about it is that it happens at random. Why would session.item
be passed twice sometimes and not others?Why is session.item passed twice
and not session.itemQty?

Unable to solve this.
Gil

-Original Message-
From: Peter Tilbrook [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 9:25 PM
To: CF-Talk
Subject: RE: session variables and shopping cart


Are you remembering to pass on the URLToken (CFID/CFToken) when
re-directing
or CFLOCATIONing? If not CF will lose track of the session you want to
keep.
eg:

-Original Message-
From: mayo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 1 October 2003 7:54 AM
To: CF-Talk
Subject: session variables and shopping cart


 I'm having an odd problem with my session variables.

 I'm storing a product id as a session variable cfset
session.item=#item#
 and am using a _javascript_ to allow the users to select the qty of items.
 Most times everything goes well: session.item and session.qty are passed
as
 expected. Other times not. I'll two session.items.

 This is not good :-) It breaks the db call. I could get around this by
 creating session.itemTitle, session.itemPrice, etc... I would rather
figure
 out why it breaks.

 In case it matters the _javascript_ is below:

 script langauge=_javascript_

function subTotal() // calculates subTotal for user : QTY x
PRICE
=
 SUBTOTAL
{
document.forms[0].priceRetailSubTotal.value=
 (
 document.forms[0].itemQty.value*
 document.forms[0].priceRetail.value
 );

 document.forms[0].itemQty2.value=document.forms[0].itemQty.value;
}

function cs() // if QTY is 1 go to previous page else send to
cart2
 to process session variables (below)
{
 var i=document.forms[0].itemQty2.value;
 if (i==1)
{

 location.href="">
}
 else
{



cfoutputlocation.href="">
 r='+i);/cfoutput
}
}
 /script

 // cart2.cfm

 cfif number GT 0

cfset session.item=#item#
cfset session.itemQty=#number#
cfoutputcflocation url="">

 /cfif



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




Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread Jim Campbell
Done, but I said it in a nice way :)

- Jim

S. Isaac Dealey wrote:

 They definately don't belong there... It's funny, I've never seen them
 anywhere but in the programming section next to C++ ... (Not popular
 enough to be on the end-cap next to XML for Dummies I guess.) But then
 it's been a little while since I've seriously been in a book store
 looking for CF books.

 Though I do think we should complain to Amazon.com for not having a
 ColdFusion section on this page:

 http://www.amazon.com/exec/obidos/tg/browse/-/4021/ref=br_bx_c_2_4/002
 -1274419-3838416



  I don't think it matters, since we all know where they are
  anyways :-)

  -Original Message-
  From: Owens, Howard [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, September 30, 2003 6:45 PM
  To: CF-Talk
  Subject: RE: CFV: comp.lang.coldfusion Usenet Newsgroup


  Speaking of more legitimacy -- what's up with chain
  bookstores always filing
  the CF titles under graphic/web design?

  I asked an employee of my local Barnes and Nobel the other
  day and he said
  this was a corporate decision.

  Personally, it always irks me that CF books aren't in with
  the programming
  books.Maybe we should all start complaining to the
  chains about this, and
  MM -- MM should file its own protests. I think.

  H.



  ~~
  Howard Owens
  Internet Operations Coordinator
  Ventura County Star / E.W. Scripps Co.
  www.venturacountystar.com
  [EMAIL PROTECTED]
  AIM: GoCatGo1956
  ~~

  -Original Message-
  From: Dave Hodder [SMTP:[EMAIL PROTECTED]
  Sent: Saturday, September 27, 2003 12:38 PM
  To: CF-Talk
  Subject: Re: CFV: comp.lang.coldfusion Usenet Newsgroup
 
  Jim McAtee wrote:
 
   There's already a CF newsgroup.Why the need for
   another?
 
  It's covered in the comp.lang.coldfusion rationale.Some
  of us on the
  existing alt.comp.lang.coldfusion group feel a proper
  comp.* group
  would give ColdFusion more legitimacy, as well as the
  group having
  better propagation, longer message retention periods,
  etc.
 
  Regards,
 
  Dave
 
 _
 
  [ Todays Threads
 _


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




parsing txt file - seems unparsable

2003-10-01 Thread Stephenie Hamilton
I am trying to use CFFILE to parse a text file, put the contents in a
var and then insert that into a db.

However, the file only gets parsed halfway through the first line. I
couldn't at first figure out why it would stop. If I opened the file
in notepad, added a space, then deleted the space, the file would
then parse correctly.

I then opened the file in wordpad and discovered that where the
parsing stops there is a little square that doesn't show up in
notepad, assuming some type of special character or something, but I
have no idea what.
If I manually delete the little square, then it parses fine (until it
runs into the one on the next line etc)...

is there any way to get past this? I am beating my head against the
wall and can no longer even see straight...

tia
Stephenie


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




RE: Settle an argument for me

2003-10-01 Thread cfhelp
Loop over the HTTP_USER_AGENT.

 

 

cfset BrowserList = Mozilla,Opera This could be in a database also. That
away if you're not listing one you can easily add it.

 

 

cfloop List=#BrowserList# Index=Browser

 

cfif HTTP_USER_AGENT CONTAINS Browser

 

 

Call the _javascript_ function to launch the mailto: link

 

 

 

cfbreak

 

/cfif

 

/cfloop

 

 

 

Give them a way to close this window.

 

ahref=_javascript_:parent.window.focus();top.window.close()Close
Window/a

 

_

From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 10:37 AM
To: CF-Talk

 

I like this idea, as the email addresses are already in a db.I guess I'm
trying figure out how I would write to check for the browser in this
scenario.

Thanks, Mark 

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 11:09 AM
To: CF-Talk
Subject: RE: Settle an argument for me


OK here is a thought...



Instead of masking put the email address in the database. Then build a small
page that pulls the email and launches the email program. To keep a bot from
following the link, confirm that the browser contains Mozilla, MSIE or Opera
(any others), or place a dynamically named cookie on the browser and then
check for it.



Your link would just be a href="">





Rick



_

From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 9:52 AM
To: CF-Talk



Instead of displaying the email address, why not create a contact form
therefore they would not see the actual email address.

However, I do as well mask my email addresses using JS and such.
But at times I use the forms to eliminate that possibility.

My 2 cents...



 [EMAIL PROTECTED] 10/01/03 10:51AM 
I would say no. But you need to ask yourself. Are these Spam bots
smart
enough to reverse the extended chars? If they are setup with this type
of
function, then yes I would say they are still picking them up.

I would say this is just a guess they are not doing this type of
function
while gathering emails.

Shawn Regan
Head Applications Developer
pacifictechnologysolutions 

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 7:37 AM
To: CF-Talk
Subject: Settle an argument for me


I've been using a UDF called emailAntiSpam, which replaces an email
address in the source code with extended characters which supposedly
can't
be crawled and picked up by spambots.

So my address:[EMAIL PROTECTED] would look like:

a
href="">
#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
;#108;#101;#46;#99;#111;#109; target=_blankNotify the
Webmaster/a

My problem, my client thinks they are still being picked up and used
for
spam - I also have a robots.txt file set to disallow bot crawling.

I've had both these in place since day one, when the site was posted
about 3
months ago.

Does it actually work?

Thanks, Mark 


_

[ Todays Threads 



_

[Todays 
_




_

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




Re: parsing txt file - seems unparsable

2003-10-01 Thread S . Isaac Dealey
if you output the content of the file in your cf template (prior to db
insert) does it display the whole thing? If so, are you using
cfqueryparam?

 I am trying to use CFFILE to parse a text file, put the
 contents in a
 var and then insert that into a db.

 However, the file only gets parsed halfway through the
 first line. I
 couldn't at first figure out why it would stop. If I
 opened the file
 in notepad, added a space, then deleted the space, the
 file would
 then parse correctly.

 I then opened the file in wordpad and discovered that
 where the
 parsing stops there is a little square that doesn't show
 up in
 notepad, assuming some type of special character or
 something, but I
 have no idea what.
 If I manually delete the little square, then it parses
 fine (until it
 runs into the one on the next line etc)...

 is there any way to get past this? I am beating my head
 against the
 wall and can no longer even see straight...

 tia
 Stephenie


 ~~

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




Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread S . Isaac Dealey
Heh... Thanks Jim... You know I'm always too beligerant to be nice. :)

 Done, but I said it in a nice way :)

 - Jim

 S. Isaac Dealey wrote:

 They definately don't belong there... It's funny, I've
 never seen them
 anywhere but in the programming section next to C++ ...
 (Not popular
 enough to be on the end-cap next to XML for Dummies I
 guess.) But then
 it's been a little while since I've seriously been in a
 book store
 looking for CF books.

 Though I do think we should complain to Amazon.com for
 not having a
 ColdFusion section on this page:

 http://www.amazon.com/exec/obidos/tg/browse/-/4021/ref=br
 _bx_c_2_4/002
 -1274419-3838416



  I don't think it matters, since we all know where they
  are
  anyways :-)

  -Original Message-
  From: Owens, Howard
  [mailto:[EMAIL PROTECTED]
  Sent: Tuesday, September 30, 2003 6:45 PM
  To: CF-Talk
  Subject: RE: CFV: comp.lang.coldfusion Usenet Newsgroup


  Speaking of more legitimacy -- what's up with chain
  bookstores always filing
  the CF titles under graphic/web design?

  I asked an employee of my local Barnes and Nobel the
  other
  day and he said
  this was a corporate decision.

  Personally, it always irks me that CF books aren't in
  with
  the programming
  books.Maybe we should all start complaining to the
  chains about this, and
  MM -- MM should file its own protests. I think.

  H.



  ~~
  Howard Owens
  Internet Operations Coordinator
  Ventura County Star / E.W. Scripps Co.
  www.venturacountystar.com
  [EMAIL PROTECTED]
  AIM: GoCatGo1956
  ~~

  -Original Message-
  From: Dave Hodder [SMTP:[EMAIL PROTECTED]
  Sent: Saturday, September 27, 2003 12:38 PM
  To: CF-Talk
  Subject: Re: CFV: comp.lang.coldfusion Usenet
  Newsgroup
 
  Jim McAtee wrote:
 
   There's already a CF newsgroup.Why the need for
   another?
 
  It's covered in the comp.lang.coldfusion rationale.
  Some
  of us on the
  existing alt.comp.lang.coldfusion group feel a
  proper
  comp.* group
  would give ColdFusion more legitimacy, as well as the
  group having
  better propagation, longer message retention periods,
  etc.
 
  Regards,
 
  Dave
 
 _
 
  [ Todays Threads
 _


  ~~~
  ~~~

 ~~

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




Re:parsing txt file - seems unparsable

2003-10-01 Thread Stephenie Hamilton
it does not display the whole file. it stops when it gets to the little square on the first line. i can't even get to the part of inserting into db because i get only part of the first line. sigh 
Stephenie



if you output the content of the file in your cf template (prior to db
insert) does it display the whole thing? If so, are you using
cfqueryparam?

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




SQL Error

2003-10-01 Thread Andy Ousterhout
This parameter value:(param 15) = [type='IN', class='java.lang.Double',
value='44.5', sqltype='CF_SQL_MONEY']
is creating the following error:Error Executing Database Query. Invalid data
for CFSQLTYPE CF_SQL_DOUBLE.

This is storing a value to a MS Access DB field that has data type of
currency.

Can anyone tell me what is wrong?

Andy


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




Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread Jim Campbell
With the sheer amount of money I funnel into Jeff Bezos' Amateur Pilot 
Tuition Fund, hopefully my words will carry some weight.Any site where 
I can buy a Gorilla Biscuits CD, Clie stylus refills, discontinued 
Dreamcast games and a hardcover copy of Coraline in one session *and* 
have them delivered in two days is worth trying to improve with a little 
more prominent ColdFusion resources :)

- Jim

S. Isaac Dealey wrote:

 Heh... Thanks Jim... You know I'm always too beligerant to be nice. :)

  Done, but I said it in a nice way :)

  - Jim

  S. Isaac Dealey wrote:

  They definately don't belong there... It's funny, I've
  never seen them
  anywhere but in the programming section next to C++ ...
  (Not popular
  enough to be on the end-cap next to XML for Dummies I
  guess.) But then
  it's been a little while since I've seriously been in a
  book store
  looking for CF books.
 
  Though I do think we should complain to Amazon.com for
  not having a
  ColdFusion section on this page:
 
  http://www.amazon.com/exec/obidos/tg/browse/-/4021/ref=br
  _bx_c_2_4/002
  -1274419-3838416
 
 
 
   I don't think it matters, since we all know where they
   are
   anyways :-)
 
   -Original Message-
   From: Owens, Howard
   [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, September 30, 2003 6:45 PM
   To: CF-Talk
   Subject: RE: CFV: comp.lang.coldfusion Usenet Newsgroup
 
 
   Speaking of more legitimacy -- what's up with chain
   bookstores always filing
   the CF titles under graphic/web design?
 
   I asked an employee of my local Barnes and Nobel the
   other
   day and he said
   this was a corporate decision.
 
   Personally, it always irks me that CF books aren't in
   with
   the programming
   books.Maybe we should all start complaining to the
   chains about this, and
   MM -- MM should file its own protests. I think.
 
   H.
 
 
 
   ~~
   Howard Owens
   Internet Operations Coordinator
   Ventura County Star / E.W. Scripps Co.
   www.venturacountystar.com
   [EMAIL PROTECTED]
   AIM: GoCatGo1956
   ~~
 
   -Original Message-
   From: Dave Hodder [SMTP:[EMAIL PROTECTED]
   Sent: Saturday, September 27, 2003 12:38 PM
   To: CF-Talk
   Subject: Re: CFV: comp.lang.coldfusion Usenet
   Newsgroup
  
   Jim McAtee wrote:
  
There's already a CF newsgroup.Why the need for
another?
  
   It's covered in the comp.lang.coldfusion rationale.
   Some
   of us on the
   existing alt.comp.lang.coldfusion group feel a
   proper
   comp.* group
   would give ColdFusion more legitimacy, as well as the
   group having
   better propagation, longer message retention periods,
   etc.
  
   Regards,
  
   Dave
  
  _
  
   [ Todays Threads
  _
 
 
   ~~~
   ~~~
 
  ~~
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Compressing Javascript

2003-10-01 Thread Barney Boisvert
The simplest way is to just remove any whitespace that follows a semicolon.
That's where most of the extra characters are, especially if you have more
than a level or two of indentation.You can also remove spaces from around
these characters:
= + - { } ( )

Those the the biggest culprits of white space in my JS, and should let you
reduce stuff a bunch.Of course, if you still want readable code, then
you'll want to be a little less complete with removing line breaks and
stuff, but if you're donig your stripping as part of the publishing
procedure, then you can just kill it all.

barneyb

 -Original Message-
From: Brook Davies [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 8:30 AM
To: CF-Talk
Subject: Compressing _javascript_


Does anyone know of a UDF or customtag that will compress _javascript_ to
cut
down on file size? I know there are apps that do this, and I would like to
include this functionality with some of our dynamically generated pages.

Thanks!

Brook Davies



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




RE: Settle an argument for me

2003-10-01 Thread Mark Leder
Thanks, I'll give it a whirl.

Thanks, Mark 

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 12:22 PM
To: CF-Talk
Subject: RE: Settle an argument for me


Loop over the HTTP_USER_AGENT.





cfset BrowserList = Mozilla,Opera This could be in a database also. That
away if you're not listing one you can easily add it.





cfloop List=#BrowserList# Index=Browser



cfif HTTP_USER_AGENT CONTAINS Browser



 

Call the _javascript_ function to launch the mailto: link



 



cfbreak



/cfif



/cfloop







Give them a way to close this window.



ahref=_javascript_:parent.window.focus();top.window.close()Close
Window/a



_

From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 10:37 AM
To: CF-Talk



I like this idea, as the email addresses are already in a db.I guess I'm
trying figure out how I would write to check for the browser in this
scenario.

Thanks, Mark 

-Original Message-
From: cfhelp [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 11:09 AM
To: CF-Talk
Subject: RE: Settle an argument for me


OK here is a thought...



Instead of masking put the email address in the database. Then build a small
page that pulls the email and launches the email program. To keep a bot from
following the link, confirm that the browser contains Mozilla, MSIE or Opera
(any others), or place a dynamically named cookie on the browser and then
check for it.



Your link would just be a href="">





Rick



_

From: Randell B Adkins [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 9:52 AM
To: CF-Talk



Instead of displaying the email address, why not create a contact form
therefore they would not see the actual email address.

However, I do as well mask my email addresses using JS and such.
But at times I use the forms to eliminate that possibility.

My 2 cents...



 [EMAIL PROTECTED] 10/01/03 10:51AM 
I would say no. But you need to ask yourself. Are these Spam bots
smart
enough to reverse the extended chars? If they are setup with this type
of
function, then yes I would say they are still picking them up.

I would say this is just a guess they are not doing this type of
function
while gathering emails.

Shawn Regan
Head Applications Developer
pacifictechnologysolutions 

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 7:37 AM
To: CF-Talk
Subject: Settle an argument for me


I've been using a UDF called emailAntiSpam, which replaces an email
address in the source code with extended characters which supposedly
can't
be crawled and picked up by spambots.

So my address:[EMAIL PROTECTED] would look like:

a
href="">
#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
;#108;#101;#46;#99;#111;#109; target=_blankNotify the
Webmaster/a

My problem, my client thinks they are still being picked up and used
for
spam - I also have a robots.txt file set to disallow bot crawling.

I've had both these in place since day one, when the site was posted
about 3
months ago.

Does it actually work?

Thanks, Mark 


_

[ Todays Threads 



_

[Todays 
_




_

[Todays 
_


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




Bank Of America CC processing

2003-10-01 Thread Ryan Roskilly
I'm trying to test processing of credit cards on a test account using Bank
Of America.

In the return code I'm getting this.

IOC_reject_description=The site that originated the order request is not
authorized to POST transactions.

But according to all the setting I can find I do have it set up correctly.

Anybody else have experience using there system?


Thanks,

-Ryan


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




Re:Breadcrumbs in Cold Fusion

2003-10-01 Thread Deetra Whatley
Hi Brad Roberts, 

I am interested in your two tags for breadcrumbs. 

If possible, I would like to have them. 

Thanks.

Deetra Whatley
[EMAIL PROTECTED]

For a tree view, I built a tag based off of Piet Niederhausen's
cf_traverseTree, which uses Joe Celko's algorithim from his book SQL for
Smarties.
http://www.niederhausen.net/piet/dev/customtags/index.htmlThe code is a
lot simpler... it took me hours to figure it out.And, instead of taking a
query, it takes a stucture.You can still use a query, you just have to
convert it to a structure... I think there's a UDF on cflib.org for this.
Or, you could re-code it to take a query.

For breadcrumbs, I built a UDF that takes a scruct of your pages with
parent/child relationships.The UDF traverses the structure and returns an
array with the pages in order.Then, you can loop over the array and format
your links however you wish.

I use these two tags together in my CMS and they work great.

If anyone's interested, send me an email...

-Brad
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:19 AM
To: CF-Talk
Subject: Re: Breadcrumbs in Cold Fusion


What about a nice treeview display similar to Microsoft Explorer?

--Original Message Text---
From: Randell B Adkins
Date: Wed, 01 Oct 2003 06:56:43 -0400

What I do is have a CutomTag (BCMenu.cfm).
When needed I call the CustomTag passing 3 parameters:

CF_BCMenu
ItemName=First Link, Second Link, Third Link
ItemLink=aaa.cfm,bbb.cfm,ccc.cfm
ActiveItem=This Page Name

The Custom Tag writes out:
cfloop index=i from=1 to=#ListLen(ATTRIBUTES.ItemName)#
cfoutput
a

href="">
Name,i)#/strong/a

img
src="">
/cfoutput
/cfloop
!--- Output the current page title ---
cfoutput#ATTRIBUTES.ActiveItem#/cfoutput


 [EMAIL PROTECTED] 10/01/03 06:43AM 
Good Day,

Does anyone have any code for breadcrumbs in Cold Fusion.

If so and possible may I have a sample of that code.I would like to
use breadcrumbs with Cold Fusion in my site.

Thank you.

Deetra Whatley


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




Re: Settle an argument for me

2003-10-01 Thread Cutter (CF-Talk)
Mark,

I can't see how they could reverse engineer it (though spammers are 
known to get notoriously industrious.) A technique I've used in the past 
is to set up a dynamic listing of contacts, which brings up a custom 
(branded no less) form for the message, then sends the contactID and 
message details to a script which makes a db call for the actual address 
to cfmail to. No addresses in code, branded message window, easy contact 
maintenance, and tracking as well (if needed.) This might be a better 
answer to your client's issues (though their ISP or an internal admin 
may have sold their address list anyway, or the spammers are using a 
rotation listing to target any address permutation of their domain.)

Cutter

Mark Leder wrote:
 I've been using a UDF called emailAntiSpam, which replaces an email
 address in the source code with extended characters which supposedly can't
 be crawled and picked up by spambots.
 
 So my address:[EMAIL PROTECTED] would look like:
 
 a
 href="">
 #101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
 ;#108;#101;#46;#99;#111;#109; target=_blankNotify the
 Webmaster/a
 
 My problem, my client thinks they are still being picked up and used for
 spam - I also have a robots.txt file set to disallow bot crawling.
 
 I've had both these in place since day one, when the site was posted about 3
 months ago.
 
 Does it actually work?
 
 Thanks, Mark
 
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:parsing txt file - seems unparsable

2003-10-01 Thread Stephenie Hamilton
If i open the file in notepad, then save it (without making any changes) it works fine. h...wonder how/if i can use cfexecute to have notepad open the file and then save it?
other than that, i can't think of anything else...

Steph

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




RE: Settle an argument for me

2003-10-01 Thread Mark Leder
Cutter, Another great idea. Thanks for your suggestion.

Thanks, Mark 

-Original Message-
From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 01, 2003 1:09 PM
To: CF-Talk
Subject: Re: Settle an argument for me


Mark,

I can't see how they could reverse engineer it (though spammers are 
known to get notoriously industrious.) A technique I've used in the past 
is to set up a dynamic listing of contacts, which brings up a custom 
(branded no less) form for the message, then sends the contactID and 
message details to a script which makes a db call for the actual address 
to cfmail to. No addresses in code, branded message window, easy contact 
maintenance, and tracking as well (if needed.) This might be a better 
answer to your client's issues (though their ISP or an internal admin 
may have sold their address list anyway, or the spammers are using a 
rotation listing to target any address permutation of their domain.)

Cutter

Mark Leder wrote:
 I've been using a UDF called emailAntiSpam, which replaces an email
 address in the source code with extended characters which supposedly can't
 be crawled and picked up by spambots.
 
 So my address:[EMAIL PROTECTED] would look like:
 
 a

href="">

#101;#97;#114;#108;#121;#119;#104;#105;#116;#101;#115;#109;#105
 ;#108;#101;#46;#99;#111;#109; target=_blankNotify the
 Webmaster/a
 
 My problem, my client thinks they are still being picked up and used for
 spam - I also have a robots.txt file set to disallow bot crawling.
 
 I've had both these in place since day one, when the site was posted about
3
 months ago.
 
 Does it actually work?
 
 Thanks, Mark
 
 
_


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




Re: CFV: comp.lang.coldfusion Usenet Newsgroup

2003-10-01 Thread S . Isaac Dealey
Not sure about the rest of it, but I'll support more prominent cf
resources. :) It's not like there's a lack of material for the
category -- there's 74 titles if you search and they show 10 per page,
so ... wouldn't that be like nearly 10 pages of results like the other
subcategories there like ASP and JSP?


 With the sheer amount of money I funnel into Jeff Bezos'
 Amateur Pilot
 Tuition Fund, hopefully my words will carry some weight.
 Any site where
 I can buy a Gorilla Biscuits CD, Clie stylus refills,
 discontinued
 Dreamcast games and a hardcover copy of Coraline in one
 session *and*
 have them delivered in two days is worth trying to improve
 with a little
 more prominent ColdFusion resources :)

 - Jim

 S. Isaac Dealey wrote:

 Heh... Thanks Jim... You know I'm always too beligerant
 to be nice. :)

  Done, but I said it in a nice way :)

  - Jim

  S. Isaac Dealey wrote:

  They definately don't belong there... It's funny, I've
  never seen them
  anywhere but in the programming section next to C++
  ...
  (Not popular
  enough to be on the end-cap next to XML for Dummies I
  guess.) But then
  it's been a little while since I've seriously been in
  a
  book store
  looking for CF books.
 
  Though I do think we should complain to Amazon.com for
  not having a
  ColdFusion section on this page:
 
  http://www.amazon.com/exec/obidos/tg/browse/-/4021/ref
  =br
  _bx_c_2_4/002
  -1274419-3838416
 
 
 
   I don't think it matters, since we all know where
   they
   are
   anyways :-)
 
   -Original Message-
   From: Owens, Howard
   [mailto:[EMAIL PROTECTED]
   Sent: Tuesday, September 30, 2003 6:45 PM
   To: CF-Talk
   Subject: RE: CFV: comp.lang.coldfusion Usenet
   Newsgroup
 
 
   Speaking of more legitimacy -- what's up with chain
   bookstores always filing
   the CF titles under graphic/web design?
 
   I asked an employee of my local Barnes and Nobel the
   other
   day and he said
   this was a corporate decision.
 
   Personally, it always irks me that CF books aren't
   in
   with
   the programming
   books.Maybe we should all start complaining to the
   chains about this, and
   MM -- MM should file its own protests. I think.
 
   H.
 
 
 
   
   ~~
   Howard Owens
   Internet Operations Coordinator
   Ventura County Star / E.W. Scripps Co.
   www.venturacountystar.com
   [EMAIL PROTECTED]
   AIM: GoCatGo1956
   
   ~~
 
   -Original Message-
   From: Dave Hodder [SMTP:[EMAIL PROTECTED]
   Sent: Saturday, September 27, 2003 12:38 PM
   To: CF-Talk
   Subject: Re: CFV: comp.lang.coldfusion Usenet
   Newsgroup
  
   Jim McAtee wrote:
  
There's already a CF newsgroup.Why the need for
another?
  
   It's covered in the comp.lang.coldfusion rationale.
   Some
   of us on the
   existing alt.comp.lang.coldfusion group feel a
   proper
   comp.* group
   would give ColdFusion more legitimacy, as well as
   the
   group having
   better propagation, longer message retention
   periods,
   etc.
  
   Regards,
  
   Dave
  
  _
  
   [ Todays Threads
  _
 
 
   
   ~~~
   ~~~
 
  ~~~
  ~~~

 ~~

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




RE: Breadcrumbs in Cold Fusion

2003-10-01 Thread Brad Roberts
I've posted an example and download here:
http://www.agentvow.com/traverseTree/

Let me know if you have any thoughts or improvements.

-Brad
-Original Message-
From: Deetra Whatley [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 1:07 PM
To: CF-Talk
Subject: Re:Breadcrumbs in Cold Fusion


Hi Brad Roberts,

I am interested in your two tags for breadcrumbs.

If possible, I would like to have them.

Thanks.

Deetra Whatley
[EMAIL PROTECTED]

For a tree view, I built a tag based off of Piet Niederhausen's
cf_traverseTree, which uses Joe Celko's algorithim from his book SQL for
Smarties.
http://www.niederhausen.net/piet/dev/customtags/index.htmlThe code is a
lot simpler... it took me hours to figure it out.And, instead of taking
a
query, it takes a stucture.You can still use a query, you just have to
convert it to a structure... I think there's a UDF on cflib.org for this.
Or, you could re-code it to take a query.

For breadcrumbs, I built a UDF that takes a scruct of your pages with
parent/child relationships.The UDF traverses the structure and returns
an
array with the pages in order.Then, you can loop over the array and
format
your links however you wish.

I use these two tags together in my CMS and they work great.

If anyone's interested, send me an email...

-Brad
-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 9:19 AM
To: CF-Talk
Subject: Re: Breadcrumbs in Cold Fusion


What about a nice treeview display similar to Microsoft Explorer?

--Original Message Text---
From: Randell B Adkins
Date: Wed, 01 Oct 2003 06:56:43 -0400

What I do is have a CutomTag (BCMenu.cfm).
When needed I call the CustomTag passing 3 parameters:

CF_BCMenu
ItemName=First Link, Second Link, Third Link
ItemLink=aaa.cfm,bbb.cfm,ccc.cfm
ActiveItem=This Page Name

The Custom Tag writes out:
cfloop index=i from=1 to=#ListLen(ATTRIBUTES.ItemName)#
cfoutput
a


href="">
m
Name,i)#/strong/a

img
src="">
/cfoutput
/cfloop
!--- Output the current page title ---
cfoutput#ATTRIBUTES.ActiveItem#/cfoutput


 [EMAIL PROTECTED] 10/01/03 06:43AM 
Good Day,

Does anyone have any code for breadcrumbs in Cold Fusion.

If so and possible may I have a sample of that code.I would like to
use breadcrumbs with Cold Fusion in my site.

Thank you.

Deetra Whatley



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




RE: Bank Of America CC processing

2003-10-01 Thread McGill, Eric
Ryan,
Maybe BoA just needs to explicitly allow the IP or domain of the server posting the transactions?
Eric

-Original Message-

IOC_reject_description=The site that originated the order request is not
authorized to POST transactions.

But according to all the setting I can find I do have it set up correctly.



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




sql question pt 2

2003-10-01 Thread Tony Weeg
how does one use calculated variable names(not sure if this is what they are
called) in queries, later on in the query?

ie.

select count(tony) as tonysCount, sum(jayme) as jaymesCount
from orders 
where tony = tony
HAVING
Abs((tonysCount-jaymesCount)/tonysCount)  0

the problem is im getting an error like

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'tonysCount'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'jaymesCount'.

(which tony minus jayme would mean im not married anymore so it would always
= 0 :) or would my count go up...hee hee hee, just kidding..

thanks...

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

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




RE: Bank Of America CC processing

2003-10-01 Thread Matt Robertson
You need to put your web site into the validated referers list.They
check the referer value and bounce anything not coming from a recognized
location (as if the referer is a valid way of determining this).

If that still doesn't work and they are refusing a listed poster, you've
hit a bug in their system, which I have a fix for if you need it.

Cheers,


 Matt Robertson [EMAIL PROTECTED]
 MSB Designs, Inc.http://mysecretbase.com



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




Re:parsing txt file - seems unparsable

2003-10-01 Thread lee
This sounds line an end -f line or carriage return character (or both)

Do a replace of each [chr(10)  chr(13); replace with white space or some marker for your illumination ~~~ or whatever ] in the variable and see if that helps.

Are you SURE it's not in the database, as well? Just kicked down a line?

If i open the file in notepad, then save it (without making any 
changes) it works fine. h...wonder how/if i can use cfexecute to 
have notepad open the file and then save it?
other than that, i can't think of anything else...

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




Re: parsing txt file - seems unparsable

2003-10-01 Thread Ben Doom
I've run into this before.CF is actually opening the file correctly, 
but there's a null character, and CF uses null terminated strings, so it 
sees that and thinks the string is done.

At least, that's my best guess.

I've never found a way to fix this in CF, unfortunately.

--Ben

Stephenie Hamilton wrote:

 I am trying to use CFFILE to parse a text file, put the contents in a
 var and then insert that into a db.
 
 However, the file only gets parsed halfway through the first line. I
 couldn't at first figure out why it would stop. If I opened the file
 in notepad, added a space, then deleted the space, the file would
 then parse correctly.
 
 I then opened the file in wordpad and discovered that where the
 parsing stops there is a little square that doesn't show up in
 notepad, assuming some type of special character or something, but I
 have no idea what.
 If I manually delete the little square, then it parses fine (until it
 runs into the one on the next line etc)...
 
 is there any way to get past this? I am beating my head against the
 wall and can no longer even see straight...
 
 tia
 Stephenie
 
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:parsing txt file - seems unparsable

2003-10-01 Thread Jerry Johnson
Is this CF 5 or earlier?

If so, it is probably actually a NULL chr(0) character.

Notepad will get rid of it when you open and save the file.

CF 5 and earlier have trouble with strings containing NULLs, since it uses NULLs to mark the end of strings (I think).

The data is still in the string, but all of the output string functions stop at that character.

Solution? I don't have one. This is where Java and Custom Tags come in handy.

Jerry Johnson

 [EMAIL PROTECTED] 10/01/03 02:08PM 
This sounds line an end -f line or carriage return character (or both)

Do a replace of each [chr(10)  chr(13); replace with white space or some marker for your illumination ~~~ or whatever ] in the variable and see if that helps.

Are you SURE it's not in the database, as well? Just kicked down a line?

If i open the file in notepad, then save it (without making any 
changes) it works fine. h...wonder how/if i can use cfexecute to 
have notepad open the file and then save it?
other than that, i can't think of anything else...

Steph

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




sql question pt 2

2003-10-01 Thread Tony Weeg
question:

how does one use calculated variable names(not sure if this is what they are
called) in queries, later on in the query?

ie.

select count(tony) as tonysCount, sum(jayme) as jaymesCount from orders
where tony = tony HAVING
Abs((tonysCount-jaymesCount)/tonysCount)  0

the problem is im getting an error like

Server: Msg 207, Level 16, State 3, Line 1 Invalid column name 'tonysCount'.
Server: Msg 207, Level 16, State 1, Line 1 Invalid column name
'jaymesCount'.

(which tony minus jayme would mean im not married anymore so it would always
= 0 :) or would my count go up...hee hee hee, just kidding..

thanks...

...tony

tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337

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




  1   2   >