More than one datasource in cfquery

2005-05-09 Thread simmyana a
Hi, How to use more than one datasource in cfquery tag? Thanks ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client

Re: More than one datasource in cfquery

2005-05-09 Thread Jared Rypka-Hauer - CMG, LLC
Simmyana, Well... basically... you can't. :/ Perhaps a more in-depth description of the need would help us resolve the issue? Laterz, J On 5/9/05, simmyana a [EMAIL PROTECTED] wrote: Hi, How to use more than one datasource in cfquery tag? Thanks -- ---

ColdFusion J2EE mysterious error

2005-05-09 Thread Thomas Chiverton
(weblogic 7, JRocket JVM, Oracle DB). Every so often, our CF server dies, returning a 500 internal server error. Has anyone seen a ExecuteThread: '1' for queue: 'default' kernel identity 100028 Could not deserialize session data

Re: More than one datasource in cfquery

2005-05-09 Thread Michael Traher
You can have the datasource dynamic i.e. cfquery name=myQuery datasource=#myCurrentDatasource# some SQL. /cfquery you can set the variable 'myCurrentDatasource' elsewhere in your code as required. HTH Mike On 5/9/05, Jared Rypka-Hauer - CMG, LLC [EMAIL PROTECTED] wrote: Simmyana,

Re: Using more than one datasource in cfquery

2005-05-09 Thread Karl
At 12:22 AM 5/9/05, Thanks wrote: How to use more than one datasource in cfquery tag? I think J is technically right about CFQUERY but there have to be other ways to skin the cat, such as by using two separate queries on different datasources and then combining their outputs with a

Is Proxy Server Recognition Possible?

2005-05-09 Thread Karl Simanonok
Is it possible (and if so, how) to detect on a web page that a visitor is using a proxy server? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/05

PS: Is REAL TIME Proxy Server Recognition Possible?

2005-05-09 Thread Karl Simanonok
I meant to say is it possible in REAL TIME? Is it possible (and if so, how) to detect on a web page that a visitor is using a proxy server? -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.6 - Release Date: 5/6/05

Re: Is Proxy Server Recognition Possible?

2005-05-09 Thread Jochem van Dieten
Karl Simanonok wrote: Is it possible (and if so, how) to detect on a web page that a visitor is using a proxy server? Not if the proxy doesn't want to be detected. But you can do a generic check on all the cgi variables for a proxy header and detect the ones that don't care about being

Re: ColdFusion J2EE mysterious error (more info)

2005-05-09 Thread Thomas Chiverton
On Monday 09 May 2005 09:06, Thomas Chiverton wrote: (weblogic 7, JRocket JVM, Oracle DB). What about java.lang.NoClassDefFoundError: coldfusion/filter/RequestMonitorFilter at coldfusion.filter.RequestMonitorFilter.isFilterEnabled()Z(RequestMonitorFilter.java:???) at

Re: location 26 error COM

