character encoding and an Access database

[Charlie Griefer]

Hey all...

got an XHTML page.  using iso-8859-1 encoding.

I have some MS Access memo field content being output to the page...this is
causing invalid XHTML when i try to validate (non SGML
characters...specifically punctuation...apostrophes, commas, even periods).

How do I work around this?  Do I need to 'massage' the data prior to it
going into Access?  Can I convert it coming out of Access?

TIA,
Charlie


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Calling a CFC from perl

[Sean A Corfield]

Shouldn't you be specifying "?WSDL" on your CFC URL in order to  
generate a SOAP interface?

We have Perl (SOAP::Lite) calling CF successfully here...

On Friday, Jan 17, 2003, at 15:04 US/Pacific, Brad Howerter wrote:

> Has anyone called a CFC service from perl?  I've written a cfc that I  
> can
> use with a url:
>
> http://webftc18/com/woodward/example.cfc?method=hi
>
> But I can't get perl to access it, I always get 'SOAP call failed: 401
> Access Denied at C:\Perl\bin\BTS.pl line 8'
>
> My perl program is simply:
>
> #!perl -w
> use SOAP::Lite
>   proxy => 'http://webftc18/com/woodward/example.cfc',
>   uri => 'http://woodward.com/examples'
>   ;
>
> my $soap1 = new SOAP::Lite;
> print $soap1->hi->result;
>
>
>
> Here's my coldfusion CFC code:
> 
>   
>  
>   
> 
>
>
> If I call real world examples from my perl program (instead of the one  
> I
> wrote), it works okay.
>
> ***
> The information in this e-mail is confidential and intended solely for  
> the
> individual or entity to whom it is addressed. If you have received this
> e-mail in error please notify the sender by return e-mail, delete this
> e-mail, and refrain from any disclosure or action based on the  
> information.
> 
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: AbleCommerce? Are they gone?

[Dave Carabetta]

> I was going to look for something at www.ablecommerce.com and it looks
> like their web site is gone.  Does anyone know if they have been another
> company to fold?

I got to their site just fine. As a matter of fact, it even looks like
they've just released updated products very recently.

Regards,
Dave.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Possible to name Application, save name, then rename Application?

[S . Isaac Dealey]

In all honesty, I'm not sure. :) It could be. It wouldn't surprise me.  But
it also wouldn't surprise me if it's not. I've never registered a domain
with GoDaddy either, so it's all pure conjecture from here.

> Concerning your comment:

> "...to have whatever dns server is responsible for your
> domains
> point directly to your DSL IP instead of being
> forwarded."

> Would that be what I would be doing if I used the
> "Advanced DNS
> Management" options and began to manage my DNS "C-Names"
> and zones with my registrar who is currently forwarding my
> domains?

> Thanks for the insights...

> Rick



> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 8:12 PM
> To: CF-Talk
> Subject: RE: Possible to name Application, save name, then
> rename
> Application?


> Yes, the method I suggested could be inconsistent -- the
> same problem exists
> for you now (if I understand your setup) and will persist,
> as long as you
> rely on the cgi.http_referer variable to determine what
> domain an individual
> is attempting to reach. The best possible solution (maybe
> the only
> completely reliable solution) is going to be to have
> whatever dns server is
> responsible for your domains point directly to your DSL IP
> instead of being
> forwarded.

>> Based on your comment...

>> "FYI - the cgi.http_referer variable isn't always present
>> on a given request
>>  - it can be filtered out by firewalls and the like."

>> ...it would seem that my method of:

>>  checking for the existence of ".com" in the HTTP_Referer
>>  and, if it's
>> present,
>> taking the HTTP_Referer and IDing the company's domain,
>> naming the CFApplication based on the HTTP_Referer,
>> assigning the HTTP_Referer value to a Server scope
>> variable...

>> ...then upon returning to any pages from within my server
>> (which would
>> change the HTTP_Referer
>> and eliminate the company's domain name from it and
>> render
>> that variable
>> useless)
>> use a new CFAppliation function to reassign the value
>> from
>> the Server scope,
>> then
>> (as you suggested) transfer the Server scope variable to
>> another Application
>> variable,
>> (or something that is contained within the Application
>> that's running, and
>> thereby,
>> not relying on the use of Server scope variables which
>> could be changed or
>> deleted
>> by other Applications running), then working from that
>> point off that
>> Application,
>> until the user used the www.bodafordhomes.com name again
>> or some other
>> domain with .com and the process would reset and start
>> over...

>> ...would not provide consistent performance because of
>> the
>> potential
>> filtering
>> of the HTTP_Referer variable?

>> If so, that's a problem...

>> Rick



>> -Original Message-
>> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
>> Sent: Friday, January 17, 2003 11:49 AM

>> To: CF-Talk
>> Subject: Re: Possible to name Application, save name,
>> then
>> rename
>> Application?


>> Considering that you also have to identify a client, the
>> server scope alone
>> may not quite get you where you need to be with this.
>> You'll need to figure
>> out how to identify each browser, for instance, you could
>> create a server
>> scoped structure ( server.clients ) which would then
>> contain a list of ip
>> addresses for different browsers drawn from the
>> cgi.remote_addr variable, or
>> you could use CF's CFID and CFToken pair although off the
>> top of my head I'm
>> not sure if they vary between applications. I don't think
>> they do, but I
>> wouldn't be surprised if I'm wrong. :)

>> Here's an example:

>> 

>> 
>>  >  type="struct" default="#structnew()#">
>>  >  cgi.http_referer>
>> 

>> 

>> 
>>  
>>  >  server.client[cgi.remote_addr]>
>>  
>> 

>> 

>> 

>> FYI - the cgi.http_referer variable isn't always present
>> on a given request
>> -- it can be filtered out by firewalls and the like.

>> hth

>> s. isaac dealey954-776-0046

>> new epoch  http://www.turnkey.to

>> lead architect, tapestry cms   http://products.turnkey.to

>> tapestry api is opensource http://www.turnkey.to/tapi

>> certified advanced coldfusion 5 developer
>> http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



>>> I know that makes no sense, but here's what's happening.

>>> I'm name a site that serves as a dynamic site for
>>> multiple
>>> companies.
>>> I need to name the Application and set variables by the
>>> CGI.HTTP_Referer
>>> variable.
>>> No problem so far.

>>> However, since the site is blind forwarded to my server,
>>> the HTTP_Referer
>>> variable
>>> changes once it's working off my server.  When it comes
>>> from the company
>>> that
>>> handles my DNS, it comes as
>>> http://www.bodafordhomes.com,
>>> from which I can
>>> do a CFIF CGI.HTTP_Referer contains ".com" and that
>>> tells
>>> me that the
>>> homepage
>>> has been r

CFMail question.... Encoding base64, 7bit

[Dan Blickensderfer]

Does anyone know how to change the Encoding format within a cfmail sent
message.  It's currently sending both base64 and 7bit.  I would only like to
send 7bit.

I have an email generated with a picture attached.  Here is what I have in
my cfmail tag.



#form.message#



When the email is sent here is the message header that it's sending.



x-cf-version: 4.5.0
x-cf-server: mail.tusco.net
x-cf-port: 25
x-cf-timeout: 60
x-cf-from: emailaddress
x-cf-to: emailaddress
Content-Type: multipart/mixed; boundary=---2e323f522e323f52
Date: Fri, 17 Jan 2003 23:35:27 -0500
From: emailaddress
Mime-version: 1.0
Subject: Subject line...
To: emailaddress
This is a multi-part message in MIME format.
-2e323f522e323f52
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Test message

-2e323f522e323f52

Content-Type: image/jpeg
Content-Disposition: attachment; filename="17376-2.jpg"
Content-Transfer-Encoding: base64
/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRof

-2e323f522e323f52--



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Possible to name Application, save name, then rename Application?

[Rick Faircloth]

Concerning your comment:

"...to have whatever dns server is responsible for your domains
point directly to your DSL IP instead of being
forwarded."

Would that be what I would be doing if I used the "Advanced DNS
Management" options and began to manage my DNS "C-Names"
and zones with my registrar who is currently forwarding my domains?

Thanks for the insights...

Rick



-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 8:12 PM
To: CF-Talk
Subject: RE: Possible to name Application, save name, then rename
Application?


Yes, the method I suggested could be inconsistent -- the same problem exists
for you now (if I understand your setup) and will persist, as long as you
rely on the cgi.http_referer variable to determine what domain an individual
is attempting to reach. The best possible solution (maybe the only
completely reliable solution) is going to be to have whatever dns server is
responsible for your domains point directly to your DSL IP instead of being
forwarded.

> Based on your comment...

> "FYI - the cgi.http_referer variable isn't always present
> on a given request
>  - it can be filtered out by firewalls and the like."

> ...it would seem that my method of:

>  checking for the existence of ".com" in the HTTP_Referer
>  and, if it's
> present,
> taking the HTTP_Referer and IDing the company's domain,
> naming the CFApplication based on the HTTP_Referer,
> assigning the HTTP_Referer value to a Server scope
> variable...

> ...then upon returning to any pages from within my server
> (which would
> change the HTTP_Referer
> and eliminate the company's domain name from it and render
> that variable
> useless)
> use a new CFAppliation function to reassign the value from
> the Server scope,
> then
> (as you suggested) transfer the Server scope variable to
> another Application
> variable,
> (or something that is contained within the Application
> that's running, and
> thereby,
> not relying on the use of Server scope variables which
> could be changed or
> deleted
> by other Applications running), then working from that
> point off that
> Application,
> until the user used the www.bodafordhomes.com name again
> or some other
> domain with .com and the process would reset and start
> over...

> ...would not provide consistent performance because of the
> potential
> filtering
> of the HTTP_Referer variable?

> If so, that's a problem...

> Rick



> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 11:49 AM

> To: CF-Talk
> Subject: Re: Possible to name Application, save name, then
> rename
> Application?


> Considering that you also have to identify a client, the
> server scope alone
> may not quite get you where you need to be with this.
> You'll need to figure
> out how to identify each browser, for instance, you could
> create a server
> scoped structure ( server.clients ) which would then
> contain a list of ip
> addresses for different browsers drawn from the
> cgi.remote_addr variable, or
> you could use CF's CFID and CFToken pair although off the
> top of my head I'm
> not sure if they vary between applications. I don't think
> they do, but I
> wouldn't be surprised if I'm wrong. :)

> Here's an example:

> 

> 
>  type="struct" default="#structnew()#">
>   
> 

> 

> 
>   
>  server.client[cgi.remote_addr]>
>   
> 

> 

> 

> FYI - the cgi.http_referer variable isn't always present
> on a given request
> -- it can be filtered out by firewalls and the like.

> hth

> s. isaac dealey954-776-0046

> new epoch  http://www.turnkey.to

> lead architect, tapestry cms   http://products.turnkey.to

> tapestry api is opensource http://www.turnkey.to/tapi

> certified advanced coldfusion 5 developer
> http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



>> I know that makes no sense, but here's what's happening.

>> I'm name a site that serves as a dynamic site for
>> multiple
>> companies.
>> I need to name the Application and set variables by the
>> CGI.HTTP_Referer
>> variable.
>> No problem so far.

>> However, since the site is blind forwarded to my server,
>> the HTTP_Referer
>> variable
>> changes once it's working off my server.  When it comes
>> from the company
>> that
>> handles my DNS, it comes as http://www.bodafordhomes.com,
>> from which I can
>> do a CFIF CGI.HTTP_Referer contains ".com" and that tells
>> me that the
>> homepage
>> has been requested from somewhere besides my server and
>> the ID of the
>> company
>> needs to be determined for the dynamic site to be setup.
>> I have
>> http://www.bodafordhomes.com
>> stored in the database from which to ID the company and
>> choose it's data.

>> The problem comes when the pages are served from my
>> server.  They use URL's
>> like http://77.88.99.00/cfdocs/rea/index.cfm , so the new
>> CGI.HTTP_Referer
>>

Re: Studio 5 not displaying international characters

[Paul Hastings]

> Does anyone know why Coldfusion Studio display's question marks instead
> of the correct character? I have a file saved in utf-8 encoding with the

any number of reasons for that. was the file unicode format to begin with?
did you cut & paste from something else? did you use a unicode font?
basically studio's unicode support has been busted since it was released.
use notepad to create the file in utf-8 format, & *then* use studio to code
remembering to leave the BOM alone (the funny looking first 3 chars).

> meta tag content set to "text/html; charset=utf-8". I had to insert the

which has no effect in mx--if you're not using mx for this then you will get
into trouble down the line.

> note pad. I am assuming that Studio can display these characters since I
> can't find any documentation or web searches that seem to indicate
> otherwise. Anyone know what I'm doing wrong?

negative evidence, in this case, isn't a good indicator.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: UDF question -- make num a string

[Charlie Griefer]

outNum = finalResult & '%'

& is the concatenation operator in CF (yeah, i know...it can be annoying) :)

charlie

- Original Message -
From: "Owens, Howard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 5:29 PM
Subject: UDF question -- make num a string


> I'm trying to do a little UDF to convert something like .77809 to 78%
>
> If I do something like:
>
> outNum=finalResult + '%';
>
> I get an error that says "cannot convert % to a number" ...
>
> well, I don't want it to be a num. I want it to be a string.  I can't find
a
> way to get a string output in the return.
>
> H.
>
> ~~
> Howard Owens
> Internet Operations Coordinator
> InsideVC.com/Ventura County Star
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
> ~~
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Studio 5 not displaying international characters

[George W. Overholtzer]

Does anyone know why Coldfusion Studio display's question marks instead
of the correct character? I have a file saved in utf-8 encoding with the
meta tag content set to "text/html; charset=utf-8". I had to insert the
Chinese characters in note pad because when I tried to type them in to
studio It just replaced the Chinese characters with question marks.
Still even though I was able to successfully input the characters
through note pad when I open up the file in Studio it still displays the
question marks. Also when the page is rendered in a browser they appear
fine. It would just be nice if I could use Coldfusion Studio rather than
note pad. I am assuming that Studio can display these characters since I
can't find any documentation or web searches that seem to indicate
otherwise. Anyone know what I'm doing wrong?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: UDF question -- make num a string

[Marius Milosav]

try :
 outNum=finalResult & '%';

Marius Milosav
www.scorpiosoft.com
It's not about technology, it's about people.
Virtual Company (VICO) Application Demo
www.scorpiosoft.com/vicodemo/login.cfm


- Original Message -
From: "Owens, Howard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 7:29 PM
Subject: UDF question -- make num a string


> I'm trying to do a little UDF to convert something like .77809 to 78%
>
> If I do something like:
>
> outNum=finalResult + '%';
>
> I get an error that says "cannot convert % to a number" ...
>
> well, I don't want it to be a num. I want it to be a string.  I can't find
a
> way to get a string output in the return.
>
> H.
>
> ~~
> Howard Owens
> Internet Operations Coordinator
> InsideVC.com/Ventura County Star
> [EMAIL PROTECTED]
> AIM: GoCatGo1956
> ~~
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: UDF question -- make num a string

[Robert Bailey]

When you use the +, tried to add it, replace the + with & and you will
be ok:

outNum=finalResult & '%';

 

Used to get me all the time, still once in a while, lol


Robert Bailey
[EMAIL PROTECTED]
"Famous for nothing!"
http://www.tinetics.com
 
 

-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 4:29 PM
To: CF-Talk
Subject: UDF question -- make num a string

I'm trying to do a little UDF to convert something like .77809 to 78%

If I do something like:

outNum=finalResult + '%';

I get an error that says "cannot convert % to a number" ...

well, I don't want it to be a num. I want it to be a string.  I can't
find a
way to get a string output in the return.

H.

~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Possible to name Application, save name, then rename Application?

[S . Isaac Dealey]

Yes, the method I suggested could be inconsistent -- the same problem exists
for you now (if I understand your setup) and will persist, as long as you
rely on the cgi.http_referer variable to determine what domain an individual
is attempting to reach. The best possible solution (maybe the only
completely reliable solution) is going to be to have whatever dns server is
responsible for your domains point directly to your DSL IP instead of being
forwarded.

