RE: Handling invalid recipient in mailing list

2015-04-02 Thread William Seiter

Dave,

You could have your code 'automatically' scrub the list and use a 'log' to
keep track of the changes.  This way you won't have to do a test run.  
Also, you could set up your code on a 'dummy' email server that will send
the email but trap it prior to being mailed, this way you don't have to
bother your recipients list.
Also, you could create an email validation loop so that you can 'verify' the
list without the concern for sending an email out at all (instead of doing a
'cfmail' tag, you would do the validation of the email address).

I don't know how large your recipient's list is, but I would try to not
bother them with testing emails.

Just my 2 pence,
William


--
William Seiter

-Original Message-
From: Dave Long [mailto:d...@northgoods.com] 
Sent: Thursday, April 02, 2015 3:55 PM
To: cf-talk
Subject: RE: Handling invalid recipient in mailing list


Thanks to all. The scheme worked perfectly. Next I will have to warn my
recipients that a test is coming so I can remove invalid recipients. 

Unless maybe you can suggest a method to delete them as they occur. I intend
to add a confirmation message requirement to our contact form, which should
have been there all along, but a means of automatically cleaning the
existing mailing list would help everyone... me most of all though.

Thanks again for your help.

Dave Long

-Original Message-
From: Rick [mailto:cfh...@kchost.net]
Sent: Thursday, April 2, 2015 5:20 PM
To: cf-talk
Subject: RE: Handling invalid recipient in mailing list




 Run you CFMAIL..

  Mark email bad in database 



-Original Message-
From: Dave Long [mailto:d...@northgoods.com]
Sent: Thursday, April 02, 2015 5:12 PM
To: cf-talk
Subject: Handling invalid recipient in mailing list


I am trying to send a mass mailing to a somewhat carelessly created list of
contacts using e-mail addresses which were not verified at the time of
entry. Whenever the cfloop tag comes to an erroneous recipient, it quits and
throws an error. Is there anything I can do to the code to make it keep
going?

Here's the code:



http://www.northgoods.com/global.css"; type="text/css" />





#Form.Message#



If you would like to be removed fromour mailing list,
please click here:
http://www.northgoods.com/unsubscribe.cfm?delEmail=#Recipient#";
title="UNSUBSCRIBE">UNSUBSCRIBE
You will receive one last
message from us to confirm your removal from our
list. 










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


CF Builder 3

2015-03-02 Thread William Seiter

Good Afternoon,

I have been playing with the mobile abilities of CF11 recently and just
noticed that my trial copy of the CFB is coming to an end soon.

Does anyone have an extra license for CFB 3 that they would be willing to
part with?

I don't want to pay the full retail price for something I am just 'playing
with' yet.

Thanks,
William


------
William Seiter 


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


RE: Cannot access session variables in a cfc

2015-01-28 Thread William Seiter

Can you give us some code examples of how it 'used' to be setup?

Where was the CFC saved.
Where was the CFC called.
How was it called.
Etc.

Not that fixing the actual problem will set you suddenly into best
practices, but it will fix your current headache and then you can follow up
with BP later when the fires are out.

Thanks,
William


------
William Seiter


-Original Message-
From: John Pullam [mailto:jpul...@mcleansystems.com] 
Sent: Wednesday, January 28, 2015 8:57 AM
To: cf-talk
Subject: Re: Cannot access session variables in a cfc


I know this isn't ideal, but it is a live application and the decision to
move the cfc's outside of the doc root was taken because CF was having
trouble finding them (for no obvious reason). Code that has worked since CF7
started breaking.

So we moved them and this problem began. 

I am looking for a quick solution for now, knowing that I need to develop a
better one.

I'm wondering about putting the variable in the Application scope? Do the
cfc's have access to that? 



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


RE: Cannot access session variables in a cfc

2015-01-28 Thread William Seiter

You will need to pass your session variables as a parameter in order to use
them in the CFC, this is best practices anyways.

Good news, however, is that you can send them as a complete struct, you
don't necessarily need to have them send all separately.



Hope this helps,
William

--
William Seiter

-Original Message-
From: John Pullam [mailto:jpul...@mcleansystems.com] 
Sent: Wednesday, January 28, 2015 8:08 AM
To: cf-talk
Subject: Cannot access session variables in a cfc


My app is running in a CF10 system and since I moved my cfc's out of the
document root, they are losing access to the session variables. It seems
that they work for around a day and then can no longer be found. I
initialize them in my application.cfm to a value and I can still cfdump them
in a regular web page, but the cfc fails with the error "Element XXX is
undefined in SESSION".

Is this normal behaviour? If it is, then what is the alternative method of
passing a variable into the cfc (other than making it a parameter when
calling)? 



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


RE: Call Rail API / CF

2015-01-19 Thread William Seiter

This line in the PHP seems to indicate that they are using double quotes
around the key.

curl_setopt($ch, CURLOPT_HTTPHEADER, array("Authorization: Token
token=\"{$api_key}\""));

Have you tried using double quotes around the key?





----------
William Seiter


-Original Message-
From: Robert Harrison [mailto:rharri...@aimg.com] 
Sent: Monday, January 19, 2015 8:48 AM
To: cf-talk
Subject: RE: Call Rail API / CF


Yes. The PHP version does pull the data. The CF version comes up empty. 


Robert Harrison
Full Stack Developer
AIMG
rharri...@aimg.com
Main Office: 704-321-1234 ext.121
Direct Line: 516-302-4345
www.aimg.com



-Original Message-
From: Dean Lawrence [mailto:dean...@gmail.com] 
Sent: Monday, January 19, 2015 11:46 AM
To: cf-talk
Subject: Re: Call Rail API / CF


Ok, good, I just wanted to make sure. So, when you use a GET, it sounds like
you are authenticating correctly, no? This my sound stupid, but do you have
any companies added to the system for the API to return? Also, have you
tried removing the single quotes from your API key in the header? In the API
documentation, it does not have quotes around it,
"Authorization: Token
token=abc1234".

On Mon, Jan 19, 2015 at 11:37 AM, Robert Harrison 
wrote:

>
> I'm not using my key here... I just not posting my key to a public 
> forum that's indexed in Google.
>
> And I've treid get also... I've tried every variation I can think of.  
> I got a 200 response from GET but no data.  Otherwise I get 401.
>
>
> Robert Harrison
> Full Stack Developer
> AIMG
> rharri...@aimg.com
> Main Office: 704-321-1234 ext.121
> Direct Line: 516-302-4345
> www.aimg.com
>
>
>
>
  [image: profile picture]  *Dean Lawrence*
*President*
Internet Data Technology
*Phone:* 888-438-4381 x701
*Web:* www.idatatech.com
*Email:* d...@idatatech.com
  Programming | Database | Consulting | Training






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


Re: local install - ses non working(I think)

2014-12-23 Thread William Seiter

My best guess, without looking at your admin, is that you did not setup your 
directories (for includes) in the administrator. 

Take a look at the live sites admin settings and mimic them on your local admin

---
William Seiter


> On Dec 23, 2014, at 3:58 PM, Matthew Smith  wrote:
> 
> 
> I have been developing on our live server as the site has been down for
> some time.  I am trying to get things right and just installed apache and
> cf11 on my local box.  This is the error I get when I try to bring up the
> site's home page.
> 
> Any ideas, I am not sure what to try.  Thanks.
> 
> MissingInclude Could not find the included template
> /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm.
> Note:
> If you wish to use an absolute template path (for example,
> template="/mypath/index.cfm") with CFINCLUDE, you must create a mapping for
> the path using the ColdFusion Administrator. Or, you can use
> per-application settings to specify mappings specific to this application
> by specifying a mappings struct to THIS.mappings in Application.cfc. 
> Using relative paths (for example, template="index.cfm" or
> template="../index.cfm") does not require the creation of any special
> mappings. It is therefore recommended that you use relative paths with
> CFINCLUDE whenever possible.
> /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm
> [empty
> string] [empty string]cfcatch.tagcontext - array1cfcatch.tagcontext - struct
> COLUMN0IDCFINCLUDELINE29RAW_TRACEat
> cfindex2ecfm1457390167.runPage(C:\wwwroot\index.cfm:29)TEMPLATE
> C:\wwwroot\index.cfmTYPECFML2cfcatch.tagcontext - structCOLUMN0IDCFINCLUDE
> LINE198RAW_TRACEat
> cfApplication2ecfc65118548$funcONREQUEST.runFunction(C:\wwwroot\Application.cfc:198)
> TEMPLATEC:\wwwroot\Application.cfcTYPECFML
> 
> -- 
> Regards,
> chedder is bedder
> 
> 
> 

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


Re: local install - ses non working(I think)

2014-12-23 Thread William Seiter

That's not it...

---
William Seiter


> On Dec 23, 2014, at 4:05 PM, Maureen  wrote:
> 
> 
> It is fairly clear that the path you are using for the include is
> invalid.  It needs to be a physical path, not a url, and I doubt if
> your physical path includes
> 
> /site_
> theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm
> 
> Are you using a variable to build the include path?
> 
> 
> 
>> On Tue, Dec 23, 2014 at 6:58 PM, Matthew Smith  wrote:
>> 
>> I have been developing on our live server as the site has been down for
>> some time.  I am trying to get things right and just installed apache and
>> cf11 on my local box.  This is the error I get when I try to bring up the
>> site's home page.
>> 
>> Any ideas, I am not sure what to try.  Thanks.
>> 
>> MissingInclude Could not find the included template
>> /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm.
>> Note:
>> If you wish to use an absolute template path (for example,
>> template="/mypath/index.cfm") with CFINCLUDE, you must create a mapping for
>> the path using the ColdFusion Administrator. Or, you can use
>> per-application settings to specify mappings specific to this application
>> by specifying a mappings struct to THIS.mappings in Application.cfc. 
>> Using relative paths (for example, template="index.cfm" or
>> template="../index.cfm") does not require the creation of any special
>> mappings. It is therefore recommended that you use relative paths with
>> CFINCLUDE whenever possible.
>> /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm
>> [empty
>> string] [empty string]cfcatch.tagcontext - array1cfcatch.tagcontext - struct
>> COLUMN0IDCFINCLUDELINE29RAW_TRACEat
>> cfindex2ecfm1457390167.runPage(C:\wwwroot\index.cfm:29)TEMPLATE
>> C:\wwwroot\index.cfmTYPECFML2cfcatch.tagcontext - structCOLUMN0IDCFINCLUDE
>> LINE198RAW_TRACEat
>> cfApplication2ecfc65118548$funcONREQUEST.runFunction(C:\wwwroot\Application.cfc:198)
>> TEMPLATEC:\wwwroot\Application.cfcTYPECFML
>> 
>> --
>> Regards,
>> chedder is bedder
> 
> 

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


Re: local install - ses non working(I think)

2014-12-23 Thread William Seiter

Phillip, I like your sense of humor. 

---
William Seiter


> On Dec 23, 2014, at 4:00 PM, Phillip Vector  wrote:
> 
> 
> *stares blankly at the screen*
> 
> *gets up and goes to get some popcorn*
> 
> Ok.. Proceed.
> 
> On Tue, Dec 23, 2014 at 3:58 PM, Matthew Smith 
> wrote:
> 
>> 
>> I have been developing on our live server as the site has been down for
>> some time.  I am trying to get things right and just installed apache and
>> cf11 on my local box.  This is the error I get when I try to bring up the
>> site's home page.
>> 
>> Any ideas, I am not sure what to try.  Thanks.
>> 
>> MissingInclude Could not find the included template
>> 
>> /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm.
>> Note:
>> If you wish to use an absolute template path (for example,
>> template="/mypath/index.cfm") with CFINCLUDE, you must create a mapping for
>> the path using the ColdFusion Administrator. Or, you can use
>> per-application settings to specify mappings specific to this application
>> by specifying a mappings struct to THIS.mappings in Application.cfc. 
>> Using relative paths (for example, template="index.cfm" or
>> template="../index.cfm") does not require the creation of any special
>> mappings. It is therefore recommended that you use relative paths with
>> CFINCLUDE whenever possible.
>> 
>> /site_theartoflovingcatsanddogs_com/index.cfm/cfid/2/cftoken/60648468/index.cfm
>> [empty
>> string] [empty string]cfcatch.tagcontext - array1cfcatch.tagcontext -
>> struct
>> COLUMN0IDCFINCLUDELINE29RAW_TRACEat
>> cfindex2ecfm1457390167.runPage(C:\wwwroot\index.cfm:29)TEMPLATE
>> C:\wwwroot\index.cfmTYPECFML2cfcatch.tagcontext - structCOLUMN0IDCFINCLUDE
>> LINE198RAW_TRACEat
>> 
>> cfApplication2ecfc65118548$funcONREQUEST.runFunction(C:\wwwroot\Application.cfc:198)
>> TEMPLATEC:\wwwroot\Application.cfcTYPECFML
>> 
>> --
>> Regards,
>> chedder is bedder
> 
> 

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


