RE: Friday question.... any difference?
well at a guess I would have said that code block 1 was better because you are doing 1 test and 1 set. In code block 2 you are potentially doing an unnecessary set making it slightly less efficient but if I'm gonna pull you up on this I guess I oughta get out more ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 05 September 2003 11:39 To: CF-Talk Subject: OT: Friday question any difference? I was mulling this over last night Should there be any preference between the following two examples of code? !--- Code Block 1 --- cfif myQuery.RecordCount cfset theName = myQuery.FIRST_NAME myQuery.LAST_NAME cfelse cfset theName = Undefined /cfif !--- Code Block 2 --- cfset theName = Undefined cfif myQuery.RecordCount cfset theName = myQuery.FIRST_NAME myQuery.LAST_NAME /cfif I prefer code block 2 as it is one less line, but are there any technical merits between the two Does it matter? Should I get out more? It can be grim up north you know :-) DC ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: DB Design
Yup I agree Ian - but sometimes I am a little uneasy about using a combination of character fields to uniquely define a record. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 16:12 To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: DB Design
well I reckon it's always more robust I feel to join tables on numeric datatypes as opposed to strings. As for genreal indexing - this is a world of fun. You need to balance off the positives you gain from indexing (quicker selects etc) to the disadvantages (slower inserts/updates/deletes). As for selects experiment as to what combination of fields gives you the quickest response. SQL Server chooses which index to use based on your select statement as opposed to older db's where you actually manually selected the index. A good point to start would be to index on the columns you use in your where clause in the order they appear - add/remove them until you get optimal performance. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 16:20 To: CF-Talk Subject: RE: DB Design Not that I disagree with you, but I would like to here what makes you uneasy about using character fields to define a record. I'm a fairly novice DBA, and I would really like to strengthen my understanding of best practices. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:21 AM To: CF-Talk Subject: RE: DB Design Yup I agree Ian - but sometimes I am a little uneasy about using a combination of character fields to uniquely define a record. -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: 29 July 2003 16:12 To: CF-Talk Subject: RE: DB Design I think what they are referring to, is that in many instances there will be natural keys in the data, and that using these instead of attaching an artificial ID field is a more PURE way to design a database. For example for users, you might use e-mail, for employees you might use SSN, ect. Not sure I believe in this strong enough to match the sentiments you quoted, but I've usually try to use a natural key before I resort to the Identity ID. -- Ian Skinner Web Programmer BloodSource Sacramento, CA -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 7:56 AM To: CF-Talk Subject: Re: DB Design I welcome the discussion but back it up.. PITA? In what ways? - Original Message - From: Boardwine, David L. [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:50 AM Subject: RE: DB Design Ok, I'll give my .02 worth. BS. What am I supposed to use as a PK? GUIDs? GUIDs are what M$ uses and they are a PITA. DavidB -Original Message- From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 10:48 AM To: CF-Talk Subject: SOT: DB Design I am working on a new DB design for a CFMX app and was doing a little refresher research on keys and data types and ran across this quote from former SQL Server project manager Ron Soukup, Identity primary keys are for people who believe there's never time to design a table right but there's always time to do it over. In another related article, another MS SQL guy says that the only reason identity made it into SQL server was because of Access (not a direct quote). Anyone care to comment? Mike ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Client Vars
Hi Does any one know how to specify a DSN for clientmanagement n the application.cfm and also pass in the username and password? - basically I have always coded the username/password into the DSN but this is not an option in this instance. Any work arounds? Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client Vars
yup but I can't pass the username or password into the DSN as is on a shared server and anyone could hijack the DSN then -Original Message- From: Mike Townend [mailto:[EMAIL PROTECTED] Sent: 25 July 2003 13:46 To: CF-Talk Subject: RE: Client Vars The DSN stuff will need to be already setup in the admin. So you will need to create a DSN (Passing in the Username and password (im pretty sure you cant have the password passed in later)) Then in client variables section of the Admin, you must register the DSN as a ClientVariables DSN (but you don't have to set it as the default) Then in the CFAPPLICATION tag you set CLIENTSTORAGE= to you DSN HTH Mikey -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 13:41 To: CF-Talk Subject: Client Vars Hi Does any one know how to specify a DSN for clientmanagement n the application.cfm and also pass in the username and password? - basically I have always coded the username/password into the DSN but this is not an option in this instance. Any work arounds? Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Client Vars
when you say on a selective basis - what basis is that selection made? -Original Message- From: Doug White [mailto:[EMAIL PROTECTED] Sent: 25 July 2003 14:18 To: CF-Talk Subject: Re: Client Vars There must be a security hole in the server configuration then, because it is relatively simple to add a security policy that can block access to DSNs on a selective basis. At least that is the case on my Win2k/Win2003 servers. All our tests have successfully prevented using unauthorized DSNs. Secondly, our tech staff reviews uploaded code in the background, and will disable a site that uploads hostile code. (AUP violation) == Stop spam on your domain, use our gateway! For hosting solutions http://www.clickdoug.com ISP rated: http://www.forta.com/cf/isp/isp.cfm?isp_id=772 == If you are not satisfied with my service, my job isn't done! - Original Message - From: Andy Ewings [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, July 25, 2003 7:53 AM Subject: RE: Client Vars | yup but I can't pass the username or password into the DSN as is on a shared | server and anyone could hijack the DSN then | | -Original Message- | From: Mike Townend [mailto:[EMAIL PROTECTED] | Sent: 25 July 2003 13:46 | To: CF-Talk | Subject: RE: Client Vars | | | The DSN stuff will need to be already setup in the admin. | | So you will need to create a DSN (Passing in the Username and password (im | pretty sure you cant have the password passed in later)) | | Then in client variables section of the Admin, you must register the DSN as | a ClientVariables DSN (but you don't have to set it as the default) | | Then in the CFAPPLICATION tag you set CLIENTSTORAGE= to you DSN | | | HTH | | Mikey | | | -Original Message- | From: Andy Ewings [mailto:[EMAIL PROTECTED] | Sent: Friday, July 25, 2003 13:41 | To: CF-Talk | Subject: Client Vars | | | Hi | | Does any one know how to specify a DSN for clientmanagement n the | application.cfm and also pass in the username and password? - basically I | have always coded the username/password into the DSN but this is not an | option in this instance. Any work arounds? | | Andy | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: update query
Hi If the link is ID then your query looks ok the following will do it. UPDATE tableA SET region = TableB.region FROM tableB, TableA WHERE tableB.id = tableA.id -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: 09 July 2003 17:40 To: CF-Talk Subject: Re: update query That is what I would normally do but it has to be part of a DTS package and will be ran everyday :( Phillip B. www.LoungeRoyale.com www.FillWorks.com - Original Message - From: Tony Weeg [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 11:25 AM Subject: RE: update query I would do a cfquery of all columns in b. then loop through that, for each iteration, update a with the value of some b query column value. make sense? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Phillip B [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 12:21 PM To: CF-Talk Subject: OT: update query I have two tables. tableA id name region tableB id name region I need to update tableA's region colum with tableB's region colum. The region colum has changed for some and not for others. With that said, does this look right? UPDATE tableA SET region = (SELECT region FROM tableB WHERE tableB.id = tableA.id) Its been a while since I have done this and I cant remeber the best way to do it. :| Phillip B. www.LoungeRoyale.com www.FillWorks.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: sql oddity (but weird)
MAkes no difference which comes first value or column. Simple case of Mathematical equality. This is why for the old inner join syntax (=) it didn't matter which table you had on left or right of join statement. In fact doesn't matter using new syntax either -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 01 July 2003 14:52 To: CF-Talk Subject: RE: sql oddity (but weird) Of course it returns all rows. You are telling the database that for each row retrieved, check if 10509 is equal to 10509 (which it will be). -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 9:12 AM To: CF-Talk Subject: RE: sql oddity (but weird) select * from routes where 10509 = 10509 doesn't produce anything close to what im lookin for...that just returns all rows...? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 9:00 AM To: CF-Talk Subject: RE: sql oddity (but weird) Actually, you can have: WHERE column = column WHERE constant = constant WHERE column = constant WHERE constant = column All are allowed. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 8:46 AM To: CF-Talk Subject: ot: sql oddity (but weird) select * from routes where 10509 = id why does this work? I always thought that it was supposed to read like... select * from routes where id = 10509 column, before the value? tony weeg uncertified advanced cold fusion developer tony at navtrak dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there SQL equivalent to CF's ListGetAt function??? Please help!
SQL has no concepts of lists - you need to look for your delimiter by using the String functions Adrian talks about below within a loop and truncate your string each time. That way you can get each element of the list. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:27 To: CF-Talk Subject: RE: Is there SQL equivalent to CF's ListGetAt function??? Please help! I don't know if this is the best way, but have a look at SubString() and CharIndex(), you might be able to use the two together to get what you need. This is on SQL Server by the way. Ade -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:10 To: CF-Talk Subject: Is there SQL equivalent to CF's ListGetAt function??? Please help! I have a column in a db that stores data with a pipe [|] delimiter. I would like to write a SQL query that filters data based on a segment of data within a pipe delimited variable. Basically, is there SQL code that is equivalent to the psuedo CF code below? A SQL version of ListGetAt if you will??? -- WHERE FinalShipTo = ListGetAt(#getOrderInfo.FinalShipTo#,5,~) -- I hope this makes sense... TIA - Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there SQL equivalent to CF's ListGetAt function??? Please help!
Here's the code to loop through a list.. Search through list SELECT @stringcopy = @list SELECT @delimpos = CHARINDEX(,,@stringcopy) IF LEN(@stringcopy) 0 BEGIN WHILE @delimpos 0 BEGIN SELECT @delimpos = CHARINDEX(,,@stringcopy) IF @delimpos 0 BEGIN -- * DO WHATEVER YOU NEED TO WITH THE LIST ELEMENT HERE BY REFERING TO LEFT(@stringcopy,@delimpos - 1) -- SELECT @stringcopy = RIGHT(@stringcopy, LEN(@stringcopy) - @delimpos) END END -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:30 To: CF-Talk Subject: RE: Is there SQL equivalent to CF's ListGetAt function??? Please help! SQL has no concepts of lists - you need to look for your delimiter by using the String functions Adrian talks about below within a loop and truncate your string each time. That way you can get each element of the list. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:27 To: CF-Talk Subject: RE: Is there SQL equivalent to CF's ListGetAt function??? Please help! I don't know if this is the best way, but have a look at SubString() and CharIndex(), you might be able to use the two together to get what you need. This is on SQL Server by the way. Ade -Original Message- From: Che Vilnonis [mailto:[EMAIL PROTECTED] Sent: 10 June 2003 14:10 To: CF-Talk Subject: Is there SQL equivalent to CF's ListGetAt function??? Please help! I have a column in a db that stores data with a pipe [|] delimiter. I would like to write a SQL query that filters data based on a segment of data within a pipe delimited variable. Basically, is there SQL code that is equivalent to the psuedo CF code below? A SQL version of ListGetAt if you will??? -- WHERE FinalShipTo = ListGetAt(#getOrderInfo.FinalShipTo#,5,~) -- I hope this makes sense... TIA - Ché ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: cfparam
Prob is that CF doesn't set the datatype of a variable on creation (as in other languages). It determines it when it is referenced or tested. Guess it's good in some ways and bad in others. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 04 April 2003 15:29 To: CF-Talk Subject: cfparam Anyone else thing cfparam would be more useful when if using it like this... cfparam name=URL.id default=0 type=numeric ...was the same as using... cfif NOT IsDefined(URL.id) OR NOT IsNumeric(URL.id) cfset URL.id = 0 /cfif ...so the param kicks in if URL.id isn't defined OR if it isn't a number? I'd never really used the type attribute in cfparam before and I was hoping this was the way it worked. Oh well :O( Adrian Lynch Web Developer Thoughtbubble Ltd -- United Kingdom http://www.thoughtbubble.net Ph: +44 (0) 20 7387 8890 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: distinct count
real data and aggregates at the same time is fine - so long as you realise the the real data is grouped too. i.e. if you are using agregate functions and real data in your select statement all of the columns referenced need to be grouped - whgich makes entire sense. I have met so many developers who ask me why doesn't this work: select firstname, surname, company, count(*) as 'num of employees' from tblemployees group by company -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: 12 March 2003 14:39 To: CF-Talk Subject: RE: distinct count The SQL padwan bows to greater wisdom. Avoiding combinig aggregates and 'real' data is a rule of thumb I picked up somewhere. It may have just been to keep me from botching things when I really didn't know /anything/ about SQL. :-) -- Ben Doom Programmer General Lackey Moonbow Software, Inc : -Original Message- : From: Dave Watts [mailto:[EMAIL PROTECTED] : Sent: Tuesday, March 11, 2003 10:09 PM : To: CF-Talk : Subject: RE: distinct count : : : Ben wrote: : : Remember -- it's generally a bad idea to run a query : selecting real data and aggregates (like count) at the : same time. : : Then how do I get both the aggregate info and the other : query columns I need for the same output? : : I disagree with the statement that it's a bad idea to run a query : selecting : real data and aggregates at the same time - if you want to ask a question : like how many sales per region, that's how you do it. : : Dave Watts, CTO, Fig Leaf Software : http://www.figleaf.com/ : voice: (202) 797-5496 : fax: (202) 797-5444 : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Writing CF to a string
Does anyone know how to create a string containing CF code without it being evaluated? i.e. I want to create a file containing the text cfinclude template-mytemplate.cfm I have tried this by creating a straing containing cfinclude template-mytemplate.cfm using the DE function but when I try to look at the contents of this string all I see is double quotation marks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Writing CF to a string
Rich But won't that still be evaluated? Also aint it chr? - and I think is chr(60) (maybe wrong). -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 13:52 To: CF-Talk Subject: RE: Writing CF to a string cfset myCFstr = '#char(139)#cfinclude template=mytemplate.cfm#char(155)#' -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 13:53 To: CF-Talk Subject: Writing CF to a string Does anyone know how to create a string containing CF code without it being evaluated? i.e. I want to create a file containing the text cfinclude template-mytemplate.cfm I have tried this by creating a straing containing cfinclude template-mytemplate.cfm using the DE function but when I try to look at the contents of this string all I see is double quotation marks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Writing CF to a string
I'm doing that already -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 14:01 To: CF-Talk Subject: RE: Writing CF to a string Escape the quotes... cfset str = cfinclude template=mytemplate.cfm === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc Member of Team Macromedia Email: [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus My ally is the Force, and a powerful ally it is. - Yoda -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 7:53 AM To: CF-Talk Subject: Writing CF to a string Does anyone know how to create a string containing CF code without it being evaluated? i.e. I want to create a file containing the text cfinclude template-mytemplate.cfm I have tried this by creating a straing containing cfinclude template-mytemplate.cfm using the DE function but when I try to look at the contents of this string all I see is double quotation marks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Writing CF to a string
thanks Rich -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 14:37 To: CF-Talk Subject: RE: Writing CF to a string sorry Andy, I'm not thinking straight, which is a requisite when answering questions. you don't even need that chr() bit. cfset myCFStr = 'cfinclude template=myTemplate.cfm' will work fine and doesn't get evaluated. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 14:36 To: CF-Talk Subject: RE: Writing CF to a string Rich But won't that still be evaluated? Also aint it chr? - and I think is chr(60) (maybe wrong). -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 13:52 To: CF-Talk Subject: RE: Writing CF to a string cfset myCFstr = '#char(139)#cfinclude template=mytemplate.cfm#char(155)#' -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED] Sent: 26 February 2003 13:53 To: CF-Talk Subject: Writing CF to a string Does anyone know how to create a string containing CF code without it being evaluated? i.e. I want to create a file containing the text cfinclude template-mytemplate.cfm I have tried this by creating a straing containing cfinclude template-mytemplate.cfm using the DE function but when I try to look at the contents of this string all I see is double quotation marks ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Corrupt records inserted into SQL database
I assume that the order number is being created by an identity field? I think that if you create a record with one of your insert statements and then another insert fails and the whole lot is rolled back that number that was assigned is lost - but this is fine as the number is inconsequential really. Can you elaborate what you mean when you say invalid orders. -Original Message- From: Ben Densmore [mailto:[EMAIL PROTECTED]] Sent: 13 February 2003 16:14 To: CF-Talk Subject: Corrupt records inserted into SQL database Hi everyone, We are having a problem with a custom order entry system application we have written in ColdFusion using MS SQL 7 database. The problem appears to be that intermittently invalid orders are getting into the system. Frequency is approximately 2 invalid orders every day out of about 120 orders. In addition, we've noticed that 100% of the time for each invalid order there's a hole in the Orders table of the database where there's at least one record immediately after the problem Order table record which does not exist. For example, if Order record # 3500 is found to be invalid, record # 3501 does not exist in the table, but there is record # 3502, 3503, etc. We are using a Begin Transaction, Commit Transaction statement surrounding the multiple SQL INSERTS to insert records into the SQL database. Anyone have any ideas on what might be wrong? Thanks, Ben Ben Densmore Web Developer TouchStone Software Corp./eSupport.com, Inc. 1538 Turnpike St. North Andover, Ma 01845 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
OT
Seriously OT guys but would anyone know why, when I open up the MMC for IIS Server I don't se the SMTP virtual service. I am supposed to see Default FTP site, Default Website, and SMTP but instead I get Default FTP site, Default Website, and IIS Administration (or sommat like that). Before you say it - yes SMTP is installed - I can see it running as a service and can telnet to it ok.. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT SMTP
Done this and it is already checked indicating that it is installed -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: 06 February 2003 16:04 To: CF-Talk Subject: RE: OT SMTP Andy, Check again - SMTP service handles relaying mail. SMTP virtual server is something different. Run Windows component setup and see if it's checked in the list of components. -Mark -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 9:25 AM To: CF-Talk Subject: OT Seriously OT guys but would anyone know why, when I open up the MMC for IIS Server I don't se the SMTP virtual service. I am supposed to see Default FTP site, Default Website, and SMTP but instead I get Default FTP site, Default Website, and IIS Administration (or sommat like that). Before you say it - yes SMTP is installed - I can see it running as a service and can telnet to it ok.. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT SMTP
...In fact have uninstalled it and reinstalled it -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: 06 February 2003 16:04 To: CF-Talk Subject: RE: OT SMTP Andy, Check again - SMTP service handles relaying mail. SMTP virtual server is something different. Run Windows component setup and see if it's checked in the list of components. -Mark -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 06, 2003 9:25 AM To: CF-Talk Subject: OT Seriously OT guys but would anyone know why, when I open up the MMC for IIS Server I don't se the SMTP virtual service. I am supposed to see Default FTP site, Default Website, and SMTP but instead I get Default FTP site, Default Website, and IIS Administration (or sommat like that). Before you say it - yes SMTP is installed - I can see it running as a service and can telnet to it ok.. ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Secure Email
Anyone know if it is possible to pass a username and password to a mail server using the CFMAIL tag? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Reading a PDF
Any of you know how to automatically read the contents of a PDF using CF? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading a PDF
I want to automatically read the contents and look for words and report back to CF if they are found. Don't want to use verity) as this is on a document by document basis. what happens if I use ReadBinary in the action attribute of the tag. Is the solution you suggest an automatic one? -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:27 To: CF-Talk Subject: RE: Reading a PDF What do you want to do with it? Suggestion: Load up your document to a web accessible directory, point Adobes PDF to HTML conversion system at the document, save away the content. Bingo! Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:14 To: CF-Talk Subject: Reading a PDF Any of you know how to automatically read the contents of a PDF using CF? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading a PDF
yup just seen that on the adobe site, tried and worked - thanks a lot. Do you think that this url is reliable long term? - i.e. will that converter always be available. Seems to take a while to execute too. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:20 To: CF-Talk Subject: RE: Reading a PDF Here's the code from one of my fusebox applications. !---@ Upload File --- cfif len(attributes.FILE_NAME) !---@ Pages with secure items must use the offline storage area. --- cffile action=UPLOAD filefield=FILE_NAME destination=#getdirectoryfrompath(getcurrenttemplatepath())#/documents nameconflict=MAKEUNIQUE cfset attributes.FILE_NAME = cffile.ServerFile cfset attributes.FILE_SIZE = cffile.FileSize !--- Determine filetype. --- cfset attributes.SUFFIX = listlast(attributes.FILE_NAME,.) cfinclude template=queries/qry_file_type_select.cfm cfif qry_file_type_select.recordcount EQ 0 cfset attributes.FILE_TYPE = application/unkown cfelse cfset attributes.FILE_TYPE = qry_file_type_select.FILE_TYPE /cfif !--- PDF files are converted to HTML --- cfif listlast(attributes.FILE_NAME,.) eq pdf cfhttp url=http://access.adobe.com/perl/convertPDF.pl; method=post resolveurl=no cfhttpparam type=formfield name=url value=#request.site.webRoot#/contentmanagement/documents/#attributes.file_n ame# /cfhttp !--- Now write the content away. --- cfset attributes.pdfhtmlfile = #createuuid()#.html cffile action=append file=#getdirectoryfrompath(getcurrenttemplatepath())#/documents/pdfhtmlfile s/#attributes.pdfhtmlfile# output=#cfhttp.FileContent# /cfif /cfif Hope this helps. You don't need to do the last write away. You can just use the contents of the check for the words you are looking for. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:49 To: CF-Talk Subject: RE: Reading a PDF I want to automatically read the contents and look for words and report back to CF if they are found. Don't want to use verity) as this is on a document by document basis. what happens if I use ReadBinary in the action attribute of the tag. Is the solution you suggest an automatic one? -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:27 To: CF-Talk Subject: RE: Reading a PDF What do you want to do with it? Suggestion: Load up your document to a web accessible directory, point Adobes PDF to HTML conversion system at the document, save away the content. Bingo! Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:14 To: CF-Talk Subject: Reading a PDF Any of you know how to automatically read the contents of a PDF using CF? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading a PDF
we have a 256k leased line. I think there may be problems saying that but CF is saying the page is taking about 100,000ms to execute -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:46 To: CF-Talk Subject: RE: Reading a PDF Well, If you think about it you are asking your server to submit the file to the adobe site. What't the connection like from your server to the net? As to the converter being always available. Ask them! We put a proviso in our contract that stated specifically that this was an external service and was not under our control. Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:37 To: CF-Talk Subject: RE: Reading a PDF yup just seen that on the adobe site, tried and worked - thanks a lot. Do you think that this url is reliable long term? - i.e. will that converter always be available. Seems to take a while to execute too. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:20 To: CF-Talk Subject: RE: Reading a PDF Here's the code from one of my fusebox applications. !---@ Upload File --- cfif len(attributes.FILE_NAME) !---@ Pages with secure items must use the offline storage area. --- cffile action=UPLOAD filefield=FILE_NAME destination=#getdirectoryfrompath(getcurrenttemplatepath())#/documents nameconflict=MAKEUNIQUE cfset attributes.FILE_NAME = cffile.ServerFile cfset attributes.FILE_SIZE = cffile.FileSize !--- Determine filetype. --- cfset attributes.SUFFIX = listlast(attributes.FILE_NAME,.) cfinclude template=queries/qry_file_type_select.cfm cfif qry_file_type_select.recordcount EQ 0 cfset attributes.FILE_TYPE = application/unkown cfelse cfset attributes.FILE_TYPE = qry_file_type_select.FILE_TYPE /cfif !--- PDF files are converted to HTML --- cfif listlast(attributes.FILE_NAME,.) eq pdf cfhttp url=http://access.adobe.com/perl/convertPDF.pl; method=post resolveurl=no cfhttpparam type=formfield name=url value=#request.site.webRoot#/contentmanagement/documents/#attribu tes.file_n ame# /cfhttp !--- Now write the content away. --- cfset attributes.pdfhtmlfile = #createuuid()#.html cffile action=append file=#getdirectoryfrompath(getcurrenttemplatepath())#/documents/p dfhtmlfile s/#attributes.pdfhtmlfile# output=#cfhttp.FileContent# /cfif /cfif Hope this helps. You don't need to do the last write away. You can just use the contents of the check for the words you are looking for. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:49 To: CF-Talk Subject: RE: Reading a PDF I want to automatically read the contents and look for words and report back to CF if they are found. Don't want to use verity) as this is on a document by document basis. what happens if I use ReadBinary in the action attribute of the tag. Is the solution you suggest an automatic one? -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:27 To: CF-Talk Subject: RE: Reading a PDF What do you want to do with it? Suggestion: Load up your document to a web accessible directory, point Adobes PDF to HTML conversion system at the document, save away the content. Bingo! Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:14 To: CF-Talk Subject: Reading a PDF Any of you know how to automatically read the contents of a PDF using CF? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading a PDF
This particular file is 76kb -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:53 To: CF-Talk Subject: RE: Reading a PDF And how big is your file? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:51 To: CF-Talk Subject: RE: Reading a PDF we have a 256k leased line. I think there may be problems saying that but CF is saying the page is taking about 100,000ms to execute -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:46 To: CF-Talk Subject: RE: Reading a PDF Well, If you think about it you are asking your server to submit the file to the adobe site. What't the connection like from your server to the net? As to the converter being always available. Ask them! We put a proviso in our contract that stated specifically that this was an external service and was not under our control. Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:37 To: CF-Talk Subject: RE: Reading a PDF yup just seen that on the adobe site, tried and worked - thanks a lot. Do you think that this url is reliable long term? - i.e. will that converter always be available. Seems to take a while to execute too. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:20 To: CF-Talk Subject: RE: Reading a PDF Here's the code from one of my fusebox applications. !---@ Upload File --- cfif len(attributes.FILE_NAME) !---@ Pages with secure items must use the offline storage area. --- cffile action=UPLOAD filefield=FILE_NAME destination=#getdirectoryfrompath(getcurrenttemplatepath())#/documents nameconflict=MAKEUNIQUE cfset attributes.FILE_NAME = cffile.ServerFile cfset attributes.FILE_SIZE = cffile.FileSize !--- Determine filetype. --- cfset attributes.SUFFIX = listlast(attributes.FILE_NAME,.) cfinclude template=queries/qry_file_type_select.cfm cfif qry_file_type_select.recordcount EQ 0 cfset attributes.FILE_TYPE = application/unkown cfelse cfset attributes.FILE_TYPE = qry_file_type_select.FILE_TYPE /cfif !--- PDF files are converted to HTML --- cfif listlast(attributes.FILE_NAME,.) eq pdf cfhttp url=http://access.adobe.com/perl/convertPDF.pl; method=post resolveurl=no cfhttpparam type=formfield name=url value=#request.site.webRoot#/contentmanagement/documents/#attribu tes.file_n ame# /cfhttp !--- Now write the content away. --- cfset attributes.pdfhtmlfile = #createuuid()#.html cffile action=append file=#getdirectoryfrompath(getcurrenttemplatepath())#/documents/p dfhtmlfile s/#attributes.pdfhtmlfile# output=#cfhttp.FileContent# /cfif /cfif Hope this helps. You don't need to do the last write away. You can just use the contents of the check for the words you are looking for. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:49 To: CF-Talk Subject: RE: Reading a PDF I want to automatically read the contents and look for words and report back to CF if they are found. Don't want to use verity) as this is on a document by document basis. what happens if I use ReadBinary in the action attribute of the tag. Is the solution you suggest an automatic one? -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:27 To: CF-Talk Subject: RE: Reading a PDF What do you want to do with it? Suggestion: Load up your document to a web accessible directory, point Adobes PDF to HTML conversion system at the document, save away the content. Bingo! Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:14 To: CF-Talk Subject: Reading a PDF Any of you know how to automatically read the contents of a PDF using CF? ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading a PDF
yeh I thought that what I was getting seemed a bit poor. I think that there are some router problems at the mo which may be affecting stuff but it should affect the time it takes for CF to process the page - which it is saying is almost 2 minutes. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 12:46 To: CF-Talk Subject: RE: Reading a PDF My server can do a 4 MB file in under 10 seconds. Is it a 256K bits leased line? How many other people are using the connection? Blah blah blah. What's surfing the internet from the server like? Lots of reasons why. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:59 To: CF-Talk Subject: RE: Reading a PDF This particular file is 76kb -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:53 To: CF-Talk Subject: RE: Reading a PDF And how big is your file? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:51 To: CF-Talk Subject: RE: Reading a PDF we have a 256k leased line. I think there may be problems saying that but CF is saying the page is taking about 100,000ms to execute -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:46 To: CF-Talk Subject: RE: Reading a PDF Well, If you think about it you are asking your server to submit the file to the adobe site. What't the connection like from your server to the net? As to the converter being always available. Ask them! We put a proviso in our contract that stated specifically that this was an external service and was not under our control. Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:37 To: CF-Talk Subject: RE: Reading a PDF yup just seen that on the adobe site, tried and worked - thanks a lot. Do you think that this url is reliable long term? - i.e. will that converter always be available. Seems to take a while to execute too. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:20 To: CF-Talk Subject: RE: Reading a PDF Here's the code from one of my fusebox applications. !---@ Upload File --- cfif len(attributes.FILE_NAME) !---@ Pages with secure items must use the offline storage area. --- cffile action=UPLOAD filefield=FILE_NAME destination=#getdirectoryfrompath(getcurrenttemplatepath())#/documents nameconflict=MAKEUNIQUE cfset attributes.FILE_NAME = cffile.ServerFile cfset attributes.FILE_SIZE = cffile.FileSize !--- Determine filetype. --- cfset attributes.SUFFIX = listlast(attributes.FILE_NAME,.) cfinclude template=queries/qry_file_type_select.cfm cfif qry_file_type_select.recordcount EQ 0 cfset attributes.FILE_TYPE = application/unkown cfelse cfset attributes.FILE_TYPE = qry_file_type_select.FILE_TYPE /cfif !--- PDF files are converted to HTML --- cfif listlast(attributes.FILE_NAME,.) eq pdf cfhttp url=http://access.adobe.com/perl/convertPDF.pl; method=post resolveurl=no cfhttpparam type=formfield name=url value=#request.site.webRoot#/contentmanagement/documents/#attribu tes.file_n ame# /cfhttp !--- Now write the content away. --- cfset attributes.pdfhtmlfile = #createuuid()#.html cffile action=append file=#getdirectoryfrompath(getcurrenttemplatepath())#/documents/p dfhtmlfile s/#attributes.pdfhtmlfile# output=#cfhttp.FileContent# /cfif /cfif Hope this helps. You don't need to do the last write away. You can just use the contents of the check for the words you are looking for. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:49 To: CF-Talk Subject: RE: Reading a PDF I want to automatically read the contents and look for words and report back to CF if they are found. Don't want to use verity) as this is on a document by document basis. what happens if I use ReadBinary in the action attribute of the tag. Is the solution you suggest an automatic one? -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:27 To: CF-Talk Subject: RE: Reading a PDF What do you want to do with it? Suggestion: Load up your document to a web accessible directory, point Adobes PDF to HTML conversion system at the document, save away the content. Bingo! Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED
RE: Reading a PDF
doh! - sorry, being a bit think at the mo. Thanks for all your help - I'll try again when things are back up and working properly -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 12:55 To: CF-Talk Subject: RE: Reading a PDF Err, Of course it will effect the performance, part of what the page is doing is posting a file to the Adobe siter and waiting for the response... -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 12:52 To: CF-Talk Subject: RE: Reading a PDF yeh I thought that what I was getting seemed a bit poor. I think that there are some router problems at the mo which may be affecting stuff but it should affect the time it takes for CF to process the page - which it is saying is almost 2 minutes. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 12:46 To: CF-Talk Subject: RE: Reading a PDF My server can do a 4 MB file in under 10 seconds. Is it a 256K bits leased line? How many other people are using the connection? Blah blah blah. What's surfing the internet from the server like? Lots of reasons why. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:59 To: CF-Talk Subject: RE: Reading a PDF This particular file is 76kb -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:53 To: CF-Talk Subject: RE: Reading a PDF And how big is your file? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:51 To: CF-Talk Subject: RE: Reading a PDF we have a 256k leased line. I think there may be problems saying that but CF is saying the page is taking about 100,000ms to execute -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:46 To: CF-Talk Subject: RE: Reading a PDF Well, If you think about it you are asking your server to submit the file to the adobe site. What't the connection like from your server to the net? As to the converter being always available. Ask them! We put a proviso in our contract that stated specifically that this was an external service and was not under our control. Adam -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:37 To: CF-Talk Subject: RE: Reading a PDF yup just seen that on the adobe site, tried and worked - thanks a lot. Do you think that this url is reliable long term? - i.e. will that converter always be available. Seems to take a while to execute too. -Original Message- From: Adam Reynolds [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 11:20 To: CF-Talk Subject: RE: Reading a PDF Here's the code from one of my fusebox applications. !---@ Upload File --- cfif len(attributes.FILE_NAME) !---@ Pages with secure items must use the offline storage area. --- cffile action=UPLOAD filefield=FILE_NAME destination=#getdirectoryfrompath(getcurrenttemplatepath())#/documents nameconflict=MAKEUNIQUE cfset attributes.FILE_NAME = cffile.ServerFile cfset attributes.FILE_SIZE = cffile.FileSize !--- Determine filetype. --- cfset attributes.SUFFIX = listlast(attributes.FILE_NAME,.) cfinclude template=queries/qry_file_type_select.cfm cfif qry_file_type_select.recordcount EQ 0 cfset attributes.FILE_TYPE = application/unkown cfelse cfset attributes.FILE_TYPE = qry_file_type_select.FILE_TYPE /cfif !--- PDF files are converted to HTML --- cfif listlast(attributes.FILE_NAME,.) eq pdf cfhttp url=http://access.adobe.com/perl/convertPDF.pl; method=post resolveurl=no cfhttpparam type=formfield name=url value=#request.site.webRoot#/contentmanagement/documents/#attribu tes.file_n ame# /cfhttp !--- Now write the content away. --- cfset attributes.pdfhtmlfile = #createuuid()#.html cffile action=append file=#getdirectoryfrompath(getcurrenttemplatepath())#/documents/p dfhtmlfile s/#attributes.pdfhtmlfile# output=#cfhttp.FileContent# /cfif /cfif Hope this helps. You don't need to do the last write away. You can just use the contents of the check for the words you are looking for. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 27 January 2003 10:49 To: CF
CFServer passwords
Does anyone know where the CF administrator password is stored in the registry? - my mate has installed the server and rapidly forgotton what it is ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFServer passwords
thanks guys... -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 17 January 2003 17:19 To: CF-Talk Subject: RE: CFServer passwords Does anyone know where the CF administrator password is stored in the registry? - my mate has installed the server and rapidly forgotton what it is Rather than finding out what the existing password is, you can simply disable the use of the password, then reset it to whatever you like. If you're running CF 5 or earlier, edit the registry, and set this value to 0: HKLM\SOFTWARE\Allaire\ColdFusion\CurrentVersion\Server\UseAdminPassword If you're running on Linux/Solaris/HPUX, you'll need to stop the server before making the edit, then restart it after you've edited the registry. On Unices, there's no actual registry, so this info is stored in the file cf.registry (typically /opt/coldfusion/registry/cf.registry). If you're running CFMX, you'll want to stop the service, edit neo-security.xml, find var name='admin.security.enabled'boolean value='true'//var and set the value to false, then restart the service. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Another Newbie Problem
I personally donnever create date objects in CF and pass them into SQL - can cause all sorts of probs with the interpretation depending on your SQL settings. what I'd do is create a date in the format dd/mm/ as a character string and then run SET DATEFORMAT DMY before your select statement...but then that's just me. -Original Message- From: Luce, Greg [mailto:[EMAIL PROTECTED]] Sent: 11 December 2002 16:19 To: CF-Talk Subject: RE: Another Newbie Problem If you have a search form with a month select and a year selectbox. And you're searching for records with call_date newer than the selected values. cfset compare_date = #createdate(form.year_search,form.month_search,01)# SELECT * FROM tblTable WHERE call_date '#compare_date#' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 8:57 AM To: CF-Talk Subject: RE: Another Newbie Problem Rick, Can you explain your situation a little more in depth? There are datepart() functions that allow us to compare parts of dates. Greg Sure, thanks for the interest. We have several thousand records in a db with a standard odbc datetime stamp column. We want to be able to filter out end of month statistics (all trouble calls in November, 2002, for instance) by using a set of drop down menus (month, year, type of call). This is the kind of product one sees everywhere on the internet, but I just can't find a reference piece to get my head in the right place about how to go about it. Plus, as I've learned, there are always several approaches to the same problem. Any ideas are appreciated. Rick ***Sterling Financial Investment Group, Inc. (SFIG) is a member of NASD/MSRB/NFA/SIPC. Email transmissions may be monitored. SFIG cannot accept orders to buy or sell via email. Please visit www.mysterling.com for more information.*** ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: OT - SQL Help
I'm a bit confused - I'm not sure what you mean by the error you are getting. What scope are you trying to request the variable un from? Is it a form variable or url? Normally you'd access these using Request.Form(un) (for form vars) If they are local vars then just reference them as un. Not saying that what you have will cause errors - just not seen it written like that b4. -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 16:31 To: CF-Talk Subject: OT - SQL Help Hi all, Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND Registered = 1 Where Email is the primary email and SEmail is a secondary email address (both are different addresses). If the submission doesn't match the first then it matches the second, how do I account for that? Right now, I am getting an error because the record doesn't match. Any ideas? Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT - SQL Help
Sorry - I wasn't particularly clear. What I meant to say was that the request object has a number of collections associated with it (form, querystring, etc...). When I have used the request object I have always referenced an element of one of these collections e,g, request.form(un). Not seen it as you had it but not to say it sdoesn't work! Besides, assuming you aren't getting an error (just no record returned) then I think that Randell's post gives you the answer. -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 17:25 To: CF-Talk Subject: RE: OT - SQL Help No scope. It is written in ASP. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:46 AM To: CF-Talk Subject: RE: OT - SQL Help I'm a bit confused - I'm not sure what you mean by the error you are getting. What scope are you trying to request the variable un from? Is it a form variable or url? Normally you'd access these using Request.Form(un) (for form vars) If they are local vars then just reference them as un. Not saying that what you have will cause errors - just not seen it written like that b4. -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 16:31 To: CF-Talk Subject: OT - SQL Help Hi all, Sorry for the OT but this should be a quick answer. This is in ASP (sorry). If I have the following: sql = SELECT * FROM SomeTable sql = sql WHERE Email = ' Request(un) ' sql = sql OR SEmail = ' Request(un) ' sql = sql AND IsDeleted = 0 sql = sql AND Password = ' Request(pw) ' sql = sql AND Approved = 1 sql = sql AND Registered = 1 Where Email is the primary email and SEmail is a secondary email address (both are different addresses). If the submission doesn't match the first then it matches the second, how do I account for that? Right now, I am getting an error because the record doesn't match. Any ideas? Thanks, Tony ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: OT - SQL Help
my ASP's not what it used to be! - so did Randells post sort it? -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 17:59 To: CF-Talk Subject: RE: OT - SQL Help Dave's absolutely right. I am a lil' lazy. The less typing the better! 8^) -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:56 PM To: CF-Talk Subject: RE: OT - SQL Help Sorry - I wasn't particularly clear. What I meant to say was that the request object has a number of collections associated with it (form, querystring, etc...). When I have used the request object I have always referenced an element of one of these collections e,g, request.form(un). Not seen it as you had it but not to say it doesn't work! You can use either syntax in ASP. I've generally used the more explicit syntax, myself. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: SQL vs PL/SQL
Do not underestimate it! - I've been using T-SQL for 5 years and know it pretty well. Got a job which was an oracle back end and tried to build the equivalent in Oracle and had a nightmare - however if you are just using SQL code in your CF using CFQueries then there wouldn't be much prob and you should be able to pick up the syntax differences as you go along -Original Message- From: Casey C Cook [mailto:ccook22;csc.com] Sent: 14 November 2002 16:34 To: CF-Talk Subject: OT: SQL vs PL/SQL If someone came to you and said we need someone to work with Oracle and PL/SQL to write some queries, but all you knew was SQL, how much of PL/SQL would you say you already knew, knowing there are some syntax differences between the two query writing languages? Im just trying to gauge how much work I will have to do to to pick up PL/SQL, a weekenda week...a month? Thanks, Casey Cook ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Stored proc help
Stick this code at the top of your SP: SET DATEFORMAT DMY -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:Rodney.Bruce;HQISEC.ARMY.MIL] Sent: 07 November 2002 19:29 To: CF-Talk Subject: RE: Stored proc help Sent it once but here it is again. It has the recommended changes and runs without errors but returns nothing? cfstoredproc procedure=sp_mySP datasource=SQLDB username=x password=xxx cfprocparam type=In cfsqltype=CF_SQL_TIMESTAMP dbvarname=startdate value=#CreateODBCDateTime(10/01/2000)# null=No CFprocresult name=Qtest /CFSTOREDPROC the username has full privileges to the db. and I have gone into the tables and verified that there are records with a start date after the one entered. and if the storedproc is run from the SQL server it returns records? -Original Message- From: Bryan Stevenson [mailto:bryan;electricedgesystems.com] Sent: Thursday, November 07, 2002 11:29 AM To: CF-Talk Subject: Re: Stored proc help How about we get to see some code instead of playing 20 questions ;-) 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: Bruce, Rodney S HQISEC/Veridian IT Services [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, November 07, 2002 9:49 AM Subject: RE: Stored proc help No params are dates -Original Message- From: Andy Ewings [mailto:andy.e;thoughtbubble.net] Sent: Thursday, November 07, 2002 10:26 AM To: CF-Talk Subject: RE: Stored proc help Is one of your parameters type text or ntext? -Original Message- From: Weaver, Anthony [mailto:AWeaver;Limitedbrands.com] Sent: 07 November 2002 17:07 To: CF-Talk Subject: RE: Stored proc help make sure that your date CFPROCPARAMS use the SQLDATESTAMP type and use CreateODBCDateTime(your date). i get this often on date formats -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:Rodney.Bruce;HQISEC.ARMY.MIL] Sent: Thursday, November 07, 2002 12:04 PM To: CF-Talk Subject: Stored proc help Hello all I am trying to call a storedproc from an SQL 7 db. and I get this error. Does anyone know what it means. ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented I have tested the connection through CF admin and it tests ok. If I leave out a param. I get the error the param is missing. SO I think the connection to the db if ok. Thanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFTalk you have a greeting card from Joe.
CFTalk, Joe has sent you a greeting card -- a postcard from Friend-Greetings.com. You can pickup your greeting card at Friend-Greetings.com by clicking on the link below. http://www.friend-greeting.com/203746/pickup.html?code=CFTalkid=0811024 Message: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: CFTalk you have a greeting card from Joe.
do not open this link - it is a virus. -Original Message- From: Andy Ewings [mailto:andy.e;thoughtbubble.net] Sent: 08 November 2002 16:18 To: CF-Talk Subject: CFTalk you have a greeting card from Joe. CFTalk, Joe has sent you a greeting card -- a postcard from Friend-Greetings.com. You can pickup your greeting card at Friend-Greetings.com by clicking on the link below. http://www.friend-greeting.com/203746/pickup.html?code=CFTalkid=0811024 Message: ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: (Admin) Virus
me too *embarrased face* - appologies for any inconvenience Michael... -Original Message- From: Bryan F. Hogan [mailto:bryan.hogan;digitalbay.net] Sent: 08 November 2002 17:06 To: CF-Talk Subject: RE: (Admin) Virus I want to appologize to everyone. I got an email from someone and was not thinking. I have removed the list from my contact list. :| Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL -Original Message- From: [EMAIL PROTECTED] [mailto:mdinowit;houseoffusion.com] Sent: Friday, November 08, 2002 11:45 AM To: CF-Talk Subject: (Admin) Virus I've blocked the subject that the virus gets sent on. If your response to the virus is blocked, this is the reason. I've already seen one that has not hit the list due to this. I'll take sterner steps against the virus if it starts to mutate its subject line (which should not happen due to its nature). Michael Dinowitz Master of the House of Fusion http://www.houseoffusion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Stored proc help
Is one of your parameters type text or ntext? -Original Message- From: Weaver, Anthony [mailto:AWeaver;Limitedbrands.com] Sent: 07 November 2002 17:07 To: CF-Talk Subject: RE: Stored proc help make sure that your date CFPROCPARAMS use the SQLDATESTAMP type and use CreateODBCDateTime(your date). i get this often on date formats -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:Rodney.Bruce;HQISEC.ARMY.MIL] Sent: Thursday, November 07, 2002 12:04 PM To: CF-Talk Subject: Stored proc help Hello all I am trying to call a storedproc from an SQL 7 db. and I get this error. Does anyone know what it means. ODBC Error Code = S1C00 (Driver not capable) [Microsoft][ODBC SQL Server Driver]Optional feature not implemented I have tested the connection through CF admin and it tests ok. If I leave out a param. I get the error the param is missing. SO I think the connection to the db if ok. Thanks Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
RE: HELP!! sql wierdness ERROR message
shove this code at the top of your SP: SET QUOTED_IDENTIFIER OFF What happens? -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:23 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Robertson-Ravo, Neil (REC) wrote: your table really should not be 50 fields in size I think a normalisation could be implemented.. before you reach the SQL Server limit on row size. We are doing an exercise of the mind on a fictitious database schema here (right Philip?). As such, it is quite easy to come up with something that has 50 fields and is perfectly normalized. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: HELP!! sql wierdness ERROR message
I agree with Phil too - let the DB do the work As far as connection pooling goes - I think there is a misunderstanding as to what it does. The most lengthy process (relatively) in going to a db and getting data is creating the connection itself. Connection pooling just holds on to connections for reuse - you still have to go back to the database and get the data and bring it back to the client via that connection. -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:Neil.Robertson-Ravo;csd.reedexpo.com] Sent: 04 November 2002 13:25 To: CF-Talk Subject: RE: HELP!! sql wierdness ERROR message A database is designed to perform SQL queries. Yes, true but I can see what Phil is saying; if you are constantly looping and reconnecting to the DB Server to perform what essentially could be completed with say an SP or a SQL Block then let the SQL Server perform what it is good at SQL. I would say that you would not find that much difference in peformace on basic Select, Insert, Update or Deletes (the standard CF/SQL Combos) but for more complex Joins etc you may find certain degredation in peformance.. N -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:20 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Stephen Moretti wrote: sending those requests as separate CFQuery tags is pretty much insane - building one big TSQL statement with one hit to the database server is a much better solution Why would that be insane? Because that's 50 connect/deconnect to the database via your DB driver Connection pooling? as opposed to one connect/disconnect and letting your DB do the job it was designed to do. A database is designed to perform SQL queries. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: HELP!! sql wierdness ERROR message
I'm not sure I follow this response? What I was saying/implying is that yes connection pooling would prevent you from having to reconnect from scratch each time but you would still be having to execute multiple SQL queries against the database which, if you got the DB to do it in one hit, would undoubtedly save you time -Original Message- From: Jochem van Dieten [mailto:jochemd;oli.tudelft.nl] Sent: 04 November 2002 13:41 To: CF-Talk Subject: Re: HELP!! sql wierdness ERROR message Andy Ewings wrote: As far as connection pooling goes - I think there is a misunderstanding as to what it does. The most lengthy process (relatively) in going to a db and getting data is creating the connection itself. Connection pooling just holds on to connections for reuse - you still have to go back to the database and get the data and bring it back to the client via that connection. What takes most time would be very database dependent. Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
auto refresh
I'm trying to auto refresh a page when the back button is clicked on the browser. At present the page that I'm going back to is an page which requires form variables from a previous page to run - if I hit back I get the usual Page Expired message ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: apologies...query display balled up
I don't think this will do it as the distinct operator works on ALL of the columns combined in the select clause and in this case each is unique so you will still get the same data back. What you need is to run the same query as you have but with an order by like so... SELECT * FROM events e, category c where e.category=c.cat_no or e.category2=c.cat_no ORDER BY event_no then continue using the group by in the cfoutput as you have. -Original Message- From: Robert Polickoski [mailto:rpolickoski;isrd.com] Sent: 18 October 2002 03:46 To: CF-Talk Subject: Re: apologies...query display balled up Tim, Use the keyword DISTINCT. I am guessing that because record #128 passes both tests, it is getting two result rows. I am not certain, but I think it will do the trick. Take care, -- Original Message -- From: Tim Laureska [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Fri, 18 Oct 2002 11:02:36 -0400 Man.. I apologize for how the first message came across formatted weird.please let me try again: I have an event calendar access database with two tables (one called category with two fields: cat_no and descr.. the other table is called events with many fields including two called category and category2) . Events can have one or two categories and each event should be reflected on one row of the table with description, location etc. The event_no is unique for each event The Table displays as shown below, but for example event# 128 should only come up on one row with Fine Food Beverage; Arts, Theatre Concerts shown under Category Description what's wrong with my code below ?? Event no. Category Description LOCATION CATEGORY CATEGORY2 128Fine Food Beverage; St Michaels; 1 5 126Sports - Youth; St Michaels; 1 2 128Arts, Theatre Concerts; St Michaels; 1 5 126Arts, Theatre Concerts; St Michaels; 1 2 cfquery datasource=cal_endar_2 name=findcal SELECT * FROM events e, category c where e.category=c.cat_no or e.category2=c.cat_no /cfquery table cfoutput query=findcal group=event_no tr td valign=top#event_no#/td tdcfoutput#descr#;/cfoutput/td td#town#/td td#category#/td td#category2#/td /tr /cfoutput /table Thanks in Advance Tim Laureska ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: SQL HELP
shouldn't make a difference. What field type is emp_id in table tblemployee? Is it the same as SYS_EMP_ID_NR in temptblJOBEVL? Are they integers? Your syntax looks fine to me. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:38 To: CF-Talk Subject: RE: SQL HELP first of all I don't think you need the first () try this. SELECT * FROM temptblJOBEVL WHERE SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee) .tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:40 AM To: CF-Talk Subject: SQL HELP For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. Thanks, Joshua Tipton SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
RE: SQL HELP
yes it may - unless you put ltrim(rtrim()) around the field values - change to an int and see what hapens -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:52 To: CF-Talk Subject: RE: SQL HELP Both char(10) I can change them to int is you think it would make a difference. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:44 AM To: CF-Talk Subject: RE: SQL HELP shouldn't make a difference. What field type is emp_id in table tblemployee? Is it the same as SYS_EMP_ID_NR in temptblJOBEVL? Are they integers? Your syntax looks fine to me. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:38 To: CF-Talk Subject: RE: SQL HELP first of all I don't think you need the first () try this. SELECT * FROM temptblJOBEVL WHERE SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee) tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:40 AM To: CF-Talk Subject: SQL HELP For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. Thanks, Joshua Tipton SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: SQL HELP
truncates them? - have you got leading 0's? Try this - although I don't think it will necessarily make a difference SELECT * FROM temptblJOBEVL WHERE LTRIM(RTRIM(SYS_EMP_ID_NR)) NOT IN (SELECT LTRIM(RTRIM(emp_id_nr)) FROM tblemployee) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 14:04 To: CF-Talk Subject: RE: SQL HELP The column is char 10 when I change it to int it truncates my numbers so I do not want that. Josh -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:59 AM To: CF-Talk Subject: RE: SQL HELP yes it may - unless you put ltrim(rtrim()) around the field values - change to an int and see what hapens -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:52 To: CF-Talk Subject: RE: SQL HELP Both char(10) I can change them to int is you think it would make a difference. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:44 AM To: CF-Talk Subject: RE: SQL HELP shouldn't make a difference. What field type is emp_id in table tblemployee? Is it the same as SYS_EMP_ID_NR in temptblJOBEVL? Are they integers? Your syntax looks fine to me. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 13:38 To: CF-Talk Subject: RE: SQL HELP first of all I don't think you need the first () try this. SELECT * FROM temptblJOBEVL WHERE SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee) tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:40 AM To: CF-Talk Subject: SQL HELP For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. Thanks, Joshua Tipton SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: SQL HELP FIXED
As I said - your syntax looked ok - however I wouldn't suggest that what you have is robust enough. If you are comparing 2 fields like this they ought to hold the same data. I would look at cleaning the data so that they don't contain the leading zero's or you add the leading zero's in the other table -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 14:11 To: CF-Talk Subject: RE: SQL HELP FIXED I put this where statment in and it fixed the problem. The emp_id_nr in tblemployee was null for empnr starting with six zeros. Josh DELETE FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee where emp_nr not like '00%')) -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:53 AM To: CF-Talk Subject: Re: SQL HELP Joshua Tipton wrote: For some unknown reason this query does not work correctly even though I know that there is data in temptbljobevl that does not match tblemployee data. Can someone please help me do this via a join. I doubt that rewriting as a join is going to solve anything. That would be a bug of a size that would be known, and it is not unlikely your database does that internally anyway. Maybe better to start looking if SYS_EMP_ID_NR and emp_id_nr don't have any NULL's, have the same datatype, are padded the same way or something. SELECT * FROM temptblJOBEVL WHERE (SYS_EMP_ID_NR NOT IN (SELECT emp_id_nr FROM tblemployee)) Rewriting that requires an OUTER JOIN, which might be less than efficient. But if you want to try: SELECT job.* FROMtemptblJOBEVL job LEFT JOIN tblemployee emp ON job.SYS_EMP_ID_NR = emp.emp_id_nr WHERE emp.emp_id_nr IS NULL I prefer the NOT EXISTS syntax, I think it is easier to read: SELECT job.* FROMtemptblJOBEVL job WHERE NOT EXISTS ( SELECT 1 FROMtblemployee emp WHERE job.SYS_EMP_ID_NR = emp.emp_id_nr ) All should return the same results, but have fun :) Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
RE: Full Text Indexs
this doesn't appear to be the case here. After eight still throws an error as after is reserved. eight however is ok. I have checked the noise.eng file and it is empty. Is there any weay of telling which noise file is being used? - I assume it's the English one -Original Message- From: Benoit Hediard [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 18:08 To: CF-Talk Subject: RE: Full Text Indexs It should only throw an error if all the search words are defined in the noise words file. For example : The will throw an error, The foo will return results based on foo search. In our application, we have customized the noise word file and put each full text SQL search in cftry blocks. If an error is thrown we create an empty recordset. For example : cftry cfquery name=qSearch datasource=#application.stConfig.DSN# select ID_NEWS as ID, TITLE_NEWS as Title, CREATEDBYID_NEWS as CreatedByID, CREATEDBY_NEWS as CreatedByLogin, CREATIONDATE_NEWS as CreationDate fromITEM_NEWS and (contains(TITLE_NEWS,'#arguments.Text#') or contains(DESCRIPTION_NEWS,'#arguments.Text#')) /cfquery cfcatch type=Database cfset qSearch = queryNew(ID,Title,CreatedByID,CreatedByLogin,CreationDate) /cfcatch /cftry Benoit Hediard www.benorama.com -Message d'origine- De : Andy Ewings [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 11 octobre 2002 18:41 À : CF-Talk Objet : RE: Full Text Indexs Hi We tried this but it didn't seem to work. We only changed the english one. When we search on these key words it still throws an ODBC error. Any ideas? Andy -Original Message- From: Benoit Hediard [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 13:23 To: CF-Talk Subject: RE: Full Text Indexs If you are using SQL Server 2000, all the noise words are defined in a text files, one per language, you can easily modify them (add/remove words) : ../Microsoft SQL Server/MSSQL/FTDATA/SQLServer/Config/noise.eng for english indexing ../Microsoft SQL Server/MSSQL/FTDATA/SQLServer/Config/noise.fra for french indexing . Once modified, you'll have to rebuild your full-text indexes. Benoit Hediard www.benorama.com -Message d'origine- De : Andy Ewings [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 11 octobre 2002 14:00 À : CF-Talk Objet : Full Text Indexs Bit OT but thought I'd test the SQL gurus on here - I have built some full text indexes and am trying to get it to ignore the ignored words if that makes sense. For exaple if I type after eight into a search box it gives an error as after is a reserved word. How to I get SQL to ignore these words when performing my fulltext query? Alternatively does anyone know where I can find a full list of these ignored words? Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Full Text Indexs
great - thanks Benoit - I'll take all this on board and re-assess
-Original Message-
From: Benoit Hediard [mailto:[EMAIL PROTECTED]]
Sent: 14 October 2002 18:00
To: CF-Talk
Subject: RE: Full Text Indexs
The noise word file used is the one corresponding to the language you
specified during the full-text index creation.
In the full-text indexing Wizard Select Table Columns step, you define a
Language for Word Breaker.
For example, we are using French (France) in our application, and it works
fine.
I recommand you not to empty the noise words files, you'll loose some great
capabilities of full-text search.
For example, if someone search for a letter/number or a common word ('the',
'or'...), those words should be ignored, otherwise you'll get plenty of
noise in your results.
Even if it is minimal, the noise words file should never be empty.
Perhaps, should you try to delete all the full-text indexes and re-create
them from scratch?
Benoit Hediard
www.benorama.com
-Message d'origine-
De : Andy Ewings [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 14 octobre 2002 17:18
À : CF-Talk
Objet : RE: Full Text Indexs
this doesn't appear to be the case here. After eight still throws an
error as after is reserved. eight however is ok. I have checked the
noise.eng file and it is empty. Is there any weay of telling which noise
file is being used? - I assume it's the English one
-Original Message-
From: Benoit Hediard [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2002 18:08
To: CF-Talk
Subject: RE: Full Text Indexs
It should only throw an error if all the search words are defined in the
noise words file.
For example :
The will throw an error,
The foo will return results based on foo search.
In our application, we have customized the noise word file and put each full
text SQL search in cftry blocks.
If an error is thrown we create an empty recordset.
For example :
cftry
cfquery name=qSearch datasource=#application.stConfig.DSN#
select ID_NEWS as ID,
TITLE_NEWS as Title,
CREATEDBYID_NEWS as CreatedByID,
CREATEDBY_NEWS as CreatedByLogin,
CREATIONDATE_NEWS as CreationDate
fromITEM_NEWS
and (contains(TITLE_NEWS,'#arguments.Text#')
or
contains(DESCRIPTION_NEWS,'#arguments.Text#'))
/cfquery
cfcatch type=Database
cfset qSearch =
queryNew(ID,Title,CreatedByID,CreatedByLogin,CreationDate)
/cfcatch
/cftry
Benoit Hediard
www.benorama.com
-Message d'origine-
De : Andy Ewings [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 11 octobre 2002 18:41
À : CF-Talk
Objet : RE: Full Text Indexs
Hi
We tried this but it didn't seem to work. We only changed the english one.
When we search on these key words it still throws an ODBC error. Any ideas?
Andy
-Original Message-
From: Benoit Hediard [mailto:[EMAIL PROTECTED]]
Sent: 11 October 2002 13:23
To: CF-Talk
Subject: RE: Full Text Indexs
If you are using SQL Server 2000, all the noise words are defined in a
text files, one per language, you can easily modify them (add/remove words)
:
../Microsoft SQL Server/MSSQL/FTDATA/SQLServer/Config/noise.eng for
english indexing
../Microsoft SQL Server/MSSQL/FTDATA/SQLServer/Config/noise.fra for french
indexing
.
Once modified, you'll have to rebuild your full-text indexes.
Benoit Hediard
www.benorama.com
-Message d'origine-
De : Andy Ewings [mailto:[EMAIL PROTECTED]]
Envoyé : vendredi 11 octobre 2002 14:00
À : CF-Talk
Objet : Full Text Indexs
Bit OT but thought I'd test the SQL gurus on here - I have built some full
text indexes and am trying to get it to ignore the ignored words if that
makes sense. For exaple if I type after eight into a search box it gives
an error as after is a reserved word. How to I get SQL to ignore these
words when performing my fulltext query?
Alternatively does anyone know where I can find a full list of these ignored
words?
Andy
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
RE: Full Text Indexs
Hi We tried this but it didn't seem to work. We only changed the english one. When we search on these key words it still throws an ODBC error. Any ideas? Andy -Original Message- From: Benoit Hediard [mailto:[EMAIL PROTECTED]] Sent: 11 October 2002 13:23 To: CF-Talk Subject: RE: Full Text Indexs If you are using SQL Server 2000, all the noise words are defined in a text files, one per language, you can easily modify them (add/remove words) : ../Microsoft SQL Server/MSSQL/FTDATA/SQLServer/Config/noise.eng for english indexing ../Microsoft SQL Server/MSSQL/FTDATA/SQLServer/Config/noise.fra for french indexing . Once modified, you'll have to rebuild your full-text indexes. Benoit Hediard www.benorama.com -Message d'origine- De : Andy Ewings [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 11 octobre 2002 14:00 À : CF-Talk Objet : Full Text Indexs Bit OT but thought I'd test the SQL gurus on here - I have built some full text indexes and am trying to get it to ignore the ignored words if that makes sense. For exaple if I type after eight into a search box it gives an error as after is a reserved word. How to I get SQL to ignore these words when performing my fulltext query? Alternatively does anyone know where I can find a full list of these ignored words? Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
OT - Thoughtbubble
Sorry to be OT guys but have any of you New Yorkers heard of a Web Design Agency called Thought Bubble Productions? (in New York and Boston) __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
MX, IE6 and Client Vars
Has anyone had the problem where the standard code you stick in your application.cfm to kill sessions (when using client vars) does not work for users on IE6 when your site is being delivered by CFMX? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFMX q's.......
2 questions: 1. Can you store query resultsets in session vars? 1. Do you have to lock session vars in CFMX? I am pretty sure the answer to 1. is yes but cannot remember the answer to 2. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Escaping characters
Does anyone know how to escape charachters in SQL server - to be more specific I am buiding a string where I need to escape a double quote so the string isn't prematurely completed. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Ccaching resultsets
Can you guys advise as to the best way to cache resultsets that are user specific. I have a situ whereby users are performing searches and doing a next/previous and I don't want to go to the DB everytime to get the results again but want to look at all of the ways of allowing the resultset to persist across requests __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Slightly OT: CFQuery, Oracle and Limiting rows
Rob I have asked a similar question on this forum - I think the best bet is to cache the query results and then use the query a query functionality (assuming you are using CF5 or above). How best to cache the query will depend on whether the results are specific to users or not. If not then you can cache in the Application scope. If it is specific to users then I think you can cache in the session scope although my questio (which I am still awaiting responses to) asks how best to do this... Andy -Original Message- From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]] Sent: 28 August 2002 14:43 To: CF-Talk Subject: Slightly OT: CFQuery, Oracle and Limiting rows I have a query that returns about 5000+ rows of data. Currently it takes about 51 seconds to execute (it's a very complex query). I'm only displaying 100 records per page using start and end rows in a cfloop. The problem is that the query gets executed every time I go to a page and it take 50 seconds or so each time. I know I can use MAXROWS in my cfquery tag to limit the return to 100 rows, but that will only get me the first 100. Does anyone know how to set it up so I can get the second 100, or third or fortieth? I would guess this needs to be done in oracle instead of CF, but there may be a custom tag I don't know about. (About the data: There is no iterator or counter on the rows so I cannot do a select where rowid between 1 and 100 or 101 and 200 and so on. Each row has a unique value in it, and can be added to or deleted from at any time. Also, the data needs to be real-time so caching a query is out of the question as well.) Any suggestions would be greatly appreciated. My phone is ringing off the hook with complaints of the slow response. Thanks, Rob Edwards Phone: (502) 359-1627 Systems Management Tools Pager: (502) 478-1116 United Parcel Service Fax:(502) 359-0094 EMail: [EMAIL PROTECTED] (2B || !2B) == ? __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server - default to current date
yep -Original Message- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: 22 August 2002 13:38 To: CF-Talk Subject: RE: SQL Server - default to current date Isnt it getDate() ? -Original Message- From: Bosky, Dave [mailto:[EMAIL PROTECTED]] Sent: 22 August 2002 13:36 To: CF-Talk Subject: SQL Server - default to current date What's the syntax for inserting the current date as a default value in SQL Server? Dave Bosky, Net+ ~HTC Senior Multimedia Web Designer ~Phone: 843.369.8613 ~Fax: 843.369.8715 ~Email: [EMAIL PROTECTED] HTC Disclaimer: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL indexes
I know this is a SQL query and really should be elsewhere but in case anyone knows the answer.. Can anyone tell me how to bring back the equivalent rows using CONTAINS and fulltext indexes that are brought back from the query: SELECT dc.* FROM DOCUMENT_SEARCH dc WHERE (dc.title LIKE '%Cowboy%') When I run SELECT dc.* FROM DOCUMENT_SEARCH dc WHERE CONTAINS(dc.title, '%cowboy%') I do not get rows where the title is cowboys and if I run: SELECT dc.* FROM DOCUMENT_SEARCH dc WHERE CONTAINS(dc.title, 'FORMSOF (INFLECTIONAL,cowboy)') I do get rows where it is cowboys but not the ones that are, say, ecowboys __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL indexes
Yeh I know - actually it doesn't seem to make a blind bit of difference - get the same records back -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 21 August 2002 11:51 To: CF-Talk Subject: Re: SQL indexes SELECT dc.* FROM DOCUMENT_SEARCH dc WHERE CONTAINS(dc.title, ' *cowboy* ') contrary to normal sql, the full text functions want * as wild search phrases contained in (double quotes). __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SQL Problem
For you SQL guys out there. Do you know if there is an easy way to combine values from multiple rows? e.g. If I have a select from a table that brings back 1 column of names say... id Name 1 Andy 2 Steve 3 Ian 4 James Is there a way of combining these into a list without having to use cursors? __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Certification
benefits are that when you pass they give you this cool little watch.and you may find it a bit easier to get interviews I guess CF 5 cert will last till Dec 2003 I think - then you will need to upgrade Andy -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 17:12 To: CF-Talk Subject: Certification For those CF Certified Devs, what are the benefits. Also is it best to wait to take the CF6 cert or get CF5 cert than get CF6 cert. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: salary...
location, company and experience are big factors - I'd say if you were in London and had a couple of years experience the ave is somewhere between 30 and 40k (although could be way off). Having said that the boys in the banks in the city will get closer to double that -Original Message- From: Buddy [mailto:[EMAIL PROTECTED]] Sent: 15 August 2002 17:29 To: CF-Talk Subject: salary... Would it be inappropriate to have a discussion about salary here? It seems like an important thing for a CF developer to know what other folks are making in the marketplace. I can see it being useful for newbies to know what goals they can reasonably reach for as their experience grows. And also for guys like me who have been in the biz for a while to know if they've hit the CF_Max_Salary. Any thoughts. Buddy __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Backward compatibility
Just started to use MX and am finding that load of the code I've written in 4.5/5 is not backward compatible. e.g cfvarname attribute in cf 4.5/5 is now variable? - anyone know what the attribute dbvarname has changed to? Bit shoddy if you ask me -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backward compatibility
Thanks for all these guys - will be useful. Don't people think that Macromedia should have covered this so upgrading would be seamless? - surely this is a put-off for people to upgrade -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 13:08 To: CF-Talk Subject: RE: Backward compatibility You should also check the code analyzer, which is in the admin. It can scan your code and identify tags that will no longer work as well as tags that have been deprecated so may not work in the future. Phil Macromedia -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:58 AM To: CF-Talk Subject: RE: Backward compatibility I found this to be very helpful.. what tag are you referring to in your post? http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt0.jsp http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt03.jsp#2451739 http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt04.jsp#2451949 Mike -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:45 AM To: CF-Talk Subject: Backward compatibility Just started to use MX and am finding that load of the code I've written in 4.5/5 is not backward compatible. e.g cfvarname attribute in cf 4.5/5 is now variable? - anyone know what the attribute dbvarname has changed to? Bit shoddy if you ask me -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backward compatibility
I agree that adding new features is good like Style sheets instead of font tags etc but you should still support it - at least for 1 version jump! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 13:29 To: CF-Talk Subject: RE: Backward compatibility Yanno, sometimes things have to change. Nothing wrong with blowing the dust off your old code now and then. Sure, you didn't want too, but ... before installing *anything* new, you should always check to see what has changed, it's a good practice. ~Todd On Thu, 25 Jul 2002, Andy Ewings wrote: Thanks for all these guys - will be useful. Don't people think that Macromedia should have covered this so upgrading would be seamless? - surely this is a put-off for people to upgrade -- Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/ | Team Macromedia Volunteer for ColdFusion | http://www.macromedia.com/support/forums/team_macromedia/ | http://www.flashCFM.com/ - webRat (Moderator)| http://www.ultrashock.com/ - webRat (Back-end Moderator) | __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backward compatibility
Phil Yeh I'm not disagreeing that you haven't clearly explained the depreciated tags etcmy argument is that if I'm upgrading from one product version to the next with only 1 step in the jump all of my code should be supported - hence backward compatibility - just good practice I would have said. -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 14:03 To: CF-Talk Subject: RE: Backward compatibility I don't want to be testy, but in what way have we not covered it: -- we provide a book in the documentation called migrating ColdFusion 5 applications which talks about all the deprecated tags and tells you how to use the analyzer -- we built the code compatibility analyzer These resources may be imperfect (they always are), but they're pretty substantial. Is there something else you're thinking of specifically? Phil -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 8:18 AM To: CF-Talk Subject: RE: Backward compatibility Thanks for all these guys - will be useful. Don't people think that Macromedia should have covered this so upgrading would be seamless? - surely this is a put-off for people to upgrade -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 13:08 To: CF-Talk Subject: RE: Backward compatibility You should also check the code analyzer, which is in the admin. It can scan your code and identify tags that will no longer work as well as tags that have been deprecated so may not work in the future. Phil Macromedia -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:58 AM To: CF-Talk Subject: RE: Backward compatibility I found this to be very helpful.. what tag are you referring to in your post? http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt0.jsp http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt03.jsp#2451739 http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt04.jsp#2451949 Mike -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:45 AM To: CF-Talk Subject: Backward compatibility Just started to use MX and am finding that load of the code I've written in 4.5/5 is not backward compatible. e.g cfvarname attribute in cf 4.5/5 is now variable? - anyone know what the attribute dbvarname has changed to? Bit shoddy if you ask me -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backward compatibility
Oops - double negative sorry - yep - I should have said ..have clearly explained I guess -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 16:36 To: CF-Talk Subject: RE: Backward compatibility Just to be clear, your statement that: I'm not disagreeing that you haven't clearly explained reduces to I'm disagreeing that you have clearly explained. I had to read it four times to get your meaning. Jerry Johnson [EMAIL PROTECTED] 07/25/02 11:09AM Phil Yeh I'm not disagreeing that you haven't clearly explained the depreciated tags etcmy argument is that if I'm upgrading from one product version to the next with only 1 step in the jump all of my code should be supported - hence backward compatibility - just good practice I would have said. -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 14:03 To: CF-Talk Subject: RE: Backward compatibility I don't want to be testy, but in what way have we not covered it: -- we provide a book in the documentation called migrating ColdFusion 5 applications which talks about all the deprecated tags and tells you how to use the analyzer -- we built the code compatibility analyzer These resources may be imperfect (they always are), but they're pretty substantial. Is there something else you're thinking of specifically? Phil -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 8:18 AM To: CF-Talk Subject: RE: Backward compatibility Thanks for all these guys - will be useful. Don't people think that Macromedia should have covered this so upgrading would be seamless? - surely this is a put-off for people to upgrade -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 13:08 To: CF-Talk Subject: RE: Backward compatibility You should also check the code analyzer, which is in the admin. It can scan your code and identify tags that will no longer work as well as tags that have been deprecated so may not work in the future. Phil Macromedia -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:58 AM To: CF-Talk Subject: RE: Backward compatibility I found this to be very helpful.. what tag are you referring to in your post? http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt0.jsp http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt03.jsp#2451739 http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt04.jsp#2451949 Mike -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:45 AM To: CF-Talk Subject: Backward compatibility Just started to use MX and am finding that load of the code I've written in 4.5/5 is not backward compatible. e.g cfvarname attribute in cf 4.5/5 is now variable? - anyone know what the attribute dbvarname has changed to? Bit shoddy if you ask me -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFPROCPARAM behavior change with MX+Oracle?
With SQL server you had to specify the proc params in order regardless of CF version. Led me to wonder why you had to specify a dbvarname attribute at all if it didn't appear to be used. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 16:24 To: CF-Talk Subject: CFPROCPARAM behavior change with MX+Oracle? Hey all, I'm wondering if anybody else has noticed that CFStoredProc and CFProcParam behavior has changed (with Oracle) from Pre-MX to MX with respect to 'Named Notation' no longer working for Oracle in MX? Or was everybody just smart and have their CFProcParams in the right order before? In Pre-MX, you didn't have to have your CFProcParams in the same order as the SP (in Oracle). In MX, you do - which is consistant with Oracle JDBC. Or am I crazy... -- Edward Smith Internet Broadcasting System Director of Architecture http://www.ibsys.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Backward compatibility
No - I think you need to provide support for both methods. e.g style sheets and font tags are both supported in latest version of browsers but officially the font tag is depreciated - granted eventually it won't be supported but to give a jump like that will put off people from upgrading. If I'm an ISP hosting 30 sites on a server running CF 5 am I really going to bother to upgrade to the next version when I have to change the code across all sites.. -Original Message- From: Venable, John [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 16:27 To: CF-Talk Subject: RE: Backward compatibility But then how does any change come about? If it's backward compatible for any one version step, wouldn't it then never be any different? If 3.0 = 4 AND 4 = 4.5 AND 4.5 = 5 AND 5 = 6 THEN 3 = 6 Personally I'm surprised at how much doesn't break when you consider the magnitude of the update to the server software. John Venable -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 11:09 AM To: CF-Talk Subject: RE: Backward compatibility Phil Yeh I'm not disagreeing that you haven't clearly explained the depreciated tags etcmy argument is that if I'm upgrading from one product version to the next with only 1 step in the jump all of my code should be supported - hence backward compatibility - just good practice I would have said. -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 14:03 To: CF-Talk Subject: RE: Backward compatibility I don't want to be testy, but in what way have we not covered it: -- we provide a book in the documentation called migrating ColdFusion 5 applications which talks about all the deprecated tags and tells you how to use the analyzer -- we built the code compatibility analyzer These resources may be imperfect (they always are), but they're pretty substantial. Is there something else you're thinking of specifically? Phil -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 8:18 AM To: CF-Talk Subject: RE: Backward compatibility Thanks for all these guys - will be useful. Don't people think that Macromedia should have covered this so upgrading would be seamless? - surely this is a put-off for people to upgrade -Original Message- From: Phil Costa [mailto:[EMAIL PROTECTED]] Sent: 25 July 2002 13:08 To: CF-Talk Subject: RE: Backward compatibility You should also check the code analyzer, which is in the admin. It can scan your code and identify tags that will no longer work as well as tags that have been deprecated so may not work in the future. Phil Macromedia -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:58 AM To: CF-Talk Subject: RE: Backward compatibility I found this to be very helpful.. what tag are you referring to in your post? http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt0.jsp http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt03.jsp#2451739 http://livedocs.macromedia.com/cfmxdocs/CFML_Reference/Tags-pt04.jsp#2451949 Mike -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 25, 2002 7:45 AM To: CF-Talk Subject: Backward compatibility Just started to use MX and am finding that load of the code I've written in 4.5/5 is not backward compatible. e.g cfvarname attribute in cf 4.5/5 is now variable? - anyone know what the attribute dbvarname has changed to? Bit shoddy if you ask me -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com
Looping thru recordset
I think I already know the answer to this but is there a way of determining the position in a recordset of a particular value without having to loop thru it.? I have a recordset stored in an application variable which I want to query (CF 5) to find the pos of this record. I then want to get everything else after it in the recordset. I think the answer to this is I can't without looping thru all recs but I appear to have left my SQL hat at home today so I'm hoping one of you may prove me wrong :) -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Looping thru recordset
ah yes - I'll try this and see how performance is effected. Currently we are using this: cfloop query=application.queryname cfif fieldvaue = client.variable cfset whereami = currentrow cfset start = whereami cfbreak /cfif /cfloop cfoutput query=APPLICATION.gettable startrow=#start#. . . . . which can get pretty inefficient as the size of the rec set builds -Original Message- From: Chris Lofback [mailto:[EMAIL PROTECTED]] Sent: 22 July 2002 17:29 To: CF-Talk Subject: RE: Looping thru recordset Here's a possible CF solution: CFSET TargetValue = value you are looking for here CFSET StartRow = ListFind(ArrayToList(MyQuery[MyField]),TargetValue) CFOUTPUT QUERY=MyQuery STARTROW=#StartRow# BR#MyField# /CFOUTPUT Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 12:18 PM To: CF-Talk Subject: Looping thru recordset I think I already know the answer to this but is there a way of determining the position in a recordset of a particular value without having to loop thru it.? I have a recordset stored in an application variable which I want to query (CF 5) to find the pos of this record. I then want to get everything else after it in the recordset. I think the answer to this is I can't without looping thru all recs but I appear to have left my SQL hat at home today so I'm hoping one of you may prove me wrong :) -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Len() Equivalent in MS SQL 2K?
does Len() not work in SQL 2K? -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: 17 July 2002 16:47 To: CF-Talk Subject: Len() Equivalent in MS SQL 2K? I am using MS SQL Server 2K. Wondering if there is an equivalent to the CF Len() function to get string length that I can use in a WHERE clause: SELECT LastName FROM Member WHERE Len(LastName) 5 --- Ben Morris Web Site Developer American Federation of Government Employees, AFL-CIO (202) 639-6448 www.afge.org __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Len() Equivalent in MS SQL 2K?
I'm confused - I thought he was using SQL 2K?? -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: 17 July 2002 16:59 To: CF-Talk Subject: RE: Len() Equivalent in MS SQL 2K? It works in Access. In Oracle, the equivalent function is LENGTH(). WHERE LENGTH(imagefile) 0 does Len() not work in SQL 2K? -Original Message- From: BEN MORRIS [mailto:[EMAIL PROTECTED]] Sent: 17 July 2002 16:47 To: CF-Talk Subject: Len() Equivalent in MS SQL 2K? I am using MS SQL Server 2K. Wondering if there is an equivalent to the CF Len() function to get string length that I can use in a WHERE clause: SELECT LastName FROM Member WHERE Len(LastName) 5 --- Ben Morris Web Site Developer American Federation of Government Employees, AFL-CIO (202) 639-6448 www.afge.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Mass Email Solution
No probs but the only thing I noticed was that it took quite a while for all the mails to be sent -Original Message- From: James Maltby [mailto:[EMAIL PROTECTED]] Sent: 17 July 2002 17:06 To: CF-Talk Subject: RE: Mass Email Solution We've been sending a regular newsletter (about 3k html each mail) to 13,000 members via cfmail (on v.5.x server) - no probs with it - but chunk the main into about 3,000 mails at a time and include a requesttimeout=2000 scope at the end of your calling page (if you are using one) as the mails will send but you will get a time-out error. J -Original Message- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 17:04 To: CF-Talk Subject: Mass Email Solution Hey, Any suggestions on the best way to manage and send email to a list of about 10,000 in an efficient manner? Would I need to use a high-performance mail build? Should I not use cfmail, but a compiled tag? Thanks. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CFMX / CFC / FLASH Books.
but 6/MX will be substantially different then? -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 13:26 To: CF-Talk Subject: RE: CFMX / CFC / FLASH Books. Yep, although I may just jump to the CFMX test. The CF5 test really did not change that much from the CF4.5 one (which is why if you were certified for 4.5 you were automatically certified for CF5 as well). --- Ben -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: Friday, July 05, 2002 8:25 AM To: CF-Talk Subject: RE: CFMX / CFC / FLASH Books. Talking of books, will you still be adding the online sample test questions for the CF5 study guide to your site? Ade -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 13:18 To: CF-Talk Subject: RE: CFMX / CFC / FLASH Books. The X was a placeholder - the publishers did not know if CFMX would be CF6 or something else, and MM has strict policies dictating when that information could be shared, so many use X until they know for sure. Which works well until you try to get the listing updated. :-) --- Ben -Original Message- From: Jon Hall [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 04, 2002 11:13 PM To: CF-Talk Subject: Re: CFMX / CFC / FLASH Books. Old thread, but I just came across this at Amazon. Reality ColdFusion: Flash X Integration with CDROM Publisher: Macromedia Press by Ben Forta, Paul Mone, Randy Drisgill, Dennis Baldwin, Greg Rewis, Matt Tatam Available: August 15, 2002 http://www.amazon.com/exec/obidos/ASIN/0321125150/qid=1025838077/sr=8-1/ ref=sr_8_1/104-6101938-0002304 I think Amazon screwed up the book titles though, some of the MX books say Coldfusion X instead of MX. If someone at Macromedia reads this I'd get in touch with Amazon... This one also, which I have preordered :). http://www.amazon.com/exec/obidos/ASIN/0321127102/ref=pd_sim_books/104-6 101938-0002304 -- jon Saturday, June 29, 2002, 12:28:46 PM, you wrote: NH I would like to see a programmers guide to the subject. Is there NH anything available now? I know Kevin Towes is involved in a Flash NH MX book but how technical does that get?' __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Update with cflocation
Is your page that does the update a custom tag? -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 04 July 2002 10:27 To: CF-Talk Subject: RE: Update with cflocation Could you post your code, I don't see why this wouldn't work. Ade -Original Message- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: 04 July 2002 06:34 To: CF-Talk Subject: Update with cflocation I am doing some query updates and then following the processing with a cflocation When I use cflocation the updates do not take place (On MS SQL Server). When I remove the cflocation they process the update. I have heard the use of cfhtmlhead for redirection, does anyone have any example code to redirect to a different url? Or any other serverside type solutions would be even better. Thanks Paul Giesenhagen QuillDesign __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Help List Find
what error are you getting? -Original Message- From: Tipton Josh (orl1jdt) [mailto:[EMAIL PROTECTED]] Sent: 03 July 2002 12:25 To: CF-Talk Subject: Help List Find What is wrong with this? cfset server = www.dev.ser.ups.com, 10.19.72.122 cfset iplist = 10.18.74.246, 10.19.74.160, 10.19.73.39 cfif listfindnocase(server,server_name) and listfindnocase(iplist,REMOTE_ADDR) This is the development server please go to a href= Click'http://www.ser.ups.com/tsg/apps/overduedispo; http://www.ser.ups.com/tsg/apps/overduedispo Click Here!!/a cfabort /cfif __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Certification
Dave I'll back this up to a certain degree - I know a Micorsoft Trainer who took 10 fairly illiterate PC users (certainly not programmers) and got 6 of them through their MCSE in 8 weeks - that's 6 exams with an 80% pass mark for each. Now I don't care what anyone says but there is no way that these people can be as good as their qualification states. Having said this I think that certification certainly has it's merits but should be used alongside experience and a portfolio. I'd also add that learning about MX by playing around with it is a damn site more fun that exam cramming anyhow! :) -Original Message- From: Dave Carabetta [mailto:[EMAIL PROTECTED]] Sent: 03 July 2002 14:49 To: CF-Talk Subject: RE: Certification Which leads me to ask, when will the MX study guides be out??? Well, I can't answer that question specifically, but I would reply by saying Why wait? Dig into MX on your own and start playing around. I've found the docs sent with MX (not the language reference, but developing application, etc.) to be excellent ways of getting acquainted with MX. See, my problem with your response (and please don't take this as a personal attack, just an observation based on the several threads of this subject over the last few weeks) is that people are willing to memorize and study just what they tell you you'll need to know for the exam, instead of exploring MX and learning how to apply the concepts. That's been my problem with the CF certification (and other certs as well, but notably CF). It seems that if you buy a $25 book that says study this and you'll pass, you get CF certified. However, having worked with several people who are CF certified, both regular and advanced, they don't really know their ass from their elbow when it comes to some of the more intermediate to advanced CF concepts (i.e., custom tags, structures, etc.), which leads me to my current opinion that the certification means nothing more to me when I see people list it on their resumes than that they've worked with CF for at least a few months. Hence the term paper certification. I guess all I'm trying to say is what I said before -- try MX out on your own for yourself instead of waiting for what boils down to a cheat sheet. The docs are excellent (with some errors, sure, but MM's been responsive to fixing them quickly). In my experiments with CFCs, writing UDFs with CFFUNCTION, etc., I've figured out ways to simplify my coding experience beyond what any study guide could teach me. Again, I truly don't mean this as a personal attack on you. But this topic has come up several times over the last few weeks, and I just wanted to thrown my opinion in the ring. Flame away if you feel the need! ;) Regards, Dave. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Stored procedure problem
My advice would be to change the datatype of @agendatime to a varchar and pass the date in as dd/mm/. Then at the top of your SP put SET DATEFORMAT DMY. Then deal with it as a date. You can encounter big problems when passing a dat in CF thru to SQL I have found. Pass in as a varchar and let SQL do the work. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 01 July 2002 10:30 To: CF-Talk Subject: RE: Stored procedure problem Would trying to put an empty string into the agendatime cause any problems? -Original Message- From: angela alston [mailto:[EMAIL PROTECTED]] Sent: 29 June 2002 05:08 To: CF-Talk Subject: Re: Stored procedure problem Thanks Joshua. I ran the proc in the analyzer as you suggested it ran successfully, although, that was only one instance, not a loop. Could that make a difference? Also the sp is wrapped in a cftransaction with another sp that functions properly when on it's own. The code earlier was somewhat simplified. Thought it would be easier, but turns out more is better :) Here's the full code: stored proc: CREATE PROCEDURE spn_AddAgenda @attendeeid as integer, @eventid as integer, @exhibitorid as integer, @sessionid as integer, @agendatime as datetime, @notes as varchar(4000), @opt_in as integer AS BEGIN DECLARE @return_code as integer SET NOCOUNT ON select * from agenda where attendeeid = @attendeeid and eventid = @eventid and exhibitorid = @exhibitorid and sessionid = @sessionid if @@rowcount 0 begin set @return_code = 1 end else begin insert into agenda ( attendeeid, eventid, exhibitorid, sessionid, begin_datetime, notes, opt_in) values ( @attendeeid, @eventid, @exhibitorid, @sessionid, @agendatime, @notes, @opt_in) if @@error = 0 set @return_code = 0 else set @return_code = -1 END return @return_code END CF: cfloop list=#form.Meeting# Index=sessionid !--- Check database for the particular person and exhibitor add if necessary--- cfstoredproc datasource=#temp_vts_datasource# procedure=spn_AddAgenda returncode=Yes cfprocparam type=IN dbvarname=@attendeeid value=#session.StAttendee.id# cfsqltype=CF_SQL_INTEGER cfprocparam type=IN dbvarname=@eventid value=#temp_vts_eventid# cfsqltype=CF_SQL_INTEGER !--- eventid is session var --- cfprocparam type=IN dbvarname=@exhibitorid value=0 cfsqltype=CF_SQL_INTEGER cfprocparam type=IN dbvarname=@sessionid value=#sessionid# cfsqltype=CF_SQL_INTEGER cfprocparam type=IN dbvarname=@agendatime value= cfsqltype=CF_SQL_TIMESTAMP cfprocparam type=IN dbvarname=@notes value= cfsqltype=CF_SQL_VARCHAR cfprocparam type=IN dbvarname=@opt_in value=0 cfsqltype=CF_SQL_INTEGER /cfstoredproc !--- set up error handling --- cfset return = CFSTOREDPROC.STATUSCODE cfif #return# is -1 !--- error --- cfelseif #return# is 0 !--- record added --- cfelseif #return# is 1 !--- already in agenda --- /cfif /cfloop See anything wrong? Thanks. Angie - Original Message - From: Joshua Tipton [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, June 28, 2002 11:22 PM Subject: RE: Stored procedure problem Angela please past the code that is within your proc that error means that something is wrong in it. Try coping all the code out of your proc or running the proc in query analyzer with the inputs that would be passed to it via the cfstoredproc tag. Joshua Tipton -Original Message- From: angela alston [mailto:[EMAIL PROTECTED]] Sent: Friday, June 28, 2002 11:10 PM To: CF-Talk Subject: Stored procedure problem Hello, I have many checkboxes all named meeting with value populated by a query. They are submitted to another template where I'm *trying* to loop thru the list insert a record for each one that was checked. Can this be done? It seems simple, but I'm getting this error: ODBC Error Code = 22005 (Error in assignment) [Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification SQL = sp_meeting Data Source = datasource The datatypes parameter order exactly match the stored procedure. I'm using CF 4.5/SQL7.0. Here's the code: cfloop list=#form.Meeting# Index=meetingid cfstoredproc datasource=datasource procedure=sp_meeting returncode=Yes cfprocparam type=IN dbvarname=@attendeeid value=#session.Attendeeid# cfsqltype=CF_SQL_INTEGER cfprocparam type=IN dbvarname=@eventid value=#session.eventid# cfsqltype=CF_SQL_INTEGER cfprocparam type=IN dbvarname=@meetingid value=#meetingid# cfsqltype=CF_SQL_INTEGER /cfstoredproc /cfloop Any help is greatly appreciated. Angie __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe:
RE: What is the best variable scope?
they do - but what happens if your CF server is serving more than one website, each using a variable Application's with a diff value - hence the locking -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 17:15 To: CF-Talk Subject: RE: What is the best variable scope? AFAIK you have to lock application variables. (plus others!) -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 16:33 To: CF-Talk Subject: RE: What is the best variable scope? I usually only use the application scope for set variables that do not change. So there are only being read, Maybe I will look at locking those too, since two people could read the same variable at the same time. But I don't see any problems with not locking if the variable is only going to be read. Shawn Regan -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 7:36 AM To: CF-Talk Subject: RE: What is the best variable scope? Shared variables such as application and session should be locked, however the lock really only needs to be there on a write. Writing to a shared variable can cause the system to hang or enter a state of confusion, hence the locking of the variable. However although recommended to lock all reads and writes, I personally have never done it on a read of said such variables. It is also very safe to do the following... cflock cfset application.test = Test cfoutputHello/cfoutput /cflock All it means is that while this bit of code is being run, nobody else can access this bit of code until this process has released the lock. If 2 applications write to a variable at the exact same time (rare, but very possible) CF can enter a state of deadlock and will require the server to be restarted. For more information on this, consult the manual about the attributes scope and type that allow the variable to be read only or exclusive and to define the type of variable it is. For example is it an application, server or even session scope. But the point is well within what has been discussed many times on this list, should we or should we lock reading of variables. Like I said I don't when reading them, and have never had any problems (touch wood) with this method. But there are many reasons why one should use application scope variables, for example to determine how many people are actually logged into a membership system as a good example. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 27 June 2002 12:18 AM To: CF-Talk Subject: RE: What is the best variable scope? Why do you need to lock it? Shawn Regan __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What is the best variable scope?
Sorry, that should have said Application.DSN - not Application's -Original Message- From: Andy Ewings Sent: 26 June 2002 17:24 To: '[EMAIL PROTECTED]' Subject: RE: What is the best variable scope? they do - but what happens if your CF server is serving more than one website, each using a variable Application's with a diff value - hence the locking -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 17:15 To: CF-Talk Subject: RE: What is the best variable scope? AFAIK you have to lock application variables. (plus others!) -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 16:33 To: CF-Talk Subject: RE: What is the best variable scope? I usually only use the application scope for set variables that do not change. So there are only being read, Maybe I will look at locking those too, since two people could read the same variable at the same time. But I don't see any problems with not locking if the variable is only going to be read. Shawn Regan -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 7:36 AM To: CF-Talk Subject: RE: What is the best variable scope? Shared variables such as application and session should be locked, however the lock really only needs to be there on a write. Writing to a shared variable can cause the system to hang or enter a state of confusion, hence the locking of the variable. However although recommended to lock all reads and writes, I personally have never done it on a read of said such variables. It is also very safe to do the following... cflock cfset application.test = Test cfoutputHello/cfoutput /cflock All it means is that while this bit of code is being run, nobody else can access this bit of code until this process has released the lock. If 2 applications write to a variable at the exact same time (rare, but very possible) CF can enter a state of deadlock and will require the server to be restarted. For more information on this, consult the manual about the attributes scope and type that allow the variable to be read only or exclusive and to define the type of variable it is. For example is it an application, server or even session scope. But the point is well within what has been discussed many times on this list, should we or should we lock reading of variables. Like I said I don't when reading them, and have never had any problems (touch wood) with this method. But there are many reasons why one should use application scope variables, for example to determine how many people are actually logged into a membership system as a good example. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 27 June 2002 12:18 AM To: CF-Talk Subject: RE: What is the best variable scope? Why do you need to lock it? Shawn Regan __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What is the best variable scope?
but they persist across requests - hence the need for locking -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 17:31 To: CF-Talk Subject: RE: What is the best variable scope? I don't think that would matter, wouldn't they be unique to each Application. -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 17:25 To: CF-Talk Subject: RE: What is the best variable scope? Sorry, that should have said Application.DSN - not Application's -Original Message- From: Andy Ewings Sent: 26 June 2002 17:24 To: '[EMAIL PROTECTED]' Subject: RE: What is the best variable scope? they do - but what happens if your CF server is serving more than one website, each using a variable Application's with a diff value - hence the locking -Original Message- From: Neil Clark - =TMM= [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 17:15 To: CF-Talk Subject: RE: What is the best variable scope? AFAIK you have to lock application variables. (plus others!) -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 16:33 To: CF-Talk Subject: RE: What is the best variable scope? I usually only use the application scope for set variables that do not change. So there are only being read, Maybe I will look at locking those too, since two people could read the same variable at the same time. But I don't see any problems with not locking if the variable is only going to be read. Shawn Regan -Original Message- From: Andrew Scott [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 26, 2002 7:36 AM To: CF-Talk Subject: RE: What is the best variable scope? Shared variables such as application and session should be locked, however the lock really only needs to be there on a write. Writing to a shared variable can cause the system to hang or enter a state of confusion, hence the locking of the variable. However although recommended to lock all reads and writes, I personally have never done it on a read of said such variables. It is also very safe to do the following... cflock cfset application.test = Test cfoutputHello/cfoutput /cflock All it means is that while this bit of code is being run, nobody else can access this bit of code until this process has released the lock. If 2 applications write to a variable at the exact same time (rare, but very possible) CF can enter a state of deadlock and will require the server to be restarted. For more information on this, consult the manual about the attributes scope and type that allow the variable to be read only or exclusive and to define the type of variable it is. For example is it an application, server or even session scope. But the point is well within what has been discussed many times on this list, should we or should we lock reading of variables. Like I said I don't when reading them, and have never had any problems (touch wood) with this method. But there are many reasons why one should use application scope variables, for example to determine how many people are actually logged into a membership system as a good example. -Original Message- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 27 June 2002 12:18 AM To: CF-Talk Subject: RE: What is the best variable scope? Why do you need to lock it? Shawn Regan __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: problem with FB 3.0
Generally the syntax is Select fieldlist FROM server.database.user.table If administrator is not a table then this aint gonna work -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 June 2002 16:13 To: CF-Talk Subject: problem with FB 3.0 Greetings, I'm using FUSEBOX 3.0, apart from trying to get my head around how its structured, I'm getting this error, ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DBO.administrator'. SQL = SELECT USERNAME,PASSWORD FROM DBO.administrator WHERE USERNAME = 'asd' AND PASSWORD = 'asd' Data Source = UTILITYADMIN The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:4) to (13:30) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\ACT_LOGIN.CFM. The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\FBX_FUSEBOX30_CF50.CFM. DBO.administrator table does exist, // calling code CFQUERY NAME=validateUser DATASOURCE=#REQUEST.DSNAdmin# USERNAME=#REQUEST.user# PASSWORD=#REQUEST.key# SELECT USERNAME,PASSWORD FROMDBO.UtilityAdmin WHERE USERNAME = '#ATTRIBUTES.username#' AND PASSWORD = '#ATTRIBUTES.pass#' /CFQUERY //username dtype = varchar 10 //password dtype = ntext 16 I'm just wondering why an error is being reported below, The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\FBX_FUSEBOX30_CF50.CFM. and maybe if it has something to do with CF5.0 and FB3, I'M sorry if this is vague,its just a very basic DB login check, any ideas out there, especially any FB3.0 people, Respectfully, j __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: problem with FB 3.0
appologies - realised my last post isn't going to help much after reading your calling code - will have a rethink -Original Message- From: John McCosker [mailto:[EMAIL PROTECTED]] Sent: 20 June 2002 16:13 To: CF-Talk Subject: problem with FB 3.0 Greetings, I'm using FUSEBOX 3.0, apart from trying to get my head around how its structured, I'm getting this error, ODBC Error Code = S0002 (Base table not found) [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'DBO.administrator'. SQL = SELECT USERNAME,PASSWORD FROM DBO.administrator WHERE USERNAME = 'asd' AND PASSWORD = 'asd' Data Source = UTILITYADMIN The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (10:4) to (13:30) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\ACT_LOGIN.CFM. The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\FBX_FUSEBOX30_CF50.CFM. DBO.administrator table does exist, // calling code CFQUERY NAME=validateUser DATASOURCE=#REQUEST.DSNAdmin# USERNAME=#REQUEST.user# PASSWORD=#REQUEST.key# SELECT USERNAME,PASSWORD FROMDBO.UtilityAdmin WHERE USERNAME = '#ATTRIBUTES.username#' AND PASSWORD = '#ATTRIBUTES.pass#' /CFQUERY //username dtype = varchar 10 //password dtype = ntext 16 I'm just wondering why an error is being reported below, The error occurred while processing an element with a general identifier of (CFRETHROW), occupying document position (246:11) to (246:21) in the template file D:\INETPUB\WWWROOT\WEBSITES\UTILITYEYEADMIN\FBX_FUSEBOX30_CF50.CFM. and maybe if it has something to do with CF5.0 and FB3, I'M sorry if this is vague,its just a very basic DB login check, any ideas out there, especially any FB3.0 people, Respectfully, j __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Database layout advice?
If you go for option 2 and Normalise the structure some of your fields are redundant - i.e. you do not need detailid in table Model as you can get it through the foreign key makeid to the Make table and then use the detailid foreign key back to the detail table -Original Message- From: Tony Carcieri [mailto:[EMAIL PROTECTED]] Sent: 11 June 2002 19:14 To: CF-Talk Subject: RE: Database layout advice? Personally, I always do option 2. I like having very specific and detailed breakdown of what I am doing. It is easier for me to do on a whiteboard and observe the flow and relationship. Just my 2cents -Original Message- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 11, 2002 2:20 PM To: CF-Talk Subject: OT: Database layout advice? I am creating a database for the sale of autos online. I have mulled over how I should lay this out to function properly and decided to post this to the group for advice. Forgive me if this is a little long. Please keep in mind that I do not like setting anything static if I can help it. The 2 ways I have envisioned this is as follows and any input would help greatly (option 1) I though of placing all inventory into one table and just using the other tables to populate fields. [inventory] This table would hold all the details about the car. IE: make, model, year, vin, options, price etc... etc... [make] list of all makes to dynamically populate fields in application back-end [model] list of all models to dynamically populate fields in application back-end [options] list of all options to dynamically populate fields in application back-end (option 2) I thought of seperating all the colums in the inventory into seperate tables, but I would also have to make seperate tables for the populating of fields in the back-end IE: [details] id vin price [make] id detail_id make [model] id make_id detail_id model [options] id make_id model_id detail_id option1 option2 option3 [makeList] list of all makes to dynamically populate fields in application back-end [modelList] list of all models to dynamically populate fields in application back-end [optionsList] list of all options to dynamically populate fields in application back-end Douglas Brown Email: [EMAIL PROTECTED] __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
SetLocale()
Any one see what's wrong with this... cfset loacle = SetLocale(English (U.K.)) Aparently English (U.K.) is not a valid locale - do I need the quotations?when I remove them I get a different error.. In case it's of any importance I am running CF5 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SetLocale()
ta guys - strange Forta book (4.5) says U.K. - knew he couldn't be perfect ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 05 June 2002 17:03 To: CF-Talk Subject: Re: SetLocale() cfset loacle = SetLocale(English (U.K.)) i believe its English (UK) not English (U.K.) --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.368 / Virus Database: 204 - Release Date: 29/5/2545 __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Query help
almost! instead of SELECT @@identity = @id you need SELECT @id = @@identity -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 15:14 To: CF-Talk Subject: RE: Query help Kris, In your Stored Proc you can use one of SQL's own variables @@identity to get the row id for the record you have just inserted. Simply assign @@identity to a local var et voilà! HTH Stephen DECLARE @id as int INSERT INTO tableFoo (Col1,Col2,Col3) VALUES (a,b,c) SELECT @@identity = @id SELECT @id -Original Message- From: Kris Pilles [mailto:[EMAIL PROTECTED]] Sent: 21 May 2002 14:06 To: CF-Talk Subject: Query help How can Insert a record into a table (that I know how to do) but after the insert, I want to be able to know what the primary key for the record I just inserted... __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: OT (SQL): Add column to query?
This physically alters a table not a query - do you mean table or query Ryan? - if you mean query then just add the column name to the table. If you mean table then I try to steer clear of Alter table. What I tend to do is write an SP which creates a temp table of the old structure of your table and copy's all of the table across, then drops the table, recreates it with the new columns/restraints/permissions/index's etc... and then copies the data back across. Sounds like overkill I know but a very experienced DBA taught me to stay away from alter tables - can't remember why... -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:26 To: CF-Talk Subject: RE: OT (SQL): Add column to query? ALTER TABLE table_name ADD column_name datatype Or ALTER TABLE table_name DROP COLUMN column_name -Original Message- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: 20 May 2002 16:13 To: CF-Talk Subject: OT (SQL): Add column to query? I know this is OT, but I've seen some SQL on this list lately, so I figured I ask: Let's say I have this query: Col1Col2Col3 1 a 10 2 b 11 3 c 12 4 d 13 5 e 14 6 f 15 But I'd like to add a column to this query later in the process, so I'd have this: Col1Col2Col3myCol 1 a 10 24 2 b 11 24 3 c 12 24 4 d 13 24 5 e 14 24 6 f 15 24 Is there a queryAppend, or something I can use to add a column to a query in MSSQL? If it makes a difference, every value in the added column will be the same. Thanks for any help. Ryan __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Strange SQL error
In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter JuryTitle. If I comment out JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here CountryID int , JuryName varchar(100) , JuryTitle varchar(50) , JuryCompanyvarchar(50) , JuryCity varchar(50) , JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( CountryID , JuryName , test , JuryCompany , JuryCity , JuryTypeID ) IF error 0 BEGIN GOTO ERROR_EXIT END RETURN error ERROR_EXIT: RETURN error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange SQL error
ah - yes sorry - forgot to change it back -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Strange SQL error
Right fixed it - all we did was to move the declaration of the JuryTitle param to the bottom of the list and itr works! SQL schmeequel -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:50 To: CF-Talk Subject: RE: Strange SQL error I assume in this bit: VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID you're actually using VALUES ( @CountryID , @JuryName , @JuryTitle , @JuryCompany , @JuryCity , @JuryTypeID ? -Original Message- From: Andy Ewings [mailto:[EMAIL PROTECTED]] Sent: 17 May 2002 16:56 To: CF-Talk Subject: Strange SQL error In all my time developing SQL I have never come across sommat like this - please someone tell me I'm being stoopid as it's a Fri afternoon. I have the following SP which refuses to release - it says it cannot find parameter @JuryTitle. If I comment out @JuryTitle and the corresponding field insert it works. If I change the name of the variable it doesn'tsomeone slap me with a kipper so I can see where I've gone wrong... CREATE PROCEDURE JuryInsert -- Any parameters here @CountryID int , @JuryName varchar(100) , @JuryTitle varchar(50) , @JuryCompanyvarchar(50) , @JuryCity varchar(50) , @JuryTypeID int AS BEGIN INSERT INTO tblJury ( CountryID , JuryName , JuryTitle , JuryCompany , JuryCity , JuryTypeID ) VALUES ( @CountryID , @JuryName , @test , @JuryCompany , @JuryCity , @JuryTypeID ) IF @@error 0 BEGIN GOTO ERROR_EXIT END RETURN @@error ERROR_EXIT: RETURN @@error END GO -- Andy Ewings Director Thoughtbubble Ltd http://www.thoughtbubble.net -- United Kingdom http://www.thoughtbubble.net Tel: +44 (0) 20 7387 8890 -- New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 419 4235 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: What is this SQL Error?
I guess you could wait for a return code from the SP and test for it in your
code. Used to do this all the time with VB but never done it with CF
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: 17 May 2002 17:37
To: CF-Talk
Subject: RE: What is this SQL Error?
The DBA wants me to call a stored procedure, wait until the stored
procedure is done, then continue with the loop to call it again... Is there
a way to make sure the store procedure is done before the code continues?
-Original Message-
From: Hoag, Claudia (LNG) [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:27 PM
To: CF-Talk
Subject: RE: What is this SQL Error?
Thanks, I'll discuss that with our DBA.
I'm not using any CFTRANSACTION, though. What might have an impact here is
that this is a code that loops up to four times and does an insert every
time. The user selects up to four items, and then the code loops through
them and inserts a record in the table in each iteration. It's simple as
cfif listlen(selectedItems)
cfloop list=#selectedItems# index=thisSelectedItem
cfquery name=insertItem database=someDatabase
insert into someTable (col1,col2)
values (#thisUser#,#thisSelectedItem#)
/cfquery
/cfloop
/cfif
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:19 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
Subject: RE: What is this SQL Error?
I'm trying to figure out if ColdFusion locks the whole table
when running a cfquery.
This is entirely dependent on the database. CF is just a regular database
client, like any other database client.
I'm getting those deadlock errors in production, where too
many people access the same table at the same time. It never
happens in the development environment or in the testing
environment.
This makes sense, since you're less likely to have collisions with fewer
users.
But the thing is, I get deadlocks with insert queries!
Something simple as insert into sometable (col1, col2,
col3) values ('val1','val2','val3') This tells me that the
lock is not done on a row level, but on the table level.
I'm using MSSQL 7, and the DBA assures me that it would
lock at row level, so I'm guessing ColdFusion is requesting
a lock at table level somewhere. Is there a CFAdmin setting
for this?
No, as mentioned above, this isn't specific to CF; there's no CF Admin
setting for this. However, I wouldn't be so sure that locking is being done
on a row level. If I recall correctly, that's not the default behavior for
SQL Server 7. I think that SQL Server 7 locks pages (an internal storage
unit) rather than locking individual rows or locking the whole table.
Now, here's a problem. You may have several rows within a single page. Also,
if you're using an identity column as a primary key, and you've defined a
clustered index on that column, each insert will be physically located right
after the previous insert. So, if you have one page with one row being
inserted, and that page gets locked, and the database wants to write the
next row to the same page due to the clustered index (which by definition
matches the physical sort order of the column) that second write may be
delayed, and if the database is busy enough, that may cause problems. I've
heard that problem called a hotspot before. For a solution to this
problem, I'm not sure what route would be best to take, in your situation.
However, I'm not certain that this, by itself, is the problem you're having;
typically, I think that this problem simply causes things to get
significantly slower. A deadlock, on the other hand, implies that you have
two transactions occurring, and neither can complete until the other has
finished. So, the question for you is, are you doing anything else besides
the insert here? Are you using CFTRANSACTION or transactional logic within
your query/stored procedure also? On the other hand, for all I know, if the
hotspot issue gets bad enough, maybe that will return a deadlock error!
Your DBA should be able to help determine what's going on at the database
level, I hope.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
__
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
You need to select just the surname part in your select list and then order by that. e.g. if your field is called name try sommat like the following.. SELECT name, LEFT(name,CHARINDEX( ,name)) as 'fname', RIGHT(name,CHARINDEX( ,name)) as 'sname' FROM table ORDER by sname This assumes that your data is all ok - i.e. all confors to the format fname sname. i.e. if there is someone who's first or surnames have a space in them then you are a bit stuffed. I have no idea if this will work in access but should work in SQL. Sticky tape job but there you go.. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 17:07 To: CF-Talk Subject: RE: can this be done? Of course it is, the replies will come flooding in just you wait... ;O) -Original Message- From: Jeff Fongemie [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 17:05 To: CF-Talk Subject: can this be done? Hello cf-talk, I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] _ Composed on Monday, May 13, 2002, at 11:55:57 AM __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: can this be done?
I second this - even though I posted a selotape solution, to break down the info into 2 separate entities is the better option -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 17:24 To: CF-Talk Subject: RE: can this be done? I have an existing project where a form takes a field name and inserts in in a row name in an Access database. So, we have about 1000 names in the database as one name (firstname lastname). Now, the client changes his mind, and wants to be able to sort by last name, firstname. Yes, this was discussed prior to, and was deemed not needed. Is there a way, to somehow break up the full name into 2 fields, say by using the space as a separator? I would only need to do this once as it is an event. Could I make two new fields, last_name and first_name, then get the fullname, break it up using the space, then insert first_name, then last_name? Is this even possible? This would have been so much easier if client said yes to this at the design stage! Yes, this is certainly possible. Access has the necessary string functions to support this within SQL statements, and you could approach this in many ways - you could do a one-time, offline data transformation, and rewrite your code to work with the new table design, or you could incorporate the transformation process into your existing CF code. I'd recommend the first option, myself. I'll also take this opportunity to say that, despite the client's initial desires, there's no reason that you had to use one field, even if that's how the client wanted to see the data. It's a good idea, for exactly this reason, to break your data into its smallest components, so that you don't have to transform it later. Even if your client didn't want to see the two fields as separate, you could certainly have handled that in your CF code, and still had the two separate fields in the database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: sql Stored Proc
:) - good man Kevan!...I remember the days of some serious dynamic SQL strings (along with serious headaches!) - youll be pleased to know they they are all coming round again... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 12:35 To: CF-Talk Subject: RE: sql Stored Proc Thanks stephen. But then as an ex-thoughtbubbler I would naturally be right. -Original Message- From: Stephen Galligan [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 10:08 To: CF-Talk Subject: RE: sql Stored Proc I agree Kevan. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 02 May 2002 09:46 To: CF-Talk Subject: RE: sql Stored Proc I don't think you can use a variable to build dynamic sql like that. I think you have to build the sql statement in a string and then use execute(@yoursqlstring) to run it. -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: 01 May 2002 17:44 To: CF-Talk Subject: RE: sql Stored Proc Can anyone else give me any insight on this? -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:08 PM To: CF-Talk Subject: RE: sql Stored Proc I recieve an error incorrect synatx near the keyword and. declare @col as varchar(500) if(@rpttype) = 'Missing' begin set @col = ([desc] Like '%Missing%' OR [DESC] IS NULL) end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod where @col and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) -Original Message- From: Costas Piliotis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 12:00 PM To: CF-Talk Subject: RE: sql Stored Proc You missed the word AS in the declare statement: DECLARE @col AS nvarchar(30) -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 9:00 AM To: CF-Talk Subject: RE: sql Stored Proc If the colors didnt come across the declare and set all work fine the part that is giving me a problem is the @col when I try to use it in the query. Does anyone know how to make this work correctly? Joshua TIpton -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 01, 2002 11:35 AM To: CF-Talk Subject: sql Stored Proc The red protion works and I can output the variable my problem is the blue highlighted part. Is it possible to create that part of the query from what is in a variable? CREATE PROCEDURE sp_ctmdatacorp @corp char(4) = null, @reg_no char(4) =null, @dis_no char(4) =null, @date1 varchar(4), @date2 varchar(4) = null, @rpttype char(10) AS /*SELECT @corp, @reg_no, @dis_no, @date1,@date2, @rpttype*/ declare @col varchar(30) if(@rpttype) = 'Missing' begin set @col = [desc] Like '%Missing%' OR [DESC] IS NULL end set nocount on if (@corp is not null and @reg_no is null and @dis_no is null and @date1 is not null and @date2 is null) BEGIN SELECT m_id, y_id, reg_no, SUM(CASE WHEN SLIC NOT LIKE '88%' THEN cost ELSE 0 END) AS INTCOST, SUM(CASE WHEN SLIC LIKE '88%' THEN cost ELSE 0 END) AS exTCOST, CONVERT(datetime, (cast(m_id as varchar)) + '/01/' + (cast(y_id as varchar))) as dateinput into #blahtable FROM vw_CTMCORPAPPFULLVIEWprod WHERE (@col) and year = @date1 GROUP BY reg_NO, y_id, M_id ORDER BY cast(y_id as int), cast(m_id as int) insert into #blahtable SELECT DISTINCT dbo.tbl_CTMCORPMONTHYEARRDD.m_id, dbo.tbl_CTMCORPMONTHYEARRDD.y_id, dbo.tbl_CTMCORPMONTHYEARRDD.reg_no, 0 as intcost, 0 as extcost, CONVERT(datetime, (cast(tbl_CTMCORPMONTHYEARRDD.m_id as varchar)) + '/01/' + (cast(tbl_CTMCORPMONTHYEARRDD.y_id as varchar))) as dateinput FROM dbo.tbl_CTMCORPMONTHYEARRDD LEFT OUTER JOIN #blahtable ON dbo.tbl_CTMCORPMONTHYEARRDD.y_id = #blahtable.y_id AND dbo.tbl_CTMCORPMONTHYEARRDD.m_id = #blahtable.m_id AND dbo.tbl_CTMCORPMONTHYEARRDD.reg_no = #blahtable.reg_no WHERE (#blahtable.m_id IS NULL) AND (#blahtable.y_id IS NULL) AND (#blahtable.reg_no IS NULL) and dbo.tbl_CTMCORPMONTHYEARRDD.y_id = right(@date1,1) select * from #blahtable drop table #blahtable END __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives:
RE: SQL Server permission question
Yup - in SQL server you want to create a user that only has permissions to execute SP's. The DSN you set up that the webser uses needs to login using this user. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 May 2002 14:37 To: CF-Talk Subject: SQL Server permission question does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert, delete. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Server permission question
Oh - forgot to mention - every SP you create you then need to put a Grant Execute. to that user (or group) -Original Message- From: Andy Ewings Sent: 01 May 2002 14:44 To: '[EMAIL PROTECTED]' Subject: RE: SQL Server permission question Yup - in SQL server you want to create a user that only has permissions to execute SP's. The DSN you set up that the webser uses needs to login using this user. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 May 2002 14:37 To: CF-Talk Subject: SQL Server permission question does nayone know of a way to allow a user to only have permission to execute stored procedures in sql server and not select, update, insert, delete permissions directly? i want people to only be able to access the data in my database from a sp and not directly using select, update, insert, delete. Anthony Petruzzi Webmaster 954-321-4703 [EMAIL PROTECTED] http://www.sheriff.org __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