> Based on your comment...

> "FYI - the cgi.http_referer variable isn't always present
> on a given request
>  - it can be filtered out by firewalls and the like."

> ...it would seem that my method of:

>  checking for the existence of ".com" in the HTTP_Referer
>  and, if it's
> present,
> taking the HTTP_Referer and IDing the company's domain,
> naming the CFApplication based on the HTTP_Referer,
> assigning the HTTP_Referer value to a Server scope
> variable...

> ...then upon returning to any pages from within my server
> (which would
> change the HTTP_Referer
> and eliminate the company's domain name from it and render
> that variable
> useless)
> use a new CFAppliation function to reassign the value from
> the Server scope,
> then
> (as you suggested) transfer the Server scope variable to
> another Application
> variable,
> (or something that is contained within the Application
> that's running, and
> thereby,
> not relying on the use of Server scope variables which
> could be changed or
> deleted
> by other Applications running), then working from that
> point off that
> Application,
> until the user used the www.bodafordhomes.com name again
> or some other
> domain with .com and the process would reset and start
> over...

> ...would not provide consistent performance because of the
> potential
> filtering
> of the HTTP_Referer variable?

> If so, that's a problem...

> Rick



> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 11:49 AM

> To: CF-Talk
> Subject: Re: Possible to name Application, save name, then
> rename
> Application?


> Considering that you also have to identify a client, the
> server scope alone
> may not quite get you where you need to be with this.
> You'll need to figure
> out how to identify each browser, for instance, you could
> create a server
> scoped structure ( server.clients ) which would then
> contain a list of ip
> addresses for different browsers drawn from the
> cgi.remote_addr variable, or
> you could use CF's CFID and CFToken pair although off the
> top of my head I'm
> not sure if they vary between applications. I don't think
> they do, but I
> wouldn't be surprised if I'm wrong. :)

> Here's an example:

> 

> 
>  type="struct" default="#structnew()#">
>   
> 

> 

> 
>   
>  server.client[cgi.remote_addr]>
>   
> 

> 

> 

> FYI - the cgi.http_referer variable isn't always present
> on a given request
> -- it can be filtered out by firewalls and the like.

> hth

> s. isaac dealey954-776-0046

> new epoch  http://www.turnkey.to

> lead architect, tapestry cms   http://products.turnkey.to

> tapestry api is opensource http://www.turnkey.to/tapi

> certified advanced coldfusion 5 developer
> http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



>> I know that makes no sense, but here's what's happening.

>> I'm name a site that serves as a dynamic site for
>> multiple
>> companies.
>> I need to name the Application and set variables by the
>> CGI.HTTP_Referer
>> variable.
>> No problem so far.

>> However, since the site is blind forwarded to my server,
>> the HTTP_Referer
>> variable
>> changes once it's working off my server.  When it comes
>> from the company
>> that
>> handles my DNS, it comes as http://www.bodafordhomes.com,
>> from which I can
>> do a CFIF CGI.HTTP_Referer contains ".com" and that tells
>> me that the
>> homepage
>> has been requested from somewhere besides my server and
>> the ID of the
>> company
>> needs to be determined for the dynamic site to be setup.
>> I have
>> http://www.bodafordhomes.com
>> stored in the database from which to ID the company and
>> choose it's data.

>> The problem comes when the pages are served from my
>> server.  They use URL's
>> like http://77.88.99.00/cfdocs/rea/index.cfm , so the new
>> CGI.HTTP_Referer
>> can't
>> be used to determine company ID any longer and the
>> Application can't user
>> the CGI.HTTP_Referer
>> any longer as a name, because the Application name has to
>> stay the same to
>> keep the variables
>> tied to the Application...

>> I need to store the first CGI.HTTP_Referer variable, then
>> when the
>> Application.cfm
>> page is consulted, I can recall that saved original
>> HTTP_Referer variable as
>> some other
>> variable and rename the Application.cfm with it.

>> There's the question:  How to save that variable, since I
>> can't use
>> application or session
>> va

RE: UDF question -- make num a string

[Robert Bailey]

outNum = finalResult & '%';

 
Robert Bailey
[EMAIL PROTECTED]
"Famous for nothing!"
http://www.tinetics.com
 
 

-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 4:29 PM
To: CF-Talk
Subject: UDF question -- make num a string

I'm trying to do a little UDF to convert something like .77809 to 78%

If I do something like:

outNum=finalResult + '%';

I get an error that says "cannot convert % to a number" ...

well, I don't want it to be a num. I want it to be a string.  I can't
find a
way to get a string output in the return.

H.

~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: WOT: Access SQL Question - Round 2

[S . Isaac Dealey]

> I'm know any anything about inner/outer joins - how is
> using an inner join different from using pk=fk, and why
> would you want to use it in this case?

An inner join is reasonably similar to using pk=fk in a where clause. I'm
not sure what the internal differences are, re: performance, etc. An outer
join produces a query wherein data from table 1 is required and data from
table 2 is optional, i.e. "find all issues associated with user x" wherein
you want to retreive data from the users table and zero or more associated
records from the issues table. With an inner join or a typical pk=fk where
clause, no data is returned from the users table if there are no issues
associated with the user. In this particular case he probably didn't want an
outer join, although it's possible an inner join might improve performance
over the where clause, but again that's just conjecture.

hth

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

tapestry api is opensource http://www.turnkey.to/tapi

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816

> Thanks,

> Matthew Small
> IT Supervisor
> Showstopper National Dance Competitions
> 3660 Old Kings Hwy
> Murrells Inlet, SC 29576
> 843-357-1847
> http://www.showstopperonline.com

> -Original Message-
> From: Dina Hess [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 12:31 PM
> To: CF-Talk
> Subject: Re: WOT: Access SQL Question - Round 2

> Matthew and Isaac have provided you with two excellent
> workarounds. I
> just have one thing to add.

> The "where pk=fk" syntax doesn't produce an inner join in
> Access.
> Instead use "from issues i inner join users u on i.owner =
> u.name".

> Too bad you have to go thru all of this...a normalized
> database schema
> would've prevented this problem...which you probably
> haven't seen the
> last of... :)

> ~Dina




> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Get the mailserver that powers this list at
> http://www.coolfusion.com

>   Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
>   ubscribe.cfm?user=633.558.4


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Calling a CFC from perl

[Brad Howerter]

Please ignore.  I've got problems with invoking this even from coldFusion, let alone 
perl.  I'll post a separate message for my CF web service problem.
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

UDF question -- make num a string

[Owens, Howard]

I'm trying to do a little UDF to convert something like .77809 to 78%

If I do something like:

outNum=finalResult + '%';

I get an error that says "cannot convert % to a number" ...

well, I don't want it to be a num. I want it to be a string.  I can't find a
way to get a string output in the return.

H.

~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Whats up with www.macromedia.com

[Scott Weikert]

>I was wondering is there anything wrong with macromedia's site.

Worked fine for me just now.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Whats up with www.macromedia.com

[Ciliotta, Mario]

Hi all,

I was wondering is there anything wrong with macromedia's site.  I cannot get thru 
with www.macromedia.com but if I use macromedia.com it works.  I was just wondering 
since a lot of the links on their site point to www.macromedia.com/showcase/.  Just 
get a 404 using this.

Just wondering whats up.

Mario

This message is for the named person's use only. It may contain sensitive and private 
proprietary or legally privileged information. No confidentiality or privilege is 
waived or lost by any mistransmission. If you are not the intended recipient, please 
immediately delete it and all copies of it from your system, destroy any hard copies 
of it and notify the sender. You must not, directly or indirectly, use, disclose, 
distribute, print, or copy any part of this message if you are not the intended 
recipient. CREDIT SUISSE GROUP and each legal entity in the CREDIT SUISSE FIRST BOSTON 
or CREDIT SUISSE ASSET MANAGEMENT business units of CREDIT SUISSE FIRST BOSTON reserve 
the right to monitor all e-mail communications through its networks. Any views 
expressed in this message are those of the individual sender, except where the message 
states otherwise and the sender is authorized to state them to be the views of any 
such entity.
Unless otherwise stated, any pricing information given in this message is indicative  
only, is subject to change and does not constitute an offer to deal at any price 
quoted. Any reference to the terms of executed transactions should be treated as  
preliminary only and subject to our formal written confirmation.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: StoredProc Error Num 3

[James Ang]

You should actually test your stored procedure as opposed to testing the
code in it. :P But I think you are right in suspecting that the problem
lies in CFML. Before you go hunt there though, try this in SQL Query
Analyzer (assuming that your stored proc is still called detail_story
and that the parameters have not changed):

DECLARE
@archive_id bigint,
@NB_ID char,
@COPYRIGHT varchar,
@PUB_DATE datetime,
@P_SECTION varchar,
@PAGE char OUTPUT,
@WORD_COUNT char,
@HEADLINE varchar,
@SUBHEAD varchar,
@LEDE varchar,
@STORY NTEXT

SET @archive_id = 2345

execute detail_story
@archive_id = @archive_id OUTPUT,
@NB_ID = @NB_ID OUTPUT,
@COPYRIGHT = @COPYRIGHT OUTPUT,
@PUB_DATE = @PUB_DATE OUTPUT,
@P_SECTION = @P_SECTION OUTPUT,
@PAGE = @PAGE OUTPUT,
@WORD_COUNT = @WORD_COUNT OUTPUT,
@HEADLINE = @HEADLINE OUTPUT,
@SUBHEAD = @SUBHEAD OUTPUT,
@LEDE = @LEDE OUTPUT,
@STORY = @STORY OUTPUT

PRINT 'Executed Query. Now lets see what happened to the variables'
PRINT '@archive_id = ' + @archive_id
PRINT '@NB_ID = ' + @NB_ID
PRINT '@COPYRIGHT = ' + @COPYRIGHT
PRINT '@PUB_DATE = ' + @PUB_DATE
PRINT '@P_SECTION = ' + @P_SECTION
PRINT '@PAGE = ' + @PAGE
PRINT '@WORD_COUNT = ' + @WORD_COUNT
PRINT '@HEADLINE = ' + @HEADLINE
PRINT '@SUBHEAD = ' + @SUBHEAD
PRINT '@LEDE = ' + @LEDE
PRINT '@STORY = ' + @STORY

Maybe this might shed some light? If not, the next debug thing to do is
to store the @ARCHIVE_ID that the stored proc received into a debug
table. Then query that table after you tested in CFML to see what values
were given to the stored proc by ColdFusion. Maybe it has to do with
VARCHAR to BIGINT conversion... :P


James Ang
Programmer
MedSeek, Inc.
[EMAIL PROTECTED]




-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 2:27 PM
To: CF-Talk
Subject: RE: StoredProc Error Num 3


Well, I'm getting no where fast ... and this is the last thing I need to
get
working, and then I have this application finished ... g

As I said previously, cfdump turns up a big blank.


I ran this test in query analyzer and it worked:

DECLARE @archive_id bigint

select @archive_id = 2345

SELECT  ARCHIVE_ID,
NB_ID,
COPYRIGHT,
PUB_DATE,
P_SECTION,
PAGE,
WORD_COUNT,
HEADLINE,
SUBHEAD,
LEDE,
STORY
FROM story_archive
WHERE  ARCHIVE_ID = @ARCHIVE_ID


So, I remain stumped.

H.



> -Original Message-
> From: James Ang [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 12:06 PM
> To:   CF-Talk
> Subject:  RE: StoredProc Error Num 3
> 
> When you said no rows, are you saying that:
> 
> 
> 
> Returns an empty query dump? Does the query even have any columns?
> 
> Judging from your stored procedure definition, those OUTPUT parameters
> are not needed since you never assign them any value. But if you do
need
> the output parameters, perhaps you meant to have:
> 
> SELECT  
>   @NB_ID = NB_ID,
>   @COPYRIGHT = COPYRIGHT,
>   @PUB_DATE = PUB_DATE,
>   @P_SECTION = P_SECTION,
>   @PAGE = PAGE,
>   @WORD_COUNT = WORD_COUNT,
>   @HEADLINE = HEADLINE,
>   @SUBHEAD = SUBHEAD,
>   @LEDE = LEDE,
>   @STORY = STORY
> FROM story_archive
> WHERE  ARCHIVE_ID = @ARCHIVE_ID
> 
> If you do the above, then: FULL_TEXT will definitely be empty, BUT all
> your  variables will be populated after the stored proc
> call.
> 
> And for future stored proc "bugs", you should test with SQL Query
> Analyzer first to make sure that your stored proc is working there. If
> it is, then the problem is in the CFML code. :) And nice thing about
> testing in SQL Query Analyzer is that you can use PRINT statements in
> your stored proc (which may or may not be deadly in a CFSTOREDPROC
call)
> to help you debug better. :)
> 
> 
> James Ang
> Programmer
> MedSeek, Inc.
> [EMAIL PROTECTED]
> 
> 
> 
> 
> 
> -Original Message-
> From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, January 17, 2003 11:13 AM
> To: CF-Talk
> Subject: RE: StoredProc Error Num 3
> 
> 
> I'm still pulling my hair out over this stored proc.
> 
> To recap, the variable archive_id does not seem to be getting passed
to
> the
> query ... so no rows (and 1 row should be returned) are being
returned.
> 
> Here's my cf tags:
> 
>datasource="#request.dsn#"
>   returncode="yes">
>   
> 
>   
>   cfsqltype="CF_SQL_VARC

Calling a CFC from perl

[Brad Howerter]

Has anyone called a CFC service from perl?  I've written a cfc that I can
use with a url:

http://webftc18/com/woodward/example.cfc?method=hi

But I can't get perl to access it, I always get 'SOAP call failed: 401
Access Denied at C:\Perl\bin\BTS.pl line 8'

My perl program is simply:

#!perl -w
use SOAP::Lite
proxy => 'http://webftc18/com/woodward/example.cfc',
uri => 'http://woodward.com/examples'
;

my $soap1 = new SOAP::Lite;
print $soap1->hi->result;



Here's my coldfusion CFC code:

  
 
  



If I call real world examples from my perl program (instead of the one I
wrote), it works okay.

***
The information in this e-mail is confidential and intended solely for the
individual or entity to whom it is addressed. If you have received this
e-mail in error please notify the sender by return e-mail, delete this
e-mail, and refrain from any disclosure or action based on the information.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: StoredProc Error Num 3

[Owens, Howard]

Well, I'm getting no where fast ... and this is the last thing I need to get
working, and then I have this application finished ... g

As I said previously, cfdump turns up a big blank.


I ran this test in query analyzer and it worked:

DECLARE @archive_id bigint

select @archive_id = 2345

SELECT  ARCHIVE_ID,
NB_ID,
COPYRIGHT,
PUB_DATE,
P_SECTION,
PAGE,
WORD_COUNT,
HEADLINE,
SUBHEAD,
LEDE,
STORY
FROM story_archive
WHERE  ARCHIVE_ID = @ARCHIVE_ID


So, I remain stumped.

H.



