Strange query of query behavior.
I am experiencing some very strange behavior from some very strange behavior with a recursive query of a query function. I am using the function to build a tree from a ms-sql table that has a parent-child relationship in its records. This function orders the selected records by a field that in the original query can contain nulls or integers. If I order the query of query by this field, the output loop will only iterate over the first record in the record set, even though I can dump the entire record set. If I remove the fields that can contain nulls from the query of query SQL statement, the output loops over all the records. Does this make sense? Should one expect this behavior from a query-of-query? How can the tag loop over all the records but the does not? The output of this page can be seen here: http://www.sierraoutdoorrecreation.com/Geo-Order.cfm ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323066 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Guru guidance needed....
>go here: http://jqueryui.com/demos/tabs/ > >click on "Methods" tab. read about the 'URL' method. > >presumably, your product_add.cfm page adds a product using ajax post? if >so, the callback function should receive the id of newly added product >and then call the url() method on the other tabs (and maybe load() >method as well - can't remember now if just setting a new url reloads >the tab or not...) > Ahh... I wasn't posting via AJAX. I was just looking at this: http://malsup.com/jquery/form/#getting-started Thanks for the info. I think I'm on the right track now. Need to post via ajax. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jQuery Guru guidance needed....
go here: http://jqueryui.com/demos/tabs/
click on "Methods" tab. read about the 'URL' method.
presumably, your product_add.cfm page adds a product using ajax post? if
so, the callback function should receive the id of newly added product
and then call the url() method on the other tabs (and maybe load()
method as well - can't remember now if just setting a new url reloads
the tab or not...)
your url(0 method calls will look like this:
$("#productAdmin").tabs('url', 1, 'productBuilder-Categories.cfm?id='+id);
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
On 02/06/2009 09:44, Will Tomlinson wrote:
> I'm using jQuery Tabs to rebuild my ancient product admin. Trying to slicken
> it up a bit. As a product is added, I need the tab .cfm's, and the parent to
> pass around the prod ID variable to each other.
>
> The tabs I'm using: http://docs.jquery.com/UI/API/1.7/Tabs
>
> I have a parent page that contains the tabs (disabling 2nd-5th tab until a
> product is added:
>
> tabs.cfm
>
>
> $(document).ready(function() {
> $("#productAdmin").tabs({ disabled: [1, 2, 3, 4] });
>
> });
>
>
>
>
> Product Info
> Categories
> SKUS
> Suggested
> Products
> Images
>
>
> If someone is using the product info tab, and they add a product, how could I
> let the parent, tabs.cfm know, and enable the other tabs at that point.
>
> Thanks,
> Will
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323064
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
jQuery Guru guidance needed....
I'm using jQuery Tabs to rebuild my ancient product admin. Trying to slicken it
up a bit. As a product is added, I need the tab .cfm's, and the parent to pass
around the prod ID variable to each other.
The tabs I'm using: http://docs.jquery.com/UI/API/1.7/Tabs
I have a parent page that contains the tabs (disabling 2nd-5th tab until a
product is added:
tabs.cfm
$(document).ready(function() {
$("#productAdmin").tabs({ disabled: [1, 2, 3, 4] });
});
Product Info
Categories
SKUS
Suggested
Products
Images
If someone is using the product info tab, and they add a product, how could I
let the parent, tabs.cfm know, and enable the other tabs at that point.
Thanks,
Will
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323063
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DSN-Less connections in CF8
Er, all of the optional arguments. Try just the new datasource name and the
path to the file.
On Mon, Jun 1, 2009 at 8:43 PM, David McGuigan wrote:
> Try omitting the driver and the port.
>
>
>
>
>
> On Mon, Jun 1, 2009 at 7:10 PM, Scott Stewart
> wrote:
>
>>
>> So I went the API route...
>>
>>
>>
>>
>>> "D:\Sites\stlouislandscape-v1\clarity\dbStore\"&#arguments.dbFileName#>
>>> createObject("component","cfide.adminapi.administrator").login("pil0t")>
>>> createObject("component","cfide.adminapi.datasource")>
>>> dbCreate.setMSAccess("tempADSN", "#dbfile#", "MSAccess",
>> "macromedia.jdbc.MacromediaDriver", "19998")>
>>
>>> datasource="tempAccessDBDSN">
>>SELECT *
>>FROM MEMBERSHIP
>>
>>
>>
>>
>>
>>
>> I'm getting this error
>> Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of
>> type class coldfusion.server.ConfigMap.
>> The error occurred on line 1385.
>>
>> Any ideas?
>>
>> --
>> Scott Stewart
>> ColdFusion Developer
>> 4405 Oakshyre Way
>> Raleigh, NC 27616
>> (h) 919.874.6229 (c) 703.220.2835
>> -Original Message-
>> From: David McGuigan [mailto:davidmcgui...@gmail.com]
>> Sent: Monday, June 01, 2009 5:04 PM
>> To: cf-talk
>> Subject: Re: DSN-Less connections in CF8
>>
>>
>> Second that. The Admin API makes it easy.
>>
>>
>> On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert
>> wrote:
>>
>> >
>> > You can also use the Admin API to create DSNs on the fly.
>> >
>> > cheers,
>> > barneyb
>> >
>> > On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger
>> > wrote:
>> > >
>> > > Scott,
>> > >
>> > > Here's the approach we usually use (it works pretty well).
>> > >
>> > > http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx
>> > >
>> > > -Mark
>> > >
>> > >
>> > >
>> > > Mark A. Kruger, CFG, MCSE
>> > > (402) 408-3733 ext 105
>> > > www.cfwebtools.com
>> > > www.coldfusionmuse.com
>> > > www.necfug.com
>> > >
>> > > -Original Message-
>> > > From: Scott Stewart [mailto:sstwebwo...@bellsouth.net]
>> > > Sent: Monday, June 01, 2009 3:23 PM
>> > > To: cf-talk
>> > > Subject: DSN-Less connections in CF8
>> > >
>> > >
>> > > Yeah, this one's been beaten to death but.
>> > >
>> > > I need a process where a user can upload an Access db, certain tables
>> can
>> > be
>> > > read and the data inserted into a MySQL DB.
>> > >
>> > >
>> > >
>> > > The user has to be able to upload a new db once or twice a month, and
>> the
>> > > name may not always be the same.
>> > >
>> > >
>> > >
>> > > I know you used to be able to do this pre-MX, but google searches come
>> > back
>> > > with conflicting results.
>> > >
>> > >
>> > >
>> > > Has anyone gotten this to work successfully\?
>> > >
>> > >
>> > >
>> > > --
>> > > Scott Stewart
>> > > ColdFusion Developer
>> > > 4405 Oakshyre Way
>> > > Raleigh, NC 27616
>> > > (h) 919.874.6229 (c) 703.220.2835
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> > >
>> >
>> >
>>
>>
>>
>>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323062
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DSN-Less connections in CF8
Try omitting the driver and the port.
On Mon, Jun 1, 2009 at 7:10 PM, Scott Stewart wrote:
>
> So I went the API route...
>
>
>
>
> "D:\Sites\stlouislandscape-v1\clarity\dbStore\"&#arguments.dbFileName#>
> createObject("component","cfide.adminapi.administrator").login("pil0t")>
> createObject("component","cfide.adminapi.datasource")>
> dbCreate.setMSAccess("tempADSN", "#dbfile#", "MSAccess",
> "macromedia.jdbc.MacromediaDriver", "19998")>
>
> datasource="tempAccessDBDSN">
>SELECT *
>FROM MEMBERSHIP
>
>
>
>
>
>
> I'm getting this error
> Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of
> type class coldfusion.server.ConfigMap.
> The error occurred on line 1385.
>
> Any ideas?
>
> --
> Scott Stewart
> ColdFusion Developer
> 4405 Oakshyre Way
> Raleigh, NC 27616
> (h) 919.874.6229 (c) 703.220.2835
> -Original Message-
> From: David McGuigan [mailto:davidmcgui...@gmail.com]
> Sent: Monday, June 01, 2009 5:04 PM
> To: cf-talk
> Subject: Re: DSN-Less connections in CF8
>
>
> Second that. The Admin API makes it easy.
>
>
> On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert
> wrote:
>
> >
> > You can also use the Admin API to create DSNs on the fly.
> >
> > cheers,
> > barneyb
> >
> > On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger
> > wrote:
> > >
> > > Scott,
> > >
> > > Here's the approach we usually use (it works pretty well).
> > >
> > > http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx
> > >
> > > -Mark
> > >
> > >
> > >
> > > Mark A. Kruger, CFG, MCSE
> > > (402) 408-3733 ext 105
> > > www.cfwebtools.com
> > > www.coldfusionmuse.com
> > > www.necfug.com
> > >
> > > -Original Message-
> > > From: Scott Stewart [mailto:sstwebwo...@bellsouth.net]
> > > Sent: Monday, June 01, 2009 3:23 PM
> > > To: cf-talk
> > > Subject: DSN-Less connections in CF8
> > >
> > >
> > > Yeah, this one's been beaten to death but.
> > >
> > > I need a process where a user can upload an Access db, certain tables
> can
> > be
> > > read and the data inserted into a MySQL DB.
> > >
> > >
> > >
> > > The user has to be able to upload a new db once or twice a month, and
> the
> > > name may not always be the same.
> > >
> > >
> > >
> > > I know you used to be able to do this pre-MX, but google searches come
> > back
> > > with conflicting results.
> > >
> > >
> > >
> > > Has anyone gotten this to work successfully\?
> > >
> > >
> > >
> > > --
> > > Scott Stewart
> > > ColdFusion Developer
> > > 4405 Oakshyre Way
> > > Raleigh, NC 27616
> > > (h) 919.874.6229 (c) 703.220.2835
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323061
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
@ Jason >Are there Ajax or iframe calls or something that could be making >updates to that session var for that user at the same time in a >situation where the order of execution could cause an unexpected value >to be read back out by the server? Yup... >To me, it just seems that you almost need to prove out that your >application is likely to allow a true race condition before locking >every call. Acknowledged. My (admittedly conservative) approach is to prove that the app _doesn't_ need locking rather than the reverse. Don't get me wrong, I'm all in favour of eliminating both the extra coding burden as well as the overhead. That said, the docs seem to lean towards locking when in doubt... that and the fact I've had the whole locking religion hammered home relentlessly over the years. It may take me a while to get with the new program. ;-) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323060 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DSN-Less connections in CF8
So I went the API route... SELECT * FROM MEMBERSHIP I'm getting this error Element macromedia.jdbc.MacromediaDriver is undefined in a Java object of type class coldfusion.server.ConfigMap. The error occurred on line 1385. Any ideas? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 -Original Message- From: David McGuigan [mailto:davidmcgui...@gmail.com] Sent: Monday, June 01, 2009 5:04 PM To: cf-talk Subject: Re: DSN-Less connections in CF8 Second that. The Admin API makes it easy. On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert wrote: > > You can also use the Admin API to create DSNs on the fly. > > cheers, > barneyb > > On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger > wrote: > > > > Scott, > > > > Here's the approach we usually use (it works pretty well). > > > > http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx > > > > -Mark > > > > > > > > Mark A. Kruger, CFG, MCSE > > (402) 408-3733 ext 105 > > www.cfwebtools.com > > www.coldfusionmuse.com > > www.necfug.com > > > > -Original Message- > > From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] > > Sent: Monday, June 01, 2009 3:23 PM > > To: cf-talk > > Subject: DSN-Less connections in CF8 > > > > > > Yeah, this one's been beaten to death but. > > > > I need a process where a user can upload an Access db, certain tables can > be > > read and the data inserted into a MySQL DB. > > > > > > > > The user has to be able to upload a new db once or twice a month, and the > > name may not always be the same. > > > > > > > > I know you used to be able to do this pre-MX, but google searches come > back > > with conflicting results. > > > > > > > > Has anyone gotten this to work successfully\? > > > > > > > > -- > > Scott Stewart > > ColdFusion Developer > > 4405 Oakshyre Way > > Raleigh, NC 27616 > > (h) 919.874.6229 (c) 703.220.2835 > > > > > > > > > > > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323059 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
@Jay Yes, fair enough. Granted that CF doesn't guarantee the order of execution when processing threads in a request, does the application in this case really have the possibility of having multiple threads making sequential changes to that specific session variable (which is thread-safe to that user already) on different threads at the same time? Are there Ajax or iframe calls or something that could be making updates to that session var for that user at the same time in a situation where the order of execution could cause an unexpected value to be read back out by the server? That would be a very rare condition, but if it's possible, then, yes, you should lock. As for reading from the application scope, as in the OP example, that's at least going to be covered by the thread-safe nature of MX, as noted in Simon's entry. To me, it just seems that you almost need to prove out that your application is likely to allow a true race condition before locking every call. Even when I used to do some fairly complex apps that happened to be iframe-driven, I only let one frame ever *write* to persistent scope, the others were only reads, so for something like session or client scope, the move from 4.5 to MX was a great relief in that regard. But certainly to each his own :) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFDocumentitem strangeness
I am using cfdocument to output mutliple cfdocumentsections and everything works fine...except for the cfdocumentitem header within each section. All of the other code in the section handles the loop iteration correctly, but the cfdocumentitem outputs only data for the last record in the result set. So, if I have records 100, 101, 102, and 103, the cfocumentitem will show 103 for each section. How can I get this to cooperate? All of the examples I have found are very simple things like ouputting page numbers. Thanks in advance, Billy Cox Old World Spices bi...@oldworldspices.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
>Then lock the application scope with a read-only lock, copy the value >into a local variable, then lock the session scope with an exclusive >lock, then copy the local variable into the session. Roger that... Thanks, Dave & all. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323056 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
On Mon, Jun 1, 2009 at 16:59, Jay Greer wrote: > > @Dave > >> What version of CF is this? > > CF-8.1 > >> Is there any likelihood of a race condition with Application.bar? > > It's possible, yes. > >> If there is the likelihood of a race condition with that variable, do >> I care? That is, could the race condition cause an improper value of >> any significance? > > Definitely... > >> Is there any likelihood of a race condition with Session.foo? > > It's possible, yes. > >> If there is, do I care? > > Definitely... Then lock the application scope with a read-only lock, copy the value into a local variable, then lock the session scope with an exclusive lock, then copy the local variable into the session. 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
@Jason >Assuming you're on CFMX 7 or 8, you no longer need to LOCK on READ... Well that's debatable for sure... http://www.horwith.com/index.cfm/2008/4/28/cflock-explained http://www.horwith.com/index.cfm/2008/7/17/CFLOCK-further-explained ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323054 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DSN-Less connections in CF8
Second that. The Admin API makes it easy. On Mon, Jun 1, 2009 at 2:36 PM, Barney Boisvert wrote: > > You can also use the Admin API to create DSNs on the fly. > > cheers, > barneyb > > On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger > wrote: > > > > Scott, > > > > Here's the approach we usually use (it works pretty well). > > > > http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx > > > > -Mark > > > > > > > > Mark A. Kruger, CFG, MCSE > > (402) 408-3733 ext 105 > > www.cfwebtools.com > > www.coldfusionmuse.com > > www.necfug.com > > > > -Original Message- > > From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] > > Sent: Monday, June 01, 2009 3:23 PM > > To: cf-talk > > Subject: DSN-Less connections in CF8 > > > > > > Yeah, this one's been beaten to death but. > > > > I need a process where a user can upload an Access db, certain tables can > be > > read and the data inserted into a MySQL DB. > > > > > > > > The user has to be able to upload a new db once or twice a month, and the > > name may not always be the same. > > > > > > > > I know you used to be able to do this pre-MX, but google searches come > back > > with conflicting results. > > > > > > > > Has anyone gotten this to work successfully\? > > > > > > > > -- > > Scott Stewart > > ColdFusion Developer > > 4405 Oakshyre Way > > Raleigh, NC 27616 > > (h) 919.874.6229 (c) 703.220.2835 > > > > > > > > > > > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323053 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
@Dave > What version of CF is this? CF-8.1 > Is there any likelihood of a race condition with Application.bar? It's possible, yes. > If there is the likelihood of a race condition with that variable, do > I care? That is, could the race condition cause an improper value of > any significance? Definitely... > Is there any likelihood of a race condition with Session.foo? It's possible, yes. > If there is, do I care? Definitely... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: DSN-Less connections in CF8
You can also use the Admin API to create DSNs on the fly. cheers, barneyb On Mon, Jun 1, 2009 at 1:26 PM, Mark Kruger wrote: > > Scott, > > Here's the approach we usually use (it works pretty well). > > http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx > > -Mark > > > > Mark A. Kruger, CFG, MCSE > (402) 408-3733 ext 105 > www.cfwebtools.com > www.coldfusionmuse.com > www.necfug.com > > -Original Message- > From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] > Sent: Monday, June 01, 2009 3:23 PM > To: cf-talk > Subject: DSN-Less connections in CF8 > > > Yeah, this one's been beaten to death but. > > I need a process where a user can upload an Access db, certain tables can be > read and the data inserted into a MySQL DB. > > > > The user has to be able to upload a new db once or twice a month, and the > name may not always be the same. > > > > I know you used to be able to do this pre-MX, but google searches come back > with conflicting results. > > > > Has anyone gotten this to work successfully\? > > > > -- > Scott Stewart > ColdFusion Developer > 4405 Oakshyre Way > Raleigh, NC 27616 > (h) 919.874.6229 (c) 703.220.2835 > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining the order of HTML tags atrributes.
Ok, so I decided to throw together a rough example of how comparing changes using XmlParse/HtmlParse could work. It only compares attributes - I wasn't sure if children tags needed checking, nor how best to do that - it could potentially get quite complex! (But feel free to have a go, and re-post the code if you get anything interesting!) If you look at what the code does, I'm sure you can work out how you might produce a function that converts to string and always puts attributes in alphabetical order. :) Oh, and one more note before the code: I haven't actually tested this in CF, only Railo - but it should work fine in CF8, unless I've left in anything Railo-specific. ... ... ... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: DSN-Less connections in CF8
Scott, Here's the approach we usually use (it works pretty well). http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Scott Stewart [mailto:sstwebwo...@bellsouth.net] Sent: Monday, June 01, 2009 3:23 PM To: cf-talk Subject: DSN-Less connections in CF8 Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323049 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
DSN-Less connections in CF8
Yeah, this one's been beaten to death but. I need a process where a user can upload an Access db, certain tables can be read and the data inserted into a MySQL DB. The user has to be able to upload a new db once or twice a month, and the name may not always be the same. I know you used to be able to do this pre-MX, but google searches come back with conflicting results. Has anyone gotten this to work successfully\? -- Scott Stewart ColdFusion Developer 4405 Oakshyre Way Raleigh, NC 27616 (h) 919.874.6229 (c) 703.220.2835 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help ColdFusion Output URGENT
Thanks. But what what you suggesting is not working. I need to display. 1 area
manager on one line and get all the calculation on one line
>You could do it better with aggregate functions, but this will work, too.
>Just make the completionDate lookup part of your base query (note the LEFT
>OUTER JOIN), and then use the GROUP attribute of the CFOUTPUT tag to do the
>looping for you in one go:
>
>
>Select distinct e.employeeid,
>e.last_name,
>er.last_name as erLastName,
>er.first_name as erFirstName,
>er.EMployeeID as REID,
>ea.last_name as eaLastName,
>ea.first_name as eaFirstName,
>l.name as locname,
>l.locationID,
>ea.Employeeid as AEID,
>et.completionDate
>from employee e join
>employeejobhistory h on h.employeeid = e.employeeid inner join
>jobassignment ja on (ja.sequence = h.sequence) inner join
>jobcode_list j on j.jobcode = h.jobcode inner join
>location l on l.locationid = ja.locationid inner join
>area a on a.areaid = l.areaid inner join
>employee ea on ea.employeeid = a.managerEmpID inner join
>region r on r.regionid = a.regionid inner join
>employee er on er.employeeid = r.managerEmpID LEFT OUTER JOIN
>employeeTraining et ON e.employeeID = et.employeeID
>AND et.courseID = 1661
>where ja.EndDate is NULL
>
>and h.JobCode in ('1024','1005','1059','1009','1014','1001')
>and h.DeptName like 'Reminiscence%'
>
>and h.JobCode in ('1025')
>and h.DeptName like 'Reminiscence%'
>
>and h.JobCode in
>('1024','1005','1059','1009','1014','1001','1025')
>and h.DeptName like 'Reminiscence%'
>
>and ja.EmplRcd = 0
>and r.ManagerEmpID in (#SESSION.Admin_Reports_locregmanager#)
>order by REID, AEID, l.locationID
>
>
>
>
>Area
>Total Number of people
>Total Employees Completed
>% Completed
>
>
>
>
>
>
>
>
>
>
>
>#AreaLastName#,
>#AreaFirstName#
>#AreaTotal#
>#AreaComplete#
>style="color:##FF8000">#NumberFormat(percent2, "0.00")#%
>
>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323047
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Modification
That's a good way to re-use the variable. Since there doesn't appear to be a simple function, that's the way I'll go. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323046 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Query Modification
On #2, I assume then that you know which column you would be removing, so how about: get the list of current columns, whatever they are: remove a known column, in this example "phone": now, requery QofQ based on the reduced column list: SELECT #colList# FROM employees That allows the actual list of columns to be entirely dynamic, while still removing whichever known columns you want to remove, AND still re-uses the same variable, so there's no additional server overhead, or at least not anything noticeable. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323045 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maintaining the order of HTML tags atrributes.
>But why not use a RegEx to pull the tag out of both bits of >content, then scan over using list functions, using a space as a >delimeter to start, then = as the secondary delimeter ... Because some evil person could put, for example: And either make your regex extra complicated, if not impossible. Far better to use DOM parsing for this sort of thing, and a good parser will have the intricacies of HTML built into it, so will be much simpler to use. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: mx7 debugger
Tried it with id and name attributes set with the same result. thanks, Mike >What does your full http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323043 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Query Modification
Well, For two reasons 1) I really didn't want to incur the overhead of creating a new variable and running the query. I know it has to be much slower than simply dleting for the object. Not the best reason but... 2) Maintenenace issues. The columns I wish to delete are fairly static but the other columns may change depending on what the flex app needs. To use a QoQ I would need to use the columnlist to build the query parsing out the unneeded columns. Granted, neither reason is really a show stopper. I figured if there was a way to add a column, there should be a way to remove one so I thought I'd ask. Sometimes you just never know what you'll find out. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
> That would work, but it's unnecessary overhead unless you're still on CF 5. > Virtually all that locking has been handled in MX. Well, no, that's actually not correct. CF doesn't lock variables unless you use CFLOCK. It simply doesn't crash if you don't lock them, as it used to with CF 5 and earlier. But if you have the potential for a race condition, and you care about the outcome of said condition, you need to lock variables. 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 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323041 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Query Modification
I 2nd this. I looked through the java stuff and I don't see a way to remove a column. Just add and manipulate them. Jake Churchill CF Webtools 11204 Davenport, Ste. 100 Omaha, NE 68154 http://www.cfwebtools.com 402-408-3733 x103 -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Monday, June 01, 2009 2:13 PM To: cf-talk Subject: re: Query Modification Query of Queries would work really well, and would be very efficient ... why not do that? Query 'employees' has: firstName, lastName, title, email, phone, ext SELECT firstName, lastName, email FROM employees That would get you there with very little overhead ... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: mx7 debugger
What does your full http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323039 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Query Modification
Query of Queries would work really well, and would be very efficient ... why not do that? Query 'employees' has: firstName, lastName, title, email, phone, ext SELECT firstName, lastName, email FROM employees That would get you there with very little overhead ... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
That would work, but it's unnecessary overhead unless you're still on CF 5. Virtually all that locking has been handled in MX. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323037 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Help ColdFusion Output URGENT
Come on dude, you've been told before, help us by asking better questions!
What doesn't work?
Format your code so it's easy for us to see what's going on, I can't be
bothered to look through your code because it's all over the place.
If the query is correct and the problem lies in the output, why include the
big ol' query?
Oh and... why oh why do you put 'urgent' in the subject line, it's not
urgent to me?!
Adrian
> -Original Message-
> From: erik tom [mailto:erik.tso...@jhu.edu]
> Sent: 01 June 2009 19:18
> To: cf-talk
> Subject: Help ColdFusion Output URGENT
>
>
> I have a query which list all the Team members, their Area MANagers,
> Region Managers, Locations and so on .
> What i need to do is to display each managers(name)
> column2: total number of people in their area
> column3: and total number of people completed the course in the area
>
> I came up with code but does not seems to work now
> query:
>
> Select distinct e.employeeid, e.last_name,
> er.last_name as erLastName, er.first_name as erFirstName,
> er.EMployeeID as REID,
> ea.last_name as eaLastName, ea.first_name as eaFirstName,
> l.name as locname, l.locationID,ea.Employeeid as AEID
> from employee e
> join employeejobhistory h on h.employeeid
> = e.employeeid
>
>
> inner join jobassignment ja on
> (ja.sequence = h.sequence)
> inner join jobcode_list j
> on j.jobcode = h.jobcode
> inner join location l
> on l.locationid = ja.locationid
> inner join area a
> on a.areaid = l.areaid
> inner join employee ea on
> ea.employeeid = a.managerEmpID
> inner join region r on
> r.regionid = a.regionid
> inner join employee er on
> er.employeeid = r.managerEmpID
>
> where ja.EndDate is NULL isDefined("form.RC") and form.RC eq 0>and (h.JobCode in
> ('1024','1005','1059','1009','1014','1001') and h.DeptName like
> 'Reminiscence%')and
> (h.JobCode in ('1025') and h.DeptName like 'Reminiscence%') and
> (h.JobCode in ('1024','1005','1059','1009','1014','1001','1025')and
> h.DeptName like 'Reminiscence%')and
> ja.EmplRcd = 0 and r.ManagerEmpID in
> (#SESSION.Admin_Reports_locregmanager#)
> order by REID,AEID,l.locationID
>
> The code is below :
>
>
> Area
> Total
> Number of people
> Total Employees
> Completed
> % Completed
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> AreaLastName=getCareManagers.eaLastName>
> AreaFirstName=getCareManagers.eaFirstName>
> datasource="cfelsunrise">
> Select completionDate
> from EmployeeTraining where courseID = 1661 and EmployeeID =
> #getCareManagers.EmployeeID#
>
>
> AEID>
> AreaTotal + 1>
> isDate(getCompletion.CompletionDate)>
> AreaComplete = AreaComplete + 1>
>
>
>
>
>
>
> #AreaLastName#,#AreaFirstName#
>
> #AreaTotal#
>
> #AreaComplete#
>
> style="color:##FF8000">#NumberFormat(percent2,"0.00")#%
>
>
>
>
>
>
>
>
>
>
>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323036
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: Help ColdFusion Output URGENT
You could do it better with aggregate functions, but this will work, too.
Just make the completionDate lookup part of your base query (note the LEFT
OUTER JOIN), and then use the GROUP attribute of the CFOUTPUT tag to do the
looping for you in one go:
Select distinct e.employeeid,
e.last_name,
er.last_name as erLastName,
er.first_name as erFirstName,
er.EMployeeID as REID,
ea.last_name as eaLastName,
ea.first_name as eaFirstName,
l.name as locname,
l.locationID,
ea.Employeeid as AEID,
et.completionDate
from employee e join
employeejobhistory h on h.employeeid = e.employeeid inner join
jobassignment ja on (ja.sequence = h.sequence) inner join
jobcode_list j on j.jobcode = h.jobcode inner join
location l on l.locationid = ja.locationid inner join
area a on a.areaid = l.areaid inner join
employee ea on ea.employeeid = a.managerEmpID inner join
region r on r.regionid = a.regionid inner join
employee er on er.employeeid = r.managerEmpID LEFT OUTER JOIN
employeeTraining et ON e.employeeID = et.employeeID
AND et.courseID = 1661
where ja.EndDate is NULL
and h.JobCode in ('1024','1005','1059','1009','1014','1001')
and h.DeptName like 'Reminiscence%'
and h.JobCode in ('1025')
and h.DeptName like 'Reminiscence%'
and h.JobCode in
('1024','1005','1059','1009','1014','1001','1025')
and h.DeptName like 'Reminiscence%'
and ja.EmplRcd = 0
and r.ManagerEmpID in (#SESSION.Admin_Reports_locregmanager#)
order by REID, AEID, l.locationID
Area
Total Number of people
Total Employees Completed
% Completed
#AreaLastName#,
#AreaFirstName#
#AreaTotal#
#AreaComplete#
#NumberFormat(percent2, "0.00")#%
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323035
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Query Modification
Hi! I have an ORACLE stored proc returning a query back to my CFC using CFProcResult. I pass this query up to Flex and some other places. Works fine but What I'd like to do is remove a column or two before I pass it on. Selected columns are only needed by the CFC so I'd like to remove them and clean up the query before I send it on. I can't find any way to delete a column in the docs and I really don't want to loop over the query or do a query of queries. Is the some other way to delete a column? Maybe via Java? Thanks! Warren Koch ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323034 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
> Is there any reason you can't simply lock the app scope, grab application variable and put it into a local variable, unlock, lock session, copy from local var to session var, unlock? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
Assuming you're on CFMX 7 or 8, you no longer need to LOCK on READ, so if you're concerned about race conditions on the WRITE, just do: (timeout can be whatever is appropriate) ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323032 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
> Having a brain cramp on this one guys... > > How would one approach locking when reading a value from the APPLICATION > scope and subsequently writing it to the SESSION scope..? > > EXAMPLE > -- > > It depends. What version of CF is this? Is there any likelihood of a race condition with Application.bar? If there is the likelihood of a race condition with that variable, do I care? That is, could the race condition cause an improper value of any significance? Is there any likelihood of a race condition with Session.foo? If there is, do I care? 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! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323031 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Locking Issue - Read value from APPLICATION scope & write it to SESSION scope
Having a brain cramp on this one guys... How would one approach locking when reading a value from the APPLICATION scope and subsequently writing it to the SESSION scope..? EXAMPLE -- ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323030 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help ColdFusion Output URGENT
I have a query which list all the Team members, their Area MANagers, Region
Managers, Locations and so on .
What i need to do is to display each managers(name)
column2: total number of people in their area
column3: and total number of people completed the course in the area
I came up with code but does not seems to work now
query:
Select distinct e.employeeid, e.last_name,
er.last_name as erLastName, er.first_name as erFirstName, er.EMployeeID
as REID,
ea.last_name as eaLastName, ea.first_name as eaFirstName,
l.name as locname, l.locationID,ea.Employeeid as
AEID
from employee e
join employeejobhistory h on h.employeeid =
e.employeeid
inner join jobassignment ja on (ja.sequence
= h.sequence)
inner join jobcode_list j on
j.jobcode = h.jobcode
inner join location l on
l.locationid = ja.locationid
inner join area a on
a.areaid = l.areaid
inner join employee ea on ea.employeeid =
a.managerEmpID
inner join region r on r.regionid =
a.regionid
inner join employee er on er.employeeid =
r.managerEmpID
where ja.EndDate is NULL and (h.JobCode in ('1024','1005','1059','1009','1014','1001')
and h.DeptName like 'Reminiscence%')and (h.JobCode in ('1025') and h.DeptName like 'Reminiscence%')
and (h.JobCode in ('1024','1005','1059','1009','1014','1001','1025')and
h.DeptName like 'Reminiscence%')and
ja.EmplRcd = 0 and r.ManagerEmpID in
(#SESSION.Admin_Reports_locregmanager#)
order by REID,AEID,l.locationID
The code is below :
Area
Total Number of
people
Total Employees
Completed
% Completed
Select completionDate from
EmployeeTraining where courseID = 1661 and EmployeeID =
#getCareManagers.EmployeeID#
#AreaLastName#,#AreaFirstName#
#AreaTotal#
#AreaComplete#
#NumberFormat(percent2,"0.00")#%
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323029
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Authentication with Active Directory
Thanks Judah. Our DBAs want to eliminate the generic account that I have my datasources setup with. Like you mentioned, they want to control users access at the DB level. Does CF8 support passing users credentials using integrated security? I think my only option, like you mentioned is to handle the security at the application level but the generic account will still have to exist on the DB server. >I think that Dave has basically answered your question but I'll toss >out the notion that if it was acceptable in your environment you could >do the same sort of permissions but at the application level instead >of the db. > >CF can do authentication with Active Directory via the CFLDAP tag. You >could fetch a list of permissions and then proxy the calls to the db >and only allow certain queries involving your sprocs and views to >people with sufficient privileges. > >Though it is functionally equivalent to what you are talking about, it >may be that they want the roles and permissions enforced down at the >SQL Server level. There are some good reasons to do so and then there >are some reasons that, well, that's just how an organization has >always done it and isn't changing now. > >Anyway, if you are investigating CF talking to Active Directory, start >with the CFLDAP tag. > >Take care, >Judah > > >> ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Maintaining the order of HTML tags atrributes.
Well this may sound goofy, and if it's a bad idea, say so... But why not use a RegEx to pull the tag out of both bits of content, then scan over using list functions, using a space as a delimeter to start, then = as the secondary delimeter, build up a structure of attributes and their values for both sides then just loop over the key lists and compare values? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining the order of HTML tags atrributes.
>Maybe I am missing something here, but why not just use the order that >FCKEditor uses? Then once it is save from FCKEditor, it would be in the >order that you want it. You know there is no way to modify FCKEditor's >behavior, so why not just make use of it as a known value? > >Eric > That was the first thing that came to my mind but the source file displays attributes randomly depending on what browser is used by the editor, to add to the complexity the source file is from an external source (XML), so I'm stripping the required text from the source file into the database using xpath, it is the database content that are edited then compared with the content in the xml file to see what was changed. Whichever route I go e.g. changing the atrributes order in the original xml file, I need to have control over the HTML attributes. Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
mx7 debugger
Hi,
I am getting the following error on the debugger tab in IE7 and Firefox when I
use in a page instead of just . None of the debugging details
are available when this happens.
Error from Firebug:
unterminated string literal
[Break on this error] document.write('Col...ascript"
src="/CFIDE/scripts/cfform.js">
Displayed on "debugger" tab:
'); } } function writeCloseBody() { if( debugMode ) { document.write(''); } }
//== TREE STATE ==
function setCookie( targetName, value ) { var cookieValue = targetName + "=" +
escape(value); var exp = new Date(); var nowPlus30Days = exp.getTime() + (30 *
24 * 60 * 60 * 1000); exp.setTime( nowPlus30Days ); document.cookie =
cookieValue + "; expires=" + exp.toGMTString() + ";"; } function
getCookieValue( name ) { var thisCookie = document.cookie.split("; ") for( i=0;
i ColdFusion MX Debugging
thanks for any help,
Mike
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323025
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
AddSOAPRequestHeader
I'm trying to consume a webservice that expects: x x ...so I wrote: ...but this generates: http://xml.apache.org/xml-soap";> PASSWORD x USERNAME x USERACCESSKEY x How do I emulate the header that the webservice is expecting? -- John Bliss IT Professional LinkedIn: http://www.linkedin.com/in/jbliss ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining the order of HTML tags atrributes.
Maybe I am missing something here, but why not just use the order that FCKEditor uses? Then once it is save from FCKEditor, it would be in the order that you want it. You know there is no way to modify FCKEditor's behavior, so why not just make use of it as a known value? Eric On Mon, Jun 1, 2009 at 2:47 AM, Matthew Allen wrote: > > >> So on database storage Replace(theString," >> "ALL")>, then on output Replace(theStringFromDbase, "tableplaceholder", > >> "something like that anyway..a bit of a hack but > >> it might save you the hassle till you find something more suitable... > >> > >> Jide. > > > >Thanks Jide should have thought of that.. > > Guys, both didn't work, XStandard is a very cool editor but didn't do the > trick. The place holder Jide suggested is fine on initial entry into the > database but once it's loaded again for subsequent edits the browser again > re orders the atrributes > > There has got to be a way to re order/maintain HTML attributes...anyone? > > Thanks, > > Matt > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323023 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
IUM Re: IUM Re: IUM Re: Google Map API
Excellent .. thanks Ryan, will let you know how I get on with that, looks straightforward! Jenny -Original Message- From: Ryan Letulle [mailto:bayous...@gmail.com] Sent: 30 May 2009 20:03 To: cf-talk Subject: SPAM-MEDIUM Re: IUM Re: IUM Re: Google Map API This what I do. Hope it helps: http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> http://www.w3.org/1999/xhtml"; xmlns:v="urn:schemas-microsoft-com:vml"> http://maps.google.com/maps?file=api&v=2.x&key=#reque st.gmapkey# " type="text/javascript"> var map = null; var geocoder = null; function initialize() { if (GBrowserIsCompatible()) { map = new GMap2(document.getElementById("map_canvas")); map.setCenter(new GLatLng(40.78704, -73.965797), 13); map.setUIToDefault() geocoder = new GClientGeocoder(); } } function showAddress(address) { if (geocoder) { geocoder.getLatLng( address, function(point) { if (!point) { alert(address + " not found"); } else { map.setCenter(point, 13); var marker = new GMarker(point); map.addOverlay(marker); marker.openInfoWindowHtml(address); } } ); } } -- Ryan On Sat, May 30, 2009 at 7:50 AM, Jenny Gavin-Wear < jenn...@fasttrackonline.co.uk> wrote: > > Hi Ryan, > > I looked at the page again in firefox using the Javascript error console > > src=" > http://maps.google.com/maps?file=api&v=2&key=#session.GoogleKey > #" > type="text/javascript"> > >//function load() { > if (GBrowserIsCompatible()) { >var map = new GMap2(document.getElementById("map")); >map.setCenter(new GLatLng(#dLatitude#, #dLongitude#), 14); >map.addControl(new GLargeMapControl()); >map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#), 3); >var point = new GPoint(#dLatitude#, #dLongitude#); >var marker = new GMarker(point); >map.addOverlay(marker); > } >} >//]]> > > > The line: > map.centerAndZoom(new GPoint(#dLatitude#, #dLongitude#), 3); > > gives the error: > map.centerAndZoom is not a function > > I removed this line assuming if it was bad the script would stop processing > at this point, but still no marker. > > Jenny > > > > > > -Original Message- > From: Ryan Letulle [mailto:bayous...@gmail.com] > Sent: 28 May 2009 14:06 > To: cf-talk > Subject: SPAM-MEDIUM Re: IUM Re: Google Map API > > > > I assume you are not getting any javascript errors? > -- > Ryan > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323022 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 - Error Trapping CFCs
Using application.cfc, you can use the OnError method, ie. 2009/6/1 ColdFusion Developer : > > I have a web application utilizing CF7 and within the Application.cfc file, > I have a function called onError to handle the error trapping. > > This works find for the simple errors but if an error occurs in a CFC, it is > not trapped. > > I have the three error types specified as: > > > > > > How can I trap CFC errors (other tran wrapping EACH cfc invoke call with a > CFTR/CATCH routine? > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 - Error Trapping CFCs
*** Disregard *** I tracked it down to being an issue within the error handler itself. For some reason it does not like the statement: .. blah blah It was barking that the variable "ERROR" does not exists, even though (correct me if I am wrong) but would be a structure of the error data? On Mon, Jun 1, 2009 at 7:43 AM, Raymond Camden wrote: > > What does your onError look like? > ** Di > On Mon, Jun 1, 2009 at 6:09 AM, ColdFusion Developer > wrote: > > > > I have a web application utilizing CF7 and within the Application.cfc > file, > > I have a function called onError to handle the error trapping. > > > > This works find for the simple errors but if an error occurs in a CFC, it > is > > not trapped. > > > > I have the three error types specified as: > > > > > > > > > > > > How can I trap CFC errors (other tran wrapping EACH cfc invoke call with > a > > CFTR/CATCH routine? > > > > > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323020 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF7 - Error Trapping CFCs
What does your onError look like? On Mon, Jun 1, 2009 at 6:09 AM, ColdFusion Developer wrote: > > I have a web application utilizing CF7 and within the Application.cfc file, > I have a function called onError to handle the error trapping. > > This works find for the simple errors but if an error occurs in a CFC, it is > not trapped. > > I have the three error types specified as: > > > > > > How can I trap CFC errors (other tran wrapping EACH cfc invoke call with a > CFTR/CATCH routine? > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF7 - Error Trapping CFCs
I have a web application utilizing CF7 and within the Application.cfc file, I have a function called onError to handle the error trapping. This works find for the simple errors but if an error occurs in a CFC, it is not trapped. I have the three error types specified as: How can I trap CFC errors (other tran wrapping EACH cfc invoke call with a CFTR/CATCH routine? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323018 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Maintaining the order of HTML tags atrributes.
>> So on database storage Replace(theString,"> "ALL")>, then on output Replace(theStringFromDbase, "tableplaceholder", >> "something like that anyway..a bit of a hack but >> it might save you the hassle till you find something more suitable... >> >> Jide. > >Thanks Jide should have thought of that.. Guys, both didn't work, XStandard is a very cool editor but didn't do the trick. The place holder Jide suggested is fine on initial entry into the database but once it's loaded again for subsequent edits the browser again re orders the atrributes There has got to be a way to re order/maintain HTML attributes...anyone? Thanks, Matt ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