2005-05-09 Thread Adam Haskell
Well the issue has been resolved. I uninstalled and reinstalled to COM API after finding out that one part of the api was on the c drive and the other part was on the E drive...for some reason I could use the VB scripts and the GUI but CF would bomb out. Adam H On 5/6/05, Adam Haskell [EMAIL

Re: cf5 question

2005-05-09 Thread Adam Haskell
couldn;t you just do #application[client.version][s][scenario]# aside from it looking cleaner its is better b/c it doesn't use evaluate :) Adam H On 5/8/05, Dave Watts [EMAIL PROTECTED] wrote: Hi, I have a blank, it's been too long since I worked with CF5. I'm trying to do something that

RE: More than one datasource in cfquery

2005-05-09 Thread Ewok
You can't with one shot. You'll have to query each then combine them with a QoQ (assuming you are running CF5.0 or up) !--- DATASOURCE ONE --- cfquery name=a datasource=datasource1 Select * from tbl_in_db1 /cfquery !--- DATASOURCE TWO --- cfquery name=b datasource=datasource2 Select * from

RE: More than one datasource in cfquery

2005-05-09 Thread Robertson-Ravo, Neil (RX)
Erm, well you can only use one DSN in a single CFQUERY but you should be able to use a Cross Database Query allowing you to search across two databases. -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 13:06 To: CF-Talk Subject: RE: More than one datasource in

RE: More than one datasource in cfquery

2005-05-09 Thread Matthew Small
Which database? - Matt Small -Original Message- From: simmyana a [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 2:05 AM To: CF-Talk Subject: More than one datasource in cfquery Hi, How to use more than one datasource in cfquery tag? Thanks

Weird problem logging in with IE 5.5

2005-05-09 Thread Stuart Kidd
Hi guys, For some time now users have been sending me mails saying that they can't log into my application.  I try and all is fine. I am now trying it with IE5.5 and am having the same problem occur. Does anyone know of any straight-forward reason why this could be?  I would have thought it

RE: Weird problem logging in with IE 5.5

2005-05-09 Thread Andy Mcshane
Could it possibly be to do with cookies? Do they have their browser setup to allow cookies? From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: Mon 09/05/2005 13:38 To: CF-Talk Subject: Weird problem logging in with IE 5.5 Hi guys, For some time now users have

RE: More than one datasource in cfquery

2005-05-09 Thread Ewok
Yes, one 'true datasource' in a cfquery but you can use 2 different record sets in a QoQ and combine them just as if they were 2 tables in one database. What's Cross Database Query? 'Sounds' promising. I've had to use the method in my previous example quite a bit in my latest nightmare... oh I

Re: More than one datasource in cfquery

2005-05-09 Thread Adam Haskell
If you use MS SQL you can use Linked Servers to query across different servers. it would be something like: Select * From myLink.database.owner.table Adam H On 5/9/05, Ewok [EMAIL PROTECTED] wrote: Yes, one 'true datasource' in a cfquery but you can use 2 different record sets in a QoQ and

RE: More than one datasource in cfquery

2005-05-09 Thread Robertson-Ravo, Neil (RX)
Yep basically the format is database.owner.table.column So you could do SELLECT * FROM EmployeeDirectory.dbo.Employee -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 14:27 To: CF-Talk Subject: Re: More than one datasource in cfquery If you use MS SQL

Re: High Load Server... how much more can it take?

2005-05-09 Thread Adam Churvis
I don't try to second-guess unusual scenarios under which race conditions might not need locking; I just lock them according to the rules, C'mon, I asked a very specific question. I know my example is frivolous but it is oversimple for the sake of easy illustration. And I promise that I'm

OT: Parent-Child Relationships within Table

2005-05-09 Thread Kazmierczak, Kevin
How does everyone handle an N level parent-child type relationship within the same table? Say you have the following table setup for Categories categoryid category parentid You could have any level of categories each with the parent pointing up the path. The problem I'm interested

RE: More than one datasource in cfquery

2005-05-09 Thread Mark A Kruger
For example - if you have 3 different installations of an ap with three different user databases and you wanted to build a single interface for all three (like a master administrators db) - you could create a user on the MS SQL server with permissions to all three. Then, using a DSN with that

Re: Encrypting email with CF5.0

2005-05-09 Thread Wayne Graham
Not in CF 5, in CF 6 there's a Java wrapper for GPG at http://swem.wm.edu/blogs/waynegraham On 5/6/05, Jim Louis [EMAIL PROTECTED] wrote: Is there any way to do this with out cfexecute. I am on a shared server and the do not allow cfexecute. Jim Louis We use the gdata Outlook plugin

Re: More than one datasource in cfquery

2005-05-09 Thread Matt Friedman
A great trick in MS SQL that will solve your issue is to use this format select a.col1,a.col2, b.col1,b.col2 froma, database_name..b as b where a.col1 = b.col1 The trick is taht the database_name is the name in the SQL server not CF admin. that works fine and you can

RE: More than one datasource in cfquery

2005-05-09 Thread Robertson-Ravo, Neil (RX)
NO!! There are awful table aliases which mean nothing. It is just plain ugly to abbreaviate them like this... at the very least you should qualify the name in some waytable a, b,c and d is just lazy. -Original Message- From: Matt Friedman [mailto:[EMAIL PROTECTED] Sent: 09 May

RE: Parent-Child Relationships within Table

2005-05-09 Thread COLLIE David
Category Path: Sports - Hockey - Teams - Buffalo Sabres You want to find anything that is a member of the hockey category and any sub category within. Really busy but recommend googling (and the HoF archives) on Joe Celko , he seems to be the master of the parent-child tree in SQL :)

Javascript to coldfusion

2005-05-09 Thread Jeremy Bunton
I want to set a javascript var to a coldfusion variable, what I am doing looks like below. The value being a true false Boolean. I keep getting an error that doit is undefined in CF. I've gone from coldfusion to JS before, but not the other way around. Thanks Jeremy script var doit = confirm(Are

RE: Javascript to coldfusion

2005-05-09 Thread COLLIE David
Hidden form field... Get it in next submission... Alternatively... Have the text in CF before it and use the var in the javascript. cfscript cfset didit = Are you sure you want to delete? / /cfscript script type=text/javascript var doit = confirm('#JSStringFormat(didit)#'); /script

Re: Javascript to coldfusion

2005-05-09 Thread frederick valone
You cannot set a coldfusion variable on the client side as you did below. You can set javascript variables to the value of cf variables that have already been set. cfset doit = Are you sure you want to delete? cfoutput script var didit = confirm(#doit#); /script /cfoutput Jeremy Bunton

Re: Javascript to coldfusion

2005-05-09 Thread Keith Gaughan
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jeremy Bunton wrote: I want to set a javascript var to a coldfusion variable, what I am doing looks like below. The value being a true false Boolean. I keep getting an error that doit is undefined in CF. I've gone from coldfusion to JS before,

Locking a DB record while editing

2005-05-09 Thread Jeff Langevin
I am curious to know how you folks have handled locking a database record in a shared application. Basically user 1 selects from a list of records to edit. Normally, I would then immediately go in an write a timestamp that locks the record. When user 2 comes I don't allow him/her to edit

RE: Parent-Child Relationships within Table

2005-05-09 Thread James Holmes
This is a great quick ref: http://www.oreilly.com/catalog/sqlpr/chapter/ch01.pdf -Original Message- From: COLLIE David [mailto:[EMAIL PROTECTED] Sent: Monday, 9 May 2005 10:11 To: CF-Talk Subject: RE: Parent-Child Relationships within Table Category Path: Sports - Hockey - Teams -

Re: OT: Parent-Child Relationships within Table

2005-05-09 Thread Sergey Croitor
Additional parent_path field will help you to retrieve all the branch starting at a given tree item by a single SELECT query: SELECT * FROM Categories WHERE parent_path LIKE '#start_item_path##path_delimiter#%' If you want to avoid having problems with keeping parent_path field in actual state

RE: Locking a DB record while editing

2005-05-09 Thread Trey Rouse
I take a different approach. I record in the users session the id timestamp of the record when they open it to edit. I then check this timestamp when I go to update the record. If the timestamps are the same, then I allow the update. If they are not the same, I generally don't let the user

RE: More than one datasource in cfquery

2005-05-09 Thread Ewok
Nice. So it's only possible with MySQL and MS SQL Server data sources? I don’t know what DB Simmyana is using but the one I mentioned was SQL server. -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 9:59 AM To: CF-Talk Subject: RE: More than

odd data model

2005-05-09 Thread Bryan Stevenson
Hey All, I always join my tables directly like so: TableA.PK_Field joins to FK TableB.PK_Field_fromTableA Like with products and categories..the product records have an FK back to categories table via cat_id Now I've been handed with a data model that joins all tables associated with lets

Re: Locking a DB record while editing

2005-05-09 Thread Jeff Langevin
The issue I see with your timestamp method is that I don't want to allow the 2nd user to be able to edit it at the same time. In this case they would be able to do a view on it. Again, maybe I'm being anal here, but I don't like the idea of the field by field comparison and then write as this

CF Blog shootout

2005-05-09 Thread Michael Dinowitz
There are basically 3 CF based blog packages: BlogFusion (http://www.countersinkdg.com/) BlogCFM (http://www.blogcfm.org/index.cfm) BlogCFC (http://www.camdenfamily.com/morpheus/blog/) What are peoples opinions of each? ~|

RE: CF Blog shootout

2005-05-09 Thread Che Vilnonis
for good looks, you can't beat Ray's blog with the Aura stylesheets applied to them. -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 12:41 PM To: CF-Talk Subject: CF Blog shootout There are basically 3 CF based blog packages: BlogFusion

RE: More than one datasource in cfquery

2005-05-09 Thread Mark A Kruger
Uh... the purpose here is to point out the technique of addressing other databases from in the same query. For my part I use a and b because I don't want to type as much - Obviously they are not necessarily good aliases - although I hasten to add on a very small query they are pretty obvious.

RE: More than one datasource in cfquery

2005-05-09 Thread Mark A Kruger
As I said there is a way to do this in Access but I've lost my sample syntax (or maybe am averse to finding it - ha). Most RDBMs will have a way to do this or something similar. -mk -Original Message- From: Ewok [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 11:17 AM To: CF-Talk

Re: Locking a DB record while editing

2005-05-09 Thread Adam Haskell
I lock using Application scope...when a user reads in a row I put the User ID as a key in the application scope then and the row ID as the value. onsessionend fires something that gets rid of the key. Application scope is locked which prevents any sort of race conditions... Adam H On 5/9/05,

RE: CF Blog shootout

2005-05-09 Thread Mark A Kruger
Please explain the aura stylesheets (as I'm using rays blog). Is this an enhancement or is it already part of it? -Mark Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent:

Re: odd data model

2005-05-09 Thread Adam Haskell
This does not seem too odd to me what you discribe, if I understand, is just a normalized Schema it seamsProducts, Categories, and Colors then a linking table that dictates what products/colors are in what category... Adam H On 5/9/05, Bryan Stevenson [EMAIL PROTECTED] wrote: Hey All, I

RE: Locking a DB record while editing

2005-05-09 Thread Burns, John D
You could store a userID and timecode in the db for that row to show who has it checked out and when it will be available. The only thing is that you need some sort of way to resolve the situation where someone opens a record and closes their browser before checking it back in. This could be

RE: CF Blog shootout

2005-05-09 Thread Che Vilnonis
see this link... http://clearsoftware.net/client/index.cfm?mode=entryentry=A6BF9536-E081-2BA C-6928967E1EAC1DD4 if you use the most recent version of Ray's blog, there are a few issues. namely, remove all instances of cfsetting and on the *new* layout.cfm page, remove the #application.root

RE: More than one datasource in cfquery

2005-05-09 Thread Ewok
NO!! There are awful table aliases which mean nothing. It is just plain ugly to abbreaviate them like this... at the very least you should qualify the name in some waytable a, b,c and d is just lazy. Woah, lean back, take a deep breathe then pop a pill. It's too early in the week

Flash forms, images and netscape

2005-05-09 Thread Jason Rogoz
I'm trying to display an image in a flash form, everything displays fine in IE but netscape seems to display the image if it is not nested in cfformgroup tags...i'm trying to place a panel on the page and then show an image in the panel...is this a known issue or is there a workaround for it?

Re: odd data model

2005-05-09 Thread Bryan Stevenson
This does not seem too odd to me what you discribe, if I understand, is just a normalized Schema it seamsProducts, Categories, and Colors then a linking table that dictates what products/colors are in what category... Adam...the example was simple and has nothing to do with products ;-)

Re: More than one datasource in cfquery

2005-05-09 Thread Jochem van Dieten
Ewok wrote: Nice. So it's only possible with MySQL and MS SQL Server data sources? That depends on your definition of a database :-) If you look carefully at what MySQL calls a database you will see that it is actually not a database but a schema and all that is implemented is cross-schema

Re: CF Blog shootout

2005-05-09 Thread Sean Corfield
On 5/9/05, Michael Dinowitz [EMAIL PROTECTED] wrote: There are basically 3 CF based blog packages: BlogFusion (http://www.countersinkdg.com/) BlogCFM (http://www.blogcfm.org/index.cfm) BlogCFC (http://www.camdenfamily.com/morpheus/blog/) What are peoples opinions of each? What I like about

RE: More than one datasource in cfquery

2005-05-09 Thread S . Isaac Dealey
Nice. So it's only possible with MySQL and MS SQL Server data sources? I don't know what DB Simmyana is using but the one I mentioned was SQL server. Iirc, with MS Access if you place multiple db's in the same directory, you can reference them in queries to any of them the way that you can

RE: odd data model

2005-05-09 Thread James Holmes
I agree - it doesn't seem normalised (it seems to repeat a lot of info for each colour). -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 10 May 2005 1:06 To: CF-Talk Subject: Re: odd data model This does not seem too odd to me what you discribe, if I

(announce) cftips and captivate

2005-05-09 Thread Michael Dinowitz
I'm finally getting http://www.cftips.com off the ground and to test out a few things (while I'm looking for podcast and blog software), I've put up a captivate presentation on web marketing with blogs. Go on over and check it out. Let me know what you think. The next one will be on making

Re: OT: Parent-Child Relationships within Table

2005-05-09 Thread Jochem van Dieten
Sergey Croitor wrote: Additional parent_path field will help you to retrieve all the branch starting at a given tree item by a single SELECT query: SELECT * FROM Categories WHERE parent_path LIKE '#start_item_path##path_delimiter#%' If you want to efficiently query subsets of the entire

Re: odd data model

2005-05-09 Thread Bryan Stevenson
I think what I find odd is the one to one relationships in this type of model. I'd think that having a cat_id in a product record makes more sense than moving that relationship to a central join table when it's only a one-to-one (as I mentioned in my last mail...duplicating the category

Re: odd data model

2005-05-09 Thread Adam Haskell
Its normailsed if you have different colors in different categorieswhich I make the assumption that would be the case. I don't know that I would design it this way but it makes enough sense to me...There are different norilization patterns and this seems to match one of them pretty

RE: More than one datasource in cfquery

2005-05-09 Thread Dave Watts
Does anybody know if queries against MS SQL Server linked servers run in one transaction? Yes, I think they can, using MS DTC: http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c08ppcsq.mspx Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the

RE: odd data model

2005-05-09 Thread Kerry
just a thought, i know the products/categories/colours is just an example but, perhaps the db structure makes sense if you have something like this: black hiking boot in the outdoor category brown hiking boot in the outdoor category black hiking boot in the casual category brown hiking boot in

RE: More than one datasource in cfquery

2005-05-09 Thread Matthew Small
You can reference an Access db using its path: users.mdb content.mdb store.mdb select * from c:\users.mdb\product or something very close to that. - Matt Small -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 1:08 PM To: CF-Talk Subject:

Re: odd data model

2005-05-09 Thread Deanna Schneider
I'd agree that it seems clumsy. The queries would be horrific - you'd be self-joining to the same table multiple times. Ouch. - Original Message - From: Bryan Stevenson [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, May 09, 2005 12:06 PM Subject: Re: odd data

Re: odd data model

2005-05-09 Thread Bryan Stevenson
Yeah Kerry...it's a one-to-one on category so hiking boots only in one category...but thanks ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web:

Re: odd data model

2005-05-09 Thread Adam Haskell
Like with products and categories..the product records have an FK back to categories table via cat_id This would be far too limiting for me...this forces me to have a one to many by using a linking table I can place smoething into 2 categories. Categories -- Categories have products --

Re: odd data model

2005-05-09 Thread Adam Haskell
If different colors would go into different categories (seems a bit odd but is bussiness could dictate this) how would you approach it differently than what you originally presented? Example: A dress comes in a variety of colors Red, Pastel Blue, Green, Yellow, Black. The dress is a Spring

Re: odd data model

2005-05-09 Thread Bryan Stevenson
Like with products and categories..the product records have an FK back to categories table via cat_id This would be far too limiting for me...this forces me to have a one to many by using a linking table I can place smoething into 2 categories. Categories -- Categories have products --

Re: odd data model

2005-05-09 Thread Bryan Stevenson
A dress comes in a variety of colors Red, Pastel Blue, Green, Yellow, Black. The dress is a Spring Dress. The Pastel Blue would make a great easter Clothing option Black wouldn't be very Easter like. At this point how do you design your model? -colour table -product table -season table

RE: odd data model

2005-05-09 Thread Kerry
Anyways..I'm asking the designer not the only part of the model I found odd im gonna guess they cut and pasted from another project -Original Message- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: 09 May 2005 18:50 To: CF-Talk Subject: Re: odd data model Like with

Re: odd data model

2005-05-09 Thread Adam Haskell
What you took as season were categories but yes you were missing something unless a Pastel Blue Down Feather Coat and pastel blue condoms are apropriate for easter morning service ;) All the same I get where you are coming from and understand how it could be a wierd model...ecspecially for 1-1s

Re: odd data model

2005-05-09 Thread Bryan Stevenson
im gonna guess they cut and pasted from another project alas...no...it was designed last nightbut the designer is in the air on the way to DC...so I can't call him right now ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone:

Re: odd data model

2005-05-09 Thread Bryan Stevenson
Thanks Deanna/James...thought perhaps I was alone and my last 8 years of data modelling had been horrifically wrong (well...not really...hehe). Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830

RE: More than one datasource in cfquery

2005-05-09 Thread Dawson, Michael
That depends on your definition of a database IBM's Unidata renamed database to account. Unidata's databases, so to speak, are directory structures. Some files in a base directory, others are in sub directories. If you want to see a whacked non-rdbms solution, you should read a whitepaper, or

Re: OT: Parent-Child Relationships within Table

2005-05-09 Thread Al Everett
Academic, really, with Oracle 9i. (Which is what we're using at the day job.) If 7 is the categoryid for Hockey: select categoryid, category, level from catalog start with categoryid=7 connect by parentid = prior categoryid level is a pseudo-column indicates the level of the tree, starting with

Re: Locking a DB record while editing

2005-05-09 Thread Matt Robertson
I do what Adam does. Application scope array, all reads and writes properly locked :-). A user tries to hit an edit page. The requested record ID is compared to a list of reserved IDs and, if the record is not in the array, it is added in along with user ID and 'last accessed' time. Every time

Re: CF Blog shootout

2005-05-09 Thread Raymond Camden
Just to be fair - and others have pointed this out - putting Aura on my blog isn't super easy. The default UI is passable but it won't win any design contests. As always - if you try the blog and have problems, please email me. I try to respond as quick as possible (not the rapid version

RE: odd data model

2005-05-09 Thread Micha Schopman
That sounds too me like a basic normalized datamodel. http://www.mschopman.demon.nl/diagram.gif uses a similair approach. It is just way to keep things in hand when handling data with alot of dependencies and modelling for future enhancements. From: Bryan

Re: Locking a DB record while editing

2005-05-09 Thread Jeff Langevin
Thanks! This is definitely a more elegant way to handle it. But one question... do I really have to lock the reads? ...kidding! Just kidding... ;-) --Jeff On 5/9/2005 3:13 PM, Matt Robertson wrote: I do what Adam does. Application scope array, all reads and writes properly locked :-).

Creating Windows GUIDs with Cold Fusion

2005-05-09 Thread SStewart
All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with Cold Fusion? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527 --

Re: More than one datasource in cfquery

2005-05-09 Thread Jeff Langevin
Ah yes. We have Benefactor here which runs over Unidata. Its unfortunate that you must use UniQuery to do all the interactions with the DB (on our version). One of the newer versions of Unidata is supposed to support ODBC with an add-on package. Unfortunately, we don't have it. :( --Jeff

Re: odd data model

2005-05-09 Thread Bryan Stevenson
Hey Micha, I checked out your schema...not seeing what I'm talking about ;-) OK..here's a much clearer view of what I'm on about: PRODUCT prod_id CATEGORY cat_id COLOUR colour_id BIG MOTHER JOIN TABLE prod_id cat_id products_prod_id category_cat_id colour_colour_id So the join table has the

CFForm, Section 508, JAWS and Window-Eyes problem

2005-05-09 Thread Don Neizer
Below are 2 basic cfform examples; test_a1.cfm and test_a2.cfm (test_a2.cfm is only provided as a submission point). Several efforts have failed in getting the JAWS and Window-Eyes programs to read the test_a1.cfm which uses the format=”flash” attribute. Has anyone else run into this? Is there

Re: Creating Windows GUIDs with Cold Fusion

2005-05-09 Thread S . Isaac Dealey
check www.cflib.org I'm pretty sure there's a function for MS GUID format. All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with Cold Fusion? sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place,

Re: Creating Windows GUIDs with Cold Fusion

2005-05-09 Thread Marlon Moyer
Like this? http://www.cflib.org/udf.cfm?ID=54 or do you mean something else... On 5/9/05, SStewart [EMAIL PROTECTED] wrote: All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with Cold Fusion? sas Scott A. Stewart, Web Application Developer Engineering

Re: More than one datasource in cfquery

2005-05-09 Thread Michael Traher
It would be great to hear if any of this helps 'simmyana' :-) On 5/9/05, simmyana a [EMAIL PROTECTED] wrote: Hi, How to use more than one datasource in cfquery tag? Thanks ~| Find out how CFTicket can increase your

Creating Windows GUIDs with Cold Fusion

2005-05-09 Thread Steve Bryant
Try out this UDF: http://cflib.org/udf.cfm?ID=54 All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with Cold Fusion? ~| Find out how CFTicket can increase your company's customer support

RE: Creating Windows GUIDs with Cold Fusion

2005-05-09 Thread SStewart
Yeah, I just saw that... That should do exactly what I need Thanks again This list rules all sas Scott A. Stewart, Web Application Developer Engineering Consulting Services, Ltd. (ECS) 14026 Thunderbolt Place, Suite 300 Chantilly, VA 20151 Phone: (703) 995-1737 Fax: (703) 834-5527

Re: Creating Windows GUIDs with Cold Fusion

2005-05-09 Thread Marlon Moyer
Like this? http://www.cflib.org/udf.cfm?ID=54 or do you mean something else... On 5/9/05, SStewart [EMAIL PROTECTED] wrote: All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with Cold Fusion? sas Scott A. Stewart, Web Application Developer Engineering

Re: Creating Windows GUIDs with Cold Fusion

2005-05-09 Thread Marlon Moyer
Sorry, gmail hiccup. On 5/9/05, Marlon Moyer [EMAIL PROTECTED] wrote: Like this? http://www.cflib.org/udf.cfm?ID=54 or do you mean something else... On 5/9/05, SStewart [EMAIL PROTECTED] wrote: All, Has anyone tried creating a Windows GUID (Globally Unique Indentifier) with

RE: CFForm, Section 508, JAWS and Window-Eyes problem

2005-05-09 Thread Sandy Clark
Its not that helpful, but at least you know you aren't alone. http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=fcd4391epss=rs s_flash_fcd4391e -Original Message- From: Don Neizer [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 3:41 PM To: CF-Talk Subject: CFForm,

CF Blog shootout

2005-05-09 Thread Jake .
Just a heads up that this week, I'll be launching the new BlogFusion 4.0. It includes both a blog and a photoblog all under one application. I've also recently acquired the blogfusion.com domain name from a squatter, so the new site has also just launched: www.blogfusion.com Interestingly,

Re: odd data model

2005-05-09 Thread Adam Haskell
Atleast someone else agress with me :) with my stiring the pot comment on cf-jobs-talk about not scoping vairables and then this I was begining to feel like this job was sucking me back into the dark ages of programing. Adam H On 5/9/05, Micha Schopman [EMAIL PROTECTED] wrote: That sounds too

RE: CF Blog shootout

2005-05-09 Thread Mark A Kruger
Ray, I was able to do it in about 1/2 an hour - but I don't have a very fancy blog. -Mark -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 2:19 PM To: CF-Talk Subject: Re: CF Blog shootout Just to be fair - and others have pointed this out -

SOT: CFMX 6.1 download?

2005-05-09 Thread Chris Alvarado
Can anyone point me to where I can get the CFMX 6.1 server install? We have 6.0 on CD and I know we can install the updates for 6.1 but we have had problems with that before thus id rather just download the 6.1 package. Thanks! -chris.alvarado [ application developer ] 4 Guys

Re: CF Blog shootout

2005-05-09 Thread Adrocknaphobia
Well in a point to point comparison of BlogFusion and Ray's... Ray's blog is free! -Adam On 5/9/05, Jake. [EMAIL PROTECTED] wrote: Just a heads up that this week, I'll be launching the new BlogFusion 4.0. It includes both a blog and a photoblog all under one application. I've also recently

RE: CF Blog shootout

2005-05-09 Thread Mark A Kruger
Yes - but to be fair, Jake's product is far more full featured and it looks to be reasonably priced. -Mark -Original Message- From: Adrocknaphobia [mailto:[EMAIL PROTECTED] Sent: Monday, May 09, 2005 3:48 PM To: CF-Talk Subject: Re: CF Blog shootout Well in a point to point

RE: Locking a DB record while editing

2005-05-09 Thread Trey Rouse
Thus why in general, I don't let them save if another user updated the record since user1 began working with it. Force them to go back and open it again and see the changes. It all depends on the type of data and the level of concern involved, but this approach has worked well for me. Trey

Re: Locking a DB record while editing

2005-05-09 Thread Matt Robertson
On 5/9/05, Jeff Langevin [EMAIL PROTECTED] wrote: But one question... Hah! You funny guy. You keep day job. As I said I've been meaning to write this up, and I just finished. Originally used includes and I converted them to custom tags and genericized it. Let me know if you want a copy, as

Re: SOT: CFMX 6.1 download?

2005-05-09 Thread Sean Corfield
On 5/9/05, Chris Alvarado [EMAIL PROTECTED] wrote: Can anyone point me to where I can get the CFMX 6.1 server install? http://www.macromedia.com/software/coldfusionmx61/downloads/ -- Sean A Corfield -- http://corfield.org/ Team Fusebox -- http://fusebox.org/ Got Gmail? -- I have 50, yes 50,

Re: More than one datasource in cfquery

2005-05-09 Thread Jochem van Dieten
Dave Watts wrote: Does anybody know if queries against MS SQL Server linked servers run in one transaction? Yes, I think they can, using MS DTC: http://www.microsoft.com/technet/prodtechnol/sql/2000/books/c08ppcsq.mspx I don't think that you can access XA functionality from CF without

RE: CF Blog shootout

2005-05-09 Thread Jake .
Yeah, Ray's blog is a great app, and has been running CF blogs for a long time. You'll hear nothing bad about it from me. Not really to compete with free, but to get the non-commercial licensing down to something reasonable, I've made the price a purchase off my amazon wishlist... which

Re: Locking a DB record while editing

2005-05-09 Thread Jeff Langevin
Hey Matt, Yes, if you could email it to me, that would be great. Thanks! --Jeff On 5/9/2005 5:01 PM, Matt Robertson wrote: On 5/9/05, Jeff Langevin [EMAIL PROTECTED] wrote: But one question... Hah! You funny guy. You keep day job. As I said I've been meaning to write

  1   2   >