Re: Upgrading from cf 7 standard to Enterprise

2006-03-17 Thread Andy Allan
Can you export from Standard? It's been that long since I used a Standard install I can't remember. But yes, as DK says, to get from Standard to Multi-Server you need to do an uninstall/reinstall. Andy On 17/03/06, Douglas Knudsen [EMAIL PROTECTED] wrote: use the CFadmin tool to archive your

Re: jsessionid/urltoken - how would I do this?

2006-03-17 Thread Will Tomlinson
SESSION.URLTOKEN contains the jsessionid on a J2EE sessions enabled server, so it will work anyway. Ahhh.. I gotcha! Thanks James! Will ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235610 Archives:

Deployment licencing cost

2006-03-17 Thread Mark Drew
Hi all I havent been able to find this informatino out anywhere on the MM site. If I am running CF7 Enterprise, and I deploy an application as a source-less war/ear onto ANOTHER server running JRun, what are the costs? Would I have to buy 2 CF7 Enterprise licences? one for the one doing the

Re: Deployment licencing cost

2006-03-17 Thread Andy Allan
Kind of :) If both are production machines then yes, you would need licenses for both as the CF runtime engine gets included in your deployed package. However, because you can deploy from the Developer Edition you don't necessarily need a license for the box doing the deployment. (And as an

Re: Deployment licencing cost

2006-03-17 Thread Mark Drew
Both of the machines will be production. So the answer is that yes.. even the machines that we are deploying to will need a licence. Pants :) thanks! MD On 17 Mar 2006, at 12:12, Andy Allan wrote: Kind of :) If both are production machines then yes, you would need licenses for both as

Re: Deployment licencing cost

2006-03-17 Thread Andy Allan
Yeah, fraid so out of interest, NewAtlanta operate a different licensing scheme for deploying applications like you're describing. It's something along the lines of, if you're selling your application for £800 then that's what the customer pays, they don't need to worry about the cost of the

Re: Deployment licencing cost

2006-03-17 Thread John Beynon
that's an interesting licensing model..I'd certainly never heard of that myself jb. On 3/17/06, Andy Allan [EMAIL PROTECTED] wrote: Yeah, fraid so out of interest, NewAtlanta operate a different licensing scheme for deploying applications like you're describing. It's something along the

Re: Eclipse issues

2006-03-17 Thread Robert Everland III
I found a post on CFEclipse forum about this. Looks like it's related to the Antivirus scanning network files, it changes the timestamp which causes the file to not synch with Eclipse anymore. I think it's a bug that the Eclipse is working on. Bob

RE: CF Server not working after months of flawless service

2006-03-17 Thread Dawson, Michael
I'm not much help, but I have seen the exact same problem recently on three different servers. One server is a dev box that is a but under-powered, but the other two servers kick ass and should not have any problems as far as timing-out. Either something expired in the install, or the HotFix 2

Large count query caching

2006-03-17 Thread Jeremy Bunton
I have a query counting records in a 25 million plus database. Even with indexing and what not it takes about 25 seconds to run this query. (count * from table where date 19000101) Is there a way I could cache the query so that if it is ran in that same way it very quickly returns the full count.

Re: Large count query caching

2006-03-17 Thread Mingo Hagen
Hi Jeremy, Yes, you can very easily cache queries using the cachedwithin= attribute of cfquery Like so: cfquery datasource=mydata name=myquery cachedwithin=#createTimeSpan( 1, 0, 0, 0 )# SELECT COUNT( * ) FROM myTable WHERE myDate '1900-01-01' /cfquery This will cache your query for

Re: Large count query caching

2006-03-17 Thread Aaron Rouse
The only problem with this is the query can change due to the dynamic building of the where clause. Could do a cached query that selects everything that could be in the where clause then do QoQ on that for dynamic where clause needs. I'd just be a little fearful of how much would need to be

Re: Large count query caching

2006-03-17 Thread John Paul Ashenfelter
On 3/17/06, Jeremy Bunton [EMAIL PROTECTED] wrote: I have a query counting records in a 25 million plus database. Even with indexing and what not it takes about 25 seconds to run this query. (count * from table where date 19000101) Is there a way I could cache the query so that if it is ran

RE: Large count query caching