> -Original Message-
> From: James Ang [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 12:06 PM
> To:   CF-Talk
> Subject:  RE: StoredProc Error Num 3
> 
> When you said no rows, are you saying that:
> 
> 
> 
> Returns an empty query dump? Does the query even have any columns?
> 
> Judging from your stored procedure definition, those OUTPUT parameters
> are not needed since you never assign them any value. But if you do need
> the output parameters, perhaps you meant to have:
> 
> SELECT  
>   @NB_ID = NB_ID,
>   @COPYRIGHT = COPYRIGHT,
>   @PUB_DATE = PUB_DATE,
>   @P_SECTION = P_SECTION,
>   @PAGE = PAGE,
>   @WORD_COUNT = WORD_COUNT,
>   @HEADLINE = HEADLINE,
>   @SUBHEAD = SUBHEAD,
>   @LEDE = LEDE,
>   @STORY = STORY
> FROM story_archive
> WHERE  ARCHIVE_ID = @ARCHIVE_ID
> 
> If you do the above, then: FULL_TEXT will definitely be empty, BUT all
> your  variables will be populated after the stored proc
> call.
> 
> And for future stored proc "bugs", you should test with SQL Query
> Analyzer first to make sure that your stored proc is working there. If
> it is, then the problem is in the CFML code. :) And nice thing about
> testing in SQL Query Analyzer is that you can use PRINT statements in
> your stored proc (which may or may not be deadly in a CFSTOREDPROC call)
> to help you debug better. :)
> 
> 
> James Ang
> Programmer
> MedSeek, Inc.
> [EMAIL PROTECTED]
> 
> 
> 
> 
> 
> -Original Message-
> From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, January 17, 2003 11:13 AM
> To: CF-Talk
> Subject: RE: StoredProc Error Num 3
> 
> 
> I'm still pulling my hair out over this stored proc.
> 
> To recap, the variable archive_id does not seem to be getting passed to
> the
> query ... so no rows (and 1 row should be returned) are being returned.
> 
> Here's my cf tags:
> 
>datasource="#request.dsn#"
>   returncode="yes">
>   
> 
>   
>   cfsqltype="CF_SQL_VARCHAR"
>variable="ARCHIVE_ID"
>value="#URL.SID#"
>  null="yes">
>   
>cfsqltype="CF_SQL_CHAR"
>variable="NB_ID"
>  null="NO">
>   
>   cfsqltype="CF_SQL_VARCHAR"
>variable="COPYRIGHT"
>  null="NO">
>
>   cfsqltype="CF_SQL_TIMESTAMP"
>variable="PUB_DATE"
>  null="NO"> 
>
>   cfsqltype="CF_SQL_VARCHAR"
>variable="P_SECTION"
>  null="NO"> 
>
>cfsqltype="CF_SQL_CHAR"
>variable="PAGE"
>  null="NO"> 
>   
>cfsqltype="CF_SQL_CHAR"
>variable="WORD_COUNT"
>  null="NO"> 
>
>   cfsqltype="CF_SQL_VARCHAR"
>variable="HEADLINE"
>  null="NO">
> 
>   
>cfsqltype="CF_SQL_VARCHAR"
>variable="SUBHEAD"
>  null="NO"> 
>   
>cfsqltype="CF_SQL_VARCHAR"
>variable="LEDE"
>  null="NO"> 
>
>cfsqltype="CF_SQL_longVARCHAR"
>variable="STORY"
>  null="no">  
> 
>resultset="1">
> 
> 
> 
> 
> Here's my stored proc:
> 
> 
> 
> 
> CREATE PROCEDURE detail_story
> @ARCHIVE_ID bigint,
> @NB_ID char OUTPUT,
> @COPYRIGHT varchar OUTPUT,
> @PUB_DATE datetime OUTPUT,
> @P_SECTION varchar OUTPUT,
> @PAGE char OUTPUT,
> @WORD_COUNT char OUTPUT,
> @HEADLINE varchar OUTPUT,
> @SUBHEAD varchar OUTPUT,
> @LEDE varchar OUTPUT,
> @STORY NTEXT OUTPUT
> AS SELECT  ARCHIVE_ID,
>   NB_ID,
>   COPYRIGHT,
>   PUB_DATE,
>   P_SECTION,
>  

re cant access RDS server on XP

[Seamus Campbell]

Please ignore last message (below) - found the problem

 >Hi
 >I've just changed to a new computer with Window XP pro and get this 
message when trying to open local host >(from the database icon in the left 
resources window in Studio)
 >"Error occurred accessing the RDS server. The authentication failed."
 >If I try to open the rds://localhost folder under Allaire FTP & RDS 
folder in Windows Explorer I get this message:
 >"Unable to authenticate on RDS server using current security information."
 >I don't know where to change security/authentication - can anyone help, 
please.
 >Many thanks
 >Seamus


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: StoredProc Error Num 3

[Owens, Howard]

James,

Thanks ... yes cfdump is empty.

I did check things in query analyzer, but maybe not the right way ...

I'll take some clues from what you offer here and see if I can get things
figure out.

H.


> -Original Message-
> From: James Ang [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 12:06 PM
> To:   CF-Talk
> Subject:  RE: StoredProc Error Num 3
> 
> When you said no rows, are you saying that:
> 
> 
> 
> Returns an empty query dump? Does the query even have any columns?
> 
> Judging from your stored procedure definition, those OUTPUT parameters
> are not needed since you never assign them any value. But if you do need
> the output parameters, perhaps you meant to have:
> 
> SELECT  
>   @NB_ID = NB_ID,
>   @COPYRIGHT = COPYRIGHT,
>   @PUB_DATE = PUB_DATE,
>   @P_SECTION = P_SECTION,
>   @PAGE = PAGE,
>   @WORD_COUNT = WORD_COUNT,
>   @HEADLINE = HEADLINE,
>   @SUBHEAD = SUBHEAD,
>   @LEDE = LEDE,
>   @STORY = STORY
> FROM story_archive
> WHERE  ARCHIVE_ID = @ARCHIVE_ID
> 
> If you do the above, then: FULL_TEXT will definitely be empty, BUT all
> your  variables will be populated after the stored proc
> call.
> 
> And for future stored proc "bugs", you should test with SQL Query
> Analyzer first to make sure that your stored proc is working there. If
> it is, then the problem is in the CFML code. :) And nice thing about
> testing in SQL Query Analyzer is that you can use PRINT statements in
> your stored proc (which may or may not be deadly in a CFSTOREDPROC call)
> to help you debug better. :)
> 
> 
> James Ang
> Programmer
> MedSeek, Inc.
> [EMAIL PROTECTED]
> 
> 
> 
> 
> 
> -Original Message-
> From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
> Sent: Friday, January 17, 2003 11:13 AM
> To: CF-Talk
> Subject: RE: StoredProc Error Num 3
> 
> 
> I'm still pulling my hair out over this stored proc.
> 
> To recap, the variable archive_id does not seem to be getting passed to
> the
> query ... so no rows (and 1 row should be returned) are being returned.
> 
> Here's my cf tags:
> 
>datasource="#request.dsn#"
>   returncode="yes">
>   
> 
>   
>   cfsqltype="CF_SQL_VARCHAR"
>variable="ARCHIVE_ID"
>value="#URL.SID#"
>  null="yes">
>   
>cfsqltype="CF_SQL_CHAR"
>variable="NB_ID"
>  null="NO">
>   
>   cfsqltype="CF_SQL_VARCHAR"
>variable="COPYRIGHT"
>  null="NO">
>
>   cfsqltype="CF_SQL_TIMESTAMP"
>variable="PUB_DATE"
>  null="NO"> 
>
>   cfsqltype="CF_SQL_VARCHAR"
>variable="P_SECTION"
>  null="NO"> 
>
>cfsqltype="CF_SQL_CHAR"
>variable="PAGE"
>  null="NO"> 
>   
>cfsqltype="CF_SQL_CHAR"
>variable="WORD_COUNT"
>  null="NO"> 
>
>   cfsqltype="CF_SQL_VARCHAR"
>variable="HEADLINE"
>  null="NO">
> 
>   
>cfsqltype="CF_SQL_VARCHAR"
>variable="SUBHEAD"
>  null="NO"> 
>   
>cfsqltype="CF_SQL_VARCHAR"
>variable="LEDE"
>  null="NO"> 
>
>cfsqltype="CF_SQL_longVARCHAR"
>variable="STORY"
>  null="no">  
> 
>resultset="1">
> 
> 
> 
> 
> Here's my stored proc:
> 
> 
> 
> 
> CREATE PROCEDURE detail_story
> @ARCHIVE_ID bigint,
> @NB_ID char OUTPUT,
> @COPYRIGHT varchar OUTPUT,
> @PUB_DATE datetime OUTPUT,
> @P_SECTION varchar OUTPUT,
> @PAGE char OUTPUT,
> @WORD_COUNT char OUTPUT,
> @HEADLINE varchar OUTPUT,
> @SUBHEAD varchar OUTPUT,
> @LEDE varchar OUTPUT,
> @STORY NTEXT OUTPUT
> AS SELECT  ARCHIVE_ID,
>   NB_ID,
>   COPYRIGHT,
>   PUB_DATE,
>   P_SECTION,
>   PAGE,
>   WORD_COUNT,
>   HEADLINE,
>   SUBHEAD,
>   LEDE,
>   STORY
> FROM story_archive
> WHERE  ARCHIVE_ID = @ARCHIVE_ID
> GO
> 
> I even tried editing the stored proc to hardcode a variable @archive_id,
> and
> I still got no results returned.  But if I run the query in the SQL
> admin,
> runs fine ... returns results.
> 
> It's probably some stupid simple little error, but I can't see it.
> 
> 

SQL unique aggregate results

[steve]

But of course! The brilliant ones always make it look so simple. I think I tried 
nesting the query everywhere BUT in the 'FROM' line (I'm feeling rather foolish now). 
I did have to add username to the nested query's 'GROUP BY' clause but, other than 
that, it worked flawlessly.

Thanks Jochem!
Steve
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Last one, I think...

[Todd]

I think Sam found the problem.  I agree with Sam and I highly encourage 
people to format your SQL statement so you can see what you're  missing. ;)

UPDATE FTP
SET domain = ..,
   username = ..,
   password = ..,
   nocharge = ..,
   ..???... = ..,
WHERE id = ..

~Todd

At 08:33 PM 1/17/2003 +0100, you wrote:
>Ryan Mitchell wrote:
> > 
> > UPDATE FTP
> > SET domain = '#domains.id#', username = '#FORM.username#', password =
> > '#FORM.password#',  > value="#FORM.root#">, nocharge = '#FORM.nocharge#', anonymous =
> > #FORM.anonymous#
> > WHERE id = #url.id#
> > 
>
>Domain is a reserverd word in SQL. And use cfqueryparam.
>
>Jochem



--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

OT - APC Recall - just a heads up

[Nick McClure]

No need to reply, I just wanted to let people know.

APC is recalling two products. A 350 and a 500 Model, the will overheat
and melt the case, then cause a fire for more info:

http://www.apc.com/rely/index.cfm
http://www.apcc.com/rely/pressrel.cfm

It is a CF site :)

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: StoredProc Error Num 3

[James Ang]

When you said no rows, are you saying that:



Returns an empty query dump? Does the query even have any columns?

Judging from your stored procedure definition, those OUTPUT parameters
are not needed since you never assign them any value. But if you do need
the output parameters, perhaps you meant to have:

SELECT  
@NB_ID = NB_ID,
@COPYRIGHT = COPYRIGHT,
@PUB_DATE = PUB_DATE,
@P_SECTION = P_SECTION,
@PAGE = PAGE,
@WORD_COUNT = WORD_COUNT,
@HEADLINE = HEADLINE,
@SUBHEAD = SUBHEAD,
@LEDE = LEDE,
@STORY = STORY
FROM story_archive
WHERE  ARCHIVE_ID = @ARCHIVE_ID

If you do the above, then: FULL_TEXT will definitely be empty, BUT all
your  variables will be populated after the stored proc
call.

And for future stored proc "bugs", you should test with SQL Query
Analyzer first to make sure that your stored proc is working there. If
it is, then the problem is in the CFML code. :) And nice thing about
testing in SQL Query Analyzer is that you can use PRINT statements in
your stored proc (which may or may not be deadly in a CFSTOREDPROC call)
to help you debug better. :)


James Ang
Programmer
MedSeek, Inc.
[EMAIL PROTECTED]





-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 11:13 AM
To: CF-Talk
Subject: RE: StoredProc Error Num 3


I'm still pulling my hair out over this stored proc.

To recap, the variable archive_id does not seem to be getting passed to
the
query ... so no rows (and 1 row should be returned) are being returned.

Here's my cf tags:







 


 
 
 
 
 
  

  
 



  

  
 
   






Here's my stored proc:




CREATE PROCEDURE detail_story
@ARCHIVE_ID bigint,
@NB_ID char OUTPUT,
@COPYRIGHT varchar OUTPUT,
@PUB_DATE datetime OUTPUT,
@P_SECTION varchar OUTPUT,
@PAGE char OUTPUT,
@WORD_COUNT char OUTPUT,
@HEADLINE varchar OUTPUT,
@SUBHEAD varchar OUTPUT,
@LEDE varchar OUTPUT,
@STORY NTEXT OUTPUT
AS SELECT  ARCHIVE_ID,
NB_ID,
COPYRIGHT,
PUB_DATE,
P_SECTION,
PAGE,
WORD_COUNT,
HEADLINE,
SUBHEAD,
LEDE,
STORY
FROM story_archive
WHERE  ARCHIVE_ID = @ARCHIVE_ID
GO

I even tried editing the stored proc to hardcode a variable @archive_id,
and
I still got no results returned.  But if I run the query in the SQL
admin,
runs fine ... returns results.

It's probably some stupid simple little error, but I can't see it.

H.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Last one, I think...

[Jochem van Dieten]

Ryan Mitchell wrote:
> 
> UPDATE FTP
> SET domain = '#domains.id#', username = '#FORM.username#', password =
> '#FORM.password#',  value="#FORM.root#">, nocharge = '#FORM.nocharge#', anonymous =
> #FORM.anonymous#
> WHERE id = #url.id#
> 

Domain is a reserverd word in SQL. And use cfqueryparam.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Last one, I think...

[Ryan Kime]

I see your problem:

You are not setting your cfqueryparam to a field:
,, etc...

Should be like the others:
, root = ,

See it? You're missing the "something=" in front of the cfqueryparam

HTH,

Ryan Kime


-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 12:46 PM
To: CF-Talk
Subject: Last one, I think...


Ok, I've got a handle on this, and got rid of all but one error... Thanks
for all the help guys..


UPDATE FTP
SET domain = '#domains.id#', username = '#FORM.username#', password =
'#FORM.password#', , nocharge = '#FORM.nocharge#', anonymous =
#FORM.anonymous#
WHERE id = #url.id#


And I'm getting this error

Error Executing Database Query.

Syntax error or access violation: You have an error in your SQL syntax near
''c:\\webserver\\rthosting.net\\www\\boo', domain = '1'  WHERE ID =
5' at line 1 

I think the problem is the id = bit but I tried using tinyint etc and it
wont work, anyone else shed any light?

Ryan

 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Last one, I think...

[Samuel R. Neff]

There's an error in the directory field.  The very last set clause, with 
the query param, has a parameter but no field.  Reformatted this is easy to 
see:

UPDATE PPD
SET
 username = '#FORM.username#',
 password = '#FORM.password#',
 domain = '#domains.id#',
 
WHERE
 ID = #url.id#

There is no field on the cfqueryparam line.  I'd suggest formatting queries 
as above.

Also, cfqueryparam can also speed up your database calls.  Without 
cfqueryparam, cf sends these type of statements to the database:

UPDATE PPD SET username='user1', password='pass1', 
domain='domain1,  dir='dri1' WHERE id=1;
UPDATE PPD SET username='user2', password='pass2', 
domain='domain2,  dir='dri1' WHERE id=2;
UPDATE PPD SET username='user3', password='pass3', 
domain='domain3,  dir='dri1' WHERE id=3;

So the DB has to analyze each query and put together a query plan and 
execute the query.  The query plan generation is often most of time 
required to actually run a query.

By contrast, with cfqueryparam the database gets sql like this:

UPDATE PPD SET username=?, password=?, domain=?,  dir=? WHERE id=?;
UPDATE PPD SET username=?, password=?, domain=?,  dir=? WHERE id=?;
UPDATE PPD SET username=?, password=?, domain=?,  dir=? WHERE id=?;

with bind variables for each query.  The DB can reuse the query plan and 
only reexecutes the query with different values.

HTH,

Sam

