Re: Weird problem with IFRAME

[Claude Schnéegans]

 >>I found this somewhat related article.

Well, no it is not the same. This one seems to deal with an error when setting 
the SRC attribute by Javascript, which is not what I'm doing.
Whet I have is a page like "myPage.cfm" which has an >Article does not mention it, but I believe the   (with whichever
IE mode you wind up with) has to be the first meta tag and must be in
the .

Yeah, I tried this one also, and beleive it or not, not only the styles were 
gone under IE9, but also under IE8!
This means IE8 is not able to emulate IE8! How about 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:353538
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Weird problem with IFRAME

[Byron Mann]

I found this somewhat related article.

http://stackoverflow.com/questions/11935458/ie9-bug-iframe-misbehaving-due-to-url-sensitivity

Article does not mention it, but I believe the   (with whichever
IE mode you wind up with) has to be the first meta tag and must be in
the .

Bit more on X-UA-Compatible

http://webdesign.about.com/od/metataglibraries/p/x-ua-compatible-meta-tag.htm

-- 
Byron Mann
Lead Engineer & Architect
HostMySite.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:353526
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Weird problem with IFRAME

[Claude Schnéegans]

 >> it looks like you need a space between
mondossier.cfm and type=#type#

No, type here is a parameter in the url, not an attribute for http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353489
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Weird problem with IFRAME

[Maureen]

If this is exact code, it looks like you need a space between
mondossier.cfm and type=#type#



On Thu, Dec 13, 2012 at 2:13 PM, <> wrote:

>
> Hi,
> One of my customers is having a very weird problem with an IFRAME in my
> site.
> Here is the code in file mondossier.cfm:
>  FRAMEBORDER="0"
>  STYLE="position:relative;" NAME="admin">
> type is blank
>


~|
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:353488
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Weird problem with IFRAME

[Claude Schnéegans]

 >>Is it possible the IFrame src is getting redirected to the "root"

It would be if the file is not found, but the file exists and it works with all 
other browsers, including IE8.
Only IE9 seems to have trouble.
And if it was redirectected, there would be a trace of it in the HTTP logs
For instance if I request doesNotExists.cfm, I clearly see the HTTP request for 
doesNotExists.cfm then another one, the CF redirection, for the root /
But in this issue, the request is directly made to /, just like if there was no 
address in the SCR attribute.


~|
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:353461
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Weird problem with IFRAME

[Byron Mann]

Is it possible the IFrame src is getting redirected to the "root"
because the user is not logged in?

On Thu, Dec 13, 2012 at 4:14 PM,  <> wrote:
>
>  >>Try ./file.cfm
>
> Ok, I tried, but it makes no difference.
>
>
> 

~|
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:353456
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Weird problem with IFRAME

[Claude Schnéegans]

 >>Try ./file.cfm

Ok, I tried, but it makes no difference.


~|
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:353451
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Weird problem with IFRAME

[Byron Mann]

Think I ran into this before with relative paths without '/'

Try ./file.cfm

Byron Mann
Lead Engineer & Architect
HostMySite.com
On Dec 13, 2012 2:14 PM, <> wrote:

>
> Hi,
> One of my customers is having a very weird problem with an IFRAME in my
> site.
> Here is the code in file mondossier.cfm:
>  FRAMEBORDER="0"
>  STYLE="position:relative;" NAME="admin">
> type is blank
>
> With all browsers, including my own Explorer it works perfectly.
> This is the trace how it look in tje server log when the page works
> normaly:
> GET 575 6742p=monDossier200 /index.cfm
>
> GET 577 11549   type=   200 /monDossierEdit.cfm
>
> showing that index.cfm?p=momDossier was called, then the iFrame called
> correctly monDossierEdit.cfm?type=
>
> But in my client's case, here is what we get:
> GET 543 7380p=monDossier200 /index.cfm
>
> GET 543 37336   -   200 /
>
> showing that the iFrame called the domain root instead of the url in the
> SRC attribute.
>
> My site uses many iFRAMES else where in the system and the client has no
> problem with them, only with this one.
>
> Any idea ?
>
>
> 

~|
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:353450
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Weird problem with IFRAME

[Claude Schnéegans]

Hi,
One of my customers is having a very weird problem with an IFRAME in my site.
Here is the code in file mondossier.cfm:

type is blank

With all browsers, including my own Explorer it works perfectly.
This is the trace how it look in tje server log when the page works normaly:
GET 575 6742p=monDossier200 /index.cfm

GET 577 11549   type=   200 /monDossierEdit.cfm

showing that index.cfm?p=momDossier was called, then the iFrame called 
correctly monDossierEdit.cfm?type=

But in my client's case, here is what we get:
GET 543 7380p=monDossier200 /index.cfm

GET 543 37336   -   200 /

showing that the iFrame called the domain root instead of the url in the SRC 
attribute.

My site uses many iFRAMES else where in the system and the client has no 
problem with them, only with this one.

Any idea ?


~|
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:353449
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Weird problem with CFPDF addheader/image

[Ryan Bentley]

Ok, so I am hoping someone out there has some kind of insight on this issue as 
I cannot find anything on this.

We are having an issue with CF9 with images not printing. We do a ton of pdf 
generation each day, and right now have a clients code updated to cf9. Its very 
simple code, and below is what is used:



The problem is that it is in fact inserting the header image into the pdf file, 
but when you randomly print some of these pdfs the image will not print. This 
doesn't happen to ever one, but maybe 50%. I cannot find any rhyme or reason to 
this, nor can I find anything over the internetz.

If anyone has seen this issue or has any insight, it would be GREATLY 
appreciate!

Thanks,
Ryan



~|
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:338767
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: cflayout weird problem

[BJ McShane]

Dave,  Thanks for the help.  The code sample worked great. 

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

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

Re: cflayout weird problem

[BJ McShane]

Dave,  I'll try it and let you know.  Thanks for the help. 

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

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

RE: cflayout weird problem

[Dave Phillips]

BJ,

Okay, not familiar with cf_betterselect, but the below should still work for
you:  

Change your cfform tag to this:



IN your  area, add the following:


function doSubmit() {
  var oForm = document.newEmpInsertForm;
 if(oForm.p_supervisor.selectedIndex == 0) {
  alert('must select a supervisor');
  return false;
}
  if(oForm.p_location.selectedIndex == 0) {
  alert('must select a location');
  return false;
}
return true;
}


Change your  to:


  
  
#emp_locat#
  



Modify the alerts to say whatever you want to say when wrong information is
entered.

