RE: Dynamic anchors on CF Page

[Clark, Aimee]

It's not too bad. I haven't migrated to .NET, not sure I want to just yet,
but I do find it annoying that I have to code so many loops in ASP. I really
liked how CF does that for you. However, on the flipside, it is easier to
control what the loop is doing in ASP than in CF. 

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 11:43 AM
To: CF-Talk
Subject: RE: Dynamic anchors on CF Page


Ahh... Well, glad to know you were able to get it all working. :) I've
worked in ASP myself -- about 3-4 years ago now I was a crack ASP programmer
-- unfortunately for my boss I already knew ColdFusion. I'm lead to believe
that I was pretty good at it but god those tools were hideous. ASP 3 or
ASP.NET could be better, I dunno... I've not bothered to keep up with it.

> Ok, well it turns out that for some reason I was using 2
> different queries.
> The bookmarks were for one and the content for the other.
> (You must
> understand, I am being taught ASP in which this is a
> somewhat necessary
> demon). At any rate, I consolidated the queries down to 1,
> then I had to
> output it and end it once for the hyperlinks to the
> bookmarks and then
> output it again for the content in order for the
> formatting to be correct.

> The agonies of coding in ASP and not CF.

> Thanks for your help...

> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 10:27 AM
> To: CF-Talk
> Subject: RE: Dynamic anchors on CF Page


> That sucks... I'm about tapped for ideas at this point...
> Wish I had any
> other suggestions to offer... Have you tested it on
> multiple machines /
> browsers to make sure it's not just a problem with your
> particular setup?

>> Well, based on what you're suggesting Issac, my page
>> isn't
>> having the
>> problem described below. For instance, presently I have 6
>> different
>> hyperlinks to bookmarks on my page. When I click the last
>> hyperlink, it
>> takes me down about halfway into the page which is about
>> the 3rd
>> headline(bookmark).

>> Does anyone have any other suggestions for how to get my
>> bookmarks to
>> function correctly. I am now on a deadline to get this
>> done today.

>> Thank you,
>> Aimee' Clark

>> -Original Message-
>> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
>> Sent: Saturday, March 29, 2003 9:46 PM
>> To: CF-Talk
>> Subject: RE: Dynamic anchors on CF Page


>>> Ok, so I now have this: #title#

>>> The name tag as this:#Title#

>>> <~
>>> the above displays the ID for the title correctly when
>>> hovering on the
>>> hyperlink to the bookmark...but still doesn't seem like
>>> it's jumping
>>> directly to the bookmark when I click the hyperlink
>>> ~~>

>> Welcome ... I recommended the wrong thing didn't I? ... I
>> mean -- I said you
>> needed ## in front of the anchor I think... anyway --
>> that
>> code should be
>> correct... My experience with MSIE has been that the
>> browser jumps to a
>> point where either a) the anchor is butted up against the
>> top of the display
>> or b) where the bottom of the page is butted up against
>> the bottom of the
>> display. So if your anchor happens to be close enough to
>> the bottom of the
>> page, the anchor link won't bring the display up beyond
>> where the bottom of
>> the page reaches the bottom of the display which results
>> in the anchor being
>> somewhat below the top. Not sure about other browsers --
>> this could be W3C
>> recommended behavior, not sure.


>> s. isaac dealey954-776-0046

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

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

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

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


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

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



> s. isaac dealey954-776-0046

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

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

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

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


> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.t

RE: Dynamic anchors on CF Page

[Clark, Aimee]

Ok, well it turns out that for some reason I was using 2 different queries.
The bookmarks were for one and the content for the other. (You must
understand, I am being taught ASP in which this is a somewhat necessary
demon). At any rate, I consolidated the queries down to 1, then I had to
output it and end it once for the hyperlinks to the bookmarks and then
output it again for the content in order for the formatting to be correct.

The agonies of coding in ASP and not CF.

Thanks for your help...

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 01, 2003 10:27 AM
To: CF-Talk
Subject: RE: Dynamic anchors on CF Page


That sucks... I'm about tapped for ideas at this point... Wish I had any
other suggestions to offer... Have you tested it on multiple machines /
browsers to make sure it's not just a problem with your particular setup?

> Well, based on what you're suggesting Issac, my page isn't
> having the
> problem described below. For instance, presently I have 6
> different
> hyperlinks to bookmarks on my page. When I click the last
> hyperlink, it
> takes me down about halfway into the page which is about
> the 3rd
> headline(bookmark).

> Does anyone have any other suggestions for how to get my
> bookmarks to
> function correctly. I am now on a deadline to get this
> done today.

> Thank you,
> Aimee' Clark

> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 29, 2003 9:46 PM
> To: CF-Talk
> Subject: RE: Dynamic anchors on CF Page


>> Ok, so I now have this: #title#

>> The name tag as this:#Title#

>> <~
>> the above displays the ID for the title correctly when
>> hovering on the
>> hyperlink to the bookmark...but still doesn't seem like
>> it's jumping
>> directly to the bookmark when I click the hyperlink
>> ~~>

> Welcome ... I recommended the wrong thing didn't I? ... I
> mean -- I said you
> needed ## in front of the anchor I think... anyway -- that
> code should be
> correct... My experience with MSIE has been that the
> browser jumps to a
> point where either a) the anchor is butted up against the
> top of the display
> or b) where the bottom of the page is butted up against
> the bottom of the
> display. So if your anchor happens to be close enough to
> the bottom of the
> page, the anchor link won't bring the display up beyond
> where the bottom of
> the page reaches the bottom of the display which results
> in the anchor being
> somewhat below the top. Not sure about other browsers --
> this could be W3C
> recommended behavior, not sure.


> s. isaac dealey954-776-0046

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

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

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

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


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

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



s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

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

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

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


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

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

RE: Dynamic anchors on CF Page

[Clark, Aimee]

Well, based on what you're suggesting Issac, my page isn't having the
problem described below. For instance, presently I have 6 different
hyperlinks to bookmarks on my page. When I click the last hyperlink, it
takes me down about halfway into the page which is about the 3rd
headline(bookmark). 

Does anyone have any other suggestions for how to get my bookmarks to
function correctly. I am now on a deadline to get this done today.

Thank you,
Aimee' Clark

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 29, 2003 9:46 PM
To: CF-Talk
Subject: RE: Dynamic anchors on CF Page


> Ok, so I now have this: #title#

> The name tag as this:#Title#

> <~
> the above displays the ID for the title correctly when
> hovering on the
> hyperlink to the bookmark...but still doesn't seem like
> it's jumping
> directly to the bookmark when I click the hyperlink
> ~~>

Welcome ... I recommended the wrong thing didn't I? ... I mean -- I said you
needed ## in front of the anchor I think... anyway -- that code should be
correct... My experience with MSIE has been that the browser jumps to a
point where either a) the anchor is butted up against the top of the display
or b) where the bottom of the page is butted up against the bottom of the
display. So if your anchor happens to be close enough to the bottom of the
page, the anchor link won't bring the display up beyond where the bottom of
the page reaches the bottom of the display which results in the anchor being
somewhat below the top. Not sure about other browsers -- this could be W3C
recommended behavior, not sure.


s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

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

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

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


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

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