At 02:13 PM 1/17/2003, you wrote:
>Not being mean, but how about doing yourself a favor and putting all the
> in there?  It'd save your time and ours.  With
>cfsqltype="..whatever.." being declared there's no mistake.
>
>~Todd
>
>At 07:09 PM 1/17/2003 +, you wrote:
> >Try this, same error different query...
> >
> >
> > 
> > UPDATE PPD
> > SET username = '#FORM.username#', password = '#FORM.password#', 
> domain =
> >'#domains.id#',  >value="#FORM.directory#">
> > WHERE ID = #url.id#
> > 
> >
> >Im only using the queryparam for the directory as it needs to have '\'s in
> >it, everything else works fine without them
> >
> >Username, password, domain, directory are all of type tinytext.
> >Id is of type tinyint(4).
> >
> >Ryan

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Obscure CFContent Problem

[Steve Robison, Jr.]

I am using cfcontent to throw documents to the browser from a non-web 
accessible directory.  I am using  cfheader as shown below to tell the 
browser what type of file it is.  So, it knows the file being downloaded is 
test.doc file instead of index.cfm.



All of this works for just about any file type except for the .dwf file 
format.  It is an Autocad file that stands for design web format.  It 
allows customers to view the drawings wiith a free Autocad program 
(Autodesk Express Viewer).

If the .dwf file is in the web directory, internet explorer opens it up 
properly.

If I try to open it with cfcontent, internet explorer displays a blank screen.

I'm assuming that this is because the Autodesk Express viewer disregards 
the header content-disposition.  Does any one have any idea on this?

Thanks,

Steve Robison, Jr.
[EMAIL PROTECTED]
Delaware.Net, Inc.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Large scale ColdFusion Case studies

[Timothy Heald]

Hi,
Anyone have any large scale case studies done on CF 5 and CFMX with benchmark 
information like number of requests, hardware architecture, clustering and such?

TIA

Timothy Heald
Assistant Webmaster
Overseas Security Advisory Council
U.S. Department of State 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Error occurred on line -1 ???

[Stephenie Hamilton]

Would this be on MX? I have seen this error lots on MX, check your
client.properties file and see if it is 0 k.


~~
Stephenie Hamilton
Macromedia Certified ColdFusion Professional
CFXHosting





-Original Message-
From: Joshua Miller [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 12:26 PM
To: CF-Talk
Subject: Error occurred on line -1 ???


Anyone else seen this error?
 
All of the error output is "null" and the error message says: "Error
occurred on line -1"
 
This happens when accessing a large amount of data in a query (88,878
records)
 
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net  
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 
**

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 1/10/2003
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WOT: Access SQL Question - Round 2

[Dina Hess]

While the recordsets produced by both of these queries are the same, the second query 
(with the ANSI join) performs *much* better. 

My simple test returned a recordset of only two records, yet the time on the first 
query was 135ms compared to only 15ms on the second query.


SELECT u.name
FROM issues i, users u
WHERE u.name = left(i.owner,len(u.name))





SELECT u.name
FROM issues i inner join users u on left(i.owner,len(u.name))= u.name





  I'm with you on this, Dave.  I think the existence of the join condition
  eliminates the Cartesian cross-product result.


  > In Access, if you use "FROM issues, owners WHERE issues.owner 
  > = users.name" you're doing a cartesian join, which produces 
  > every possible combination of the two tables. An inner join, 
  > on the other hand, will return only the rows that match your 
  > join condition.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: -OT- Javascript and lists

[Timothy Heald]

That's off a bit.

function testField(thisField){
myString = "o,b/o,s,h";

myArray = myString.split(",");

for(i = 0; i < myArray.length; i++){
if(thisField.value == myArray[i]){
break
}else

if(myArray.length == (i-1)){
alert('String not in list');
}

}
}

That should be closer.

-Original Message-
From: Timothy Heald 
Sent: Friday, January 17, 2003 2:04 PM
To: CF-Talk
Subject: RE: -OT- Javascript and lists


I would split the list into an array then loop through like so:

function testField(thisField){
myString = "o,b/o,s,h";

myArray = myString.split(",");

for(i = 0; i < myArray.length; i++){
if(thisField.value == myArray[i]){
break
}

alert('String not in list');
}
}


That should do something like it.

Tim
-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 1:55 PM
To: CF-Talk
Subject: -OT- Javascript and lists


How do I look through a list of strings in Javascript and compare each to a 
variable?  I'm trying to do the following:

Set up a list like this "O,B/O,S,H"

And then loop through and compare each the data in a form field and if the 
form field doesn't match any of the choices, have it throw an alert.

T



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: StoredProc Error Num 3

[Owens, Howard]

I'm still pulling my hair out over this stored proc.

To recap, the variable archive_id does not seem to be getting passed to the
query ... so no rows (and 1 row should be returned) are being returned.

Here's my cf tags:







 


 
 
 
 
 
  

  
 



  

  
 
   






Here's my stored proc:




CREATE PROCEDURE detail_story
@ARCHIVE_ID bigint,
@NB_ID char OUTPUT,
@COPYRIGHT varchar OUTPUT,
@PUB_DATE datetime OUTPUT,
@P_SECTION varchar OUTPUT,
@PAGE char OUTPUT,
@WORD_COUNT char OUTPUT,
@HEADLINE varchar OUTPUT,
@SUBHEAD varchar OUTPUT,
@LEDE varchar OUTPUT,
@STORY NTEXT OUTPUT
AS SELECT  ARCHIVE_ID,
NB_ID,
COPYRIGHT,
PUB_DATE,
P_SECTION,
PAGE,
WORD_COUNT,
HEADLINE,
SUBHEAD,
LEDE,
STORY
FROM story_archive
WHERE  ARCHIVE_ID = @ARCHIVE_ID
GO

I even tried editing the stored proc to hardcode a variable @archive_id, and
I still got no results returned.  But if I run the query in the SQL admin,
runs fine ... returns results.

It's probably some stupid simple little error, but I can't see it.

H.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Last one, I think...

[Todd]

Not being mean, but how about doing yourself a favor and putting all the 
 in there?  It'd save your time and ours.  With 
cfsqltype="..whatever.." being declared there's no mistake.

~Todd

At 07:09 PM 1/17/2003 +, you wrote:
>Try this, same error different query...
>
>
> 
> UPDATE PPD
> SET username = '#FORM.username#', password = '#FORM.password#', domain =
>'#domains.id#', value="#FORM.directory#">
> WHERE ID = #url.id#
> 
>
>Im only using the queryparam for the directory as it needs to have '\'s in
>it, everything else works fine without them
>
>Username, password, domain, directory are all of type tinytext.
>Id is of type tinyint(4).
>
>Ryan



--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: -OT- Javascript and lists

[ksuh]

Use the split() method.  This creates a array that you can loop through.

var list = "O,B/O,S,H";

var listArray = list.split(",");

- Original Message -
From: Thane Sherrington <[EMAIL PROTECTED]>
Date: Friday, January 17, 2003 11:54 am
Subject: -OT- Javascript and lists

> How do I look through a list of strings in Javascript and compare 
> each to a 
> variable?  I'm trying to do the following:
> 
> Set up a list like this "O,B/O,S,H"
> 
> And then loop through and compare each the data in a form field 
> and if the 
> form field doesn't match any of the choices, have it throw an alert.
> 
> T
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Code Audit, is there a better way?

[Robert Everland]

Here is the case, I have 6 queries that all need to be put together, I can't
do a join cause the previous year's data doesn't match this years and I have
to do somet logic. It's on an AS/400 so fancy SQL is not an option. Is this
the best way to do this, or is there a better way, short of changing it to
cfscript.


SELECT  SUM(CANTS) as NetSales,
trim(CAMCU) as CAMCU
FROMDIXCUST.FDCASLDL2
Where   1=1

AND CACO NOT IN ('00036','00071')
AND CAMCU IN ('HUN','VER')

AND CACO IN ('00071')

AND CACO IN ('00036')

GROUP   BY CAMCU

UNION
SELECT  SUM(CANTS) as NetSales, 
'OTHER' as CAMCU
FROMDIXCUST.FDCASLDL2
Where   1=1
AND CACO NOT IN ('00036','00071')
AND CAMCU not IN ('HUN','VER')
Order by CAMCU




SELECT  SUM(CANTS) as NetSales,
trim(CAMCU) as CAMCU
FROMDIXCUST.FDCASLSL2
Where   1=1

AND CACO IN ('00030', '00032')
AND CACO NOT IN ('00036','00071')
AND CAMCU <> 'RTN'

AND CACO IN ('00071')

AND CACO IN ('00036')

and CADAT = 1#dateformat(createdate(2002,  datepart("m",
now()),  datepart("d", now())), "YYMMDD")#
GROUP   BY CACO,CAMCU

UNION
SELECT  SUM(CANTS) as NetSales, 'OTHER' as CAMCU
FROMDIXCUST.FDCASLSL2
Where   1=1
AND CACO NOT IN ('00030', '00032','00036','00071')
and CADAT = 1#dateformat(createdate(2002,  datepart("m",
now()),  datepart("d", now())), "YYMMDD")#
Order by CAMCU

 



SELECT  SUM(CANTS) as NetSales,
trim(CAMCU) as CAMCU
FROMDIXCUST.FDCASLSL2
Where   1=1

AND CACO IN ('00030', '00032')
AND CACO NOT IN ('00036','00071')
AND CAMCU <> 'RTN'

AND CACO IN ('00071')

AND CACO IN ('00036')

and CADAT between 1#dateformat(createdate(2001,  10,
1), "YYMMDD")# and 1#dateformat(createdate(2002,  9,  30), "YYMMDD")#
GROUP   BY CAMCU

UNION
SELECT  SUM(CANTS) as NetSales, 
'OTHER' as CAMCU
FROMDIXCUST.FDCASLSL2
Where   1=1
AND CACO NOT IN ('00030', '00032','00036','00071')
and CADAT between 1#dateformat(createdate(2001,  10,
1), "YYMMDD")# and 1#dateformat(createdate(2002,  9,  30), "YYMMDD")#
Order by CAMCU





SELECT  SUM(CANTS) as NetSales,
trim(CAMCU) as CAMCU
FROMDIXCUST.FDCASLSL2
Where   1=1

AND CACO NOT IN ('00036','00071')
AND CAMCU IN ('HUN','VER')

AND CACO IN ('00071')

AND CACO IN ('00036')

and CADAT >= 1#dateformat(createdate(2002,  10,  1),
"YYMMDD")#
GROUP   BY CAMCU

UNION
SELECT  SUM(CANTS) as NetSales, 'OTHER' as CAMCU
FROMDIXCUST.FDCASLSL2
Where   1=1
AND CACO NOT IN ('00036','00071')
AND CAMCU not IN ('HUN','VER')
and CADAT >= 1#dateformat(createdate(2002,  10,  1),
"YYMMDD")#
Order by CAMCU




SELECT  SUM(CANTS) as NetSales,
trim(CAMCU) as CAMCU
FROMDIXCUST.FDCASLSL2
Where   1=1

AND CACO IN ('00030', '00032')
AND CACO NOT IN ('00036','00071')
AND CAMCU <> 'RTN'

AND CACO IN ('00071')

AND CACO IN ('00036')

and CADAT between
1#dateformat(createdate(datepart("",dateadd("",  -1, now())),
datepart("m",now()),  1), "YYMMDD")# and
1#dateformat(createdate(datepart("",dateadd("",  -1, now())),
datepart("m",now()),  DaysInMonth(now())), "YYMMDD")#
GROUP   BY CAMCU

UNION
SELECT  SUM(CANTS) as NetSales, 'OTHER' as CAMCU
FROMDIXCUST.FDCASLSL2
Where   1=1
AND CACO NOT IN ('00030', '00032','00036','00071')
and CADAT between
1#dateformat(createdate(datepart("",dateadd("",  -1, now())),
datepart("m",now()),  1), "YYMMDD")# and
1#dateformat(createdate(datepart("",dateadd("",  -1, now())),
datepart("m",now()),  DaysInMonth(now())), "YYMMDD")#
Order by CAMCU





SELECT  SUM(CANTS) as NetSales,
trim(CAMCU) as CAMCU
FROMDIXCUST.FDCASLSL2
  

Re: Last one, I think...

[Ryan Mitchell]

Try this, same error different query...



UPDATE PPD
SET username = '#FORM.username#', password = '#FORM.password#', domain =
'#domains.id#', 
WHERE ID = #url.id#


Im only using the queryparam for the directory as it needs to have '\'s in
it, everything else works fine without them

Username, password, domain, directory are all of type tinytext.
Id is of type tinyint(4).

Ryan

On 17/1/03 19:01, "Todd" <[EMAIL PROTECTED]> wrote:

> anonymous = #FORM.anonymous# ..?
> 
> anonymous = '#FORM.anonymous#' ?
> 
> Without seeing the data types of the column I can sit and guess all
> day.  Why are you mixing / matching CFQUERYPARAMs?  Why do you have one
> there, but you don't have the others in there?
> 
> ~Todd
> 
> At 06:56 PM 1/17/2003 +, you wrote:
>> Nope fraid not, the field is a text field intentionally :)
>> 
>> Any other thoughts?
>> 
>> On 17/1/03 18:50, "Todd" <[EMAIL PROTECTED]> wrote:
>> 
>>> Domain = '#domains.id#'
>>> 
>>> Should be:
>>> 
>>> Domain = #domain.id#
>>> 
>>> No single quotes around integers.
>>> 
>>> ~Todd
> 
> 
> 
> --
> Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
> Team Macromedia Volunteer for ColdFusion
> http://www.macromedia.com/support/forums/team_macromedia/
> http://www.devmx.com/
> 
> --
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Best way to store 40 values?

[Frank Mamone]

There's an interesting article in CFDJ Oct 2002 page 40 by Tom Nunamaker
which has an innovative way of storing checkbox selections using integers.

I'm not sure if it will help your basic problem but definately worth the
read.

Frank


- Original Message -
From: "Owens, Howard" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 17, 2003 11:39 AM
Subject: RE: Best way to store 40 values?


> Ah, what the hell ... I'll weigh ... besides ... I've done this -- this
> exact thing.
>
> I assume with  10,000 songs to choose from, what you want to create is
some
> sort of shopping cart.
>
> Users will want to browse by Artist, Song Title, Song Style, at least.
> Users will also want to be able to search.  You're not going to be able to
> serve up all 10,000 songs on a single page and just have them go through
> check boxes.
>
> Each hitlist page (either through browse or search) will list the songs --
> there are two options on how songs get added to the cart ... either the
user
> clicks a button or checkbox and it's immediately added to the cart; or the
> user checks the checkboxes and then scrolls to the bottom (or top) of the
> page and clicks a "add selected items to cart" button.
>
> The cart is an array of structures stored in either session variables or
in
> WDDX and then the WDDX package is stored in a client variable (my
> preference, but then I usually work on clustered servers).
>
> At insert, checkout, I prefer the table method recommended by others
> (user_id,song_id).  This gives more flexibility in a number of ways, such
as
> reporting (as mentioned previously).
>
> H.
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: -OT- Javascript and lists

[Timothy Heald]

I would split the list into an array then loop through like so:

function testField(thisField){
myString = "o,b/o,s,h";

myArray = myString.split(",");

for(i = 0; i < myArray.length; i++){
if(thisField.value == myArray[i]){
break
}

alert('String not in list');
}
}


That should do something like it.

Tim
-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 1:55 PM
To: CF-Talk
Subject: -OT- Javascript and lists


How do I look through a list of strings in Javascript and compare each to a 
variable?  I'm trying to do the following:

Set up a list like this "O,B/O,S,H"

And then loop through and compare each the data in a form field and if the 
form field doesn't match any of the choices, have it throw an alert.

T


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Last one, I think...

[Todd]

anonymous = #FORM.anonymous# ..?

anonymous = '#FORM.anonymous#' ?

Without seeing the data types of the column I can sit and guess all 
day.  Why are you mixing / matching CFQUERYPARAMs?  Why do you have one 
there, but you don't have the others in there?

~Todd