RE: Creating columns that aren't included in a query result

2014-12-11 Thread William Seiter

I know this topic has gone far since we last reviewed together, but I wanted
to touch on this subject quickly.

 


List 1 is a defined set of values or 'column headers' in a table. (HTML)

List 2 is a resultset of values (valuelist()) or 'Row values' in a table.
(query)

By doing a 'ValueList()' for list2 you are telling the code to make a list
of all of the resultset values for a specific column that was returned.

By checking the second list for a matching value to the first, you are
comparing 'column header' strings to 'row result values (possibly
numeric?)'.

--
William Seiter

-Original Message-
From: Torrent Girl [mailto:moniqueb...@gmail.com] 
Sent: Thursday, December 11, 2014 5:42 AM
To: cf-talk
Subject: Re: Creating columns that aren't included in a query result


William, your suggestion is what I went with it initially:

Here is my code:


  #getimprovedCompetence.TOTALIMPROVEDCOMPETENCE#

0


 


The problem is for the cells that are supposed to have a value, it puts ALL
of the values in these cells.

This is where I got stuck.




>It seems illogical that a column would not exist from the query.  Could 
>you post the query that is being run?
>
>As to your display issue...
>
>   #[qName].[colName]#
>
>   0
>
>
>One of these per column...
>
> 



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


RE: Creating columns that aren't included in a query result

2014-12-10 Thread William Seiter

It seems illogical that a column would not exist from the query.  Could you
post the query that is being run?

As to your display issue...

#[qName].[colName]#

0


One of these per column...


--
William Seiter

-Original Message-
From: Torrent Girl [mailto:moniqueb...@gmail.com] 
Sent: Wednesday, December 10, 2014 4:29 PM
To: cf-talk
Subject: Re: Creating columns that aren't included in a query result


Russ there is only one loop.

It's a very simple table with a static first row with headers and a simple
query loop to add columns.

So here is my header row: 
Agree, Disagree, Neither Agree nor Disagree, Strongly Agree, Strongly
Disagree 

And here is my dynamic row created from the query:

Agree, Disagree,  Strongly Agree, Strongly Disagree 


So, if 'Neither Agree nor Disagree' is not returned from the query, I am
short of one cell and it throws it off.

I need to create an empty cell for each one that wasn't returned.



>why do you need the 2nd loop rather than simply outputting the value of 
>the query column from the main loop?
>
>On Thu, Dec 11, 2014 at 12:02 AM, Torrent Girl 
>wrote:
>
>> 



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


RE: Creating columns that aren't included in a query result

2014-12-10 Thread William Seiter

If I understand correctly

Select response1 from [table]

The resulting Query can equal 'response1' == 'Agree' or 'Disagree' or
'Neither Agree nor Disagree' or 'Strongly Agree' or 'Strongly Disagree'

Then you loop over the results from the query and (I am guessing here) you
want to place an 'X' in the box under the correct header?

Simplest I can think of would be





X


X


X


X


X
        





--
William Seiter

-Original Message-
From: Torrent Girl [mailto:moniqueb...@gmail.com] 
Sent: Wednesday, December 10, 2014 4:03 PM
To: cf-talk
Subject: Creating columns that aren't included in a query result


I am hoping I can explain this correctly.

I have a table which houses responses to a survey.

The columns can have any of the following values:

Agree,Disagree,Neither Agree nor Disagree,Strongly Agree,Strongly Disagree

I have a table with the headers equal to all of the values above.

I have a 2nd row that loops through the query and adds a cell in the row for
each value:

EX: #query.value#

Here is my problem:

There are times when not all of the values exists, so I don't have enough of
the dynamic cells in the row. EX: I have a header called "Agree" but the
value "agree" is not returned from the query so it messes up the row.

My question is how can I create a "fake" column from the query OR create an
empty cell in the row if a value doesn't exist?

NOTE: The values don't exist so I can "test for existence" if that makes
sense.

Thanks in advance.




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


RE: Redirects

2014-11-10 Thread William Seiter

Unless you need these redirects to be dynamically controlled by a
datasource, I would handle them outside of CF.
You could use a mod_rewrite on the server or even a virtual directory.

If you are determined to utilize CF for this, look into the 
tag.
(http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0
811cbec22c24-7cac.html)
It does what you are looking to do.


Hope this helps,
William



--
William Seiter

-Original Message-
From: Steve LaBadie [mailto:slaba...@po-box.esu.edu] 
Sent: Monday, November 10, 2014 12:39 PM
To: cf-talk
Subject: Redirects


We are currently using a meta date redirect from a UNIX box. The redirects
currently sit on www and the production server sit at www4. We are taking
down www so the redirects have to be recreated on our new production server
which will be taking www.

Current redirect structure:


http://www4.esu.edu/about/offices/police/index.cfm";>



When the user types in www.esu.edu/police<http://www.esu.edu/police> it
takes you to the correct page. We use this format to avoid long URLs on
marketing pieces.

Can someone give me directions for best practices using CF. The new
production server currently runs CF9 but looking to upgrade to CF11.


Steve LaBadie, Web Manager
East Stroudsburg University
570-422-3999
slaba...@esu.edu<mailto:slaba...@esu.edu>

[facebook-16x16]<http://www.facebook.com/eaststroudsburguniversity>
[twitter-16x16] <http://twitter.com/esuniversity>   [youtube-16x16]
<http://www.youtube.com/user/esuedu>





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


RE: Avoiding a boat load of queries inserting multiple records - Better Way?

2014-10-10 Thread William Seiter

It sounds like your client needs a smarter application.

When your client uploads their XLS document, you can add functionality that
displays back to them the first line of the excel spreadsheet and have them
identify which column is filled with which data...( email|first name|last
name|company)

Then you can instruct whichever method you end up using to correlate the
correct column with the correct data.

William

--
William Seiter


-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Thursday, October 09, 2014 5:51 PM
To: cf-talk
Subject: Re: Avoiding a boat load of queries inserting multiple records -
Better Way?


 > Not knowing much about your overall process, I'll try to stick to some  >
generic ideas. Let's assume you don't need this stuff dumped into the  >
database the very second it gets sent to you.

This is actually part of a client's admin system on their website. They send
out legal newsletters. LOTS of legal newsletters.
And they have boats loads of various list they can send them too. Some lists
go to 15,000 or more subscribers at a time.
They want to be able to import as many list as they want with as many
records at any time they want by just clicking the "import list" button...

This app have been around for awhile. They just upgraded their server, so up
to this point the import function was using the POI utility.
Even when they entered a "legal" spreadsheet into the system, if it had too
many records or extra crap for POI to chew through, the whole thing would
time out.
They KNOW that the damn spreadsheet is supposed to be formatted a very
specific way for this to work, and there's a template they're supposed to
use, but clients being clients, they will attempt to shove ANYTHING in there
at times, and then yell when it doesn't import. Even the concept of "the
email address HAS to be the first column" just gets ignored a lot.

This particular application has been a huge challenge from day one, mostly
because the rules get ignored half the time, so the app kicks the
spreadsheet back out at them and demands it be reformatted, and they yell
about it thinking that it should be able to import whatever they try to put
in. Ain't never gonna happen.