Dave
-Original Message-
From: BJ McShane [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2008 4:54 PM
To: CF-Talk
Subject: Re: cflayout weird problem

Dave,

  I am using cfform and some of the validation on tags with it.  The two
places I don't is a custom tag I'm using cf_betterselect and the regular
select.  the betterselect allows the user to type and narrow down the list.
the select tag I want the user to select a location and not have it default
to one so I put in an empty  tag.  With this the validation will not
work when I set the cfselect tag to required.

Here's my code:






  


 


Name:



Employee No.:





Title:





RCN:
   




#emp_rcn# - #mid(emp_rcn_name,9,35)#



Time Reporting Group:





Supervisor:
 



#emp_last_name#,
#emp_nick_name#




Start Date:

   

 

Location:
   


#emp_locat#



 
   


FERC/Walled Employee:



Transmission Apprentice:





Bargaining:


or
Non-Bargaining:
  
Need Office:



or Cubicle:   
or N/A:
 
  

  

Re: cflayout weird problem

[BJ McShane]

Dave,

  I am using cfform and some of the validation on tags with it.  The two places 
I don't is a custom tag I'm using cf_betterselect and the regular select.  the 
betterselect allows the user to type and narrow down the list.  the select tag 
I want the user to select a location and not have it default to one so I put in 
an empty  tag.  With this the validation will not work when I set the 
cfselect tag to required.

Here's my code:






  


 


Name:



Employee No.:





Title:





RCN:
   




#emp_rcn# - #mid(emp_rcn_name,9,35)#



Time Reporting Group:





Supervisor:
 



#emp_last_name#, 
#emp_nick_name#

  


Start Date:

   

 

Location:
   


#emp_locat#



 
   


FERC/Walled Employee:



Transmission Apprentice:





Bargaining:


or Non-Bargaining:
  
Need Office:



or Cubicle:   
or N/A:
 
  

Laptop needed:



Desktop needed:



 

Cell phone needed:



Broadband Card needed:





VPN ne

RE: cflayout weird problem

[Dave Phillips]

BJ,

Post your form code (or a snippet) and what fields you're trying to validate
and what you want validated and we can help.

Also, check out the CF docs for CFFORM as it has a lot of built-in
javascript validation that you can utilize through CF tags like CFINPUT and
so on.

Dave

-Original Message-
From: BJ McShane [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2008 3:59 PM
To: CF-Talk
Subject: Re: cflayout weird problem

Dave, thanks for the reply.  I did run it in firefox and the data doesn't
get wiped out in that browser.  So you are right it looks like it is a
browser issue.  I've never validated with just javascript, I'll have to look
around for examples.

thanks

bj 



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

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

Re: cflayout weird problem

[BJ McShane]

Dave, thanks for the reply.  I did run it in firefox and the data doesn't get 
wiped out in that browser.  So you are right it looks like it is a browser 
issue.  I've never validated with just javascript, I'll have to look around for 
examples.

thanks

bj 

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

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

RE: cflayout weird problem

[Dave Phillips]

To my knowledge, this is a browser issue, not a cflayout issue, as you will
get different results in different browsers.

You can avoid this completely by using javascript to validate your fields.

Dave

-Original Message-
From: BJ McShane [mailto:[EMAIL PROTECTED] 
Sent: Friday, August 22, 2008 3:24 PM
To: CF-Talk
Subject: cflayout weird problem

I'm using the cflayout for tabs on my form.  When the form submits, I check
a couple of the fields for error checking and if the fields are wrong or not
filled in I send the user back using the history.back() function.  The forms
returns but all the input the user put in is gone.  If I take off the
cflayout and just have a regular form the input data stays if there is an
error.  Does any one know of a work around or something I can do.

thanks,

bj 


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

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

cflayout weird problem

[BJ McShane]

I'm using the cflayout for tabs on my form.  When the form submits, I check a 
couple of the fields for error checking and if the fields are wrong or not 
filled in I send the user back using the history.back() function.  The forms 
returns but all the input the user put in is gone.  If I take off the cflayout 
and just have a regular form the input data stays if there is an error.  Does 
any one know of a work around or something I can do.

thanks,

bj 

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

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

Weird problem after Updater 2 (can someone confirm)

[DURETTE, STEVEN J \(ASI-AIT\)]

Hi all,
 
Last night we finally applied the CFMX7 Updater 2.  I know it should
have been done a long time ago, but our IT department has a really bad
method for requesting patches be applied, have to wait for approval,
then I have to do it even though I'm not IT!
 
Anyhow, I noticed something really weird after applying the patch.  I
have a cfstoredproc that gets two result sets.  The code looks something
like this:
 
 
  
  
  
 

After the updater, this would only return 1 row for the first result
set, even though manually running the query returned 15 rows.  The
correction was to do this:
 
 
  
  
  
 

It seems that if maxrows was set for one of them it did it for both.
Can anyone confirm this?
 
Thanks,
Steve
 


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

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

RE: Weird problem logging in with IE 5.5

[Andy Mcshane]

Excellent, glad to be of help.
 


From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Mon 09/05/2005 23:05
To: CF-Talk
Subject: Re: Weird problem logging in with IE 5.5



Hi Andy,

Thanks, that seemed to be the problem! :)


On 9/5/05 13:47, "Andy Mcshane" <[EMAIL PROTECTED]> wrote:

> Could it possibly be to do with cookies? Do they have their browser setup to
> allow cookies?
>
> 
>
> From: Stuart Kidd [mailto:[EMAIL PROTECTED]
> Sent: Mon 09/05/2005 13:38
> To: CF-Talk
> Subject: Weird problem logging in with IE 5.5
>
>
>
> Hi guys,
>
> For some time now users have been sending me mails saying that they can't log
> into my application.  I try and all is fine.
>
> I am now trying it with IE5.5 and am having the same problem occur.
>
> Does anyone know of any straight-forward reason why this could be?  I would
> have thought it was browser independent being CF.  Perhaps it's something in
> the user's options with IE5.5?
>
> If anyone could shed some light on to this i would be very grateful.
>
> The app is quite simple where by a user types in their username and then
> password which are then checked in an MS-SQL database.
>
> The strange thing is that an error doesn't occur, it just sends the user back
> to the user/password form.
>
> All other browsers it works fine in.
>
> Thanks,
>
> Saturday
>
>
>
>
>
>
>
>



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

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

Re: Weird problem logging in with IE 5.5

[Stuart Kidd]

Hi Andy,

Thanks, that seemed to be the problem! :)


On 9/5/05 13:47, "Andy Mcshane" <[EMAIL PROTECTED]> wrote:

> Could it possibly be to do with cookies? Do they have their browser setup to
> allow cookies?
> 
> 
> 
> From: Stuart Kidd [mailto:[EMAIL PROTECTED]
> Sent: Mon 09/05/2005 13:38
> To: CF-Talk
> Subject: Weird problem logging in with IE 5.5
> 
> 
> 
> Hi guys,
> 
> For some time now users have been sending me mails saying that they can't log
> into my application.  I try and all is fine.
> 
> I am now trying it with IE5.5 and am having the same problem occur.
> 
> Does anyone know of any straight-forward reason why this could be?  I would
> have thought it was browser independent being CF.  Perhaps it's something in
> the user's options with IE5.5?
> 
> If anyone could shed some light on to this i would be very grateful.
> 
> The app is quite simple where by a user types in their username and then
> password which are then checked in an MS-SQL database.
> 
> The strange thing is that an error doesn't occur, it just sends the user back
> to the user/password form.
> 
> All other browsers it works fine in.
> 
> Thanks,
> 
> Saturday
> 
> 
> 
> 
> 
> 
> 
> 

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

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

RE: Weird problem logging in with IE 5.5

[Andy Mcshane]

Could it possibly be to do with cookies? Do they have their browser setup to 
allow cookies?



From: Stuart Kidd [mailto:[EMAIL PROTECTED]
Sent: Mon 09/05/2005 13:38
To: CF-Talk
Subject: Weird problem logging in with IE 5.5



Hi guys,

For some time now users have been sending me mails saying that they can't log 
into my application.  I try and all is fine.

I am now trying it with IE5.5 and am having the same problem occur.

Does anyone know of any straight-forward reason why this could be?  I would 
have thought it was browser independent being CF.  Perhaps it's something in 
the user's options with IE5.5?

If anyone could shed some light on to this i would be very grateful.

The app is quite simple where by a user types in their username and then 
password which are then checked in an MS-SQL database.

The strange thing is that an error doesn't occur, it just sends the user back 
to the user/password form.

All other browsers it works fine in.

Thanks,

Saturday







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

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

Weird problem logging in with IE 5.5

[Stuart Kidd]

Hi guys,

For some time now users have been sending me mails saying that they can't log 
into my application.  I try and all is fine.

I am now trying it with IE5.5 and am having the same problem occur.

Does anyone know of any straight-forward reason why this could be?  I would 
have thought it was browser independent being CF.  Perhaps it's something in 
the user's options with IE5.5?

If anyone could shed some light on to this i would be very grateful.

The app is quite simple where by a user types in their username and then 
password which are then checked in an MS-SQL database.

The strange thing is that an error doesn't occur, it just sends the user back 
to the user/password form.

All other browsers it works fine in.

Thanks,

Saturday

 



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

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

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

Re: Weird problem with CFLOGIN and Session variables

[Jared Rypka-Hauer - CMG, LLC]

Good news on the solving part... sometimes that's all one really wishes to 
achieve.

I'll let you know if I find anything on my end...

J

On 5/4/05, Fabio Terracini <[EMAIL PROTECTED]> wrote:
> 
> I rewrited all the code and I'm not using cflogin structure anymore
> (with j_username and j_password). Also, I deleted all classes in cfclass
> directory and have a 
>   before the cflogin block.
> 
> We're running some tests, but I believe it's "solved" by now, although
> the specific bug wans't discovered.
> 
> Thanks,
> 
> Fabio Terracini
> 



-- 
---
-
Buy SQLSurveyor!
http://www.web-relevant.com/sqlsurveyor
Never make your developers open Enterprise Manager again.


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

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

Re: Weird problem with CFLOGIN and Session variables

[Fabio Terracini]

I rewrited all the code and I'm not using cflogin structure anymore 
(with j_username and j_password). Also, I deleted all classes in cfclass 
directory and have a   
   before the cflogin block.

We're running some tests, but I believe it's "solved" by now, although 
the specific bug wans't discovered.

Thanks,

Fabio Terracini



Fabio Terracini wrote:

>Thanks Jared. I also tried your modifications in cflogin block, but 
>didn't work.
>
>The sessions seems to be working fine. I still think it's something with 
>cflogin tag, and it's totally ridiculous to lost time with such a simple 
>tag. Oh my...
>
>I'm almost changing the login architecture, dismissing cflogin tag and 
>make an authentication system based only on sessions variables.
>
>--
>Thanks!
>
>Fabio Terracini
>
>
>
>Jared Rypka-Hauer - CMG, LLC wrote:
>
>  
>
>>Fabio,
>>
>>I suggest you give onSessionEnd a try... if for no other reason that to 
>>write a few log file entries. Maybe not permanently, but at least while 
>>troubleshooting. I think that what's happening is this: while J2EE sessions 
>>promise some nice things, they're not quite working correctly. :)
>>
>>What else... cflogin doesn't run if there's a logged in use...
>>
>>Oh, Fabio... use LOTS of CFLOG tags... I first had to use a TON of them to 
>>get some quirks out of CFMX 6.1 code for cflogin. Log pass/fail, 
>>before/after, anywhere you can trap the difference between one state and 
>>another, log it.
>>
>>And you might want to use >len(getAuthUser())> instead of ... it reverses 
>>your logic a bit, but it should still work. I also don't include the form 
>>inside cflogin. I use  to 
>>include the login form and  inside 
>>my cflogin tag.
>>
>>Maybe later I can send you my cflogin code...
>>
>>Laterz,
>>J
>>
>>On 5/4/05, Fabio Terracini <[EMAIL PROTECTED]> wrote:
>> 
>>
>>
>>
>>>Really odd!
>>>
>>>Jared, I'm not using onSessionStart, neither onSessionEnd. The
>>>Application.cfc only contains the application variables 
>>>(this.name, 
>>>etc)
>>>and onRequestStart method, which includes the cflogin block. Should I
>>>use onSessionEnd? When the browser close, both login and sessions are
>>>ended anyway.
>>>
>>>I did some test, setting output=yes on onRequestStart, and tracing
>>>weather block of code is beeing executed or not. When the problem
>>>occurs, the user doesn't enter the cflogin block as it should, which is
>>>weird, since he isn't logged in. If he was logged, the login form won't
>>>display: the user will enter the system directly.
>>>
>>>Anyway, just a thought: the problem seems to be with cflogin, since when
>>>the user tries to login again, he doesn't enter the cflogin block. This
>>>is way session variables aren't beeing setted. This is fine. But, why
>>>ain't enterting the cflogin block?
>>>
>>>As I said - and you suggested - in the login form, and also before
>>>logging in, I loged out (cflogout), cleaned session (and cookies too)
>>>variables to ensure the user isn't logged in in anyway. Didn't worked out.
>>>
>>>Thanks,
>>>--
>>>
>>>Fabio Terracini
>>>
>>>
>>>Jared Rypka-Hauer - CMG, LLC wrote:
>>>
>>>   
>>>
>>>  
>>>
Ooops, missed a part of the message from Fabio... yeah, it's a bit odd.

Fabio, are you using onSessionStart and onSessionEnd events to control 
 



>>>your
>>>   
>>>
>>>  
>>>
sessions? Really, what you should be doing is using onSessionEnd to clean 
 



>>>up
>>>   
>>>
>>>  
>>>
your session when it times out instead of detecting problems later and
trying to work around them.

Laterz,
J

On 5/4/05, James Holmes <[EMAIL PROTECTED]> wrote:


 



>You might have to post the contents of the cflogin block, as this is 
>   
>
>  
>
>>>very
>>>   
>>>
>>>  
>>>
>weird.
>
>
>
>   
>
>  
>

 



>>>   
>>>
>>>  
>>>
>>
>>
>
>

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

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

Re: Weird problem with CFLOGIN and Session variables

[Fabio Terracini]

Thanks Jared. I also tried your modifications in cflogin block, but 
didn't work.

The sessions seems to be working fine. I still think it's something with 
cflogin tag, and it's totally ridiculous to lost time with such a simple 
tag. Oh my...

I'm almost changing the login architecture, dismissing cflogin tag and 
make an authentication system based only on sessions variables.

--
Thanks!

Fabio Terracini



Jared Rypka-Hauer - CMG, LLC wrote:

>Fabio,
>
>I suggest you give onSessionEnd a try... if for no other reason that to 
>write a few log file entries. Maybe not permanently, but at least while 
>troubleshooting. I think that what's happening is this: while J2EE sessions 
>promise some nice things, they're not quite working correctly. :)
>
>What else... cflogin doesn't run if there's a logged in use...
>
>Oh, Fabio... use LOTS of CFLOG tags... I first had to use a TON of them to 
>get some quirks out of CFMX 6.1 code for cflogin. Log pass/fail, 
>before/after, anywhere you can trap the difference between one state and 
>another, log it.
>
>And you might want to use len(getAuthUser())> instead of ... it reverses 
>your logic a bit, but it should still work. I also don't include the form 
>inside cflogin. I use  to 
>include the login form and  inside 
>my cflogin tag.
>
>Maybe later I can send you my cflogin code...
>
>Laterz,
>J
>
>On 5/4/05, Fabio Terracini <[EMAIL PROTECTED]> wrote:
>  
>
>>Really odd!
>>
>>Jared, I'm not using onSessionStart, neither onSessionEnd. The
>>Application.cfc only contains the application variables 
>>(this.name, 
>>etc)
>>and onRequestStart method, which includes the cflogin block. Should I
>>use onSessionEnd? When the browser close, both login and sessions are
>>ended anyway.
>>
>>I did some test, setting output=yes on onRequestStart, and tracing
>>weather block of code is beeing executed or not. When the problem
>>occurs, the user doesn't enter the cflogin block as it should, which is
>>weird, since he isn't logged in. If he was logged, the login form won't
>>display: the user will enter the system directly.
>>
>>Anyway, just a thought: the problem seems to be with cflogin, since when
>>the user tries to login again, he doesn't enter the cflogin block. This
>>is way session variables aren't beeing setted. This is fine. But, why
>>ain't enterting the cflogin block?
>>
>>As I said - and you suggested - in the login form, and also before
>>logging in, I loged out (cflogout), cleaned session (and cookies too)
>>variables to ensure the user isn't logged in in anyway. Didn't worked out.
>>
>>Thanks,
>>--
>>
>>Fabio Terracini
>>
>>
>>Jared Rypka-Hauer - CMG, LLC wrote:
>>
>>
>>
>>>Ooops, missed a part of the message from Fabio... yeah, it's a bit odd.
>>>
>>>Fabio, are you using onSessionStart and onSessionEnd events to control 
>>>  
>>>
>>your
>>
>>
>>>sessions? Really, what you should be doing is using onSessionEnd to clean 
>>>  
>>>
>>up
>>
>>
>>>your session when it times out instead of detecting problems later and
>>>trying to work around them.
>>>
>>>Laterz,
>>>J
>>>
>>>On 5/4/05, James Holmes <[EMAIL PROTECTED]> wrote:
>>>
>>>
>>>  
>>>
You might have to post the contents of the cflogin block, as this is 


>>very
>>
>>
weird.





>>>
>>>
>>>
>>>  
>>>
>>
>>
>
>

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

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

Re: Weird problem with CFLOGIN and Session variables

[Jared Rypka-Hauer - CMG, LLC]

Fabio,

I suggest you give onSessionEnd a try... if for no other reason that to 
write a few log file entries. Maybe not permanently, but at least while 
troubleshooting. I think that what's happening is this: while J2EE sessions 
promise some nice things, they're not quite working correctly. :)

What else... cflogin doesn't run if there's a logged in use...

Oh, Fabio... use LOTS of CFLOG tags... I first had to use a TON of them to 
get some quirks out of CFMX 6.1 code for cflogin. Log pass/fail, 
before/after, anywhere you can trap the difference between one state and 
another, log it.

And you might want to use  instead of ... it reverses 
your logic a bit, but it should still work. I also don't include the form 
inside cflogin. I use  to 
include the login form and  inside 
my cflogin tag.

Maybe later I can send you my cflogin code...

Laterz,
J

On 5/4/05, Fabio Terracini <[EMAIL PROTECTED]> wrote:
> 
> Really odd!
> 
> Jared, I'm not using onSessionStart, neither onSessionEnd. The
> Application.cfc only contains the application variables 
> (this.name, 
> etc)
> and onRequestStart method, which includes the cflogin block. Should I
> use onSessionEnd? When the browser close, both login and sessions are
> ended anyway.
> 
> I did some test, setting output=yes on onRequestStart, and tracing
> weather block of code is beeing executed or not. When the problem
> occurs, the user doesn't enter the cflogin block as it should, which is
> weird, since he isn't logged in. If he was logged, the login form won't
> display: the user will enter the system directly.
> 
> Anyway, just a thought: the problem seems to be with cflogin, since when
> the user tries to login again, he doesn't enter the cflogin block. This
> is way session variables aren't beeing setted. This is fine. But, why
> ain't enterting the cflogin block?
> 
> As I said - and you suggested - in the login form, and also before
> logging in, I loged out (cflogout), cleaned session (and cookies too)
> variables to ensure the user isn't logged in in anyway. Didn't worked out.
> 
> Thanks,
> --
> 
> Fabio Terracini
> 
> 
> Jared Rypka-Hauer - CMG, LLC wrote:
> 
> >Ooops, missed a part of the message from Fabio... yeah, it's a bit odd.
> >
> >Fabio, are you using onSessionStart and onSessionEnd events to control 
> your
> >sessions? Really, what you should be doing is using onSessionEnd to clean 
> up
> >your session when it times out instead of detecting problems later and
> >trying to work around them.
> >
> >Laterz,
> >J
> >
> >On 5/4/05, James Holmes <[EMAIL PROTECTED]> wrote:
> >
> >
> >>You might have to post the contents of the cflogin block, as this is 
> very
> >>weird.
> >>
> >>
> >>
> >
> >
> >
> >
> >
> 
> 

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

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

Re: Weird problem with CFLOGIN and Session variables

[Fabio Terracini]

Really odd!

Jared, I'm not using onSessionStart, neither onSessionEnd. The 
Application.cfc only contains the application variables (this.name, etc) 
and onRequestStart method, which includes the cflogin block. Should I 
use onSessionEnd? When the browser close, both login and sessions are 
ended anyway.

I did some test, setting output=yes on onRequestStart, and tracing 
weather block of code is beeing executed or not. When the problem 
occurs, the user doesn't enter the cflogin block as it should, which is 
weird, since he isn't logged in. If he was logged, the login form won't 
display: the user will enter the system directly.

Anyway, just a thought: the problem seems to be with cflogin, since when 
the user tries to login again, he doesn't enter the cflogin block. This 
is way session variables aren't beeing setted. This is fine. But, why 
ain't enterting the cflogin block?

As I said - and you suggested - in the login form, and also before 
logging in, I loged out (cflogout), cleaned session (and cookies too) 
variables to ensure the user isn't logged in in anyway. Didn't worked out.

Thanks,
--

Fabio Terracini



Jared Rypka-Hauer - CMG, LLC wrote:

>Ooops, missed a part of the message from Fabio... yeah, it's a bit odd.
>
>Fabio, are you using onSessionStart and onSessionEnd events to control your 
>sessions? Really, what you should be doing is using onSessionEnd to clean up 
>your session when it times out instead of detecting problems later and 
>trying to work around them.
>
>Laterz,
>J
>
>On 5/4/05, James Holmes <[EMAIL PROTECTED]> wrote:
>  
>
>>You might have to post the contents of the cflogin block, as this is very
>>weird.
>>
>>
>>
>
>
>
>  
>

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

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

Re: Weird problem with CFLOGIN and Session variables

[Fabio Terracini]

Oh yeah.

The cflogin block follows:








   


   
   















alert('Login inválido!');


   

   






Fabio Terracini
Synex Technologies Co.
Consultant
Fone/Fax: +55 (11) 3071-3363
[EMAIL PROTECTED]
www.synex.com.br 



James Holmes wrote:

>You might have to post the contents of the cflogin block, as this is very
>weird. 
>
>

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

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

Re: Weird problem with CFLOGIN and Session variables

[Fabio Terracini]

Oh yeah.

The cflogin block follows:








   


   
   














alert('Login inválido!');


   

   






Fabio Terracini
Synex Technologies Co.
Consultant
Fone/Fax: +55 (11) 3071-3363
[EMAIL PROTECTED]
www.synex.com.br 



James Holmes wrote:

>You might have to post the contents of the cflogin block, as this is very
>weird. 
>
>

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

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

Re: Weird problem with CFLOGIN and Session variables

[Jared Rypka-Hauer - CMG, LLC]

Ooops, missed a part of the message from Fabio... yeah, it's a bit odd.

Fabio, are you using onSessionStart and onSessionEnd events to control your 
sessions? Really, what you should be doing is using onSessionEnd to clean up 
your session when it times out instead of detecting problems later and 
trying to work around them.

Laterz,
J

On 5/4/05, James Holmes <[EMAIL PROTECTED]> wrote:
> 
> You might have to post the contents of the cflogin block, as this is very
> weird.
> 



-- 
---
-
Buy SQLSurveyor!
http://www.web-relevant.com/sqlsurveyor
Never make your developers open Enterprise Manager again.


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

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

Re: Weird problem with CFLOGIN and Session variables

[Jared Rypka-Hauer - CMG, LLC]

All you're going to need is something like this:





In your logout page, run the cflogout tag, which does not error if there is 
no user logged in... and then something like this:








Now that's example code, and not really customized for CFC use... I 
generally start using page-scope code and then migrate it to CFC wrappers 
once I know it's doing what I want it to do.

HTH,
J

On 5/4/05, James Holmes <[EMAIL PROTECTED]> wrote:
> 
> You might have to post the contents of the cflogin block, as this is very
> weird.
> 



-- 
---
-
Buy SQLSurveyor!
http://www.web-relevant.com/sqlsurveyor
Never make your developers open Enterprise Manager again.


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

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

RE: Weird problem with CFLOGIN and Session variables

[James Holmes]

You might have to post the contents of the cflogin block, as this is very
weird. 

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

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

Weird problem with CFLOGIN and Session variables

[Fabio Terracini]

Hello guys,

I have an authentication system, using both cflogin (for authentication) 
and session variables (to set user data, sites able to manage, and so on).

- User access the system for the first time, so he isn't logged in;
- The system displays the login form.
- User fill the form, click submit;
- Since he isn't logged in, he "enter the cflogin tag".
- The system authenticate using cfloginuser and also set session variables.

This is working like a charm, as usual.

- If the user logout, session variables are deleted and cflogout executed.
- If the user access the system again, both cfloginuser and sessions are 
setted again.

Also, working perfectly.

*But*...
If the user is logged in and simply close the browser (without login out 
properly), the next time he access the system, the login form *will be* 
displayed (since he ain't logged in), but, when he submit the form, 
session variables are not setted. The cfset's for session variables are 
inside the cflogin block. So, if they are not executed, I presume the 
user hasn't entered the cflogin block, which is totally weird, since he 
isn't logged in!

Application.cfc configured as follows:




   


   








I tried putting cflogout and deleting sessions variables in the login 
page (to really ensure the user isn't logged in), but didn't worked. 
Also, the login form use j_username and j_password as form inputs, so, 
inside cflogin tag, we have the cflogin structure.

Using ColdFusion 7 Updater 2 in J2EE Configuration on JRun 4 Updater 3, 
using jsessionID variables (in CF Administrator). Linux and Apache.

Am I missing something?

Many thanks,

-- 
Fabio Terracini


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

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

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

RE: Weird problem

[Matt Osbun]

Had that problem shortly after installing CF7.  Since our CF7 server is
development only at the moment, I reduced the page cache in the
administrator to 0 and restarted the service.

That may not be the best solution if that will affect production sites,
though.  Unless you're the BWMFH (Bastard Web Master From Hell- with
apologies to Simon Travaglia)

Matt Osbun
Web Developer
Health Systems, International


-Original Message-
From: simmyana a [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 12, 2005 1:13 AM
To: CF-Talk
Subject: Weird problem


Hi,
 I am facing a strange problem in CF, one of my CFM files is missing
from the server(if I set show hidden files property also, It is not
displaying the file) but it is displaying the file in the browser! Could
anyone please tell me, how cfm files will get processed?

Thank you



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

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

Re: Weird problem

[Dave Francis]

Cache?

- Original Message - 
From: "simmyana a" <[EMAIL PROTECTED]>
To: "CF-Talk" 
Sent: Tuesday, April 12, 2005 2:13 AM
Subject: Weird problem


> Hi,
> I am facing a strange problem in CF, one of my CFM files is missing from 
> the server(if I set show hidden files property also, It is not displaying 
> the file)
> but it is displaying the file in the browser! Could anyone please tell me, 
> how cfm files will get processed?
>
> Thank you
>
> 

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

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

RE: Weird problem

[Rick Faircloth]

>  I am facing a strange problem in CF

Sorry, can't help you...we never have those around here.  :o)

Rick



> -Original Message-
> From: simmyana a [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 12, 2005 2:13 AM
> To: CF-Talk
> Subject: Weird problem
> 
> 
> Hi,
>  I am facing a strange problem in CF, one of my CFM files is 
> missing from the server(if I set show hidden files property also, 
> It is not displaying the file)
> but it is displaying the file in the browser! Could anyone please 
> tell me, how cfm files will get processed?
> 
> Thank you
> 


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

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

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

Weird problem

[simmyana a]

Hi,
 I am facing a strange problem in CF, one of my CFM files is missing from the 
server(if I set show hidden files property also, It is not displaying the file)
but it is displaying the file in the browser! Could anyone please tell me, how 
cfm files will get processed?

Thank you

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

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

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

RE: Weird Problem with Structure

[Phillip B. Holmes]

Pardon the typo:

 sed 's/unneccesary/unnecessary/'

;)

Regards,

Phillip B. Holmes
 

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED] 
Sent: Saturday, February 12, 2005 3:41 PM
To: CF-Talk
Subject: RE: Weird Problem with Structure

> I had an interesting thing happen the other day. I was messing around 
> with something, trying to find a way around a particular problem, and 
> I used this code... fully expecting it to error out:
> 
> 
> 
> 
>   
> 
> Now, had I put myTest["#i#"], I would have expected it to work. What I 
> ended up with when I dumped it was a struct that looked very much like 
> an array.
> 
> This was on CFMX 6.1, just kinda struck me odd.

Actually, that makes perfect sense.

When you use array notation, you can specify whatever values you like. Since
CF is a typeless language, any value stored within a variable will be
treated as a string when you use array notation to make it a member name for
a structure.

Keep in mind that the two values of foo are the same in the example below:




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

Fig Leaf Software provides the highest caliber vendor-authorized instruction
at our training centers in Washington DC, Atlanta, Chicago, Baltimore,
Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!




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

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

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

RE: Weird Problem with Structure

[Phillip B. Holmes]

J,

Not unusual at all. The pound signs are unneccesary inside cfset (or any
other tag for that matter (unless the value is encapsulated by quotes).

You created a structure in the variables scope and assign value to each
iteration.

Regards,

Phillip B. Holmes

Example of query to structure:

stGetCust=StructNew();
for(IDX=1; IDX LTE qGetCust.recordcount; IDX=incrementvalue(IDX)){
"stGetCust.#qGetCust.CustomerID[IDX]#.CustomerID" =
qGetCust.CustomerID[IDX];
"stGetCust.#qGetCust.CustomerID[IDX]#.CompanyName" =
qGetCust.CompanyName[IDX];
"stGetCust.#qGetCust.CustomerID[IDX]#.ContactName" =
qGetCust.ContactName[IDX];
"stGetCust.#qGetCust.CustomerID[IDX]#.Phone" = qGetCust.Phone[IDX];
"stGetCust.#qGetCust.CustomerID[IDX]#.Fax" = qGetCust.Fax[IDX];
 }

>




 

-Original Message-
From: Jared Rypka-Hauer - CMG, LLC [mailto:[EMAIL PROTECTED] 
Sent: Saturday, February 12, 2005 2:29 PM
To: CF-Talk
Subject: Re: Weird Problem with Structure

Dave,

I had an interesting thing happen the other day. I was messing around with
something, trying to find a way around a particular problem, and I used this
code... fully expecting it to error out:




 

Now, had I put myTest["#i#"], I would have expected it to work. What I ended
up with when I dumped it was a struct that looked very much like an array.

This was on CFMX 6.1, just kinda struck me odd.

Laterz,
J


On Fri, 11 Feb 2005 14:21:48 -0500, Dave Watts <[EMAIL PROTECTED]> wrote:
> 
> "2" is not a valid variable name. If you use dot notation with 
> structures and their members, you must use valid CF variable names for
those members.
> If you want to use arbitrary strings for those members, you must use 
> array
> notation:
> 
> lines["2"]
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized 
> instruction at our training centers in Washington DC, Atlanta, 
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
> 
> 



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

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

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

RE: Weird Problem with Structure

[Dave Watts]

> I had an interesting thing happen the other day. I was 
> messing around with something, trying to find a way around a 
> particular problem, and I used this code... fully expecting 
> it to error out:
> 
> 
> 
> 
>   
> 
> Now, had I put myTest["#i#"], I would have expected it to 
> work. What I ended up with when I dumped it was a struct that 
> looked very much like an array.
> 
> This was on CFMX 6.1, just kinda struck me odd.

Actually, that makes perfect sense.

When you use array notation, you can specify whatever values you like. Since
CF is a typeless language, any value stored within a variable will be
treated as a string when you use array notation to make it a member name for
a structure.

Keep in mind that the two values of foo are the same in the example below:




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

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


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

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

Re: Weird Problem with Structure

[Jared Rypka-Hauer - CMG, LLC]

Dave,

I had an interesting thing happen the other day. I was messing around
with something, trying to find a way around a particular problem, and
I used this code... fully expecting it to error out:




 

Now, had I put myTest["#i#"], I would have expected it to work. What I
ended up with when I dumped it was a struct that looked very much like
an array.

This was on CFMX 6.1, just kinda struck me odd.

Laterz,
J


On Fri, 11 Feb 2005 14:21:48 -0500, Dave Watts <[EMAIL PROTECTED]> wrote:
> 
> "2" is not a valid variable name. If you use dot notation with structures
> and their members, you must use valid CF variable names for those members.
> If you want to use arbitrary strings for those members, you must use array
> notation:
> 
> lines["2"]
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> 
> Fig Leaf Software provides the highest caliber vendor-authorized
> instruction at our training centers in Washington DC, Atlanta,
> Chicago, Baltimore, Northern Virginia, or on-site at your location.
> Visit http://training.figleaf.com/ for more information!
> 
> 

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

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

RE: Weird Problem with Structure

[Dave Watts]

> I have a structure "lines"
> 
> when I dump that it shows me structure under structure.
> 
> when I dump "lines.2" it also shows me the other elements 
> inside that structure.
> like 
> 
> struct
> ADDRESS  ABC BLVD
> CITY  Toronto
> COMPANY  ABC Company
> COUNTRY  CANADA
> FNAME  My Firstname
> LNAME  My Lastname
> STATE  ON
> ZIP  myzip/postal code.
> 
> when i try to reference that variable directly like 
> #lines[2]['Address']#
> 
> it gives me an error.
> Element Address is undefined in a CFML structure referenced 
> as part of an expression.
> 
> 
> When I tried
> #lines.2.address#
> 
> Element 2.ADDRESS is undefined in LINES.

"2" is not a valid variable name. If you use dot notation with structures
and their members, you must use valid CF variable names for those members.
If you want to use arbitrary strings for those members, you must use array
notation:

lines["2"]

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

Fig Leaf Software provides the highest caliber vendor-authorized 
instruction at our training centers in Washington DC, Atlanta, 
Chicago, Baltimore, Northern Virginia, or on-site at your location. 
Visit http://training.figleaf.com/ for more information!


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

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

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

Re: Weird Problem

[Russell Patterson]

This may sound funny, but do you experience this problem from other web browsers?  If not, it may be as simple as deleting your local cache from your web browser.  I have had a similar problem to this and this solved my problem.

Russell
  - Original Message - 
  From: Ewok 
  To: CF-Talk 
  Sent: Friday, September 10, 2004 5:31 PM
  Subject: RE: Weird Problem

  Nope. nothing has changed since 3 days ago when I made a successful update
  to the same site and today when it won't display changes. Everyone else went
  home with no concerns. so I guess I'll call it day too.

 _  

  From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
  Sent: Friday, September 10, 2004 6:21 PM
  To: CF-Talk
  Subject: Re: Weird Problem

  >>Could the server possibly be caching and entire page?

  Or some proxy you are going through?

  --
  ___
  REUSE CODE! Use custom tags;
  See http://www.contentbox.com/claude/customtags/tagstore.cfm
  (Please send any spam to this address: [EMAIL PROTECTED])
  Thanks.

 _  

  [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads]
  [HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:177992"This
  Message] [HYPERLINK
  "http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK
  "http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast
  Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings]
  [HYPERLINK
  "https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus
  iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation
  s and Support] 

 _  

  HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=40" \n

  ---
  Incoming mail is certified Virus Free.
  Checked by AVG anti-virus system (http://www.grisoft.com).
  Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004

  ---
  Outgoing mail is certified Virus Free.
  Checked by AVG anti-virus system (http://www.grisoft.com).
  Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Weird Problem

[Ewok]

Nope… nothing has changed since 3 days ago when I made a successful update
to the same site and today when it won’t display changes. Everyone else went
home with no concerns… so I guess I’ll call it day too.

   _  

From: Claude Schneegans [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 10, 2004 6:21 PM
To: CF-Talk
Subject: Re: Weird Problem

>>Could the server possibly be caching and entire page?

Or some proxy you are going through?

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.

   _  

[HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads]
[HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:177992"This
Message] [HYPERLINK
"http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK
"http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast
Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings]
[HYPERLINK
"https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus
iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation
s and Support] 

   _  

HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=40" \n

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Weird Problem

[Claude Schneegans]

>>Could the server possibly be caching and entire page?

Or some proxy you are going through?

--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Weird Problem

[joe velez]

hmmm - i dunno, reboot :)  .. check the web server's path to your files and make sure you put the files in the right place. are you sure you overwrite the files? check the date modified 

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

RE: Weird Problem

[Ewok]

It’s our server and has never done this before. It hasn’t been “setup” to
cache our dynamic pages. Any other suggestions?

   _  

From: joe velez [mailto:[EMAIL PROTECTED] 
Sent: Friday, September 10, 2004 5:39 PM
To: CF-Talk
Subject: Re: Weird Problem

yes the server can cache files .. talk to your host to see if this is the
case

   _  

[HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=t:4"Todays Threads]
[HYPERLINK "http://www.houseoffusion.com/lists.cfm/link=i:4:177986"This
Message] [HYPERLINK
"http://www.houseoffusion.com/lists.cfm/link=s:4"Subscription] [HYPERLINK
"http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=678.598.4"Fast
Unsubscribe] [HYPERLINK "http://www.houseoffusion.com/signin/"User Settings]
[HYPERLINK
"https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&bus
iness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick"Donation
s and Support] 

   _  

HYPERLINK "http://www.houseoffusion.com/banners/view.cfm?bannerid=17" \n

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Re: Weird Problem

[joe velez]

yes the server can cache files .. talk to your host to see if this is the case
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

Weird Problem

[Ewok]

I made some changes to a site earlier but when I uploaded the .cfm pages,
the changes didn’t show up on the site.

So I cleared my cache blah blah… still no changes.

I made EXTRA sure I was putting the files in the right place and they are
absolutely there. I even downloaded the template to MAKE sure and the
changes are in there… they just ….won’t… show…..up *beating head on the
desk*

Could the server possibly be caching and entire page? It was in no way set
up to…

I’m completely out of ideas… 

Download File

Edit File

Upload File

How hard can it be?!?!?!

It’s on a secure server if it matters… *crying now*

I feel like Clark Grizwald in National Lampoons European Vacation when he
just couldn’t get in the left lane. It’s not like it’s a hard thing to do…
it just won’t happen! 

I’m not asking for a lot, I got up, I ate my breakfast, I went to work, it
SEEMED like an ok day….*trails off*


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.759 / Virus Database: 508 - Release Date: 9/9/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]
 [Donations and Support]

RE: Weird problem with Next X records

[Pascal Peters]

Very hard to answer without code.
For your second problem: your next-n is working on individual records, not groups, so it works as intended. Show first three (3 ben), then next three (1 ben, 2 john). You will have to find an alternative to make the next-n work on accounts. You could make 2 queries instead of one. A query to get accounts (use that for your next-n interface) and one to get customers.

Pascal

> -Original Message-
> From: Ben Densmore [mailto:[EMAIL PROTECTED] 
> Sent: woensdag 26 mei 2004 3:35
> To: CF-Talk
> Subject: Weird problem with Next X records
> 
> I have an application that I am using Next and Previous 
> records links to sort through data. 
> 
> The I'm using the group attribute in the  tag to 
> group by the customerID. My page will look like:
> 
> Ben's Accounts
>  CustomerID1
>  CustomerID2
>  CustomerID3
>  CustomerID4
> 
> Johns Accounts
>  CustomerID1
>  CustomerID2
> 
> This will output a maximum of 3 accounts per page but with 
> any number of customerID's. The odd thing is if there are say 
> 4 accounts, when I click the next link to diaplay the 4th 
> record it duplicated the first 3 records to me and if I click 
> next again I then get the 4th record.
> 
> One other strange thing is say in my example Ben's Accounts 
> is the first record displayed and it has 4 customerIDs, when 
> I click the next link and it show's me the duplicate of Ben's 
> accounts on the next page it only has the 4th customerID.
> 
> Has anyone run into something like this before? I'm thinking 
> the group attribute might be causing this but I'm not sure.
> 
> Thanks,
> Ben
> 
> **
> **
>  
> This e-mail and any files transmitted with it are 
> confidential and intended solely for the use of the 
> individual or entity to which they are addressed. If you have 
> received this e-mail in error please notify the system manager.
>  
> This e-mail message has been swept for the presence of 
> computer viruses. 
>  
> WARNING: All e-mail sent to this address will be received by 
> the HMC network and is subject to archival and review by 
> someone other than the recipient.
> 
> **
> **
>  
> 
> 
> 
>
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]

Weird problem with Next X records

[Ben Densmore]

I have an application that I am using Next and Previous records links to sort through data. 

The I'm using the group attribute in the  tag to group by the customerID. My page will look like:

Ben's Accounts
 CustomerID1
 CustomerID2
 CustomerID3
 CustomerID4

Johns Accounts
 CustomerID1
 CustomerID2

This will output a maximum of 3 accounts per page but with any number of customerID's. The odd thing is if there are say 4 accounts, when I click the next link to diaplay the 4th record it duplicated the first 3 records to me and if I click next again I then get the 4th record.

One other strange thing is say in my example Ben's Accounts is the first record displayed and it has 4 customerIDs, when I click the next link and it show's me the duplicate of Ben's accounts on the next page it only has the 4th customerID.

Has anyone run into something like this before? I'm thinking the group attribute might be causing this but I'm not sure.

Thanks,
Ben


 
This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual 
or entity to which they are addressed. If you have received this e-mail in error please notify the system manager.
 
This e-mail message has been swept for the presence of computer viruses. 
 
WARNING: All e-mail sent to this address will be received by the HMC network and is subject to archival and review 
by someone other than the recipient.


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

RE: Weird problem with CFEXECUTE not releasing file

[Shawn McKee]

Anybody have a Linux version of this?

Shawn McKee

-Original Message-
From: Lewis Sellers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 3:07 PM
To: CF-Talk
Subject: Re: Weird problem with CFEXECUTE not releasing file


On Thu, 27 Jun 2002 08:47:14 -0400, in cf-talk you wrote:

>> FYI. There's also it's successor, CFX_Execute. Which I also wrote.
>> It's "more like CFEXECUTE, except for the bugs". :)
>
>I was unable to find CFX_Execute on the MM developer exchange... could you
>email me a copy off list at [EMAIL PROTECTED] or even just send me a
>link that I can download from?

I stopped use the exchange ages ago because it never worked (cfml
errors or other problems). Maybe Macromedia's gotten it working now.
Haven't looked in many many months. Anyway...

http://www.intrafoundation.com/freeware.html.

Everything's there.

--min


__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird problem with CFEXECUTE not releasing file

[Lewis Sellers]

On Thu, 27 Jun 2002 08:47:14 -0400, in cf-talk you wrote:

>> FYI. There's also it's successor, CFX_Execute. Which I also wrote.
>> It's "more like CFEXECUTE, except for the bugs". :)
>
>I was unable to find CFX_Execute on the MM developer exchange... could you
>email me a copy off list at [EMAIL PROTECTED] or even just send me a
>link that I can download from?

I stopped use the exchange ages ago because it never worked (cfml
errors or other problems). Maybe Macromedia's gotten it working now.
Haven't looked in many many months. Anyway...

http://www.intrafoundation.com/freeware.html.

Everything's there.

--min

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird problem with CFEXECUTE not releasing file

[Seth Petry-Johnson]

> FYI. There's also it's successor, CFX_Execute. Which I also wrote.
> It's "more like CFEXECUTE, except for the bugs". :)

I was unable to find CFX_Execute on the MM developer exchange... could you
email me a copy off list at [EMAIL PROTECTED] or even just send me a
link that I can download from?

Thanks,
Seth

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird problem with CFEXECUTE not releasing file

[Lewis Sellers]

On Wed, 26 Jun 2002 17:21:52 -0400, in cf-talk you wrote:

>> Are you using the timeout option?  If you don't specify one then the file
>> will be locked.  I have seen this problem when a command takes too long.
>I
>> just moved on to CFX_consolecommand.
>
>Yes, I have specified a timeout on the CFEXECUTE call.  Still, the weird
>thing is that it isn't UNTIL my code tries to delete the file that it gets
>"locked".  Up until I run the delete code I can manually view, edit, and
>delete the file without issue.
>
>In any case, CFX_consolecommand works great and deletes the files just fine.
>Thanks!

FYI. There's also it's successor, CFX_Execute. Which I also wrote.
It's "more like CFEXECUTE, except for the bugs". :)

--min

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird problem with CFEXECUTE not releasing file

[Seth Petry-Johnson]

> Are you using the timeout option?  If you don't specify one then the file
> will be locked.  I have seen this problem when a command takes too long.
I
> just moved on to CFX_consolecommand.

Yes, I have specified a timeout on the CFEXECUTE call.  Still, the weird
thing is that it isn't UNTIL my code tries to delete the file that it gets
"locked".  Up until I run the delete code I can manually view, edit, and
delete the file without issue.

In any case, CFX_consolecommand works great and deletes the files just fine.
Thanks!

Seth

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird problem with CFEXECUTE not releasing file

[Neil H.]

Are you using the timeout option?  If you don't specify one then the file
will be locked.  I have seen this problem when a command takes too long.  I
just moved on to CFX_consolecommand.

Neil

- Original Message -
From: "Seth Petry-Johnson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 3:48 PM
Subject: Weird problem with CFEXECUTE not releasing file


> I have been having a rather strange problem with trying to delete text
files
> created using the OUTPUTFILE attribute of the CFEXECUTE tag on CF 4.51,
> running on Win 2k Professional.  It seems that any file I create using
> CFEXECUTE gets stuck in a locked state after I try to programatically
delete
> it.
>
> Here's what my app is supposed to do:
>
> 1) I use CF to create a batch file containing multiple command line
commands
> to run.
> 2) I call CFEXECUTE to run this batch file and save the results to a text
> file for later debugging if needed.
> 3) When the database record that the batch file relates to is deleted my
> cleanup code attempts to delete both the batch file and the result text
> file, since they are no longer needed.
>
> The problem is that result text file, the one created by CFEXECUTE, never
> gets deleted.  If I try to delete it by hand, or even view it in notepad,
> I'm told the file is in use and can not be accessed.  Cycling the CF
> application service apparently frees up the text file because it
disappears
> as soon as I do so.  The batch files (which are created by CFFILE) are
> deleted without issue.
>
> The strange thing is that the text file is NOT locked until step 3.  In
> other words, after the batch file and text file are created I can edit
them
> or delete them just fine, but once I initiate the cleanup code they get
> stuck.  Also, I have tried deleting the files both using CFFILE and also
by
> creating another batch file that deletes them.  I get the same results
with
> both approaches.
>
> I'm grasping at straws and hoping that someone has seen this behaviour
> before... any suggestions?
>
> Thanks in advance,
> Seth Petry-Johnson
> Argo Enterprise and Associates
>
> 
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Weird problem with CFEXECUTE not releasing file

[Seth Petry-Johnson]

I have been having a rather strange problem with trying to delete text files
created using the OUTPUTFILE attribute of the CFEXECUTE tag on CF 4.51,
running on Win 2k Professional.  It seems that any file I create using
CFEXECUTE gets stuck in a locked state after I try to programatically delete
it.

Here's what my app is supposed to do:

1) I use CF to create a batch file containing multiple command line commands
to run.
2) I call CFEXECUTE to run this batch file and save the results to a text
file for later debugging if needed.
3) When the database record that the batch file relates to is deleted my
cleanup code attempts to delete both the batch file and the result text
file, since they are no longer needed.

The problem is that result text file, the one created by CFEXECUTE, never
gets deleted.  If I try to delete it by hand, or even view it in notepad,
I'm told the file is in use and can not be accessed.  Cycling the CF
application service apparently frees up the text file because it disappears
as soon as I do so.  The batch files (which are created by CFFILE) are
deleted without issue.

The strange thing is that the text file is NOT locked until step 3.  In
other words, after the batch file and text file are created I can edit them
or delete them just fine, but once I initiate the cleanup code they get
stuck.  Also, I have tried deleting the files both using CFFILE and also by
creating another batch file that deletes them.  I get the same results with
both approaches.

I'm grasping at straws and hoping that someone has seen this behaviour
before... any suggestions?

Thanks in advance,
Seth Petry-Johnson
Argo Enterprise and Associates

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Problem with CF-Admin

[Chris Norloff]

Hope you've solved it now. I'd stop/start the CF server and see if that fixes it.  If 
not, I'd look at the cf.registry file.

We've been running CF on Solaris for several years and have been very happy (and no, 
haven't seen the problem you experienced).

best,
Chris Norloff

-- Original Message --
from: "James Taavon" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 10 Jun 2002 13:23:26 -0400

>um... ok. not the solution i was looking for, but an interesting one to say
>the least.
>
>-Original Message-
>From: Critz [mailto:[EMAIL PROTECTED]]
>Sent: Monday, June 10, 2002 12:19 PM
>To: CF-Talk
>Subject: Re: Weird Problem with CF-Admin
>
>
>oi James!!
>
>we  ran  into that problem ages ago running cf on solaris. I don't think we
>ever
>sorted the problem, except that we canned solaris and went back to win2k.
>*poof*
>no more problem
>
>
>--
>Critz
>Certified Adv. ColdFusion Developer
>
>Crit[s2k] - 
>
>Monday, June 10, 2002, 12:02:13 PM, you wrote:
>
>JT> Ok, this is a first for me. I was checking my datasources on my CF
>machine
>JT> and when I went to create a new datasource my whole list of existing
>JT> datasources disappeared. How can that happen??? So for fun I tried to
>JT> re-create one of the existing datasources only to find out that CF told
>me
>JT> that it exists and use another name. When I go to my CF ODBC page, the
>page
>JT> are blank,, but the connections obviously still are there. Should
>stopping
>JT> and re-starting the services fix this problem?? Using CF 4.51 on
>Solaris.
>
>
>
>
>
>
>JT>
>
>
__
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Problem with CF-Admin

[James Taavon]

um... ok. not the solution i was looking for, but an interesting one to say
the least.

-Original Message-
From: Critz [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 10, 2002 12:19 PM
To: CF-Talk
Subject: Re: Weird Problem with CF-Admin


oi James!!

we  ran  into that problem ages ago running cf on solaris. I don't think we
ever
sorted the problem, except that we canned solaris and went back to win2k.
*poof*
no more problem


--
Critz
Certified Adv. ColdFusion Developer

Crit[s2k] - 

Monday, June 10, 2002, 12:02:13 PM, you wrote:

JT> Ok, this is a first for me. I was checking my datasources on my CF
machine
JT> and when I went to create a new datasource my whole list of existing
JT> datasources disappeared. How can that happen??? So for fun I tried to
JT> re-create one of the existing datasources only to find out that CF told
me
JT> that it exists and use another name. When I go to my CF ODBC page, the
page
JT> are blank,, but the connections obviously still are there. Should
stopping
JT> and re-starting the services fix this problem?? Using CF 4.51 on
Solaris.






JT>

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird Problem with CF-Admin

[Critz]

oi James!!

we  ran  into that problem ages ago running cf on solaris. I don't think we ever
sorted the problem, except that we canned solaris and went back to win2k. *poof*
no more problem


-- 
Critz
Certified Adv. ColdFusion Developer

Crit[s2k] - 

Monday, June 10, 2002, 12:02:13 PM, you wrote:

JT> Ok, this is a first for me. I was checking my datasources on my CF machine
JT> and when I went to create a new datasource my whole list of existing
JT> datasources disappeared. How can that happen??? So for fun I tried to
JT> re-create one of the existing datasources only to find out that CF told me
JT> that it exists and use another name. When I go to my CF ODBC page, the page
JT> are blank,, but the connections obviously still are there. Should stopping
JT> and re-starting the services fix this problem?? Using CF 4.51 on Solaris.






JT> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Weird Problem with CF-Admin

[James Taavon]

Ok, this is a first for me. I was checking my datasources on my CF machine
and when I went to create a new datasource my whole list of existing
datasources disappeared. How can that happen??? So for fun I tried to
re-create one of the existing datasources only to find out that CF told me
that it exists and use another name. When I go to my CF ODBC page, the page
are blank,, but the connections obviously still are there. Should stopping
and re-starting the services fix this problem?? Using CF 4.51 on Solaris.






__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: SQL weird problem

[Janine Jakim]

I have an odd problem on my sql2000 and hoping someone can help.
I am doing a report card system. What I do is run append queries for all the
schools.  The teachers when "adding" grades are actually doing an update
query.
Because the fields are populated with an array I have set placeholders in
each field so the update query won't shift the grades up.
I have one teacher who's grades shifted- several of his students had invalid
grades for one subject.  I did a query asking for all grade <>.. (the
placeholder)
Sure enough the students whose grades had shifted appeared on the list! I
added a fake grades but when I took out the fake grades and returned the
field to .. it again showed up in my query that said all grades but ..
So for these students the database isn't seeing the grades as having any
placeholders- then the updates go into the wrong spaces if he does not do
the report cards in the report cards in the order that they are set up as
the array is populating the database starting with the "blank" grades.
I don't get it and I'm pretty confused.  I've never seen this before.
Any ideas out there?
__
Dedicated Windows 2000 Server
  PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
  Instant Activation · $99/Month · Free Setup
  http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird problem with CF-Talk on newsgroups

[Jamie Jackson]

Dimo asked privately how to post to the group via a newsreader.

Steps:
1. Subscribe to the digest version of cf-talk, and have your email
client filter those digest emails straight to the trash can.
2. Use fuseware.com as your news server.
3. Your news reader should support "reply by email" and "post by
email." Use those to post your new thread or reply to
[EMAIL PROTECTED]

Let me know if you have any questions,
Jamie


On Thu, 06 Dec 2001 12:31:41 -0500, in cf-talk you wrote:

>Works perfectly on Forte Agent (where I'm writing from now).
>
>I can't imagine trying to sort out all these posts in an email client.
>
>Jamie
>
>On Thu, 06 Dec 2001 11:04:33 -0500, in cf-talk you wrote:
>
>>Has anyne tried to use the news.fuseware.com newsserver to access 
>>CF-Talk. I have been reading CF-Talk for several months now via 
>>newsgroup access with Outlook Express, everything seems to be fine. 
Now,
> 
>>I switched to Netscape News reader and all the messages there have for 
>>date 12/31/69 7:00 PM.
>>
>>Does anyone have an idea where the problem is, is it fuseware issue, or
 
>>Netscape news problem?
>>
>>Thanks,
>>Dimo
>>
>>
>>
>>
>>
>
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird problem with CF-Talk on newsgroups

[Jamie Jackson]

Works perfectly on Forte Agent (where I'm writing from now).

I can't imagine trying to sort out all these posts in an email client.

Jamie

On Thu, 06 Dec 2001 11:04:33 -0500, in cf-talk you wrote:

>Has anyne tried to use the news.fuseware.com newsserver to access 
>CF-Talk. I have been reading CF-Talk for several months now via 
>newsgroup access with Outlook Express, everything seems to be fine. Now,
 
>I switched to Netscape News reader and all the messages there have for 
>date 12/31/69 7:00 PM.
>
>Does anyone have an idea where the problem is, is it fuseware issue, or 
>Netscape news problem?
>
>Thanks,
>Dimo
>
>
>
>
>
~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird problem with CF-Talk on newsgroups

[Shawn Grover]

I would guess that it's a Netscape issue.  I recall that trying to get the
page modified date from CGI variables would work fine in IE, but Netscape
interpreted the info a little differently and gave dates similar to what you
are seeing.

Of course, I could be wrong and it could be a different issue altogther.

Shawn Grover

-Original Message-
From: Dimo Michailov [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 9:05 AM
To: CF-Talk
Subject: Weird problem with CF-Talk on newsgroups


Has anyne tried to use the news.fuseware.com newsserver to access 
CF-Talk. I have been reading CF-Talk for several months now via 
newsgroup access with Outlook Express, everything seems to be fine. Now, 
I switched to Netscape News reader and all the messages there have for 
date 12/31/69 7:00 PM.

Does anyone have an idea where the problem is, is it fuseware issue, or 
Netscape news problem?

Thanks,
Dimo





~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird problem with CF-Talk on newsgroups

[Smith, Daron [PA]]

I can't even get to it from Outlook Express

-Original Message-
From: Dimo Michailov [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 06, 2001 11:05 AM
To: CF-Talk
Subject: Weird problem with CF-Talk on newsgroups


Has anyne tried to use the news.fuseware.com newsserver to access 
CF-Talk. I have been reading CF-Talk for several months now via 
newsgroup access with Outlook Express, everything seems to be fine. Now, 
I switched to Netscape News reader and all the messages there have for 
date 12/31/69 7:00 PM.

Does anyone have an idea where the problem is, is it fuseware issue, or 
Netscape news problem?

Thanks,
Dimo





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Weird problem with CF-Talk on newsgroups

[Dimo Michailov]

Has anyne tried to use the news.fuseware.com newsserver to access 
CF-Talk. I have been reading CF-Talk for several months now via 
newsgroup access with Outlook Express, everything seems to be fine. Now, 
I switched to Netscape News reader and all the messages there have for 
date 12/31/69 7:00 PM.

Does anyone have an idea where the problem is, is it fuseware issue, or 
Netscape news problem?

Thanks,
Dimo




~~
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird problem setting client variable

[Perez, Bismark]

so, even if a redirect the page right after the  and don't care about
the client var until the next page the var won't be set because of the
re-direct?

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 11:44 AM
To: CF-Talk
Subject: RE: Weird problem setting client variable


I would imagine its because you cannot use CFLOCATION and set cookies in the
same template.  The cookie (client var) is only set AFTER the whole page has
been processed.
This may be the problem.
Nick Betts.

-Original Message-
From: Perez, Bismark [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 16:03
To: CF-Talk
Subject: Weird problem setting client variable


I have the weirdest problem setting a client variable and for the live of me
I can not see where the problem is.  The problem is the following:

I have a form where the user can change the language of the site, one of the
fields on the form is a select box named "NewLang", now, once the user
selects the new language the form is posted to a template (ChangeLang.cfm)
which only function is to  and then
 to the parent template.  The first line in the application.cfm
is to  for client.lang and set it to "en" if is not defined, some
how it is always set to "en" because client.lang is not defined. 

Now I know app.cfm is always executed, so before ChangeLang.cfm is executed
the client.lang is set to "en" then the template is executed and client.lang
is set to the new language and a redirection occurs to the parent template,
client.lang should contain the new language, but is not because the
 resets it to "en".

Can somebody see where the problem is...
TIA

Bismarck Perez
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird problem setting client variable

[Jason Santerre]

**
i didn't send this to you.. sorry the reply u sent went to the wrong person.
**
At 04:44 PM 6/11/2001, you wrote:
>I would imagine its because you cannot use CFLOCATION and set cookies in the
>same template.  The cookie (client var) is only set AFTER the whole page has
>been processed.
>This may be the problem.
>Nick Betts.
>
>-Original Message-
>From: Perez, Bismark [mailto:[EMAIL PROTECTED]]
>Sent: 11 June 2001 16:03
>To: CF-Talk
>Subject: Weird problem setting client variable
>
>
>I have the weirdest problem setting a client variable and for the live of me
>I can not see where the problem is.  The problem is the following:
>
>I have a form where the user can change the language of the site, one of the
>fields on the form is a select box named "NewLang", now, once the user
>selects the new language the form is posted to a template (ChangeLang.cfm)
>which only function is to  and then
> to the parent template.  The first line in the application.cfm
>is to  for client.lang and set it to "en" if is not defined, some
>how it is always set to "en" because client.lang is not defined.
>
>Now I know app.cfm is always executed, so before ChangeLang.cfm is executed
>the client.lang is set to "en" then the template is executed and client.lang
>is set to the new language and a redirection occurs to the parent template,
>client.lang should contain the new language, but is not because the
> resets it to "en".
>
>Can somebody see where the problem is...
>TIA
>
>Bismarck Perez
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird problem setting client variable

[Nick Betts]

I would imagine its because you cannot use CFLOCATION and set cookies in the
same template.  The cookie (client var) is only set AFTER the whole page has
been processed.
This may be the problem.
Nick Betts.

-Original Message-
From: Perez, Bismark [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 16:03
To: CF-Talk
Subject: Weird problem setting client variable


I have the weirdest problem setting a client variable and for the live of me
I can not see where the problem is.  The problem is the following:

I have a form where the user can change the language of the site, one of the
fields on the form is a select box named "NewLang", now, once the user
selects the new language the form is posted to a template (ChangeLang.cfm)
which only function is to  and then
 to the parent template.  The first line in the application.cfm
is to  for client.lang and set it to "en" if is not defined, some
how it is always set to "en" because client.lang is not defined. 

Now I know app.cfm is always executed, so before ChangeLang.cfm is executed
the client.lang is set to "en" then the template is executed and client.lang
is set to the new language and a redirection occurs to the parent template,
client.lang should contain the new language, but is not because the
 resets it to "en".

Can somebody see where the problem is...
TIA

Bismarck Perez
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird problem setting client variable

[Chris Jenkins]

Try to avoid having the redirect on the same page your are setting the
client variable.

-Original Message-
From: Perez, Bismark [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 8:03 AM
To: CF-Talk
Subject: Weird problem setting client variable


I have the weirdest problem setting a client variable and for the live of me
I can not see where the problem is.  The problem is the following:

I have a form where the user can change the language of the site, one of the
fields on the form is a select box named "NewLang", now, once the user
selects the new language the form is posted to a template (ChangeLang.cfm)
which only function is to  and then
 to the parent template.  The first line in the application.cfm
is to  for client.lang and set it to "en" if is not defined, some
how it is always set to "en" because client.lang is not defined.

Now I know app.cfm is always executed, so before ChangeLang.cfm is executed
the client.lang is set to "en" then the template is executed and client.lang
is set to the new language and a redirection occurs to the parent template,
client.lang should contain the new language, but is not because the
 resets it to "en".

Can somebody see where the problem is...
TIA

Bismarck Perez
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird problem setting client variable

[Craig Dudley]

If you're storing client variables in cookies the cflocation will break them
always.

Change client variable storage to a datasource, use another way of
re-locating or use a locked session variable would be my suggestions.

HTH, Craig


-Original Message-
From: Perez, Bismark [mailto:[EMAIL PROTECTED]]
Sent: 11 June 2001 16:03
To: CF-Talk
Subject: Weird problem setting client variable


I have the weirdest problem setting a client variable and for the live of me
I can not see where the problem is.  The problem is the following:

I have a form where the user can change the language of the site, one of the
fields on the form is a select box named "NewLang", now, once the user
selects the new language the form is posted to a template (ChangeLang.cfm)
which only function is to  and then
 to the parent template.  The first line in the application.cfm
is to  for client.lang and set it to "en" if is not defined, some
how it is always set to "en" because client.lang is not defined. 

Now I know app.cfm is always executed, so before ChangeLang.cfm is executed
the client.lang is set to "en" then the template is executed and client.lang
is set to the new language and a redirection occurs to the parent template,
client.lang should contain the new language, but is not because the
 resets it to "en".

Can somebody see where the problem is...
TIA

Bismarck Perez
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Weird problem setting client variable

[Perez, Bismark]

I have the weirdest problem setting a client variable and for the live of me
I can not see where the problem is.  The problem is the following:

I have a form where the user can change the language of the site, one of the
fields on the form is a select box named "NewLang", now, once the user
selects the new language the form is posted to a template (ChangeLang.cfm)
which only function is to  and then
 to the parent template.  The first line in the application.cfm
is to  for client.lang and set it to "en" if is not defined, some
how it is always set to "en" because client.lang is not defined. 

Now I know app.cfm is always executed, so before ChangeLang.cfm is executed
the client.lang is set to "en" then the template is executed and client.lang
is set to the new language and a redirection occurs to the parent template,
client.lang should contain the new language, but is not because the
 resets it to "en".

Can somebody see where the problem is...
TIA

Bismarck Perez


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird Problem - Additional Info

[Billy Cravens]

That's because html uses quotation marks as delimiters.. try escaping it
somehow .. perhaps 
#htmlcodeformat(mystring)#

-- 
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]



[EMAIL PROTECTED] wrote:
> 
> In addition, if I put single quotes in, it works just fine.
> 
> Any info would be appreciated.
> Mary
> - Forwarded by Mary Baotic/na/Hyperion on 01/30/01 07:45 AM -
> 
> I am having the strangest problem...
> 
> I have a varchar field in a SQL database.  It contains the following text:
> this is a "quoted title" to view
> 
> When I go to display in a form (using either cfinput or input) everything
> after the first quote is cut off in the text box.  But if I display the
> code before the text box , the field contains all the proper information.
> 
> So the field is coming back fine, but when the form is displaying, it cuts
> it off.
> 
> I am using .
> 
> Does anyone have any ideas?
> 
> TIA
> Mary
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird Problem

[Mary_Baotic]

Yes this worked.  I got a private email with this same solution.

Thanks!
Mary


   
   
"Chris Sham"   
   
<[EMAIL PROTECTED]To: CF-Talk 
<[EMAIL PROTECTED]>
s.fsu.edu> cc: 
   
   Subject: Re: Weird Problem  
   
01/30/01 09:46 AM  
   
Please respond to  
   
cf-talk
   
   
   
   
   




Note what you are doing.  In essence you are saying 'INPUT TYPE="TEXT"
VALUE="this is a "quoted title" to view">  See the error.  If you use
HTMLEditFormat you will be fine.  For example, 'INPUT TYPE="TEXT"
VALUE="#HTMLEditFormat(myVar)#">

Chris


- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 7:37 AM
Subject: Weird Problem


> I am having the strangest problem...
>
> I have a varchar field in a SQL database.  It contains the following
text:
> this is a "quoted title" to view
>
> When I go to display in a form (using either cfinput or input) everything
> after the first quote is cut off in the text box.  But if I display the
> code before the text box , the field contains all the proper information.
>
> So the field is coming back fine, but when the form is displaying, it
cuts
> it off.
>
> I am using .
>
> Does anyone have any ideas?
>
> TIA
> Mary
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Problem - Additional Info

[Philip Arnold - ASP]

> I am having the strangest problem...
>
> I have a varchar field in a SQL database.  It contains the following text:
> this is a "quoted title" to view
>
> When I go to display in a form (using either cfinput or input) everything
> after the first quote is cut off in the text box.  But if I display the
> code before the text box , the field contains all the proper information.
>
> So the field is coming back fine, but when the form is displaying, it cuts
> it off.

Remeber that it starts the value part of the input with quotes, therefore it
thinks that the next quote is the end

Put the value as Replace(myField,,""","all")

HTML naturally converts the " into " in the input

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Problem - Additional Info

[Cornillon, Matthieu]

Mary,

If I understand correctly, your code looks roughly like this:


SELECT VarCharField FROM blah blah blah






blah
blah
blah


So, your field value:

this is a "quoted title" to view

is plugged in, so that the VALUE parameter reads:

VALUE="this is a "quoted title" to view"

If you use single quotes, it works, since the single quotes inside the
double quotes get translated into double quotes in the final.  What you
might do is use the Replace function to replace double quotes with single
quotes as you put the value in the parameter statement.  Your statement
would look like this:



I am not sure that this is what you are looking for, but hopefully it will
get you started in the right direction.

Matthieu




> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 30, 2001 7:42 AM
> To: CF-Talk
> Subject: Weird Problem - Additional Info
> 
> 
> In addition, if I put single quotes in, it works just fine.
> 
> Any info would be appreciated.
> Mary
> - Forwarded by Mary Baotic/na/Hyperion on 01/30/01 07:45 AM -
> 
> I am having the strangest problem...
> 
> I have a varchar field in a SQL database.  It contains the 
> following text:
> this is a "quoted title" to view
> 
> When I go to display in a form (using either cfinput or 
> input) everything
> after the first quote is cut off in the text box.  But if I 
> display the
> code before the text box , the field contains all the proper 
> information.
> 
> So the field is coming back fine, but when the form is 
> displaying, it cuts
> it off.
> 
> I am using .
> 
> Does anyone have any ideas?
> 
> TIA
> Mary
> 
> 
> 
> 
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Problem

[Steve Martin]

Mary,
The quote is closing the quote in the form thus rendering it invisible.


> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: 30 January 2001 12:37
> To: CF-Talk
> Subject: Weird Problem
>
>
> I am having the strangest problem...
>
> I have a varchar field in a SQL database.  It contains the following text:
> this is a "quoted title" to view
>
> When I go to display in a form (using either cfinput or input) everything
> after the first quote is cut off in the text box.  But if I display the
> code before the text box , the field contains all the proper information.
>
> So the field is coming back fine, but when the form is displaying, it cuts
> it off.
>
> I am using .
>
> Does anyone have any ideas?
>
> TIA
> Mary
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Problem

[Lord, Heath]

Use HTMLEditFormat() around the variable you are outputting.
Heath

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 7:37 AM
To: CF-Talk
Subject: Weird Problem


I am having the strangest problem...

I have a varchar field in a SQL database.  It contains the following text:
this is a "quoted title" to view

When I go to display in a form (using either cfinput or input) everything
after the first quote is cut off in the text box.  But if I display the
code before the text box , the field contains all the proper information.

So the field is coming back fine, but when the form is displaying, it cuts
it off.

I am using .

Does anyone have any ideas?

TIA
Mary
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Problem - Additional Info

[Milks, Jim]

Sure. Your tag thinks it has reached the end of the VALUE parameter when it
encounters the double quote contained in the string. Use Single quotes in
your tag, and it will work just fine...until you put single quotes in your
string...

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 7:42 AM
To: CF-Talk
Subject: Weird Problem - Additional Info


In addition, if I put single quotes in, it works just fine.

Any info would be appreciated.
Mary
- Forwarded by Mary Baotic/na/Hyperion on 01/30/01 07:45 AM -

I am having the strangest problem...

I have a varchar field in a SQL database.  It contains the following text:
this is a "quoted title" to view

When I go to display in a form (using either cfinput or input) everything
after the first quote is cut off in the text box.  But if I display the
code before the text box , the field contains all the proper information.

So the field is coming back fine, but when the form is displaying, it cuts
it off.

I am using .

Does anyone have any ideas?

TIA
Mary
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Weird Problem - Additional Info

[Dylan Bromby]

if you're using the VALUE attribute with double quotes, and the value of the
VALUE attribute has double quotes in it, that might be the problem.

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 30, 2001 4:42 AM
To: CF-Talk
Subject: Weird Problem - Additional Info


In addition, if I put single quotes in, it works just fine.

Any info would be appreciated.
Mary
- Forwarded by Mary Baotic/na/Hyperion on 01/30/01 07:45 AM -

I am having the strangest problem...

I have a varchar field in a SQL database.  It contains the following text:
this is a "quoted title" to view

When I go to display in a form (using either cfinput or input) everything
after the first quote is cut off in the text box.  But if I display the
code before the text box , the field contains all the proper information.

So the field is coming back fine, but when the form is displaying, it cuts
it off.

I am using .

Does anyone have any ideas?

TIA
Mary
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Weird Problem

[Chris Sham]

Note what you are doing.  In essence you are saying 'INPUT TYPE="TEXT"
VALUE="this is a "quoted title" to view">  See the error.  If you use
HTMLEditFormat you will be fine.  For example, 'INPUT TYPE="TEXT"
VALUE="#HTMLEditFormat(myVar)#">

Chris


- Original Message -
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 7:37 AM
Subject: Weird Problem


> I am having the strangest problem...
>
> I have a varchar field in a SQL database.  It contains the following text:
> this is a "quoted title" to view
>
> When I go to display in a form (using either cfinput or input) everything
> after the first quote is cut off in the text box.  But if I display the
> code before the text box , the field contains all the proper information.
>
> So the field is coming back fine, but when the form is displaying, it cuts
> it off.
>
> I am using .
>
> Does anyone have any ideas?
>
> TIA
> Mary
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Weird Problem - Additional Info

[Mary_Baotic]

In addition, if I put single quotes in, it works just fine.

Any info would be appreciated.
Mary
- Forwarded by Mary Baotic/na/Hyperion on 01/30/01 07:45 AM -

I am having the strangest problem...

I have a varchar field in a SQL database.  It contains the following text:
this is a "quoted title" to view

When I go to display in a form (using either cfinput or input) everything
after the first quote is cut off in the text box.  But if I display the
code before the text box , the field contains all the proper information.

So the field is coming back fine, but when the form is displaying, it cuts
it off.

I am using .

Does anyone have any ideas?

TIA
Mary




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Weird Problem

[Mary_Baotic]

I am having the strangest problem...

I have a varchar field in a SQL database.  It contains the following text:
this is a "quoted title" to view

When I go to display in a form (using either cfinput or input) everything
after the first quote is cut off in the text box.  But if I display the
code before the text box , the field contains all the proper information.

So the field is coming back fine, but when the form is displaying, it cuts
it off.

I am using .

Does anyone have any ideas?

TIA
Mary



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: weird problem

[Andrew Scott]

 
 
 
   
 
   
 

-Original Message-
From: AustralianAccommodation.com Pty. Ltd.
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, 27 August 2000 4:26 AM
To: [EMAIL PROTECTED]
Subject: Re: weird problem


ummm

can I have that in English please



- Original Message -
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 27, 2000 4:31 AM
Subject: RE: weird problem


| Simple before doing the cfset check the value of quantity, if its null
then
| put a zero in the array intead of throwing the returned value from the
| query:-)
|
|
| -Original Message-
| From: S R [mailto:[EMAIL PROTECTED]]
| Sent: Friday, 25 August 2000 2:54 AM
| To: [EMAIL PROTECTED]
| Subject: weird problem
|
|
| Hi everyone,
|
| I have a simple table with 4 fields (Quantity, ID, State, FirstName) .
When
| I run this query:
|
| 
| SELECT Quantity, ID FROM TestTable
| WHERE State = NULL
| 
|
| and try to do this array and output:
|
| 
| 
| 
| 
|
|
| 
| #ArraySum(QuantityTotal)#
| 
|
| I get a value that looks something like this:
|
| 1.48562799385E-306
|
| If I change the query to this:
|
| 
| SELECT Quantity, ID FROM TestTable
| WHERE Quantity <> NULL
| 
|
| It works fine. I really need to do a query against 'Blank' 'State' fields.
| What the heck is going on??
| 
| Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
|
| --
--
| --
| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| To Unsubscribe visit
| http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
| send a message to [EMAIL PROTECTED] with 'unsubscribe' in
| the body.
|
| --

| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
|


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: weird problem

[AustralianAccommodation.com Pty. Ltd.]

ummm

can I have that in English please



- Original Message -
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 27, 2000 4:31 AM
Subject: RE: weird problem


| Simple before doing the cfset check the value of quantity, if its null
then
| put a zero in the array intead of throwing the returned value from the
| query:-)
|
|
| -Original Message-
| From: S R [mailto:[EMAIL PROTECTED]]
| Sent: Friday, 25 August 2000 2:54 AM
| To: [EMAIL PROTECTED]
| Subject: weird problem
|
|
| Hi everyone,
|
| I have a simple table with 4 fields (Quantity, ID, State, FirstName) .
When
| I run this query:
|
| 
| SELECT Quantity, ID FROM TestTable
| WHERE State = NULL
| 
|
| and try to do this array and output:
|
| 
| 
| 
| 
|
|
| 
| #ArraySum(QuantityTotal)#
| 
|
| I get a value that looks something like this:
|
| 1.48562799385E-306
|
| If I change the query to this:
|
| 
| SELECT Quantity, ID FROM TestTable
| WHERE Quantity <> NULL
| 
|
| It works fine. I really need to do a query against 'Blank' 'State' fields.
| What the heck is going on??
| 
| Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
|
| --
--
| --
| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| To Unsubscribe visit
| http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
| send a message to [EMAIL PROTECTED] with 'unsubscribe' in
| the body.
|
| --

| Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
| To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
|

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: weird problem

[Andrew Scott]

Simple before doing the cfset check the value of quantity, if its null then
put a zero in the array intead of throwing the returned value from the
query:-)


-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Friday, 25 August 2000 2:54 AM
To: [EMAIL PROTECTED]
Subject: weird problem


Hi everyone,

I have a simple table with 4 fields (Quantity, ID, State, FirstName) . When
I run this query:


SELECT Quantity, ID FROM TestTable
WHERE State = NULL


and try to do this array and output:








#ArraySum(QuantityTotal)#


I get a value that looks something like this:

1.48562799385E-306

If I change the query to this:


SELECT Quantity, ID FROM TestTable
WHERE Quantity <> NULL


It works fine. I really need to do a query against 'Blank' 'State' fields.
What the heck is going on??

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: weird problem

[CHowarth]

My guess is that ArraySum() is overflowing.  Why don't you do the sum in
SQL, like this:


SELECT SUM(Quantity)
FROM TestTable
WHERE State = NULL


This will return one row with a sum of all quantities where State is NULL.
It should be faster too, as you are pushing the work to SQL Server.

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 12:54 PM
To: [EMAIL PROTECTED]
Subject: weird problem


Hi everyone,

I have a simple table with 4 fields (Quantity, ID, State, FirstName) . When 
I run this query:


SELECT Quantity, ID FROM TestTable
WHERE State = NULL


and try to do this array and output:








#ArraySum(QuantityTotal)#


I get a value that looks something like this:

1.48562799385E-306

If I change the query to this:


SELECT Quantity, ID FROM TestTable
WHERE Quantity <> NULL


It works fine. I really need to do a query against 'Blank' 'State' fields. 
What the heck is going on??

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.




This transmittal may be a confidential attorney-client communication or may otherwise 
be privileged or confidential.  If you are not the intended recipient, you are hereby 
notified that you have received this transmittal in error; any review, dissemination, 
distribution or copying of this transmittal is strictly prohibited.  If you have 
received this communication in error, please notify us immediately by reply 
([EMAIL PROTECTED]) or by telephone (call us collect at 212-403-4357) and 
immediately delete this message and all its attachments.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: weird problem

[Dan Haley]

You'll need to decide what you want to do with rows in the database that
have a null quantity.  You have two choices . . . assign them a value in the
select statement or ignore rows with quantity = null.

In Oracle option 1 would be:
select nvl(quantity, 0) quantity   <<-- assigns a value of zero if
it is null

and option 2 would be
where state is null and quantity is not null

But, it looks like you aren't using Oracle, so you'll have to determine how
to do this with your database!

HTH,
Dan

-Original Message-
From: S R [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 24, 2000 9:54 AM
To: [EMAIL PROTECTED]
Subject: weird problem


Hi everyone,

I have a simple table with 4 fields (Quantity, ID, State, FirstName) . When 
I run this query:


SELECT Quantity, ID FROM TestTable
WHERE State = NULL


and try to do this array and output:








#ArraySum(QuantityTotal)#


I get a value that looks something like this:

1.48562799385E-306

If I change the query to this:


SELECT Quantity, ID FROM TestTable
WHERE Quantity <> NULL


It works fine. I really need to do a query against 'Blank' 'State' fields. 
What the heck is going on??

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: weird problem

[Dave Watts]

> I have a simple table with 4 fields (Quantity, ID, State,
> FirstName). When I run this query:
>
> 
> SELECT Quantity, ID FROM TestTable
> WHERE State = NULL
> 
>
> and try to do this array and output:
>
> 
>   
>   
>   
>
> 
> #ArraySum(QuantityTotal)#
> 
>
> I get a value that looks something like this:
>
> 1.48562799385E-306
>
> If I change the query to this:
>
> 
> SELECT Quantity, ID FROM TestTable
> WHERE Quantity <> NULL
> 
>
> It works fine. I really need to do a query against 'Blank'
> 'State' fields. What the heck is going on??

There are a couple of things worth pointing out here.

First, some databases don't allow you to use the equality operator with
NULL. After all, it doesn't make any sense to say something is equal to an
unknown value. For those databases, you can use the IS operator:

WHERE State IS NULL

Second, there's a difference between a "blank" field, which contains a
zero-length string, and a field that contains NULL. They're not equivalent.
You'll want to find out whether you're using zero-length strings in the
field, or NULLs, and modify your query appropriately. When you insert new
records in the database, if you get the value for a specific field from a
text box in a form, and the user leaves the text box blank, that will cause
your query to insert a zero-length string, not a NULL.  If you want to use
NULLs to represent values not supplied by the user, you'll have to put them
in yourself. Here's one way you can do that:


INSERT INTO mytable
(field1, field2)
VALUES
('#Form.Field1#',

'#Form.Field2#'

NULL
)


Third, if you want to do calculations on your data, rather than doing all
sorts of contortions with arrays, etc. in CFML, you're generally better off
doing them in SQL:


SELECT SUM(Quantity) AS MyQuantity
FROM   TestTable
WHEREState IS NULL


...

#qGetNumbers.MyQuantity#

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

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: weird problem

[John Quarto-vonTivadar]

since you're calculating a total why not just let SQL do it for you?
SELECT Sum(Quantity) FROM TestTable WHERE State IS NULL

(also notice that Null is not the same thing as zero, so using an equal sign
in context with a NULL has a "null" meaning :) (sorry for the pun)



- Original Message -
From: "S R" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 24, 2000 12:54 PM
Subject: weird problem


> Hi everyone,
>
> I have a simple table with 4 fields (Quantity, ID, State, FirstName) .
When
> I run this query:
>
> 
> SELECT Quantity, ID FROM TestTable
> WHERE State = NULL
> 
>
> and try to do this array and output:
>
> 
> 
> 
> 
>
>
> 
> #ArraySum(QuantityTotal)#
> 
>
> I get a value that looks something like this:
>
> 1.48562799385E-306
>
> If I change the query to this:
>
> 
> SELECT Quantity, ID FROM TestTable
> WHERE Quantity <> NULL
> 
>
> It works fine. I really need to do a query against 'Blank' 'State' fields.
> What the heck is going on??
> 
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --

> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.


--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

weird problem

[S R]

Hi everyone,

I have a simple table with 4 fields (Quantity, ID, State, FirstName) . When 
I run this query:


SELECT Quantity, ID FROM TestTable
WHERE State = NULL


and try to do this array and output:








#ArraySum(QuantityTotal)#


I get a value that looks something like this:

1.48562799385E-306

If I change the query to this:


SELECT Quantity, ID FROM TestTable
WHERE Quantity <> NULL


It works fine. I really need to do a query against 'Blank' 'State' fields. 
What the heck is going on??

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: Very, Very weird problem

[Brandon Whitaker]

Question...I don't know if this would solve your problem, but have you tried
writing both queries into one, rather than performing a query, building a
list, then passing the list to the second query?  Something like this


 SELECT Students.ID, Students.Name, Students.email,
Courses.IDCourse, Courses.CourseName,
SCourses.IDStudent, Scourses.IDcourse
   FROM Students, Courses, Scourses
  WHERE Students.ID IN (SELECT DISTINCT IDStudent
FROM SCourses
   WHERE IDCourse IN (#ID#))
AND Scourses.IDStudent = Students.ID
AND Scourses.IDCourse = Courses.IDCourse


Aside from that, I'm kinda stumped...the weird part is its tendency to stop
after 8...

Of the student IDs in the list you originally provided, have you tried
running the query against each of them individually to make sure they're
returning the proper data? (i.e. WHERE Students.ID = #ID#)...

Brandon Whitaker
[EMAIL PROTECTED]
---
"It'll get used by the same people using Opera.  People dressed in black
wearing berets."
- Dave Watts, on Mozilla
"The net interprets censorship as damage and routes around it."
- John Gilmore


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Very, Very weird problem

[vinicius]

This is a multi-part message in MIME format.

--=_NextPart_000_000F_01BFA45C.9AE1D0A0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi there!
I'm having a very weird problem...
I'm building a system where users can subscribe to some courses over the =
net, my database looks like this:

Students=20
-
ID | Name | email | Phone

Courses

IDcourse | NameCourse

SCourses (a table where I put the Student ID and tell which course is =
hi/her doing)
---
IDStudent | IDCourse

My template looks like this


SELECT DISTINCT IDStudent=20
FROM SCourses
WHERE IDCourse IN (#ID#)


Ok, I pass an Course ID to the template and it returns to me the name of =
the students on it

then I create a list


 



 SELECT Students.ID, Students.Name, Students.email,
   Courses.IDCourse, Courses.CourseName,
  SCourses.IDStudent, Scourses.IDcourse
 FROM   Students, Courses, Scourses
 WHERE  Students.ID IN (#list#)
 ANDScourses.IDStudent =3D Students.ID
 ANDScourses.IDCourse =3D Courses.IDCourse  =20


When Generating a report it will looks like this
ID  Name  Email   Courses

10  MIKE  [EMAIL PROTECTED]AutoCad 2000 Basic
21  Bruce [EMAIL PROTECTED]   MapGuide Basic/3D Studio Basic

And it goes. But if my list of ID gets bigger than 8 elements for my=20
surprise looks what happens:

13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp
13 Kate  [EMAIL PROTECTED]   AutoLisp

I tried to show my list just for debugging purpposes, and its ok
the problem is in the query I belive, my list for the display=20
above looks like this

list =3D 1,3,13,14,15,16,21,22,45,46

but only the user ID # 13 is shown.

Any idea guys?
Please I'll be in serious problems if I don't solve this.
Thanks a LOT

Vinicius Carvalho
Digicadd Brazil
Official AutoDesk Reseller






--=_NextPart_000_000F_01BFA45C.9AE1D0A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable









Hi there!I'm having a very weird =

problem...I'm building a system where users can subscribe to some =
courses=20
over the net, my database looks like this:
 
Students -ID | =
Name | email=20
| Phone
 
CoursesIDcourse =
|=20
NameCourse
 
SCourses (a table where I put the =
Student ID and=20
tell which course is hi/her doing)---IDStudent |=20
IDCourse
 
My template looks like =
this
 
<cfquery name=3DgetdistinctID=20
datasource=3D"#application.dsn#">SELECT DISTINCT =
IDStudent=20
FROM SCoursesWHERE IDCourse IN =
(#ID#)</cfquery>
 
Ok, I pass an Course ID to the =
template and it=20
returns to me the name of the students on it
 
then I create a list<cfset=20
list=3D""><cfoutput =
query=3DgetdistinctID> <cfset=20
list =3D ListAppend(list, =
IDStudent)></cfoutput>
 
<cfquery =
name=3D"getstudents"=20
datasource=3D"#application.dsn#"> SELECT =
Students.ID,=20
Students.Name, Students.email,   Courses.IDCourse,=20
Courses.CourseName,  SCourses.IDStudent,=20
Scourses.IDcourse FROM   Students, Courses,=20
Scourses WHERE  Students.ID IN=20
(#list#) AND    Scourses.IDStudent =3D=20
Students.ID AND    Scourses.IDCourse =3D=20
Courses.IDCourse   </cfquery>
 
When Generating a report it will =
looks like=20
thisID  Name =20
Email   &n=
bsp;  =20
Courses
 
10  MIKE  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]&nbs=
p;  =20
AutoCad 2000 Basic21  Bruce mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]   =
MapGuide=20
Basic/3D Studio Basic
 
And it goes. But if my list of ID =
gets bigger=20
than 8 elements for my surprise looks what happens:
 
13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp13 Kate  mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]=
  =20
AutoLisp
 
I tried to show my list just for =
debugging=20
purpposes, and its okthe problem is in