At 06:56 PM 1/17/2003 +, you wrote:
>Nope fraid not, the field is a text field intentionally :)
>
>Any other thoughts?
>
>On 17/1/03 18:50, "Todd" <[EMAIL PROTECTED]> wrote:
>
> > Domain = '#domains.id#'
> >
> > Should be:
> >
> > Domain = #domain.id#
> >
> > No single quotes around integers.
> >
> > ~Todd



--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

-OT- Javascript and lists

[Thane Sherrington]

How do I look through a list of strings in Javascript and compare each to a 
variable?  I'm trying to do the following:

Set up a list like this "O,B/O,S,H"

And then loop through and compare each the data in a form field and if the 
form field doesn't match any of the choices, have it throw an alert.

T

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Last one, I think...

[Ryan Mitchell]

Nope fraid not, the field is a text field intentionally :)

Any other thoughts?

On 17/1/03 18:50, "Todd" <[EMAIL PROTECTED]> wrote:

> Domain = '#domains.id#'
> 
> Should be:
> 
> Domain = #domain.id#
> 
> No single quotes around integers.
> 
> ~Todd
> 
> At 06:46 PM 1/17/2003 +, you wrote:
>> Ok, I've got a handle on this, and got rid of all but one error... Thanks
>> for all the help guys..
>> 
>> 
>> UPDATE FTP
>> SET domain = '#domains.id#', username = '#FORM.username#', password =
>> '#FORM.password#', > value="#FORM.root#">, nocharge = '#FORM.nocharge#', anonymous =
>> #FORM.anonymous#
>> WHERE id = #url.id#
>> 
>> 
>> And I'm getting this error
>> 
>> Error Executing Database Query.
>> 
>> Syntax error or access violation: You have an error in your SQL syntax near
>> ''c:\\webserver\\rthosting.net\\www\\boo', domain = '1'  WHERE ID =
>> 5' at line 1
> 
> 
> 
> --
> Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
> Team Macromedia Volunteer for ColdFusion
> http://www.macromedia.com/support/forums/team_macromedia/
> http://www.devmx.com/
> 
> --
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Last one, I think...

[Todd]

Domain = '#domains.id#'

Should be:

Domain = #domain.id#

No single quotes around integers.

~Todd

At 06:46 PM 1/17/2003 +, you wrote:
>Ok, I've got a handle on this, and got rid of all but one error... Thanks
>for all the help guys..
>
>
> UPDATE FTP
> SET domain = '#domains.id#', username = '#FORM.username#', password =
>'#FORM.password#', value="#FORM.root#">, nocharge = '#FORM.nocharge#', anonymous =
>#FORM.anonymous#
> WHERE id = #url.id#
>
>
>And I'm getting this error
>
>Error Executing Database Query.
>
>Syntax error or access violation: You have an error in your SQL syntax near
>''c:\\webserver\\rthosting.net\\www\\boo', domain = '1'  WHERE ID =
>5' at line 1



--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Last one, I think...

[Ryan Mitchell]

Ok, I've got a handle on this, and got rid of all but one error... Thanks
for all the help guys..


UPDATE FTP
SET domain = '#domains.id#', username = '#FORM.username#', password =
'#FORM.password#', , nocharge = '#FORM.nocharge#', anonymous =
#FORM.anonymous#
WHERE id = #url.id#


And I'm getting this error

Error Executing Database Query.

Syntax error or access violation: You have an error in your SQL syntax near
''c:\\webserver\\rthosting.net\\www\\boo', domain = '1'  WHERE ID =
5' at line 1 

I think the problem is the id = bit but I tried using tinyint etc and it
wont work, anyone else shed any light?

Ryan

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Visual Fusion - Thoughts?

[Adrocknaphobia Jones]

Alright, I think we have some fundamental differences on artistic
integrity.
2-week-websites are definitely not my bag. I guess it's the old adage of
quality vs. quantity. I'd rather develop 1 site for 9k, rather than work
on 9 sites for 1k, in the same time span.

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division


-Original Message-
From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, January 16, 2003 5:14 PM
To: CF-Talk
Subject: RE: Visual Fusion - Thoughts?

At 01:52 PM 1/16/03 -0500, you wrote:
>If they can't afford a server... what makes you think they will pay $75
>an hour + hosting?


Ahhh  the trick is, over the past five years I've developed a
proprietary 
system that I use to generate 60% to 80% of the sites I build on the fly
so 
I don't have to do all the tedious labor - that lets me focus all my
energy 
on the purely customized aspects of a client site so I can get it done
in 
60 to 80% less time than typical - and so I can get the rate I get for
the 
same work that would take someone else twice as long to do the same job.

Just this week I had a prospective client say he was leaning toward a 
competitor who said they would put extra programmers on the job to get
it 
done in three weeks and I said - not to worry - we don't need to put
extra 
programmers on the job and we guarantee in the contract that we'll
deliver 
it in two weeks.He liked that better.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WOT: Access SQL Question - Round 2

[Dina Hess]

>Admittedly, I don't use Access that often, but that hasn't been my
>experience. My experience has been that Access will treat non-ANSI joins as
>described above as inner joins, at least with regard to passthrough SQL
>statements from CF.

I just tried Matthew's query in Access and it worked just fine. So...my apologies, 
Matthew, for misleading you and thank you, Dave, for sharing the wisdom of your 
experience. :)

~Dina





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Obscure Dateformat Question

[Tony Weeg]

but actually, im not sure that this is the case with this one...

cause I know that1042761600 = today (Jan 17 2003 00:00:00.000) in
epoch time, but
when I do this

#DateFormat(1042761600,'mm/dd/')#

I get, 04/14/2856884 which is definitely not right.

so, im not sure what he was talking about with this

" Ok, This is true: dateformat("1092117600") = 04-Jun-16 "

cause when I run that, I get the same thing, but that's not what it
looks
like...that actually saying...06/04/2992016 without the formatting, im
not 
sure...who knows, but what I do know, is that 1042761600 is the epoch
time
representation of Today @ midnight :)

ENJOYING THE SNOW!!

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 1:24 PM
To: CF-Talk
Subject: RE: Obscure Dateformat Question


Yeah left that out

Epoch time = "Unix time"... but epoch is the more correct name.

WG


> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 18:16
> To: CF-Talk
> Subject: RE: Obscure Dateformat Question
>
>
> no its actually called epoch time.
>
> its simply seconds since jan 1 1970 @ midnight.
>
> very nice to use, fits as a long int (until 2029 I think)
> and is good to index as a timeId for our app :)
>
> ...tony
>
> Tony Weeg
> Senior Web Developer
> UnCertified Advanced ColdFusion Developer
> Information System Design
> Navtrak, Inc.
> Mobile workforce monitoring, mapping & reporting
> www.navtrak.net
> 410.548.2337
>
> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 1:10 PM
> To: CF-Talk
> Subject: RE: Obscure Dateformat Question
>
>
> Is that unix time ?
>
> 1092117600 = second since midnight 1/1/1970 UTC (GMT).
>
> WG
>
> > -Original Message-
> > From: Willy Ray [mailto:[EMAIL PROTECTED]]
> > Sent: 17 January 2003 18:00
> > To: CF-Talk
> > Subject: Obscure Dateformat Question
> >
> >
> > Ok, This is true: dateformat("1092117600") = 04-Jun-16
> >
> > What I need to do is take 04-Jun-16 and turn it into 1092117600.  I
> can
> > go one direction, but I'm not sure how to go back... Some special
mask
> > for Dateformat that I don't know, or what?  If I could get the
> > algorythm, I'd make a UDF for it...
> >
> > Thanks in advance,
> >
> > Willy
> >
> >
> >
> >
> >
> > -
> > Willy Ray
> > Web Applications Developer
> > Certified Advanced ColdFusion Developer
> > Westminster College
> >
>
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Obscure Dateformat Question

[webguy]

Yeah left that out

Epoch time = "Unix time"... but epoch is the more correct name.

WG