Really, how hard is: email|first name|last name|company?
But I see sheets with hidden columns, paragraphs of extra stuff, formulas
(what the heck for? It's supposed to be a list of addresses!!), email
address in the 9th column when the app is specifically set to ignore
anything past the first four ... it's unreal.

Since the server upgrade, sheets that would time out seem to get parsed
pretty quickly by cfspreadsheet functions. I'm happier with it now. But, I'm
trying to improve on the efficiency of the whole thing by optimizing the
queries, because I KNOW that running 20,000 queries to import 5000 email
addresses isn't a good thing as far as cpu cycles go.

I'm having my local SQL Server expert meet with me tomorrow and we'll get a
stored procedure written to take care of all this in one fell swoop...

Clients, huh?? Sheesh!



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


RE: Avoiding a boat load of queries inserting multiple records - Better Way?

2014-10-09 Thread William Seiter

Off the top of my head...

To insert the last inserted unique id in a transaction...


INSERT dbo.table(column) SELECT 1;
SELECT @newID = SCOPE_IDENTITY();
INSERT dbo.table_2 (column) SELECT @newID;


--
William Seiter


-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Thursday, October 09, 2014 2:14 PM
To: cf-talk
Subject: Re: Avoiding a boat load of queries inserting multiple records -
Better Way?


On 10/9/2014 5:00 PM, Cameron Childress wrote:
>
>
> A few years ago I stopped using numerics and auto-increment and 
> started using UUID for all PK/FK columns.

On new stuff, this is what I'm doing as well. Unfortunitely, this is a
pre-existing app and would take a good bit of rewrite to do that.

Still scratching my head over writing the procedure itself.



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


RE: Avoiding a boat load of queries inserting multiple records - Better Way?

2014-10-09 Thread William Seiter

What kind of database?  MSSql? Mysql? Oracle? ...


--
William Seiter


-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Thursday, October 09, 2014 1:29 PM
To: cf-talk
Subject: Re: Avoiding a boat load of queries inserting multiple records -
Better Way?


On 10/9/2014 1:49 PM, Cameron Childress wrote:
> Most databases will let you issue multiple SQL statements in a single 
> request/transaction. You just have to separate them with a semicolon.

If you did it this way, how would you get the ID from the first insert for
use in the 2nd ... (because I'm looking at stored procedures and I'm not
ashamed to admit that doing that inside SQL Server is beyond my coding
capabilities - unless somebody can point me to /The Complete Idiot's Guide
to Writing this Procedure with SqlServer 10/ (which I've been looking for
but haven't found yet...)

So something like:



  insert into table_1 (...) values (...);
  insert into table_2 (table_1_id, other_stuff) values
(#Id_from_above_insert#, #other_stuff# )










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


RE: Avoiding a boat load of queries inserting multiple records - Better Way?

2014-10-09 Thread William Seiter

Have you investigated using a Stored Procedure that does both inserts?


--
William Seiter


-Original Message-
From: Les Mizzell [mailto:lesm...@bellsouth.net] 
Sent: Thursday, October 09, 2014 9:31 AM
To: cf-talk
Subject: Avoiding a boat load of queries inserting multiple records - Better
Way?


I've got an application that imports email list from Excel sheets. 
Mostly working fine, but I've got one spot where I'd like to optimize things
if I could.

Once the data is imported I run two queries against each email address:
1. see if the email address is already in the group in question 2. see if
this person has already unsubscribed from this list --->

If both of those return no records, and I've already run some other
validation making sure entered info is valid, I add everything to an array:






Now the problem ...
I need to do two inserts
   - first to enter the info into the email database
   - second to capture the ID from the first insert, and put that into a
relational table that assigns that address to the specified group.
I removed cfqueryparam from the below to make it more compact...

So, I loop through my array and enter all the records..


   
 SET NOCOUNT ON
  . remainder of insert code
 SET NOCOUNT OFF
 SELECT @@IDENTITY AS fromLISTID
 

   
   INSERT INTO nl_catREL ( groups_id, email_id )
VALUES ( #req.thisGROUPID#, #insertLIST.fromLISTID# )



The problem is, some of these spreadsheets and have up to 5,000 or more
email addresses.
That means, just for the insert, two queries for each address = 10,000
queries.
If it was just one insert query, no big deal, as I could loop inside the
query tag itself and reduce it to one call. It's the two combined that are
giving me a headache. The application IS working the way it is, but shove a
15,000 email list into it, and it obviously chokes.

Is there a better way to set up my two insert queries above so it's not
making two calls for every single address?





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


Re: Using a variable to dynamically specify table name in CF10?

2013-03-29 Thread William Seiter

What is the error message that you receive?

--
William Seiter 

On Mar 29, 2013, at 9:40 AM, Marty Franklin  wrote:

> 
> I am in the process of moving from CF8 to 10. I have a couple of queries 
> where I dynamically specify the table name. For some reason this 
> technique does not work in CF10?
> 
> So for instance...
> 
> 
> 
>  
> SELECT * FROM #tblname#
> 
> 
> Thanks is advance.
> 
> -- 
> 
> Best Regards,
> 
> *Marty Franklin*
> /Information Technology/
> 
> *Asset Research Services, Inc.*
> ma...@assetresearch.com <mailto:ma...@assetresearch.com>
> 
> 
> 
> 
> 

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


RE: validating query string error

2012-06-11 Thread William Seiter

>From the Coldfusion docs:

If TestValue = "234A56?7'", Val(TestValue) returns 234.
If TestValue = "234'5678'9?'", Val(TestValue) returns 234.
If TestValue = "BG234", Val(TestValue) returns the value 0, (not an
error).
If TestValue = "0", Val(TestValue) returns the value 0, (not an error).

So lid=14%27%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40version
Val('14%27%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40version') would be equal to
14, which is numeric.

-Original Message-
From: Mike Little [mailto:m...@nzsolutions.co.nz] 
Sent: Monday, June 11, 2012 3:09 PM
To: cf-talk
Subject: validating query string error


on my pricing page, i have the following if statement to ensure invalid url
vars are not being input...

if (isnumeric(val(URL.lid))) {

however the query string below seems to get through? what should i be doing
instead?

--- error message ---

Diagnostics: The LOCATION_ID argument passed to the get_term_loaded function
is not of type numeric. If the component name is specified as a type of this
argument, its possible that a definition file for the component cannot be
found or is not accessible. 

The error occurred on line 153.
Referrer:
Template: /pricing.cfm
Query string: lid=14%27%2F%2A%2A%2For%2F%2A%2A%2F1%3D%40%40version-- 




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


Re: bizarre cffile upload bug.

2012-05-07 Thread William Seiter

Is that location inside of the web root?  You say the file exists but isn't 
openable, right?  If it is outside of the web root, you may need to add a 
mapping to the server. 

--
William Seiter 

On May 7, 2012, at 6:32 PM, Tony  wrote:

> 
> hi there.
> 
> im sending a file to my server with the following code:
>  nameconflict="overwrite" filefield="pdf_file" attributes="readonly" />
> 
> the result of this when I browse the file in chrome and safari (on my
> mac) both result in a "Failed to Load PDF Document" error.
> 
> _however_
> 
> if I simply ftp the file, the same exact file from my machine, and I
> browse to it, it's working just fine :)
> 
> *when I use CFFILE, the file actually appears on the server, and i can
> see the file, with filesize as I would expect it.
> 
> this doesnt work, I need to build this for my client to manage the
> files themselves, ive done this 20 other times
> for other clients, but today, its just not working... any clues?!
> 
> ive tried every attribute i can think of... nothing is making sense.
> 
> thanks
> tw
> 
> 

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


Re: (ot) SEO

2012-01-20 Thread William Seiter

Hey Dave,
The description of what you are trying to accomplish is  very vague. If you 
just wanted clarification on redirects vs SEO, they are not good practice and 
will probably mess everything up.  If you want advice on how to handle what you 
need to accomplish on an SEO friendly way, please post what it is that your 
index page is doing, being as specific as possible. Or hit me up off list

--
William Seiter 

On Jan 20, 2012, at 7:15 AM, Dave  Hatz  wrote:

> 
> Sorry about the OT here, but I know there are some really good SEO people 
> that are on this list.
> 
> I have a CFM page that processes some information, then redirects to another 
> CFM page.  I have a client that is telling me that my redirect inside my cfm 
> page is not going to work for SEO.
> 
> I have index.cfm, it parses the URL for some data, updates the DB, then I use 
>  work for his SEO stuff.  
> 
> As you can tell, I am not well versed in SEO.  Can I get some verification 
> from others on this list that are well versed on SEO topics and let me know 
> if my client is right or wrong? 
> 
> 

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


Re: RE: CFSELECT - Required

2011-12-13 Thread William Seiter

I would be curious as to what adobe documentation said that is the way to do 
it.  

I guess the classification as a 'bug' would be determined by the definition of 
why that message would launch.

CF does not actually process the form when submitted.  CF creates the 
javascript and form elements and allows the browser to process the HTML event.

Because of this, HTML sees an option in the select statement and says that the 
form field has value (even if that value is empty or just a space)

If, however, you were to create a muli-choice select box, or a select box that 
has 'no options' in it, then the message would react as you are expecting.


The 
 Choose a Value
 One
 Two



--
William E. Seiter


On Dec 13, 2011, Robert Harrison  wrote: 


> The message isn't appearing because your form element has a value.  the blank 
> space is considered a value. 

According to the CF documentation that is how to make it work.   Regardless, it 
also does not work if you say value="" or leave out the value clause 
altogether.   I looked this up on Adobe forums and apparently this has been a 
long-standing bug that Adobe has not addressed. 

Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be &.

Plug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged



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


Re: CFSELECT - Required

2011-12-13 Thread William Seiter

The message isn't appearing because your form element has a value.  the blank 
space is considered a value.

William

--
William E. Seiter


On Dec 13, 2011, Robert Harrison  wrote: 


According to the CF documentation you can make a select list required and you 
can get around the need to set the size gt 1 by entering " " as the value of 
the first option. 

This is the documentation: 

REQUIRED... Note: This attribute has no effect if you omit the size attribute 
or set it to 1, because the browser always submits the displayed item. You can 
work around this issue: format forms by having an initial option tag with 
value=" " (notice the space character between the quotation marks).

This is the code:


Month
January
February
March
More



What am I doing wrong? I just want to get the message when the users selects 
the  "Month"  option. 

Thanks

Robert B. Harrison
Director of Interactive Services
Austin & Williams
125 Kennedy Drive, Suite 100 
Hauppauge NY 11788
P : 631.231.6600 Ext. 119 
F : 631.434.7022
http://www.austin-williams.com 

Great advertising can't be either/or.  It must be &.

Plug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged



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


RE: Amazingly annoying concurrent CFC variable issue

2011-10-15 Thread William Seiter

I was not referring to 'var'ing, I was referring to 'scoping'.

When you create a scope inside of the function, that scope only has value
within that function.

You will want to upgrade the ' GetRecordFromRecordID' to also use scoping as
well.

William

-Original Message-
From: Tavs Dalaa [mailto:j...@dalaa.com] 
Sent: Saturday, October 15, 2011 9:00 AM
To: cf-talk
Subject: Re: Amazingly annoying concurrent CFC variable issue


Makes no difference. As mentioned, I've already tried var'ing within the
functions.


Tavs


>Inside your methods () use scoping.
>
>For example.
>   
>   
>   
>
>   Application.Functions.GetRecordFromRecordID(arguments.RecordID)>
>   
>   
>   
>   
>   
>I've got some pretty simple CFC code which fails when executed with 10+
>concurrent connections. Variables between requests get mixed up, so one
>request with recordID 10 suddenly returns with recordID 2 etc, causing
>issues in the application.
>
>This is simplified version of code:
>
>application.cfm
>
>
>createObject("component","com.ourapp.functions").init() />
>
>functions.cfc
>
>
>   access="public">
>   
>   
>
>   
>   
>   
>   Application.Functions.GetRecordFromRecordID(arguments.RecordID)>
>   
>   
>   
>   
>   
>   
>   returntype="any">
>   
>   
>   datasource="#Application.AppDatasource#">
>   SELECT RecordID,RecordTitle FROM Records
>   WHERE RecordID = value="#arguments.RecordID#" cfsqltype="CF_SQL_NUMERIC">
>   
>   
>   
>   
>
>
>index.cfm
>
>
>
>
>Now, pretty simple, and tons of irrelevant code removed. 
>
>If we fire 50 requests at the same moment to index.cfm, like:
>
>index.cfm?RecordID=1
>index.cfm?RecordID=2
>.. 
>..
>
>.. Then within the DoSomeAction function, we see that 1 out of 25 requests
>on average there's a mixup, we get a result for a different record than the
>one we requested.
>
>Tried to wrap in CFLOCK, eg:
>
>
>   Application.Functions.GetRecordFromRecordID(arguments.RecordID)>
>
>
>.. no diff.
>
>Tried to Var and cflock, ie:
>
>
>   Application.Functions.GetRecordFromRecordID(arguments.RecordID)>
>
>
>Any ideas? 



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


RE: Amazingly annoying concurrent CFC variable issue

2011-10-15 Thread William Seiter

Inside your methods () use scoping.

For example.










-Original Message-
From: Tavs Dalaa [mailto:j...@dalaa.com] 
Sent: Saturday, October 15, 2011 8:47 AM
To: cf-talk
Subject: Amazingly annoying concurrent CFC variable issue


I've got some pretty simple CFC code which fails when executed with 10+
concurrent connections. Variables between requests get mixed up, so one
request with recordID 10 suddenly returns with recordID 2 etc, causing
issues in the application.

This is simplified version of code:

application.cfm




functions.cfc




















SELECT RecordID,RecordTitle FROM Records
WHERE RecordID = 






index.cfm




Now, pretty simple, and tons of irrelevant code removed. 

If we fire 50 requests at the same moment to index.cfm, like:

index.cfm?RecordID=1
index.cfm?RecordID=2
.. 
..

.. Then within the DoSomeAction function, we see that 1 out of 25 requests
on average there's a mixup, we get a result for a different record than the
one we requested.

Tried to wrap in CFLOCK, eg:





.. no diff.

Tried to Var and cflock, ie:





Any ideas? 



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


Re: How CF works

2011-10-14 Thread William Seiter

Post code

--
William Seiter 

On Oct 14, 2011, at 2:09 PM, "Stephens, Larry V"  wrote:

> 
> Thanks. I found the culprit. Odd thing is I've used it on a lot of pages 
> without a problem but this page (and one other) acts up with it.
> 
> It's a third party js library I got from Dynamic Drive several years ago - 
> jumptop.js  Allows the user to jump to the top on a long page. The error is 
> "Warning: an unbalanced tree was written using document.write()causing data 
> from the network to be reparsed."
> 
> I pinpointed the line but don't see the error. I've just taken the library 
> out.
> 
> 
> 
> 
> -Original Message-
> From: Nathan Strutz [mailto:str...@gmail.com] 
> Sent: Friday, October 14, 2011 1:24 AM
> To: cf-talk
> Subject: Re: How CF works
> 
> 
> Larry,
> 
> ColdFusion will not return something different to different browsers unless 
> you explicitly tell it to do so. The most likely culprit here is bad HTML, 
> Javascript and CSS. It sounds like an unclosed (or unopened) table tag, a 
> missing quote on an inline style attribute, or something related. Set a 
> doctype (I like ) and and run the W3C validator or an html 
> lint, then try jslint and csslint, you will find the problem with one of 
> these, and if not, just rewrite the html, remove your table tags except where 
> they are literally needed, separate your styles and javascript from your 
> html, and just spruce things up. If there's something about the page that IE 
> doesn't like (and it wouldn't be the first time), move elements around and 
> play with the stylesheet until it does.
> 
> nathan strutz
> [www.dopefly.com] [hi.im/nathanstrutz] [about.me/nathanstrutz]
> 
> 
> On Thu, Oct 13, 2011 at 7:57 PM, Stephens, Larry V 
> wrote:
> 
>> 
>> I have a page that does a moderately involved query: it returns 16 
>> fields with 3 left joins, a simple WHERE and ORDER. (I'd include it 
>> here but I'm remoting in and can't copy-and-paste). The database is 
>> small - only 40 or so record at this point.
>> 
>> I can see it in Mozilla and IE, with XP and Windows 7. I'm on DSL and 
>> it pops for me almost immediately.
>> 
>> A user, on DSL using IE, complained the page just flashed at her. I 
>> finally duplicated the problem by accident: my laptop started updating 
>> its virus definitions and then the page started flashing at me. These 
>> aren't public pages so I can't give free access.
>> 
>> That user switched to Mozilla and her problem went away.
>> 
>> Next user, same problem. I'm to the point where all I display is a 
>> CFDUMP of the query and one header row of the output. She still can't see it.
>> 
>> So, the user loads the page and a query is sent to the CF server. It 
>> returns a table with 14 columns, a couple of header rows.
>> 
>> So why does it appear to return he menu options and the the beginning 
>> of the table, then send the same thing over and over but never filling 
>> out the table (with only 12-24 rows)? I believe it's because her 
>> machine is too busy to process what the server is sending it but I must be 
>> missing something.
>> Especially since it works in Mozilla but not IE.
>> 
>> Thanks.
>> 
>> 
> 
> 
> 
> 

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


Re: Caching ajax / dhtml

2011-09-13 Thread William Seiter

JavaScript is run on the client side, so unless that JavaScript is pointed to 
your server to get the information...

You will need to find another way. 

--
William Seiter 

On Sep 13, 2011, at 4:12 PM, Matt Williams  wrote:

> 
> I have some divs that are populated with tweet.js (jquery plugin for
> twitter). So on document.ready(), the divs are populated by the
> plugin.
> 
> I don't want to hit twitter on every page load and want to cache the
> populated divs somehow.
> 
> Is there a way to take those populated divs and cache them? Simply
> saving the content to html is still saving the javascript too and not
> the actual output.
> 
> I guess I may have to switch to grabbing the feed using cffeed or
> something, but this code is already done and styled, so I was hoping
> for something else.
> 
> Thanks,
> 
> -Matt
> 
> 

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


RE: Way to "send" data as a form without using a form?

2011-08-21 Thread William Seiter

There are different ways to handle this, posting your form variables into
your subsequent URL variables being one of them.

A few questions to establish what you are actually looking for.
1. The 'conditional' redirect;  Are you redirecting the user to a different
website, or just to a different page on your website?
2. If you are sending the user to a different website, do you have to?  Can
you use cfhttp to call the page on the other site, using your form
variables, and then just display the results to your user on your own site?
3. If you are keeping the user on your own website, does the url have to
change to the 'redirected' page in order for the application to work
properly?  If you are concerned with the url having the form data in it, you
could use a 'main' page that 'includes' a subsequent page (chosen from many)
depending on the form entry's information.
For example.  If it is a 'search page' and the search results would
display differently depending on what was searched.
Main.cfm

[include, method call, etc to have the person search
results display]

[include, method call, etc to have the place search
results display]


If there is a different concept you are trying to create, share the
specifics and I am sure we can point out one or two ways to accomplish it.

William

-Original Message-
From: Pete Ruckelshaus [mailto:pruckelsh...@gmail.com] 
Sent: Sunday, August 21, 2011 11:47 AM
To: cf-talk
Subject: Way to "send" data as a form without using a form?


Hopefully simple question.

I would like to do a conditional redirect from one page to another.  For
some of those conditions, I would like to "send" data along with this
redirect, and I would prefer to not do it via URL parameters.  Is there any
way to "send" data as form values without actually using a form?

Thanks,

Pete




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


RE: SerializeJSON is Undefined

2011-08-13 Thread William Seiter

SerializeJSON was added in CF8

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_21.
html

William

-Original Message-
From: Joshua O'Connor-Rose [mailto:joshua.oconnorr...@gmail.com] 
Sent: Saturday, August 13, 2011 9:45 AM
To: cf-talk
Subject: SerializeJSON is Undefined


I'm worknig through the pains of an inexpensive host that severely
limits CF functionality. I'm setting up ajax for the site and step one
of everything is putting error handling in place.

In any case this is my first cf ajax project and I was adding Bens
ajax error handling and the test cfm file has  this line




I'm getting an error back

Variable SERIALIZEJSON is undefined

the server is CF7

any thoughts



-Joshua O'Connor-Rose
-All is Good



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


Re: loop timing out

2011-06-27 Thread William Seiter

Hey Daniel,

In order to assist you, it would be helpful to see the code that has the loop 
as well as some knowledge of what the 'database call' is doing.  (maybe the 
database call isn't returning?)

The cfsetting that you mention, does only change the timeout setting for the 
page that it is set in.  It does not change the master settings in the cfadmin, 
so it will not effect other pages on your website directly. (this is true from 
CF7 thru CF9, and I would expect any future version of CF as well)

The issue that it appears that you are running into is two-fold.  1.  how many 
'actions' are you looping over combined with 2. how long does it take to 
complete each action.

Setting up a 'grouped' plan to only run x of them is a valid assessment, but I 
would suggest that you do this by tracking which ones need to be redone outside 
of the page.
An example would be, you could have each of the necessary redone's to show up 
in a database table, and mark them as completed once they are done.  The you 
would just need to pull the oldest 5 of them each time you load the page.  
(this would mean the page would have to be loaded more often.

The best solution for you, will probably come after you have posted some more 
information (the loop code and 'what' the action is doing)

hope this helps,
William


--
William E. Seiter


On Jun 27, 2011, daniel kessler  wrote: 


I'm creating a scheduled_task to correct a problem.  For the correction, I'm 
doing a query for the list of problem records.  Then I'm looping through the 
problem records and resending each one of them through the same code that it 
went through when it developed the problem.  That code has several database 
updates.  

Unfortunately, I'm timing out of the cfloop.  I don't have access to the page 
that I'm looping through, so I can't change it.

Is there a way to let a loop have other transactions so that it doesn't time 
out?  I thought of putting the loop in another loop, so that it only does 5 at 
a time, but then that's just a loop in a loop and then the outer one will time 
out.

Did I state this clearly?

A friend of mine suggested the line:
cfsetting requestTimeOut = "120”
I am told that this setting will only be persistent for that page and that the 
timeout will revert to it's previous setting once the page is done running.  Is 
that correct?  I was also concerned that when CF is upgraded (we're on CF7 for 
this app) that this setting might be trouble.  Any thoughts?  Overall, I'd like 
a different solution than this, something that will make the loop more 
acceptable.

thank you for any assistance.

daniel



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


RE: DateDiff Weirdness/Possible bug

2011-06-09 Thread William Seiter

It looks like the times are off by 1 hour.  Did you check your server's
clocks to make sure they are both set to the same time?



-Original Message-
From: Ruslan Sivak [mailto:cfli...@ruslansivak.com] 
Sent: Thursday, June 09, 2011 9:43 PM
To: cf-talk
Subject: DateDiff Weirdness/Possible bug


I'm having trouble with different results for DateDiff between CF and SQL
Server.  I'm guessing it has something to do with DST, but it seems that CF
is doing it wrong.

Doing a SQL Query like this:

select DateDiff(s,'1/1/1970','6/1/2011') as datediff

I get 1306886400.

Doing



I get 1306882800.

Converting SQL's result back to Date using CF:

#dateAdd('s',1306886400,'1/1/1970')#

I get  {ts '2011-06-01 01:00:00'}

According to http://www.epochconverter.com/, 1306886400 is the correct
number of seconds for midnight on June 1st, 2011.

Is there a reason that CF is returning the wrong number of seconds?

Russ




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


RE: Problem Using QueryNew

2011-04-23 Thread William Seiter

You are using a simple cfloop from to, instead of a cfquery or a cfloop
query.

Because of this, when you call "#stockTable.stockTitle#", it defaults to the
first line of the query.

Either change your loop to a cfloop query="stockTable">
Or change your data call to "#stockTable.stockTitle[R]#"

William

-Original Message-
From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] 
Sent: Saturday, April 23, 2011 9:45 AM
To: cf-talk
Subject: Problem Using QueryNew


My first time using created queries, I can't understand why this is putting
the same value on every row.










#stock.stockTitle#

No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.894 / Virus Database: 271.1.1/3591 - Release Date: 04/23/11
07:36:00





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


Re: Re: file upload - preventing double or more full stops in file name

2011-03-07 Thread William Seiter

Please have a look at this post: 
http://www.williamoncoldfusion.com/index.php/knowledgebase/file-uploading

If you are referring to the cffile.serverfilename key that is available after 
the cffile upload command, that brings back somefile.mack, the extension is in 
a different key off of cffile of serverfileext.  checkout this page as well: 
http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=Tags_f_10.html


--
William E. Seiter


On Mar 7, 2011, Don  wrote: 


> > Why do you need to do this before you process it with CFFILE?

Because once its uploaded the server hacks off the last (.)

For example:

original file: somefile.mack.txt

renamed file on server: somefile.mack


> > I would like to retrieve the original path of the file upload for 
> the purposes of grabbing the initial file name and then checking to 
> see how many full
> > stops (.) are in the original file.
> >
> > I need this to happen before I process it via . Right now 
> the form data posts back in a  b_original_form_filefield#>
> > as:
> >
> > C:\JRun4\servers\cfusion25\SERVER-INF\temp\cfusion.
> war-tmp\neotmp4910092545170934955.tmp
> >
> > which is sort of useless for my needs.
> >
> > Is there a workaround?
> 
> Why do you need to do this before you process it with CFFILE? All 
> that
> happens when you use CFFILE ACTION="UPLOAD" is that CF writes the 
> file
> to a specified location on the filesystem. The file has already been
> received by the web server, and stored in a temporary file location.
> So, write the file to the filesystem in one place, then move it
> somewhere else with a subsequent CFFILE if you really want to.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> http://training.figleaf.com/
> 
> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
> GSA Schedule, and provides the highest caliber vendor-authorized
> instruction at our training centers, online, or onsite.




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


Re: RE: Database Lookup - Possible with CF?

2011-03-03 Thread William Seiter

Curious...   Where are you that they are moving away from CF onto .NET and 
Java(ADF)?


--
William E. Seiter


On Mar 3, 2011, Ian Vaughan  wrote: 


Hi Dave

I'm willing to give CF a go, even though here the move is away from CF
onto .NET and Java (ADF)

Do you have any step by step tutorials that I could follow that I can
use to implement the feature below in CF, if they can see what it can do
it would certainly help its case.

All I am looking to do is when a user fills in their employee number in
a form text field, ajax calls CF to run a SQL query to bring back and
populate the other fields in the form with that employees info.

Is it really that difficult to achieve the above?  Are there any
ajax/jquery libraries I could use to integrate in with CF because
javascript is not be strong point

-Original Message-
From: Dave Watts [mailto:dwa...@figleaf.com] 
Sent: 03 March 2011 15:02
To: cf-talk
Subject: Re: Database Lookup - Possible with CF?


> So would I be better developing this application in a language that is
> more scaleable/future proof than CF

You won't be using ASP.NET then, right? Because (a) it's not more
scalable, and (b) any platform effectively limited to Windows is not
more future-proof. I mean, I could see your point if you were talking
about Java, even if I'd quibble on the scalability bit.

Having worked with some high-scalability clients, I am very confident
that CF is as scalable as .NET. I've mentioned them on the list
before, so I'm not going to bother enumerating them now, but I'll be
happy to provide further details on request.

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

Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
GSA Schedule, and provides the highest caliber vendor-authorized
instruction at our training centers, online, or onsite.





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


Re: Re: Re: Re: Change in ColdFusion management

2011-02-14 Thread William Seiter

Were you ever 'off' the list of skeptics?

--
William E. Seiter


On Feb 14, 2011, jqdur...@gmail.com wrote: 


I'll believe it [Adobe's renewed commitment] when I see it. And,  
apparently, that won't be a for a long time. For now, put me on the list of  
skeptics.

On Feb 14, 2011 1:53pm, William Seiter  wrote:


> Got it, thanks everyone for the google cache link... must be a bad brain  
> day monday for me ;)



> William

> --

> William E. Seiter





> On Feb 14, 2011, cft...@fusionlink.com wrote:





> It's cached by Google..



> http://webcache.googleusercontent.com/search?q=cache:3G9LdiSkodEJ:www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion+http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion&cd=1&hl=en&ct=clnk&gl=us&client=safari&source=www.google.com





> - Original Message -

> From: William Seiter [mailto:will...@seiter.com]

> To: cf-talk@houseoffusion.com

> Sent: Mon, 14 Feb 2011 19:08:14 + (GMT)

> Subject: Re: Change in ColdFusion management





> Anyone have Adam's announcement? I keep trying to access it and get a  
> blank page.



> Thanks,

> William



> --

> William E. Seiter





> On Feb 14, 2011, cft...@fusionlink.com wrote:





> In case people don't know and many may not due to the way it was  
> announced late last friday, there is a debate going on with the recent  
> change in Adobe's management of Coldfusion. Whether you agree with my  
> concerns or not, it's important that everyone get a chance to voice their  
> opinions on this.



> Here a the blog posts to look at...



> Adam's announcement

> http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion



> My reaction

> -there"  
> target="_blank">http://www.codfusion.com/blog/post.cfm/so-there-s-this-story-about-a-frog-in-boiling-water

> -there are comments that add additional problems to this move



> Brian Meloche's reaction

> http://www.brianmeloche.com/blog/index.cfm/2011/2/12/End-of-another-era



> John

> ma...@fusionlink.com

> twitter: john_mason_



















> 



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


Re: Re: Change in ColdFusion management

2011-02-14 Thread William Seiter

Got it, thanks everyone for the google cache link...  must be a bad brain day 
monday for me  ;)

William
--
William E. Seiter


On Feb 14, 2011, cft...@fusionlink.com wrote: 


It's cached by Google..

http://webcache.googleusercontent.com/search?q=cache:3G9LdiSkodEJ:www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion+http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion&cd=1&hl=en&ct=clnk&gl=us&client=safari&source=www.google.com


- Original Message -
From: William Seiter [mailto:will...@seiter.com]
To: cf-talk@houseoffusion.com
Sent: Mon, 14 Feb 2011 19:08:14 + (GMT)
Subject: Re: Change in ColdFusion management


Anyone have Adam's announcement?  I keep trying to access it and get a blank 
page.

Thanks,
William

--
William E. Seiter


On Feb 14, 2011, cft...@fusionlink.com wrote: 


In case people don't know and many may not due to the way it was announced late 
last friday, there is a debate going on with the recent change in Adobe's 
management of Coldfusion. Whether you agree with my concerns or not, it's 
important that everyone get a chance to voice their opinions on this.

Here a the blog posts to look at...

Adam's announcement
http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion

My reaction
http://www.codfusion.com/blog/post.cfm/so-there-s-this-story-about-a-frog-in-boiling-water
-there are comments that add additional problems to this move

Brian Meloche's reaction
http://www.brianmeloche.com/blog/index.cfm/2011/2/12/End-of-another-era

John
ma...@fusionlink.com 
twitter: john_mason_









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


Re: Change in ColdFusion management

2011-02-14 Thread William Seiter

Anyone have Adam's announcement?  I keep trying to access it and get a blank 
page.

Thanks,
William

--
William E. Seiter


On Feb 14, 2011, cft...@fusionlink.com wrote: 


In case people don't know and many may not due to the way it was announced late 
last friday, there is a debate going on with the recent change in Adobe's 
management of Coldfusion. Whether you agree with my concerns or not, it's 
important that everyone get a chance to voice their opinions on this.

Here a the blog posts to look at...

Adam's announcement
http://www.adrocknaphobia.com/post.cfm/the-modern-age-of-coldfusion

My reaction
http://www.codfusion.com/blog/post.cfm/so-there-s-this-story-about-a-frog-in-boiling-water
-there are comments that add additional problems to this move

Brian Meloche's reaction
http://www.brianmeloche.com/blog/index.cfm/2011/2/12/End-of-another-era

John
ma...@fusionlink.com 
twitter: john_mason_





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


Re: Multiple applications with a single codebase issues

2011-02-08 Thread William Seiter

I had a similar issue that came up a couple of years ago for me.  As it turned 
out I had the name of the application the same across all of the sites, so the 
application variables weren't unique to each site.


--
William E. Seiter


On Feb 8, 2011, Pete Ruckelshaus  wrote: 


I'm having a bit of an issue here.

Over time, I have developed a CF web-based content management system (hey,
who hasn't?).  The software is currently running a handful of sites, all on
different web hosts.  It works fine in this mode.

Recently, I realized that I could get a VPS for less money than the several
web hosting accounts I'm using; this would have the added benefit of
allowing me to update the core software in one location rather than in
several.

I have it set up so that IIS sees the root directory of the CMS software as
each web sites' root, and then I set up a virtual directory to the
site-specific content for each domain.  For instance,
c:\inetpub\wwwroot\app\core is set as the root directory; in it, I have an
application.cfc file that sets up variables, security, etc.  For
site-specific stuff in the application.cfc, I am including a file that sets
the app name, etc. before the onApplicationStart() runs.

I then have the site-specific stuff (templates, config files, etc.) in
separate directory paths, each set up mapped to /site as virtual directories
for their respective web sites.

The problem I am having is that application.applicationname is being set to
whatever site loads first; i.e., I have SiteA and SiteB set up in IIS,
restart CF, and if I load SiteB first, then SiteA has SiteB's
application.applicationname value.

This is a problem.

Has anyone here tried to do this and succeeded?  Or do I need to rethink how
I have this site architected?

Thanks,

Pete




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


RE: Coldfusion Hosting

2011-01-28 Thread William Seiter

Yeah, you're dreaming.  But you can check out gearhost.com.  I moved to them
a couple years ago and have never had a problem creating robust OO based
coldfusion 8 websites there.

William

-Original Message-
From: Adam Bourg [mailto:adam.bo...@gmail.com] 
Sent: Friday, January 28, 2011 10:49 AM
To: cf-talk
Subject: Coldfusion Hosting


Can anyone recommend a decent yet cheap web host for ColdFusion? 

Right now I'm hosting my site at DreamHost (Simple wordpress as CMS site). 

I'm looking for
SQL
PHP 5
and Coldfusion 8 support
all under $6. 

Am I dreaming? 



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


Re: http://mail.seiter.com/webmail/driver?nimlet=showcanvas#Lions, Tigers and Images, Oh My!

2010-10-12 Thread William Seiter

http://www.williamoncoldfusion.com/index.php/knowledgebase/file-uploading


--
William E. Seiter


On Oct 12, 2010, Everett Alexander  wrote: 


Hello,

I have a an form that will be updating a database for creating webpages. That 
form will need to upload images (along with various other fields, text, etc.) 
to a server. So I want to point to a specific folder on the server to upload 
images, and then reference that location in the database.

Currently, when I upload an image, I get this in the database field:

/opt/jrun4/servers/DISCOVERY/SERVER-INF/temp/cfusion.war-tmp/neotmp2153518236327741178.tmp

When it should be this:

/images/news/volcanos.jpg


Any tips or direction?

Thanks in advance... 



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


Re: How to point to a Directory?

2010-10-04 Thread William Seiter

AIR is not the only method, but you can't get it done with just html. You will 
need A java applet or flash or air or some other program that can talk to the 
system as well as your app.

--
William Seiter 

On Oct 4, 2010, at 4:39 PM, Gonzo Rock  wrote:

> 
> Well the purpose is to capture and store the Directory as part of a
> configuration routine. Then days in the future other users of the
> application will trigger it to process some datafiles... but
> coldfusion needs to know where those datafiles are located.  The
> current user has no idea where they are stored... they just want the
> files in the directory processed.
> 
> Currently during the configuration session we can capture it by making
> them point to a file in the directory and then stripping the actual
> file name from the network path they navigated down... however how to
> do this when there is NO file in the directory for them to use while
> configuring the Directory Location for future use... that is the
> problem... which Dave suggests can only be solved using AIR :-(
> 
> On Mon, Oct 4, 2010 at 4:18 PM, Russ Michaels  wrote:
>> 
>> also u do not need to remember the path as this is the default behaviour of
>> windows. When you open a browse window it always takes you to the last
>> location you used.
>> 
>> On Tue, Oct 5, 2010 at 12:15 AM, Dave Watts  wrote:
>> 
>>> 
>>>> Using >>> but how do you let the user browse and point to a Directory?
>>>> 
>>>> I am trying to figure out how to let a user browse to a particular
>>>> directory location on their network and then capture that location for
>>>> future use.  In this instance the application will always look in this
>>>> location for files that it needs to process for the user.
>>> 
>>> There's nothing built into HTML to capture a directory path. Also,
>>> browsers won't let you store a directory path for later use, for
>>> security reasons - the user always has to choose the file directly.
>>> 
>>> Adobe AIR is a nice alternative here. Downloadable applications can do
>>> all sorts of things that browsers won't allow.
>>> 
>>> Dave Watts, CTO, Fig Leaf Software
>>> http://www.figleaf.com/
>>> http://training.figleaf.com/
>>> 
>>> Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on
>>> GSA Schedule, and provides the highest caliber vendor-authorized
>>> instruction at our training centers, online, or onsite
>>> 
>>> 
>> 
>> 
> 
> 

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


Re: Re: sending a form through CF and catching the results

2010-08-26 Thread William Seiter

The page you are trying to hit with cfhttp is expecting a numeric value for 
'di_20156'.

try changing the value in your script from "SPHL-School of Public Health" to 
"20"

William



--
William E. Seiter


On Aug 26, 2010, daniel kessler  wrote: 


>Seems like the error isn't really giving much help.
>
>
>Can you get full debugging from that error on jobs.cfm?
>Can we see the code on and around line 346 of jobs.cfm?


How would I get the full error?  
The code on and around 346 is the block of code that I posted last.
https://jobs.umd.edu/applicants/jsp/shared/search/SearchResults_css.jsp"; 
  columns="di_0_20156" name="blah" port="443"
>
  




Line 346 is the:

though as pointed out earlier, the value should be "20" 



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


West Side Rentals

2010-07-11 Thread William Seiter

Hey,

Does anyone know who is the developer or involved with IT at Westside
Rentals in Los Angeles?

Contact me offline.  William [at] Seiter [dot] com

Thanks,
William


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


Re: Seriously PO'd - cfqueryparam and/or struct dereference flakes out

2010-06-24 Thread William Seiter

When CF throws an error on a stored proc, it will usually reference the last 
line of the stored proc, not necessarily which line has bad data.

If I were you, I would dump the values that are being sent into the stored proc 
and review to see if any of it is null or blank (or string) going into any of 
the integer declared procparams.

Hope this helps,
William


--
William E. Seiter


On Jun 24, 2010, Marc Funaro  wrote: 


The function below was written literally MONTHS ago.  Worked fine the whole 
time, even today... then suddenly it's throwing the error:

"Invalid data '' for CFSQLTYPE CF_SQL_INTEGER."

The error points to the line in the WHERE clause, referencing a.articleId.

Next, I purposely set the output="true" on this function, and did a cfdump of 
#a.articleId# -- it's definitely a valid integer.  but it's now choking on it 
for some reason.

as a test, i hard coded an article id into the where clause, removing the 
cfqueryparam.  with a hard coded number, it chokes on the next cfqueryparam up. 
 if i reference #a.articleId# directly (outside of cfqueryparam), I also get 
the same error.  how can a.articleId suddenly become '' right after dumping it 
and successfully showing it to be an integer??

I've restarted both the cf server and the database server, wondering if there 
was some sort of strange hangup there... no joy.

I'm losing my mind... help!!
















UPDATE
Article

SET
categoryId = ,
title = ,
byLine = ,
imageId = ,
imageCaption = ,
abstract = ,
body = ,
isLead = ,
publishDateTime = 

WHERE
articleId = 



 



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


Re: list of declared functions

2010-06-18 Thread William Seiter

this can be built rather simply.

1.  add to your Application.cfc in the OnRequestStart function 
   
2.  change all of your functions to read like this:


   your function declaration
   


this way you can call a function to your hearts content, but it will only load 
if it wasn't already loaded.

hope this helps,
William
--
William E. Seiter


On Jun 18, 2010, daniel kessler  wrote: 


I am receiving the error "Routines cannot be declared more than once", which is 
true.  This function can be declared in multiple places so it's sort of 
difficult to track.

Is there a way I can test and check whether a function is already declared 
(please say "yes, it's easy"?  Can I query for a list of declared functions?  
Also, this is on a shared hosting server, if that makes any difference.


thanks! 



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


RE: How to loop over a dataset twice.

2010-06-08 Thread William Seiter

We will need to see more of the code. 
If the second loop doesn't work then there is probably something in the code 
that is stopping your action.
Once the query has been created, it will persist until it is erased by the code.

-Original Message-
From: Dave Hatz 
Sent: Tuesday, June 08, 2010 5:45 PM
To: cf-talk 
Subject: How to loop over a dataset twice.


I am trying to loop over a dataset twice.  I am trying using CFLOOP but the 2nd 
CFLOOP will not process.  


  select first,last from name


//loop through DataSet 1st time

 


//Now I want to loop through the DataSet a 2nd time

 .


How do I get the 2nd cfloop to loop over the DataSet without calling the query 
again?

Thanks,
Dave 



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


Re: Redirect question

2010-06-02 Thread William Seiter

The easiest way I can think of would be to change the page name from:
http://www.domain.com/acme.cfm
to:
http://www.domain.com/acme/index.cfm

Your 'http://www.domain.com/acme' call would automatically call the index.cfm 
page, and it will be easier for future maintenance needs.

William



--
William E. Seiter


On Jun 2, 2010, Donnie Carvajal  wrote: 


I have a client that would like to send out URLs without .cfm.  For example, 
there is a page in the website called acme.cfm.  To access the page, a visitor 
would go to http://www.domain.com/acme.cfm.  The client would like to also 
access acme.cfm by the following URL: http://www.domain.com/acme.  We are on 
Windows and IIS 6.  Has anybody ever done anything like this before?  It seems 
that there would need to be an ISAPI filter or maybe have a custom error 
redirect or some setting change in IIS.  I can write Coldfusion code for this, 
but that means I would have to create folder for every page and drop this CF 
code in the folder as the default and redirect to the acme.cfm page.  I would 
like to avoid creating thousands of folders, just for this redirect.

All help is appreciated.

Thanks,

Donnie 



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


RE: Comma delimited list

2010-05-28 Thread William Seiter

Break out the comma dilimited list into a cross ref table then you query the 
tables with an inner join to get the features.

-Original Message-
From: Bill Hartley 
Sent: Friday, May 28, 2010 7:37 PM
To: cf-talk 
Subject: Comma delimited list


I am trying to display feature codes from a comma delimited list inside a 
database.  Here is my setup:

Table: Listings has a column called FEATURE_CODES and example of the data in 
this column is "B01,E09,E20,G12,J07"

Then I have another table inside the same database called FeatureCodes the data 
inside this table is arranged
FEATURE_CODE FEATURE_DESCRIPTION
B01  Sold As Is
E09  Frame and Stucco
and so on
I need to display the feature description from the FeatureCodes table on the 
display page by reading the feature_codes from the listing table

Any Suggestions?? Please!! 



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


Re: How to make a select option tag selected in CF?

2010-05-27 Thread William Seiter

on page load, to default to the previously saved data...
selected="selected">Choose
>From Below
and 
checked="checked" />Not Applicable

if, however, you are having a problem where this isn't working for you, then 
you probably are experiencing 'persistent form choices'.
This would not be a problem with the code, but with the local browser.  best 
way to reload the defaults would be to hold down the 'ctrl' button and press 
the 'f5' button.  This will do a 'hard refresh' of the browser, hopefully 
erasing any persisting data selections.
William
--
William E. Seiter


On May 27, 2010, Phillip Perry  wrote: 


Hi,

I am making a form and I would like to have the user review the form
answers before it gets sent to the processing template. I know how to
populate all the other things but the drop down list and the radio
buttons are confusing me. It's been a while since I used CF for this
so I forget. Below is the select and radio button form fields:


Choose
>From Below
Clothing Store
Sporting Goods Store
Hobby Shop
Computer Related Sales
Medical Profession
Grocery Store
Printed Publications
Accounting Firm
Utilities Company
Other



Personal
Business
Not Applicable

How do I make these 2 selected/checked when the user submits the form?

Thanks for the help.

Phil



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


Re: FIXED: cflock and cfloop question

2010-05-26 Thread William Seiter

Please be sure to post the fix that was used so that persons using the archive 
in the future will be able to troubleshoot their stuff as well.

William


--
William E. Seiter


On May 26, 2010, cfcom  wrote: 


ISSUE IS FIXED - THANKS EVERYONE!




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


RE: Need CF help- is anyone available

2010-05-25 Thread William Seiter

It sounds like the images were moved to their new homes, but the site code
might still be pointing to the old location.  Or the old location isn't
accessible to the new site.

If the code is pointing to an image that does exist, take a look at the
permissions on the directory to verify that your site has access to files
there.

Hope this helps,
William

-Original Message-
From: cfcom [mailto:cf...@aceligent.com] 
Sent: Tuesday, May 25, 2010 2:28 PM
To: cf-talk
Subject: RE: Need CF help- is anyone available


We have a legacy site that was originally written without error handling.
Yesterday the old programmer ran a script to clear out the images folder
that had grown to 20 gigs. He set up a new image folder but all the images
stopped showing up in queries. We've spent all day chasing down globals but
it keeps throwing errors and the pictures aren't showing up. 

Heres notes from what the old programmer did: wrote a script to break up the
directory in to smaller directories.  The created 900 subdirectories inside
a new folder called images_new  The image 90031_7.jpg will be in the folder
"images_houses_new\900\" because it begins with 900.  then put a url
redirect on the original directory to redirect any 404 errors to a script
which will try to find the correct image. also threw the file
Directorybreaker.exe into the root dir of the e drive.  running it with the
old dir as param one and the new drive as param two will break up any new
images. only updated the listings pages. His note goes on to something about
creating an object called Image.cfc and then extend that to HouseImages.cfc 

With the exception of the images-folder too big before he touched the code
we had most things functioning and now they are not. - any help would be
greatly appreciated.

>
> -Original Message-
> From: Phillip Vector [mailto:vec...@mostdeadlygame.com]
> Sent: 2010-05-25 16:50
> To: cf-talk
> Subject: Re: Need CF help- is anyone available
>
>
> The best solution is to ask directly here. It allows for allot of
> people to help.
>
> So what's the issue?
>
> On Tue, May 25, 2010 at 1:47 PM, cfcom  wrote:
>>
>> Having serious problem with a piece of code
>> Is there anyone who could take a look
>> Been racking my head on this all day
>>
>> Please contact off list
>>
>> And thank you in advane
>>
>>
>>
>
> 



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


RE: idea paint

2010-05-22 Thread William Seiter

I am not certain the reason for the link, but that website is one of the worst 
i've seen recently when viewed from my smartphone browser.

william

-Original Message-
From: Brian Thornton 
Sent: Friday, May 21, 2010 8:27 PM
To: cf-talk 
Subject: idea paint


http://www.ideapaint.com/work/installation/

-- 
Brian Thornton
(303) 997-1777



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


Re: Re: Re: Adobe ColdFusion Anthology released

2010-05-20 Thread William Seiter

good to know, 
Thanks!
--
William E. Seiter


On May 20, 2010, Sean Corfield  wrote: 


On Mon, May 17, 2010 at 1:25 PM, William Seiter  wrote:
> I bought mine through amazon a couple weeks ago.  Can you let us know what 
> was wrong with the original so that we can verify we didn't receive a 
> corrupted copy?

Chapter 7 is missing (and the 'Part 2' intro page appears between
chapters 6 & 8 instead of 5 & 6 and the 'Part 3' intro page is missing
- it should be between 7 & 8).

Apress are reprinting this week or next week and will be shipping new
copies shortly after. They seem to be making quite an effort to recall
all the faulty copies.

If you get a misprinted version, go back to the seller and ask them to
replace it with a reprinted copy. If that fails, contact Apress
directly.
-- 
Sean A Corfield -- (904) 302-SEAN
Railo Technologies, Inc. -- http://getrailo.com/
An Architect's View -- http://corfield.org/

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwoo



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


Re: Re: CF 9 Hosting

2010-05-20 Thread William Seiter

I wouldn't use them anymore at all, if they had told one of my clients that.

William


--
William E. Seiter


On May 20, 2010, Dawn Sekel  wrote: 


I have used them for years too -- but I have recently had a really bad 
experience with them.  I signed one of my new customers up under a shared 
hosting account -- just a small application.  The server he was on kept 
crashing.  Their technical support told him that the problem was Coldfusion and 
that he needed to switch to another technology.  They said Coldfusion is going 
out of business and know one uses it any more.  Anyway -- I don't user them any 
more for my smaller customers that can't afford a dedicated server. 

>I'll +1 for CrystalTech. I've been using them for years.
>
>Thanks,
>
>Eric Cobb
>ECAR Technologies, LLC
>http://www.ecartech.com
>http://www.cfgears.com
>
>
>
>Alan Rother wrote:
>> 



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


Re: CF 9 Hosting

2010-05-20 Thread William Seiter

GearHost has all of their servers on CF9.  I just spoke to Adam Patton in sales 
who confirmed that the servers are updated, but the website hasn't been yet.

http://www.gearhost.com/hosting/shared/coldfusion/

William


--
William E. Seiter


On May 20, 2010, Kelly Matthews  wrote: 


Anyone know any good, reasonable CF 9 hosting companies w/ mysql. 
Thanks! 



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


Re: Re: Adobe ColdFusion Anthology released

2010-05-17 Thread William Seiter

I bought mine through amazon a couple weeks ago.  Can you let us know what was 
wrong with the original so that we can verify we didn't receive a corrupted 
copy?

Thanks, 
William


--
William E. Seiter


On May 17, 2010, Reed Powell  wrote: 


Mike:  2 copies just arrived to give out at my next UG meeting - from leafing 
through it looks great!  I got an email a few minutes ago from the publisher 
telling me that 2 reprinted copies are on their way because of some printing 
error in the first ones.  Any concrete info available on just what was changed? 
 Is it so bad I shouldn't give away those copies?
thanks,
-reed 



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


Re: Re: Anyone done this before???

2010-05-07 Thread William Seiter

I am confused as to what language they changed on you?

the database?  the report scripting language? the web server language?

as far as pass the id, it will all depend on what your system actually looks 
like and what you are trying to accomplish.  

I would suggest that you give us a longer, more detailed, description of what 
you have there, and what you want to do with it, or you hire a professional CF 
consultant to take a look at what you have and devise a blueprint on how to get 
to where you want to go.

Thanks,
William

--
William E. Seiter


On May 7, 2010, Stephen Hoskins  wrote: 


There are about 5,000 reports with conditional statements in VB script.  I 
started creating pdfs and was going to use cfdirectory to parse through them.  
After spending a day creating 1,000 of them manually, they changed the language 
on me.  

Im suprised there isnt a way to pass the id and pull up each report in CF.  



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


Re: Anyone done this before???

2010-05-07 Thread William Seiter

Having very little knowledge of MS Access for the web, can you have the report 
output to a static table, where the web page reads the data from the table, and 
the report runs hourly, or more/less often?  Or, can you port the report 
functionality to a 'view' and have the web page read its data from the view?

William


--
William E. Seiter


On May 7, 2010, Stephen Hoskins  wrote: 


I have a pretty complex MS Access report that takes in an ID and outputs a 
report, how the heck can I get this to run online???  

Im poking through cfexecute but no luck yet. 



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


RE: query for experts?

2010-05-05 Thread William Seiter

Is this just a list of price breaks where the single item price is in a
different table?


--
William E. Seiter

-Original Message-
From: Mike Little [mailto:m...@nzsolutions.co.nz] 
Sent: Wednesday, May 05, 2010 8:49 PM
To: cf-talk
Subject: Re: query for experts?


william that would be ideal. my problem is that the client inputs their own
price breaks. most of their products require a minimum greater than 1.

azadi, i have done the following and it still outputs some odd results
(using a cart qty of 4 to test)...

SELECT FLOOR(product_price * CEILING(4 / product_min)) AS price
FROM tblPricing
WHERE 1=1

(i am using mySQL by the way) 



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


RE: query for experts?

2010-05-05 Thread William Seiter

I think I am a bit confused as to what your scenario is...

Is 5 the minimum a customer can purchase?

If they order 5 or more, is $12 their price, or if they order 1-5 it is $12?

If the pricing is for 1-5 = $12 each, then I think you can adjust your table
a little to get the proper results.
Add a row, 1, 12.00
Change 5, 12 to 6, 11.55
And so on.  Then you can use your example query to pull the correct data.  

Also, the 'price' should be a number (without the $ sign).  It will make it
easier to use the number for multiplying with later.

William

--
William E. Seiter
-Original Message-
From: Mike Little [mailto:m...@nzsolutions.co.nz] 
Sent: Wednesday, May 05, 2010 5:12 PM
To: cf-talk
Subject: query for experts?


hey guys, hopefully an easy one...

tblPricing
--
min_qty (INT)
price 

a product has the following rows...
5, $12.00
10, $11.55

the customer adds a quantity of 4 to their cart. how do i establish that the
price should be $12.00?

existing query would be...

SELECT price
FROM tblPricing
WHERE product_min <= cart.qty
ORDER BY product_min DESC
LIMIT 1;

doesn't work in this case.

mike 



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


Re: cfform won't submit

2010-05-04 Thread William Seiter

Without seeing your full application, my assumption would be that the code that 
is running (after the username unique validation) is not returning to the 
browser any data.  I would take a look at any querries you are running and 
possibly add a timeout to them so you can see if they are running, unusually 
long.

William


--
William E. Seiter


On May 4, 2010, Steve Logan  wrote: 


I must be missing something obvious here.  I have a simple user enrollment form 
that submits fine on the first submit, but can't seem to be submitted a 2nd 
time.  There is no submit once validation.  For example, if I test it with a 
username that I know is in use, it quickly submits and generates and error 
message stating that the username is in use.  If I select a username that's 
good and resubmit, it just hangs.  In the browser status bar it simple sits at 
"waiting for test.server.com" until it times out with a connection reset error. 
 I installed a Firefox plugin to watch the HTTP traffic and it seems to confirm 
that there's no response from the server on the 2nd submit.  Yet if I open up 
countless new browsers and tabs, the server is working fine.

Any ideas?? 



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


RE: question ("null" attribute)

2010-05-04 Thread William Seiter

You can do nested iif, but not a full cfif/cfelseif/cfelse

-Original Message-
From: Matthew Lowrey 
Sent: Tuesday, May 04, 2010 12:26 PM
To: cf-talk 
Subject: Re:  question ("null" attribute)


Sean, I'm pretty sure I already know this answer, but now that you've brought 
this new way of thinking to my attention.  I'm going to place my cards on the 
table here and ask the million dollar question.  Is it possible to have a 
cfelseif in this param? :-D  I know... I have a pair of 4's... not likely to 
beat your cards haha

Matt...

> YA  SEAN WINS THE PRIZE!! Thank you Mr. 
> Corfield.  This worked beautifully and better yet I didn't have to set 
> anything or cfif anything, just one tag with everything all inside of 
> it.  Thanks a million x yourVal
> 
> Matt...
> 
> > Since you're on CF9:
> > 
> >  > null="#!isDefined('form.myVar')#" />
> > 
> > The (new in CF9) ?: operator only evaluates the true-expr if the
> > condition is true.
> > 
> > On Mon, May 3, 2010 at 8:12 AM, Matthew Lowrey  
> > wrote:
> > > This is getting to be quite an interesting challenge.  All the 
> > examples I've seen logically make sense but none of them have worked 
> 
> > so far.  I will say I'm learning quite a bit from everyone's 
> > knowledge/wisdom.  I will try and list here all the different 
> methods 
> > I've tried out and have failed.  First, the method I've used (and 
> > still using):
> > >
> > >  > cfsqltype="cf_sql_varchar" value="#form.myVal#" 
> > maxlength="50">http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:29
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Re: Using two submit buttons to control form action

2010-04-29 Thread William Seiter

When using a regular HTML form, we rely on the browser to act like a regular 
browser.  Only the 'activated' elements of a form are sent.  Form elements with 
the same name and are 'activated' will be received by the server as a 
comma-delimited list.

In a regular form, only the button that is pressed is 'activated' so your 
scenario works correctly.

Now enter into the world of cfwindow/cfform.  These two tag-groups are 
extremely powerful, but do cause some changes in the way the form is processed.

As you mentioned, when you changed your cfform to a regular form, it worked 
correctly, but you lost the 'keep in the cfwindow' functionality.

Cfform and cfwindow appears to work together to submit forms via AJAX.  The 
script probably compiles the form in the usual manner, any field with an active 
value are sent to the server.  The ajax probably identifies the button that was 
pressed, by its name, and then gathers the values for that 'named field'

In this case, you can achieve your needs in 1 of 2 ways (probably a lot more, 
but working on little sleep here).

1.  make your buttons unique names, and parse on the server side based on the 
button that was pressed.
2.  create an additional hidden field, when one of the buttons is pressed, pass 
the value of the pressed button to the hidden field using javascript, and have 
your server check the value of the hidden field, instead of the button.


Hope this helps,

William

--
William E. Seiter


On Apr 29, 2010, John Pullam  wrote: 


Thanx for all the feedback. I'm about 95% sure that I've done all this before 
and made it work. And the examples given have been tried too. There must be 
something different in my case. This simple use of 2 buttons on a page worked 
for me. But when I put it back into the live case it fails, so I think I am 
missing something there. 

I have trimmed out irrelevant code in an attempt to get this down to a basic 
test but still it fails showing me a string that has both button names (it 
didn't do this when I started with a single page). My case includes a cfwindow, 
so there are 2 bits of code below ... the page and the window.

The calling page: ...


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333244
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: RE: storing a cfinput inside of a variable

2010-04-08 Thread William Seiter

Hey Steve,

Can you tell us what the bigger picture is, what is it that you are trying to 
accomplish by saving the cfinput in a variable?

 wrote: 


The only option would be to evaluate the variable, and even that might not
work:


#Evaluate(config.formFieldA)#


-Original Message-
From: Steve Logan [mailto:st...@sagescholars.com] 
Sent: Thursday, April 08, 2010 1:37 PM
To: cf-talk
Subject: storing a cfinput inside of a variable


Is there anyway to use cfset or cfsavecontent to store a complete cfinput
tag?

i.e.

"/>

If I do a view source, I see it the code on my output page, but it won't
render at all in the browser.

If I try cfsavecontent it errors because the cfinput isn't in a cfform
(since the cfinput is in a CFC being called by the form page).

The reason for this is that this one form field could have different max
lengths, validations, validation patterns, and messages based on a variety
of factors.  If I can move the input into a CFC that returns all sorts of
other partner specific info, it keeps me to having just one space to enter
config data. 





~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332806
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: Re: FileExists using variable - not working

2010-04-08 Thread William Seiter

try:


Success!!

Failed!!




--
William E. Seiter


On Apr 8, 2010, Fred Grainger  wrote: 


Took the hash marks out.  Put quotes, trimmed the variable, checked the length 
of the file name to make sure there weren't any control characters or anything. 
 My code is very straight forward.  

A day and a half later, still no dice.  This is the first time I've used this 
function.  We just upgraded to CF9 a few weeks ago, but it is up to date.

This makes no sense whatsoever.  When I type the file path into the FileExists 
function it works fine.  Will not work with a variable.  Period. 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332787
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: FileExists using variable - not working

2010-04-08 Thread William Seiter

try

or



--
William E. Seiter


On Apr 8, 2010, Fred Grainger  wrote: 


Ok - I'm about to pull my hair out.

I am using fileexists() function to determine whether a image file exists on 
the server. When I type in the path it works fine, but when I use a variable it 
always returns false.

My code is like this:




do something

do something else


The variable works everywhere else in the code. I am outputting it to the 
browser and have double triple checked to make sure the variable value is 
correct.

I've been working on this a day and a half and cannot get it to work.

HELP! 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332774
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: populate cf variable using javascript array

2010-03-11 Thread William Seiter

Hey Charlie,
Once the 'cfinput' is viewed in the browser, it is translated into a regular 
 wrote: 


Hello,
I would like to know if it's possible to set a coldfusion variable from a 
javascript array? If so how?

What I really want to do is populate a cfinput with the values from the 
javascript array.

Thanks,
Charlie 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331617
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm


Re: jquery ajax tabs & cfinclude

2010-02-17 Thread William Seiter

if you show us the code that is breaking, we might be able to assist you better.


--
William E. Seiter


On Feb 17, 2010, Sachin Mohan  wrote: 


Hi,

Just wondering if someone has come across such an issue. I am loading in 
coldfusion content into jquery tabs using ajax. i.e. . 

If I have a  inside "dispAppointments.cfm", I get a '500 error - 
Could not find the included template'
 
It works fine if there is no  inside dispAppointments.cfm.

Thanks in advance!
Sachin 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330828
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Code Review?

2010-02-10 Thread William Seiter

without seeing the context of the code, it appears to be holding values that 
may be used for 'tracking' the user on the site.
What is the error that you are receiving from it?

--
William E. Seiter


On Feb 10, 2010, Glyn Jackson  wrote: 


I have been asked to looked as some code within this page is below. I have no 
idea what its doing however I was told its needed but keeps giving me errors. 
is your opinion why does this exists?









 





















 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330535
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: setting cf var with javascript

2010-02-05 Thread William Seiter

There is a misunderstanding about how the coldfusion works with JavaScript, I 
think.

On the server, the coldfusion is translated to pure HTML and Javascript (or any 
language that is 'client side').

Once the page is delivered to the browser, there is no coldfusion left on the 
page.  This means that when javascript runs on the client, there is no way to 
interact with coldfusion, without sending information back to the server first.

if you let us know what you are trying to accomplish, maybe we can suggest some 
alternative methods?

Thanks,
William

--
William E. Seiter


On Feb 5, 2010, Keith McGee  wrote: 


How do you set a CF variable with a java script variable. 

I have a script that adds three weekdays to the current day, 
document.write(mydate) 

and I want to set this to a CF variable 

cfset mydate = document.write(mydate) 

any suggestions
Keith 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330433
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: IE8 is killing my website

2010-02-02 Thread William Seiter

I have heard that if you replicate this tag as a cfheader tag, it works. 
(although I don't know why)

-Original Message-
From: Marc Funaro 
Sent: Tuesday, February 02, 2010 11:21 AM
To: cf-talk 
Subject: Re: IE8 is killing my website


>Try setting this Meta tag in you document head:
>
>
>
>That may solve your issue.
>
>Robert B. Harrison

This tag's been in place for a couple weeks; no effect. 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330363
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Why i fear ColdFusion is on its last legs

2010-01-20 Thread William Seiter

I can't speak to your experience with [A] or [C], but I will try to do a
parallel to [B].

In Los Angeles, we have had what amounts to a 'dead' CF user group.  I think
2 meetings in the last year since it was resurrected, after being shelved
for many many years.

However, the job market for CF developers in the Los Angeles area has never
been better.

We do have a 'general' Adobe users group that meets, but they don't really
care much for CF programmers, and focus mainly on the products you had
mentioned.  If I went to one of those meetings as a litmus test for CF
strength in the area, I would write LA off.  But because I work in the
market, I know better.

If you are having issues finding projects that are starting to use CF, keep
in mind that most new companies trend toward the free server-side
programming languages simply because it's free.

In contract work, I have taken a few of the contracts and changed their
minds about CF by citing and proving some of the basic tenets of CF
development.  Fast to market, advanced developers tend to be actually
advanced (not 'I worked with PHP for a year, I must be a 'senior'), etc.

If I were you, instead of looking for 'jobs' that are using CF, try looking
for 'startups' that are looking for a solution, and then sell them on you
and CF.

Just my 2 deenah,

William

-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com] 
Sent: Wednesday, January 20, 2010 9:52 PM
To: cf-talk
Subject: Why i fear ColdFusion is on its last legs


I know that's a 'Chicken Little" kind of subject line.  I hope my
impressions are wrong.   Might be - i have been wrong before.  I
remember i was wrong once when i thought i was incorrect, but i wasnt.

Anyway,  these are the reasons i think the trends tell me ColdFusion
is either a dead duck of soon to be a dead duck at least in Sydney
anyway.  I dont know about other places.  ...

[A] there is almost no new development going on in ColdFusionIn
the last 12 months there has been just a handful of coldfusion jobs
advertised.   And most of those have been advertised by time-wasters
who didnt end up appointing anyone. "I'm sorry Mike, they've put that
project on hold for now ... yada yada yada "  (or so they said  maybe
they were just too gutless to tell me i didnt get the assignment)   In
the last 12 months i have had NOT ONE assignment as a result of any
advertisements for CF developers.   If I hadnt dug up business on my
own I'd have starved.   Contrast this with a few years ago when
freelancers like me had jobs lined up one behind the other.   Maybe
its just me,   maybe everyone else has lots of jobs lined up.  But
somehow i doubt it.

[B] There is next-to no apparent activity in the Usergroups on
coldfusion, at least as far as I've seen.  Everyone's fussing about
Flex and Flash and Railo and Ruby on Rails and no one's talking about
ColdFusion.I'd have made the 4 hour trek into the user group
meeting if there'd been anything to do with coldfusion on.  Apparently
developers think there is nothing to talk about with ColdFusion.   How
newer developers are getting on learning the product I have no idea.

[C]  Adobe dont seem to be doing anything to promote ColdFusion here.
 I might be wrong on that,  and its just that they dont tell us what
they're doing,  but I havent seen any evidence that they're putting
much effort into marketing ColdFusion. I dont consider sending
speakers to a COLDFUSION conference like WebDU or CfObjective to be
promoting new ColdFusion installations because they're preaching to
the choir there.   Those folks are already sold on CF.  Yes it's
important to keep those lines open with the developer community but I
dont see much use for gaining new users that way.   ( I said something
similar a few years ago, and Mark Blair got highly indignant about it
- called me and told me all the things he was doing to promote
ColdFusion.   But after that, nothing)   I would like to know that
Adobe care enough about their server product to put some money behind
it and promote it a bit here.It would make me feel more
comfortable about building my business around it.

-- 
Cheers
Mike Kear


~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329884
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: line-through in select tag

2010-01-04 Thread William Seiter

In this page ' http://htmlhelp.com/reference/css/text/text-decoration.html',
this code is used:
line-through

I am able to view the desired effect using IE8 and FF 3.5.6

I cannot test this on IE7 and earlier at the moment, however.

William

-Original Message-
From: Gerald Guido [mailto:gerald.gu...@gmail.com] 
Sent: Monday, January 04, 2010 2:47 PM
To: cf-talk
Subject: Re: line-through in select tag


This worked on FF but not IE 7 (got figure).


#dollarFormat(productData.Price)#


On Mon, Jan 4, 2010 at 3:18 PM, Chad Gray  wrote:

>
> Anyone know of a way to get a CSS line-through in an HTML select tag?
>
> I tried this but it does not work.
>
> 
> 
style="text-decoration:line-through;">#dollarFormat(productData.Price)# 
>
>
> 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329402
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: adding ip address to email body

2009-12-09 Thread William Seiter

Alex, to make your code modular, you can create a custom function that wraps 
around the cfmail tag and adds all of your intended updates.  Then you would 
call the new function instead of cfmail, directly.
This will allow easy server migrations withot 'hacking' cf settings.

-Original Message-
From: Alex DeMarco 
Sent: Wednesday, December 09, 2009 11:00 AM
To: cf-talk 
Subject: adding ip address to email body


Is there any way to get the cfmail tag to automatically include the submittors 
IP address?  I realize if can be done programaticaly within the cfmail tag, but 
was looking for server based solution. Can the tag be hacked to include the 
ipaddress?
This would be for CFMX 8 and 9.

- Alex 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329029
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


RE: Possible thread issue?

2009-12-07 Thread William Seiter

Last_insert_id does just that, gets the last inserted id.
No matter who entered it.
This means that under intense traffic, that select may not return the id 
associated with that transactions action.

You should find the mysql equivalent to ScopeIdentity()

Or if you are using a newer version of cf, the generatedkeys.

-Original Message-
From: Andre Kapp 
Sent: Monday, December 07, 2009 11:22 AM
To: cf-talk 
Subject: Possible thread issue?


I'v now come across a code problem that I simply cannot understand what is 
happending here.

 

The code is part of a cfc module that is behind a web-service.
This is not inside a loop - just a normal cfc with a function that enter, 
process and returns data...
 

The problem here is the transID.
When you start putting a bit of load on this code, the transID gets 
mangled/confused/
When looking at the first cflog here, the trans id is the correct value is an 
thedatabase table.
However, after the values are assigned to stTrans, the trans id is different! 
It is that of another tx that happend later on...

 

Nowere is the transID updated in the code between the two cflog's. The value in 
the cflog is correct, as it is this value that I receive on the other side of 
the WebService module

 


Here is the logfile output
Look for card no 00213

 

Information","jrpp-5","12/07/09","20:11:27","GCCSVPWS","Process tx for 
xxx00213 with tx id 163537 and Thread.txid is 163537"


"Information","jrpp-0","12/07/09","20:11:27","GCCSVPWS"," Process tx (after 
transaction) for x000346 with tx id 163537 and Thread.txid is 163537"
"Information","jrpp-4","12/07/09","20:11:27","GCCSVPWS"," Process tx (after 
transaction) for 38304 with tx id 163537 and Thread.txid is 163537"
"Information","jrpp-7","12/07/09","20:11:27","GCCSVPWS","Process tx for 
254"
"Information","jrpp-9","12/07/09","20:11:27","GCCSVPWS","Process tx for 
xxx0270"
"Information","jrpp-16","12/07/09","20:11:27","GCCSVPWS"," Process tx (after 
transaction) for xx005097 with tx id 163537 and Thread.txid is 163537"
"Information","jrpp-18","12/07/09","20:11:27","GCCSVPWS"," Process tx (after 
transaction) for xx00239 with tx id 163537 and Thread.txid is 163537"
"Information","jrpp-19","12/07/09","20:11:27","GCCSVPWS"," Process tx (after 
transaction) for xx00304 with tx id 163537 and Thread.txid is 163537"
"Information","jrpp-8","12/07/09","20:11:27","GCCSVPWS","Process tx for 
x12 with tx id 163538 and Thread.txid is 163538"
"Information","jrpp-9","12/07/09","20:11:27","GCCSVPWS","Process tx for 
x270 with tx id 163539 and Thread.txid is 163539"
"Information","jrpp-3","12/07/09","20:11:27","GCCSVPWS"," Process tx (after 
transaction) for 0288 with tx id 163539 and Thread.txid is 163539"
"Information","jrpp-7","12/07/09","20:11:27","GCCSVPWS","Process tx for 
xxx254 with tx id 163540 and Thread.txid is 163540"
"Information","jrpp-5","12/07/09","20:11:27","GCCSVPWS"," Process tx (after 
transaction) for xx0213 with tx id 163540 and Thread.txid is 163540"

 

 

 