2006-03-17 Thread Jeremy Bunton
Yeah I thought about that also, but since all my queries, regardless of the ever changing where clause only return a count, never a full record set, I would think that the memory usage would be small or am I wrong? This machine sql 2005 has 4 gig of ram, but the data as a .csv was over 8 gig so I

Re: Large count query caching

2006-03-17 Thread Aaron Rouse
If you were taking the route of a cached query then yes/no that you are wrong. If the count() is going to change based upon the where clause then you would have to have a single master cached query that pulled out everything possibly needed so that you could then do QoQ on that for the dynamic

RE: CF Server not working after months of flawless service

2006-03-17 Thread Munson, Jacob
In the last few weeks, since I added MS SQLServer2005, the CF Server hasnt started automatically as it's supposed to Aha! Microsoft is intentionally breaking ColdFusion because it's a competitor to ASP! How dare they...the dirty dogs. If you were wondering, I /am/ joking. It's Friday,

Re: Deployment licencing cost

2006-03-17 Thread John Beynon
FYI, from Charlie: Yep, see FAQ 311: http://www.newatlanta.com/c/products/bluedragon/self_help/faq/detail?faqId=311 jb On 3/17/06, John Beynon [EMAIL PROTECTED] wrote: that's an interesting licensing model..I'd certainly never heard of that myself jb. On 3/17/06, Andy Allan [EMAIL

RE: Large count query caching