RE: Dynamic anchors on CF Page

[Clark, Aimee]

Ok, so I now have this: #title#

The name tag as this:#Title#

<~
the above displays the ID for the title correctly when hovering on the
hyperlink to the bookmark...but still doesn't seem like it's jumping
directly to the bookmark when I click the hyperlink
~~>

Thank you.

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 29, 2003 8:43 PM
To: CF-Talk
Subject: Re: Dynamic anchors on CF Page


Probably just getting an error on this line:

href="##GetKey#">#title#

which should read ###getKey#

Same for the anchor name attribute. You have to escape the leading # for the
anchor and then output the name of the anchor.

> Apart from that you've missed the hashes (#), what's wrong
> with what you
> have?

> 

> Matthew Walker
> Electric Sheep Web
> http://www.electricsheep.co.nz/

> - Original Message -
> From: "Clark, Aimee" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, March 30, 2003 12:38 PM
> Subject: Dynamic anchors on CF Page


>> I have a page in which headings go across the top like
>> (newpaper headings)
>> that I want the user to be able to click the heading to
>> jump down to the
>> article. All headings and articles are on the same page.
>> So I need to be
>> able to create dynamic anchors. Is this possible in CF?
>> Here's a snippet
> of
>> code I have:
>>
>> 
>>  Select DailyNewsKey, Title From DailyNews
>>  Where convert(varchar, PublishDte, 101) <=
>>  convert(varchar, GETDATE(),
> 101)
>> AND
>>  convert(varchar, EndPublishDte, 101) >= convert(varchar,
>>  GETDATE(), 101)
>> 
>>
>> 
>>  Select DailyNewsKey, Title, Body, Sig From DailyNews
>>  Where convert(varchar, PublishDte, 101) <=
>>  convert(varchar, GETDATE(),
> 101)
>> AND
>>  convert(varchar, EndPublishDte, 101) >= convert(varchar,
>>  GETDATE(), 101)
>> 
>>
>> 
>> 
>> 
>>  
>>   >   valign="top">What's Up
>> Today
>>  
>>  
>>   >   valign="bottom">Table of
>> Contents
>>  
>>  
>>  
>>  
>>    > href="##GetKey#">#title#  
>>  
>>  
>>   >   valign="top">> size="1" color="353535">
>>  
>>  
>>  
>>   >   face="Trebuchet MS"
>> size="2" color="CC">> name="GetKey">#Title#
>>  
>>  
>>   >   face="Trebuchet MS"
>> size="2">#Body#
>>  
>>  
>>   >   face="Trebuchet MS"
>> size="2">#Sig#
>>  
>>  
>>  >  size="1"
>> color="353535">
>>  
>>  
>>
>> 
>> 
>> 
>>
>>
>> Thank you,
>> Aimee Clark
>> Web Developer
>> Stinson Morrison Hecker
>> 816.691.3461
>> [EMAIL PROTECTED]
>> <mailto:[EMAIL PROTECTED]>
>>
>>
> ~~
> ~~~|
> Archives:
> http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
> Subscription: http://www.houseoffusion.com/cf_lists/index.
> cfm?method=subscribe&forumid=4
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Get the mailserver that powers this list at
> http://www.coolfusion.com

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



s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

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

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

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


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

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

RE: Dynamic anchors on CF Page

[Clark, Aimee]

Well it doesn't appear to actually jump down to a specific heading. For
instance, lets say I hardcoded 3 headings to be in hyperlink #1a, #2b, and
#3a, then whenever I click on the heading that has the anchor coded as #3a,
it would just down right to the title and content for the 3rd heading. Well,
presently it acts like it's jumping down, but it doesn't go to the specified
heading.



