Re: OT: A Good Data Structure for a Large Binary Tree
(excuse my super long email, but you might like this) I've been fascinated with binary trees for years. So much so that I've designed my own. I have used three different methods of binary trees. I'm sure there are other techniques, but I haven't tried them. Here are the advantages and disadvantages of the three methods that I know of. Method #1: Parent/Child Tree - ID ParentID NodeData This is the most commonly known, used and understood tree. It requires 3 fields: ID, ParentID and NodeData. The ID and ParentID are joined together to create the tree. The root node will have a predefined value for the ParentID. Usually it's just left NULL. To obtain the children you just look for records where parentID=#ID#, one at a time. uggh. Advantages: -Inserts and updates are very fast. They do not require any restructuring of parent/child data -Pretty simple to understand -multiple parents can be easily defined by breaking it into two tables. This is the only real advantage to this method. Disadvantages: -Linear math, requires recursion -Selects and Deletes are recursive. This becomes slower the larger the set of data is -Calculating the current level of a node is recursive. This becomes slower the larger the set of data is My advice on method #1. In most applications, selecting data is done far more than inserts and updates, so I wouldn't recommend using this method. While this is a good technique to understand, I would recommend learning the two below. Method #2: Nested Set Model - ID startRowendRow NodeData This type of tree is gaining popularity, but it is rather difficult to understand. I think it was invented by Joe Celko, but I might be wrong. It requires 4 fields: ID, startRow, endRow and NodeData. The ID and the NodeData should be obvious, the startRow and endRow confuse most people. Think of it like XML. XML has an open tag and a close tag. Everything between those tags are children. Same thing. Advantages: -Based on set mathematics. You remember those Venn diagrams from high school? That's set math. DBMSs are designed around set Math -Selects are lightning fast and pretty simple. They do not require any recursion. If you want to define a tree of children, you do this: "select ID where startRow < #startrow# and endRow > #endrow# -deletes are much faster than Parent/child trees -Calculating the current level of a node is fairly easy, but it requires a subquery. uggh Disadvantages: -it is much more difficult to understand than the parent/child model -inserts, updates and deletes are more difficult to understand because it requires rebuilding a portion of the tree. -inserts, updates are a little slower than parent/child trees, because all child data has to be reset. Of course, DBMSs are designed to deal with large sets, so a good database can do this with no sweat. -Some DBMSs can't handle sub queries, so calculating current level may not be possible depending on the DBMS. -Because calculating the current level uses sub-queries, it seems to me that it is recursive. -as far as i know you can't have multiple parents with this method My advice on method #2. This method is not for the faint of heart, but worth the effort. Selecting data is super fast with this method (same as method 3, below). I would highly recommend learning it. Buy a copy of "SQL for Smarties". He explains the theories and practice. If your project requires multi-parent trees, you might need to go back to method #1 Method #3: Steve's spinoff of the nested set Model (I'd love help with a correct name for this) - ID indent order NodeData As far as I know, I invented this. But if i'm a lunatic, someone correct me. This model is another implementation of a set math tree inspired by Joe Celko's model. I was helping one of my clients build a tree and was having difficulty remembering how to use the nested set model. Afraid of losing face, I invented this new method and never looked back. It turns out this is my favorite of the three. It's a little strange, but it's really fast (defining current levels is faster than method 2) Advantages: -Based on set mathematics just like the nested set model. Instead of using startRow and endRow to find the boundaries, it uses indent and order. -Selects are lightning fast (same relative speed as method 2). They do not require any recursion. If you want all children you do this: "select ID where order > #currentOrder# and indent < #currentIndent# -deletes are much faster than Parent/child trees, same speed as method 2 -Calculating the current level of a node is super easy because there is no calculating! Just select the "indent" field. MUCH faster than method 1 and 2 -doesn't require sub-Queries. yeah! Disadvantages: -it is more difficult to understand than the parent/child model -inserts,
Re: Need help with Graphs
first, try rebooting the server...then try deleting the cfclasses. --- Exciteworks -- expert hosting for less! http://exciteworks.com specializing in reseller accounts chad wrote: > I have a site that generates a couple of graphs (CFMX Server), the > graphs get created correctly and are stored in the cache. The problem > is they take forever to load on my page and in some cases never load > and the status bar keeps saying (Opening page.). I am generating > the graphs as a flash file. But seem to have the same problem > generating them as jpgs. I know the graphs are working correctly > because I can see the correct graph when viewing them directly from > the cache folder. > > Any suggestions. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: A Good Data Structure for a Large Binary Tree
Hi Joe... mmm... 1000 levels deep I would guess that is an exceptional situation. What is a typical level? When I am faced with an "unsolvable" design problem, it often helps me to examine some real data and see if any patterns reveal themselves. If this is the case, than you can design/tune performance for the "norm". This is the same reasoning for sometimes making an overt decision to denormalize a database. A good example of this (which might apply to your problem) is to store redundant data at a higher level of the tree or data structure to reduce traversals. Consider the classic db storing customer orders: CustomerData | | OrderData | |--- LineItem 1 | |--- LineItem 2 | | |--- LineItem n In frequent processing, you want to drill-down search/display the database - showing all the orders by customer: Customer AAA Order # 123 02/10/04 $112,345.67 * * * * * Order # 754 02/26/04 $200.34 The user would select a particular order to display the line items (and other detail) Now, in a truly normalized db you would need to traverse each order record and *all* of its LineItem children so that you could compute the order "total". But, if you denormalize the database you can store the sum of lineItem amounts of all the children in the OrderData record (when the order is entered). This is a small trade0ff of db space (and sacrifice of "pure" normalization) -- but it pays for itself many times over in "normal" processing of the DB. You may find that a practical approach to the problem presents an unorthodox but elegant solution. HTH Dick On Mar 1, 2004, at 5:39 PM, Joe Eugene wrote: > >Lots of data? why not xml? > > Xml parsing for large NESTED Data Structures are too slow. I probably > will > have > around 150,000 Unique ID's in the Tree data Structure which can go > deep as > 1000 Levels. I am looking to avoid sequencial/Recursive search. > Joe Eugene > >-Original Message- >From: Rob [mailto:[EMAIL PROTECTED] >Sent: Monday, March 01, 2004 8:24 PM >To: CF-Talk >Subject: Re: OT: A Good Data Structure for a Large Binary Tree > >Lots of data? why not xml? > >On Mon, 2004-03-01 at 17:11, Joe Eugene wrote: >> I am trying to solve a Binary Tree data structure problem, i > think this >> can be done from a DataBase Perspective with relations but then > that >> might involve doing something like a matrix to develop the > relations >> between nodes. >> >> The other thought i have is solve the problem by using some > native(Java/C++) >> data Structure (Binary Tree /TreeMap) and store keys of the > database >> structure >> as keys of the Binary Tree... that might relate to a simple > select. >> >> Any ideas are much appreciated. >> >> Thanks, >> Joe Eugene >> >> >> > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Three Questions
Anyone put 2003 in a 2000 domain? Can you deploy CFMX and .Net on the same server and can this server be a member server? Thanks L Marcus [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT: A Good Data Structure for a Large Binary Tree
>Lots of data? why not xml? Xml parsing for large NESTED Data Structures are too slow. I probably will have around 150,000 Unique ID's in the Tree data Structure which can go deep as 1000 Levels. I am looking to avoid sequencial/Recursive search. Joe Eugene -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 8:24 PM To: CF-Talk Subject: Re: OT: A Good Data Structure for a Large Binary Tree Lots of data? why not xml? On Mon, 2004-03-01 at 17:11, Joe Eugene wrote: > I am trying to solve a Binary Tree data structure problem, i think this > can be done from a DataBase Perspective with relations but then that > might involve doing something like a matrix to develop the relations > between nodes. > > The other thought i have is solve the problem by using some native(Java/C++) > data Structure (Binary Tree /TreeMap) and store keys of the database > structure > as keys of the Binary Tree... that might relate to a simple select. > > Any ideas are much appreciated. > > Thanks, > Joe Eugene > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: A Good Data Structure for a Large Binary Tree
Lots of data? why not xml? On Mon, 2004-03-01 at 17:11, Joe Eugene wrote: > I am trying to solve a Binary Tree data structure problem, i think this > can be done from a DataBase Perspective with relations but then that > might involve doing something like a matrix to develop the relations > between nodes. > > The other thought i have is solve the problem by using some native(Java/C++) > data Structure (Binary Tree /TreeMap) and store keys of the database > structure > as keys of the Binary Tree... that might relate to a simple select. > > Any ideas are much appreciated. > > Thanks, > Joe Eugene > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: A Good Data Structure for a Large Binary Tree
I am trying to solve a Binary Tree data structure problem, i think this can be done from a DataBase Perspective with relations but then that might involve doing something like a matrix to develop the relations between nodes. The other thought i have is solve the problem by using some native(Java/C++) data Structure (Binary Tree /TreeMap) and store keys of the database structure as keys of the Binary Tree... that might relate to a simple select. Any ideas are much appreciated. Thanks, Joe Eugene [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
> Did you figure out what datatype it is having problems with? i.e. only > > selecting one field at a time. Can it get just an int ok? > > All of the datatypes seem to match up just fine. I've gone out of my > way to make them all match. If I remove the refcursor from the > procedure call, then it gives an error telling me that the procresult is > not defined. I mean you are selecting varchar2 and char in your refcursor have you just tried one or the other to see if it has a problem with just one of those datatypes - it's probably a conversion between what the drive says is a query and what cf thinks is a query, but I was hoping the Unsupported data conversion was refering to one of the column types. -- Rob <[EMAIL PROTECTED]> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Rob wrote: > Did you figure out what datatype it is having problems with? i.e. only > selecting one field at a time. Can it get just an int ok? All of the datatypes seem to match up just fine. I've gone out of my way to make them all match. If I remove the refcursor from the procedure call, then it gives an error telling me that the procresult is not defined. > > On Mon, 2004-03-01 at 16:38, Richard Crawford wrote: > >>Still having issues. >> >>Here is the Stored Procedure in question: >>== >>CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( >> studentID IN number, >> studentInfo OUT types.cursorType >>) >> >>as >> >>sFirst varchar2(50); >>sLast varchar2(50); >>sOrient char(1); >> >>begin >> >>open studentInfo for >> select >> sFirst, >> sLast, >> sOrient >> from >> tblStudentInfo >> where >> sid = studentID; >> >>fetch studentInfo into sFirst, sLast, sOrient; >> >>close studentInfo; >> >>end; >>/ >>== >> >> >>And here is where it is called in my Cold Fusion page: >>== >> >> >> >> >>== >> >> >>In the database, the table tblStudentInfo is set up as this: >>== >>sID number >>sFirst varchar2(50) >>sLast varchar2(50) >>sOrient char(1) >>== >> >> >>When I execute the stored procedure by going to the CF page in a >>browser, I get the following error: >>== >> Error Executing Database Query. >>[Macromedia][Oracle JDBC Driver]Unsupported data conversion. >>== >> >> >>I'm still at a loss, and I can't see what else I can do. Anyone got any >>suggestions? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Oracle and Cold Fusion
Did you figure out what datatype it is having problems with? i.e. only selecting one field at a time. Can it get just an int ok? On Mon, 2004-03-01 at 16:38, Richard Crawford wrote: > Still having issues. > > Here is the Stored Procedure in question: > == > CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( > studentID IN number, > studentInfo OUT types.cursorType > ) > > as > > sFirst varchar2(50); > sLast varchar2(50); > sOrient char(1); > > begin > > open studentInfo for > select > sFirst, > sLast, > sOrient > from > tblStudentInfo > where > sid = studentID; > > fetch studentInfo into sFirst, sLast, sOrient; > > close studentInfo; > > end; > / > == > > > And here is where it is called in my Cold Fusion page: > == > > > > > == > > > In the database, the table tblStudentInfo is set up as this: > == > sID number > sFirst varchar2(50) > sLast varchar2(50) > sOrient char(1) > == > > > When I execute the stored procedure by going to the CF page in a > browser, I get the following error: > == > Error Executing Database Query. > [Macromedia][Oracle JDBC Driver]Unsupported data conversion. > == > > > I'm still at a loss, and I can't see what else I can do. Anyone got any > suggestions? -- Rob <[EMAIL PROTECTED]> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ANNOUNCE: CFUN-04 - new track on Accessiblity
We have added an accessiblity track to CFUN-04. Topics include: * How disabled people use the web - Larry Hull * CSS for Better Sites - Sandra Clark * HTML Markup for Accessibility You Never Knew About - David Epler * Creating Accessible Web Forms - Sandra Clark For details see http://www.cfconf.org/cfun-04/Topics.cfm CFUN-04 has FIVE tracks with 42 sessions for every level. * Bootcamp - Basic ColdFusion and Flash topics * Advanced - Advanced ColdFusion topics * Empowered - Fusebox and Project management topics * Accessibility - making sites that disabled people can use, section 508 * Integration - Flash, Flex and other technologies integrated with CF topics The early bird price of $199 for CFUN-04 ends 3/31/03 Don't miss out on the programming conference of 2004! http://www.cfconf.org/cfun-04/ Here are what some CFUN-03 attendess had to say: "The CFUN series of conferences are by far the best Cold Fusion conference of the year. Each year, Michael puts together the most advanced and sophisticated set of Cold Fusion topics and speakers to be found--anywhere--for any price. No where else do you get to network with the real CF guru's and peers alike in a fun, friendly, casual atmosphere. The timing of the meeting couldn't be better, either. The early summer dates for CFUN provide an excellent opposite end of the year opportunity to see what's going on with Cold Fusion and the Macromedia world. Year after year, the meeting provides a first look opportunity with CF server and Fusebox product releases. Best courses, best learning, best timing, best networking, best price--best meeting. Period." -Jeremy R. "I would like to thank Michael Smith for the invitation. It was a great conference, with great speakers, sessions, and even a great party Saturday night. If you missed it this year, I recommend planning on attending next time." -Christian Cantrell (Macromedia Server Community Manager) -- -- Vote for TeraTech in CFDJ awards http://www.teratech.com/vote.cfm Michael Smith, TeraTech, Inc 405 E Gude Dr Ste 207, Rockville MD 20850 CF , VB, SQL, Math custom programming Voice: +1-301-424-3903 x110, 800-447-9120 Fax:301-762-8185 Web: http://www.teratech.com/sig/ Email: mailto:[EMAIL PROTECTED] ICQ: 66057682 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Oracle and Cold Fusion
Still having issues. Here is the Stored Procedure in question: == CREATE OR REPLACE procedure dlc_sp_getStudentInfo ( studentID IN number, studentInfo OUT types.cursorType ) as sFirst varchar2(50); sLast varchar2(50); sOrient char(1); begin open studentInfo for select sFirst, sLast, sOrient from tblStudentInfo where sid = studentID; fetch studentInfo into sFirst, sLast, sOrient; close studentInfo; end; / == And here is where it is called in my Cold Fusion page: == == In the database, the table tblStudentInfo is set up as this: == sID number sFirst varchar2(50) sLast varchar2(50) sOrient char(1) == When I execute the stored procedure by going to the CF page in a browser, I get the following error: == Error Executing Database Query. [Macromedia][Oracle JDBC Driver]Unsupported data conversion. == I'm still at a loss, and I can't see what else I can do. Anyone got any suggestions? -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
i ddi that a long time ago. We are cleaning out the whole hard drive this time :D - Original Message - From: Rob To: CF-Talk Sent: Monday, March 01, 2004 5:42 PM Subject: Re: OT: migrating to SQL Server 2000 On Mon, 2004-03-01 at 14:57, brobborb wrote: > ok i just found out from the network admin that the drive the SQL Server is on is a partitioned. (C and D) it's isntalled in the C partition. could this be a problem? hehe Not unless the database files are on C too and there isn't much disk space - but I think that would be a different error ;-) I am at a loss - unless you can find the difference between the one that works well (your other 2k install) and this one... Reinstall then reboot :) > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 4:55 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > On Mon, 2004-03-01 at 14:52, Rob wrote: > > What kind of commit are you using by > That should be transaction level sorry - > > > > > "Try rebooting" > > -- MCSE > > > > On Mon, 2004-03-01 at 14:27, brobborb wrote: > > > Query cost is 0.20%, for each insert!!! > > > > > > on the SQL 7 server it's 0.10%. > > > > > > WHY > > > > > > :( > > > - Original Message - > > > From: Rob > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 4:32 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > In query analyser what does the execution path show? > > > > > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > > > - Original Message - > > > > From: [EMAIL PROTECTED] > > > > To: CF-Talk > > > > Sent: Monday, March 01, 2004 4:09 PM > > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > > > (read). > > > > > > > > Does your 2000 server have more RAM than the 7 server? > > > > > > > > -Kore > > > > > > > > > > > > "brobborb" > > > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > > > on.rr.com>cc: > > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > 03/01/2004 > > > > 03:45 PM > > > > Please respond > > > > to cf-talk > > > > > > > > > > > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > > > up in a split second. > > > > > > > > So far i know this (i hope i'm right!) > > > > > > > > It's not a coldfusion compatibility problem > > > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > > > running SQL 7 is 900mhz) > > > > It's not an indexing problem > > > > No problems with SELECT statements. Works fine, works great. > > > > PROBLEMS with INSERT statements > > > > > > > > This is how simple the insert statement is (500 times)INSERT INTO > > > > testy(name) VALUES ("TEST01") > > > > > > > > maybe there's something wrong with that insert thats causing SQL 2000 to >
Re: OT: migrating to SQL Server 2000
On Mon, 2004-03-01 at 14:57, brobborb wrote: > ok i just found out from the network admin that the drive the SQL Server is on is a partitioned. (C and D) it's isntalled in the C partition. could this be a problem? hehe Not unless the database files are on C too and there isn't much disk space - but I think that would be a different error ;-) I am at a loss - unless you can find the difference between the one that works well (your other 2k install) and this one... Reinstall then reboot :) > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 4:55 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > On Mon, 2004-03-01 at 14:52, Rob wrote: > > What kind of commit are you using by > That should be transaction level sorry - > > > > > "Try rebooting" > > -- MCSE > > > > On Mon, 2004-03-01 at 14:27, brobborb wrote: > > > Query cost is 0.20%, for each insert!!! > > > > > > on the SQL 7 server it's 0.10%. > > > > > > WHY > > > > > > :( > > > - Original Message - > > > From: Rob > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 4:32 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > In query analyser what does the execution path show? > > > > > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > > > - Original Message - > > > > From: [EMAIL PROTECTED] > > > > To: CF-Talk > > > > Sent: Monday, March 01, 2004 4:09 PM > > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > > > (read). > > > > > > > > Does your 2000 server have more RAM than the 7 server? > > > > > > > > -Kore > > > > > > > > > > > > "brobborb" > > > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > > > on.rr.com>cc: > > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > 03/01/2004 > > > > 03:45 PM > > > > Please respond > > > > to cf-talk > > > > > > > > > > > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > > > up in a split second. > > > > > > > > So far i know this (i hope i'm right!) > > > > > > > > It's not a coldfusion compatibility problem > > > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > > > running SQL 7 is 900mhz) > > > > It's not an indexing problem > > > > No problems with SELECT statements. Works fine, works great. > > > > PROBLEMS with INSERT statements > > > > > > > > This is how simple the insert statement is (500 times)INSERT INTO > > > > testy(name) VALUES ("TEST01") > > > > > > > > maybe there's something wrong with that insert thats causing SQL 2000 to > > > > act funny :( > > > > > > > > I hate it when I dont know what the problem is! You feel so helpless :( > > > > haha I am sure this is fixable because it has to be maybe we'll have > > > > torequest a different CD! > > > > > > > > - Original Message - > > > > From: Rob > > > > To: CF-Talk > > > > Sent: Monday, March 01, 2004 3:40
Re: Access & Coldfusion MX6.1 problems...sites keep dying
On Mon, 2004-03-01 at 15:14, Will Blackie wrote: > # HotSpot Virtual Machine Error, Internal Error > # Please report this error at > # http://java.sun.com/cgi-bin/bugreport.cgi > # > # Java VM: Java HotSpot(TM) Server VM (1.4.2-b28 mixed mode) Not sure if it will help but there is a newer JVM out 1.4.2_03 (the b28 is a beta version I believe). VM crashes really really suck :( -- Rob <[EMAIL PROTECTED]> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access & Coldfusion MX6.1 problems...sites keep dying
Is it crucial to run with MSAccess? It was never really designed for this use and is more suited to the desktop environment. MSSQL Server would be easy to upgrade to or if on a tight budget MySQL. Peter Tilbrook Transitional Services - Enterprise eSolutions Centrelink (http://www.centrelink.gov.au) 2 Faulding Street Symonston ACT 2609 Tel: (02) 62115927 "Will Blackie" <[EMAIL PROTECTED]To: CF-Talk <[EMAIL PROTECTED]> h.com> cc: Subject: Access & Coldfusion MX6.1 problems...sites keep dying 02/03/2004 10:14 Please respond to cf-talk | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Access & Coldfusion MX6.1 problems...sites keep dying
Thanks for the responses that have been posted with regard to this problem a few of us are experiencing. Just to recap for anyone new looking at this post that might be helpful I have a windows 200 server running CFMX 6.1 that keeps crashing - the sites running an access database are unable to get a connection to their db's ("Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is:") other sites running SQL Server continue on fine, we even have a site or 2 built in ASP that use access databases and they continue to work perfectly. The only way to rescue the server seems to be a full restart. I've tried changing over a few of my sites to use the access unicode driver but i suspect that without changing them all i may not see any dramatic improvement - the server is still crashing pretty regularly. We ran the server via the command prompt so that the output to be piped to a text file for analysis, the following is the message it gives right before the server needs to be restarted. # # HotSpot Virtual Machine Error, Internal Error # Please report this error at # http://java.sun.com/cgi-bin/bugreport.cgi # # Java VM: Java HotSpot(TM) Server VM (1.4.2-b28 mixed mode) # # Error ID: 53414645504F494E540E4350500159 # # Problematic Thread: prio=5 tid=0x3841e410 nid=0xfdc runnable # Heap at VM Abort: Heap PSYoungGen total 43264K, used 28288K [0x1001, 0x138f, 0x138f) eden space 28288K, 100% used [0x1001,0x11bb,0x11bb) from space 14976K, 0% used [0x12a5,0x12a5,0x138f) to space 14976K, 0% used [0x11bb,0x11bb,0x12a5) PSOldGen total 466048K, used 466048K [0x138f, 0x3001, 0x3001) object space 466048K, 100% used [0x138f,0x3001,0x3001) PSPermGen total 30720K, used 30600K [0x3001, 0x31e1, 0x3801) object space 30720K, 99% used [0x3001,0x31df2150,0x31e1) We've reported it as instructed but I was hoping that someone might be able to shed some light on this from a Coldfusion perspective rather than just the JVM. Thanks again, Will [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
no network involved at all i am running the queries striaght from the local comp. the disk is good, the ram is good, 1 GB! hehe - Original Message - From: Rob To: CF-Talk Sent: Monday, March 01, 2004 5:07 PM Subject: Re: OT: migrating to SQL Server 2000 Are you running enterprise manager from the local computer (server) or connecting over the network? could it be sending the information to you really slowly? Also if you are going over the network and are using that named-pipes stuff I have had crazy problems with that before and had the issuses clear up by switching to a *gasp* tcp/ip connectoin :-) Otherwise I'd look at the disk or maybe even the RAM - you can specify how much resources SQL server uses could that be it? On Mon, 2004-03-01 at 14:50, brobborb wrote: > IO cost is like .0101 > > > UPDATE.we installed a copy on a different server, and it works fine! So now we know the problem can't be with the database. It must be with the computer. But we dont know what it could be it's the fastest in here! > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 4:52 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > When you hover over the icon does it give you any more info that is > helpful (IO time or something)? What kind of commit are you using by > default - bad / lame disk maybe? > > "Try rebooting" > -- MCSE > > On Mon, 2004-03-01 at 14:27, brobborb wrote: > > Query cost is 0.20%, for each insert!!! > > > > on the SQL 7 server it's 0.10%. > > > > WHY > > > > :( > > - Original Message - > > From: Rob > > To: CF-Talk > > Sent: Monday, March 01, 2004 4:32 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > In query analyser what does the execution path show? > > > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 4:09 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > > (read). > > > > > > Does your 2000 server have more RAM than the 7 server? > > > > > > -Kore > > > > > > > > > "brobborb" > > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > > on.rr.com>cc: > > > Subject: Re: OT: migrating to SQL Server 2000 > > > 03/01/2004 > > > 03:45 PM > > > Please respond > > > to cf-talk > > > > > > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > > up in a split second. > > > > > > So far i know this (i hope i'm right!) > > > > > > It's not a coldfusion compatibility problem > > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > > running SQL 7 is 900mhz) > > > It's not an indexing problem > > > No problems with SELECT statements. Works fine, works great. > > > PROBLEMS with INSERT statements > > > > >
Re: OT: migrating to SQL Server 2000
ok i just found out from the network admin that the drive the SQL Server is on is a partitioned. (C and D) it's isntalled in the C partition. could this be a problem? hehe - Original Message - From: Rob To: CF-Talk Sent: Monday, March 01, 2004 4:55 PM Subject: Re: OT: migrating to SQL Server 2000 On Mon, 2004-03-01 at 14:52, Rob wrote: > What kind of commit are you using by That should be transaction level sorry - > > "Try rebooting" > -- MCSE > > On Mon, 2004-03-01 at 14:27, brobborb wrote: > > Query cost is 0.20%, for each insert!!! > > > > on the SQL 7 server it's 0.10%. > > > > WHY > > > > :( > > - Original Message - > > From: Rob > > To: CF-Talk > > Sent: Monday, March 01, 2004 4:32 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > In query analyser what does the execution path show? > > > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 4:09 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > > (read). > > > > > > Does your 2000 server have more RAM than the 7 server? > > > > > > -Kore > > > > > > > > > "brobborb" > > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > > on.rr.com>cc: > > > Subject: Re: OT: migrating to SQL Server 2000 > > > 03/01/2004 > > > 03:45 PM > > > Please respond > > > to cf-talk > > > > > > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > > up in a split second. > > > > > > So far i know this (i hope i'm right!) > > > > > > It's not a coldfusion compatibility problem > > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > > running SQL 7 is 900mhz) > > > It's not an indexing problem > > > No problems with SELECT statements. Works fine, works great. > > > PROBLEMS with INSERT statements > > > > > > This is how simple the insert statement is (500 times)INSERT INTO > > > testy(name) VALUES ("TEST01") > > > > > > maybe there's something wrong with that insert thats causing SQL 2000 to > > > act funny :( > > > > > > I hate it when I dont know what the problem is! You feel so helpless :( > > > haha I am sure this is fixable because it has to be maybe we'll have > > > torequest a different CD! > > > > > > - Original Message - > > > From: Rob > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 3:40 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > Did your indexes come over ok? There is a setting somewhere on 7 I > > > believe when moving data if you do not say you want indexes to go they > > > wont. That could impact performace (more on selects I would imagine). > > > Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor > > > problems (and very obscure syntax changes) but not much to write home > > >
Re: OT: migrating to SQL Server 2000
Perhaps DMA needs to be turned on? - Original Message - From: brobborb <[EMAIL PROTECTED]> Date: Monday, March 1, 2004 3:50 pm Subject: Re: OT: migrating to SQL Server 2000 > IO cost is like .0101 > > > UPDATE.we installed a copy on a different server, and it works > fine! So now we know the problem can't be with the database. It > must be with the computer. But we dont know what it could be it's > the fastest in here! > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 4:52 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > When you hover over the icon does it give you any more info that is > helpful (IO time or something)? What kind of commit are you > using by > default - bad / lame disk maybe? > > "Try rebooting" > -- MCSE > > On Mon, 2004-03-01 at 14:27, brobborb wrote: > > Query cost is 0.20%, for each insert!!! > > > > on the SQL 7 server it's 0.10%. > > > > WHY > > > > :( > > - Original Message - > > From: Rob > > To: CF-Talk > > Sent: Monday, March 01, 2004 4:32 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > In query analyser what does the execution path show? > > > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > > No RAID set up. it has 1 gig of RAM, vs 512 on the server > with SQL 7 > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 4:09 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > Are you on a RAID 5? Could cause slower inserts (write) > and fast selects > > > (read). > > > > > > Does your 2000 server have more RAM than the 7 server? > > > > > > -Kore > > > > > > > > > > > "brobborb" > > > > > <[EMAIL PROTECTED] To: CF- > Talk <[EMAIL PROTECTED]> > > > > on.rr.com>cc: > > > > > Subject: > Re: OT: migrating to SQL Server 2000 > > > > 03/01/2004 > > > > > 03:45 PM > > > > > Please respond > > > > > to cf-talk > > > > > > > > > > > > > > > > > > > > > I just did a little test. I created a regular table, > with one field. I > > > used the Query Analyzer to insert 500 rows. took about > 4 seconds. > > > > > > In SQL 7, i did the same thing, except with 1000 rows. > The results showed > > > up in a split second. > > > > > > So far i know this (i hope i'm right!) > > > > > > It's not a coldfusion compatibility problem > > > It's not a crappy computer problem (the one running 2000 > is 2.8ghz, the one > > > running SQL 7 is 900mhz) > > > It's not an indexing problem > > > No problems with SELECT statements. Works fine, works > great. > > PROBLEMS with INSERT statements > > > > > > This is how simple the insert statement is (500 > times)INSERT INTO > > > testy(name) VALUES ("TEST01") > > > > > > maybe there's something wrong with that insert thats > causing SQL 2000 to > > > act funny :( > > > > > > I hate it when I dont know what the problem is! You > feel so helpless :( > > > haha I am sure this is fixable because it has to be > maybe we'll have > > > torequest a different CD! > > > > > > - Original Message - > > > From: Rob > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 3:40 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > Did your indexes come over ok? There is a setting > somewhere on 7 I > > > beli
Re: OT: migrating to SQL Server 2000
Are you running enterprise manager from the local computer (server) or connecting over the network? could it be sending the information to you really slowly? Also if you are going over the network and are using that named-pipes stuff I have had crazy problems with that before and had the issuses clear up by switching to a *gasp* tcp/ip connectoin :-) Otherwise I'd look at the disk or maybe even the RAM - you can specify how much resources SQL server uses could that be it? On Mon, 2004-03-01 at 14:50, brobborb wrote: > IO cost is like .0101 > > > UPDATE.we installed a copy on a different server, and it works fine! So now we know the problem can't be with the database. It must be with the computer. But we dont know what it could be it's the fastest in here! > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 4:52 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > When you hover over the icon does it give you any more info that is > helpful (IO time or something)? What kind of commit are you using by > default - bad / lame disk maybe? > > "Try rebooting" > -- MCSE > > On Mon, 2004-03-01 at 14:27, brobborb wrote: > > Query cost is 0.20%, for each insert!!! > > > > on the SQL 7 server it's 0.10%. > > > > WHY > > > > :( > > - Original Message - > > From: Rob > > To: CF-Talk > > Sent: Monday, March 01, 2004 4:32 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > In query analyser what does the execution path show? > > > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 4:09 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > > (read). > > > > > > Does your 2000 server have more RAM than the 7 server? > > > > > > -Kore > > > > > > > > > "brobborb" > > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > > on.rr.com>cc: > > > Subject: Re: OT: migrating to SQL Server 2000 > > > 03/01/2004 > > > 03:45 PM > > > Please respond > > > to cf-talk > > > > > > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > > up in a split second. > > > > > > So far i know this (i hope i'm right!) > > > > > > It's not a coldfusion compatibility problem > > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > > running SQL 7 is 900mhz) > > > It's not an indexing problem > > > No problems with SELECT statements. Works fine, works great. > > > PROBLEMS with INSERT statements > > > > > > This is how simple the insert statement is (500 times)INSERT INTO > > > testy(name) VALUES ("TEST01") > > > > > > maybe there's something wrong with that insert thats causing SQL 2000 to > > > act funny :( > > > > > > I hate it when I dont know what the problem is! You feel so helpless :( > > > haha I am sure this is fixable because it has to be maybe we'll have > > > torequest a
Re: And Now... some Services?????????????
Frost, Michael wrote: > Ok, What is going on here. Is "Services" some kinda reserved word? I don't know the answer but a google search for "And Now... some Services" (in quotes" reveals that you're not the only one who has experienced this issue. You might be able to find your answer by going more in depth than I did. It definately seems to be related to the servlet engine. - Rick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
IO cost is like .0101 UPDATE.we installed a copy on a different server, and it works fine! So now we know the problem can't be with the database. It must be with the computer. But we dont know what it could be it's the fastest in here! - Original Message - From: Rob To: CF-Talk Sent: Monday, March 01, 2004 4:52 PM Subject: Re: OT: migrating to SQL Server 2000 When you hover over the icon does it give you any more info that is helpful (IO time or something)? What kind of commit are you using by default - bad / lame disk maybe? "Try rebooting" -- MCSE On Mon, 2004-03-01 at 14:27, brobborb wrote: > Query cost is 0.20%, for each insert!!! > > on the SQL 7 server it's 0.10%. > > WHY > > :( > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 4:32 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > In query analyser what does the execution path show? > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > - Original Message - > > From: [EMAIL PROTECTED] > > To: CF-Talk > > Sent: Monday, March 01, 2004 4:09 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > (read). > > > > Does your 2000 server have more RAM than the 7 server? > > > > -Kore > > > > > > "brobborb" > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > on.rr.com>cc: > > Subject: Re: OT: migrating to SQL Server 2000 > > 03/01/2004 > > 03:45 PM > > Please respond > > to cf-talk > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > up in a split second. > > > > So far i know this (i hope i'm right!) > > > > It's not a coldfusion compatibility problem > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > running SQL 7 is 900mhz) > > It's not an indexing problem > > No problems with SELECT statements. Works fine, works great. > > PROBLEMS with INSERT statements > > > > This is how simple the insert statement is (500 times)INSERT INTO > > testy(name) VALUES ("TEST01") > > > > maybe there's something wrong with that insert thats causing SQL 2000 to > > act funny :( > > > > I hate it when I dont know what the problem is! You feel so helpless :( > > haha I am sure this is fixable because it has to be maybe we'll have > > torequest a different CD! > > > > - Original Message - > > From: Rob > > To: CF-Talk > > Sent: Monday, March 01, 2004 3:40 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > Did your indexes come over ok? There is a setting somewhere on 7 I > > believe when moving data if you do not say you want indexes to go they > > wont. That could impact performace (more on selects I would imagine). > > Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor > > problems (and very obscure syntax changes) but not much to write home > > about. > > > > On Mon, 2004-03-01 at 13:16
Re: OT: migrating to SQL Server 2000
On Mon, 2004-03-01 at 14:52, Rob wrote: > What kind of commit are you using by That should be transaction level sorry - > > "Try rebooting" > -- MCSE > > On Mon, 2004-03-01 at 14:27, brobborb wrote: > > Query cost is 0.20%, for each insert!!! > > > > on the SQL 7 server it's 0.10%. > > > > WHY > > > > :( > > - Original Message - > > From: Rob > > To: CF-Talk > > Sent: Monday, March 01, 2004 4:32 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > In query analyser what does the execution path show? > > > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > > - Original Message - > > > From: [EMAIL PROTECTED] > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 4:09 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > > (read). > > > > > > Does your 2000 server have more RAM than the 7 server? > > > > > > -Kore > > > > > > > > > "brobborb" > > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > > on.rr.com>cc: > > > Subject: Re: OT: migrating to SQL Server 2000 > > > 03/01/2004 > > > 03:45 PM > > > Please respond > > > to cf-talk > > > > > > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > > up in a split second. > > > > > > So far i know this (i hope i'm right!) > > > > > > It's not a coldfusion compatibility problem > > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > > running SQL 7 is 900mhz) > > > It's not an indexing problem > > > No problems with SELECT statements. Works fine, works great. > > > PROBLEMS with INSERT statements > > > > > > This is how simple the insert statement is (500 times)INSERT INTO > > > testy(name) VALUES ("TEST01") > > > > > > maybe there's something wrong with that insert thats causing SQL 2000 to > > > act funny :( > > > > > > I hate it when I dont know what the problem is! You feel so helpless :( > > > haha I am sure this is fixable because it has to be maybe we'll have > > > torequest a different CD! > > > > > > - Original Message - > > > From: Rob > > > To: CF-Talk > > > Sent: Monday, March 01, 2004 3:40 PM > > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > Did your indexes come over ok? There is a setting somewhere on 7 I > > > believe when moving data if you do not say you want indexes to go they > > > wont. That could impact performace (more on selects I would imagine). > > > Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor > > > problems (and very obscure syntax changes) but not much to write home > > > about. > > > > > > On Mon, 2004-03-01 at 13:16, brobborb wrote: > > > > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 > > > is just running really slow and we can't figure out why. Is there a > > > difference in syntax or something? On SQL 7 a multiple insert query (400 > > > inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > > > > > > > i've google some information and it seem others have come across this
RE: OT: migrating to SQL Server 2000
I know there were some issues with upgrading servers. I cannot remember clearly now and I got book at home. As soon as I get there I take a look. I am quite sure you need to re-create statistics and re-populate all full text search indexes. TK -Original Message- From: Rob [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 5:52 PM To: CF-Talk Subject: Re: OT: migrating to SQL Server 2000 When you hover over the icon does it give you any more info that is helpful (IO time or something)? What kind of commit are you using by default - bad / lame disk maybe? "Try rebooting" -- MCSE On Mon, 2004-03-01 at 14:27, brobborb wrote: > Query cost is 0.20%, for each insert!!! > > on the SQL 7 server it's 0.10%. > > WHY > > :( > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 4:32 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > In query analyser what does the execution path show? > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > - Original Message - > > From: [EMAIL PROTECTED] > > To: CF-Talk > > Sent: Monday, March 01, 2004 4:09 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > (read). > > > > Does your 2000 server have more RAM than the 7 server? > > > > -Kore > > > > > > "brobborb" > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > on.rr.com>cc: > > Subject: Re: OT: migrating to SQL Server 2000 > > 03/01/2004 > > 03:45 PM > > Please respond > > to cf-talk > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > up in a split second. > > > > So far i know this (i hope i'm right!) > > > > It's not a coldfusion compatibility problem > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > running SQL 7 is 900mhz) > > It's not an indexing problem > > No problems with SELECT statements. Works fine, works great. > > PROBLEMS with INSERT statements > > > > This is how simple the insert statement is (500 times)INSERT INTO > > testy(name) VALUES ("TEST01") > > > > maybe there's something wrong with that insert thats causing SQL 2000 to > > act funny :( > > > > I hate it when I dont know what the problem is! You feel so helpless :( > > haha I am sure this is fixable because it has to be maybe we'll have > > torequest a different CD! > > > > - Original Message - > > From: Rob > > To: CF-Talk > > Sent: Monday, March 01, 2004 3:40 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > Did your indexes come over ok? There is a setting somewhere on 7 I > > believe when moving data if you do not say you want indexes to go they > > wont. That could impact performace (more on selects I would imagine). > > Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor > > problems (and very obscure syntax changes) but not much to write home > > about. > > > > On Mon, 2004-03-01 at 13:16, brobborb wrote: > > > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 > > is just running really slow and we can't figure out why. Is there a > > difference in syntax or something? On SQL 7 a multiple insert query (400 > > inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > > > > > i've google some information and it seem others have come across this > > problem, but we could not fix ours to work correctly. I hope this is > > fixable :( > > > > > > > > > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
When you hover over the icon does it give you any more info that is helpful (IO time or something)? What kind of commit are you using by default - bad / lame disk maybe? "Try rebooting" -- MCSE On Mon, 2004-03-01 at 14:27, brobborb wrote: > Query cost is 0.20%, for each insert!!! > > on the SQL 7 server it's 0.10%. > > WHY > > :( > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 4:32 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > In query analyser what does the execution path show? > > On Mon, 2004-03-01 at 14:10, brobborb wrote: > > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > > - Original Message - > > From: [EMAIL PROTECTED] > > To: CF-Talk > > Sent: Monday, March 01, 2004 4:09 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > > (read). > > > > Does your 2000 server have more RAM than the 7 server? > > > > -Kore > > > > > > "brobborb" > > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > > on.rr.com>cc: > > Subject: Re: OT: migrating to SQL Server 2000 > > 03/01/2004 > > 03:45 PM > > Please respond > > to cf-talk > > > > > > > > > > I just did a little test. I created a regular table, with one field. I > > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > > up in a split second. > > > > So far i know this (i hope i'm right!) > > > > It's not a coldfusion compatibility problem > > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > > running SQL 7 is 900mhz) > > It's not an indexing problem > > No problems with SELECT statements. Works fine, works great. > > PROBLEMS with INSERT statements > > > > This is how simple the insert statement is (500 times)INSERT INTO > > testy(name) VALUES ("TEST01") > > > > maybe there's something wrong with that insert thats causing SQL 2000 to > > act funny :( > > > > I hate it when I dont know what the problem is! You feel so helpless :( > > haha I am sure this is fixable because it has to be maybe we'll have > > torequest a different CD! > > > > - Original Message - > > From: Rob > > To: CF-Talk > > Sent: Monday, March 01, 2004 3:40 PM > > Subject: Re: OT: migrating to SQL Server 2000 > > > > Did your indexes come over ok? There is a setting somewhere on 7 I > > believe when moving data if you do not say you want indexes to go they > > wont. That could impact performace (more on selects I would imagine). > > Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor > > problems (and very obscure syntax changes) but not much to write home > > about. > > > > On Mon, 2004-03-01 at 13:16, brobborb wrote: > > > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 > > is just running really slow and we can't figure out why. Is there a > > difference in syntax or something? On SQL 7 a multiple insert query (400 > > inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > > > > > i've google some information and it seem others have come across this > > problem, but we could not fix ours to work correctly. I hope this is > > fixable :( > > > > > > > > > > > >
Re: OT: migrating to SQL Server 2000
Query cost is 0.20%, for each insert!!! on the SQL 7 server it's 0.10%. WHY :( - Original Message - From: Rob To: CF-Talk Sent: Monday, March 01, 2004 4:32 PM Subject: Re: OT: migrating to SQL Server 2000 In query analyser what does the execution path show? On Mon, 2004-03-01 at 14:10, brobborb wrote: > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > - Original Message - > From: [EMAIL PROTECTED] > To: CF-Talk > Sent: Monday, March 01, 2004 4:09 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > (read). > > Does your 2000 server have more RAM than the 7 server? > > -Kore > > > "brobborb" > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > on.rr.com>cc: > Subject: Re: OT: migrating to SQL Server 2000 > 03/01/2004 > 03:45 PM > Please respond > to cf-talk > > > > > I just did a little test. I created a regular table, with one field. I > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > up in a split second. > > So far i know this (i hope i'm right!) > > It's not a coldfusion compatibility problem > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > running SQL 7 is 900mhz) > It's not an indexing problem > No problems with SELECT statements. Works fine, works great. > PROBLEMS with INSERT statements > > This is how simple the insert statement is (500 times)INSERT INTO > testy(name) VALUES ("TEST01") > > maybe there's something wrong with that insert thats causing SQL 2000 to > act funny :( > > I hate it when I dont know what the problem is! You feel so helpless :( > haha I am sure this is fixable because it has to be maybe we'll have > torequest a different CD! > > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 3:40 PM > Subject: Re: OT: migrating to SQL Server 2000 > > Did your indexes come over ok? There is a setting somewhere on 7 I > believe when moving data if you do not say you want indexes to go they > wont. That could impact performace (more on selects I would imagine). > Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor > problems (and very obscure syntax changes) but not much to write home > about. > > On Mon, 2004-03-01 at 13:16, brobborb wrote: > > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 > is just running really slow and we can't figure out why. Is there a > difference in syntax or something? On SQL 7 a multiple insert query (400 > inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > > > i've google some information and it seem others have come across this > problem, but we could not fix ours to work correctly. I hope this is > fixable :( > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: And Now... some Services?????????????
Have you got a virtual directory called services set up in iis? -Original Message- From: Frost, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, 2 March 2004 10:18 a.m. To: CF-Talk Subject: And Now... some Services? Ok, What is going on here. Is "Services" some kinda reserved word? We have a directory called services and we are calling a .html file and it is throwing an AXIS error saying there are no services. Also, on the same server, another site, where there is no actual "services" directory, it comes up with the text "And Now... some Services" We are running IIS6, MX6.1 with jRun. I can't seem to find any reference to this directory in IIS or Jrun.. Anyone have any ideas on this? -Mike _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF6.1 & IIS Register files
Run the WSConfig tool, usually found in Start > Programs > Macromedia > ColdFusion MX > Web Server Config Tool. -nathan strutz -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 3:06 PM To: CF-Talk Subject: CF6.1 & IIS Register files can someone remind me of how to register an installed version of CF 6.1 in IIS 5. I had to kill IIS and reinstall, and of course it can't browse CF files now. I go into Home Directory, and add the mappingbut don't know what .exe to point to. Anyone? I will be forever in your debt. Thanks. Eric __ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
In query analyser what does the execution path show? On Mon, 2004-03-01 at 14:10, brobborb wrote: > No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 > - Original Message - > From: [EMAIL PROTECTED] > To: CF-Talk > Sent: Monday, March 01, 2004 4:09 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > Are you on a RAID 5? Could cause slower inserts (write) and fast selects > (read). > > Does your 2000 server have more RAM than the 7 server? > > -Kore > > > "brobborb" > <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> > on.rr.com>cc: > Subject: Re: OT: migrating to SQL Server 2000 > 03/01/2004 > 03:45 PM > Please respond > to cf-talk > > > > > I just did a little test. I created a regular table, with one field. I > used the Query Analyzer to insert 500 rows. took about 4 seconds. > > In SQL 7, i did the same thing, except with 1000 rows. The results showed > up in a split second. > > So far i know this (i hope i'm right!) > > It's not a coldfusion compatibility problem > It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one > running SQL 7 is 900mhz) > It's not an indexing problem > No problems with SELECT statements. Works fine, works great. > PROBLEMS with INSERT statements > > This is how simple the insert statement is (500 times)INSERT INTO > testy(name) VALUES ("TEST01") > > maybe there's something wrong with that insert thats causing SQL 2000 to > act funny :( > > I hate it when I dont know what the problem is! You feel so helpless :( > haha I am sure this is fixable because it has to be maybe we'll have > torequest a different CD! > > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 3:40 PM > Subject: Re: OT: migrating to SQL Server 2000 > > Did your indexes come over ok? There is a setting somewhere on 7 I > believe when moving data if you do not say you want indexes to go they > wont. That could impact performace (more on selects I would imagine). > Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor > problems (and very obscure syntax changes) but not much to write home > about. > > On Mon, 2004-03-01 at 13:16, brobborb wrote: > > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 > is just running really slow and we can't figure out why. Is there a > difference in syntax or something? On SQL 7 a multiple insert query (400 > inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > > > i've google some information and it seem others have come across this > problem, but we could not fix ours to work correctly. I hope this is > fixable :( > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
And Now... some Services?????????????
Ok, What is going on here. Is "Services" some kinda reserved word? We have a directory called services and we are calling a .html file and it is throwing an AXIS error saying there are no services. Also, on the same server, another site, where there is no actual "services" directory, it comes up with the text "And Now... some Services" We are running IIS6, MX6.1 with jRun. I can't seem to find any reference to this directory in IIS or Jrun.. Anyone have any ideas on this? -Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: template reader/parser sort of thing :)
I recently wrote a weblog app which used custom (Movable Type-style) markup tags to indicate points to insert data into an HTML template. When first viewed, this would all be compiled into a regular cfm file to improve performance. Soon after writing this I found the flexibility limitations e.g. handling attributes was a pain, inability to embed cfm if I wanted to. I ended up replacing with a cfimport and tag library as described below, which means all the functionality is inherent to CF, no template compilation, and the markup is easier, even for non-CF folk. Fundamentally though, the code is much much easier to maintain. My solution: all the visual design is handled by CSS. The template is little more than a series of tags indicating which elements to include and the attributes to pass, plus a few divs. -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Tuesday, 2 March 2004 7:16 a.m. To: CF-Talk Subject: RE: template reader/parser sort of thing :) Though you can't compute a taglib path at runtime, it's done at compile time, so that wouldn't of much use if the skinning needs to be dynamic. You'd have to use them the other way (where the template is skin specific, and the tags are the commonn stuff). Cheers, barneyb > -Original Message- > From: Nathan Strutz [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 11:04 AM > To: CF-Talk > Subject: RE: template reader/parser sort of thing :) > > Actually I really like this idea, but modified a bit... > a taglib > of custom display tags, where from depends on the skin you > want to use, then > . > This is native > functionality to coldfusion, and not nearly as much code as > the XSLT samples > given in this thread. > > -nathan strutz > > > -Original Message- > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 7:23 AM > To: CF-Talk > Subject: Re: template reader/parser sort of thing :) > > > To make it a little easier to work with I would suggest > using tag like > syntax instead of comment syntax. > > > > > > Then use regular expressions to parse the page into a > structure replace > your tags with the appropriate data, write the page to disk > or memory, > and then save the unparsed page as a template. > > Ryan Mitchell wrote: > > > Hello > > > > I'm working on a project that i would like to make > skinnable... i'm not > > just talking css skinnable i mean like proper skinnable. > > > > I was wanting to use a file as a template that contained > some variation > > of comments eg <[EMAIL PROTECTED] links ---@> or something to that > effect, which are > > then replaced by finding the appropriate entry in a > structure of items > > to be replaced... > > > > Has anyone done this before? What happens when you have > an arrangement > > like this... > > > > > > > > > > > > > > > > > > > > ie nested bits needing replaced. > > > > Any wise thoughts? Things to watch out for? > > > > Thanks, > > Ryan > > > _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
No RAID set up. it has 1 gig of RAM, vs 512 on the server with SQL 7 - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Monday, March 01, 2004 4:09 PM Subject: Re: OT: migrating to SQL Server 2000 Are you on a RAID 5? Could cause slower inserts (write) and fast selects (read). Does your 2000 server have more RAM than the 7 server? -Kore "brobborb" <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> on.rr.com>cc: Subject: Re: OT: migrating to SQL Server 2000 03/01/2004 03:45 PM Please respond to cf-talk I just did a little test. I created a regular table, with one field. I used the Query Analyzer to insert 500 rows. took about 4 seconds. In SQL 7, i did the same thing, except with 1000 rows. The results showed up in a split second. So far i know this (i hope i'm right!) It's not a coldfusion compatibility problem It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one running SQL 7 is 900mhz) It's not an indexing problem No problems with SELECT statements. Works fine, works great. PROBLEMS with INSERT statements This is how simple the insert statement is (500 times)INSERT INTO testy(name) VALUES ("TEST01") maybe there's something wrong with that insert thats causing SQL 2000 to act funny :( I hate it when I dont know what the problem is! You feel so helpless :( haha I am sure this is fixable because it has to be maybe we'll have torequest a different CD! - Original Message - From: Rob To: CF-Talk Sent: Monday, March 01, 2004 3:40 PM Subject: Re: OT: migrating to SQL Server 2000 Did your indexes come over ok? There is a setting somewhere on 7 I believe when moving data if you do not say you want indexes to go they wont. That could impact performace (more on selects I would imagine). Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor problems (and very obscure syntax changes) but not much to write home about. On Mon, 2004-03-01 at 13:16, brobborb wrote: > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 is just running really slow and we can't figure out why. Is there a difference in syntax or something? On SQL 7 a multiple insert query (400 inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > i've google some information and it seem others have come across this problem, but we could not fix ours to work correctly. I hope this is fixable :( > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
Are you on a RAID 5? Could cause slower inserts (write) and fast selects (read). Does your 2000 server have more RAM than the 7 server? -Kore "brobborb" <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> on.rr.com>cc: Subject: Re: OT: migrating to SQL Server 2000 03/01/2004 03:45 PM Please respond to cf-talk I just did a little test. I created a regular table, with one field. I used the Query Analyzer to insert 500 rows. took about 4 seconds. In SQL 7, i did the same thing, except with 1000 rows. The results showed up in a split second. So far i know this (i hope i'm right!) It's not a coldfusion compatibility problem It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one running SQL 7 is 900mhz) It's not an indexing problem No problems with SELECT statements. Works fine, works great. PROBLEMS with INSERT statements This is how simple the insert statement is (500 times)INSERT INTO testy(name) VALUES ("TEST01") maybe there's something wrong with that insert thats causing SQL 2000 to act funny :( I hate it when I dont know what the problem is! You feel so helpless :( haha I am sure this is fixable because it has to be maybe we'll have torequest a different CD! - Original Message - From: Rob To: CF-Talk Sent: Monday, March 01, 2004 3:40 PM Subject: Re: OT: migrating to SQL Server 2000 Did your indexes come over ok? There is a setting somewhere on 7 I believe when moving data if you do not say you want indexes to go they wont. That could impact performace (more on selects I would imagine). Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor problems (and very obscure syntax changes) but not much to write home about. On Mon, 2004-03-01 at 13:16, brobborb wrote: > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 is just running really slow and we can't figure out why. Is there a difference in syntax or something? On SQL 7 a multiple insert query (400 inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > i've google some information and it seem others have come across this problem, but we could not fix ours to work correctly. I hope this is fixable :( > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
It's reaching, but it might be the collation on the tables. Check it out. - Original Message - From: brobborb <[EMAIL PROTECTED]> Date: Monday, March 1, 2004 2:45 pm Subject: Re: OT: migrating to SQL Server 2000 > I just did a little test. I created a regular table, with one > field. I used the Query Analyzer to insert 500 rows. took about > 4 seconds. > > In SQL 7, i did the same thing, except with 1000 rows. The > results showed up in a split second. > > > So far i know this (i hope i'm right!) > > It's not a coldfusion compatibility problem > It's not a crappy computer problem (the one running 2000 is > 2.8ghz, the one running SQL 7 is 900mhz) > It's not an indexing problem > No problems with SELECT statements. Works fine, works great. > PROBLEMS with INSERT statements > > > This is how simple the insert statement is (500 times)INSERT > INTO testy(name) VALUES ("TEST01") > > maybe there's something wrong with that insert thats causing SQL > 2000 to act funny :( > > I hate it when I dont know what the problem is! You feel so > helpless :( haha I am sure this is fixable because it has to be > maybe we'll have torequest a different CD! > > > - Original Message - > From: Rob > To: CF-Talk > Sent: Monday, March 01, 2004 3:40 PM > Subject: Re: OT: migrating to SQL Server 2000 > > > Did your indexes come over ok? There is a setting somewhere on 7 I > believe when moving data if you do not say you want indexes to > go they > wont. That could impact performace (more on selects I would > imagine). Anyway I have done at least 3 SQL7 -> SQL2000 and there > were a few minor > problems (and very obscure syntax changes) but not much to write > home about. > > On Mon, 2004-03-01 at 13:16, brobborb wrote: > > Is there a HUGE difference between SQL 7 and SQL 2000??? > Because 2000 is just running really slow and we can't figure out > why. Is there a difference in syntax or something? On SQL 7 a > multiple insert query (400 inserts) finished in 400ms. in 2000, > same query, but in 7 SECONDS!!! > > > > i've google some information and it seem others have come > across this problem, but we could not fix ours to work correctly. > I hope this is fixable :( > > > > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF6.1 & IIS Register files
can someone remind me of how to register an installed version of CF 6.1 in IIS 5. I had to kill IIS and reinstall, and of course it can't browse CF files now. I go into Home Directory, and add the mappingbut don't know what .exe to point to. Anyone? I will be forever in your debt. Thanks. Eric __ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Looking for design pattern advice: role based permission to objec ts
Hi Experts: Would appreciate if you could share your advice: how to keep the customization info of a web application. some sample requirements: 1. menu is dynamically created based on the Role of the logon user 2. Tables can be customized - for example, which columns to display, editable, sortable, etc. So in an OO application, where should I keep these customization information? What design pattern / set of patterns do you recommend? My initial thought was to create a factory that created a different manager based on role i.e main.cfm: productManager = createobject('component', 'productFactory').init(session.user.role); productFactory.cfc: function init (role) { var productManager = createobject('component', 'productManager'&role).init(); return productManager; } With this approach, I will need a seperate productManager for every role. And every productManager would define only the properties and methods available to that role. So it would work ... but then I would need a CFC for every object-role combination. It strikes me that there must be a better way? How have otheres implemented role-based permissions in there OO apps? Any help is much appreciated! Ed. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF5.0 app w/ Access extremely slow
First of all, it's not my app but I'm tasked to fix bugs for the app. The app won't run properly on CFMX, more importantly the client prefers to stay with CF5.0. The app is just way too slow. It seems that the ODBC driver is the culprit for when I switch to CFMX6.1 using Access Unicode driver, I got jet speed. My box is Windows XP Pro. Any thoughts? Access Unicode driver for CF5.0? If so, how to make it available to CF5.0's datasource creation process? ??? TIA [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
I just did a little test. I created a regular table, with one field. I used the Query Analyzer to insert 500 rows. took about 4 seconds. In SQL 7, i did the same thing, except with 1000 rows. The results showed up in a split second. So far i know this (i hope i'm right!) It's not a coldfusion compatibility problem It's not a crappy computer problem (the one running 2000 is 2.8ghz, the one running SQL 7 is 900mhz) It's not an indexing problem No problems with SELECT statements. Works fine, works great. PROBLEMS with INSERT statements This is how simple the insert statement is (500 times)INSERT INTO testy(name) VALUES ("TEST01") maybe there's something wrong with that insert thats causing SQL 2000 to act funny :( I hate it when I dont know what the problem is! You feel so helpless :( haha I am sure this is fixable because it has to be maybe we'll have torequest a different CD! - Original Message - From: Rob To: CF-Talk Sent: Monday, March 01, 2004 3:40 PM Subject: Re: OT: migrating to SQL Server 2000 Did your indexes come over ok? There is a setting somewhere on 7 I believe when moving data if you do not say you want indexes to go they wont. That could impact performace (more on selects I would imagine). Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor problems (and very obscure syntax changes) but not much to write home about. On Mon, 2004-03-01 at 13:16, brobborb wrote: > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 is just running really slow and we can't figure out why. Is there a difference in syntax or something? On SQL 7 a multiple insert query (400 inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > i've google some information and it seem others have come across this problem, but we could not fix ours to work correctly. I hope this is fixable :( > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
Did you update stats? -Kore Rob <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> om> cc: Subject: Re: OT: migrating to SQL Server 2000 03/01/2004 03:40 PM Please respond to cf-talk Did your indexes come over ok? There is a setting somewhere on 7 I believe when moving data if you do not say you want indexes to go they wont. That could impact performace (more on selects I would imagine). Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor problems (and very obscure syntax changes) but not much to write home about. On Mon, 2004-03-01 at 13:16, brobborb wrote: > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 is just running really slow and we can't figure out why. Is there a difference in syntax or something? On SQL 7 a multiple insert query (400 inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > i've google some information and it seem others have come across this problem, but we could not fix ours to work correctly. I hope this is fixable :( > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
PDF opened with CFContent Crashes browser
I am wondering if anyone has any ideas. I am opening some PDF files with CFContent using the following code: FILE="#VARIABLES.file_location#"> Everything works fine on the machines I've tried in my office, however at least 3 machines in their office crash not when the PDF opens, but rather when they go to close it. At this moment I have no clue what could cause this. So far, the main difference I have uncovered between their machines and mine is that I have Acrobat 6.x on my machine, and they use 4 or 5. I don't know if that matters though. I wouldn't think this issue had anything to do with ColdFusion or CFContent, but they can go to other websites and open PDFs without trouble. Our server uses ColdFusion 5.0. Thanks! __ Do you Yahoo!? Get better spam protection with Yahoo! Mail. http://antispam.yahoo.com/tools [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: migrating to SQL Server 2000
Did your indexes come over ok? There is a setting somewhere on 7 I believe when moving data if you do not say you want indexes to go they wont. That could impact performace (more on selects I would imagine). Anyway I have done at least 3 SQL7 -> SQL2000 and there were a few minor problems (and very obscure syntax changes) but not much to write home about. On Mon, 2004-03-01 at 13:16, brobborb wrote: > Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 is just running really slow and we can't figure out why. Is there a difference in syntax or something? On SQL 7 a multiple insert query (400 inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! > > i've google some information and it seem others have come across this problem, but we could not fix ours to work correctly. I hope this is fixable :( > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Controlling the execution of CFHEADER and CFCONTENT
> I have some code to force the downloading of a file to the > client. It works great but I want to execute some other code > before that. Is it possible? > > My code looks like the stuff below and when you run it, it > fires immediately. > > > > Yes, you can execute other code before that, but you can't return any output to the browser before that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX - How do i end "client" variable state at browser close?
> Thanks I knew that trick... was curious if there was a better > "CFMX" way... If you can use Session variables instead of Client variables, you can use J2EE sessions in CFMX, which use a session cookie as their token. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: migrating to SQL Server 2000
Is there a HUGE difference between SQL 7 and SQL 2000??? Because 2000 is just running really slow and we can't figure out why. Is there a difference in syntax or something? On SQL 7 a multiple insert query (400 inserts) finished in 400ms. in 2000, same query, but in 7 SECONDS!!! i've google some information and it seem others have come across this problem, but we could not fix ours to work correctly. I hope this is fixable :( [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Service to Validate US Address
Although I am sure the cfc that Bryan provided will be adequate for the task, I thought I would also post this link to the USPS web tools. I wrote a set up custom tags for a previous employer that connected to these API's. One of many of the services they provide is address verification. I never hear much mention of these tools so I dont know if people dont know about them or if everyone has found better solutions. but check out http://www.usps.com/webtools/ to see if it helps you out. simeon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Display images inside a form select tag
Mark: SELECT lists only support text options. What with CSS you can style the text a bit, but you can't put images in there. However, you can roll your own drop-down control via DHTML or use any number of canned DHTML menu scripts. A bunch of them support images. -- Mosh Teitelbaum evoch, LLC Tel: (301) 942-5378 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 2:49 PM To: CF-Talk Subject: Display images inside a form select tag Hi all, I have a query which populates a loop of options in a form select box. Problem is, I want to display small dynamic images next to each option (using the tag). I've tried the following code without success (the text list items display as intended). Any ideas? value="#colorAdvantageID#">#colorAdvantageID# - #colorAdvantageNam e# src=""> /> Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
You know I think I went wrong getting values in a WHERE clause confused with conditions in a CFIF. Oh well...better safe than sorry Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Bryan F. Hogan To: CF-Talk Sent: Monday, March 01, 2004 1:00 PM Subject: Re: populating dropdowns truefalse It is not case sensitive, on any version of cf. Bryan Stevenson wrote: > Well let's say there are 2 programmers... > > 1 makes the select box and fills all the values in in lower case > > The second programmer is doing whatever based on the value selected in > the select box and writes this line: > > > That condition will never be true because case was not considered...the > line should read > > > > This is assuming that "biff" only has one meaning no matter what case > it's in. > > Does that make sense?? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Undefined values?
Never mind, in the other code I use the query tag in the This time I do not.. Thanks -Original Message- From: Morphis, Greg Sent: Monday, March 01, 2004 3:04 PM To: CF-Talk Subject: Undefined values? I have an update/insert query (depending on if the record already exists). Afterwards I want my page to email a group with information pertaining to the record. I have the cfmail code correct(I use it elsewhere on my site) however here I get a weird error "The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. " It highlights the last ## statement. Also in the debugger it shows 15:55:20.020 - java.lang.NullPointerException - in D:\Inetpub\wwwroot\sales\agentdb\AgentInsert.cfm : line 157 Any ideas? When I remove the whole #form.entitytype# and execute, it highlights the form.commcontactname Thanks Here's my cfmail tag... The following Agent requires a Vendor ID set up for them. Thank you Date: #dateformat(form.DATEENTERED,"mmm-dd-")# Agent: #form.agentname# Address: #form.commstreet# #form.commcity#, #form.commst#, #form.commzip# Contact: #form.commcontactname# Entity: #form.entitytype# Agent Inserted into Database Greg Morphis Rapid Response Team Client Server Dev/Analyst I Armageddon Programmer/Support Desk: 501/905-2881 Cell: 501/529-3691 ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
Well dang it all to heck (hate those filters) ;-) I could have sworn I had seen it act differently (testing logon credentials as a matter of fact), but I just fired up a test and sure enough you're right (shoulda trusted ya...you spell your name with a 'y' as well) ;-) Well I guess I've used a few extra UCase() funtions along the way!! Thanks for for that one Bryan Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Bryan F. Hogan To: CF-Talk Sent: Monday, March 01, 2004 1:00 PM Subject: Re: populating dropdowns truefalse It is not case sensitive, on any version of cf. Bryan Stevenson wrote: > Well let's say there are 2 programmers... > > 1 makes the select box and fills all the values in in lower case > > The second programmer is doing whatever based on the value selected in > the select box and writes this line: > > > That condition will never be true because case was not considered...the > line should read > > > > This is assuming that "biff" only has one meaning no matter what case > it's in. > > Does that make sense?? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Undefined values?
I have an update/insert query (depending on if the record already exists). Afterwards I want my page to email a group with information pertaining to the record. I have the cfmail code correct(I use it elsewhere on my site) however here I get a weird error "The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. " It highlights the last ## statement. Also in the debugger it shows 15:55:20.020 - java.lang.NullPointerException - in D:\Inetpub\wwwroot\sales\agentdb\AgentInsert.cfm : line 157 Any ideas? When I remove the whole #form.entitytype# and execute, it highlights the form.commcontactname Thanks Here's my cfmail tag... The following Agent requires a Vendor ID set up for them. Thank you Date: #dateformat(form.DATEENTERED,"mmm-dd-")# Agent: #form.agentname# Address: #form.commstreet# #form.commcity#, #form.commst#, #form.commzip# Contact: #form.commcontactname# Entity: #form.entitytype# Agent Inserted into Database Greg Morphis Rapid Response Team Client Server Dev/Analyst I Armageddon Programmer/Support Desk: 501/905-2881 Cell: 501/529-3691 ** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Session Replication in CFMX 6.1 on JRun 4
Perhaps I should mention that I have not set up the web server configuration, if that makes a difference, thanks, Igor -Original Message- From: Igor Ilyinsky Sent: Monday, March 01, 2004 2:09 PM To: CF-Talk Subject: Session Replication in CFMX 6.1 on JRun 4 > Having trouble setting up the session replication in CFMX 6.1 on Jrun 4. > > I'm trying to test it out on 1 machine (for now). > I have set up 2 server instances (say Server1 and Server2) and deployed CFMX on both. > I configured both instances of CFMX to allow J2EE sessions. > I clustered those 2 server instances in JRun > I added each of the instances as a peer to the other, and pointed the web root to the same index.cfm file. > > The simple INDEX.CFM for testing is as follows: > > > > applicationtimeout="#createtimespan(0,0,5,0)#" > sessionmanagement="Yes" > sessiontimeout="#createtimespan(0,0,1,0)#"> > > > #Session.Host# > > First time here. > > > > > > > Now, when I test the two instances (say loclhost:8001 and localhost:8002) I never get confirmation that a session is coming form the other instance. > > The weird thing (or maybe not) is that the JSessionID, CFID and CFTOKEN are the same on both calls. > > Any input is appreciated. > > thanks in advance, > Igor > cccfug.org _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
truefalse It is not case sensitive, on any version of cf. Bryan Stevenson wrote: > Well let's say there are 2 programmers... > > 1 makes the select box and fills all the values in in lower case > > The second programmer is doing whatever based on the value selected in > the select box and writes this line: > > > That condition will never be true because case was not considered...the > line should read > > > > This is assuming that "biff" only has one meaning no matter what case > it's in. > > Does that make sense?? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
They are interchangable and neither one is case sensitive. Bryan Stevenson wrote: > my bad...I did not know "IS" is case insensitiveI always use EQ and > thought the 2 wre interchangeable [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
Well let's say there are 2 programmers... 1 makes the select box and fills all the values in in lower case The second programmer is doing whatever based on the value selected in the select box and writes this line: That condition will never be true because case was not considered...the line should read This is assuming that "biff" only has one meaning no matter what case it's in. Does that make sense?? Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Bryan F. Hogan To: CF-Talk Sent: Monday, March 01, 2004 12:46 PM Subject: Re: populating dropdowns Why would checking case insensative get you into trouble? As you say it would be bad design to make HIGH and high mean differant things, so why then would session.username='high' mean anything differant than UCASE(session.username) is 'HIGH'? Bryan Stevenson wrote: > The value could be high,High,HIGH,HiGH etc. SO checking to see if > it's 'high' can get you into trouble (unless of course HIGH and high > have different meanings...then by all means it should be as it was > written (but IMHO that would be bad design to have HIGH and high mean > different things). > > It's case sensitive because the value of username could be stored in the > DB as all upper/lower/mixed caseto be case insensitive you have to > check values of the same case...all upper...all lower...whatever floats > yer boat. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
Trimming of variables should be done before they are inserted into the database. Wherever your entering username into the database you should make sure that you trim all variables going in. I also recommend using the 'is' operator on string values and the 'eq' operator on numerical values. For example: truefalse Robert Orlini wrote: > The trim function fixed everything in this part: > > > > Select * from admin > Where username = '#trim(session.username)#' > > > > and here as well: > > > > Custom Status Message [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
my bad...I did not know "IS" is case insensitiveI always use EQ and thought the 2 wre interchangeable Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Barney Boisvert To: CF-Talk Sent: Monday, March 01, 2004 12:43 PM Subject: RE: populating dropdowns The binary comparison operators are not case sensitive, so "high" EQ "High" is true. Though I would recommend using either "EQ" or "IS" (not both) for consistency. Cheers, barneyb > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 12:27 PM > To: CF-Talk > Subject: Re: populating dropdowns > > First off...ditch the excessive use of # > > getuser.priority is "high"> > should be > > getuser.priority is "high"> > > The issue may be that getuser.priority is equal to "HIGH" or > "High" and not "high" but I can't tell without seeing it for > myself ;-) (same goes for username) > > you should really make this entire condition case insensitive like so: > > UCase(getuser.priority) is "HIGH"> > > Hope that sheds some light > > Cheers > > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: Robert Orlini > To: CF-Talk > Sent: Monday, March 01, 2004 12:14 PM > Subject: populating dropdowns > > > I'm trying to restrict an option on a dropdown from > appearing based on the users priority. I have the code below > which does not generate any errors but will not display the > "Custom Message" option when the priority is the correct one. > What am I missing here please? > > Select one of six messages from this list > System Down for Scheduled > Maintenance > System Down/Internet > Circuit Problems > > getuser.priority is "high">Custom > Status Message > > > Thx. > > Roberto. O. > HWW > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: populating dropdowns
The trim function fixed everything in this part: Select * from admin Where username = '#trim(session.username)#' and here as well: Custom Status Message But as always I do appreciate the quick and helpful responses. Robert O. -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 3:46 PM To: CF-Talk Subject: Re: populating dropdowns Why would checking case insensative get you into trouble? As you say it would be bad design to make HIGH and high mean differant things, so why then would session.username='high' mean anything differant than UCASE(session.username) is 'HIGH'? Bryan Stevenson wrote: > The value could be high,High,HIGH,HiGH etc. SO checking to see if > it's 'high' can get you into trouble (unless of course HIGH and high > have different meanings...then by all means it should be as it was > written (but IMHO that would be bad design to have HIGH and high mean > different things). > > It's case sensitive because the value of username could be stored in the > DB as all upper/lower/mixed caseto be case insensitive you have to > check values of the same case...all upper...all lower...whatever floats > yer boat. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web Service to Validate US Address
I'm working from the standpoint that the Web service will be invoked after validation of the address against United States Postal Service's addressing standards. The most current version of these standards is available at http://pe.usps.gov/text/pub28/PUB28C3.html. It would not be too difficult to develop a system that validates against the rules outlined here. In this case, I need a system that simply verifies whether or not an address exists after it has been entered. M -Original Message- From: Burns, John [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 3:17 PM To: CF-Talk Subject: RE: Web Service to Validate US Address Just a thought, but if there is something out there, would it be possible to check the existence of the address if it's not formatted correctly? I don't know of anything like this but would be happy to hear if someone else knew. John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
Why would checking case insensative get you into trouble? As you say it would be bad design to make HIGH and high mean differant things, so why then would session.username='high' mean anything differant than UCASE(session.username) is 'HIGH'? Bryan Stevenson wrote: > The value could be high,High,HIGH,HiGH etc. SO checking to see if > it's 'high' can get you into trouble (unless of course HIGH and high > have different meanings...then by all means it should be as it was > written (but IMHO that would be bad design to have HIGH and high mean > different things). > > It's case sensitive because the value of username could be stored in the > DB as all upper/lower/mixed caseto be case insensitive you have to > check values of the same case...all upper...all lower...whatever floats > yer boat. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: populating dropdowns
The binary comparison operators are not case sensitive, so "high" EQ "High" is true. Though I would recommend using either "EQ" or "IS" (not both) for consistency. Cheers, barneyb > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 12:27 PM > To: CF-Talk > Subject: Re: populating dropdowns > > First off...ditch the excessive use of # > > getuser.priority is "high"> > should be > > getuser.priority is "high"> > > The issue may be that getuser.priority is equal to "HIGH" or > "High" and not "high" but I can't tell without seeing it for > myself ;-) (same goes for username) > > you should really make this entire condition case insensitive like so: > > UCase(getuser.priority) is "HIGH"> > > Hope that sheds some light > > Cheers > > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > - > Macromedia Associate Partner > www.macromedia.com > - > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > - Original Message - > From: Robert Orlini > To: CF-Talk > Sent: Monday, March 01, 2004 12:14 PM > Subject: populating dropdowns > > > I'm trying to restrict an option on a dropdown from > appearing based on the users priority. I have the code below > which does not generate any errors but will not display the > "Custom Message" option when the priority is the correct one. > What am I missing here please? > > Select one of six messages from this list > System Down for Scheduled > Maintenance > System Down/Internet > Circuit Problems > > getuser.priority is "high">Custom > Status Message > > > Thx. > > Roberto. O. > HWW > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
The value could be high,High,HIGH,HiGH etc. SO checking to see if it's 'high' can get you into trouble (unless of course HIGH and high have different meanings...then by all means it should be as it was written (but IMHO that would be bad design to have HIGH and high mean different things). It's case sensitive because the value of username could be stored in the DB as all upper/lower/mixed caseto be case insensitive you have to check values of the same case...all upper...all lower...whatever floats yer boat. Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Bryan F. Hogan To: CF-Talk Sent: Monday, March 01, 2004 12:36 PM Subject: Re: populating dropdowns Bryan Stevenson wrote: > The issue may be that getuser.priority is equal to "HIGH" or "High" and > not "high" but I can't tell without seeing it for myself ;-) (same goes > for username) > > you should really make this entire condition case insensitive like so: > > UCase(getuser.priority) is "HIGH"> truefalse Since when is it case sensitive ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
Bryan Stevenson wrote: > The issue may be that getuser.priority is equal to "HIGH" or "High" and > not "high" but I can't tell without seeing it for myself ;-) (same goes > for username) > > you should really make this entire condition case insensitive like so: > > UCase(getuser.priority) is "HIGH"> truefalse Since when is it case sensitive ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strip HTML from String
Glad to help. :) > Thanks guys... > Yeah I just happen to find it on CFLib right when Ben > posted. I knew there > was something out there. Thanks Isaac, Ben this is what I > was looking for. > Neal Bailey > Internet Marketing Manager > E-mail: [EMAIL PROTECTED] > _ > From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 1:23 PM > To: CF-Talk > Subject: Re: Strip HTML from String > Thanks for the ringing endorsement Ben. :) > Ben doesn't use my functions because he's too good with > regex to need > them. heh :) >> That should work if you want to remove all HTML. If you >> want to be more >> selective, there's a UDF called StripTags by S. Isaac >> Dealey at >> http://www.cflib.org >> that is supposed to be pretty good. >> --Ben Doom > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
First off...ditch the excessive use of # should be The issue may be that getuser.priority is equal to "HIGH" or "High" and not "high" but I can't tell without seeing it for myself ;-) (same goes for username) you should really make this entire condition case insensitive like so: Hope that sheds some light Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: Robert Orlini To: CF-Talk Sent: Monday, March 01, 2004 12:14 PM Subject: populating dropdowns I'm trying to restrict an option on a dropdown from appearing based on the users priority. I have the code below which does not generate any errors but will not display the "Custom Message" option when the priority is the correct one. What am I missing here please? Select one of six messages from this list System Down for Scheduled Maintenance System Down/Internet Circuit Problems Custom Status Message Thx. Roberto. O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
Either session.username does not equal getuser.username or getuser.priority does not equal high. Use and to see what values are being returned. Also remove the #s from within the cfif, they are not needed. Robert Orlini wrote: > I'm trying to restrict an option on a dropdown from appearing based on > the users priority. I have the code below which does not generate any > errors but will not display the "Custom Message" option when the > priority is the correct one. What am I missing here please? > > Select one of six messages from this list > System Down for Scheduled Maintenance > System Down/Internet Circuit > Problems > > "high">Custom Status Message > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Web Service to Validate US Address
http://www.cfm-applications.com/ups.cfc.txt Burns, John wrote: > Just a thought, but if there is something out there, would it be > possible to check the existence of the address if it's not formatted > correctly? I don't know of anything like this but would be happy to > hear if someone else knew. > > John Burns [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
populating dropdowns
I'm trying to restrict an option on a dropdown from appearing based on the users priority. I have the code below which does not generate any errors but will not display the "Custom Message" option when the priority is the correct one. What am I missing here please? Select one of six messages from this list System Down for Scheduled Maintenance System Down/Internet Circuit Problems Custom Status Message Thx. Roberto. O. HWW [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Web Service to Validate US Address
Just a thought, but if there is something out there, would it be possible to check the existence of the address if it's not formatted correctly? I don't know of anything like this but would be happy to hear if someone else knew. John Burns -Original Message- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 3:15 PM To: CF-Talk Subject: OT: Web Service to Validate US Address I'm wondering if anyone here knows about a Web service capable of verifying the existance of a U.S. address. I'm not looking for something that checks whether the address is properly formatted, but instead something that verifies whether or not the address actually exists. M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Help - CF5 -> Sorry but the data for this graph has expired
Trying to use CFGRAPH, i often get: "Sorry but the data for this graph has expired." Aside from upgrading to CFMX, what is the best way to avoid getting this stupid message from in cf5? I need to get it to work with cf5 Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: Web Service to Validate US Address
I'm wondering if anyone here knows about a Web service capable of verifying the existance of a U.S. address. I'm not looking for something that checks whether the address is properly formatted, but instead something that verifies whether or not the address actually exists. M [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfeclipse cvs and mailing list
The cold fusion plug-in for eclipse (cfeclipse) now has a project space (finally) - thanks to Mr. Oliver Tupman (who by the way added a cool hovering tag insight and is improving the function insight to handle nested funtions and cfc's) We now also have a mailing list so we don't have to bother everyone in the cold fusion community with bug fixes etc (Thanks for offering us a mailing list Thomas but the CVS came with one so we'll save you the headache hehe) - if you use cfeclipse (or even if you don't I guess) you can subscribe here [EMAIL PROTECTED] We will still post releases to this list (if thats ok with Michael), but any help question, bug fixes, improvements, wish list, et cetera can go to that list. If you are interested in joining the project let me know. We are currently discussing possible ways to scan cf files for structure data, and ... well ... just a bunch of stuff. the project page (and cvs) is here http://cfeclipse.tigris.org/ and releases are still (at the moment) here http://cfeclipse.rohanclan.com/ We will probably do another minor relase pretty soon that adds a tree view for snips and can use dreamweaver snippets simply by copying them to the cfeclipse snip directory. Oliver has added some text hovering improvments, and there was some code structure improvements -- Rob <[EMAIL PROTECTED]> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Display images inside a form select tag
I was able to do this with CSS, but I'm not sure how well supported this is. It worked in Firefox nee Firebird nee Phoenix. But it did not work in IE 5.5. That's all the testing I gave it. Test 1 Test 2 Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CFMX - How do i end "client" variable state at browser close?
Dave, Thanks I knew that trick... was curious if there was a better "CFMX" way... Thanks, Jon -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 12:31 PM To: CF-Talk Subject: RE: CFMX - How do i end "client" variable state at browser close? > I use CLIENT variables to maintain state in an application > for when a user logs in, for example. I want the variable > state to be lost when the browser closes. What is the *best* > way to ensure that the CFID and CFTOKEN cookies expire when > the browser closes? CFMX seems to be dropping permanent cookies > by default. That means that when the user returns to the > site, they are still logged in even after they quit the browser... You'll need to write the cookies yourself: Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strip HTML from String
Thanks guys... Yeah I just happen to find it on CFLib right when Ben posted. I knew there was something out there. Thanks Isaac, Ben this is what I was looking for. Neal Bailey Internet Marketing Manager E-mail: [EMAIL PROTECTED] _ From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 1:23 PM To: CF-Talk Subject: Re: Strip HTML from String Thanks for the ringing endorsement Ben. :) Ben doesn't use my functions because he's too good with regex to need them. heh :) > That should work if you want to remove all HTML. If you > want to be more > selective, there's a UDF called StripTags by S. Isaac > Dealey at > http://www.cflib.org > that is supposed to be pretty good. > --Ben Doom [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Session Replication in CFMX 6.1 on JRun 4
> Having trouble setting up the session replication in CFMX 6.1 on Jrun 4. > > I'm trying to test it out on 1 machine (for now). > I have set up 2 server instances (say Server1 and Server2) and deployed CFMX on both. > I configured both instances of CFMX to allow J2EE sessions. > I clustered those 2 server instances in JRun > I added each of the instances as a peer to the other, and pointed the web root to the same index.cfm file. > > The simple INDEX.CFM for testing is as follows: > > > > applicationtimeout="#createtimespan(0,0,5,0)#" > sessionmanagement="Yes" > sessiontimeout="#createtimespan(0,0,1,0)#"> > > > #Session.Host# > > First time here. > > > > > > > Now, when I test the two instances (say loclhost:8001 and localhost:8002) I never get confirmation that a session is coming form the other instance. > > The weird thing (or maybe not) is that the JSessionID, CFID and CFTOKEN are the same on both calls. > > Any input is appreciated. > > thanks in advance, > Igor > cccfug.org [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Encrypt
Is the cfEncrypt.exe utility still useful in CFMX? Not bulletproof, but prevents the casual user from seeing source code. Sincerely, Andrew -Original Message- From: Shahzad.Butt [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 12:09 PM To: CF-Talk Subject: Encrypt Hi Does anyone know how I can encrypt my source code in CFMX. Also after [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Need help with Graphs
I have a site that generates a couple of graphs (CFMX Server), the graphs get created correctly and are stored in the cache. The problem is they take forever to load on my page and in some cases never load and the status bar keeps saying (Opening page.). I am generating the graphs as a flash file. But seem to have the same problem generating them as jpgs. I know the graphs are working correctly because I can see the correct graph when viewing them directly from the cache folder. Any suggestions. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Controlling the execution of CFHEADER and CFCONTENT
I have some code to force the downloading of a file to the client. It works great but I want to execute some other code before that. Is it possible? My code looks like the stuff below and when you run it, it fires immediately. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Trying to group dates in dropdown list (SOLVED)
DateFormat jacked up the output. It gave me this in the dropdown list: January 2004 December 2003 November 2003 October 2003 September 2003 August 2003 July 2003 NumberFormat worked. value="#dateYear#-#NumberFormat(dateMonth,'00')#"> gave me the correct output in the dropdown list. Thanks everyone for the help! -Original Message- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 5:16 PM To: CF-Talk Subject: Re: Trying to group dates in dropdown list (ALMOST THERE) In the output you can format the month to two digits: Right("00" & dateMonth, 2). This can also be done with NumberFormat(), or, if you had the date itself you could use DateFormat(thedate, "mm"). - Original Message - From: "Ron Eis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, February 27, 2004 4:04 PM Subject: RE: Trying to group dates in dropdown list (ALMOST THERE) > Thanks for all the suggestions. I'm almost there but just have one > issue left to fix. > > How can I get the MONTH(dataDateReported) to return a two character > integer? i.e., 01-January, 02-February, 03-March, etc. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Display images inside a form select tag
No can do, unless you write your own SELECT tag, using an Java Applet, Flash movie, some crazy DHTML, or whatever. Cheers, barneyb > -Original Message- > From: Mark Leder [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 11:49 AM > To: CF-Talk > Subject: Display images inside a form select tag > > Hi all, > > I have a query which populates a loop of options in a form select box. > Problem is, I want to display small dynamic images next to each option > (using the tag). I've tried the following code without > success (the > text list items display as intended). Any ideas? > > > > > > > > > > value="#colorAdvantageID#">#colorAdvantageID# - #col > orAdvantageNam > e# > src=""> > tageSwatch#" > /> > > > > > > > > Thanks, Mark > > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMail problem
CFMail is acting up on me. The same exact tag works only sporadically. I know this is a vastly general question, but does anyone have any experience with the idiosyncracies of the CFMail tag? Is there a list of things that could possibly make the CFMail tag act up? Using CF5. Thanks, Les [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Display images inside a form select tag
to my knowledge you cant put anything but text in there. that's really a windows combo box element without the ability to type in tony -Original Message- From: Mark Leder [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 2:49 PM To: CF-Talk Subject: Display images inside a form select tag Hi all, I have a query which populates a loop of options in a form select box. Problem is, I want to display small dynamic images next to each option (using the tag). I've tried the following code without success (the text list items display as intended). Any ideas? name="colorAdvantageID"> value="#colorAdvantageID#">#colorAdvantageID# - #colorAdvantageNam e# src=""> /> Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Display images inside a form select tag
Hi all, I have a query which populates a loop of options in a form select box. Problem is, I want to display small dynamic images next to each option (using the tag). I've tried the following code without success (the text list items display as intended). Any ideas? value="#colorAdvantageID#">#colorAdvantageID# - #colorAdvantageNam e# src=""> /> Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Strip HTML from String
Thanks for the ringing endorsement Ben. :) Ben doesn't use my functions because he's too good with regex to need them. heh :) > That should work if you want to remove all HTML. If you > want to be more > selective, there's a UDF called StripTags by S. Isaac > Dealey at > http://www.cflib.org > that is supposed to be pretty good. > --Ben Doom > [EMAIL PROTECTED] wrote: >> Hi Neal, >> >> Try: >> >> ReReplace(Form.CalloutComments,"<[^>]*>"," ","ALL") >> >> Where 'Form.CalloutComments' is your string. Pretty >> simplistic, but it >> works. I'm sure someone will come up with something >> else..! >> >> -Original Message- >> From: Bailey, Neal [mailto:[EMAIL PROTECTED] >> Sent: 01 March 2004 5:40 pm >> To: CF-Talk >> Subject: Strip HTML from String >> >> Hello everyone... >> >> >> I saw a while back that someone either posted a snippet >> or a link to a tag >> somewhere that would strip out HTML tags from a string. I >> tried looking >> though my e-mail but cant seem to find it, also tried >> looking on a few >> exchanges but they did not do what I needed. >> >> >> Basically if I have a string that looks like this: >> >> >> code to strip >> >> Here is some sample test >> with a >> >> end >> >> >> output of striped code >> Here is some sample test with a link. >> end >> >> >> Thanks for any help... >> >> >> Neal Bailey >> Internet Marketing Manager >> E-mail: [EMAIL PROTECTED] s. isaac dealey 214.823.9345 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.turnkey.to/ontap [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: template reader/parser sort of thing :)
Though you can't compute a taglib path at runtime, it's done at compile time, so that wouldn't of much use if the skinning needs to be dynamic. You'd have to use them the other way (where the template is skin specific, and the tags are the commonn stuff). Cheers, barneyb > -Original Message- > From: Nathan Strutz [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 11:04 AM > To: CF-Talk > Subject: RE: template reader/parser sort of thing :) > > Actually I really like this idea, but modified a bit... > a taglib > of custom display tags, where from depends on the skin you > want to use, then > . > This is native > functionality to coldfusion, and not nearly as much code as > the XSLT samples > given in this thread. > > -nathan strutz > > > -Original Message- > From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] > Sent: Monday, March 01, 2004 7:23 AM > To: CF-Talk > Subject: Re: template reader/parser sort of thing :) > > > To make it a little easier to work with I would suggest > using tag like > syntax instead of comment syntax. > > > > > > Then use regular expressions to parse the page into a > structure replace > your tags with the appropriate data, write the page to disk > or memory, > and then save the unparsed page as a template. > > Ryan Mitchell wrote: > > > Hello > > > > I'm working on a project that i would like to make > skinnable... i'm not > > just talking css skinnable i mean like proper skinnable. > > > > I was wanting to use a file as a template that contained > some variation > > of comments eg <[EMAIL PROTECTED] links ---@> or something to that > effect, which are > > then replaced by finding the appropriate entry in a > structure of items > > to be replaced... > > > > Has anyone done this before? What happens when you have > an arrangement > > like this... > > > > > > > > > > > > > > > > > > > > ie nested bits needing replaced. > > > > Any wise thoughts? Things to watch out for? > > > > Thanks, > > Ryan > > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: template reader/parser sort of thing :)
Actually I really like this idea, but modified a bit... a taglib of custom display tags, where from depends on the skin you want to use, then . This is native functionality to coldfusion, and not nearly as much code as the XSLT samples given in this thread. -nathan strutz -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 7:23 AM To: CF-Talk Subject: Re: template reader/parser sort of thing :) To make it a little easier to work with I would suggest using tag like syntax instead of comment syntax. Then use regular expressions to parse the page into a structure replace your tags with the appropriate data, write the page to disk or memory, and then save the unparsed page as a template. Ryan Mitchell wrote: > Hello > > I'm working on a project that i would like to make skinnable... i'm not > just talking css skinnable i mean like proper skinnable. > > I was wanting to use a file as a template that contained some variation > of comments eg <[EMAIL PROTECTED] links ---@> or something to that effect, which are > then replaced by finding the appropriate entry in a structure of items > to be replaced... > > Has anyone done this before? What happens when you have an arrangement > like this... > > > > > > > > > > ie nested bits needing replaced. > > Any wise thoughts? Things to watch out for? > > Thanks, > Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Separate DB from Server or not
Nice dev box! It depends what you are developing, but for most cases it would be fine to run both SQL and CF on the same box. How many thousands of queries per second you plan to do, if you are warring? Anything under 1000/s of "simple" queries will not harm your server performance. Also, unless you have >25 developers CFMX should not complain. TK -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 1:57 PM To: CF-Talk Subject: RE: Separate DB from Server or not on a dev box it shouldn't be an issue, unless you are really, really hammering the bejesus out of the thing with a thorough load test or somesuch. If you have to buy anything to do this I'd pass until you know you need it. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:14 AM To: CF-Talk Subject: Separate DB from Server or not hey guys, this is my Dev machine configuration 2.8ghz P4 1 gig of RAM and SERIAL ATA 100 hard drives Windows Server 2000 For now, we have SQL Server running on a separate computer. I was wondering whether we should run them on the same server, or on a separate server. Security is not an issue. Performance is. There is alot of info traveling between CF and the database and we don't want to overload the network (I dont even know if it will even get to that), and maybe all that data going back and forth might cause a slight perfomance hit to the app. But also, the server might slow down if both DB and coldfusion are running! How do you have your dev set up? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Strip HTML from String
That should work if you want to remove all HTML. If you want to be more selective, there's a UDF called StripTags by S. Isaac Dealey at http://www.cflib.org that is supposed to be pretty good. --Ben Doom [EMAIL PROTECTED] wrote: > Hi Neal, > > Try: > > ReReplace(Form.CalloutComments,"<[^>]*>"," ","ALL") > > Where 'Form.CalloutComments' is your string. Pretty simplistic, but it > works. I'm sure someone will come up with something else..! > > -Original Message- > From: Bailey, Neal [mailto:[EMAIL PROTECTED] > Sent: 01 March 2004 5:40 pm > To: CF-Talk > Subject: Strip HTML from String > > Hello everyone... > > > I saw a while back that someone either posted a snippet or a link to a tag > somewhere that would strip out HTML tags from a string. I tried looking > though my e-mail but cant seem to find it, also tried looking on a few > exchanges but they did not do what I needed. > > > Basically if I have a string that looks like this: > > > code to strip > > Here is some sample test > with a > > end > > > output of striped code > Here is some sample test with a link. > end > > > Thanks for any help... > > > Neal Bailey > Internet Marketing Manager > E-mail: [EMAIL PROTECTED] > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Separate DB from Server or not
on a dev box it shouldn't be an issue, unless you are really, really hammering the bejesus out of the thing with a thorough load test or somesuch. If you have to buy anything to do this I'd pass until you know you need it. Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:14 AM To: CF-Talk Subject: Separate DB from Server or not hey guys, this is my Dev machine configuration 2.8ghz P4 1 gig of RAM and SERIAL ATA 100 hard drives Windows Server 2000 For now, we have SQL Server running on a separate computer. I was wondering whether we should run them on the same server, or on a separate server. Security is not an issue. Performance is. There is alot of info traveling between CF and the database and we don't want to overload the network (I dont even know if it will even get to that), and maybe all that data going back and forth might cause a slight perfomance hit to the app. But also, the server might slow down if both DB and coldfusion are running! How do you have your dev set up? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
Actually, you'd get a major advantage using a cached query, that is, if the select statement is taking more than about 30ms. In your example below, the select statement would need to be a little more complex, or the "tbl" table would need to have hundreds of thousands or millions of records to make it worthwhile. Cached queries are incredibly fast, but if you want the data to always be up to date, you have to manually refresh the cache when you insert, update or delete data. This is done by setting the cachedwithin timespan to 0. It's rather difficult to keep track of when to refresh the queries, but if you are anal enough to figure it out, you can dramatically speed up your application. By doing this, you only hit the database on the first query or after data has changed. To give you a comparison of times Regular cfquery that averages 200milliseconds 1st time: 200 milliseconds 2nd time: 200 milliseconds 3rd time: 200 milliseconds update data: 10 milliseconds 4th time: 200 milliseconds etc Same cfquery using cachedwithin 1st time: 200 milliseconds 2nd time: ~1 milliseconds 3rd time: ~1 milliseconds update data: 10 milliseconds 4th time: 200 milliseconds << manual refresh 5th time: ~1 milliseconds etc Does that make sense? One thing that i think is in BlueDragon but not in MM CFML is a way to delete the cache as opposed to refreshing it. The difference being that when you do a cachedwithin=#createtimespan(0,0,0,0)# to refresh a query, you're effectively rerunning it. In BD you can just delete the query from memory when you change data. This is a more elegant way of handling it because when data changes in the db, you may not actually need to run the query at the point in time. So you don't force the user to have to wait for the query(ies) to run. Steve David Fafard wrote: > So of I use: > > select x,y,z from tbl where id=1 > select x,y,z from tbl where id=2 > select x,y,z from tbl where id=3 > > where id would be a dynamic variable, > I would not get any benefit in using cached query > but would see a benefit from cfqueryparam ? > > Thanks, > Dave > > - Original Message - > From: Philip Arnold > To: CF-Talk > Sent: Monday, March 01, 2004 12:25 PM > Subject: RE: SQL Multiple Inserts > > > From: Hugo Ahlenius > > > > Cached queries means storing the whole output query variable > > in the cf server memory. CF does not touch the database. The > > query can not have any dynamic variables (The SQL statement > > has to be the same). > > > > Using cfqueryparam improves the caching on the db server side > > (as described before). The cfquery will still need a > > roundtrip to the database. > > > > So the first option is the fastest, but least flexible. > > The cached query is only useful if you're only getting one set of > data, > and it never changes, then the cached query is right > > If you've got loads of variation on the data, for example getting > different records from the database, the CFQUERYPARAM is the way to > go > > Of course, using SPs might be even faster than using CFQUERYPARAM, > as > long as your queries are never going to change > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: CF render of CSS
It is probably the # that is the problem, CF is looking for a matching # and is finding the { (which it does not like). Escape the # as ##. ##back { } --- Ben _ From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 1:17 PM To: CF-Talk Subject: CF render of CSS This is my first Cold Fusion project. I have a server that won't mix HTML and CF. It's not my server and that's just the case. So in order to have HTML, I have to embed it in the cfoutput. It seems to work fine with html. Unfortunately, I also have CSS and when I put that in the cfoutput, it won't process the output. It complains about an invalid character. The invalid character is the { } that I use in the div declaration. I still need the CSS, so what should I do with this? I've tried escaping it and changing it to a { which it then complains about those characters. Maybe the question is "how do you output special characters"? The CSs code is: #back { } I was just told that maybe I can put it in a var and then use the var, but I'm not even there yet. Also, I get this list digested, so if you could cc me, that'd be great. thanks for your help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CF render of CSS
This is my first Cold Fusion project. I have a server that won't mix HTML and CF. It's not my server and that's just the case. So in order to have HTML, I have to embed it in the cfoutput. It seems to work fine with html. Unfortunately, I also have CSS and when I put that in the cfoutput, it won't process the output. It complains about an invalid character. The invalid character is the { } that I use in the div declaration. I still need the CSS, so what should I do with this? I've tried escaping it and changing it to a { which it then complains about those characters. Maybe the question is "how do you output special characters"? The CSs code is: #back { } I was just told that maybe I can put it in a var and then use the var, but I'm not even there yet. Also, I get this list digested, so if you could cc me, that'd be great. thanks for your help. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Encrypt
Hi Does anyone know how I can encrypt my source code in CFMX. Also after encrypting when I do the modification do I need to encrypt the whole folder or it would be the only modified files? Thanks Shaz ** This email and any files transmitted with it are confidential and intended solely for use by the individual or entity to whom it is addressed. If you have received this e-mail in error, kindly notify [EMAIL PROTECTED] or call +44 1992 701 704. Unless stated otherwise, please note that any views or opinions expressed in this e-mail are solely that of the author and are not necessarily of JJ Fast Food Distribution Limited. The company can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. The company accepts no liability for any damage caused by this email. JJ Fast Food Distribution Limited reserves the right to monitor and or record e-mail without prior notification. ** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Strip HTML from String
Hi Neal, Try: ReReplace(Form.CalloutComments,"<[^>]*>"," ","ALL") Where 'Form.CalloutComments' is your string. Pretty simplistic, but it works. I'm sure someone will come up with something else..! -Original Message- From: Bailey, Neal [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 5:40 pm To: CF-Talk Subject: Strip HTML from String Hello everyone... I saw a while back that someone either posted a snippet or a link to a tag somewhere that would strip out HTML tags from a string. I tried looking though my e-mail but cant seem to find it, also tried looking on a few exchanges but they did not do what I needed. Basically if I have a string that looks like this: code to strip Here is some sample test with a end output of striped code Here is some sample test with a link. end Thanks for any help... Neal Bailey Internet Marketing Manager E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
> From: David Fafard > > So of I use: > > select x,y,z from tbl where id=1 > select x,y,z from tbl where id=2 > select x,y,z from tbl where id=3 > > where id would be a dynamic variable, > I would not get any benefit in using cached query > but would see a benefit from cfqueryparam ? How many variations on ID? How much data is coming back? In this instance, I'd use a CFQUERYPARAM as you know that the ID is changing BUT - if you only have 3 variations on ID, then it might be worth caching the query Next you get into the question of HOW to cache the query If you use CACHEDWITHIN or CACHEDAFTER then you can't use CFQUERYPARAM But if you store the results into another scope, like Application, then you can use CFQUERYPARAM to your heart's content :) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Strip HTML from String
Hello everyone... I saw a while back that someone either posted a snippet or a link to a tag somewhere that would strip out HTML tags from a string. I tried looking though my e-mail but cant seem to find it, also tried looking on a few exchanges but they did not do what I needed. Basically if I have a string that looks like this: code to strip Here is some sample test with a end output of striped code Here is some sample test with a link. end Thanks for any help... Neal Bailey Internet Marketing Manager E-mail: [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: OT: How is this possible?
It looks like MS came up with their own _javascript_ method for IE5.5 and up. How nice of them. :-| http://msdn.microsoft.com/workshop/author/dhtml/reference/objects/popup.asp http://msdn.microsoft.com/workshop/author/dhtml/reference/methods/createpopup.asp Jim McAtee wrote: > > Of course I am - latest IE 6.whatever with current patches. Doesn't > even run > in Firebird. Interestingly, in IE the status bar show a _javascript_ > error. I > wonder if the script takes advantage of a known problem with error > handling > in IE to escape the boundaries of the browser. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
So of I use: select x,y,z from tbl where id=1 select x,y,z from tbl where id=2 select x,y,z from tbl where id=3 where id would be a dynamic variable, I would not get any benefit in using cached query but would see a benefit from cfqueryparam ? Thanks, Dave - Original Message - From: Philip Arnold To: CF-Talk Sent: Monday, March 01, 2004 12:25 PM Subject: RE: SQL Multiple Inserts > From: Hugo Ahlenius > > Cached queries means storing the whole output query variable > in the cf server memory. CF does not touch the database. The > query can not have any dynamic variables (The SQL statement > has to be the same). > > Using cfqueryparam improves the caching on the db server side > (as described before). The cfquery will still need a > roundtrip to the database. > > So the first option is the fastest, but least flexible. The cached query is only useful if you're only getting one set of data, and it never changes, then the cached query is right If you've got loads of variation on the data, for example getting different records from the database, the CFQUERYPARAM is the way to go Of course, using SPs might be even faster than using CFQUERYPARAM, as long as your queries are never going to change [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Separate DB from Server or not
Buy two gigabit network cards, and attach the sql server directly to the cf machine. Problem solved. But since this is a dev machine, a presumably doesn't get too much traffic, I don't think you need to worry about it at all. - Original Message - From: brobborb <[EMAIL PROTECTED]> Date: Monday, March 1, 2004 10:14 am Subject: Separate DB from Server or not > hey guys, this is my Dev machine configuration > > 2.8ghz P4 > 1 gig of RAM > and SERIAL ATA 100 hard drives > Windows Server 2000 > > For now, we have SQL Server running on a separate computer. I was > wondering whether we should run them on the same server, or on a > separate server. Security is not an issue. Performance is. > There is alot of info traveling between CF and the database and we > don't want to overload the network (I dont even know if it will > even get to that), and maybe all that data going back and forth > might cause a slight perfomance hit to the app. > > But also, the server might slow down if both DB and coldfusion are > running! How do you have your dev set up? > > Thanks > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]