Re: Why i need use XML with CF
On Saturday 28 Feb 2004 23:48 pm, Gregory Harris wrote: The real power behind XML is it's portableness and platform independence. :nods We have an XML file that defines all the parameters users neeed to enter into our application, and this is used to generate a GUI in both ColdFusion and Delphi - it rocks quite a lot, if I do say so myself :-) However, if you're building an application in ColdFusion that is strictly in house and can do something more efficiently in data transfer without XML, why bother? :nods again Why use a buzzword just for the sake of it ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cell phone text messaging...
On Saturday 28 Feb 2004 14:53 pm, Burns, John wrote: Right, but by only giving AOL 3018675309, how does it know that it should be sent to SprintPCS? Or maybe ATT, T-mobile, Cingular, Verizon, etc? The message is just sent to whoever mobile operator the provider is connected to, and they then forward it on just as if you had entered the number into a mobile phone. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Detecting Images with Digital Rights
On Friday 27 Feb 2004 19:21 pm, John Blayter wrote: Does anyone know of a product or service that checks an image to see if it is protected by Digital Rights? Short answer: No - there is no standard for DRM, so no standard way to check. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SOT: SQL Multiple Inserts
Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
I've often wonder at what point Bulk Insert becomes an advantage. I imagine the drawback with bulk insert is that it has to read an actual file versus read from ram. It seems that for a small number of records a regular insert would be faster. Has anyone done any comparisons between bulk insert versus regular insert? Steve Nelson Robertson-Ravo, Neil (RX) wrote: Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
cfx_getimage for linux?
is there any equivelant of cfx_getimage and cfx_putimage for use under a linux server? Thanks the.exquisite team [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
From: brobborb Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? I've not tested with JDBC, but with ODBC there is a limit to how much you can pass to the SQL engine in one go But in answer to your question - it's a LOT quicker to do it in less CFQUERY tags as you're passing the load to the database and letting it do it's job rather than saying Here is one item, here is another, and another Where are the inserts coming from? If they're from another table, then you should look at letting the database handle the inserts the best way it can You've also not said which DB Engine [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getimage for linux?
On Monday 01 Mar 2004 12:09 pm, mark taylor wrote: is there any equivelant of cfx_getimage and cfx_putimage for use under a Probably. What do they do ? Can you use cfexecute ? -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
From: Robertson-Ravo, Neil (RX) Stored Procedure : BULK INSERT. This really depends - if you're inserting data from another table, then it's a lot easier to do a INSERT INTO SELECT FROM Also, if he's running Access *spit* then doing SPs is impossible [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
Here's what i thought about stored procedure.I thought they are only useful when the SQL query isn't dynamic, like SELECT * from tbl_images.But if it's something like SELECT * from tbl_images where project_id = 30, then a stored procedure is not beneficial, because it's essentially a different query every time. Is this correct?My queries are like the latter. - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 6:14 AM Subject: RE: SQL Multiple Inserts Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
I have just tested this myself and I am very happy! 308 milliseconds vs. 1590 milliseconds (the numbers were something like that) This is alot of time saved since the actual application will do 10 times the amount of row inserts. - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:00 AM Subject: Re: SQL Multiple Inserts I've often wonder at what point Bulk Insert becomes an advantage. I imagine the drawback with bulk insert is that it has to read an actual file versus read from ram. It seems that for a small number of records a regular insert would be faster. Has anyone done any comparisons between bulk insert versus regular insert? Steve Nelson Robertson-Ravo, Neil (RX) wrote: Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
True, true.also Bulk Inserts are not entered into the Transaction Logif on MSSQL _ From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:28 To: CF-Talk Subject: RE: SQL Multiple Inserts From: Robertson-Ravo, Neil (RX) Stored Procedure : BULK INSERT. This really depends - if you're inserting data from another table, then it's a lot easier to do a INSERT INTO SELECT FROM Also, if he's running Access *spit* then doing SPs is impossible _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
No, thats the whole point of a stored procedure...you pass it in variables and it does the processing _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:32 To: CF-Talk Subject: Re: SQL Multiple Inserts Here's what i thought about stored procedure.I thought they are only useful when the SQL query isn't dynamic, like SELECT * from tbl_images.But if it's something like SELECT * from tbl_images where project_id = 30, then a stored procedure is not beneficial, because it's essentially a different query every time. Is this correct?My queries are like the latter. - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 6:14 AM Subject: RE: SQL Multiple Inserts Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
Really?There's a limit?What is it?hmmm.Me sets loop to 50,000 :D it took it!16203 milliseconds! however, at 100,000 inserts, it took 57333 milliseconds.Maybe cos mys erver is crapping out.It seems like doing 2x 50,000 inserts is alot faster than 1 100,000 inserts! 50,000 should be more than enuff! - Original Message - From: Philip Arnold To: CF-Talk Sent: Monday, March 01, 2004 7:12 AM Subject: RE: SQL Multiple Inserts From: brobborb Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? I've not tested with JDBC, but with ODBC there is a limit to how much you can pass to the SQL engine in one go But in answer to your question - it's a LOT quicker to do it in less CFQUERY tags as you're passing the load to the database and letting it do it's job rather than saying Here is one item, here is another, and another Where are the inserts coming from? If they're from another table, then you should look at letting the database handle the inserts the best way it can You've also not said which DB Engine [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
Just out of pure curiosity, can you try reducing the number of records until the processing time is about equivalent? Maybe we can figure out a very simple rule of thumb, like If there are more than 100 records, use bulk insert, otherwise use a regular insert. Hell, it might be if there are more than 2 records... :-) Steve Nelson brobborb wrote: I have just tested this myself and I am very happy! 308 milliseconds vs. 1590 milliseconds (the numbers were something like that) This is alot of time saved since the actual application will do 10 times the amount of row inserts. - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:00 AM Subject: Re: SQL Multiple Inserts I've often wonder at what point Bulk Insert becomes an advantage. I imagine the drawback with bulk insert is that it has to read an actual file versus read from ram. It seems that for a small number of records a regular insert would be faster. Has anyone done any comparisons between bulk insert versus regular insert? Steve Nelson Robertson-Ravo, Neil (RX) wrote: Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
But will it help in terms of performance? My understanding is that Stored Procedures are cached queries.But if the query you use has different variable values everytime, then it's just like using a new query.no performance benefit.But if this is not the case, the I would totally use a stored procedure for this part!! - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 7:34 AM Subject: RE: SQL Multiple Inserts No, thats the whole point of a stored procedure...you pass it in variables and it does the processing _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:32 To: CF-Talk Subject: Re: SQL Multiple Inserts Here's what i thought about stored procedure.I thought they are only useful when the SQL query isn't dynamic, like SELECT * from tbl_images.But if it's something like SELECT * from tbl_images where project_id = 30, then a stored procedure is not beneficial, because it's essentially a different query every time. Is this correct?My queries are like the latter. - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 6:14 AM Subject: RE: SQL Multiple Inserts Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL Brainblock
Hi All, I am having trouble with an iif in SQL and was wondering if someone could help me with the syntax. here is one line of my query. Round(((sum(ORIG_BAL) -Sum(wo_amount)) / sum(ORIG_BAL)) * 100,0) as SalvageCollected What I would like is to display a zero if the value is null or a zero but I keep getting errors in syntax, I know that this is possible I am just getting lost in my braces. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
I did 2x 50,000 records insert:one using multiple inserts, the other by looping the query 50,000 times. 16 seconds vs 61 seconds, respectively. Forget the conditionals!Multiple Inserts yay! - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:43 AM Subject: Re: SQL Multiple Inserts Just out of pure curiosity, can you try reducing the number of records until the processing time is about equivalent? Maybe we can figure out a very simple rule of thumb, like If there are more than 100 records, use bulk insert, otherwise use a regular insert. Hell, it might be if there are more than 2 records... :-) Steve Nelson brobborb wrote: I have just tested this myself and I am very happy! 308 milliseconds vs. 1590 milliseconds (the numbers were something like that) This is alot of time saved since the actual application will do 10 times the amount of row inserts. - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:00 AM Subject: Re: SQL Multiple Inserts I've often wonder at what point Bulk Insert becomes an advantage. I imagine the drawback with bulk insert is that it has to read an actual file versus read from ram. It seems that for a small number of records a regular insert would be faster. Has anyone done any comparisons between bulk insert versus regular insert? Steve Nelson Robertson-Ravo, Neil (RX) wrote: Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
In theory an SP should be faster no matter... _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:47 To: CF-Talk Subject: Re: SQL Multiple Inserts But will it help in terms of performance? My understanding is that Stored Procedures are cached queries.But if the query you use has different variable values everytime, then it's just like using a new query.no performance benefit.But if this is not the case, the I would totally use a stored procedure for this part!! - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 7:34 AM Subject: RE: SQL Multiple Inserts No, thats the whole point of a stored procedure...you pass it in variables and it does the processing _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:32 To: CF-Talk Subject: Re: SQL Multiple Inserts Here's what i thought about stored procedure.I thought they are only useful when the SQL query isn't dynamic, like SELECT * from tbl_images. But if it's something like SELECT * from tbl_images where project_id = 30, then a stored procedure is not beneficial, because it's essentially a different query every time. Is this correct?My queries are like the latter. - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 6:14 AM Subject: RE: SQL Multiple Inserts Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT-CSS list of quality
Hi All, I was wondering if someone could recommend a good list for CSS, a list like this one would be great were there are experienced people that don't snub beginners. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: cfx_getimage for linux?
mark taylor wrote: is there any equivelant of cfx_getimage and cfx_putimage for use under a linux server? You know that you can't install M$ SQL Server on Linux, right??... ;o) I would suggest that if you have a remote database server, then it would be more appropriate to store your images on the linux server and only a reference in the database.(I have to say that this is my view re: storing files in DATAbases) Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
Hey question.When you do an INSERT statement, does SQL still return a resultset?Or does that only happen with SELECT statements? - Original Message - From: Philip Arnold To: CF-Talk Sent: Monday, March 01, 2004 7:28 AM Subject: RE: SQL Multiple Inserts From: Robertson-Ravo, Neil (RX) Stored Procedure : BULK INSERT. This really depends - if you're inserting data from another table, then it's a lot easier to do a INSERT INTO SELECT FROM Also, if he's running Access *spit* then doing SPs is impossible [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
Did you add the 50,000 cffile writes? Or loop 50,000 times to create the data in one variable, then do a single cffile write? Don't you have to write to a file first, then perform the bulk insert on the file? I imagine that would make a pretty major difference. Steve Nelson brobborb wrote: I did 2x 50,000 records insert:one using multiple inserts, the other by looping the query 50,000 times. 16 seconds vs 61 seconds, respectively. Forget the conditionals!Multiple Inserts yay! - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:43 AM Subject: Re: SQL Multiple Inserts Just out of pure curiosity, can you try reducing the number of records until the processing time is about equivalent? Maybe we can figure out a very simple rule of thumb, like If there are more than 100 records, use bulk insert, otherwise use a regular insert. Hell, it might be if there are more than 2 records... :-) Steve Nelson brobborb wrote: I have just tested this myself and I am very happy! 308 milliseconds vs. 1590 milliseconds (the numbers were something like that) This is alot of time saved since the actual application will do 10 times the amount of row inserts. - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:00 AM Subject: Re: SQL Multiple Inserts I've often wonder at what point Bulk Insert becomes an advantage. I imagine the drawback with bulk insert is that it has to read an actual file versus read from ram. It seems that for a small number of records a regular insert would be faster. Has anyone done any comparisons between bulk insert versus regular insert? Steve Nelson Robertson-Ravo, Neil (RX) wrote: Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
the way it works is it gets the name of all the images in a diretory/and all subdirectories, and inserts them into the database.I'm not writing to a file or anything.Or are you talking about something else? - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 8:02 AM Subject: Re: SQL Multiple Inserts Did you add the 50,000 cffile writes? Or loop 50,000 times to create the data in one variable, then do a single cffile write? Don't you have to write to a file first, then perform the bulk insert on the file? I imagine that would make a pretty major difference. Steve Nelson brobborb wrote: I did 2x 50,000 records insert:one using multiple inserts, the other by looping the query 50,000 times. 16 seconds vs 61 seconds, respectively. Forget the conditionals!Multiple Inserts yay! - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:43 AM Subject: Re: SQL Multiple Inserts Just out of pure curiosity, can you try reducing the number of records until the processing time is about equivalent? Maybe we can figure out a very simple rule of thumb, like If there are more than 100 records, use bulk insert, otherwise use a regular insert. Hell, it might be if there are more than 2 records... :-) Steve Nelson brobborb wrote: I have just tested this myself and I am very happy! 308 milliseconds vs. 1590 milliseconds (the numbers were something like that) This is alot of time saved since the actual application will do 10 times the amount of row inserts. - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:00 AM Subject: Re: SQL Multiple Inserts I've often wonder at what point Bulk Insert becomes an advantage. I imagine the drawback with bulk insert is that it has to read an actual file versus read from ram. It seems that for a small number of records a regular insert would be faster. Has anyone done any comparisons between bulk insert versus regular insert? Steve Nelson Robertson-Ravo, Neil (RX) wrote: Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts (LIMIT)
I have found the limit.It is 456.Even though i did 50,000 INSERTS in one query, SQL Server only took 456.Bummer.On well.Doing Round((50,000/456)) queries is alot faster than doing 50,000 queries ehehe - Original Message - From: brobborb To: CF-Talk Sent: Monday, March 01, 2004 7:43 AM Subject: Re: SQL Multiple Inserts Really?There's a limit?What is it?hmmm.Me sets loop to 50,000 :D it took it!16203 milliseconds! however, at 100,000 inserts, it took 57333 milliseconds.Maybe cos mys erver is crapping out.It seems like doing 2x 50,000 inserts is alot faster than 1 100,000 inserts! 50,000 should be more than enuff! - Original Message - From: Philip Arnold To: CF-Talk Sent: Monday, March 01, 2004 7:12 AM Subject: RE: SQL Multiple Inserts From: brobborb Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? I've not tested with JDBC, but with ODBC there is a limit to how much you can pass to the SQL engine in one go But in answer to your question - it's a LOT quicker to do it in less CFQUERY tags as you're passing the load to the database and letting it do it's job rather than saying Here is one item, here is another, and another Where are the inserts coming from? If they're from another table, then you should look at letting the database handle the inserts the best way it can You've also not said which DB Engine [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: OT-CSS list of quality
I've learned a lot from the mailing list at http://www.css-discuss.org/. I've had to unsubscribe lately because of the sheer volume of messages.The moderator, Eric Meyer from Netscape fame, does a good job of keeping it on topic. -- marlon And Bobby you are right, I am being selfish, but the last time I checked, we don't have a whole lot of songs that feature the cowbell! -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 7:53 AM To: CF-Talk Subject: OT-CSS list of quality Hi All, I was wondering if someone could recommend a good list for CSS, a list like this one would be great were there are experienced people that don't snub beginners. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
Hmmm, maybe. I haven't used bulk insert in a couple years. This is the syntax I've used before: BULK INSERT SomeTable FROM 'c:\temp\filetoinsert.txt' WITH (FIELDTERMINATOR = '|', ROWTERMINATOR = '~') So I figured you'd have to write the 50,000 records to c:\temp\filetoinsert.txt (i.e. any file) What syntax are you using? Steve Nelson brobborb wrote: the way it works is it gets the name of all the images in a diretory/and all subdirectories, and inserts them into the database. I'm not writing to a file or anything.Or are you talking about something else? - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 8:02 AM Subject: Re: SQL Multiple Inserts Did you add the 50,000 cffile writes? Or loop 50,000 times to create the data in one variable, then do a single cffile write? Don't you have to write to a file first, then perform the bulk insert on the file? I imagine that would make a pretty major difference. Steve Nelson brobborb wrote: I did 2x 50,000 records insert:one using multiple inserts, the other by looping the query 50,000 times. 16 seconds vs 61 seconds, respectively. Forget the conditionals!Multiple Inserts yay! - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:43 AM Subject: Re: SQL Multiple Inserts Just out of pure curiosity, can you try reducing the number of records until the processing time is about equivalent? Maybe we can figure out a very simple rule of thumb, like If there are more than 100 records, use bulk insert, otherwise use a regular insert. Hell, it might be if there are more than 2 records... :-) Steve Nelson brobborb wrote: I have just tested this myself and I am very happy! 308 milliseconds vs. 1590 milliseconds (the numbers were something like that) This is alot of time saved since the actual application will do 10 times the amount of row inserts. - Original Message - From: Steve Nelson To: CF-Talk Sent: Monday, March 01, 2004 7:00 AM Subject: Re: SQL Multiple Inserts I've often wonder at what point Bulk Insert becomes an advantage. I imagine the drawback with bulk insert is that it has to read an actual file versus read from ram. It seems that for a small number of records a regular insert would be faster. Has anyone done any comparisons between bulk insert versus regular insert? Steve Nelson Robertson-Ravo, Neil (RX) wrote: Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: template reader/parser sort of thing :)
Have you seen the contentVariables in Fusebox 4? It handles this type of skinning for you. If you want it db driven, you could just write a script to write out the appropriate fb4 xml. Steve Nelson 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... !---@ begin links @--- !---@ main links @--- !---@ end main links @--- !---@ end links @--- 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 :)
To make it a little easier to work with I would suggest using tag like syntax instead of comment syntax. ?mytags:link? ?mytags:link main=1 /? ?mytags:link? 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... !---@ begin links @--- !---@ main links @--- !---@ end main links @--- !---@ end links @--- 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 :)
I recommend that you use XML to do the templating, and XSLT to apply the styles to your templated files.This is closer to an industry-adopted standard instead of some sort of hand-coded solution. Why reinvent the wheel? -dov _ From: Ryan Mitchell [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:15 AM To: CF-Talk Subject: template reader/parser sort of thing :) 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... !---@ begin links @--- !---@ main links @--- !---@ end main links @--- !---@ end links @--- 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: SQL Multiple Inserts
Something like
cfquery datasource=#dsn# name=name
cfloop index=index query=cfdirectory_query
INSERT INTO testy (name, a, b, c, d, e, f, g) VALUES ('#name#', 'other stuff', 'a', 'a', 'a', 'a', 'a', 'a')
/cfloop
/cfquery
The problem is that even though the query goes through and the page gets processed, SQL Server only actually accepts 456 rows!So I will try using your syntax :)
- Original Message -
From: Steve Nelson
To: CF-Talk
Sent: Monday, March 01, 2004 8:15 AM
Subject: Re: SQL Multiple Inserts
Hmmm, maybe. I haven't used bulk insert in a couple years. This is the
syntax I've used before:
BULK INSERT SomeTable
FROM 'c:\temp\filetoinsert.txt'
WITH
(FIELDTERMINATOR = '|',
ROWTERMINATOR = '~')
So I figured you'd have to write the 50,000 records to
c:\temp\filetoinsert.txt (i.e. any file)
What syntax are you using?
Steve Nelson
brobborb wrote:
the way it works is it gets the name of all the images in a
diretory/and all subdirectories, and inserts them into the database.
I'm not writing to a file or anything.Or are you talking about
something else?
- Original Message -
From: Steve Nelson
To: CF-Talk
Sent: Monday, March 01, 2004 8:02 AM
Subject: Re: SQL Multiple Inserts
Did you add the 50,000 cffile writes? Or loop 50,000 times to create
the
data in one variable, then do a single cffile write? Don't you have
to
write to a file first, then perform the bulk insert on the file? I
imagine that would make a pretty major difference.
Steve Nelson
brobborb wrote:
I did 2x 50,000 records insert:one using multiple inserts, the
other
by looping the query 50,000 times.
16 seconds vs 61 seconds, respectively.
Forget the conditionals!Multiple Inserts yay!
- Original Message -
From: Steve Nelson
To: CF-Talk
Sent: Monday, March 01, 2004 7:43 AM
Subject: Re: SQL Multiple Inserts
Just out of pure curiosity, can you try reducing the number of
records
until the processing time is about equivalent? Maybe we can
figure
out a
very simple rule of thumb, like If there are more than 100
records,
use
bulk insert, otherwise use a regular insert. Hell, it might be
if
there are more than 2 records... :-)
Steve Nelson
brobborb wrote:
I have just tested this myself and I am very happy!
308 milliseconds vs. 1590 milliseconds (the numbers were
something
like that)
This is alot of time saved since the actual application will
do 10
times the amount of row inserts.
- Original Message -
From: Steve Nelson
To: CF-Talk
Sent: Monday, March 01, 2004 7:00 AM
Subject: Re: SQL Multiple Inserts
I've often wonder at what point Bulk Insert becomes an
advantage. I
imagine the drawback with bulk insert is that it has to read
an
actual
file versus read from ram. It seems that for a small number
of
records a
regular insert would be faster.
Has anyone done any comparisons between bulk insert versus
regular
insert?
Steve Nelson
Robertson-Ravo, Neil (RX) wrote:
Stored Procedure : BULK INSERT.
_
From: brobborb [mailto:[EMAIL PROTECTED]
Sent: 01 March 2004 12:16
To: CF-Talk
Subject: SOT: SQL Multiple Inserts
Hey guys, let's say I have to insert like 5,000 rows of
data
with
the
click
of a button in my app.Would it be alot faster to insert
all
5,000 in
one
CFQuery with multiple inserts?Right now it is just one
query
looped
5,000
times.
Also are there any drawbacks with using multplie inserts?
Thanks
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: template reader/parser sort of thing :)
I concur with dov -- CFMX has built in XMLTransform functions for doing
all this stuff right in XML which means the designs are much more
portable and stuff -- XSLT is very flexible -- the only pain in the butt
is filling in form element values which I do with _javascript_.I
actually wrote a function for doing this find-replace action after the
XML transform.Here's an example for doing the whole thing [also
attached in example.cfm for convenience]
// begin example.cfm
// begin example.cfm
// begin example.cfm
// begin example.cfm
!--- create the XML Object containing the person's information ---
cfxml variable=personXMLObj
person
name
firstgt;Joe/first
lastO'Shmoe/last
/name
sexMale/sex
birthday2/20/1975/birthday
/person
/cfxml
!--- create teh XSL template to display the person's information ---
cfsavecontent variable=personXSL
xsl:stylesheet version=1.0
xmlns:xsl=http://www.w3.org/1999/XSL/Transform
xsl:template match=/
script
var
firstName='post-xsl:jsstringformatxsl:value-of
select=person/name/first //post-xsl:jsstringformat';
var
lastName='post-xsl:jsstringformatxsl:value-of
select=person/name/last //post-xsl:jsstringformat';
/script
form name=myForm action="">
method=post
table border=1 cellpadding=3
cellspacing=0
tr align=left valign=top
tdbPerson's Name:/b/td
tdi
input name=firstName
type=text value= /
input name=lastName
type=text value= /
/i/td
/tr
/table
/form
script
document.forms.myForm.firstName.value=firstName;
document.forms.myForm.lastName.value=lastName;
/script
/xsl:template
/xsl:stylesheet
/cfsavecontent
!--- this is the function for encoding post-xsl:jsstringformat tag
content ---
cffunction name=PostXSL_JSStringFormat access=private
returntype=string
cfargument name=sourceContent type=string required=yes
cfscript
var content=sourceContent;
var contentLeft='';
var contentRight='';
var openTag='post-xsl:jsstringformat';
var openTagIndex=1;
var closeTag='/post-xsl:jsstringformat';
var closeTagIndex=0;
var tagContent='';
var tagContentLen=0;
while(openTagIndex LT Len(content)) {
openTagIndex=FindNoCase(openTag,content,openTagIndex);
if(openTagIndex EQ 0) {
openTagIndex=Len(content);
}
else {
closeTagIndex=FindNoCase(closeTag,content,openTagIndex);
if(closeTagIndex EQ 0) {
openTagIndex=Len(content);
}
else {
tagContentLen=closeTagIndex-(openTagIndex+Len(openTag));
if(tagContentLen GT 0) {
tagContent=Mid(content,openTagIndex+Len(openTag),tagContentLen);
tagContent=JSStringFormat(tagContent);
}
else {
tagContent='';
}
if(openTagIndex GT 1) {
contentLeft=Left(content,openTagIndex-1);
}
else {
contentLeft='';
}
if((closeTagIndex+Len(closeTag)-1) LT Len(content)) {
contentRight=Right(content,Len(content)-(closeTagIndex+Len(closeTag)-1))
;
}
else {
contentRight='';
}
content=contentLeft tagContent
contentRight;
openTagIndex=openTagIndex+1;
}
}
}
/cfscript
cfreturn content
/cffunction
!--- this is the wrapper function for post-xsl:* tags ---
cffunction name=PostXSL access=private returntype=string
cfargument name=sourceContent type=string required=yes
cfscript
var content=sourceContent;
content=PostXSL_JSStringFormat(content);
content=ReplaceNoCase(content,'?xml version=1.0
encoding=UTF-8?','','ALL');
/cfscript
cfreturn content
/cffunction
!--- this is the demo of it all in action ---
cfset personXHTML=PostXSL(XMLTransform(personXMLObj,personXSL))
cfoutput
html
head
titlesome page/title
/head
body
#personXHTML#
/body
/html
/cfoutput
// end example.cfm //
// end example.cfm //
// end example.cfm //
// end example.cfm //
-Original Message-
From: Katz, Dov B (IT) [mailto:[EMAIL PROTECTED]
Sent: Monday, March 01, 2004 8:27 AM
To: CF-Talk
Subject: RE: template reader/parser sort of thing :)
I recommend that you use XML to do the templating, and XSLT to apply the
styles to your templated files.This is closer to an industry-adopted
standard instead of some sort of hand-coded solution. Why reinvent the
wheel?
-dov
_
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
Sent: Monday, March 01, 2004 9:15 AM
To: CF-Talk
Subject: template reader/parser sort of thing :)
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
RE: Cell phone text messaging...
But how does AOL know which provider the user has?When you set it up, they don't ask what carrier you have.All you enter is your phone number. John Burns -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 6:13 AM To: CF-Talk Subject: Re: Cell phone text messaging... On Saturday 28 Feb 2004 14:53 pm, Burns, John wrote: Right, but by only giving AOL 3018675309, how does it know that it should be sent to SprintPCS? Or maybe ATT, T-mobile, Cingular, Verizon, etc? The message is just sent to whoever mobile operator the provider is connected to, and they then forward it on just as if you had entered the number into a mobile phone. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
From: brobborb
Something like
cfquery datasource=#dsn# name=name
cfloop index=index query=cfdirectory_query
INSERT INTO testy (name, a, b, c, d, e, f, g) VALUES
('#name#', 'other stuff', 'a', 'a', 'a', 'a', 'a', 'a')
/cfloop
/cfquery
The problem is that even though the query goes through and
the page gets processed, SQL Server only actually accepts 456
rows!So I will try using your syntax :)
Can you try the #name# in a CFQUERYPARAM - it should give you more
space as it's a parameter and not part of the SQL
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: SQL Brainblock
what db? you would do it with nvl(act_val, val_if_null) in oracle (i think :-) -- dc -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:50 To: CF-Talk Subject: SQL Brainblock Hi All, I am having trouble with an iif in SQL and was wondering if someone could help me with the syntax. here is one line of my query. Round(((sum(ORIG_BAL) -Sum(wo_amount)) / sum(ORIG_BAL)) * 100,0) as SalvageCollected What I would like is to display a zero if the value is null or a zero but I keep getting errors in syntax, I know that this is possible I am just getting lost in my braces. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cell phone text messaging...
Burns, John wrote: But how does AOL know which provider the user has?When you set it up, they don't ask what carrier you have.All you enter is your phone number. If you dial a phone number, do you have to specify which carrier the phone number is on, or does the phone company find that out for you? Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Brainblock
ISNULL(field, Value if Null) in MS SQL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 8:29 AM To: CF-Talk Subject: RE: SQL Brainblock what db? you would do it with nvl(act_val, val_if_null) in oracle (i think :-) -- dc -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:50 To: CF-Talk Subject: SQL Brainblock Hi All, I am having trouble with an iif in SQL and was wondering if someone could help me with the syntax. here is one line of my query. Round(((sum(ORIG_BAL) -Sum(wo_amount)) / sum(ORIG_BAL)) * 100,0) as SalvageCollected What I would like is to display a zero if the value is null or a zero but I keep getting errors in syntax, I know that this is possible I am just getting lost in my braces. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Cell phone text messaging...
I use a company that enables me to send messages to my customers, i don't need to know which carrier they are with.If they respond however the company i use tells me who the carrier is. AOL probably uses an intermediary company also.These intermediary companies have agreements with all the providers... when a text message is sent it comes with a header which would say which network the customer is on.Then, this middle company can send it on to you. Or vice versa. I use http://www.eplcommunications.com in the UK. HTH -- Original Message -- From: Burns, John [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date:Mon, 1 Mar 2004 09:48:44 -0500 But how does AOL know which provider the user has?When you set it up, they don't ask what carrier you have.All you enter is your phone number. John Burns -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 6:13 AM To: CF-Talk Subject: Re: Cell phone text messaging... On Saturday 28 Feb 2004 14:53 pm, Burns, John wrote: Right, but by only giving AOL 3018675309, how does it know that it should be sent to SprintPCS? Or maybe ATT, T-mobile, Cingular, Verizon, etc? The message is just sent to whoever mobile operator the provider is connected to, and they then forward it on just as if you had entered the number into a mobile phone. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: template reader/parser sort of thing :)
ok, i would prefer not to do it this way.. basically among other ideas i would love to convert phpbb over to coldfusion.. i've been working on it for a while, and now i've come to the reading and parsing of the template files... i want to be able to read in phpbb template files and so xlst/xml won't work. my main problem comes with nested replacements... how do you do it? TIA, Ryan [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Brainblock
I am using Access - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Monday, March 01, 2004 9:28 AM Subject: RE: SQL Brainblock what db? you would do it with nvl(act_val, val_if_null) in oracle (i think :-) -- dc -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:50 To: CF-Talk Subject: SQL Brainblock Hi All, I am having trouble with an iif in SQL and was wondering if someone could help me with the syntax. here is one line of my query. Round(((sum(ORIG_BAL) -Sum(wo_amount)) / sum(ORIG_BAL)) * 100,0) as SalvageCollected What I would like is to display a zero if the value is null or a zero but I keep getting errors in syntax, I know that this is possible I am just getting lost in my braces. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access Coldfusion MX6.1 problems...sites keep dying
Jochem, I tried looking for the unicode driver in the drop down, but all that is listed is Access.The dropdown you are talking about is on the CFA Datasources page right (Add datasource above a listing of all the current datasources). Steve -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 12:15 PM To: CF-Talk Subject: Re: Access Coldfusion MX6.1 problems...sites keep dying Josen Ruiseco wrote: Is the unicode driver just useful for Access or will it stabilize Sql Server 2000 also? Where can it be found? Access only, and it is just in the dropdown menu. For MS SQL Server, use the JDBC driver from Microsoft. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Access Coldfusion MX6.1 problems...sites keep dying
DURETTE, STEVEN J (AIT) wrote: I tried looking for the unicode driver in the drop down, but all that is listed is Access.The dropdown you are talking about is on the CFA Datasources page right (Add datasource above a listing of all the current datasources). Should be there: http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/dataso11.htm#wp1255395 Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Multiple Inserts
Stored procedures are not cached queries - they are compiled execution plans. The thing that makes the difference is the databinding. SQL knows what type a variable is prior to execution of the query. So it does not have to check in the system tables to see what type it should be using.For example, if you do the following: select * from mytable where user_id = 2 SQL doesn't know A) what the column names are and B) what datatype your 2 is.So first it looks in the system tables for that db and says, give me all the columns, which it uses for select, then it goes back to the system tables and says what datatype is the column 'user_id' in the table 'mytable'.Once it knows it's an int (for example) it qualifies the 2 as an int, builds an execution plan and proceeds. Now, a stored proc looks like this: spu_mystoredproce @var1=2, @var2='marcus' SQL knows in advance in this case that @var1 and @var2 are int and char respectively.It doesn't need to check - it just tests var1 to make sure it's an int and moves on. Incidentally, this is why the use of cfqueryparam can significantly improve your performance - it binds the type to a variable.SQL caches execution plans on the server side. When you do databinding you greatly increase the likelyhood of a cache hit for your execution plan. When you do traditional CF (like the query above) you have almost NO chance of finding an execution plan in the cache. -Mark -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 7:47 AM To: CF-Talk Subject: Re: SQL Multiple Inserts But will it help in terms of performance? My understanding is that Stored Procedures are cached queries.But if the query you use has different variable values everytime, then it's just like using a new query.no performance benefit. But if this is not the case, the I would totally use a stored procedure for this part!! - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 7:34 AM Subject: RE: SQL Multiple Inserts No, thats the whole point of a stored procedure...you pass it in variables and it does the processing _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:32 To: CF-Talk Subject: Re: SQL Multiple Inserts Here's what i thought about stored procedure.I thought they are only useful when the SQL query isn't dynamic, like SELECT * from tbl_images.But if it's something like SELECT * from tbl_images where project_id = 30, then a stored procedure is not beneficial, because it's essentially a different query every time. Is this correct?My queries are like the latter. - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 6:14 AM Subject: RE: SQL Multiple Inserts Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: SQL Brainblock
iif( [field] IS NULL, NullValue, [FIELD]) -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 9:13 AM To: CF-Talk Subject: Re: SQL Brainblock I am using Access - Original Message - From: [EMAIL PROTECTED] To: CF-Talk Sent: Monday, March 01, 2004 9:28 AM Subject: RE: SQL Brainblock what db? you would do it with nvl(act_val, val_if_null) in oracle (i think :-) -- dc -Original Message- From: Mickael [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:50 To: CF-Talk Subject: SQL Brainblock Hi All, I am having trouble with an iif in SQL and was wondering if someone could help me with the syntax. here is one line of my query. Round(((sum(ORIG_BAL) -Sum(wo_amount)) / sum(ORIG_BAL)) * 100,0) as SalvageCollected What I would like is to display a zero if the value is null or a zero but I keep getting errors in syntax, I know that this is possible I am just getting lost in my braces. Thanks Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can you reset row numbers in a DB after deleting all rows?
If you want to start from scratch every once in a while, I'd upload clean copy of the database and change the DSN to accomplish your task.Also, I wouldn't worry about running out of IDs unless you are doing something special.I would think Access would crash before reaching the max number of records in a db. Paul [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Charts in Cache
I have a site that generates a couple of graphs, 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: SQL Multiple Inserts
Thanks, Mark - great description! I know that we should do these things (cfqueryparam and sp's) but I haven't seen such a good/easy description in quite a long time! /H. - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED] | Sent: Monday, March 01, 2004 16:35 | To: CF-Talk | Subject: RE: SQL Multiple Inserts | | Stored procedures are not cached queries - they are compiled | execution plans. The thing that makes the difference is the | databinding. SQL knows what type a variable is prior to | execution of the query. So it does not have to check in the | system tables to see what type it should be using.For | example, if you do the following: | | select * from mytable where user_id = 2 | | SQL doesn't know A) what the column names are and B) what | datatype your 2 is.So first it looks in the system tables | for that db and says, give me all the columns, which it uses | for select, then it goes back to the system tables and says | what datatype is the column 'user_id' in the table | 'mytable'.Once it knows it's an int (for example) it | qualifies the 2 as an int, builds an execution plan and proceeds. | | Now, a stored proc looks like this: | | spu_mystoredproce @var1=2, @var2='marcus' | | SQL knows in advance in this case that @var1 and @var2 are | int and char respectively.It doesn't need to check - it | just tests var1 to make sure it's an int and moves on. | | Incidentally, this is why the use of cfqueryparam can | significantly improve your performance - it binds the type to | a variable.SQL caches execution plans on the server side. | When you do databinding you greatly increase the likelyhood | of a cache hit for your execution plan. When you do | traditional CF (like the query above) you have almost NO | chance of finding an execution plan in the cache. ### This message has been scanned by F-Secure Anti-Virus for Microsoft Exchange. For more information, connect to http://www.F-Secure.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Cell phone text messaging...
On Monday 01 Mar 2004 15:02 pm, Stuart Kidd wrote: These intermediary companies have agreements with all the providers... knowing look They don't have to. /knowing look -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
Interesting. Again.. because one can NOT use cached queries with cfqueryparam, which is more beneficial, cached queries or cfqueryparam ? I have always been confused with this distinction. Is there any good rules of thumb when deciding on this? Dave - Original Message - From: Mark A. Kruger - CFG To: CF-Talk Sent: Monday, March 01, 2004 10:34 AM Subject: RE: SQL Multiple Inserts Stored procedures are not cached queries - they are compiled execution plans. The thing that makes the difference is the databinding. SQL knows what type a variable is prior to execution of the query. So it does not have to check in the system tables to see what type it should be using.For example, if you do the following: select * from mytable where user_id = 2 SQL doesn't know A) what the column names are and B) what datatype your 2 is.So first it looks in the system tables for that db and says, give me all the columns, which it uses for select, then it goes back to the system tables and says what datatype is the column 'user_id' in the table 'mytable'.Once it knows it's an int (for example) it qualifies the 2 as an int, builds an execution plan and proceeds. Now, a stored proc looks like this: spu_mystoredproce @var1=2, @var2='marcus' SQL knows in advance in this case that @var1 and @var2 are int and char respectively.It doesn't need to check - it just tests var1 to make sure it's an int and moves on. Incidentally, this is why the use of cfqueryparam can significantly improve your performance - it binds the type to a variable.SQL caches execution plans on the server side. When you do databinding you greatly increase the likelyhood of a cache hit for your execution plan. When you do traditional CF (like the query above) you have almost NO chance of finding an execution plan in the cache. -Mark -Original Message- From: brobborb [mailto:[EMAIL PROTECTED] Sent: Monday, March 01, 2004 7:47 AM To: CF-Talk Subject: Re: SQL Multiple Inserts But will it help in terms of performance? My understanding is that Stored Procedures are cached queries.But if the query you use has different variable values everytime, then it's just like using a new query.no performance benefit. But if this is not the case, the I would totally use a stored procedure for this part!! - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 7:34 AM Subject: RE: SQL Multiple Inserts No, thats the whole point of a stored procedure...you pass it in variables and it does the processing _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 13:32 To: CF-Talk Subject: Re: SQL Multiple Inserts Here's what i thought about stored procedure.I thought they are only useful when the SQL query isn't dynamic, like SELECT * from tbl_images.But if it's something like SELECT * from tbl_images where project_id = 30, then a stored procedure is not beneficial, because it's essentially a different query every time. Is this correct?My queries are like the latter. - Original Message - From: Robertson-Ravo, Neil (RX) To: CF-Talk Sent: Monday, March 01, 2004 6:14 AM Subject: RE: SQL Multiple Inserts Stored Procedure : BULK INSERT. _ From: brobborb [mailto:[EMAIL PROTECTED] Sent: 01 March 2004 12:16 To: CF-Talk Subject: SOT: SQL Multiple Inserts Hey guys, let's say I have to insert like 5,000 rows of data with the click of a button in my app.Would it be alot faster to insert all 5,000 in one CFQuery with multiple inserts?Right now it is just one query looped 5,000 times. Also are there any drawbacks with using multplie inserts? Thanks _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: template reader/parser sort of thing :)
I assume you probably will want to handle the deepest nested tags first
before working your way back out to the bottom-most level, in which case
a recursive function is probably the best way to handle it.Something
along the lines of this maybe:
(Please note this function works when you have a matching !---@ begin
something @--- and !---@ end something @--- only -- so be sure to use
begin and end in your comment names for this one to work.)
I attached a zip file containing this cftemplate for your edification
and amusement.
//
//
//
//
//
//
cfset sourceText=
!---@ begin main @---
some text some text some text
some text some text some text
some text some text some text
a href=''link/a
!---@ begin links @---
some text some text some text
some text some text some text
a href=''link/a
a href=''link/a
a href=''link/a
!---@ end links @---
some text some text some text
some text some text some text
some text some text some text
a href=''link/a
!---@ end main @---
cfscript
function ConvertIt(source) {
var openTagInfo=0;
var tagName=0;
var tagContent=0;
var reSafeTagName=0;
var closeTagInfo=0;
var newSource=source;
var newSourceLeft=0;
var newSourceRight=0;
// find the 'open-tag'
openTagInfo=REFindNoCase([EMAIL PROTECTED]:space:]]*begin[[:space:]]+([EMAIL PROTECTED])@---
,source,1,TRUE);
// check if an 'open-tag' was found
if(openTagInfo.pos[1] GT 0) {
// get the 'name' of the tag
tagName=Trim(Mid(source,openTagInfo.pos[2],openTagInfo.len[2]));
// escape non-alphanumeric characters for our upcoming
regular closetag match regex
reSafeTagName=REReplaceNoCase(tagName,([^[:alnum:]]),\\\1,ALL);
// find the'close-tag'
closeTagInfo=REFindNoCase([EMAIL PROTECTED]:space:]]*end[[:space:]]+reSafeTagN
ame[[:space:[EMAIL PROTECTED],source,1,TRUE);
// check if a 'close-tag' was found
if(closeTagInfo.pos[1] GT 0) {
// make sure tag content is more than an empty
string so our Mid() function doesn't bomb
if((closeTagInfo.pos[1]-(openTagInfo.pos[1]+openTagInfo.len[1])) GT 0) {
// extract the tag content
tagContent=Mid(newSource,openTagInfo.pos[1]+openTagInfo.len[1],closeTagI
nfo.pos[1]-(openTagInfo.pos[1]+openTagInfo.len[1]));
// if left-side or right-side remainders
are zero-length we need to manually set empty strings so as not to bomb
Left() and Right() functions
if(openTagInfo.pos[1] GT 1) {
newSourceLeft=Left(newSource,openTagInfo.pos[1]-1);
}
else {
newSourceLeft='';
}
if((Len(newSource)-(closeTagInfo.pos[1]+closeTagInfo.len[1]-1)) GT 0) {
newSourceRight=Right(newSource,Len(newSource)-(closeTagInfo.pos[1]+close
TagInfo.len[1]-1));
}
else {
newSourceRight='';
}
// recursively call ConvertIt() to
handle nested tags first
tagContent=ConvertIt(tagContent);
// okay NOW we perform any conversion
functions that you want
// since i have no idea what you want to
do here i will just HTMLEditFormat any content surrounded by !---@
tags.
tagContent=HTMLEditFormat(tagContent);
// now we are done with conversion so
lets put the tag contents back into the rest of the source
newSource=newSourceLeft tagContent
newSourceRight;
// ALL DONE.
}
}
}
// return updated source text
return newSource;
}
/cfscript
cfoutput
pre#HTMLEditFormat(ConvertIt(sourceText))#/pre
/cfoutput
//
//
//
//
//
//
-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]
Sent: Monday, March 01, 2004 9:06 AM
To: CF-Talk
Subject: Re: template reader/parser sort of thing :)
ok,
i would prefer not to do it this way.. basically among other ideas i
would love to convert phpbb over to coldfusion.. i've been working on it
for a while, and now i've come to the reading and parsing of the
template files... i want to be able to read in phpbb template files and
so xlst/xml won't work.
my main problem comes with nested replacements... how do you do it?
TIA,
Ryan
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
RE: SQL Multiple Inserts
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. /Hugo - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: David Fafard [mailto:[EMAIL PROTECTED] | Sent: Monday, March 01, 2004 17:23 | To: CF-Talk | Subject: Re: SQL Multiple Inserts | | Interesting. | | Again.. because one can NOT use cached queries with | cfqueryparam, which is more beneficial, cached queries or | cfqueryparam ? | | I have always been confused with this distinction. | Is there any good rules of thumb when deciding on this? | | Dave | |- Original Message - |From: Mark A. Kruger - CFG |To: CF-Talk |Sent: Monday, March 01, 2004 10:34 AM |Subject: RE: SQL Multiple Inserts | | |Stored procedures are not cached queries - they are | compiled execution plans. The thing that makes the difference is the |databinding. SQL knows what type a variable is prior to | execution of the query. So it does not have to check in the |system tables to see what type it should be using.For | example, if you do the following: | |select * from mytable where user_id = 2 | |SQL doesn't know A) what the column names are and B) what | datatype your 2 is.So first it looks in the system tables |for that db and says, give me all the columns, which it | uses for select, then it goes back to the system tables and says |what datatype is the column 'user_id' in the table | 'mytable'.Once it knows it's an int (for example) it qualifies |the 2 as an int, builds an execution plan and proceeds. | |Now, a stored proc looks like this: | |spu_mystoredproce @var1=2, @var2='marcus' | |SQL knows in advance in this case that @var1 and @var2 are | int and char respectively.It doesn't need to check - it |just tests var1 to make sure it's an int and moves on. | |Incidentally, this is why the use of cfqueryparam can | significantly improve your performance - it binds the type to a |variable.SQL caches execution plans on the server side. | When you do databinding you greatly increase the likelyhood of |a cache hit for your execution plan. When you do | traditional CF (like the query above) you have almost NO chance of |finding an execution plan in the cache. | |-Mark | |-Original Message- |From: brobborb [mailto:[EMAIL PROTECTED] |Sent: Monday, March 01, 2004 7:47 AM |To: CF-Talk |Subject: Re: SQL Multiple Inserts | |But will it help in terms of performance? My | understanding is that Stored Procedures are cached queries. | But if the |query you use has different variable values everytime, then | it's just like using a new query.no performance benefit. |But if this is not the case, the I would totally use a | stored procedure for this part!! | | - Original Message - | From: Robertson-Ravo, Neil (RX) | To: CF-Talk | Sent: Monday, March 01, 2004 7:34 AM | Subject: RE: SQL Multiple Inserts | | No, thats the whole point of a stored procedure...you | pass it in variables | and it does the processing | | _ | | From: brobborb [mailto:[EMAIL PROTECTED] | Sent: 01 March 2004 13:32 | To: CF-Talk | Subject: Re: SQL Multiple Inserts | | Here's what i thought about stored procedure.I | thought they are only | useful when the SQL query isn't dynamic, like SELECT * | from tbl_images.But | if it's something like SELECT * from tbl_images where | project_id = 30, then | a stored procedure is not beneficial, because it's | essentially a different | query every time. | | Is this correct?My queries are like the latter. | |- Original Message - |From: Robertson-Ravo, Neil (RX) |To: CF-Talk |Sent: Monday, March 01, 2004 6:14 AM |Subject: RE: SQL Multiple Inserts | |Stored Procedure : BULK INSERT. | |_ | |From: brobborb [mailto:[EMAIL PROTECTED] |Sent: 01 March 2004 12:16 |To: CF-Talk |Subject: SOT: SQL Multiple Inserts | |Hey guys, let's say I have to insert like 5,000 rows | of data with the | click |of a button in my app.Would it be alot faster to | insert all 5,000 in one |CFQuery with multiple inserts?Right now it is just | one query looped | 5,000 |times. | |Also are there any drawbacks with using multplie inserts? | |Thanks |_ | _ | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL Multiple Inserts
David Fafard wrote: Again.. because one can NOT use cached queries with cfqueryparam http://www.macromedia.com/go/wish/ which is more beneficial, cached queries or cfqueryparam ? Depends on the situation. I have always been confused with this distinction. Is there any good rules of thumb when deciding on this? Always use cfqueryparam for the security features. Caache a query if it is executed often and / or has a long runtime. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMX - How do i end client variable state at browser close?
(Software: CFMX) 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... Jon [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Access Coldfusion MX6.1 problems...sites keep dying
It's the one that says Microsoft Access with Unicode, that one worked for me. It's on all of our servers by default upon installing CFMX. Donnie Bachan Phone: (718) 217-2883 ICQ#: 28006783 Nitendo Vinces - By Striving You Shall Conquer [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
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
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: 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: cfapplication ... setclientcookies=no cfif not IsDefined(Cookie.CFID) cfcookie name=CFID value=#Client.CFID# cfcookie name=CFTOKEN value=#Client.CFTOKEN# /cfif 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: 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]
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: 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]
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 body Here is some font face=Arial, Helvetica, sans-serifsample/font test with a a href=""> /body 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:mailto:[EMAIL PROTECTED] [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]
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 body Here is some font face=Arial, Helvetica, sans-serifsample/font test with a a href=""> /body 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:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [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]
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
#123;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, MD20742-2611
301-405-2545 Phone
www.phi.umd.edu
[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
#123;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, MD20742-2611
301-405-2545 Phone
www.phi.umd.edu
_
[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: 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 body Here is some font face=Arial, Helvetica, sans-serifsample/font test with a a href=""> /body 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:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] [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: template reader/parser sort of thing :)
Actually I really like this idea, but modified a bit... cfimport a taglib of custom display tags, where from depends on the skin you want to use, then mytags:linksSectionmytags:links/mytags:linksSection. 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. ?mytags:link? ?mytags:link main=1 /? ?mytags:link? 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... !---@ begin links @--- !---@ main links @--- !---@ end main links @--- !---@ end links @--- 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 :)
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... cfimport a taglib of custom display tags, where from depends on the skin you want to use, then mytags:linksSectionmytags:links/mytags:linksSection. 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. ?mytags:link? ?mytags:link main=1 /? ?mytags:link? 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... !---@ begin links @--- !---@ main links @--- !---@ end main links @--- !---@ end links @--- 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: 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 body Here is some font face=Arial, Helvetica, sans-serifsample/font test with a a href=""> /body 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:mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] s. isaac dealey214.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]
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 img tag).I've tried the following code without success (the text list items display as intended).Any ideas? cfset REQUEST.webroot = http://www.somesite.com form ACTION="" METHOD=POST Name=form1 select name=colorAdvantageID cfloop query=qColorAdvantage cfoutput option value=#colorAdvantageID##colorAdvantageID#nbsp;-nbsp;#colorAdvantageNam e#nbsp;nbsp;nbsp;img src=""> //option /cfoutput /cfloop /select input type=Submit value=Get Samples! /form Thanks, Mark [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 img tag).I've tried the following code without success (the text list items display as intended).Any ideas? cfset REQUEST.webroot = http://www.somesite.com form ACTION="" METHOD=POST Name=form1 select name=colorAdvantageID cfloop query=qColorAdvantage cfoutput option value=#colorAdvantageID##colorAdvantageID#nbsp;-nbsp;#colorAdvantageNam e#nbsp;nbsp;nbsp;img src=""> //option /cfoutput /cfloop /select input type=Submit value=Get Samples! /form Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
CFMail problem
http://www.houseoffusion.com/banners/view.cfm?bannerid=11 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
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 img tag).I've tried the following code without success (the text list items display as intended).Any ideas? cfset REQUEST.webroot = http://www.somesite.com form ACTION="" METHOD=POST Name=form1 select name=colorAdvantageID cfloop query=qColorAdvantage cfoutput option value=#colorAdvantageID##colorAdvantageID#nbsp;-nbsp;#col orAdvantageNam e#nbsp;nbsp;nbsp;img src=""> tageSwatch# //option /cfoutput /cfloop /select input type=Submit value=Get Samples! /form Thanks, Mark [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: option value=2004-12January 2004 /option option value=2003-01December 2003 /option option value=2003-01November 2003 /option option value=2003-01October 2003 /option option value=2003-01September 2003 /option option value=2003-01August 2003 /option option value=2003-01July 2003 /option NumberFormat worked.option 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]
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. cfset filePath = c:\path\to\file\thefile.ext cfheader name=Content-Disposition value=attachment; filename=#getFileFromPath(filePath)# cfcontent file=#filePath# type=application/octet-stream [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]
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]
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: CFAPPLICATION name=testapp applicationtimeout=#createtimespan(0,0,5,0)# sessionmanagement=Yes sessiontimeout=#createtimespan(0,0,1,0)# CFIF IsDefined(Session.Host) CFOUTPUT#Session.Host#/CFOUTPUT CFELSE First time here. /CFIF BRBR CFSET Session.Host = CGI.HTTP_HOST CFDUMP var=#Session.Host# 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: 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:mailto:[EMAIL PROTECTED] [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: 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: cfapplication ... setclientcookies=no cfif not IsDefined(Cookie.CFID) cfcookie name=CFID value=#Client.CFID# cfcookie name=CFTOKEN value=#Client.CFTOKEN# /cfif 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: 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. form select multiple size=4 style=width: 100px; option style=background: url(corner.gif); background-repeat : no-repeat; padding-left: 25px;Test 1/option optionTest 2/option /select /form 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]
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/ teaser 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 /teaser -- Rob [EMAIL PROTECTED] [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]
Help - CF5 CFGRAPH - 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 cfgraph in cf5? I need to get it to work with cf5 Jon [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]
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? optionSelect one of six messages from this list/option option value=maintenanceSystem Down for Scheduled Maintenance/option option value=circuitproblemsSystem Down/Internet Circuit Problems/option CFIF #session.username# EQ #getuser.username# and getuser.priority is highoption value=customCustom Status Message/option/cfif /select Thx. Roberto. O. HWW [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]
Re: populating dropdowns
Either session.username does not equal getuser.username or getuser.priority does not equal high. Use cfdump var=#getuser# and cfdump var=#session# 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? optionSelect one of six messages from this list/option option value=maintenanceSystem Down for Scheduled Maintenance/option option value=circuitproblemsSystem Down/Internet Circuit Problems/option CFIF #session.username# EQ #getuser.username# and getuser.priority is highoption value=customCustom Status Message/option/cfif /select [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
First off...ditch the excessive use of # CFIF #session.username# EQ #getuser.username# and getuser.priority is high should be CFIF session.username EQ getuser.username AND 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: CFIF UCase(session.username) EQ UCase(getuser.username) AND 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? optionSelect one of six messages from this list/option option value=maintenanceSystem Down for Scheduled Maintenance/option option value=circuitproblemsSystem Down/Internet Circuit Problems/option CFIF #session.username# EQ #getuser.username# and getuser.priority is highoption value=customCustom Status Message/option/cfif /select Thx. Roberto. O. HWW [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:mailto:[EMAIL PROTECTED] [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
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: CFIF UCase(session.username) EQ UCase(getuser.username) AND UCase(getuser.priority) is HIGH cfset session.username='hiGh' cfif session.username is 'high'truecfelsefalse/cfif Since when is it case sensitive ? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: populating dropdowns
The value could behigh,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: CFIF UCase(session.username) EQ UCase(getuser.username) AND UCase(getuser.priority) is HIGH cfset session.username='hiGh' cfif session.username is 'high'truecfelsefalse/cfif Since when is it case sensitive ? [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 # CFIF #session.username# EQ #getuser.username# and getuser.priority is high should be CFIF session.username EQ getuser.username AND 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: CFIF UCase(session.username) EQ UCase(getuser.username) AND 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? optionSelect one of six messages from this list/option option value=maintenanceSystem Down for Scheduled Maintenance/option option value=circuitproblemsSystem Down/Internet Circuit Problems/option CFIF #session.username# EQ #getuser.username# and getuser.priority is highoption value=customCustom Status Message/option/cfif /select Thx. Roberto. O. HWW [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 behigh,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]