-Original Message-
From: Matthew Walker [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 29, 2003 7:12 PM
To: CF-Talk
Subject: Re: Dynamic anchors on CF Page


Apart from that you've missed the hashes (#), what's wrong with what you
have?



Matthew Walker
Electric Sheep Web
http://www.electricsheep.co.nz/

- Original Message -
From: "Clark, Aimee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, March 30, 2003 12:38 PM
Subject: Dynamic anchors on CF Page


> I have a page in which headings go across the top like (newpaper headings)
> that I want the user to be able to click the heading to jump down to the
> article. All headings and articles are on the same page. So I need to be
> able to create dynamic anchors. Is this possible in CF? Here's a snippet
of
> code I have:
>
> 
>  Select DailyNewsKey, Title From DailyNews
>  Where convert(varchar, PublishDte, 101) <= convert(varchar, GETDATE(),
101)
> AND
>  convert(varchar, EndPublishDte, 101) >= convert(varchar, GETDATE(), 101)
> 
>
> 
>  Select DailyNewsKey, Title, Body, Sig From DailyNews
>  Where convert(varchar, PublishDte, 101) <= convert(varchar, GETDATE(),
101)
> AND
>  convert(varchar, EndPublishDte, 101) >= convert(varchar, GETDATE(), 101)
> 
>
> 
> 
> 
>  
>   What's Up
> Today
>  
>  
>   Table of
> Contents
>  
>  
>  
>  
>     href="##GetKey#">#title#  
>  
>  
>size="1" color="353535">
>  
>  
>  
>size="2" color="CC">#Title#
>  
>  
>size="2">#Body#
>  
>  
>size="2">#Sig#
>  
>  
>   color="353535">
>  
>  
>
> 
> 
> 
>
>
> Thank you,
> Aimee Clark
> Web Developer
> Stinson Morrison Hecker
> 816.691.3461
> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
>
> 

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

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

Dynamic anchors on CF Page

[Clark, Aimee]

I have a page in which headings go across the top like (newpaper headings)
that I want the user to be able to click the heading to jump down to the
article. All headings and articles are on the same page. So I need to be
able to create dynamic anchors. Is this possible in CF? Here's a snippet of
code I have:
 

 Select DailyNewsKey, Title From DailyNews 
 Where convert(varchar, PublishDte, 101) <= convert(varchar, GETDATE(), 101)
AND 
 convert(varchar, EndPublishDte, 101) >= convert(varchar, GETDATE(), 101)
 
 

 Select DailyNewsKey, Title, Body, Sig From DailyNews 
 Where convert(varchar, PublishDte, 101) <= convert(varchar, GETDATE(), 101)
AND 
 convert(varchar, EndPublishDte, 101) >= convert(varchar, GETDATE(), 101)

 



 
  What's Up
Today
 
 
  Table of
Contents
 
 
 
 
   #title#  
 
 
  
 
 
 
  #Title#
 
 
  #Body#
 
 
  #Sig#
 
 
 
 
 
 




 
Thank you,
Aimee Clark
Web Developer
Stinson Morrison Hecker
816.691.3461
[EMAIL PROTECTED]  

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

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

Change in datatype of table causing problems with CF pages

[Clark, Aimee]

There was a change made to a table we have where 2 fields that used to be
char were made to be decimal.
 
Now, whenever we try to add to or update the table we receive a message that
it cannot "convert varchar to numeric". I'm guessing that it has to do with
the fact the form is an input type of "text" and therefore the insert won't
let it go into the table that way. 
 
I tried doing a CONVERT( decimal, form.field), but it still doesn't work.
Can someone shed some light on how else to accomplish this?
 
Thanks,

Aimee Clark
Web Developer
Stinson Morrison Hecker LLP
816-691-3461
[EMAIL PROTECTED] 

 

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

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

Using cfoutput in Emails

[Clark, Aimee]

I have used cfmail for quite some time, but I had a quick question. Is it
possible to display parameters in the subject line? For instance if I wanted
the subject line to be:

Departure-IS Notification: Bugs Bunny, PHX, 12/14/02

Now, the first part after notification is just something that I type, but
everything after that would be like
#QueryName.FieldName#

Can I do this?

Thank you,

Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 



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

Need help with missing submit buttons

[Clark, Aimee]

Ok, for some reason, my submit buttons are not showing up at the bottom of
my page. This is the code for the page in question. Can someone tell me why
this is happening?




Conflicts Check Request Continued




Select Conflict_ID from ConflictsCheck 
where (Conflict_ID=#Conflict_ID#)



Select Conflict_ID from ConflictsCheck 
where (SubmitterEmail='#SubmitterEmail#' AND
EntryDateTime=#EntryDateTime#)






Conflicts Check Request
Continued


If you need to
enter more than the allotted fields provided please choose Add More at the
bottom of the page.




(#1)  Name of Adverse Party:



 (#1)  Address of Adverse Party:




(#2)  Name of Adverse Party:



(#2)  Address of Adverse Party:


















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

RE: Using a counter variable

[Clark, Aimee]

Mosh,
I tried this and it did work, but, it's still showing my survey link
even though the counter has been set back to 0. Can you tell why?










Your Help Desk call (Ticket No. #GetCall.ID#) has been
closed.  If you believe the call should not be closed, or the problem occurs
again, please reply to this message or call the Help Desk, to let us know.

Call Information
Ticket Number:  #GetCall.ID#
Problem Description:  
#GetCall.Issue#
Resolution: 
#GetCall.Resolution#

http://dailynews/helpdesk/test/HDSurvey.cfm?ID=#ID#";
target="_blank">Click here to answer a brief survey about your issue and
resolution.
#counter#







Your Help Desk call (Ticket No. #GetCall.ID#) has been
closed.  If you believe the call should not be closed, or the problem occurs
again, please reply to this message or call the Help Desk, to let us know.

Call Information
Ticket Number:  #GetCall.ID#
Problem Description:  
#GetCall.Issue#
Resolution: 
#GetCall.Resolution#

#counter#



Thank you,
Aimee' Clark

-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 3:41 PM
To: CF-Talk
Subject: RE: Using a counter variable


You haven't made your counter variable persistent.  Every time someone makes
a new request of your application, Application.cfm creates a new variable
called "counter" and sets it equal to 0.  You need to make your variable
persistent.  And since you want it to work across multiple users, it should
probably persist in the APPLICATION scope.

So, your Application.cfm should look something like:







Your action page should look something like:





















--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


> -Original Message-
> From: Clark, Aimee [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, November 26, 2002 4:03 PM
> To: CF-Talk
> Subject: Using a counter variable
>
>
> I have an application in which I want every 7th record closed in
> a table to
> generate an email asking the user to participate in a survey.
>
> I have  in the application.cfm file.
>
> I have  in my action page right after
> an update
> that is done to the table.
>
> Then I have 
>   execute generating email
>   then it resets the counter back to 0
>
> However my counter is not incrementing at all. It just keep staying at 1.
> I'm not sure why. Can someone provide some assistance with this?
>
> Thank you,
> Aimee' Clark
> Web Developer
> Stinson Morrison Hecker
>
> 

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

RE: Using a counter variable

[Clark, Aimee]

I guess I really need some guidance on this problem. I tried putting the
initial creation for this variable on the action page, but then it does the
same thing because when the page runs, it resets the variable back to 0,
then adds 1. Very frustrating.

What should I do? What is the best practice for this type of scenario?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 3:24 PM
To: CF-Talk
Subject: RE: Using a counter variable


Aimee,

A bit more info would be helpful. Are you trying to do this all in one
request?  what sort of variable is it? session? If it's a session variable
then it's being reset to Zero with every request by the application.cfm
page. You would need to do (with locking):





-Original Message-----
From: Clark, Aimee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 3:03 PM
To: CF-Talk
Subject: Using a counter variable


I have an application in which I want every 7th record closed in a table to
generate an email asking the user to participate in a survey.

I have  in the application.cfm file.

I have  in my action page right after an update
that is done to the table.

Then I have 
execute generating email
then it resets the counter back to 0

However my counter is not incrementing at all. It just keep staying at 1.
I'm not sure why. Can someone provide some assistance with this?

Thank you,
Aimee' Clark
Web Developer
Stinson Morrison Hecker



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

RE: Using a counter variable

[Clark, Aimee]

I'm trying to do it all in one request. The tech goes to close the ticket,
clicks save changes, then that executes the action page. I set the variable
initially in the application file, but I'm incrementing it in the action
page, which would mean that at that point it's a session variable. 

I have to admit, I'm still learning the best practices with respect to "how"
I should be doing this. 

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 3:24 PM
To: CF-Talk
Subject: RE: Using a counter variable


Aimee,

A bit more info would be helpful. Are you trying to do this all in one
request?  what sort of variable is it? session? If it's a session variable
then it's being reset to Zero with every request by the application.cfm
page. You would need to do (with locking):





-Original Message-
From: Clark, Aimee [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 3:03 PM
To: CF-Talk
Subject: Using a counter variable


I have an application in which I want every 7th record closed in a table to
generate an email asking the user to participate in a survey.

I have  in the application.cfm file.

I have  in my action page right after an update
that is done to the table.

Then I have 
execute generating email
then it resets the counter back to 0

However my counter is not incrementing at all. It just keep staying at 1.
I'm not sure why. Can someone provide some assistance with this?

Thank you,
Aimee' Clark
Web Developer
Stinson Morrison Hecker



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

Using a counter variable

[Clark, Aimee]

I have an application in which I want every 7th record closed in a table to
generate an email asking the user to participate in a survey. 

I have  in the application.cfm file.

I have  in my action page right after an update
that is done to the table.

Then I have 
execute generating email
then it resets the counter back to 0

However my counter is not incrementing at all. It just keep staying at 1.
I'm not sure why. Can someone provide some assistance with this?

Thank you,
Aimee' Clark
Web Developer
Stinson Morrison Hecker

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

Locking pages in CF

[Clark, Aimee]

I have an application in which techs can click to edit a ticket in the
ticketing application. I would like to know what the best way is to prevent
Tech B from getting into a ticket that Tech A is already in and currently
modifying.
 
I am thinking of using cflock, but where do I put it?
 
Thanks,
Aimee' Clark

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

FW: Displaying values passed from one page into an email

[Clark, Aimee]

I realized that I didn't include enough info in my last email. Here's what I
omitted:
 

 
The problem I am having is this: Let's say in my record it shows me as
speaking just French. Well, now I want to add that I speak Spanish. The
value passed to the email is French, Spanish. 
 
Now, let's say I don't really speak Spanish very well, so I want that
removed from my record. Well, the value passed is just the first one in the
list, so if you speak French, Spanish, it only shows that you want French
removed, not Spanish.
 
Thanks,
Aimee'
-----Original Message-
From: Clark, Aimee 
Sent: Wednesday, November 13, 2002 1:52 PM
To: CF-Talk (E-mail)
Subject: Displaying values passed from one page into an email


I have a page that users are able to go into to see what is currently listed
for their employee information. If a user decides that they need to change
something like their home address and annotate that they speak a foreign
language, they can do so on this page and when they submit the form, an
email is generated that shows only the fields that they have modified.
 
Ok, so having said that, I can get everything they may modify on the form to
display correctly in the email EXCEPT the foriegn language field. 
 
This field is a dynamic checkbox, and they can select more than one language
if they happen to speak say, French and Spanish.
 
Here is the code for what is on the form:
 
 
  Foreign Languages:
  
  

   Checked>
 #LanguageName#

  
  
  
 
Here are the queries, variables, and how I am finding their changes:
 
<-QUERIES & VARIABLES->
 

select * from Languages order by LanguageName

 

 

select * from EmployeeLanguages
where EmpID = '#ID#'

 

 
<--Checking to see if there's something in the field that was on the
form-->






 
<-Displaying whether to add or delete a language based on what
the user selected--->
 



Add Foreign Language:
#LangChoice#


 


Remove Foreign Language:
#GetEmpLanguages.LanguageName#

 

 
Can anyone offer some insight into what I may be doing wrong here?
 
Thanks,
 
Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Recall: Displaying values passed from one page into an email

[Clark, Aimee]

Clark, Aimee would like to recall the message, "Displaying values passed
from one page into an email".

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

Displaying values passed from one page into an email

[Clark, Aimee]

I have a page that users are able to go into to see what is currently listed
for their employee information. If a user decides that they need to change
something like their home address and annotate that they speak a foreign
language, they can do so on this page and when they submit the form, an
email is generated that shows only the fields that they have modified.
 
Ok, so having said that, I can get everything they may modify on the form to
display correctly in the email EXCEPT the foriegn language field. 
 
This field is a dynamic checkbox, and they can select more than one language
if they happen to speak say, French and Spanish.
 
Here is the code for what is on the form:
 
 
  Foreign Languages:
  
  

   Checked>
 #LanguageName#

  
  
  
 
Here are the queries, variables, and how I am finding their changes:
 
<-QUERIES & VARIABLES->
 

select * from Languages order by LanguageName

 

 

select * from EmployeeLanguages
where EmpID = '#ID#'

 

 
<--Checking to see if there's something in the field that was on the
form-->






 
<-Displaying whether to add or delete a language based on what
the user selected--->
 



Add Foreign Language:
#LangChoice#


 


Remove Foreign Language:
#GetEmpLanguages.LanguageName#

 

 
Can anyone offer some insight into what I may be doing wrong here?
 
Thanks,
 
Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

CF Training

[Clark, Aimee]

I am still learning CF, but I would like to take some training courses to
become better acquainted with how to better utilize CF in my code. My new
boss is an ASP programmer and would like it (if she had it her way) to sway
me from coding in CF to coding in ASP. I happen to think CF is easier than
anything else I have worked with, so I would like to continue to use it for
most of my web pages and applications.
 
What is the general consensus about who has the best CF training?
 
Thanks,
Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 


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

RE: Using Cfloops on the same page

[Clark, Aimee]

True, except on the page that handles the insert, I am looping that list and
inserting the id for the employee and the first value into the table, then
the id and the second value so that the table looks like this:

EmpID   NotaryState
95  VA
95  AZ

So, can I still use the Cfparam that way?

-Original Message-
From: Ben Doom [mailto:bdoom@;moonbow.com]
Sent: Friday, November 08, 2002 11:35 AM
To: CF-Talk
Subject: RE: Using Cfloops on the same page


Since, according to the code you posted, the checkboxes all have the same
name, the values are returned in a comma-separated list.

I.e. if the checked values are 1, 3 and 6 then in the url (if it's using
get) you'll have 'notary=1,3,6'.

Therefore, you could always set an empty default by using 



  --Ben Doom
Programmer & General Lackey
Moonbow Software

: -Original Message-----
: From: Clark, Aimee [mailto:aclark@;stinsonmoheck.com]
: Sent: Friday, November 08, 2002 12:25 PM
: To: CF-Talk
: Subject: RE: Using Cfloops on the same page
:
:
: So, I thought about what everyone was suggesting for this, but I
: still don't
: think this willl work for me. Below is the way one of the
: checkbox fields is
: set up. It's dynamic and there is more than one checkbox that the user can
: select from.
:
: 
:   Notary:
:  
:   #NotaryState#
:   
: 
:
: My question is, how can I use cfparam to set this to a default setting if
: there are more than one checkbox?
:
: Thanks,
:   Aimee'


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

RE: Using Cfloops on the same page

[Clark, Aimee]

So, I thought about what everyone was suggesting for this, but I still don't
think this willl work for me. Below is the way one of the checkbox fields is
set up. It's dynamic and there is more than one checkbox that the user can
select from.


  Notary:
   
#NotaryState#



My question is, how can I use cfparam to set this to a default setting if
there are more than one checkbox?

Thanks,
Aimee'

-Original Message-
From: Bob Haroche [mailto:spambait@;onpointsolutions.com]
Sent: Thursday, November 07, 2002 11:45 AM
To: CF-Talk
Subject: Re: Using Cfloops on the same page


> And I replace form.notary with EditForm.Notary, that should work?

No. The "problem" is with the nature of different form input types. A blank
text input will pass an empty variable to the form processing page. A blank
checkbox (or radio button for that matter), on the other hand, will not pass
anything to the form processing page. Hence the processing page expects to
handle some value for the checkbox but it won't get anything if the box is
unchecked.

One way to deal with this is to set a default checkbox value on the
processing page like so:



That in effect tells the processing page that, by default, the Notary box is
not checked. Of course if the user does check the Notary box, then the
default value set by CFPARAM doesn't kick in, and the actual value of "yes"
is passed to the processing page.

---
Regards,
Bob Haroche
O n P o i n t  S o l u t i o n s
www.OnPointSolutions.com


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

RE: Using Cfloops on the same page

[Clark, Aimee]

So, if my cfform tag looks like this:



And I replace form.notary with EditForm.Notary, that should work?

Because I did this and it generates the same type of error. Is there
somewhere else I need to change this?

Thanks,
Aimee'

-Original Message-
From: Randell B Adkins [mailto:AdkinsR@;GAO.GOV]
Sent: Thursday, November 07, 2002 11:06 AM
To: CF-Talk
Subject: Re: Using Cfloops on the same page


Check to make sure the form is named properly.
This indicates that the FORM.NOTARY variable
does not exist.

This has nothing to do with 2 CFLOOPs on one page.
If so, alot of my apps would bomb out.

>>> [EMAIL PROTECTED] 11/07/02 12:00PM >>>
I have a page in which there are two fields that are checkboxes. I am
looping those fields with separate list cfloops and finding the values
that
have been selected and writing the id and the name of the field to a
table.
Problem is, I am getting an error when both cfloops are on the same
page.
How do I fix this? 
 
The error I am receiving is this:
 
An error occurred while evaluating the expression: 


"#form.notary#"



Error near line 50, column 16. 
  _  


Error resolving parameter FORM.NOTARY 



The specified form field cannot be found. This problem is very likely
due to
the fact that you have misspelled the form field name. 




The error occurred while processing an element with a general
identifier of
(CFLOOP), occupying document position (50:1) to (50:49).

This is the code I am using:





insert into EmployeeNotaries
 (empid, notarystate)
 values('#ID#', '#notarystate#')

 





insert into EmployeeLanguages
 (empid, languagename)
 values('#ID#', '#languagename#')



Any ideas or assistance would be greatly appreciated.

Thanks,

Aimee' Clark




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

Using Cfloops on the same page

[Clark, Aimee]

I have a page in which there are two fields that are checkboxes. I am
looping those fields with separate list cfloops and finding the values that
have been selected and writing the id and the name of the field to a table.
Problem is, I am getting an error when both cfloops are on the same page.
How do I fix this? 
 
The error I am receiving is this:
 
An error occurred while evaluating the expression: 


"#form.notary#"



Error near line 50, column 16. 
  _  


Error resolving parameter FORM.NOTARY 



The specified form field cannot be found. This problem is very likely due to
the fact that you have misspelled the form field name. 




The error occurred while processing an element with a general identifier of
(CFLOOP), occupying document position (50:1) to (50:49).

This is the code I am using:





insert into EmployeeNotaries
 (empid, notarystate)
 values('#ID#', '#notarystate#')

 





insert into EmployeeLanguages
 (empid, languagename)
 values('#ID#', '#languagename#')



Any ideas or assistance would be greatly appreciated.

Thanks,

Aimee' Clark


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

FW: Running ASP on a server used for CF

[Clark, Aimee]

The SQL server we have running sits on its own box. So, the web server is
independent of it. There are ODBC connections from the web server to the SQL
server.

-Original Message-
From: Haggerty, Mike [mailto:MHaggerty@;mbda.gov]
Sent: Monday, November 04, 2002 3:15 PM
To: CF-Talk
Subject: RE: Running ASP on a server used for CF


Here's what Microsoft says about the issue:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q186726&;


-Original Message-----
From: Clark, Aimee [mailto:aclark@;stinsonmoheck.com]
Sent: Monday, November 04, 2002 4:07 PM
To: CF-Talk
Subject: Running ASP on a server used for CF


I have a situation in which I will begin coding some pages in ASP vs CF and
I plan to do so on the same IIS server that my CF is running on. Because of
the way that the server has been configured, I am curious to know if there
is anything I need to be aware of if I plan to do this.
 
So far, I have run into a problem when trying to run an ASP page and it
generates a SQL error:
 
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection. 


/isweb/pdissues/addIt.asp, line 11 

Now, I have gone back and setup an ODBC connection with SQL authentication
and no luck. 

Also on the IIS server the NT authentication is how we have it setup because
we use an intranet on this server and we use NT authentication in a lot of
the code we generate.

So, if anyone has any insight into what I should be aware of, I would really
appreciate it. I'm just trying to understand why I am receiving this error
and if it's the result of trying to code ASP on a server with CF.

Thank you,

Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Running ASP on a server used for CF

[Clark, Aimee]

I have a situation in which I will begin coding some pages in ASP vs CF and
I plan to do so on the same IIS server that my CF is running on. Because of
the way that the server has been configured, I am curious to know if there
is anything I need to be aware of if I plan to do this.
 
So far, I have run into a problem when trying to run an ASP page and it
generates a SQL error:
 
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection. 


/isweb/pdissues/addIt.asp, line 11 

Now, I have gone back and setup an ODBC connection with SQL authentication
and no luck. 

Also on the IIS server the NT authentication is how we have it setup because
we use an intranet on this server and we use NT authentication in a lot of
the code we generate.

So, if anyone has any insight into what I should be aware of, I would really
appreciate it. I'm just trying to understand why I am receiving this error
and if it's the result of trying to code ASP on a server with CF.

Thank you,

Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

RE: Need assistance with listbox on a form

[Clark, Aimee]

I'm sorry, I am still learning CF and I haven't yet begun to use scripts or
functions within my code. I am not opposed to doing so, I just need help.

So I applied this logic to my code, but how do I get it to display the value
entered in the email notification that is sent out?

Thank you,
Aimee' Clark



-Original Message-
From: Mark A. Kruger - CFG [mailto:mkruger@;cfwebtools.com]
Sent: Thursday, October 31, 2002 3:27 PM
To: CF-Talk
Subject: RE: Need assistance with listbox on a form


I use the following "IsEmpty( )" function for simple values.  It saves time
and it looks similar (in my code) to "IsDefined( )":


  function IsEmpty(item){
IF(len(trim(item))) return false;
ELSEReturn true;
  }


-Original Message-
From: Chuck Brockman [mailto:cfmail@;designmotives.com]
Sent: Thursday, October 31, 2002 2:55 PM
To: CF-Talk
Subject: RE: Need assistance with listbox on a form


Try len(Trim(chgFLangauge)).  See if that helps




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

RE: *** GREAT IDEA *** DING DING DING*** RE: OT RAGE

[Clark, Aimee]

Oh that's just mean. I'm a newbie, but I really do appreciate the things
Matt posts from time to time.

Aimee'

-Original Message-
From: [EMAIL PROTECTED] [mailto:ksuh@;shaw.ca]
Sent: Thursday, October 31, 2002 6:16 PM
To: CF-Talk
Subject: Re: *** GREAT IDEA *** DING DING DING*** RE: OT RAGE


That would be good.  Every one of Matt's posts would be deleted instantly :)

- Original Message -
From: Matt Robertson <[EMAIL PROTECTED]>
Date: Thursday, October 31, 2002 5:00 pm
Subject: Re: *** GREAT IDEA *** DING DING DING*** RE: OT RAGE

> Yea baby!  that would eliminate unreasonable OT, Machiavellian 
> plots to give the listmaster indigestion and the dreaded ''you 
> took his OT and not my OT... waah'' all at once.  Just add another 
> link in the footer.
> 
> 'Course, its easy to code 'cuz none of us has to do it :)
> 
> Boo,
> 
> --Matt--
> 
> 
> >GREAT IDEA BRIAN!
> 
> 
> 
> 

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

RE: Need assistance with listbox on a form

[Clark, Aimee]

Well, what it is that I am trying to accomplish is: The user goes to a form,
fills out whatever needs to be changed and only the changes that they make
are then emailed to the webmaster.

So, the code that I have been having trouble with is all on the page that is
called after the user submits their changes. The page looks like this
(codewise):



SubmitChangeMail


Select * from Employees where ID = #ID#






















































































































 

 





An employee has requested that a change be made to the firm
directory.


Change Requested by:
#Firstname# #Middlename# #Lastname#



Salutation Change:
#chgSalutation#




First Name Change:
#chgFirstName#




Middle Name Change:
#chgMiddleName#




Last Name Change:
#chgLastName#




Nick Name Change:
#chgNickName#




Extention Change:
#chgExt#




Works for/Secretary Change:
#chgWorksfor#




Secretary's Extention Change:
#chgSecExt#




Secretary Backup Change:
#chgSecBackup#




Title Change:
#chgTitle#




Office Change:
#chgOffice#




Floor Change:
#chgFloor#




Room Change:
#chgRoom#




Email Address Change:
#chgExternalEmail#




Birthdate Change:
#chgBirthdate#




Anniversary Change:
#chgAnniversary#




Barno Change:
#chgBarno#




Timekeeper No. Change:
#chgAttyBillingNo#




CAF No. Change:
#chgCAFNo#




Unlisted Change:
#chgUnlisted#




Home Phone Change:
#chgHomePhone#




Home Address Change:
#chgHomeAddress#




Spouse Change:
#chgSpouse#




Foriegn Language Change:
#chgFLanguage#





http://DailyNews";>



Does this help? 

Thanks,
Aimee'

-Original Message-
From: Everett, Al [mailto:AEverett@;askallied.com]
Sent: Thursday, October 31, 2002 2:45 PM
To: CF-Talk
Subject: RE: Need assistance with listbox on a form


You should explicitly scope your variables, i.e., Form.chgFLanguage or
queryname.chgFLanguage. That may be contributing to the problem.

We also need to see the bigger picture. What is it you're trying to
accomplish?

> -Original Message-
> From: Clark, Aimee [mailto:aclark@;stinsonmoheck.com]
> Sent: Thursday, October 31, 2002 3:23 PM
> To: CF-Talk
> Subject: RE: Need assistance with listbox on a form
> 
> 
> I'm sorry, but that gives me an error right where the 
> #chgFLanguage# line
> is.
> 
> I have tried the len(chgFLangauge) suggestion that Shawn 
> provided, but that
> did not work either.
> 
> I tried this and it at least allowed for me to modify 
> something other than
> the list box, but now if I choose a foreign language, it 
> doesn't pass the
> value I selected to the email that is generated. 
> 
> 
> 
> Foriegn Language Change:
> #chgFLanguage#
> 
> 
> 
> Boy, am I trouble or what?
> 
> -Original Message-
> From: Tony Weeg [mailto:tony@;navtrak.net]
> Sent: Thursday, October 31, 2002 2:21 PM
> To: CF-Talk
> Subject: RE: Need assistance with listbox on a form
> 
> 
> aimee,
> 
> try this
> 
> 
> 
> Foriegn Language Change:
> #chgFLanguage#
> 
> 
> 
> .tony
> 
> Tony Weeg
> Senior Web Developer
> Information System Design
> Navtrak, Inc.
> Fleet Management Solutions
> www.navtrak.net
> 410.548.2337 
> 
> 
> -Original Message-
> From: Clark, Aimee [mailto:aclark@;stinsonmoheck.com] 
> Sent: Thursday, October 31, 2002 3:04 PM
> To: CF-Talk
> Subject: RE: Need assistance with listbox on a form
> 
> 
> So, for some reason my last email was cut off. Here is the code that I
> am
> trying to process from my previous problem.
> 
> Here is the code that is processing:
> 
> 
> 
> Foriegn Language Change:
> #chgFLanguage#
> 
> 
> 
> How do I correct this?
> 
> Thanks,
> 
> Aimee'
> 
> 
> 
> 

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

RE: Need assistance with listbox on a form

[Clark, Aimee]

I'm sorry, but that gives me an error right where the #chgFLanguage# line
is.

I have tried the len(chgFLangauge) suggestion that Shawn provided, but that
did not work either.

I tried this and it at least allowed for me to modify something other than
the list box, but now if I choose a foreign language, it doesn't pass the
value I selected to the email that is generated. 



Foriegn Language Change:
#chgFLanguage#



Boy, am I trouble or what?

-Original Message-
From: Tony Weeg [mailto:tony@;navtrak.net]
Sent: Thursday, October 31, 2002 2:21 PM
To: CF-Talk
Subject: RE: Need assistance with listbox on a form


aimee,

try this



Foriegn Language Change:
#chgFLanguage#



.tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 


-Original Message-----
From: Clark, Aimee [mailto:aclark@;stinsonmoheck.com] 
Sent: Thursday, October 31, 2002 3:04 PM
To: CF-Talk
Subject: RE: Need assistance with listbox on a form


So, for some reason my last email was cut off. Here is the code that I
am
trying to process from my previous problem.

Here is the code that is processing:



Foriegn Language Change:
#chgFLanguage#



How do I correct this?

Thanks,

Aimee'



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

RE: Need assistance with listbox on a form

[Clark, Aimee]

So, for some reason my last email was cut off. Here is the code that I am
trying to process from my previous problem.

Here is the code that is processing:



Foriegn Language Change:
#chgFLanguage#



How do I correct this?

Thanks,

Aimee'

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

RE: Need assistance with listbox on a form

[Clark, Aimee]

Well, I think we are headed in the right direction, however, I have a new
problem. It is now bombing out on the output:

An error occurred while evaluating the expression: 


 #chgFLanguage# is not ""



Error near line 280, column 21.

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

Need assistance with listbox on a form

[Clark, Aimee]

I have a page in which employees can update information that is contained in
their record in my SQL table. I recently added a multi-select list box with
a list of foreign languages that they can choose from if it's applicable to
them.
 
If a user selects a foreign language and submits their changes, it works.
 
If they change their address, but don't speak a foreign language and the
list box doesn't have anything selected, then they get this lovely error
message:
 
GetOld.FLanaguage IS ""


Error near line 126, column 24. 
  _  


Error resolving parameter GETOLD.FLANAGUAGE 



The column FLANAGUAGE is not present in the query named GETOLD. It is likely
that you have misspelled the name of the column. 




The error occurred while processing an element with a general identifier of
(CFIF), occupying document position (126:1) to (126:30).

Ok, so FLangauge is a field in the query, so it isn't that. Here's the piece
of the page where it's failing at:


 

 


Is the reason why I am having this problem have to do with the fact that
this is a multi-select list box and if so, how do I correct this to make
this work correctly?

For anyone who wants to see the code for the list box it is:

 
Foriegn Languages You May Speak:

   
  


  

   #LanguageName#  




Thank you,

Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
[EMAIL PROTECTED] 


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

RE: Problem with CFSchedule Page

[Clark, Aimee]

OS is Win2K

CF is version 5

-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 14, 2002 12:47 PM
To: CF-Talk
Subject: Re: Problem with CFSchedule Page


Which version of CF? Which OS? etc etc

On Monday, Oct 14, 2002, at 09:39 US/Pacific, Clark, Aimee wrote:

> This is my first attempt at creating a cfschedule page. Unfortunately,  
> it is
> not working. I coded it to run the test2.cfm page at 11:35AM, but it  
> did not
> generate the emails I was expecting. Is there something wrong with the  
> way I
> set the cfschedule up?
>
>  url="/test/test2.cfm" startdate="10/14/2002" starttime="11:35:00"
> endtime="11:45:00" interval="daily" resolveurl="Yes" publish="No">
> 
>
> Thank you,
> Aimee Clark
> Web Developer
> Stinson Morrison Hecker LLP
> 816-691-3461
> [EMAIL PROTECTED]
>
>
> 

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

Problem with CFSchedule Page

[Clark, Aimee]

This is my first attempt at creating a cfschedule page. Unfortunately, it is
not working. I coded it to run the test2.cfm page at 11:35AM, but it did not
generate the emails I was expecting. Is there something wrong with the way I
set the cfschedule up?
 


 
Thank you,
Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 


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

Need help with creating a drill-down in a page with frames

[Clark, Aimee]

I am trying to generate a page that has Training Categories with
Sub-Categories within a page with frames. I am having trouble just getting
the query to display the names of the Training Categories within the frame.
 
Here is what I have so far:
 
There is an application.cfm within the directory of files I am generating
for this page. It has 3 queries which are:
 

select * from TrainingTips order by TrainingCategory

 

select * from TrainingCategory order by TrainingCategory

 

select * from SubCategory order by SubCategory


 
Then on the framed page this is what I have:
 

   
   
   
   

 
The tiplinks.htm is the one giving me fits:
 

 
 
Today's Tip
 
Archived Tips
 

#TrainingCategory# 

 
Presently, my output within the frame looks like this:
 

Today's   Tip


Archived Tips

#TrainingCategory#
  
 
Where is says #TrainingCategory#, it's supposed to be showing me the
Training Categories in my table which are things like:
 
Word
Outlook
Excel
PowerPoint
 
etc.
 
Why is this not generating the output correctly in my frame? Any help would
be greatly appreciated.
 
Thank you,
 
Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 

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

Need help with using a counter variable within a page that send e mail to users

[Clark, Aimee]

I need some help. I am trying to devise a way where every 2nd (eventually
will be 7th) email sent out has a link in it that the users can click on
that takes them to a survey that we would like for them to participate in.
My logic so far is this:
 
1. I have a  in the application.cfm.
 
2. Then in the page where the tech clicks to close the ticket, before they
click on the submit button to go to the page that processes the sending of
email, I have:

 
3. Then this is what I have on my page for sending out the email:
 

mailto:[EMAIL PROTECTED]> @stinsonmoheck.com"
subject="Closed Help Desk Ticket"
type="HTML">
  Your Help Desk call (Ticket No. #GetCall.ID#) has been closed.  If you
believe the call should not be closed, or the problem occurs again, please
reply to this message or call the Help Desk, to let us know.

Call Information
Ticket Number:  #GetCall.ID#
Problem Description:  
#GetCall.Issue#
Resolution: 
#GetCall.Resolution#
#counter#


 

  
mailto:[EMAIL PROTECTED]> "
subject="Closed Help Desk Ticket"
type="HTML">
  Your Help Desk call (Ticket No. #GetCall.ID#) has been closed.  If you
believe the call should not be closed, or the problem occurs again, please
reply to this message or call the Help Desk, to let us know.

Call Information
Ticket Number:  #GetCall.ID#
Problem Description:  
#GetCall.Issue#
Resolution: 
#GetCall.Resolution#
#counter#
Click here to answer a
brief survey about your issue and resolution.

 

 
The probelm I am having right now is that it sends out duplicates of emails
to the tech and the user. It is also not incrementing the counter.
 
Can anyone help me figure out what is wrong with this?
 
Thank you,
 
Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 

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

RE: Using a variable to collect query-like results

[Clark, Aimee]

Thank you Bryan! That worked very well. However, I think I need a little
more help. I am receiving 257 same rows in my resultset for the same
"ticket". I am currently modifying the query to pull distinct id, but that
is not helping. Does anyone have additional thoughts on what I might try?

Thanks,
Aimee' Clark

-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 4:52 PM
To: CF-Talk
Subject: RE: Using a variable to collect query-like results


actually it should probably be:


  #preserveSingleQuotes(myquery)#


+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+---+

"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis

"Let's Roll"
- Todd Beamer, Flight 93



-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 17, 2002 1:27 PM
To: CF-Talk
Subject: Re: Using a variable to collect query-like results



 #myquery#


should read


  #myquery#


HTH


Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Clark, Aimee" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 17, 2002 1:16 PM
Subject: Using a variable to collect query-like results


> Hello everyone,
> If you had a variable set like the one I have below...how do you then
> reference the variable to display the results? (sorry in advance for the
> long posting)
>
> <-Here's the variable--->
>
> 
>
> 
>  
> 
>
> 
>  
>  
>   
>   
>  
>  
>  
>  
> 
>
> 
>  =
"
> & #CallDateStart#>
> 
>
> 
>  
>  
>
> 
>  
>
> 
>  
>
> 
>  
>
> 
>   &  #CallDescWords# & "'">
>
> 
>   &  #CallNotesWords# & "'">
>
> 
>   Calls.Resolution like  '" &  #CallResolutionWords# & "'">
>
>
> <-Here's the query I try to use--->
>
> 
>  #myquery#
> 
>
> <-Here's the output I try to display-->
>
> 
> 
>  #Ticket#
> mailto:#ExternalEmail#>
> mailto:#ExternalEmail#";>#FullName#
>  #Ext#
>  mailto:#Tech#> mailto:#Tech#";>#Tech#
>  #DateOfCall#
>  #LU#
>  href="MonitorEdit.cfm?ID=#CallsQry.Ticket#&OLDTECH=#TECH#">Edit
>  Close
>  Notes
>  #Issue#
>  #Category#
>  #Office#
> 
> 
>
> <-Here's the lovely error message I receive->
>
> ODBC Error Code = 37000 (Syntax error or access violation)
>
>
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or
> column names. Use a single space if necessary.
>
>
>
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (64:1) to (64:57).
>
>
> Date/Time: 09/17/02 15:04:06
> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Hotbar
4.1.5.0)
> Remote Address: 10.30.25.134
> HTTP Referrer: http://dailynews/helpdesk/monitorqbe.cfm
> <http://dailynews/helpdesk/monitorqbe.cfm>
>
>
>
> Does anyone have any ideas on a better way for me to generate my output?
> This is a Query By Example application.
>
>
>
> Thanks,
>
> Aimee Clark
> Web Developer
> Stinson Morrison Hecker LLP
> 816-691-3461
> [EMAIL PROTECTED]
>
>
>   _
>
>
>
<http://promos.hotbar.com/promos/promodll.dll?RunPromo&El=hotbar%5felement%3
> bst%3b&SG=&RAND=9320><http://skins.hotbar.com/Skins/promo/1px/1px.gif>
>
> 


__
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

Using a variable to collect query-like results

[Clark, Aimee]

Hello everyone,
If you had a variable set like the one I have below...how do you then
reference the variable to display the results? (sorry in advance for the
long posting)
 
<-Here's the variable--->
 

 

 

 

  
 
  
  
 
 
 
 

 

 = "
& #CallDateStart#>

 

 
 
 

 
 

 
 

 
 

 
 

 
 

 
 
 
<-Here's the query I try to use--->
 

 #myquery#

 
<-Here's the output I try to display-->
 


 #Ticket#
mailto:#ExternalEmail#>
mailto:#ExternalEmail#";>#FullName#
 #Ext#
 mailto:#Tech#> mailto:#Tech#";>#Tech#
 #DateOfCall#
 #LU#
Edit
 Close
 Notes
 #Issue#
 #Category#
 #Office#


 
<-Here's the lovely error message I receive->
 
ODBC Error Code = 37000 (Syntax error or access violation) 



[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or
column names. Use a single space if necessary. 




The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (64:1) to (64:57).


Date/Time: 09/17/02 15:04:06
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Hotbar 4.1.5.0)
Remote Address: 10.30.25.134
HTTP Referrer: http://dailynews/helpdesk/monitorqbe.cfm
 

 

Does anyone have any ideas on a better way for me to generate my output?
This is a Query By Example application.

 

Thanks,

Aimee Clark 
Web Developer 
Stinson Morrison Hecker LLP 
816-691-3461 
[EMAIL PROTECTED] 


  _  

 
 

__
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

Have a question about a cfselect....Was(RE: Need help with update on two different tables)

[Clark, Aimee]

Turns out that there was nothing wrong with this cfselect, but something
else was wrong with the data that was being saved to the multiple tables I
was inserting into. All is well, however I have a question. How can I
emulate the blank line before a cfselect in a drop down box? Here's a sample
cfselect I have:


Division:



Currently this defaults to the 1st value that the query returns. I tried to
insert a blank line in the DB, but that is not working.

Thanks,
Aimee' Clark

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 23, 2002 7:37 PM
To: CF-Talk
Subject: RE: Need help with update on two different tables


> Here's the code for the cfselect.

> 
> Gender:
>  query="GetPersonnelInfo"
> value="Gender" selected="Gender">
> M
>F
> 

My first instinct is to close the option tags... so M ... If that doesn't work, I'd start to think it's a bug
because I don't see any other problems with the  tag syntax... I'm
not sure why there's a query attribute tho, since your only options are both
provided manually and not by the query ( as is normal for cfselect ), so you
might want to remove that also... and if you want to make sure the people
entering the data don't make some women men, you might also want to add
 above the M option...


hth

Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046


__
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: Trouble updating value in table

[Clark, Aimee]

Hey, whadda know, it worked like a charm. Thank you very much!

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 26, 2002 12:38 PM
To: CF-Talk
Subject: Re: Trouble updating value in table


> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax
> near
> '110.00'.
> The error occurred while processing an element with a general identifier
> of
> (CFQUERY), occupying document position (20:1) to (20:54).
> Date/Time: 08/26/02 12:07:20
> Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
> Remote Address: 10.30.20.25
> HTTP Referrer: http://dailynews/DAC/new/Edit.cfm?ID=144

> The value '110.00' is what the user would be entering into that field.
> Below is my cfquery that updates the table. I noticed in the CF5 app
> book by Forta that you have to use CONVERT to make this work, however,
> I can't seem to find any sample code stating how to use it the way I
> need it to be done. Can anyone help me with this?

> 
> update DAC
>   set BillingInitials = '#BillingInitials#',
>   StandardRate = CONVERT(#StandardRate#, MONEY),
>   OMRate = CONVERT(#OMRate#, MONEY)
>   where ID = '#ID#'
> 

Are you sure you don't have the values for the convert statement reversed?
My experience with MS SQL Server is that the data type preceeds the value in
the arguments... Try this:

StandardRate = CONVERT(MONEY, '#standardRate#'),
OMRate = CONVERT(MONEY, '#OMRate#')


Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

__
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

Trouble updating value in table

[Clark, Aimee]

I am trying to update a table that has a field on it that in the table is
set to (money), but when I go to update the table, I receive this error: 

ODBC Error Code = 37000 (Syntax error or access violation) 
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near
'110.00'. 
The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (20:1) to (20:54).
Date/Time: 08/26/02 12:07:20
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)
Remote Address: 10.30.20.25
HTTP Referrer: http://dailynews/DAC/new/Edit.cfm?ID=144

The value '110.00' is what the user would be entering into that field. Below
is my cfquery that updates the table. I noticed in the CF5 app book by Forta
that you have to use CONVERT to make this work, however, I can't seem to
find any sample code stating how to use it the way I need it to be done. Can
anyone help me with this? 


update DAC
set BillingInitials = '#BillingInitials#',
StandardRate = CONVERT(#StandardRate#, MONEY),
OMRate = CONVERT(#OMRate#, MONEY)
where ID = '#ID#'



Thanks,
Aimee Clark
Web Developer
Stinson Morrison Hecker LLP
[EMAIL PROTECTED]

 






__
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: Displaying a dynamic HTML Table

[Clark, Aimee]

I'm curious, since you state that "In most cases I would expect this to be a
poor choice of data structure if
users are allowed to add columns to a db table"

how else would you suggest I do something like this without having to find
out what kind of tasks they would like to track and then having to hardcode
the values from the table?

Thanks,
Aimee'

-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 19, 2002 1:52 PM
To: CF-Talk
Subject: Re: Displaying a dynamic HTML Table


> I would like my output to look something like this:

> Column A  Column BColumn CColumn DColumn E
> Column F  Column G
> Y (null)
> Y Y

> Presently the column headings are fine, but the rows are not. They look
> something like this:

> AMC   AMCAMC

> What am I doing wrong? Any help would be greatly appreciated.

In most cases I would expect this to be a poor choice of data structure if
users are allowed to add columns to a db table, however...

You should be able to get the data you want by using a case statement in
your query which retrieves the data...

SELECT
CASE WHEN columna IS NULL THEN '(null)' ELSE 'Y' END AS columna,
CASE WHEN columnb IS NULL THEN '(null)' ELSE 'Y' END AS columnb
etc...

hth

Isaac Dealey
Certified Advanced ColdFusion Developer

www.turnkey.to
954-776-0046

__
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

Displaying a dynamic HTML Table

[Clark, Aimee]

I have a scenario in which I allow users to enter tasks into a SQL table by
entering the name of the task and then the table is altered to include the
new task. Presently I am querying the syscolumns table to find the name for
those tasks in that unique table.

The problem that I have now, is that I want to create a dynamic HTML table
displaying the tasks (which that part is fine), but now I need to display
the rows from the table on the page. I wrote a basic cfloop statement, but
it doesn't seem to be displaying the null values as I would expect them to.
Also, if there is data in a field in the table, I want the value on the HTML
table to reflect a "Y" for that field otherwise I want the field to be null.
This is what I have so far:






#GetRows[FieldIndex] [GetRows.CurrentRow]#




 







I would like my output to look something like this:

Column AColumn BColumn CColumn DColumn E
Column FColumn G
Y   (null)
Y   Y

Presently the column headings are fine, but the rows are not. They look
something like this:

AMC AMCAMC

What am I doing wrong? Any help would be greatly appreciated.

Thanks,
Aimee' Clark
Web Developer
Stinson Morrison Hecker




__
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

Frame within a frame error

[Clark, Aimee]

Hello. I'm new to this listserv, but I have a problem in which I hope
someone can help me with. I have a frame page that I have created in which
the top part of the  page contains an alphabet link so that when you click
on the individual letters it takes you down below to the list of names to
the letter that you click on. The problem is that at the top there is a drop
down box in which you can choose to sort the list by last name, or first
name, etc. When I choose to sort differently the page opens at the top but
within the same frame page that was orginally there. Hence I have a frame
within a frame thing going on. Anyone ever seen that or know how to fix it?

Thank you,
Aimee' Clark
User Support Specialist
Stinson, Mag & Fizzell

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