I found a problem when I did code optimizationon the other side of the 
webservice. First thought it was the web service, but trace it right down to 
this bit of code on the one server.

 

This is happening on my Mac's VM's running CentOS 5.2 and Coldfusion 8 on top 
of that.

Coldfusion details:
Server Product  ColdFusion
Version 8,0,1,195765 

 
Operating SystemUNIX 
OS Version  2.6.18-128.2.1.el5 
JVM Details
Java Version1.6.0_04 

 

Database is MySQL version 5.0

 

 

Any any any  ideas will be appreciated!

 

 

 

snipped 

 

SELECT last_insert_id() AS transid;


 



   

   


UPDATE acct_balances
SET
acct_balance = acct_balance + #arguments.amount#,
acct_balance_available = acct_balance_available + 
#arguments.amount#
WHERE
acct_id = 


 

   

 






UPDATE fees_collection
SET
settled = ,
settled_trans_id = ,
settled_dttm = NOW()
WHERE
acct_id =  AND
settled = 0





 










 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.house

Re: Scheduled Tasks

2009-09-28 Thread William Seiter

sounds like a great reason to follow his advice of creating a log file for the 
http responses.  If its not recreatable, yet you know it happens.


--
William E. Seiter


Sep 28, 2009 03:53:19 PM, cf-talk@houseoffusion.com wrote:

===


Right...but the URL's in question never produce 401 or anything like that
when I call them "manually..."

On Mon, Sep 28, 2009 at 4:51 PM, Ian Skinner  wrote:

>
> Do you have the scheduled task configured to log the results it gets
> when it makes the HTTP request?
>
> I find these can be very helpful when the request generates unexpected
> results such as a 401 access denied error that to a programmer is a
> failed task run, but to the ColdFusion server is a success.  It made an
> HTTP request it got an HTTP response, it is happy.
>

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326721
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


RE: Web service error

2009-08-05 Thread William Seiter

1.  The scope is arguments, note the s
2.  If the query returns a recordcount of 0, what does the function return?

-Original Message-
From: ch g 
Sent: Wednesday, August 05, 2009 10:40 AM
To: cf-talk 
Subject: Re: Web service error


After i changed the file name it's working, so i developed another service to 
verify the information aganist my database. Now i am receiving this error.

 Cannot perform web service invocation testUser.
The fault returned when invoking the web service operation is:

AxisFault
 faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException
 faultSubcode: 
 faultString: coldfusion.xml.rpc.CFCInvocationException: 
[coldfusion.runtime.UndefinedElementException : Element FIRSTNAME is 
undefined in ARGUMENT.]
 faultActor: 
 faultNode: 
 faultDetail: 