> -Original Message-
> From: Tony Weeg [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 18:16
> To: CF-Talk
> Subject: RE: Obscure Dateformat Question
>
>
> no its actually called epoch time.
>
> its simply seconds since jan 1 1970 @ midnight.
>
> very nice to use, fits as a long int (until 2029 I think)
> and is good to index as a timeId for our app :)
>
> ...tony
>
> Tony Weeg
> Senior Web Developer
> UnCertified Advanced ColdFusion Developer
> Information System Design
> Navtrak, Inc.
> Mobile workforce monitoring, mapping & reporting
> www.navtrak.net
> 410.548.2337
>
> -Original Message-
> From: webguy [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 1:10 PM
> To: CF-Talk
> Subject: RE: Obscure Dateformat Question
>
>
> Is that unix time ?
>
> 1092117600 = second since midnight 1/1/1970 UTC (GMT).
>
> WG
>
> > -Original Message-
> > From: Willy Ray [mailto:[EMAIL PROTECTED]]
> > Sent: 17 January 2003 18:00
> > To: CF-Talk
> > Subject: Obscure Dateformat Question
> >
> >
> > Ok, This is true: dateformat("1092117600") = 04-Jun-16
> >
> > What I need to do is take 04-Jun-16 and turn it into 1092117600.  I
> can
> > go one direction, but I'm not sure how to go back... Some special mask
> > for Dateformat that I don't know, or what?  If I could get the
> > algorythm, I'd make a UDF for it...
> >
> > Thanks in advance,
> >
> > Willy
> >
> >
> >
> >
> >
> > -
> > Willy Ray
> > Web Applications Developer
> > Certified Advanced ColdFusion Developer
> > Westminster College
> >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: WOT: Access SQL Question - Round 2

[webguy]

No, I agree! Just saying that it's always better to fix the underlying
problem (i.e. the db design) than coding around it.

The metaphor "Fix broken windows" refer to the idea, that if you leave even
small bits of bad code in your code base, it spreads to other code. Better
to bite the bullet and fix the DB design

*apparently this comes from a study, that showed, if a broken window in
housing block is left unrepaired, that occupants start to disrespect the
property and that broken window leads to further problems*

WG

> -Original Message-
> From: Dina Hess [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 18:06
> To: CF-Talk
> Subject: Re: WOT: Access SQL Question - Round 2
>
>
> I'm not too sure what you're getting at...maybe I wasn't clear.
>
> My point was that a list of values should not be stored in a DB
> field. This is a basic criterion of a normalized database. It
> tends to become increasingly difficult to work with such databases.
>
>
>   > Too bad you have to go thru all of this...a normalized database
>   > schema would've prevented this problem...which you probably
>   > haven't seen the last of... :)
>   >
>   > ~Dina
>
>   Ouch! Database - Refactoring 101
>   http://www.agiledata.org/essays/databaseRefactoring.html
>
>   Always fix broken windows...
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: WOT: Access SQL Question - Round 2

[Matthew Small]

I'm with you on this, Dave.  I think the existence of the join condition
eliminates the Cartesian cross-product result.

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 1:16 PM
To: CF-Talk
Subject: RE: WOT: Access SQL Question - Round 2

> In Access, if you use "FROM issues, owners WHERE issues.owner 
> = users.name" you're doing a cartesian join, which produces 
> every possible combination of the two tables. An inner join, 
> on the other hand, will return only the rows that match your 
> join condition.

Admittedly, I don't use Access that often, but that hasn't been my
experience. My experience has been that Access will treat non-ANSI joins
as
described above as inner joins, at least with regard to passthrough SQL
statements from CF.

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFMX and CFForms

[Dave Watts]

> Here is a question; I use a CFFORM with the CFINPUTS 
> to validate the required fields, simple, right? Well, 
> not for this host, it does not validate at all! This 
> is the page that is in question:
> 
> http://www.tennisjobs.com/affiliates/new_affiliate.cfm
> 
> 
> This is the response to my question about why this is 
> not working from the hosting company:
> 
> " The only issue I could see regarding the CFFORM problem 
> would be that you need a CFIDE Mapping"
> 
> Have any of you ever heard of this? I mean I have never 
> had CFFORM not work for simple required fields in CFINPUT.

Yes, as others have mentioned, the client will need to be able to fetch the
script file from /CFIDE/scripts for any validation to work. In addition, I'm
pretty sure that this is new in CFMX; in previous versions, all of the
validation code was dropped directly in the page with the CFFORM tag. So, as
a result, the validation code will no longer work on Netscape 2! (Or is it
Netscape 3 - I forget which one introduced the SRC attribute for the SCRIPT
tag?)

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Obscure Dateformat Question

[Tony Weeg]

no its actually called epoch time.

its simply seconds since jan 1 1970 @ midnight.

very nice to use, fits as a long int (until 2029 I think)
and is good to index as a timeId for our app :)

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: webguy [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 1:10 PM
To: CF-Talk
Subject: RE: Obscure Dateformat Question


Is that unix time ?

1092117600 = second since midnight 1/1/1970 UTC (GMT).

WG

> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 18:00
> To: CF-Talk
> Subject: Obscure Dateformat Question
>
>
> Ok, This is true: dateformat("1092117600") = 04-Jun-16
>
> What I need to do is take 04-Jun-16 and turn it into 1092117600.  I
can
> go one direction, but I'm not sure how to go back... Some special mask
> for Dateformat that I don't know, or what?  If I could get the
> algorythm, I'd make a UDF for it...
>
> Thanks in advance,
>
> Willy
>
>
>
>
>
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Is CF 5 Pro still available for purchase?

[Dave Watts]

> That sure does the excitement out of winning Studio 
> MX or a CFMX Server at a User Group raffle.

If it makes you feel any better, I'm pretty sure that at the users' groups
that we sponsor, regular (as opposed to NFR) versions of CFMX and Studio MX
are raffled off occasionally.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Possible to name Application, save name, then rename Application?

[Rick Faircloth]

Hi, Jeremy.  Thanks for your reply.

GoDaddy.com provides DNS service for me...I don't use the "advanced
management option", which I think is what you're speaking of when you
wrote...

"set the "A record" to your static IP and you would be set
 (outside of IIS and/or router settings on your side)."

I've tried to make sense of the DNS stuff on my Win 2000 Server,
but haven't been able to sort it out.  I couldn't find enought "starter"
info,
to get me on the right track, so I just gave up on it, not even knowing if I
needed
that unless I was handling all my DNS internally, i.e., using my server as a
DNS server.
Couldn't sort out the "Forward Lookup Zones" and "Reverse Lookup Zones" and
determine how, and if, that applied to what I was doing with having my
domains
masked and forwarded.  That was just one less thing for me to figure out at
the time...
When I first set up the server I needed to get the site back online
quickly...they had
been down for 3 weeks due to lack of cooperation from a local ISP who was
dragging
his feet about getting my co-located server back online...finally I'd had
enough and
just bought a business DSL line and have never looked back.  I've always
wanted to know
more about handling my own DNS, but just never had the time or info on the
level I needed it.

How would the "Advanced DNS Management" your speaking of impact my situation
now?
If I set up "C-Names" at GoDaddy.com or UltraDomains.com, or even on my
server,
would that allow me to forward to actual domain names instead of
http://000.111.222.333/cfdocs//indexcfm ?

Final question, is there a "...for Dummies" book that helps the unintiated
make sense of all this?

Thanks for your time and help.

Rick



-Original Message-
From: Jeremy Bruck [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 11:43 AM
To: CF-Talk
Subject: RE: Possible to name Application, save name, then rename
Application?


Rick,

The best solution is to have a DNS server.  We just found out about
UltraDomains.com -- http://www.ultradomains.com.  They will let you cheaply
register/transfer a domain and they will also let you host/set your "A
records" and "mx records" in their DNS server for NO extra charge.  Many of
us that host sites on our own "DSL/Cable Servers" are very impressed with
the site.

So you could register/transfer the domain to them, and set the "A record" to
your static IP and you would be set (outside of IIS and/or router settings
on your side).

They will even let you set sub-domains on the fly.

This is a very cool site -- No I don't work for them or get paid anything.
I am truly impressed that they have cheap costs for buying domains and
include DNS hosting as a part of it -- the way all will go sooner or later.

Jeremy

Jeremy Bruck, VP of Technology
::MfgQuote
2690 Cumberland Parkway SE
Suite 510
Atlanta, GA  30339
TEL:   678.556.2929
FAX:  678.556.2980
www.mfgquote.com
[EMAIL PROTECTED]


-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 1:52 AM
To: CF-Talk
Subject: Possible to name Application, save name, then rename
Application?


I know that makes no sense, but here's what's happening.

I'm name a site that serves as a dynamic site for multiple companies.
I need to name the Application and set variables by the CGI.HTTP_Referer
variable.
No problem so far.

However, since the site is blind forwarded to my server, the HTTP_Referer
variable
changes once it's working off my server.  When it comes from the company
that
handles my DNS, it comes as http://www.bodafordhomes.com, from which I can
do a CFIF CGI.HTTP_Referer contains ".com" and that tells me that the
homepage
has been requested from somewhere besides my server and the ID of the
company
needs to be determined for the dynamic site to be setup.  I have
http://www.bodafordhomes.com
stored in the database from which to ID the company and choose it's data.

The problem comes when the pages are served from my server.  They use URL's
like http://77.88.99.00/cfdocs/rea/index.cfm , so the new CGI.HTTP_Referer
can't
be used to determine company ID any longer and the Application can't user
the CGI.HTTP_Referer
any longer as a name, because the Application name has to stay the same to
keep the variables
tied to the Application...

I need to store the first CGI.HTTP_Referer variable, then when the
Application.cfm
page is consulted, I can recall that saved original HTTP_Referer variable as
some other
variable and rename the Application.cfm with it.

There's the question:  How to save that variable, since I can't use
application or session
variables because on the second trip to the Application.cfm page, the
Application will
not have been defined and therefore an error occurs.

Is there some variable that can be created after the first Application is
named, then
continue to be used until the Application is renamed?

(I have got to learn how to do my own DNS, then I probably wouldn't have
this problem.
But I only have one s

RE: Sports XML Feed

[Erik Yowell]

Moreover has started checking sites these days and comparing them to
their terms and conditions. If your site has any commercial interest
what so ever they're going to charge you... something like $3k
annually... It's free for personal and non-profit use though.

Erik Yowell
[EMAIL PROTECTED]
http://www.shortfusemedia.com


-Original Message-
From: Rich Wild [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, January 15, 2003 8:53 AM
To: CF-Talk
Subject: RE: Sports XML Feed

nope.


> -Original Message-
> From: Raymond Camden [mailto:[EMAIL PROTECTED]]
> Sent: 15 January 2003 16:50
> To: CF-Talk
> Subject: RE: Sports XML Feed
> 
> 
> Last I heard moreover stopped giving away free content - is 
> that right?
> 
> ==
> =
> Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
> 
> Email: [EMAIL PROTECTED]
> WWW  : www.camdenfamily.com/morpheus
> Yahoo IM : morpheus
> 
> "My ally is the Force, and a powerful ally it is." - Yoda 
> 
> > -Original Message-
> > From: Joshua Miller 
> [mailto:[EMAIL PROTECTED]] 
> > Sent: Wednesday, January 15, 2003 10:46 AM
> > To: CF-Talk
> > Subject: RE: Sports XML Feed
> > 
> > 
> > Moreover.com has XML/RDF/WDDX feeds ... Or used to anyway, 
> > haven't used it in a while.
> > 
> 
> 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: WOT: Access SQL Question - Round 2

[Dave Watts]

> In Access, if you use "FROM issues, owners WHERE issues.owner 
> = users.name" you're doing a cartesian join, which produces 
> every possible combination of the two tables. An inner join, 
> on the other hand, will return only the rows that match your 
> join condition.

Admittedly, I don't use Access that often, but that hasn't been my
experience. My experience has been that Access will treat non-ANSI joins as
described above as inner joins, at least with regard to passthrough SQL
statements from CF.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WOT: Access SQL Question - Round 2

[Jeff Chastain]

Isacc's solution gives me what I need - thanks for all the input.

I won't get into the debate about Access vs. SQL.  However, Access does have an 
advantage over SQL in small, light use, cases ($$$), but a well designed DB is much 
easier to deal with, no matter what system it is in.

Thanks
-- Jeff

-- Original Message --
From: S. Isaac Dealey <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Fri, 17 Jan 2003 12:06:30 -0500

>Getting Access to do those sorts of things is always hideously difficult. If
>you really need to stick with a single query, you can use a view -- iirc
>Access calls them Queries. The view would include all the data from the
>issues table, with the owner column modified as such
>
>SELECT *, left(owner + ',', inStr(owner,',')-1) as ownername FROM issues
>
>then in your cf query you would be able to use a normal join on that added
>column to the users.name column.
>
>SELECT * FROM v_issues, users
>WHERE v_issues.ownername = users.name
>
>s. isaac dealey954-776-0046
>
>new epoch  http://www.turnkey.to
>
>lead architect, tapestry cms   http://products.turnkey.to
>
>tapestry api is opensource http://www.turnkey.to/tapi
>
>certified advanced coldfusion 5 developer
>http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
>
>> Okay, I am still having problems with this ... so here is
>> an attempt to
>> simplify the problem.
>
>> I have a hand-me-down Access database which I am trying to
>> get some data
>> out of.
>
>> I have a table called issues with a field called owner.
>> The owner field
>> may contain a single name, or it may contain a
>> comma-separated list of
>> names.
>
>> I have a table called users with a field called name.  I
>> am needing to
>> join the two tables up based on the first or only name in
>> the
>> issues.owner field matched to the users.name field.
>
>> Whenever I try using inStr in the WHERE clause, access
>> throws an invalid
>> procedure error.  Anybody got any suggestions?
>
>> This does not seem to work with Access and even if it did,
>> it would only
>> work for records with a list of users in the issues table,
>> not just a
>> single entry 
>
>> SELECT *
>> FROM issues, users
>> WHERE left(issues.owner, inStr(issues.owner, ',')-1) =
>> users.name
>
>
>> Thanks
>> -- Jeff
>
>> ~~
>> ~~~|
>> Archives:
>> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
>> Subscription: http://www.houseoffusion.com/cf_lists/index.
>> cfm?method=subscribe&forumid=4
>> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>> Your ad could be here. Monies from ads go to support these
>> lists and provide more resources for the community.
>> http://www.fusionauthority.com/ads.cfm
>
>>  Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
>>  ubscribe.cfm?user=633.558.4
>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Obscure Dateformat Question

[webguy]

Is that unix time ?

1092117600 = second since midnight 1/1/1970 UTC (GMT).

WG

> -Original Message-
> From: Willy Ray [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 18:00
> To: CF-Talk
> Subject: Obscure Dateformat Question
>
>
> Ok, This is true: dateformat("1092117600") = 04-Jun-16
>
> What I need to do is take 04-Jun-16 and turn it into 1092117600.  I can
> go one direction, but I'm not sure how to go back... Some special mask
> for Dateformat that I don't know, or what?  If I could get the
> algorythm, I'd make a UDF for it...
>
> Thanks in advance,
>
> Willy
>
>
>
>
>
> -
> Willy Ray
> Web Applications Developer
> Certified Advanced ColdFusion Developer
> Westminster College
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WOT: Access SQL Question - Round 2

[Dina Hess]

I'm not too sure what you're getting at...maybe I wasn't clear.

My point was that a list of values should not be stored in a DB field. This is a basic 
criterion of a normalized database. It tends to become increasingly difficult to work 
with such databases.


  > Too bad you have to go thru all of this...a normalized database 
  > schema would've prevented this problem...which you probably 
  > haven't seen the last of... :)
  > 
  > ~Dina

  Ouch! Database - Refactoring 101 
  http://www.agiledata.org/essays/databaseRefactoring.html

  Always fix broken windows...


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cffile in a cfc

[Darren Adams]

BINGO,

I think that has cracked it !!

Cheers Todd !!!

> -Original Message-
> From: Todd [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 17:53
> To: CF-Talk
> Subject: RE: cffile in a cfc
> 
> It can't be arguments.file either... again, it has to be the "FORM"
name.
> 
> So, set it to form.file... and try it.
> 
> At 05:52 PM 1/17/2003 +, you wrote:
> >The form field attribute is set to "arguments.file" it doesn't have
##'s
> >around it.
> >
> > > -Original Message-
> > > From: Todd [mailto:[EMAIL PROTECTED]]
> > > Sent: 17 January 2003 17:45
> > > To: CF-Talk
> > > Subject: Re: cffile in a cfc
> > >
> > > Sounds like you're surrounding the the form field with ##'s and
you
> > > shouldn't be.
> > >
> > >  > > destination="#uploadDir#">
> > >
> > > filefield should be the actual form field name is and not the
contents
> >of
> > > that form field.
> > >
> > > ~Todd
> > >
> > > At 05:35 PM 1/17/2003 +, you wrote:
> > > >Hello All,
> > > >
> > > >Does anyone know if you can use cffile in a cfc ?
> > > >
> > > >I have converted a form action page to a cfc and I get the old
> >chestnut
> > > >about "the form field does not contain a file" error.
> > > >
> > > >The form enc type is fine as it works if I put the old code back
in.
> > > >
> > > >It only errors when I invoke the component and supply the form
data
> > > >through the argument collection.
> > > >
> > > >Has anyone got any ideas ?
> > > >
> > > >Cheers,
> > > >
> > > >-Darren
> > >
> > >
> > >
> > > --
> > > Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
> > > Team Macromedia Volunteer for ColdFusion
> > > http://www.macromedia.com/support/forums/team_macromedia/
> > > http://www.devmx.com/
> > >
> > > --
> > >
> > >
> >
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Obscure Dateformat Question

[Tony Weeg]

is that seconds since jan 1 1970, if so do this


#DateAdd('s', '04-Jun-16', 'January 1 1970 00:00:00)#

will give you that...basically what it is is seconds since Jan 1 1970

hth

...tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping & reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 1:00 PM
To: CF-Talk
Subject: Obscure Dateformat Question


Ok, This is true: dateformat("1092117600") = 04-Jun-16

What I need to do is take 04-Jun-16 and turn it into 1092117600.  I can
go one direction, but I'm not sure how to go back... Some special mask
for Dateformat that I don't know, or what?  If I could get the
algorythm, I'd make a UDF for it...

Thanks in advance,

Willy





-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfquery in mysql part 2

[Todd]

Remove the asterisk.

~Todd

At 05:59 PM 1/17/2003 +, you wrote:
>Ok, so I got that, and a few others to work, now I have a bit of an issue
>with my delete statements
>
>
>DELETE * FROM PPD WHERE ID = #url.id#
>
>
>Now I tried using  for the url.id but none worked! the field
>type is tinyint(4)...
>
>Help!!!
>Ryan




--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Possible to name Application, save name, then rename Application?

[Rick Faircloth]

Based on your comment...

"FYI - the cgi.http_referer variable isn't always present on a given request
 - it can be filtered out by firewalls and the like."

...it would seem that my method of:

 checking for the existence of ".com" in the HTTP_Referer and, if it's
present,
taking the HTTP_Referer and IDing the company's domain,
naming the CFApplication based on the HTTP_Referer,
assigning the HTTP_Referer value to a Server scope variable...

...then upon returning to any pages from within my server (which would
change the HTTP_Referer
and eliminate the company's domain name from it and render that variable
useless)
use a new CFAppliation function to reassign the value from the Server scope,
then
(as you suggested) transfer the Server scope variable to another Application
variable,
(or something that is contained within the Application that's running, and
thereby,
not relying on the use of Server scope variables which could be changed or
deleted
by other Applications running), then working from that point off that
Application,
until the user used the www.bodafordhomes.com name again or some other
domain with .com and the process would reset and start over...

...would not provide consistent performance because of the potential
filtering
of the HTTP_Referer variable?

If so, that's a problem...

Rick



-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 11:49 AM
To: CF-Talk
Subject: Re: Possible to name Application, save name, then rename
Application?


Considering that you also have to identify a client, the server scope alone
may not quite get you where you need to be with this. You'll need to figure
out how to identify each browser, for instance, you could create a server
scoped structure ( server.clients ) which would then contain a list of ip
addresses for different browsers drawn from the cgi.remote_addr variable, or
you could use CF's CFID and CFToken pair although off the top of my head I'm
not sure if they vary between applications. I don't think they do, but I
wouldn't be surprised if I'm wrong. :)

Here's an example:




















FYI - the cgi.http_referer variable isn't always present on a given request
-- it can be filtered out by firewalls and the like.

hth

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

tapestry api is opensource http://www.turnkey.to/tapi

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



> I know that makes no sense, but here's what's happening.

> I'm name a site that serves as a dynamic site for multiple
> companies.
> I need to name the Application and set variables by the
> CGI.HTTP_Referer
> variable.
> No problem so far.

> However, since the site is blind forwarded to my server,
> the HTTP_Referer
> variable
> changes once it's working off my server.  When it comes
> from the company
> that
> handles my DNS, it comes as http://www.bodafordhomes.com,
> from which I can
> do a CFIF CGI.HTTP_Referer contains ".com" and that tells
> me that the
> homepage
> has been requested from somewhere besides my server and
> the ID of the
> company
> needs to be determined for the dynamic site to be setup.
> I have
> http://www.bodafordhomes.com
> stored in the database from which to ID the company and
> choose it's data.

> The problem comes when the pages are served from my
> server.  They use URL's
> like http://77.88.99.00/cfdocs/rea/index.cfm , so the new
> CGI.HTTP_Referer
> can't
> be used to determine company ID any longer and the
> Application can't user
> the CGI.HTTP_Referer
> any longer as a name, because the Application name has to
> stay the same to
> keep the variables
> tied to the Application...

> I need to store the first CGI.HTTP_Referer variable, then
> when the
> Application.cfm
> page is consulted, I can recall that saved original
> HTTP_Referer variable as
> some other
> variable and rename the Application.cfm with it.

> There's the question:  How to save that variable, since I
> can't use
> application or session
> variables because on the second trip to the
> Application.cfm page, the
> Application will
> not have been defined and therefore an error occurs.

> Is there some variable that can be created after the first
> Application is
> named, then
> continue to be used until the Application is renamed?

> (I have got to learn how to do my own DNS, then I probably
> wouldn't have
> this problem.
> But I only have one server, and I need two for DNS
> service...don't I?)

> If I can get past this part, I've got the rest of this
> "one site for many
> companies" licked...

> If this is all crazy and someone else has a solution for
> this situation, I'm
> all ears...uh...or eyes...

> Rick


> ~~
> ~~~|
> Archives:
> http:

Obscure Dateformat Question

[Willy Ray]

Ok, This is true: dateformat("1092117600") = 04-Jun-16

What I need to do is take 04-Jun-16 and turn it into 1092117600.  I can
go one direction, but I'm not sure how to go back... Some special mask
for Dateformat that I don't know, or what?  If I could get the
algorythm, I'd make a UDF for it...

Thanks in advance,

Willy





-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Cfquery in mysql part 2

[Ryan Mitchell]

Ok, so I got that, and a few others to work, now I have a bit of an issue
with my delete statements


DELETE * FROM PPD WHERE ID = #url.id#


Now I tried using  for the url.id but none worked! the field
type is tinyint(4)...

Help!!!
Ryan

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WOT: Access SQL Question - Round 2

[Dina Hess]

In Access, if you use "FROM issues, owners WHERE issues.owner = users.name" you're 
doing a cartesian join, which produces every possible combination of the two tables. 
An inner join, on the other hand, will return only the rows that match your join 
condition.

In SQL Server, however, the "WHERE issues.owner = users.name" syntax *does* produce an 
inner join.

Does that help? 

BTW, kudos on that workaround...I was still scratching over it when your post came 
through. :) 



  I'm know any anything about inner/outer joins - how is using an inner
  join different from using pk=fk, and why would you want to use it in
  this case?



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cffile in a cfc

[Todd]

It can't be arguments.file either... again, it has to be the "FORM" name.

So, set it to form.file... and try it.

At 05:52 PM 1/17/2003 +, you wrote:
>The form field attribute is set to "arguments.file" it doesn't have ##'s
>around it.
>
> > -Original Message-
> > From: Todd [mailto:[EMAIL PROTECTED]]
> > Sent: 17 January 2003 17:45
> > To: CF-Talk
> > Subject: Re: cffile in a cfc
> >
> > Sounds like you're surrounding the the form field with ##'s and you
> > shouldn't be.
> >
> >  > destination="#uploadDir#">
> >
> > filefield should be the actual form field name is and not the contents
>of
> > that form field.
> >
> > ~Todd
> >
> > At 05:35 PM 1/17/2003 +, you wrote:
> > >Hello All,
> > >
> > >Does anyone know if you can use cffile in a cfc ?
> > >
> > >I have converted a form action page to a cfc and I get the old
>chestnut
> > >about "the form field does not contain a file" error.
> > >
> > >The form enc type is fine as it works if I put the old code back in.
> > >
> > >It only errors when I invoke the component and supply the form data
> > >through the argument collection.
> > >
> > >Has anyone got any ideas ?
> > >
> > >Cheers,
> > >
> > >-Darren
> >
> >
> >
> > --
> > Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
> > Team Macromedia Volunteer for ColdFusion
> > http://www.macromedia.com/support/forums/team_macromedia/
> > http://www.devmx.com/
> >
> > --
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: cffile in a cfc

[Darren Adams]

The form field attribute is set to "arguments.file" it doesn't have ##'s
around it.

> -Original Message-
> From: Todd [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 17:45
> To: CF-Talk
> Subject: Re: cffile in a cfc
> 
> Sounds like you're surrounding the the form field with ##'s and you
> shouldn't be.
> 
>  destination="#uploadDir#">
> 
> filefield should be the actual form field name is and not the contents
of
> that form field.
> 
> ~Todd
> 
> At 05:35 PM 1/17/2003 +, you wrote:
> >Hello All,
> >
> >Does anyone know if you can use cffile in a cfc ?
> >
> >I have converted a form action page to a cfc and I get the old
chestnut
> >about "the form field does not contain a file" error.
> >
> >The form enc type is fine as it works if I put the old code back in.
> >
> >It only errors when I invoke the component and supply the form data
> >through the argument collection.
> >
> >Has anyone got any ideas ?
> >
> >Cheers,
> >
> >-Darren
> 
> 
> 
> --
> Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
> Team Macromedia Volunteer for ColdFusion
> http://www.macromedia.com/support/forums/team_macromedia/
> http://www.devmx.com/
> 
> --
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: cffile in a cfc

[Todd]

Sounds like you're surrounding the the form field with ##'s and you 
shouldn't be.



filefield should be the actual form field name is and not the contents of 
that form field.

~Todd

At 05:35 PM 1/17/2003 +, you wrote:
>Hello All,
>
>Does anyone know if you can use cffile in a cfc ?
>
>I have converted a form action page to a cfc and I get the old chestnut
>about "the form field does not contain a file" error.
>
>The form enc type is fine as it works if I put the old code back in.
>
>It only errors when I invoke the component and supply the form data
>through the argument collection.
>
>Has anyone got any ideas ?
>
>Cheers,
>
>-Darren



--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFServer passwords

[Andy Ewings]

thanks guys...

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: 17 January 2003 17:19
To: CF-Talk
Subject: RE: CFServer passwords


> Does anyone know where the CF administrator password 
> is stored in the registry? - my mate has installed 
> the server and rapidly forgotton what it is

Rather than finding out what the existing password is, you can simply
disable the use of the password, then reset it to whatever you like.

If you're running CF 5 or earlier, edit the registry, and set this value to
"0":

HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword

If you're running on Linux/Solaris/HPUX, you'll need to stop the server
before making the edit, then restart it after you've edited the registry. On
Unices, there's no actual registry, so this info is stored in the file
cf.registry (typically /opt/coldfusion/registry/cf.registry).

If you're running CFMX, you'll want to stop the service, edit
neo-security.xml, find "" and set the value to false, then restart the service.

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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: WOT: Access SQL Question - Round 2

[webguy]

> Too bad you have to go thru all of this...a normalized database 
> schema would've prevented this problem...which you probably 
> haven't seen the last of... :)
> 
> ~Dina

Ouch! Database - Refactoring 101 
http://www.agiledata.org/essays/databaseRefactoring.html

Always fix broken windows...

WG 



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: WOT: Access SQL Question - Round 2

[Matthew Small]

I'm know any anything about inner/outer joins - how is using an inner
join different from using pk=fk, and why would you want to use it in
this case?

Thanks,

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Dina Hess [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 12:31 PM
To: CF-Talk
Subject: Re: WOT: Access SQL Question - Round 2

Matthew and Isaac have provided you with two excellent workarounds. I
just have one thing to add.

The "where pk=fk" syntax doesn't produce an inner join in Access.
Instead use "from issues i inner join users u on i.owner = u.name".

Too bad you have to go thru all of this...a normalized database schema
would've prevented this problem...which you probably haven't seen the
last of... :)

~Dina




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Error occurred on line -1 ???

[webguy]

CF ERROR NUMBER -1 Don't event think about.

Haven't heard of that one...

WG

> -Original Message-
> From: Joshua Miller [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 17:26
> To: CF-Talk
> Subject: Error occurred on line -1 ???
>
>
> Anyone else seen this error?
>
> All of the error output is "null" and the error message says: "Error
> occurred on line -1"
>
> This happens when accessing a large amount of data in a query (88,878
> records)
>
> Joshua Miller
> Head Programmer / IT Manager
> Garrison Enterprises Inc.
> www.garrisonenterprises.net 
> [EMAIL PROTECTED]
> (704) 569-9044 ext. 254
>
> 
> *
> Any views expressed in this message are those of the individual sender,
> except where the sender states them to be the views of
> Garrison Enterprises Inc.
>
> This e-mail is intended only for the individual or entity to which it is
> addressed and contains information that is private and confidential. If
> you are not the intended recipient you are hereby notified that any
> dissemination, distribution or copying is strictly prohibited. If you
> have received this e-mail in error please delete it immediately and
> advise us by return e-mail to
> 
> [EMAIL PROTECTED]
> 
> *
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

cffile in a cfc

[Darren Adams]

Hello All,

Does anyone know if you can use cffile in a cfc ?

I have converted a form action page to a cfc and I get the old chestnut
about "the form field does not contain a file" error.

The form enc type is fine as it works if I put the old code back in.

It only errors when I invoke the component and supply the form data
through the argument collection.

Has anyone got any ideas ?

Cheers,

-Darren


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Possible to name Application, save name, then rename Application?

[Rick Faircloth]

Hi, Isaac... thanks for the reply.

Oh, ok, I see...Kym was referring to my DSL provider as "my upstream."
...duh...
I haven't talked with them about doing that, but I have a business DSL
account,
so that might be a possibility.

Right now, when I register a domain with godaddy.com, they park the address,
then I used their "parked" domain servers for DNS and just have them forward
(masked)
the registered domain to my server, http://00.00.00.00/cfdocs/xxx/index.cfm
..
Is that different from what you're talking about doing with Telocity?  It
costs me
$5.95 for masked domain forwardig with godaddy.com.  They have an option
for advanced DNS management for my domains at godaddy, but when it comes
to zone files, etc., I'm lost.  Haven't been able to find enough info to
make all that clear,
so for now, I just handle it like I've done so far.  The only time it has
presented a problem
is at this point of trying to setup multiple companies to work off the same
set of pages...
which requires that some type of unique info come with the initial request
for the homepage
of the domain, so I can pick out that info and assign the right companyID
and setup the app.

I guess the $5.95 per year per domain is what Kym was referring to?  My
local DSL company
would probably not have an Internet GUI through which I could easily manage
DNS info, etc...

Thanks for your help.

Rick


-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 11:32 AM
To: CF-Talk
Subject: RE: Possible to name Application, save name, then rename
Application?


I think Kym was suggesting possibly your DSL provider can offer DNS service.
I think Telocity ( www.DirecTVDSL.com ) used to have that service -- they
supported running web-servers from their DSL -- though they're out of
business or soon to be now. They were my provider for the past year or so
until they tanked and I had to find another provider.

> Hi, Kym, and thanks for the reply.

> I will check out the server scope and see what I can do
> with that.
> Haven't used that one, but perhaps this is a good time to
> learn about it!

> I'm serving with Win 2000 Server through DSL with an
> upstream of about 1.1
> Mbps.
> I don't serve high traffic sites, just several small,
> low-traffic sites.
> I typically register my domains with some vender, usually
> godaddy.com and
> park the domain there and use their servers for DNS, then
> forward the
> domains
> to my server (masked).  That approach has gotten me up and
> running and
> keeps all the hosting dollars in-house, which is why I
> went ahead and set up
> my
> own server.  I'm not very knowledgeable about full
> adminstration of servers,
> so I don't
> what options for DNS "in-house" really are.  Got tired of
> send the hosting
> money elsewhere.

> When you say "Your upstream might be able to offer full
> dns hosting
> for you a few dollars a month for every domain name you
> need..."  what do
> you mean?

> If I set up DNS hosting here for myself, where would the
> "few dollars a
> month" cost
> come into play?

> I know this is pretty far OT now, so if you have any
> advice and would prefer
> to relay
> it directly, feel free to email me.

> Any tutorials and articles on "So you want to run your own
> server and set up
> DNS for yourself, huh?,
> that you can points me to would be appreciated also.

> Thanks for your time.

> Rick


> -Original Message-
> From: Kym Kovan [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 4:13 AM
> To: CF-Talk
> Subject: Re: Possible to name Application, save name, then
> rename
> Application?


> Hi Rick,

>>I know that makes no sense, but here's what's
>>happening.

> The question is how do you save variables that are
> independent of
> application/session scopes. As you have your own server
> why not try server
> scope variables? They are above the application level,
> always there.

>>(I have got to learn how to do my own DNS, then I probably
>>wouldn't have
>>this problem.
>>But I only have one server, and I need two for DNS
>>service...don't I?)

> yes, preferably in different places :-)  How are you
> connecting to the
> Internet? Your upstream might be able to offer full dns
> hosting for you a
> few dollars a month for every domain name you need, that
> type of thing.


> --

> Yours,

> Kym


> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Your ad could be here. Monies from ads go to support these
> lists and provide more resources for the community.
> http://www.fusionauthority.com/ads.cfm

>   Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
>   ubscribe.cfm?user=633.558.4



s. isaac dealey954-776-0046

new

Re: WOT: Access SQL Question - Round 2

[Dina Hess]

Matthew and Isaac have provided you with two excellent workarounds. I just have one 
thing to add.

The "where pk=fk" syntax doesn't produce an inner join in Access. Instead use "from 
issues i inner join users u on i.owner = u.name".

Too bad you have to go thru all of this...a normalized database schema would've 
prevented this problem...which you probably haven't seen the last of... :)

~Dina



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: When do Weekly scheduled items run?

[cfhelp]

I thought they ran at the time you scheduled it... If on Tuesday you create
a weekly it will run Next Tuesday. You can also specify the start time. 

Rick

-Original Message-
From: Ryan Kime [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 10:57 AM
To: CF-Talk
Subject: RE: When do Weekly scheduled items run?

Can't confirm time, but yes, all my weekly runs happen on Monday.

-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 10:44 AM
To: CF-Talk
Subject: When do Weekly scheduled items run?


On the CF scheduler can someone confirm when weekly and monthly items are
executed? 12:01 AM on Moday? That's just a guess...

Thanks!

Stace

AVIS IMPORTANT:
--- 
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee. Si vous avez recu ce document par
erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur
et detruire ce document sans en faire de copie sous quelque forme.

WARNING:
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above. If you are not the intended
recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited. If
you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Error occurred on line -1 ???

[Joshua Miller]

Anyone else seen this error?
 
All of the error output is "null" and the error message says: "Error
occurred on line -1"
 
This happens when accessing a large amount of data in a query (88,878
records)
 
Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net  
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to

[EMAIL PROTECTED]

*
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: When do Weekly scheduled items run?

[webguy]

or maybe not :-)

maybe use

 -Original Message-
> From: Ryan Kime [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 16:57
> To: CF-Talk
> Subject: RE: When do Weekly scheduled items run?
>
>
> Can't confirm time, but yes, all my weekly runs happen on Monday.
>
> -Original Message-
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 10:44 AM
> To: CF-Talk
> Subject: When do Weekly scheduled items run?
>
>
> On the CF scheduler can someone confirm when weekly and monthly items are
> executed? 12:01 AM on Moday? That's just a guess...
>
> Thanks!
>
> Stace
>
> AVIS IMPORTANT:
> ---
> Les informations contenues dans le present document et ses pieces jointes
> sont strictement confidentielles et reservees a l'usage de la (des)
> personne(s) a qui il est adresse. Si vous n'etes pas le
> destinataire, soyez
> avise que toute divulgation, distribution, copie, ou autre utilisation de
> ces informations est strictement prohibee. Si vous avez recu ce
> document par
> erreur, veuillez s'il vous plait communiquer immediatement avec
> l'expediteur
> et detruire ce document sans en faire de copie sous quelque forme.
>
> WARNING:
> ---
> The information contained in this document and attachments is confidential
> and intended only for the person(s) named above. If you are not
> the intended
> recipient you are hereby notified that any disclosure, copying,
> distribution, or any other use of the information is strictly
> prohibited. If
> you have received this document by mistake, please notify the sender
> immediately and destroy this document and attachments without making any
> copy of any kind.
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cfquery - whats wrong with this!?

[Matthew Small]

On that mote, try putting square brackets around On if you don't want to
change the column name.  I don't know if that works in mysql but it
would in access and sql2k.


Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Samuel R. Neff [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 12:12 PM
To: CF-Talk
Subject: Re: Cfquery - whats wrong with this!?

"ON" is a reserved word.  You shouldn't use it as a field name.  Also,
use 
cfqueryparam for parameters.

At 04:56 PM 1/17/2003, you wrote:
>Hello
>
>I've just moved from access to mysql, and I'm noticing that a lot of my
>insert queries aren't working, and I cant figure out why!!
>
>For example...
>
> 
> INSERT INTO Log
> (Action, On, StaffUser)
> VALUES ('#description#', #now()#, '#getstaff.name#')
> 
>
>Updates work fine, as do selects etc, but why isnt this (or any other)
>insert working?!
>
>Ryan


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: WOT: Access SQL Question - Round 2

[Matthew Small]

I would have to disagree with you.  Access is not hideously difficult to
work with.  I actually think it's easier because the functions are right
from visual basic - meaning intuitive for the most part.

I think the reason that this query has been hard to work with because
we're not thinking this problem all the way through - the instr function
is returning a value in the negative range when it reaches a
non-comma-containing field, and then the left function can't run with a
negative length to get.  I think we would have had the same problem with
SQL Server or MySQL - user error.

IMHO

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 12:07 PM
To: CF-Talk
Subject: Re: WOT: Access SQL Question - Round 2

Getting Access to do those sorts of things is always hideously
difficult. If
you really need to stick with a single query, you can use a view -- iirc
Access calls them Queries. The view would include all the data from the
issues table, with the owner column modified as such

SELECT *, left(owner + ',', inStr(owner,',')-1) as ownername FROM issues

then in your cf query you would be able to use a normal join on that
added
column to the users.name column.

SELECT * FROM v_issues, users
WHERE v_issues.ownername = users.name

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

tapestry api is opensource http://www.turnkey.to/tapi

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816

> Okay, I am still having problems with this ... so here is
> an attempt to
> simplify the problem.

> I have a hand-me-down Access database which I am trying to
> get some data
> out of.

> I have a table called issues with a field called owner.
> The owner field
> may contain a single name, or it may contain a
> comma-separated list of
> names.

> I have a table called users with a field called name.  I
> am needing to
> join the two tables up based on the first or only name in
> the
> issues.owner field matched to the users.name field.

> Whenever I try using inStr in the WHERE clause, access
> throws an invalid
> procedure error.  Anybody got any suggestions?

> This does not seem to work with Access and even if it did,
> it would only
> work for records with a list of users in the issues table,
> not just a
> single entry 

> SELECT *
> FROM issues, users
> WHERE left(issues.owner, inStr(issues.owner, ',')-1) =
> users.name


> Thanks
> -- Jeff

> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Your ad could be here. Monies from ads go to support these
> lists and provide more resources for the community.
> http://www.fusionauthority.com/ads.cfm

>   Unsubscribe:
http://www.houseoffusion.com/cf_lists/uns
>   ubscribe.cfm?user=633.558.4



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFServer passwords

[Dave Watts]

> Does anyone know where the CF administrator password 
> is stored in the registry? - my mate has installed 
> the server and rapidly forgotton what it is

Rather than finding out what the existing password is, you can simply
disable the use of the password, then reset it to whatever you like.

If you're running CF 5 or earlier, edit the registry, and set this value to
"0":

HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword

If you're running on Linux/Solaris/HPUX, you'll need to stop the server
before making the edit, then restart it after you've edited the registry. On
Unices, there's no actual registry, so this info is stored in the file
cf.registry (typically /opt/coldfusion/registry/cf.registry).

If you're running CFMX, you'll want to stop the service, edit
neo-security.xml, find "" and set the value to false, then restart the service.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfquery - whats wrong with this!?

[Samuel R. Neff]

"ON" is a reserved word.  You shouldn't use it as a field name.  Also, use 
cfqueryparam for parameters.

At 04:56 PM 1/17/2003, you wrote:
>Hello
>
>I've just moved from access to mysql, and I'm noticing that a lot of my
>insert queries aren't working, and I cant figure out why!!
>
>For example...
>
> 
> INSERT INTO Log
> (Action, On, StaffUser)
> VALUES ('#description#', #now()#, '#getstaff.name#')
> 
>
>Updates work fine, as do selects etc, but why isnt this (or any other)
>insert working?!
>
>Ryan

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Cfquery - whats wrong with this!?

[Craig Dudley]

It's the date,

As Jochem said, use cfqueryparam, should help.

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] 
Sent: 17 January 2003 16:57
To: CF-Talk
Subject: Cfquery - whats wrong with this!?

Hello

I've just moved from access to mysql, and I'm noticing that a lot of my
insert queries aren't working, and I cant figure out why!!

For example...


INSERT INTO Log
(Action, On, StaffUser)
VALUES ('#description#', #now()#, '#getstaff.name#')


Updates work fine, as do selects etc, but why isnt this (or any other)
insert working?!

Ryan


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CFServer passwords

[Joel Blanchette]

For CF 5 Server







  Registry Password: #CFusion_Decrypt(AdminPassword, CFKey)#


 
 
==
Joel Blanchette
IT and System Specialist
Point of Impact Technologies Inc.
Tel: (204) 989-0013
Email: [EMAIL PROTECTED]
==


-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 10:55 AM
To: CF-Talk
Subject: CFServer passwords


Does anyone know where the CF administrator password is stored in the
registry? - my mate has installed the server and rapidly forgotton what
it is

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: When do Weekly scheduled items run?

[webguy]

I think it using the current day/time by default

ie if you set a weekly recurring event today at 5pm , it will run weekly at
5pm on friday...



WG

> -Original Message-
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: 17 January 2003 16:44
> To: CF-Talk
> Subject: When do Weekly scheduled items run?
>
>
> On the CF scheduler can someone confirm when weekly and monthly items
> are executed? 12:01 AM on Moday? That's just a guess...
>
> Thanks!
>
> Stace
>
> AVIS IMPORTANT:
> ---
> Les informations contenues dans le present document et ses pieces
> jointes sont strictement confidentielles et reservees a l'usage
> de la (des) personne(s) a qui il est adresse. Si vous n'etes pas
> le destinataire, soyez avise que toute divulgation, distribution,
> copie, ou autre utilisation de ces informations est strictement
> prohibee. Si vous avez recu ce document par erreur, veuillez s'il
> vous plait communiquer immediatement avec l'expediteur et
> detruire ce document sans en faire de copie sous quelque forme.
>
> WARNING:
> ---
> The information contained in this document and attachments is
> confidential and intended only for the person(s) named above. If
> you are not the intended recipient you are hereby notified that
> any disclosure, copying, distribution, or any other use of the
> information is strictly prohibited. If you have received this
> document by mistake, please notify the sender immediately and
> destroy this document and attachments without making any copy of any kind.
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Cfquery - whats wrong with this!?

[Jochem van Dieten]

Ryan Mitchell wrote:
> 
> 
> INSERT INTO Log
> (Action, On, StaffUser)
> VALUES ('#description#', #now()#, '#getstaff.name#')
> 
> 
> Updates work fine, as do selects etc, but why isnt this (or any other)
> insert working?!

Use cfqueryparam.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: MX and Linux not connecting to MS SQL 6.5

[Nick Mitchell]

ODBC has limited support in Linux. It workssometimes and is very
difficult to setup. MX seems to connect to 7/2000 without trouble so I
wasn't sure if Macromedia developed a custom API for MS SQL access.


On Fri, 17 Jan 2003 17:36:05 +0100
Jochem van Dieten <[EMAIL PROTECTED]> wrote:

> Nick Mitchell wrote:
> > Sorry if I miss some etiquette, my first post here. 
> > 
> > I recently installed CF MX on a Debian Linux box and can't get it to
> > connect to MS SQL 6.5 it always kicks back an error. It works just fine
> > with MS SQL 7/2000. I also tested MX on a windows box and it can connect
> > to SQL 6.5 without any trouble. 
> 
> Native drivers (JDBC Type 4) are not available for MS SQL Server 6.5. Is 
> ODBC supported on Linux?
> 
> Jochem
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: Next N" Navigation and query caching theory question

[Samuel R. Neff]

I should also point out that when I used the primary key caching technique 
I was doing a full-text search against a Verity collection to return the 
primary keys and then using those to get the details out of a database.  So 
in my particular case, I had to do two queries (one against verity, one 
against db) and verity searches can't be cached (at least not with built in 
functionality).

Sam

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQL unique aggregate results

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:
> total  pagename
> =  
> 3  page1
> 2  page2

SELECT  pagename, COUNT(username) AS total
FROM(
SELECT  DISTINCT username, pagename
FROMtrackRes
GROUP BYpagename
) dist_users
GROUP BYpagename

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Access SQL Question - Round 2

[Matthew Small]

I got it...

SELECT issues.id, owners.name, owners.email
FROM issues, owners
WHERE owners.name = left(issues.owner,len(owners.name))


This works, I know for a fact because I tried it.

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Jeff Chastain [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 11:19 AM
To: CF-Talk
Subject: RE: Access SQL Question - Round 2

No, that is along the lines of what I have been trying without any luck.

Okay, I have the following tables and data:

table: issues (id, owner)
  1  Doe
  2  Klein, Doe
  3  James
  4  Doe, James

table: owners (name, email)
  Doe  [EMAIL PROTECTED]
  James[EMAIL PROTECTED]
  Klein[EMAIL PROTECTED]

The results I need to get back are ...
  (issue.id, owners.name, owners.email)
  1  Doe [EMAIL PROTECTED]
  2  Klein   [EMAIL PROTECTED]
  3  James   [EMAIL PROTECTED]
  4  Doe [EMAIL PROTECTED]

Where the name and email come from the first (or only) name in the
issues table.

I would not think that this would be that hard, but for some reason it
appears to be.

Thanks
-- Jeff



-- Original Message --
From: "webguy" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Fri, 17 Jan 2003 15:56:19 -

>No access guru, (anymore:-/) but try
>
>SELECT Firstinlist as (or "=" ???)left(issues.owner,
inStr(issues.owner,
>',')-1)
>FROM issues, users
>WHERE Firstinlist  = users.name
>
>Something like that...
>
>WG
>
>> -Original Message-
>> From: Jeff Chastain [mailto:[EMAIL PROTECTED]]
>> Sent: 17 January 2003 15:44
>> To: CF-Talk
>> Subject: WOT: Access SQL Question - Round 2
>>
>>
>> Okay, I am still having problems with this ... so here is an attempt
to
>> simplify the problem.
>>
>> I have a hand-me-down Access database which I am trying to get some
data
>> out of.
>>
>> I have a table called issues with a field called owner.  The owner
field
>> may contain a single name, or it may contain a comma-separated list
of
>> names.
>>
>> I have a table called users with a field called name.  I am needing
to
>> join the two tables up based on the first or only name in the
>> issues.owner field matched to the users.name field.
>>
>> Whenever I try using inStr in the WHERE clause, access throws an
invalid
>> procedure error.  Anybody got any suggestions?
>>
>> This does not seem to work with Access and even if it did, it would
only
>> work for records with a list of users in the issues table, not just a
>> single entry 
>>
>> SELECT *
>> FROM issues, users
>> WHERE left(issues.owner, inStr(issues.owner, ',')-1) = users.name
>>
>>
>> Thanks
>> -- Jeff
>>
>> 
>

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: WOT: Access SQL Question - Round 2

[S . Isaac Dealey]

Getting Access to do those sorts of things is always hideously difficult. If
you really need to stick with a single query, you can use a view -- iirc
Access calls them Queries. The view would include all the data from the
issues table, with the owner column modified as such

SELECT *, left(owner + ',', inStr(owner,',')-1) as ownername FROM issues

then in your cf query you would be able to use a normal join on that added
column to the users.name column.

SELECT * FROM v_issues, users
WHERE v_issues.ownername = users.name

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

tapestry api is opensource http://www.turnkey.to/tapi

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816

> Okay, I am still having problems with this ... so here is
> an attempt to
> simplify the problem.

> I have a hand-me-down Access database which I am trying to
> get some data
> out of.

> I have a table called issues with a field called owner.
> The owner field
> may contain a single name, or it may contain a
> comma-separated list of
> names.

> I have a table called users with a field called name.  I
> am needing to
> join the two tables up based on the first or only name in
> the
> issues.owner field matched to the users.name field.

> Whenever I try using inStr in the WHERE clause, access
> throws an invalid
> procedure error.  Anybody got any suggestions?

> This does not seem to work with Access and even if it did,
> it would only
> work for records with a list of users in the issues table,
> not just a
> single entry 

> SELECT *
> FROM issues, users
> WHERE left(issues.owner, inStr(issues.owner, ',')-1) =
> users.name


> Thanks
> -- Jeff

> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Your ad could be here. Monies from ads go to support these
> lists and provide more resources for the community.
> http://www.fusionauthority.com/ads.cfm

>   Unsubscribe: http://www.houseoffusion.com/cf_lists/uns
>   ubscribe.cfm?user=633.558.4


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: Access SQL Question - Round 2

[Jeff Chastain]

That is where 'webguy' had it - he just had the AS clause reversed.  Am I missing 
something?


-- Original Message --
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Fri, 17 Jan 2003 11:44:41 -0500

>I'm not sure but try puting the "left(issues.owner, inStr(issues.owner,
>',')-1)" up in the select as "left(issues.owner, inStr(issues.owner, ',')-1)
>as LastName". That should get rid of the error.
>
>
>-Original Message-
>From: Jeff Chastain [mailto:[EMAIL PROTECTED]]
>Sent: Friday, January 17, 2003 11:19 AM
>To: CF-Talk
>Subject: RE: Access SQL Question - Round 2
>
>
>No, that is along the lines of what I have been trying without any luck.
>
>Okay, I have the following tables and data:
>
>table: issues (id, owner)
>  1  Doe
>  2  Klein, Doe
>  3  James
>  4  Doe, James
>
>table: owners (name, email)
>  Doe  [EMAIL PROTECTED]
>  James[EMAIL PROTECTED]
>  Klein[EMAIL PROTECTED]
>
>The results I need to get back are ...
>  (issue.id, owners.name, owners.email)
>  1  Doe [EMAIL PROTECTED]
>  2  Klein   [EMAIL PROTECTED]
>  3  James   [EMAIL PROTECTED]
>  4  Doe [EMAIL PROTECTED]
>
>Where the name and email come from the first (or only) name in the issues
>table.
>
>I would not think that this would be that hard, but for some reason it
>appears to be.
>
>Thanks
>-- Jeff
>
>
>
>-- Original Message --
>From: "webguy" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>Date:  Fri, 17 Jan 2003 15:56:19 -
>
>>No access guru, (anymore:-/) but try
>>
>>SELECT Firstinlist as (or "=" ???)left(issues.owner, inStr(issues.owner,
>>',')-1)
>>FROM issues, users
>>WHERE Firstinlist  = users.name
>>
>>Something like that...
>>
>>WG
>>
>>> -Original Message-
>>> From: Jeff Chastain [mailto:[EMAIL PROTECTED]]
>>> Sent: 17 January 2003 15:44
>>> To: CF-Talk
>>> Subject: WOT: Access SQL Question - Round 2
>>>
>>>
>>> Okay, I am still having problems with this ... so here is an attempt to
>>> simplify the problem.
>>>
>>> I have a hand-me-down Access database which I am trying to get some data
>>> out of.
>>>
>>> I have a table called issues with a field called owner.  The owner field
>>> may contain a single name, or it may contain a comma-separated list of
>>> names.
>>>
>>> I have a table called users with a field called name.  I am needing to
>>> join the two tables up based on the first or only name in the
>>> issues.owner field matched to the users.name field.
>>>
>>> Whenever I try using inStr in the WHERE clause, access throws an invalid
>>> procedure error.  Anybody got any suggestions?
>>>
>>> This does not seem to work with Access and even if it did, it would only
>>> work for records with a list of users in the issues table, not just a
>>> single entry 
>>>
>>> SELECT *
>>> FROM issues, users
>>> WHERE left(issues.owner, inStr(issues.owner, ',')-1) = users.name
>>>
>>>
>>> Thanks
>>> -- Jeff
>>>
>>> 
>>
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: When do Weekly scheduled items run?

[Ryan Kime]

Can't confirm time, but yes, all my weekly runs happen on Monday.

-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]] 
Sent: Friday, January 17, 2003 10:44 AM
To: CF-Talk
Subject: When do Weekly scheduled items run?


On the CF scheduler can someone confirm when weekly and monthly items are
executed? 12:01 AM on Moday? That's just a guess...

Thanks!

Stace

AVIS IMPORTANT:
--- 
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee. Si vous avez recu ce document par
erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur
et detruire ce document sans en faire de copie sous quelque forme.

WARNING:
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above. If you are not the intended
recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited. If
you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Cfquery - whats wrong with this!?

[Ryan Mitchell]

Hello

I've just moved from access to mysql, and I'm noticing that a lot of my
insert queries aren't working, and I cant figure out why!!

For example...


INSERT INTO Log
(Action, On, StaffUser)
VALUES ('#description#', #now()#, '#getstaff.name#')


Updates work fine, as do selects etc, but why isnt this (or any other)
insert working?!

Ryan

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

CFServer passwords

[Andy Ewings]

Does anyone know where the CF administrator password is stored in the
registry? - my mate has installed the server and rapidly forgotton what it
is
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: CF File error code...

[Owens, Howard]

Sounds like the Cold Fusion service needs permission to write files on that
server ... I'm reading what you wrote as you are trying to write from one
server to another.  You need to explicitly go into the control
panel/services tool and open up the CF service, and set the proper username
and password.

H.



> -Original Message-
> From: Paris Lundis [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, January 16, 2003 9:50 PM
> To:   CF-Talk
> Subject:  CF File error code...
> 
> I was sitting here writing a custom little application using CFFILE... 
> a simple copy statement.. nothing fancy...  copying a file from one sub 
> directory on the server to another...
> 
> I get this:
> 
> Error processing CFFILE Unable to copy file 'c:\utils\0del.exe' to 
> path 'c:\1'. Error: Access is denied. (error 5).
> 
> What is that error specific too?  I am running IIS and told IIS full 
> access to the directory the write is going to... including WRITE 
> access...
> 
> anyone?
> 
> 
>   
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4