2006-03-17 Thread Wolfe, Aaron
You should use a field name in the count instead of the *. It should speed it up. SELECT COUNT( fieldname ) FROM myTable With the * it has to return all records and all fields. -Original Message- From: Jeremy Bunton [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 9:28 AM To:

RE: Large count query caching

2006-03-17 Thread mark
Is there a finite number of options for a count? Even if the number is 50, you could run the queries late at night and cache the results for 24 hours? It wouldn't take any shorter time, but to the user it would be much better. Mark -Original Message- From: Aaron Rouse [mailto:[EMAIL

RE: Large count query caching

2006-03-17 Thread Jeremy Bunton
There is a pretty large number of options. Considering zip codes(43,000 of in the US), area code, state and about 16 other fields are available. I think what it does now will work, the main problem was with nothing selected, oddly enough the more ands in the where clause the faster the clustered

Re: Large count query caching

2006-03-17 Thread Aaron Rouse
What is a bitmap index? On 3/17/06, Jeremy Bunton [EMAIL PROTECTED] wrote: There is a pretty large number of options. Considering zip codes(43,000 of in the US), area code, state and about 16 other fields are available. I think what it does now will work, the main problem was with nothing

RE: Large count query caching

2006-03-17 Thread Munson, Jacob
oddly enough the more ands in the where clause the faster the clustered index seems to go. That does seem odd, but that's the way it usually works. The 'ands' are cutting off chunks of data from the whole, and making the search cover smaller areas. Also, if your 'ands' are part of your

RE: Large count query caching

2006-03-17 Thread Mark A Kruger
If you cannot cache on the web server - make sure and bind the data using CFQUERYPARAM. This will enable the RDMBS to use a cached execution plan on it's end. I have a blog on why this is important. http://mkruger.cfwebtools.com/index.cfm?mode=aliasalias=cfqueryparam Secondly, change the * to

Why is this failing??

2006-03-17 Thread Richard Colman
Here is a simple program flow statement that is failing. I don't know why. Data values are not null. I am probably doing something really stupid. Can someone offer an insight? TNX. cfif getproject.clusterbillable is Yes value should be Yes but is #getproject.clusterbillable#

RE: Why is this failing??

2006-03-17 Thread Munson, Jacob
Maybe you have white space after your value, in the data? I don't know if you copy/pasted that result line, but if you did there /is/ a space there. Could just be your email software too. :) -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Friday, March 17,

RE: Large count query caching

2006-03-17 Thread Jeremy Bunton
I'll check that out, I am not using them now. Jeremy -Original Message- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 11:09 AM To: CF-Talk Subject: RE: Large count query caching If you cannot cache on the web server - make sure and bind the data using

RE: Why is this failing??

2006-03-17 Thread Richard Colman
That was it. Added a trim and problem cleaned up. TNX very much. -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 8:22 AM To: CF-Talk Subject: RE: Why is this failing?? Maybe you have white space after your value, in the data? I don't know

Re: Large count query caching

2006-03-17 Thread Mingo Hagen
Hi Aaron, Are you sure about that? I just tried three different queries (count(*), count(field) and count(0)) on two joined tables with a date selection which return a count of about 50 records. all three queries run in exactly the same time (1.5sec). I think I read somewhere that it should

RE: Application.cfc

2006-03-17 Thread Steve Brownlee
Unfortunately, it's one or the other. Cannot use them in conjunction. There was a topic about this a ways back. You might want to search the forums for it. Might be helpful. -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 11:39 AM To:

Re: Application.cfc

2006-03-17 Thread Tony
why not just cfinclude your application.cfm in the onRequest method? tw On 3/17/06, Asim Manzur [EMAIL PROTECTED] wrote: Hi, I have a current application running on CFMX7, using Application.cfm for the login and other stuff. What I want to use is on sessionEnd I want to delete some files

SQL Server error 15250

2006-03-17 Thread S . Isaac Dealey
I'm guessing that I'm probably SOL, but I've got a friend who's having a problem with this SQL Server error. I can't reproduce it and I can't find any information about it either in the BOL or the web. Here's what the BOL say: 15250 16 The database name component of the object qualifier must be

RE: SQL Server error 15250

2006-03-17 Thread Jim
shot in the dark: The user used in the datasource setup has a default database defined which is not the one defined in the datasource? -Original Message- From: S.Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: 17 March 2006 17:50 To: CF-Talk Subject: SQL Server error 15250 I'm guessing

Converting a Query to Stored Procedure

2006-03-17 Thread Ali Awan
I have a query that I want to convert to a stored procedure. The problem I am having is that the query has lists in it and I don't know how to pass those through in the stored procedure. My query looks like this: [cfquery name=getOver4 datasource=mydsn] SELECT DealerID,

threerelatedselects - do you can help?

2006-03-17 Thread Michel Deloux
I was wondering if anyone had a fixed version of the custom tag, ThreeSelectsRelated. The copy that I have doesn't work properly with the default values when using with edit mode forms. Only the value of default1 work. I've been banging my head and pulling my hair out trying to get it to work,

Re: SQL Server error 15250

2006-03-17 Thread Ken Ferguson
http://www.mcse.ms/archive94-2005-5-1594364.html What's he trying to do when he get's the error? --Ferg S. Isaac Dealey wrote: I'm guessing that I'm probably SOL, but I've got a friend who's having a problem with this SQL Server error. I can't reproduce it and I can't find any information

RE: Faster FTP and DW8 Synch for Windoze Servers

2006-03-17 Thread Dennis Powers
We have had very good luck with Gen6 FTP server http://www.g6ftpserver.com/ we use it to deliver files from a gaming hobby website (www.halomaps.org) and have saturated an OC3 with it on a W2K Celeron box. One of the nice features is that you can script events ondownload, onupload...etc Best

Re: Converting a Query to Stored Procedure

2006-03-17 Thread Qasim Rasheed
this might help you Ali http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm Qasim On 3/17/06, Ali Awan [EMAIL PROTECTED] wrote: I have a query that I want to convert to a stored procedure. The problem I am having is that the query has lists in it and I don't know how to pass

Re: Converting a Query to Stored Procedure

2006-03-17 Thread Ali Awan
this might help you Ali http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm Qasim On 3/17/06, Ali Awan [EMAIL PROTECTED] wrote: Thanks Qasim, that almost helps, but my ID's are 6 character varchars. So what I'm passing, is all delimited by single quotes. My first problem is

RE: Dynamic Form Selects and Posting Troubles

2006-03-17 Thread PINE Phyo Z
Hi Mark, Sorry for replying late. I just got a chance to go over the CF-Talk posts. I don't know whether I understand your problem right or not. But probably using Arrays (or Structs) might solve your problem? I would do something like this when calling CFC: cfset userValue = ArrayNew(2) cfset

RE: threerelatedselects - do you can help?

2006-03-17 Thread Munson, Jacob
I've got a copy I'll send you offline. I'm not sure if it's the same one you've got or not. I will say, however, that these days I'm using AJAX for these kinds of things, it seems to be a lot easier (to me anyway). -Original Message- From: Michel Deloux [mailto:[EMAIL PROTECTED]

Re: threerelatedselects - do you can help?

2006-03-17 Thread Robert Everland III
I started looking into this tag and found it much easier to use AJAX. You may want to look into that. Either cfajax or ajaxcfc. Bob ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235652 Archives:

Re: Application.cfc

2006-03-17 Thread S . Isaac Dealey
Because the onRequest method doesn't correspond to the Application.cfm behavior -- it corresponds to the execution of the base template... However, in some cases you can simply inlcude the Application.cfm in the onRequestStart method. If you set any local varaibles (not in request or other shared

Re: Converting a Query to Stored Procedure

2006-03-17 Thread Robert Everland III
There are a few ways you can do this. Either do a subquery so you don't have to pass a list, mark up the list with single quotes already in your list or use cfqueryparam and use the option to say it's a list and it will mark up your data to pass in correctly. Bob

RE: CF Server not working after months of flawless service

2006-03-17 Thread Dave Watts
My dev installation of CFM7 has worked flawlessly day in day out for months adn months - since I first installed it on this machine. Not it's not working and I'm trying to pin down what has changed to break it .. I'm hoping someone here can help me isolate the cause In the last

RE: Large count query caching

2006-03-17 Thread Mark A Kruger
Mingo, The actually counting is unlikely to be affected, but you are forcing the planner to look up the column names in the sys tables for no good reason - and that initial task while neglible is superflous. -mark -Original Message- From: Mingo Hagen [mailto:[EMAIL PROTECTED] Sent:

Re: Deployment licencing cost

2006-03-17 Thread S . Isaac Dealey
Mark Drew wrote: Both of the machines will be production. So the answer is that yes.. even the machines that we are deploying to will need a licence. Pants :) thanks! MD Yes, I suspect they'll also need pants. :P s. isaac dealey 434.293.6201 new epoch : isn't it time for a

RE: threerelatedselects - do you can help?

2006-03-17 Thread Andy Matthews
It's definitely less data transfer. I had a 3relatedselects box which loaded in something like 1900 rows of data. Ridiculous. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From:

Re: Converting a Query to Stored Procedure

2006-03-17 Thread Patti Lee
I got this SQL UDF off of the list a long time ago. I believe it will do what you need. SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS OFF GO /** Object: User Defined Function dbo.fnc_ParseDelimited Script Date: 1/12/2005 3:18:53 PM **/ CREATE FUNCTION dbo.fnc_ParseDelimited (

OT: dynamic urls from CFObjective

2006-03-17 Thread Michael Dinowitz
I was talking to someone at CF.Objective about an idea I had for displaying dynamic pages as if they were static. He had tried some stuff out and didn't get it (yet). If your here, email me off list. I've got it. Look at these 3 urls:

Sort Array to Categroies SubCategores Listing 4 Items if 3 Or 5 found!

2006-03-17 Thread Aldon Moore
Frustrated! Problem: I have an array that stores items for multiple categories and subcategories. ITEMS IN THIS MAIN CATEGORY: Eg: Category X * Sub Category : A,B,C,D Eg: Category Y * Sub Category : E,F,G,H, __ ITEMS IN NEXT MAIN CATEGORY: Eg: Category

Re: Large count query caching

2006-03-17 Thread Jochem van Dieten
Wolfe, Aaron wrote: You should use a field name in the count instead of the *. It should speed it up. SELECT COUNT( fieldname ) FROM myTable With the * it has to return all records and all fields. COUNT(fieldname) has a different meaning then COUNT(*). Jochem

Re: Converting a Query to Stored Procedure

2006-03-17 Thread Qasim Rasheed
Ali, There were several examples on this article to use delimited list with SQL Server stored procedure. From coldfusion side, I beleive you have to use preservesinglequotes function. HTH Qasim On 3/17/06, Ali Awan [EMAIL PROTECTED] wrote: this might help you Ali

Re: Large count query caching

2006-03-17 Thread Jochem van Dieten
Aaron Rouse wrote: What is a bitmap index? The short explanation: Most types of database index contain the value of the indexed field plus a pointer to the rest of the row. So if you are indexing a bigint, that is 8 bytes for the value, another 8 bytes for the pointer and some room for

Mail Spool stopped sending

2006-03-17 Thread Scott Mulholland
An application of ours just stopped sending mail today. We do not manage the server. The server was moved behind a firewall this morning and mail had been sent after that without issue. It uses the local smtp setting to send and the connection verifies through the cfadmin. The mail.log

Re: Converting a Query to Stored Procedure

2006-03-17 Thread Ali Awan
Thanks to everyone who posted suggestions. Qasim, the article showed several examples using an integer list. I am looking for an example using a character list. I ended up searching some SQL sites and came up with something on my own. Using preservesinglequotes in ColdFusion, did not help, it

Printing HTML then CFR

2006-03-17 Thread Claremont, Timothy
I have two reports that end users need to print out quite frequently. One of the reports is an HTML page that is optimized for printing, and the other is a CFR page that generates a PDF. So, the end user visits a web page, and presses the print button that I have embedded in the page. Works

RE: Printing HTML then CFR

2006-03-17 Thread Andy Matthews
Using javascript, yes. Hang on...if they're on two totally seperate pages then no. !//-- andy matthews web developer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Claremont, Timothy [mailto:[EMAIL PROTECTED]

RE: SQL Server error 15250

2006-03-17 Thread S . Isaac Dealey
shot in the dark: The user used in the datasource setup has a default database defined which is not the one defined in the datasource? Thanks Jim... Tried testing this theory in query analyzer without any success... I'm able to produce errors while attempting to create or drop tables in an

Re: SQL Server error 15250

2006-03-17 Thread S . Isaac Dealey
http://www.mcse.ms/archive94-2005-5-1594364.html What's he trying to do when he get's the error? --Ferg Thanks Ken, oddly enough I hadn't found that article... I wasn't able to get anything useful from it unfortunately... You know, I should probably know what he's doing, but I honestly am

Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Michael E. Carluen
Is there any potential problems by using the pipe | character as a delimiter for storing lists values in either mySQL or SQLServer? I just want to make sure before I run into any unforeseen compatibility issues caused by this in the future. Thanks.

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Charlie Griefer
ermm...the question will arise as to why you're storing delimited lists in a relational database :) But if you must...there shouldn't be any issues that I can think of. A string is a string and AFAIK, there's nothing special about the pipe character. On 3/17/06, Michael E. Carluen [EMAIL

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
Yeap, I'd highly recommend against an approach like this. People at my work do this a lot and then struggle with how to search on it since you can not write a simple query to find all lists that contain foo I am sure there are many other reasons not to, that is just the first one that comes to

RE: Weird error

2006-03-17 Thread Mosh Teitelbaum
Late to the party so I don't know if this was already resolved... I've seen this error before as well and I've been able to figure out the problem but haven't had time to figure out which browser(s) is/are the culprit(s). Apparently, some clients tend to URLEncode a URL (or the query string

RE: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Michael E. Carluen
Aaron, Charlie, Besides the pipe on list, I've actually been debating whether to use this approach even for the simplest requirement. Yep, I'll just throw it on a table, what the heck! Many thanks, guys. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Friday, March

Re: Sort Array to Categroies SubCategores Listing 4 Items if 3 Or 5 found!

2006-03-17 Thread Michael Traher
Hi Aldon, I'd like to help but I'm a bit confused on a few points. Can you post what your query looks like and also show an example of the output, but with some real values in - so I can understand if the Powder, Shadow, Foundation is a main cetegory, or a sub catgory or an item or what. -- Mike

RE: dynamic urls from CFObjective

2006-03-17 Thread Russ
Isn't this just simple apache URL rewriting? -Original Message- From: Michael Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 3:29 PM To: CF-Talk Subject: OT: dynamic urls from CFObjective I was talking to someone at CF.Objective about an idea I had for displaying

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Rick Root
For what it's worth, there are seome cases where I use a varchar to store a CSV list of flags. I do this sometimes when I have no need to query on specific values. For example, in my CMS, I store permissions to specific modules in such a field, which allows me to add modules without having to

Re: Weird error

2006-03-17 Thread Claude Schneegans
It's usually hard to diagnose this error because the error logs are usually viewed as HTML and any escaped characters (like the amp; in the above, misinterpreted URL) are displayed unescaped. Ah ah, that at least a good lead indeed. The last error of that type has gone out of the database, but

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Claude Schneegans
For example, in my CMS, I store permissions to specific modules in such a field, Exactly! I do the same. No need to query the database to check for a permission. Just put le list in a session variable at login and for every module, check if the permission code for the module is the the user's

RE: Weird error

2006-03-17 Thread Munson, Jacob
I will also check for the type of browser. By the way, it must be some pretty cheap browsr to do so ;-/ I'll bet it's Internet Exploder. ;) [INFO] -- Access Manager: This transmission may contain information that is privileged, confidential and/or exempt from disclosure

RE: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Michael E. Carluen
I use a similar method in a large multipage form that may mutate from time to time over the years. There are 40-50 fields, some of which are multi-select lists, radio buttons, checkboxes. Thanks, Rick. This is actually the reason why I considered using a list in the db to begin with. As my

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Claude Schneegans
the question will arise as to why you're storing delimited lists in a relational database I think we've been through this discussion quite a few times. In theory, I mean PURE theory, you're absolutely right. However, a relational database is not for storing exclusively relational data. In some

RE: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Munson, Jacob
For what it's worth, there are seome cases where I use a varchar to store a CSV list of flags. I do this sometimes when I have no need to query on specific values. For example, in my CMS, I store permissions to specific modules in such a field, which allows me to add modules without

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
For updating them it seems like a simple merge query would work fine enough, update if exists or it inserts if not. I have a series of custom functions I use in the database that help me deal with the need to do things like return a list of user permissions from a cross table. So in this case my

RE: Using Pipe character | as a list delimeter in varchar field s

2006-03-17 Thread Dave Watts
I think we've been through this discussion quite a few times. In theory, I mean PURE theory, you're absolutely right. However, a relational database is not for storing exclusively relational data. In some accasions, one needs a list of a small number of items, with no relation to anything

RE: Large count query caching

2006-03-17 Thread Mark A Kruger
Jochem, Can I just say that I sometimes stand in awe of you :) Mark A. Kruger, CFG, MCSE www.cfwebtools.com www.necfug.com http://mkruger.cfwebtools.com -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 2:49 PM To: CF-Talk Subject: Re:

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Rick Root
Aaron Rouse wrote: For updating them it seems like a simple merge query would work fine enough, update if exists or it inserts if not. I have a series of custom functions I use in the database that help me deal with the need to do things like return a list of user permissions from a cross

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Rick Root
Munson, Jacob wrote: This is the kind of thing I will create a separate table for. For example, using your example, you would have a permissions table. All it would have is the userid, a permission id, and the permission description. Then you just query that table using the userid and get

RE: Using Pipe character | as a list delimeter in varchar field s

2006-03-17 Thread Dave Watts
That sounds a lot more complicated than what I do. Extra queries, extra joins and *MORE DATA STORAGE* Let's say, for example, your user ID is a UUID... 35 characters. Plus your permission ID, which we'll say is a tinyint (limiting you to 255 different permission ids) and that each

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
I have an SP that I use for dealing with inserts of lists. It essentially would do something like this: INSERT INTO LKP_CATS (PID, CATID) SELECT #PID# PID, CATID FROM CATEGORIES WHERE CATID IN (#MyCatList#) On 3/17/06, Rick Root [EMAIL PROTECTED] wrote: Aaron Rouse wrote: For updating

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Claude Schneegans
So in this case my function returns a comma seperated list of permissions, would be the same as doing a ValueList() in CF on the query results though. Then, if your code is using a list anyway, what's the big deal not storing the list directly in the user's record? --

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Claude Schneegans
INSERT INTO LKP_CATS And how do you remove permissions that were there before and no more in MyCatList? -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
Because I can search on a specific value in the list. An example might be if I had a Property record and related to it are zero to many product segments. If I want to find all properties that have ABC product segment and I stored my product segments as a comma seperated list in my table then I

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
Unfortunately I do not have access to the code to look at right now. I know it actually does a MERGE and not the query I typed up earlier. My guess is I actually just wipe out what is in there and then repopulate, that is something I wrote and used well over a year ago so I honestly do not

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Claude Schneegans
If I want to find all properties that have ABC product segment and I stored my product segments as a comma seperated list in my table then I would have a decently hard time looking for this. Then, if you really need this, then its probabilly better to use a cross table. We were just talking

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
I can think of times needing to know all users who have permissions to do XYZ. Such as wanting to see all users who have full rights to modify that properties table. I used Properties and Product Segments because that is what the page I have opened right now is doing. I can also think of times

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Claude Schneegans
My guess is I actually just wipe out what is in there and then repopulate This is also my guess, I never heard of a MERGE query in SQL. I have an 800 page book on SQL and the word MERGE is not even in the index. This apprach is deadly for Access database for instance, because it creates empty

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
Google 'oracle merge' Here is one result, I just glanced at it but I think it gives the idea. http://www.dba-oracle.com/oracle_tips_rittman_merge.htm Sorry, but I have not had to work with Access with CFM for years now and this whole time have been referring to Oracle and probably should have

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Claude Schneegans
Such as wanting to see all users who have full rights to modify that properties table. Again, if you DO need this, then go by the book. My point is that you don't always need this, and if you don't need it, do not bother with cross table. So it is not true that it is always better with cross

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
Yes and as I tried to point out in my other email. My experience is that a lot of the developers at work have no idea on how to deal with cross tables or even what one is. They end up defaulting to doing this list in a database column and then reverting to CFM to make a search possible. I end up

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Charlie Griefer
On 3/17/06, Claude Schneegans [EMAIL PROTECTED] wrote: Such as wanting to see all users who have full rights to modify that properties table. Again, if you DO need this, then go by the book. My point is that you don't always need this, and if you don't need it, do not bother with cross

Re: Using Pipe character | as a list delimeter in varchar fields

2006-03-17 Thread Aaron Rouse
I agree completely, it is late and I probably am just doing a bad job of making a similar point. On 3/17/06, Charlie Griefer [EMAIL PROTECTED] wrote: On 3/17/06, Claude Schneegans [EMAIL PROTECTED] wrote: Such as wanting to see all users who have full rights to modify that properties

RE: Soap and namespaces A bit deeper

2006-03-17 Thread Andrew Stevens
I'm not sure what you want to achieve, you want to get some data out of the soap header, right? Can you post the code showing when you substitute the first argument to whatever? I think you could get the soap header by accessing the ws object in your example as xml or struct too. Does this

Re: usability skills

2006-03-17 Thread Judith Dinowitz
I'm happy for you, Bobby. But what does that have to do with usabilitiy skills? (curious) Judith - Original Message - I slept at a Holiday Inn Express last night ~| Message:

RE: Strange Job Description

2006-03-17 Thread Steve Blades
I saw this type of ad a lot when I was last on the hunt. With slimmer budgets companies continue to do more with less, and expect the same out of their employees (for less, no less). I feel like I truly fell into a unique position here, where we have a DBA who writes and inspects every query

Re: Strange Job Description

2006-03-17 Thread James Holmes
I was thinking that they just somehow got hold of and used my position description without asking ;-) I don't do DBA work, but I do just about everything else on that list: Oracle Dev (incl DB design, PL/SQL etc), CF back end, JS/HTML front end, graphic design (Fireworks, Flash), managing

RE: usability skills

2006-03-17 Thread Bobby Hartsfield
'bout as much as psych ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Judith Dinowitz [mailto:[EMAIL PROTECTED] Sent: Friday, March 17, 2006 6:11 AM To: CF-Jobs-Talk Subject: Re: usability skills I'm happy for you, Bobby. But what does

Re: usability skills

2006-03-17 Thread Larry C. Lyons
my sympathies. I recommend a good chiropractor and a few shots of Talikser Scotch. That you help your pain. On 3/16/06, Bobby Hartsfield [EMAIL PROTECTED] wrote: I slept at a Holiday Inn Express last night ..:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com

Re: usability skills

2006-03-17 Thread Bryan Stevenson
I'm happy for you, Bobby. But what does that have to do with usabilitiy skills? (curious) Judith - Original Message - I slept at a Holiday Inn Express last night Judith you must not watch much TVit eludes to a Holiday Inn commercial where people aren't what they appaear to

RE: usability skills

2006-03-17 Thread Bobby Hartsfield
My 8 year old brother is just as qualified as any psyche major at informing someone of what should be changed in an application to make it more 'user friendly'. Saying cognitive psychology has a lot to do with usability is like saying breathing is necessary to live. I don't know anyone who went

  1   2   >