{http://xml.apache.org/axis/}stackTrace:coldfusion.xml.rpc.CFCInvocationException:
 [coldfusion.runtime.UndefinedElementException : Element FIRSTNAME is undefined 
in ARGUMENT.]
at 
coldfusion.xml.rpc.CFComponentSkeleton.__createCFCInvocationException(CFComponentSkeleton.java:723)
at 
coldfusion.xml.rpc.CFComponentSkeleton.__invoke(CFComponentSkeleton.java:670)
at serviceTest.testUser(C:\Inetpub\wwwroot\devsite\serviceTest.cfc)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
... ''

And here is my function






SELECT *
FROM...














What's wrong with the above function?

Thank you so much for all your time and suggestions.


>A quick test on my own server shows that your function works fine.
>
>
>createobject("webservice","http://www.ecodes.biz/UserVerif.cfc?wsdl";).echoSt
>ring("hello World")/>
>
>#x# 
>
>
>I suspect you have compiled the WSDL and the stub is being cached. You need
>to refresh the cache... But as a quick fix just rename your file to
>UserVerify.cfc or something and try again :)
>
>-mark
>
>
>Mark A. Kruger, CFG, MCSE
>(402) 408-3733 ext 105
>www.cfwebtools.com
>www.coldfusionmuse.com
>www.necfug.com
>
>I included that also
>
> access="remote">
>
>
>  
>
>Still receving the same error message
>
>Web service operation echoString with parameters {input={hello}} cannot
>be found. 
>
>Thank you. 



~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325230
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Moving from CF to Java - redirecting old pages to new ones

2009-06-11 Thread William Seiter

I would suggest handling it at the webserver level.  If you just put the 
cfheader data in the page, then the redirect won't occur until after the page 
has already been processed and sent back to the user's browser.  By handling it 
at the server level, you reduce your companies processing for the page, and 
reduce the time waiting for the extra page call from the user's browser.

William

>I know someone knows a better way but I have done it in the application.cfm
>using cfheader statuscode=301, statustext=Moved Permanently then another
> cfheader name=Location value="new url".
>First detecting whether it's the page in question of course.
>
>--
>Ryan LeTulle
>
>
>
>
>> 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323429
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: how to deal with "Delivery Status Notification (Failure)" cfmail

2009-06-11 Thread William Seiter

""email is correct on receiving server but the recipient is over its size 
limit""

Yes, the generic code that is returned is 'failure', thus the 'fail to' email 
address gets the response.  I would suggest that your cfpop do a quick and 
dirty search for possible reasons for non-delivery of the email and only delete 
the ones reported as 'unrecoverable'.

William 

~|
Want to reach the ColdFusion community with something they want? Let them know 
on the House of Fusion mailing lists
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323427
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: new to cflayout/cflayoutarea

2009-06-11 Thread William Seiter

If you want your form to load its action page into the current 'container' then 
you will need to use  tags instead of plain 
tags. William > I've tried using cflayout/cflayoutarea for the first time. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: CFFORM METADATA

2009-06-11 Thread William Seiter

>> I guess keeping track of the field types at the time the form is 
>> created is better than what I'm doing now. My field names are coded, 
>> so I loop through FORM.fieldNames looking for a keyword which triggers 
>> the correct type of validation. I could save the field name and field 
>> type in a session variable, then I wouldn't have to worry about the 
>> type being altered.
--sorry if this is a repost, the first one didn't seem to go through--

Since the form submit won't inherently send the 'type' of the field that was 
sent, you could use a method of naming your fields according to the type of 
form field that was used.  eg.  
or