RE: Experiences with VisualSourceSafe?
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, December 03, 2002 1:07 AM > To: CF-Talk > Subject: Experiences with VisualSourceSafe? > > > Hi All, > > Does anyone here use CFMX and Microsoft Visual SourceSafe? > If so, how do you like it? Are there any implementation or > usage issues we should know about? We tried it long ago (version 6 I think) and it had a lot of rough spots that made it unworkable for us. If I remember correctly (and it was a while ago) the main problem was that it didn't deal with outside changes very well - for example if somebody added a file to the working directory and didn't add it to the system it didn't show up in SourceSafe at all. > Also... on the same note... does anyone recommend using a > different software solution and if so why? We're using StarTeam (by StarBase, recently bought by Borland) and really like it. It's got some rough edges (what doesn't) but it works very well in a shared web environment. The problem above, for example, is solved: StarTeam shows such a file in the tool, but with a status of "Not in View". The tool is very complete: threaded discussion groups, defect management, change request management, etc - and everything can be linked to everything else (so you can have a business owner make a change request which is assigned to a developer, linked to a file attachment and a discussion thread on the problem and finally linked to the files that must be edited). StarTeam does require a server however (although the client is about the same as SourceSafe)... So it might be a little pricey for a small shop. Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Experiences with VisualSourceSafe?
Hi All, Does anyone here use CFMX and Microsoft Visual SourceSafe? If so, how do you like it? Are there any implementation or usage issues we should know about? Also... on the same note... does anyone recommend using a different software solution and if so why? -Novak ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CFX_Image - Quality of images not good when rotating
ever tried rotating an image a bunch of times in photoshop, or sizing/resizing/sizing, you will see a degredation of quality this way as wellh wonder if its related? ...tony -Original Message- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 12:18 AM To: CF-Talk Subject: CFX_Image - Quality of images not good when rotating Hi everyone, Has anyone experienced this when rotating images using this tag? The moment I rotate an image, the quality is degraded. I checked through the IML readme file that the tag comes with and after adding the quality command, there's been no improvement. Any thoughts? Thanks Mark ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
CFX_Image - Quality of images not good when rotating
Hi everyone, Has anyone experienced this when rotating images using this tag? The moment I rotate an image, the quality is degraded. I checked through the IML readme file that the tag comes with and after adding the quality command, there's been no improvement. Any thoughts? Thanks Mark
RE: shooting my server soon....
posimitively positive ;) but good lookin out!! tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:26 PM To: CF-Talk Subject: RE: shooting my server soon As lng as you are sure . -mk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 10:18 PM To: CF-Talk Subject: RE: shooting my server soon cf code u/p that is on a secondary page/step that if you dont know the correct u/p will just redirect you to the main page. im the only one with access...and really, is just for testing...but im the only one with access. trust me i get sick of explaining "pebkac" to clients and give them only sooo much access. tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:15 PM To: CF-Talk Subject: RE: shooting my server soon Are you speaking of an SQL server uname and pw? Or some form of login that you implement in your CF code? If it's SQL, then you can set up DB permissions in a very granular way and your risk is less (though not completely gone - if you are allowing update, insert or delete). If not, then you have the issue of raw SQL being passed to the SQL server. Either way, Unless you can be possitive that all the folks who are accessing the script are competent SQL writers - this is a great risk. What happens (for example) when someone puts in "update userTable SET fname = 'Bill' ", but they forget the where clause. Suddenly, all your users or named "Bill" . Sounds crazy - but do you remember the mistakes you use to make when you first started writing SQL? Or what if they experiment with the "truncate" key word - or "Drop" or "create". The possiblities are endless - and all really scary . -mk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 10:04 PM To: CF-Talk Subject: RE: shooting my server soon even with a username/password protecting it? tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:03 PM To: CF-Talk Subject: RE: shooting my server soon bingo - if you have a string you are building that includes single quotes, you have to use the "preservesinglequotes( )" function. Otherwise you would get exactly this syntax errror - the query without the function would end up being: update [reports] set password = ' '123xxx456' ' (two sets of single quotes). Tony, I wouldn't do it this way unless you are doing some kind of one-time query - or building some form of on-line query analyzer. The security risk is pretty high. I would at least restrict DML type queries using SQL permissions. -mk -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:48 PM To: CF-Talk Subject: RE: shooting my server soon So the entire SQL is inside the form field, including the single quotes? Then you need PreserveSingleQuotes()--and think about the security issue.. > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:44 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > > but not when i send this string from a form field > textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > > any idea? > > tony > > -Original Message- > From: David Notik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:26 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Try adding a valid WHERE clause and see if the statement works. > > UPDATE Reports SET Password = 'XX' WHERE ID=1 > > That will at least get you closer to diagnosing the cause. > > Also, be sure your CFQUERY tags have proper < and >. > > --Dave > > ### > David Notik > Digital202, LLC > Imagination gone digital. > Web: www.digital202.com > E-mail: [EMAIL PROTECTED] > Office: (206) 575-1717 > Mobile: (206) 351-3948 > ### > > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 7:21 PM > To: CF-Talk > Subject: RE: shooting my server soon > > ok. > > update [reports] set password = '' > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: > Incorrect syntax near ''. > Native Error Code: 170 > SQL State: HY000 > > same error? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:15 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL
RE: shooting my server soon....
As lng as you are sure . -mk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 10:18 PM To: CF-Talk Subject: RE: shooting my server soon cf code u/p that is on a secondary page/step that if you dont know the correct u/p will just redirect you to the main page. im the only one with access...and really, is just for testing...but im the only one with access. trust me i get sick of explaining "pebkac" to clients and give them only sooo much access. tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:15 PM To: CF-Talk Subject: RE: shooting my server soon Are you speaking of an SQL server uname and pw? Or some form of login that you implement in your CF code? If it's SQL, then you can set up DB permissions in a very granular way and your risk is less (though not completely gone - if you are allowing update, insert or delete). If not, then you have the issue of raw SQL being passed to the SQL server. Either way, Unless you can be possitive that all the folks who are accessing the script are competent SQL writers - this is a great risk. What happens (for example) when someone puts in "update userTable SET fname = 'Bill' ", but they forget the where clause. Suddenly, all your users or named "Bill" . Sounds crazy - but do you remember the mistakes you use to make when you first started writing SQL? Or what if they experiment with the "truncate" key word - or "Drop" or "create". The possiblities are endless - and all really scary . -mk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 10:04 PM To: CF-Talk Subject: RE: shooting my server soon even with a username/password protecting it? tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:03 PM To: CF-Talk Subject: RE: shooting my server soon bingo - if you have a string you are building that includes single quotes, you have to use the "preservesinglequotes( )" function. Otherwise you would get exactly this syntax errror - the query without the function would end up being: update [reports] set password = ' '123xxx456' ' (two sets of single quotes). Tony, I wouldn't do it this way unless you are doing some kind of one-time query - or building some form of on-line query analyzer. The security risk is pretty high. I would at least restrict DML type queries using SQL permissions. -mk -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:48 PM To: CF-Talk Subject: RE: shooting my server soon So the entire SQL is inside the form field, including the single quotes? Then you need PreserveSingleQuotes()--and think about the security issue.. > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:44 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > > but not when i send this string from a form field > textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > > any idea? > > tony > > -Original Message- > From: David Notik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:26 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Try adding a valid WHERE clause and see if the statement works. > > UPDATE Reports SET Password = 'XX' WHERE ID=1 > > That will at least get you closer to diagnosing the cause. > > Also, be sure your CFQUERY tags have proper < and >. > > --Dave > > ### > David Notik > Digital202, LLC > Imagination gone digital. > Web: www.digital202.com > E-mail: [EMAIL PROTECTED] > Office: (206) 575-1717 > Mobile: (206) 351-3948 > ### > > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 7:21 PM > To: CF-Talk > Subject: RE: shooting my server soon > > ok. > > update [reports] set password = '' > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: > Incorrect syntax near ''. > Native Error Code: 170 > SQL State: HY000 > > same error? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:15 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From
RE: shooting my server soon....
cf code u/p that is on a secondary page/step that if you dont know the correct u/p will just redirect you to the main page. im the only one with access...and really, is just for testing...but im the only one with access. trust me i get sick of explaining "pebkac" to clients and give them only sooo much access. tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:15 PM To: CF-Talk Subject: RE: shooting my server soon Are you speaking of an SQL server uname and pw? Or some form of login that you implement in your CF code? If it's SQL, then you can set up DB permissions in a very granular way and your risk is less (though not completely gone - if you are allowing update, insert or delete). If not, then you have the issue of raw SQL being passed to the SQL server. Either way, Unless you can be possitive that all the folks who are accessing the script are competent SQL writers - this is a great risk. What happens (for example) when someone puts in "update userTable SET fname = 'Bill' ", but they forget the where clause. Suddenly, all your users or named "Bill" . Sounds crazy - but do you remember the mistakes you use to make when you first started writing SQL? Or what if they experiment with the "truncate" key word - or "Drop" or "create". The possiblities are endless - and all really scary . -mk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 10:04 PM To: CF-Talk Subject: RE: shooting my server soon even with a username/password protecting it? tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:03 PM To: CF-Talk Subject: RE: shooting my server soon bingo - if you have a string you are building that includes single quotes, you have to use the "preservesinglequotes( )" function. Otherwise you would get exactly this syntax errror - the query without the function would end up being: update [reports] set password = ' '123xxx456' ' (two sets of single quotes). Tony, I wouldn't do it this way unless you are doing some kind of one-time query - or building some form of on-line query analyzer. The security risk is pretty high. I would at least restrict DML type queries using SQL permissions. -mk -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:48 PM To: CF-Talk Subject: RE: shooting my server soon So the entire SQL is inside the form field, including the single quotes? Then you need PreserveSingleQuotes()--and think about the security issue.. > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:44 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > > but not when i send this string from a form field > textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > > any idea? > > tony > > -Original Message- > From: David Notik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:26 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Try adding a valid WHERE clause and see if the statement works. > > UPDATE Reports SET Password = 'XX' WHERE ID=1 > > That will at least get you closer to diagnosing the cause. > > Also, be sure your CFQUERY tags have proper < and >. > > --Dave > > ### > David Notik > Digital202, LLC > Imagination gone digital. > Web: www.digital202.com > E-mail: [EMAIL PROTECTED] > Office: (206) 575-1717 > Mobile: (206) 351-3948 > ### > > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 7:21 PM > To: CF-Talk > Subject: RE: shooting my server soon > > ok. > > update [reports] set password = '' > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: > Incorrect syntax near ''. > Native Error Code: 170 > SQL State: HY000 > > same error? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:15 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in
RE: shooting my server soon....
Are you speaking of an SQL server uname and pw? Or some form of login that you implement in your CF code? If it's SQL, then you can set up DB permissions in a very granular way and your risk is less (though not completely gone - if you are allowing update, insert or delete). If not, then you have the issue of raw SQL being passed to the SQL server. Either way, Unless you can be possitive that all the folks who are accessing the script are competent SQL writers - this is a great risk. What happens (for example) when someone puts in "update userTable SET fname = 'Bill' ", but they forget the where clause. Suddenly, all your users or named "Bill" . Sounds crazy - but do you remember the mistakes you use to make when you first started writing SQL? Or what if they experiment with the "truncate" key word - or "Drop" or "create". The possiblities are endless - and all really scary . -mk -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 10:04 PM To: CF-Talk Subject: RE: shooting my server soon even with a username/password protecting it? tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:03 PM To: CF-Talk Subject: RE: shooting my server soon bingo - if you have a string you are building that includes single quotes, you have to use the "preservesinglequotes( )" function. Otherwise you would get exactly this syntax errror - the query without the function would end up being: update [reports] set password = ' '123xxx456' ' (two sets of single quotes). Tony, I wouldn't do it this way unless you are doing some kind of one-time query - or building some form of on-line query analyzer. The security risk is pretty high. I would at least restrict DML type queries using SQL permissions. -mk -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:48 PM To: CF-Talk Subject: RE: shooting my server soon So the entire SQL is inside the form field, including the single quotes? Then you need PreserveSingleQuotes()--and think about the security issue.. > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:44 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > > but not when i send this string from a form field > textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > > any idea? > > tony > > -Original Message- > From: David Notik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:26 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Try adding a valid WHERE clause and see if the statement works. > > UPDATE Reports SET Password = 'XX' WHERE ID=1 > > That will at least get you closer to diagnosing the cause. > > Also, be sure your CFQUERY tags have proper < and >. > > --Dave > > ### > David Notik > Digital202, LLC > Imagination gone digital. > Web: www.digital202.com > E-mail: [EMAIL PROTECTED] > Office: (206) 575-1717 > Mobile: (206) 351-3948 > ### > > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 7:21 PM > To: CF-Talk > Subject: RE: shooting my server soon > > ok. > > update [reports] set password = '' > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: > Incorrect syntax near ''. > Native Error Code: 170 > SQL State: HY000 > > same error? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:15 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in [] > > http://aspfaq.com/show.asp?id=2080 > > > > > > > > > -Original Message- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > > To: CF-Talk > > > Subject: shooting my server soon > > > > > > > > > why? > > > > > > update reports set password = '' > > > > > > will not work in my cf code on my cfmx server. > > > > > > i can run the same query in query analyzer, and all is well. > > > > > > any explanation would save my ***kin
RE: shooting my server soon....
even with a username/password protecting it? tony -Original Message- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 11:03 PM To: CF-Talk Subject: RE: shooting my server soon bingo - if you have a string you are building that includes single quotes, you have to use the "preservesinglequotes( )" function. Otherwise you would get exactly this syntax errror - the query without the function would end up being: update [reports] set password = ' '123xxx456' ' (two sets of single quotes). Tony, I wouldn't do it this way unless you are doing some kind of one-time query - or building some form of on-line query analyzer. The security risk is pretty high. I would at least restrict DML type queries using SQL permissions. -mk -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:48 PM To: CF-Talk Subject: RE: shooting my server soon So the entire SQL is inside the form field, including the single quotes? Then you need PreserveSingleQuotes()--and think about the security issue.. > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:44 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > > but not when i send this string from a form field > textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > > any idea? > > tony > > -Original Message- > From: David Notik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:26 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Try adding a valid WHERE clause and see if the statement works. > > UPDATE Reports SET Password = 'XX' WHERE ID=1 > > That will at least get you closer to diagnosing the cause. > > Also, be sure your CFQUERY tags have proper < and >. > > --Dave > > ### > David Notik > Digital202, LLC > Imagination gone digital. > Web: www.digital202.com > E-mail: [EMAIL PROTECTED] > Office: (206) 575-1717 > Mobile: (206) 351-3948 > ### > > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 7:21 PM > To: CF-Talk > Subject: RE: shooting my server soon > > ok. > > update [reports] set password = '' > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: > Incorrect syntax near ''. > Native Error Code: 170 > SQL State: HY000 > > same error? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:15 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in [] > > http://aspfaq.com/show.asp?id=2080 > > > > > > > > > -Original Message- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > > To: CF-Talk > > > Subject: shooting my server soon > > > > > > > > > why? > > > > > > update reports set password = '' > > > > > > will not work in my cf code on my cfmx server. > > > > > > i can run the same query in query analyzer, and all is well. > > > > > > any explanation would save my ***king server... > > > > > > thanks > > > > > > ...tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.
(SOLVED) RE: shooting my server soon....
preserveSingleQuotes() wow. what a novel concept. you all rock. back to my raiders beating the jets :) i can get back to football now!!! later. -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 02, 2001 10:57 PM To: CF-Talk Subject: RE: shooting my server soon ok, like samuel also said, maybe its my single quotes, ill check and let y'alls know ;) thanks. tony -Original Message- From: Antony Sideropoulos [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:52 PM To: CF-Talk Subject: RE: shooting my server soon In your form example, you may need to #PreserveSingleQuotes(form.sql)# Also confirm that the text isn't wrapping in the text box and picking up CRs and LFs. > >ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > >but not when i send this string from a form field >textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > >any idea? > >tony > >-Original Message- >From: David Notik [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 10:26 PM >To: CF-Talk >Subject: RE: shooting my server soon > > >Try adding a valid WHERE clause and see if the statement works. > >UPDATE Reports SET Password = 'XX' WHERE ID=1 > >That will at least get you closer to diagnosing the cause. > >Also, be sure your CFQUERY tags have proper < and >. > >--Dave > >### >David Notik >Digital202, LLC >Imagination gone digital. >Web: www.digital202.com >E-mail: [EMAIL PROTECTED] >Office: (206) 575-1717 >Mobile: (206) 351-3948 >### > > >-Original Message- >From: Tony Weeg [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 7:21 PM >To: CF-Talk >Subject: RE: shooting my server soon > >ok. > >update [reports] set password = '' > >Message: Error Executing Database Query. >Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect >syntax near ''. >Native Error Code: 170 >SQL State: HY000 > >same error? > >tony > >-Original Message- >From: Matthew Walker [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 10:15 PM >To: CF-Talk >Subject: RE: shooting my server soon > > >Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in [] > > http://aspfaq.com/show.asp?id=2080 > > > > > > > > > -Original Message- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > > To: CF-Talk > > > Subject: shooting my server soon > > > > > > > > > why? > > > > > > update reports set password = '' > > > > > > will not work in my cf code on my cfmx server. > > > > > > i can run the same query in query analyzer, and all is well. > > > > > > any explanation would save my ***king server... > > > > > > thanks > > > > > > ...tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: shooting my server soon....
bingo - if you have a string you are building that includes single quotes, you have to use the "preservesinglequotes( )" function. Otherwise you would get exactly this syntax errror - the query without the function would end up being: update [reports] set password = ' '123xxx456' ' (two sets of single quotes). Tony, I wouldn't do it this way unless you are doing some kind of one-time query - or building some form of on-line query analyzer. The security risk is pretty high. I would at least restrict DML type queries using SQL permissions. -mk -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:48 PM To: CF-Talk Subject: RE: shooting my server soon So the entire SQL is inside the form field, including the single quotes? Then you need PreserveSingleQuotes()--and think about the security issue.. > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:44 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > > but not when i send this string from a form field > textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > > any idea? > > tony > > -Original Message- > From: David Notik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:26 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Try adding a valid WHERE clause and see if the statement works. > > UPDATE Reports SET Password = 'XX' WHERE ID=1 > > That will at least get you closer to diagnosing the cause. > > Also, be sure your CFQUERY tags have proper < and >. > > --Dave > > ### > David Notik > Digital202, LLC > Imagination gone digital. > Web: www.digital202.com > E-mail: [EMAIL PROTECTED] > Office: (206) 575-1717 > Mobile: (206) 351-3948 > ### > > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 7:21 PM > To: CF-Talk > Subject: RE: shooting my server soon > > ok. > > update [reports] set password = '' > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: > Incorrect syntax near ''. > Native Error Code: 170 > SQL State: HY000 > > same error? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:15 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in [] > > http://aspfaq.com/show.asp?id=2080 > > > > > > > > > -Original Message- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > > To: CF-Talk > > > Subject: shooting my server soon > > > > > > > > > why? > > > > > > update reports set password = '' > > > > > > will not work in my cf code on my cfmx server. > > > > > > i can run the same query in query analyzer, and all is well. > > > > > > any explanation would save my ***king server... > > > > > > thanks > > > > > > ...tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: shooting my server soon....
ok, like samuel also said, maybe its my single quotes, ill check and let y'alls know ;) thanks. tony -Original Message- From: Antony Sideropoulos [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:52 PM To: CF-Talk Subject: RE: shooting my server soon In your form example, you may need to #PreserveSingleQuotes(form.sql)# Also confirm that the text isn't wrapping in the text box and picking up CRs and LFs. > >ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > >but not when i send this string from a form field >textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > >any idea? > >tony > >-Original Message- >From: David Notik [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 10:26 PM >To: CF-Talk >Subject: RE: shooting my server soon > > >Try adding a valid WHERE clause and see if the statement works. > >UPDATE Reports SET Password = 'XX' WHERE ID=1 > >That will at least get you closer to diagnosing the cause. > >Also, be sure your CFQUERY tags have proper < and >. > >--Dave > >### >David Notik >Digital202, LLC >Imagination gone digital. >Web: www.digital202.com >E-mail: [EMAIL PROTECTED] >Office: (206) 575-1717 >Mobile: (206) 351-3948 >### > > >-Original Message- >From: Tony Weeg [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 7:21 PM >To: CF-Talk >Subject: RE: shooting my server soon > >ok. > >update [reports] set password = '' > >Message: Error Executing Database Query. >Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect >syntax near ''. >Native Error Code: 170 >SQL State: HY000 > >same error? > >tony > >-Original Message- >From: Matthew Walker [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 10:15 PM >To: CF-Talk >Subject: RE: shooting my server soon > > >Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in [] > > http://aspfaq.com/show.asp?id=2080 > > > > > > > > > -Original Message- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > > To: CF-Talk > > > Subject: shooting my server soon > > > > > > > > > why? > > > > > > update reports set password = '' > > > > > > will not work in my cf code on my cfmx server. > > > > > > i can run the same query in query analyzer, and all is well. > > > > > > any explanation would save my ***king server... > > > > > > thanks > > > > > > ...tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: shooting my server soon....
Aha - that is important info. ;) Use PreserveSingleQuotes() around the query string. Also be careful allowing SQL to be submitted via a form, because it can allow malicious users to execute queries at will. --D -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 7:44 PM To: CF-Talk Subject: RE: shooting my server soon ok great, it works when i have this in a page... update [reports] set password = '123xxx456' but not when i send this string from a form field textarea called sql update [reports] set password = '123xxx456' #form.sql# any idea? tony -Original Message- From: David Notik [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:26 PM To: CF-Talk Subject: RE: shooting my server soon Try adding a valid WHERE clause and see if the statement works. UPDATE Reports SET Password = 'XX' WHERE ID=1 That will at least get you closer to diagnosing the cause. Also, be sure your CFQUERY tags have proper < and >. --Dave ### David Notik Digital202, LLC Imagination gone digital. Web: www.digital202.com E-mail: [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ### -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 7:21 PM To: CF-Talk Subject: RE: shooting my server soon ok. update [reports] set password = '' Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near ''. Native Error Code: 170 SQL State: HY000 same error? tony -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:15 PM To: CF-Talk Subject: RE: shooting my server soon Don't know. One of the secrets of T-SQL I guess. ;-) > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 4:06 p.m. > To: CF-Talk > Subject: RE: shooting my server soon > > > but why can i do it fine in select statements? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 9:59 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Reports is a reserved word. Wrap it in [] > http://aspfaq.com/show.asp?id=2080 > > > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > To: CF-Talk > > Subject: shooting my server soon > > > > > > why? > > > > update reports set password = '' > > > > will not work in my cf code on my cfmx server. > > > > i can run the same query in query analyzer, and all is well. > > > > any explanation would save my ***king server... > > > > thanks > > > > ...tony > > > > tony weeg > > [EMAIL PROTECTED] > > www.revolutionwebdesign.com > > rEvOlUtIoN wEb DeSiGn > > 410.334.6331 > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: shooting my server soon....
In your form example, you may need to #PreserveSingleQuotes(form.sql)# Also confirm that the text isn't wrapping in the text box and picking up CRs and LFs. > >ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > >but not when i send this string from a form field >textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > >any idea? > >tony > >-Original Message- >From: David Notik [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 10:26 PM >To: CF-Talk >Subject: RE: shooting my server soon > > >Try adding a valid WHERE clause and see if the statement works. > >UPDATE Reports SET Password = 'XX' WHERE ID=1 > >That will at least get you closer to diagnosing the cause. > >Also, be sure your CFQUERY tags have proper < and >. > >--Dave > >### >David Notik >Digital202, LLC >Imagination gone digital. >Web: www.digital202.com >E-mail: [EMAIL PROTECTED] >Office: (206) 575-1717 >Mobile: (206) 351-3948 >### > > >-Original Message- >From: Tony Weeg [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 7:21 PM >To: CF-Talk >Subject: RE: shooting my server soon > >ok. > >update [reports] set password = '' > >Message: Error Executing Database Query. >Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect >syntax near ''. >Native Error Code: 170 >SQL State: HY000 > >same error? > >tony > >-Original Message- >From: Matthew Walker [mailto:[EMAIL PROTECTED]] >Sent: Monday, December 02, 2002 10:15 PM >To: CF-Talk >Subject: RE: shooting my server soon > > >Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in [] > > http://aspfaq.com/show.asp?id=2080 > > > > > > > > > -Original Message- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > > To: CF-Talk > > > Subject: shooting my server soon > > > > > > > > > why? > > > > > > update reports set password = '' > > > > > > will not work in my cf code on my cfmx server. > > > > > > i can run the same query in query analyzer, and all is well. > > > > > > any explanation would save my ***king server... > > > > > > thanks > > > > > > ...tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: shooting my server soon....
cant use it without a u/p and there is also some hash encryption going on ;) tony -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:48 PM To: CF-Talk Subject: RE: shooting my server soon So the entire SQL is inside the form field, including the single quotes? Then you need PreserveSingleQuotes()--and think about the security issue.. > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:44 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > > but not when i send this string from a form field > textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > > any idea? > > tony > > -Original Message- > From: David Notik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:26 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Try adding a valid WHERE clause and see if the statement works. > > UPDATE Reports SET Password = 'XX' WHERE ID=1 > > That will at least get you closer to diagnosing the cause. > > Also, be sure your CFQUERY tags have proper < and >. > > --Dave > > ### > David Notik > Digital202, LLC > Imagination gone digital. > Web: www.digital202.com > E-mail: [EMAIL PROTECTED] > Office: (206) 575-1717 > Mobile: (206) 351-3948 > ### > > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 7:21 PM > To: CF-Talk > Subject: RE: shooting my server soon > > ok. > > update [reports] set password = '' > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: > Incorrect syntax near ''. > Native Error Code: 170 > SQL State: HY000 > > same error? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:15 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in [] > > http://aspfaq.com/show.asp?id=2080 > > > > > > > > > -Original Message- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > > To: CF-Talk > > > Subject: shooting my server soon > > > > > > > > > why? > > > > > > update reports set password = '' > > > > > > will not work in my cf code on my cfmx server. > > > > > > i can run the same query in query analyzer, and all is well. > > > > > > any explanation would save my ***king server... > > > > > > thanks > > > > > > ...tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: shooting my server soon....
So the entire SQL is inside the form field, including the single quotes? Then you need PreserveSingleQuotes()--and think about the security issue.. > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:44 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > ok great, it works when i have this in a page... > > > update [reports] set password = '123xxx456' > > > but not when i send this string from a form field > textarea called sql > > update [reports] set password = '123xxx456' > > > > #form.sql# > > > any idea? > > tony > > -Original Message- > From: David Notik [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:26 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Try adding a valid WHERE clause and see if the statement works. > > UPDATE Reports SET Password = 'XX' WHERE ID=1 > > That will at least get you closer to diagnosing the cause. > > Also, be sure your CFQUERY tags have proper < and >. > > --Dave > > ### > David Notik > Digital202, LLC > Imagination gone digital. > Web: www.digital202.com > E-mail: [EMAIL PROTECTED] > Office: (206) 575-1717 > Mobile: (206) 351-3948 > ### > > > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 7:21 PM > To: CF-Talk > Subject: RE: shooting my server soon > > ok. > > update [reports] set password = '' > > Message: Error Executing Database Query. > Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: > Incorrect syntax near ''. > Native Error Code: 170 > SQL State: HY000 > > same error? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 10:15 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Don't know. One of the secrets of T-SQL I guess. ;-) > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 4:06 p.m. > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > but why can i do it fine in select statements? > > > > tony > > > > -Original Message- > > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 9:59 PM > > To: CF-Talk > > Subject: RE: shooting my server soon > > > > > > Reports is a reserved word. Wrap it in [] > > http://aspfaq.com/show.asp?id=2080 > > > > > > > > > -Original Message- > > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > > To: CF-Talk > > > Subject: shooting my server soon > > > > > > > > > why? > > > > > > update reports set password = '' > > > > > > will not work in my cf code on my cfmx server. > > > > > > i can run the same query in query analyzer, and all is well. > > > > > > any explanation would save my ***king server... > > > > > > thanks > > > > > > ...tony > > > > > > tony weeg > > > [EMAIL PROTECTED] > > > www.revolutionwebdesign.com > > > rEvOlUtIoN wEb DeSiGn > > > 410.334.6331 > > > > > > > > > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
ok great, it works when i have this in a page... update [reports] set password = '123xxx456' but not when i send this string from a form field textarea called sql update [reports] set password = '123xxx456' #form.sql# any idea? tony -Original Message- From: David Notik [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:26 PM To: CF-Talk Subject: RE: shooting my server soon Try adding a valid WHERE clause and see if the statement works. UPDATE Reports SET Password = 'XX' WHERE ID=1 That will at least get you closer to diagnosing the cause. Also, be sure your CFQUERY tags have proper < and >. --Dave ### David Notik Digital202, LLC Imagination gone digital. Web: www.digital202.com E-mail: [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ### -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 7:21 PM To: CF-Talk Subject: RE: shooting my server soon ok. update [reports] set password = '' Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near ''. Native Error Code: 170 SQL State: HY000 same error? tony -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:15 PM To: CF-Talk Subject: RE: shooting my server soon Don't know. One of the secrets of T-SQL I guess. ;-) > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 4:06 p.m. > To: CF-Talk > Subject: RE: shooting my server soon > > > but why can i do it fine in select statements? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 9:59 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Reports is a reserved word. Wrap it in [] > http://aspfaq.com/show.asp?id=2080 > > > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > To: CF-Talk > > Subject: shooting my server soon > > > > > > why? > > > > update reports set password = '' > > > > will not work in my cf code on my cfmx server. > > > > i can run the same query in query analyzer, and all is well. > > > > any explanation would save my ***king server... > > > > thanks > > > > ...tony > > > > tony weeg > > [EMAIL PROTECTED] > > www.revolutionwebdesign.com > > rEvOlUtIoN wEb DeSiGn > > 410.334.6331 > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
Have you tried using ? That solved many CFMX/Oracle errors, maybe it helps SQL Server too. :) > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 9:45 PM > To: CF-Talk > Subject: shooting my server soon > > > why? > > update reports set password = '' > > will not work in my cf code on my cfmx server. > (snip) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
Try adding a valid WHERE clause and see if the statement works. UPDATE Reports SET Password = 'XX' WHERE ID=1 That will at least get you closer to diagnosing the cause. Also, be sure your CFQUERY tags have proper < and >. --Dave ### David Notik Digital202, LLC Imagination gone digital. Web: www.digital202.com E-mail: [EMAIL PROTECTED] Office: (206) 575-1717 Mobile: (206) 351-3948 ### -Original Message- From: Tony Weeg [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 7:21 PM To: CF-Talk Subject: RE: shooting my server soon ok. update [reports] set password = '' Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near ''. Native Error Code: 170 SQL State: HY000 same error? tony -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:15 PM To: CF-Talk Subject: RE: shooting my server soon Don't know. One of the secrets of T-SQL I guess. ;-) > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 4:06 p.m. > To: CF-Talk > Subject: RE: shooting my server soon > > > but why can i do it fine in select statements? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 9:59 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Reports is a reserved word. Wrap it in [] > http://aspfaq.com/show.asp?id=2080 > > > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > To: CF-Talk > > Subject: shooting my server soon > > > > > > why? > > > > update reports set password = '' > > > > will not work in my cf code on my cfmx server. > > > > i can run the same query in query analyzer, and all is well. > > > > any explanation would save my ***king server... > > > > thanks > > > > ...tony > > > > tony weeg > > [EMAIL PROTECTED] > > www.revolutionwebdesign.com > > rEvOlUtIoN wEb DeSiGn > > 410.334.6331 > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
ok. update [reports] set password = '' Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near ''. Native Error Code: 170 SQL State: HY000 same error? tony -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:15 PM To: CF-Talk Subject: RE: shooting my server soon Don't know. One of the secrets of T-SQL I guess. ;-) > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 4:06 p.m. > To: CF-Talk > Subject: RE: shooting my server soon > > > but why can i do it fine in select statements? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 9:59 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Reports is a reserved word. Wrap it in [] > http://aspfaq.com/show.asp?id=2080 > > > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > To: CF-Talk > > Subject: shooting my server soon > > > > > > why? > > > > update reports set password = '' > > > > will not work in my cf code on my cfmx server. > > > > i can run the same query in query analyzer, and all is well. > > > > any explanation would save my ***king server... > > > > thanks > > > > ...tony > > > > tony weeg > > [EMAIL PROTECTED] > > www.revolutionwebdesign.com > > rEvOlUtIoN wEb DeSiGn > > 410.334.6331 > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
Have you tried putting the "password" into the actual tag? -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 3 December 2002 1:48 PM To: CF-Talk Subject: Re: shooting my server soon What sort of error message are you receiving? - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 8:44 PM Subject: shooting my server soon > why? > > update reports set password = '' > > will not work in my cf code on my cfmx server. > > i can run the same query in query analyzer, and all is well. > > any explanation would save my ***king server... > > thanks > > ...tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
Don't know. One of the secrets of T-SQL I guess. ;-) > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 4:06 p.m. > To: CF-Talk > Subject: RE: shooting my server soon > > > but why can i do it fine in select statements? > > tony > > -Original Message- > From: Matthew Walker [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 9:59 PM > To: CF-Talk > Subject: RE: shooting my server soon > > > Reports is a reserved word. Wrap it in [] > http://aspfaq.com/show.asp?id=2080 > > > > > -Original Message- > > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, 3 December 2002 3:45 p.m. > > To: CF-Talk > > Subject: shooting my server soon > > > > > > why? > > > > update reports set password = '' > > > > will not work in my cf code on my cfmx server. > > > > i can run the same query in query analyzer, and all is well. > > > > any explanation would save my ***king server... > > > > thanks > > > > ...tony > > > > tony weeg > > [EMAIL PROTECTED] > > www.revolutionwebdesign.com > > rEvOlUtIoN wEb DeSiGn > > 410.334.6331 > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
thanks btw matt :) tony -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:59 PM To: CF-Talk Subject: RE: shooting my server soon Reports is a reserved word. Wrap it in [] http://aspfaq.com/show.asp?id=2080 > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 3:45 p.m. > To: CF-Talk > Subject: shooting my server soon > > > why? > > update reports set password = '' > > will not work in my cf code on my cfmx server. > > i can run the same query in query analyzer, and all is well. > > any explanation would save my ***king server... > > thanks > > ...tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
but why can i do it fine in select statements? tony -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:59 PM To: CF-Talk Subject: RE: shooting my server soon Reports is a reserved word. Wrap it in [] http://aspfaq.com/show.asp?id=2080 > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 3:45 p.m. > To: CF-Talk > Subject: shooting my server soon > > > why? > > update reports set password = '' > > will not work in my cf code on my cfmx server. > > i can run the same query in query analyzer, and all is well. > > any explanation would save my ***king server... > > thanks > > ...tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: shooting my server soon....
Reports is a reserved word. Wrap it in [] http://aspfaq.com/show.asp?id=2080 > -Original Message- > From: Tony Weeg [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, 3 December 2002 3:45 p.m. > To: CF-Talk > Subject: shooting my server soon > > > why? > > update reports set password = '' > > will not work in my cf code on my cfmx server. > > i can run the same query in query analyzer, and all is well. > > any explanation would save my ***king server... > > thanks > > ...tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
Message: Error Executing Database Query. Detail: [Macromedia][SQLServer JDBC Driver][SQLServer]Line 1: Incorrect syntax near ''. Native Error Code: 170 SQL State: HY000 i can change it to anything, the value that is right now, i can make that anything, and nothing works. its a varchar field, that i can do a select statement from, and get anything i want WTF TIA tony... -Original Message- From: Bruce Sorge [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:48 PM To: CF-Talk Subject: Re: shooting my server soon What sort of error message are you receiving? - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 8:44 PM Subject: shooting my server soon > why? > > update reports set password = '' > > will not work in my cf code on my cfmx server. > > i can run the same query in query analyzer, and all is well. > > any explanation would save my ***king server... > > thanks > > ...tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: shooting my server soon....
What sort of error message are you receiving? - Original Message - From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 8:44 PM Subject: shooting my server soon > why? > > update reports set password = '' > > will not work in my cf code on my cfmx server. > > i can run the same query in query analyzer, and all is well. > > any explanation would save my ***king server... > > thanks > > ...tony > > tony weeg > [EMAIL PROTECTED] > www.revolutionwebdesign.com > rEvOlUtIoN wEb DeSiGn > 410.334.6331 > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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.
shooting my server soon....
why? update reports set password = '' will not work in my cf code on my cfmx server. i can run the same query in query analyzer, and all is well. any explanation would save my ***king server... thanks ...tony tony weeg [EMAIL PROTECTED] www.revolutionwebdesign.com rEvOlUtIoN wEb DeSiGn 410.334.6331 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Architecting Tools
> -Original Message- > From: SFN Development [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 1:31 AM > To: CF-Talk > Subject: RE: Architecting Tools > > > I found a solution to the 'partner resistance' issue... > > Take the two car garage as your office. Go to > and buy bathroom tub > wall paneling (it's really white board) and do one wall in > the garage :-) Do you think home depot has a two car garage that will fit in my apartment? That would be really nice... Of course I do get the whole dining room, so I can't complain much. But I do agree - at an old job we walled our office with that stuff - cheap and HUGE and perfect. It was so great to "wake-up" after a a deep design session and find that we had filled it down to floor. ;^) Jim Davis ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Nested Query Loops
Hmmm..interesting... I've never tested that behaviour, but I can tell you if I were to reference a field from the outer query in the inner query, I can only output an outer query field inside the inner query loop via qOuterQuery.FieldName (which would actually give the data from the last record returned from the outer query for every pass of the inner query loop). So, I guess we're to the point of you posting your code so we can compare (problem is...I'm heading out of townback on Wednesday) ;-) 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 3:25 PM Subject: RE: Nested Query Loops > Okay, what do you mean by properly referencing the > queries? > > I always use the queryname.columnname inside of a loop, > even a single loop. In this case, I added the > variables scope to it as well. The issue is not a > duplication of variable names. The issue is that the > second query does not exist at all inside of the outer > loop. If I do a outer loop, I get the full recordset. If I do a > get null - the second query has been wiped out. > > If it matters, I am running this on CF5 Standard. > > -- Jeff > > > -Original Message- > From: Bryan Stevenson > [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 4:45 PM > To: CF-Talk > Subject: Re: Nested Query Loops > > > I beleive this is the case ALWAYS even if the 2 queries > have seperate names > and fields. This "feature" is there to prevent the > issue I mentioned. It > forces you to properly reference your variables ;-) > > 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, December 02, 2002 2:39 PM > Subject: RE: Nested Query Loops > > > > I can see that ... The issue is that I have two > differently named > > queries with differently named columns. The CF error > is that the inner > > query does not even exist, which is verified with a > > inner loop. For some reason, that query variable > goes to null within > > the outside loop. > > > > -- Jeff > > > > > > -Original Message- > > From: Bryan Stevenson > [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 4:34 PM > > To: CF-Talk > > Subject: Re: Nested Query Loops > > > > > > Well...think about your nested loop having fieldnames > that same as the > > outer loop > > > > CF has to know which field you are referencing ;-) > > > > 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Monday, December 02, 2002 2:30 PM > > Subject: RE: Nested Query Loops > > > > > > > I was referring to the inner query using the full > scoped name - > > > variables.queryName. > > > > > > So, why does setting newQueryName = > variables.queryName PRIOR to > > > looping the first query change anything? Both > variables are in the > > > variable scope and are created prior to the first > loop - they should > > > be the same right? > > > > > > BTW - copying the query over to a new name worked. > Now the question > > > is why? > > > > > > Thanks > > > > > > > > > -Original Message- > > > From: Keith Dodd [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, December 02, 2002 3:17 PM > > > To: CF-Talk > > > Subject: Nested Query Loops > > > > > > > > > Not sure this is the problem, but I've had problems > with nesting > > > loops, forgetting that you need to set a variable > from the outer loop > > > (with a new name) before using that variable in the > inner loop. I > > > don't understand why, but variables get confused in > nested loops. This > > > > > *might* have something to do with it. > > > > > > Keith Dodd > > > >
RE: Sql 2000 -> XML cfmx
Thanks Samuel Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Samuel Neff [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 4:42 PM To: CF-Talk Subject: RE: Sql 2000 -> XML cfmx Rob, The trick is to use the structure notation, and keep in mind that it always returns just one column. select * from books for xml auto "> Also remember that SQL Server returns only an XML fragment, not an actual valid XML document. You have to add a root node before you can use xmlParse on it. HTH, Sam > -Original Message- > From: Rob Rohan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 6:52 PM > To: CF-Talk > Subject: Sql 2000 -> XML cfmx > > > We are trying to retrieve xml data from an SQL 2000 database like so: > > > select top 10 * > from thetable_mst > for xml auto, elements > > (snip) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: Sql 2000 -> XML cfmx
Rob, The trick is to use the structure notation, and keep in mind that it always returns just one column. select * from books for xml auto "> Also remember that SQL Server returns only an XML fragment, not an actual valid XML document. You have to add a root node before you can use xmlParse on it. HTH, Sam > -Original Message- > From: Rob Rohan [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 6:52 PM > To: CF-Talk > Subject: Sql 2000 -> XML cfmx > > > We are trying to retrieve xml data from an SQL 2000 database like so: > > > select top 10 * > from thetable_mst > for xml auto, elements > > (snip) ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Sql 2000 -> XML cfmx SOLVED
a bit of a hack but --- (thanks to Mark) select top 10 * from thetable_mst for xml auto, elements #xmltest[xmltest.columnlist][x]# seems to work. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:52 PM To: CF-Talk Subject: Sql 2000 -> XML cfmx We are trying to retrieve xml data from an SQL 2000 database like so: select top 10 * from thetable_mst for xml auto, elements then we would like to use the xml with cf, but it doesn't seem possible. When we do: it shows a query with 4 rows all having a piece of the xml document and the column name is XML_F52E2B61-18A1-11D1-B105-00805F49916B which cold fusion seem to not like (due to the '-') character. So, of course, xmlParse(xmltest) doesn't work because it's a query, and I cant loop over the query rows to build the document because XML_F52E2B61-18A1-11D1-B105-00805F49916B is invalid. Are we doing this totally wrong? I would like to just select information form the database in a pre made xml document - any one know how to do that? (apparently I don't) Thanks, Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RDS Timing Out.
When I start CFStudio, I get a non-descript popup box that says "Operation timed out." When I try to debug a page it eventually says "Operation timed out." The entire CFStudio crashes even if there is no activity going on within CFStudio or CF5 Server. I searched through the Archives and through Google and found few hits and even fewer related articles. I'm running CF5 Studio and CF5 Server on the same W2K Pro machine. I'm using simple mappings: "c:\inetpub\wwwroot\" "c:\inetpub\wwroot\" "http^://localhost/" I've also tried Homesite+ 5.1 with the same result. I've also re-installed Server and Studio more times than I care to say. I've applied all the patches that were recommended. I have all the recent Virus patches installed and the machine scans clean. I have a voodoo doll with Bill Gates' picture on it strapped to my monitor. I can't go to CFMX yet due to project constraints. Can DreamWeaverMX debug CF5 code? Is CF5 just a buggy IDE and I should look for something else, or can someone offer any advice to help fix this problem? Greg M ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Sql 2000 -> XML cfmx
We are trying to retrieve xml data from an SQL 2000 database like so: select top 10 * from thetable_mst for xml auto, elements then we would like to use the xml with cf, but it doesn't seem possible. When we do: it shows a query with 4 rows all having a piece of the xml document and the column name is XML_F52E2B61-18A1-11D1-B105-00805F49916B which cold fusion seem to not like (due to the '-') character. So, of course, xmlParse(xmltest) doesn't work because it's a query, and I cant loop over the query rows to build the document because XML_F52E2B61-18A1-11D1-B105-00805F49916B is invalid. Are we doing this totally wrong? I would like to just select information form the database in a pre made xml document - any one know how to do that? (apparently I don't) Thanks, Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Service Starting/Stopping
Hi Bruce, Take a look at this technote about Occlude errors: http://www.macromedia.com/v1/Handlers/index.cfm?ID=16007&Method=Full Regards, Christine Lawson Macromedia -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 5:51 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Its full of these warnings: In a CF_TagName construct custom tag file 'e:\CFusion\CustomTags\data\anyfile.cfm' will occlude custom tag file 'e:\CFusion\CustomTags\Custom Tags\functions\anyfile.cfm'. I changed the file name to anyfile, because this is happening for many files. There are .cfm files with same names in different directories under \CustomTags. but many are also like this one were its referencing only one file: In a CF_TagName construct custom tag file 'e:\CFusion\CustomTags\tags\form_fieldFocus.cfm' will occlude custom tag file 'e:\CFusion\CustomTags\TAGS\form_fieldFocus.cfm'. and I have check there is only one form_fieldFocus.cfm file. Is CF Admin case sensitive, I did notice that in all cases were the files are then same, the directory listed is in different cases? -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:31 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Rodney, can you look at what is in the Application log? 232 and 109 errors can indicate slow responses to the browser. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:05 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping sorry did a bad cut and paste below the error reads: Error number 232 occurred while attempting to write the reply to the web server. -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:02 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Ok Cleaned up the log files. Now in the server.log we are getting this error: Error number 232 occurred attempting to close connection to web server. almost every second :o( No wonder the old file was 1.2 gb in size. Does anyone know what it means? Only thing I found was: 232 The pipe is being closed (from MS KB). no real details Thanks -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:06 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: One dynamic site for multiple indepentdent businesses
Ben, I think I'm getting the idea of the dynamics involved in this type of site. I didn't realize the application variables could be redefined for each visitor... wouldn't that cause some problems! I can see now why you've said to verify the relationship between the domain and the variables in use with every page call. It's necessary because of the complete dynamic nature of the site. That problem wouldn't show up until more than one user was accessing the site at once. Thanks for pointing that out. I guess for now, before I get the domain names involved, I'll use the BusinessID to set the variables, then once domain are established, use those for setting the variables, including the BusinessID, which I'll have to have for relationships to a second database already in existence. I'll just have to code the BusinessID into the URL for each page, so it can be checked... I guess my biggest limitation in understanding how to code this type of app, is understanding the fine points of the various types of scopes. I'll have to do some deeper digging on those. I appreciate your help, insight, and time! Rick -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 6:06 PM To: CF-Talk Subject: RE: One dynamic site for multiple indepentdent businesses : When you wrote: : : "you should be setting request-scoped variables in : the application file and set them for every request, not just the first : one." : : Do you mean that each page of the site should re-define the request scope : variables, : instead of just the first page (index.cfm?) I figured that once : I had some : global variables : set, I wouldn't need to run the query involved for each page. For the : topgraphic, say, : I was just running a query and getting the name of the appropriate :graphic : and assigning : that name to the Application.TopGraphic variable and using an tag to : place : the graphic. Are you saying allow the application.cfm to run the : query and : re-define : that graphic for each page? Is that the only way to prevent users from : seeing the wrong : site graphics and information when the variables change? Yes, I mean that you should, in your application.cfm file, run whatever routines you need to get and set request-scope variables that you will use later in your page to create whatever customizations you need. Since the routines are located in (or are called from -- whichever works best for you) your application.cfm file, they will be run each time any .cfm page is called. This is not the /only/ way to do this, but (IMHO) it is the best. You could store this info in the session scope. I really don't see much of an upside here unless you are running from a lousy DB (ie Access) and have high traffic. Basically, you need to lock a section of code that does a few things. First, check and see if some session variables exist. If they exist, make sure they match the requested domain. If they don't exist or don't match the requested domain, go and get the information by whatever means you've dreamed up. Finally, copy all the information to the request scope so that you can use it without locking each call. finally, close the lock. You could store this info in the client scope, but that would basically work the same as session scope, but you don't need the locks. However, if you use this method, you should store the client info in a designated database, /not/ in the system registry. This means that you're still making a bunch of calls to your db. You should NOT repeat NOT use application scope for this. Why? You start surfing d1.com, so d1.gif is the header and d1.css is the style sheet. Now I show up via d2.com. I change all the application variables in the process. This changes them for everyone, not just me. Therefore, unless you are checking the domain on every call, you end up seeing d2.gif and d2.css instead of the ones for the domain you requested. Remember, application variables apply to /every/ call to that application, not just your request. In the end, I'd skip any attempt at persistent storage via CF and just check the domain on every call (since you have to anyway) and either run that against your DB or hard-code the variables or just base the images, stylesheets, etc. on the domain name. : Concerning the application.cfm page being accessed when I open a : bookmarked : index.cfm page: : : It wasn't accessing the page automatically. I tested this by having the : application.cfm page : output some variables and abort to see if it was being accessed. : Only when : I refreshed the : bookmarked index.cfm did the output occur from application.cfm. That : confuses me. : I thought it happened automatically every time. That behavior is what I'm : depending on. : It may be just a localhost production behavior I have no idea about this. I'll let the experts handle this one. :-) --Ben Doom Programmer & General Lackey Moonbow Software
RE: Nested Query Loops
Okay, what do you mean by properly referencing the queries? I always use the queryname.columnname inside of a loop, even a single loop. In this case, I added the variables scope to it as well. The issue is not a duplication of variable names. The issue is that the second query does not exist at all inside of the outer loop. If I do a mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 4:45 PM To: CF-Talk Subject: Re: Nested Query Loops I beleive this is the case ALWAYS even if the 2 queries have seperate names and fields. This "feature" is there to prevent the issue I mentioned. It forces you to properly reference your variables ;-) 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 2:39 PM Subject: RE: Nested Query Loops > I can see that ... The issue is that I have two differently named > queries with differently named columns. The CF error is that the inner > query does not even exist, which is verified with a inner loop. For some reason, that query variable goes to null within > the outside loop. > > -- Jeff > > > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 4:34 PM > To: CF-Talk > Subject: Re: Nested Query Loops > > > Well...think about your nested loop having fieldnames that same as the > outer loop > > CF has to know which field you are referencing ;-) > > 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, December 02, 2002 2:30 PM > Subject: RE: Nested Query Loops > > > > I was referring to the inner query using the full scoped name - > > variables.queryName. > > > > So, why does setting newQueryName = variables.queryName PRIOR to > > looping the first query change anything? Both variables are in the > > variable scope and are created prior to the first loop - they should > > be the same right? > > > > BTW - copying the query over to a new name worked. Now the question > > is why? > > > > Thanks > > > > > > -Original Message- > > From: Keith Dodd [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 3:17 PM > > To: CF-Talk > > Subject: Nested Query Loops > > > > > > Not sure this is the problem, but I've had problems with nesting > > loops, forgetting that you need to set a variable from the outer loop > > (with a new name) before using that variable in the inner loop. I > > don't understand why, but variables get confused in nested loops. This > > > *might* have something to do with it. > > > > Keith Dodd > > > > > > ~~~ ~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid =4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method= subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: One dynamic site for multiple indepentdent businesses
: When you wrote: : : "you should be setting request-scoped variables in : the application file and set them for every request, not just the first : one." : : Do you mean that each page of the site should re-define the request scope : variables, : instead of just the first page (index.cfm?) I figured that once : I had some : global variables : set, I wouldn't need to run the query involved for each page. For the : topgraphic, say, : I was just running a query and getting the name of the appropriate :graphic : and assigning : that name to the Application.TopGraphic variable and using an tag to : place : the graphic. Are you saying allow the application.cfm to run the : query and : re-define : that graphic for each page? Is that the only way to prevent users from : seeing the wrong : site graphics and information when the variables change? Yes, I mean that you should, in your application.cfm file, run whatever routines you need to get and set request-scope variables that you will use later in your page to create whatever customizations you need. Since the routines are located in (or are called from -- whichever works best for you) your application.cfm file, they will be run each time any .cfm page is called. This is not the /only/ way to do this, but (IMHO) it is the best. You could store this info in the session scope. I really don't see much of an upside here unless you are running from a lousy DB (ie Access) and have high traffic. Basically, you need to lock a section of code that does a few things. First, check and see if some session variables exist. If they exist, make sure they match the requested domain. If they don't exist or don't match the requested domain, go and get the information by whatever means you've dreamed up. Finally, copy all the information to the request scope so that you can use it without locking each call. finally, close the lock. You could store this info in the client scope, but that would basically work the same as session scope, but you don't need the locks. However, if you use this method, you should store the client info in a designated database, /not/ in the system registry. This means that you're still making a bunch of calls to your db. You should NOT repeat NOT use application scope for this. Why? You start surfing d1.com, so d1.gif is the header and d1.css is the style sheet. Now I show up via d2.com. I change all the application variables in the process. This changes them for everyone, not just me. Therefore, unless you are checking the domain on every call, you end up seeing d2.gif and d2.css instead of the ones for the domain you requested. Remember, application variables apply to /every/ call to that application, not just your request. In the end, I'd skip any attempt at persistent storage via CF and just check the domain on every call (since you have to anyway) and either run that against your DB or hard-code the variables or just base the images, stylesheets, etc. on the domain name. : Concerning the application.cfm page being accessed when I open a : bookmarked : index.cfm page: : : It wasn't accessing the page automatically. I tested this by having the : application.cfm page : output some variables and abort to see if it was being accessed. : Only when : I refreshed the : bookmarked index.cfm did the output occur from application.cfm. That : confuses me. : I thought it happened automatically every time. That behavior is what I'm : depending on. : It may be just a localhost production behavior I have no idea about this. I'll let the experts handle this one. :-) --Ben Doom Programmer & General Lackey Moonbow Software ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Service Starting/Stopping
Its full of these warnings: In a CF_TagName construct custom tag file 'e:\CFusion\CustomTags\data\anyfile.cfm' will occlude custom tag file 'e:\CFusion\CustomTags\Custom Tags\functions\anyfile.cfm'. I changed the file name to anyfile, because this is happening for many files. There are .cfm files with same names in different directories under \CustomTags. but many are also like this one were its referencing only one file: In a CF_TagName construct custom tag file 'e:\CFusion\CustomTags\tags\form_fieldFocus.cfm' will occlude custom tag file 'e:\CFusion\CustomTags\TAGS\form_fieldFocus.cfm'. and I have check there is only one form_fieldFocus.cfm file. Is CF Admin case sensitive, I did notice that in all cases were the files are then same, the directory listed is in different cases? -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:31 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Rodney, can you look at what is in the Application log? 232 and 109 errors can indicate slow responses to the browser. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:05 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping sorry did a bad cut and paste below the error reads: Error number 232 occurred while attempting to write the reply to the web server. -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:02 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Ok Cleaned up the log files. Now in the server.log we are getting this error: Error number 232 occurred attempting to close connection to web server. almost every second :o( No wonder the old file was 1.2 gb in size. Does anyone know what it means? Only thing I found was: 232 The pipe is being closed (from MS KB). no real details Thanks -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:06 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: One dynamic site for multiple indepentdent businesses
I've never used request scope variables. I did find this info in the CF Documentation: "The Request scope is a reserved variable/scope that allows you to store data pertaining to the complete hierarchy of custom tags used in a single page request." Seems to be made for this sort of thing as opposed to Application or Session. When you wrote: "you should be setting request-scoped variables in the application file and set them for every request, not just the first one." Do you mean that each page of the site should re-define the request scope variables, instead of just the first page (index.cfm?) I figured that once I had some global variables set, I wouldn't need to run the query involved for each page. For the topgraphic, say, I was just running a query and getting the name of the appropriate graphic and assigning that name to the Application.TopGraphic variable and using an tag to place the graphic. Are you saying allow the application.cfm to run the query and re-define that graphic for each page? Is that the only way to prevent users from seeing the wrong site graphics and information when the variables change? Concerning the application.cfm page being accessed when I open a bookmarked index.cfm page: It wasn't accessing the page automatically. I tested this by having the application.cfm page output some variables and abort to see if it was being accessed. Only when I refreshed the bookmarked index.cfm did the output occur from application.cfm. That confuses me. I thought it happened automatically every time. That behavior is what I'm depending on. It may be just a localhost production behavior Rick -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 5:02 PM To: CF-Talk Subject: RE: One dynamic site for multiple indepentdent businesses To find out what domain is being accessed, simply look at the cgi.server_name variable. You could use a cfswitch to check the server name and set appropriate variables accordingly. Since in IIS (IIRC) you can set as many domains as you want to point to a single directory, you need maintain only one set of code (which seems to be your goal) but simply add whatever information is needed in the application.cfm file and whatever graphics, stylesheets, etc are necessary in order to create a new site. For a little less flexibility (but increased ease of setup) you could simply set a variable to the name of the domain (minus the www. and .com or whatever) and have external files like domain.css and domain_logo.gif such that you simply need add the external files and not worry about a switch. I agree with Kieth that you should be setting request-scoped variables in the application file and set them for every request, not just the first one. If you are surfing site 1, and I go to site 2, the application variables get reset and suddenly you are looking at site 2. I don't think that was your intent. As for the "sticking" site, I again urge you to check whether it could be cached from a previous session. I say this because if the application is actually called (that is, any .cfm file is accessed) then the application.cfm file is run. There might be some problems with latency, but I kinda doubt that. So, make sure that your browser isn't caching the page. --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Rick Faircloth [mailto:[EMAIL PROTECTED]] : Sent: Monday, December 02, 2002 4:16 PM : To: CF-Talk : Subject: RE: One dynamic site for multiple indepentdent businesses : : : Hi, Ben and thanks for the reply. : : Yes, each business will have its own domain. : All the files for the site will be in one folder and subfolders : "RentalCompanies". : : I've been pulling the BusinessID from the bookmarked URL and : assigning that to Application.BusinessID and using that on each page : when needed to ID the Business. (I finally started using today : and turned on "Full Checking" or whatever the setting is called on my : production box, : and went throught the site and eliminated all errors, so I guess the : Application and : Session variables aren't an issue any more. : : Can you give me an example of code concerning how to determine which : business' info should be displayed based on domain for each page request? : Would there have to be queries on each page to pull the graphics each time : a page is requested? I was trying to define a persistent variable : (Application.BusinessID) : that would be globally available to the site. I need to query a second : database : based on the BusinessID key. : : At this point, the site is just a concept and I don't have actual domains : yet. : How would I work it for the temporary addresses, which are all the same at : this point, : except for having the BusinessID attached to the URL... : : One question is: Why isn't the Application.cfm page being : accessed whenever : I pull up a new bookmarked URL? If that wou
Re: Nested Query Loops
I beleive this is the case ALWAYS even if the 2 queries have seperate names and fields. This "feature" is there to prevent the issue I mentioned. It forces you to properly reference your variables ;-) 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 2:39 PM Subject: RE: Nested Query Loops > I can see that ... The issue is that I have two differently named > queries with differently named columns. The CF error is that the inner > query does not even exist, which is verified with a inner loop. For some reason, that query variable goes to null within > the outside loop. > > -- Jeff > > > -Original Message- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 4:34 PM > To: CF-Talk > Subject: Re: Nested Query Loops > > > Well...think about your nested loop having fieldnames that same as the > outer loop > > CF has to know which field you are referencing ;-) > > 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, December 02, 2002 2:30 PM > Subject: RE: Nested Query Loops > > > > I was referring to the inner query using the full scoped name - > > variables.queryName. > > > > So, why does setting newQueryName = variables.queryName PRIOR to > > looping the first query change anything? Both variables are in the > > variable scope and are created prior to the first loop - they should > > be the same right? > > > > BTW - copying the query over to a new name worked. Now the question > > is why? > > > > Thanks > > > > > > -Original Message- > > From: Keith Dodd [mailto:[EMAIL PROTECTED]] > > Sent: Monday, December 02, 2002 3:17 PM > > To: CF-Talk > > Subject: Nested Query Loops > > > > > > Not sure this is the problem, but I've had problems with nesting > > loops, forgetting that you need to set a variable from the outer loop > > (with a new name) before using that variable in the inner loop. I > > don't understand why, but variables get confused in nested loops. This > > > *might* have something to do with it. > > > > Keith Dodd > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Nested Query Loops
I don't know why this oddity. But do know that I've posted similar questions when nested queries weren't working, and someone would always remind me of this need. Don't think anyone ever had a reason though. :) Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Nested Query Loops
I can see that ... The issue is that I have two differently named queries with differently named columns. The CF error is that the inner query does not even exist, which is verified with a mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 4:34 PM To: CF-Talk Subject: Re: Nested Query Loops Well...think about your nested loop having fieldnames that same as the outer loop CF has to know which field you are referencing ;-) 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 2:30 PM Subject: RE: Nested Query Loops > I was referring to the inner query using the full scoped name - > variables.queryName. > > So, why does setting newQueryName = variables.queryName PRIOR to > looping the first query change anything? Both variables are in the > variable scope and are created prior to the first loop - they should > be the same right? > > BTW - copying the query over to a new name worked. Now the question > is why? > > Thanks > > > -Original Message- > From: Keith Dodd [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 3:17 PM > To: CF-Talk > Subject: Nested Query Loops > > > Not sure this is the problem, but I've had problems with nesting > loops, forgetting that you need to set a variable from the outer loop > (with a new name) before using that variable in the inner loop. I > don't understand why, but variables get confused in nested loops. This > *might* have something to do with it. > > Keith Dodd > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Nested Query Loops
Jeff, This has always been the case for me. Had to copy the query to a new variable, and then it worked. I believe it is a bug. If not, it should be as I see no purpose for it. Cedric Villat Lead Designer http://www.Cornfeed.Com Creators of CFTicket - A multipurpose Email Management and Trouble Ticket application. - Original Message - From: "Jeff D. Chastain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 2:30 PM Subject: RE: Nested Query Loops > I was referring to the inner query using the full scoped name - > variables.queryName. > > So, why does setting newQueryName = variables.queryName PRIOR to looping > the first query change anything? Both variables are in the variable > scope and are created prior to the first loop - they should be the same > right? > > BTW - copying the query over to a new name worked. Now the question is > why? > > Thanks > > > -Original Message- > From: Keith Dodd [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 3:17 PM > To: CF-Talk > Subject: Nested Query Loops > > > Not sure this is the problem, but I've had problems with nesting loops, > forgetting that you need to set a variable from the outer loop (with a > new name) before using that variable in the inner loop. I don't > understand why, but variables get confused in nested loops. This *might* > have something to do with it. > > Keith Dodd > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Nested Query Loops
Well...think about your nested loop having fieldnames that same as the outer loop CF has to know which field you are referencing ;-) 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: "Jeff D. Chastain" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 2:30 PM Subject: RE: Nested Query Loops > I was referring to the inner query using the full scoped name - > variables.queryName. > > So, why does setting newQueryName = variables.queryName PRIOR to looping > the first query change anything? Both variables are in the variable > scope and are created prior to the first loop - they should be the same > right? > > BTW - copying the query over to a new name worked. Now the question is > why? > > Thanks > > > -Original Message- > From: Keith Dodd [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 3:17 PM > To: CF-Talk > Subject: Nested Query Loops > > > Not sure this is the problem, but I've had problems with nesting loops, > forgetting that you need to set a variable from the outer loop (with a > new name) before using that variable in the inner loop. I don't > understand why, but variables get confused in nested loops. This *might* > have something to do with it. > > Keith Dodd > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Service Starting/Stopping
Rodney, can you look at what is in the Application log? 232 and 109 errors can indicate slow responses to the browser. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 2:05 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping sorry did a bad cut and paste below the error reads: Error number 232 occurred while attempting to write the reply to the web server. -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:02 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Ok Cleaned up the log files. Now in the server.log we are getting this error: Error number 232 occurred attempting to close connection to web server. almost every second :o( No wonder the old file was 1.2 gb in size. Does anyone know what it means? Only thing I found was: 232 The pipe is being closed (from MS KB). no real details Thanks -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:06 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Nested Query Loops
I was referring to the inner query using the full scoped name - variables.queryName. So, why does setting newQueryName = variables.queryName PRIOR to looping the first query change anything? Both variables are in the variable scope and are created prior to the first loop - they should be the same right? BTW - copying the query over to a new name worked. Now the question is why? Thanks -Original Message- From: Keith Dodd [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:17 PM To: CF-Talk Subject: Nested Query Loops Not sure this is the problem, but I've had problems with nesting loops, forgetting that you need to set a variable from the outer loop (with a new name) before using that variable in the inner loop. I don't understand why, but variables get confused in nested loops. This *might* have something to do with it. Keith Dodd ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: client variables disappearing
Thanks, Debbie.
I assume the same limit does not apply to session variables so I might just
recode a few areas.
>>-Original Message-
>>From: Debbie Dickerson [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, December 02, 2002 3:44 PM
>>To: CF-Talk
>>Subject: RE: client variables disappearing
>>
>>If you're using CF5 or earlier, yes, there is a limit (65k).
>>http://www.macromedia.com/v1/Handlers/index.cfm?ID=22902&Method=Full
>>
>>
>>-Original Message-
>>From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]]
>>Sent: Monday, December 02, 2002 4:28 PM
>>To: CF-Talk
>>Subject: client variables disappearing
>>
>>
>>Is there a limit to the total amount of information stored in client
>>variables per user?
>>
>>I am having random client variables become undefined for no reason. It is
>>not consistently the same variable, it's not a loss of state issue as we
>>have cfid/cftoken in the url and I'm allowing cookies to be set in my
>>browser as well.
>>
>>
>>>evaluate("client." & i)>
>>
>>
>>
>>
>>The length of variables.testvar = 66817, which makes me wonder if I am
>>hitting a 65000 limit somewhere.
>>
>>We are storing client variables in a sql2k db. I have tried upping the
>>Long
>>Text Buffer Size up to the max it will allow(99), but this doesn't
>>seem
>>to help. (I'm not sure if it should or not, but something to try). Does
>>the cf service need to be restarted for this change to take effect?
>>
>>What else might be causing this? The macromedia forums don't seem to have
>>any entries similiar to this, but it's hard to believe no one has hit this
>>limit before.
>>Matthew P. Smith
>>Web Developer, Object Oriented
>>Naval Education & Training Professional
>>Development & Technology Center
>>(NETPDTC)
>>(850)452-1001 ext. 1245
>>[EMAIL PROTECTED]
>>
>>
>>
>>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Nested Query Loops
Not sure this is the problem, but I've had problems with nesting loops, forgetting that you need to set a variable from the outer loop (with a new name) before using that variable in the inner loop. I don't understand why, but variables get confused in nested loops. This *might* have something to do with it. Keith Dodd ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Service Starting/Stopping
sorry did a bad cut and paste below the error reads: Error number 232 occurred while attempting to write the reply to the web server. -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:02 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Ok Cleaned up the log files. Now in the server.log we are getting this error: Error number 232 occurred attempting to close connection to web server. almost every second :o( No wonder the old file was 1.2 gb in size. Does anyone know what it means? Only thing I found was: 232 The pipe is being closed (from MS KB). no real details Thanks -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:06 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Nested Query Loops
I have got a situation where I need to dynamically generate a form with one section of the form being duplicated for every set of values in a query. Within each duplicated section of the form, there is a list of items generated by a second query. The result, I have a variables.queryName, but this does not help either. Any suggestions as to what is wrong or what I could do differently? Thanks -- Jeff Chastain ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: One dynamic site for multiple indepentdent businesses
To find out what domain is being accessed, simply look at the cgi.server_name variable. You could use a cfswitch to check the server name and set appropriate variables accordingly. Since in IIS (IIRC) you can set as many domains as you want to point to a single directory, you need maintain only one set of code (which seems to be your goal) but simply add whatever information is needed in the application.cfm file and whatever graphics, stylesheets, etc are necessary in order to create a new site. For a little less flexibility (but increased ease of setup) you could simply set a variable to the name of the domain (minus the www. and .com or whatever) and have external files like domain.css and domain_logo.gif such that you simply need add the external files and not worry about a switch. I agree with Kieth that you should be setting request-scoped variables in the application file and set them for every request, not just the first one. If you are surfing site 1, and I go to site 2, the application variables get reset and suddenly you are looking at site 2. I don't think that was your intent. As for the "sticking" site, I again urge you to check whether it could be cached from a previous session. I say this because if the application is actually called (that is, any .cfm file is accessed) then the application.cfm file is run. There might be some problems with latency, but I kinda doubt that. So, make sure that your browser isn't caching the page. --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Rick Faircloth [mailto:[EMAIL PROTECTED]] : Sent: Monday, December 02, 2002 4:16 PM : To: CF-Talk : Subject: RE: One dynamic site for multiple indepentdent businesses : : : Hi, Ben and thanks for the reply. : : Yes, each business will have its own domain. : All the files for the site will be in one folder and subfolders : "RentalCompanies". : : I've been pulling the BusinessID from the bookmarked URL and : assigning that to Application.BusinessID and using that on each page : when needed to ID the Business. (I finally started using today : and turned on "Full Checking" or whatever the setting is called on my : production box, : and went throught the site and eliminated all errors, so I guess the : Application and : Session variables aren't an issue any more. : : Can you give me an example of code concerning how to determine which : business' info should be displayed based on domain for each page request? : Would there have to be queries on each page to pull the graphics each time : a page is requested? I was trying to define a persistent variable : (Application.BusinessID) : that would be globally available to the site. I need to query a second : database : based on the BusinessID key. : : At this point, the site is just a concept and I don't have actual domains : yet. : How would I work it for the temporary addresses, which are all the same at : this point, : except for having the BusinessID attached to the URL... : : One question is: Why isn't the Application.cfm page being : accessed whenever : I pull up a new bookmarked URL? If that would happen, I might just have : this licked... : : Thanks for your help. : : Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Service Starting/Stopping
Ok Cleaned up the log files. Now in the server.log we are getting this error: Error number 232 occurred attempting to close connection to web server. almost every second :o( No wonder the old file was 1.2 gb in size. Does anyone know what it means? Only thing I found was: 232 The pipe is being closed (from MS KB). no real details Thanks -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:06 PM To: CF-Talk Subject: RE: CF Service Starting/Stopping Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF-TALK / Usenet?
Fuseware.com asked to mirror the lists wy back and have been doing so for years. You still need to be subscribed (in digest mode at least) to post, but otherwise you can read from them. In addition, you can always use the archives (www.houseoffusion.com/cf_lists) to read posts. It's a basic forums setup that provides the messages as fast as the list does (slightly faster, actually). I've asked Howie about adding NNTP ability to iMS but it's not a simple thing. It would cost time and money to do so and without a return, it could be a burden to his business. If there was a demand for it then I'm sure that it would go into the product. Personally, I'd love to have the mail server and news server synchronized on a single DB. If anyone is interested in buying a mail server with NNTP synchronization and all, please email him. If he knows there's a demand then the chances of us seeing it are great. (I'm actually hoping he does one as he plays by the RFC rules and his stuff is very tight) Again, I'd like to thank Howie for the support he's given to the lists in the form of iMS and various minor patches to deal with truly obscure problems. :) As for logging into the archives, go to the sign in page (www.houseoffusion.com/signin) and select email password. This will ask you for your email address and then email you your signin information based on the entered password. Using that, you can then signin to the system and alter your information. If there are any alterations you'd like to the system, please email me off list and I'll look at them. > Just curious if Usenet will become an option at some point? > > (forgive me if this has already been discussed -- I can't for some > reason, login to the archives.. Another issue) > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: client variables disappearing
If you're using CF5 or earlier, yes, there is a limit (65k). http://www.macromedia.com/v1/Handlers/index.cfm?ID=22902&Method=Full -Original Message- From: Smith, Matthew P -CONT(DYN) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 4:28 PM To: CF-Talk Subject: client variables disappearing Is there a limit to the total amount of information stored in client variables per user? I am having random client variables become undefined for no reason. It is not consistently the same variable, it's not a loss of state issue as we have cfid/cftoken in the url and I'm allowing cookies to be set in my browser as well. The length of variables.testvar = 66817, which makes me wonder if I am hitting a 65000 limit somewhere. We are storing client variables in a sql2k db. I have tried upping the Long Text Buffer Size up to the max it will allow(99), but this doesn't seem to help. (I'm not sure if it should or not, but something to try). Does the cf service need to be restarted for this change to take effect? What else might be causing this? The macromedia forums don't seem to have any entries similiar to this, but it's hard to believe no one has hit this limit before. Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
Crazy CFJava(script) scripting
I have been playing with the bean scripting framework stuff with CFMX and I
have a question that is probably not going to be able to be answered, but...
Does anyone know where cold fusion keeps it variable scopes? For reference
here is the BSF code (watch out for line wrap):
runtime;
//create a manager object
manager = createObject("java","com.ibm.bsf.BSFManager");
//registar beans to use
//get the master factory
factory = createObject("java","coldfusion.server.ServiceFactory");
manager.declareBean("mail", factory.MailSpoolService,
factory.MailSpoolService.getClass());
manager.declareBean("registry", factory.RegistryService,
factory.RegistryService.getClass());
manager.declareBean("runtime", factory.RuntimeService,
factory.RuntimeService.getClass());
//execute
result = manager.eval("javascript", "#cfJavaScriptName#", 0, 0, cfjava);
if you look at result you'll see it is indeed the RuntimeService and can
manipulate the cfadmin stuff, *but* there doesn't seem to be anyway to get
to scoped variables.
I.e. if I wanted to do:
variables.mypagelevelvar++;
where would I find the "variables" scope. (it's not runtime.getVariables());
I know I am way out there but any thoughts?
Rob
http://treebeard.sourceforge.net
http://ruinworld.sourceforge.net
Scientia Est Potentia
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Re: CF-TALK / Usenet?
On Mon, 2 Dec 2002 19:39:51 +0100, in cf-talk you wrote: >> Just curious if Usenet will become an option at some point? >> >I am following the list using NNTP since years :-) >Just point your newsreader to news.fuseware.com > >Be aware that in order to post you need to be subscribed, I am subscribed to >the digest, this way I can post without getting hundreds of emails > >Massimo Just a note for anyone using that option (as I have for ages as well), that you have to reply via email back to [EMAIL PROTECTED] Standard usenet posts aren't propagated back from the NNTP version. --min ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
client variables disappearing
Is there a limit to the total amount of information stored in client variables per user? I am having random client variables become undefined for no reason. It is not consistently the same variable, it's not a loss of state issue as we have cfid/cftoken in the url and I'm allowing cookies to be set in my browser as well. The length of variables.testvar = 66817, which makes me wonder if I am hitting a 65000 limit somewhere. We are storing client variables in a sql2k db. I have tried upping the Long Text Buffer Size up to the max it will allow(99), but this doesn't seem to help. (I'm not sure if it should or not, but something to try). Does the cf service need to be restarted for this change to take effect? What else might be causing this? The macromedia forums don't seem to have any entries similiar to this, but it's hard to believe no one has hit this limit before. Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
One dynamic site for multiple indepentdent businesses
I *think* request scope has been around for a long time. With it, you have a variable available site-wide (for the current user) that does not have to be locked, as would/should session. (Similar to setting the datasource in the request scope: request.datasource = "MySource" and then using that throughout site) A couple possibilities come to mind regarding not yet having domain names. Havent' tried these, but might be able to use a /newsite at end of thetestdomain.com/newsite1, etc., then get this last piece and use it to find the id in initial query. Also, might be able to use dot notation: as newsite1.thetestdomain.com and look for that. Keith ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: One dynamic site for multiple indepentdent businesses
Hi, Keith, and thanks for the reply. I'm using CF 4.5 (should have stated that earlier) so would I have the request scope available? And why would that be preferable to an application variable? Part of the problem with your solution at this point is that the site is a demo (hopefully the companies will want to buy in) so there's no domain names. I guess I could setup a table with assumed domain names and corresponding BusinessID's. The BusinessID's are critical because I have to connect to a second database for information based on the BusinessID as a relational key. At first, I decided to use URL.BusinessID all through the site, but figured there had to be a global variable setup I could use for this. I'm just trying to make sure that when I demo the site off my server, that things will work properly as opposed to what's happening on my production box and localhost... For now, since the URL is the same for all the businesses, how would I establish which businessID to use except for attaching the BusinessID to the URL? Thanks for your help. Rick -Original Message- From: Keith Dodd [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:07 PM To: CF-Talk Subject: One dynamic site for multiple indepentdent businesses Have done something similar, but query database first to have a list of businessIDs related to a domain name. In application.cfm, loop through the available list of domains/ids until find match with the domain being called. This becomes the businessID for the desired site. Then set the businessID in the request scope--as request.BusinessID. All through the site, any queries, etc. are based on this unique ID. No need to carry through on URLs, as the request scope keeps it. Hope this helps Keith Dodd [EMAIL PROTECTED] www.wingserv.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Problem with CFMX server
Talk about irony. I was just experiencing this very same issue on a server I just put on-line. Thanks Dave! And thanks Alex for asking this question. - Original Message - From: <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 1:30 PM Subject: Re: Problem with CFMX server > hi Dave... obviusly... rush make simple issues to look like great truobles > with the link you provided i solved my problem in one second... > many thanks and sorry for bothered... i completely forgot to look in macromedia site > > many many thanks > alex > > - Original Message - > From: "Dave Watts" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, December 02, 2002 8:25 PM > Subject: RE: Problem with CFMX server > > > > hi i'm setting up a webserver with a number of domains > > with this structure: > > > > domain 1 (ip address 1) -> home dir= d:\home\site1 > > domain 2 (ip address 2) -> home dir= d:\home\site2 > > domain 3 (ip address 3) -> home dir= d:\home\site3 > > > > and the result is that every time i restart the CF service > > and run a website it correctly run the template (it say > > d:\home\site[n]) the first time and later on different web > > it keep to run the template on the starting web until i > > restart the service. > > > > where may the problem be? > > http://www.macromedia.com/v1/handlers/index.cfm?ID=23179&Method=Full > > This is clearly described in the setup documentation, I believe. > > 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=subscribe&forumid=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: One dynamic site for multiple indepentdent businesses
Hi, Ben and thanks for the reply. Yes, each business will have its own domain. All the files for the site will be in one folder and subfolders "RentalCompanies". I've been pulling the BusinessID from the bookmarked URL and assigning that to Application.BusinessID and using that on each page when needed to ID the Business. (I finally started using today and turned on "Full Checking" or whatever the setting is called on my production box, and went throught the site and eliminated all errors, so I guess the Application and Session variables aren't an issue any more. Can you give me an example of code concerning how to determine which business' info should be displayed based on domain for each page request? Would there have to be queries on each page to pull the graphics each time a page is requested? I was trying to define a persistent variable (Application.BusinessID) that would be globally available to the site. I need to query a second database based on the BusinessID key. At this point, the site is just a concept and I don't have actual domains yet. How would I work it for the temporary addresses, which are all the same at this point, except for having the BusinessID attached to the URL... One question is: Why isn't the Application.cfm page being accessed whenever I pull up a new bookmarked URL? If that would happen, I might just have this licked... Thanks for your help. Rick -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 3:53 PM To: CF-Talk Subject: RE: One dynamic site for multiple indepentdent businesses There are a couple of things I'd do differently (based on what I gather from your message). First, I'd look at the way you're deciding which business to display. Assuming you will use different domains for each business, I'd use those to decide what to display. Second, based on what you've said, it sounds like you're using something like a session variable to store what site information you need. I'd probably not do this, and generate the correct information based on domain for each page request -- this eliminates the possibility of "bleed" between visits to two different sites from the same machine. Finally, I'd look at how you're caching in your browser, as that might be why the wrong graphics etc. are showing up. --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Rick Faircloth [mailto:[EMAIL PROTECTED]] : Sent: Monday, December 02, 2002 3:48 PM : To: CF-Talk : Subject: One dynamic site for multiple indepentdent businesses : : : Hi, all. : : I'm trying to build a single site that will serve as a dynamic : site whose content and graphics are totally different depending on the : BusinessID. : : I've got the database setup with the info needed, and I've been : trying to specify the BusinessID by putting it in the URL that I've : bookmarked on my production box. : : Example: : : http://localhost/cfdocs/rentalcompanies/index.cfm?BusinessID=1 : : Once the Application.cfm is accessed, the presence of URL.BusinessID : is checked, and if it's present, various site variables are setup for : graphics, : etc. : : It seems to work, sort of... : : When I first access a bookmarked URL, the Application.cfm is not accessed : unless I refresh index.cfm. Then everything on the site is properly setup : for the business according to the BusinessID in the URL. But if I don't : manually : refresh the page, when I click on the other pages in the site, : the graphics : from the : previous version of the site are still there. : : I thought that the Application.cfm was always accessed by .cfm : pages first. : ?? : That's not happening when I pull a bookmarked URL on using localhost : development. : Will it be different when the site is accessed via the Internet? : : I'm planning to setup several businesses to use the same dynamic site. : Is the approach I'm using appropriate? Is there a better way to establish : the : BusinessID? Will it work in a regular URL accessed via the Internet? : : Has anyone done something like this and have a solution? : : Rick : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
One dynamic site for multiple indepentdent businesses
Have done something similar, but query database first to have a list of businessIDs related to a domain name. In application.cfm, loop through the available list of domains/ids until find match with the domain being called. This becomes the businessID for the desired site. Then set the businessID in the request scope--as request.BusinessID. All through the site, any queries, etc. are based on this unique ID. No need to carry through on URLs, as the request scope keeps it. Hope this helps Keith Dodd [EMAIL PROTECTED] www.wingserv.com ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
CFMX and SourceSafe
Hi All, Does anyone here use CFMX and Microsoft Visual SourceSafe? If so, how do you like it? Are there any implementation or usage issues we should know about? Also... on the same note... does anyone recommend using a different software solution and if so why? -Novak ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: One dynamic site for multiple indepentdent businesses
There are a couple of things I'd do differently (based on what I gather from your message). First, I'd look at the way you're deciding which business to display. Assuming you will use different domains for each business, I'd use those to decide what to display. Second, based on what you've said, it sounds like you're using something like a session variable to store what site information you need. I'd probably not do this, and generate the correct information based on domain for each page request -- this eliminates the possibility of "bleed" between visits to two different sites from the same machine. Finally, I'd look at how you're caching in your browser, as that might be why the wrong graphics etc. are showing up. --Ben Doom Programmer & General Lackey Moonbow Software : -Original Message- : From: Rick Faircloth [mailto:[EMAIL PROTECTED]] : Sent: Monday, December 02, 2002 3:48 PM : To: CF-Talk : Subject: One dynamic site for multiple indepentdent businesses : : : Hi, all. : : I'm trying to build a single site that will serve as a dynamic : site whose content and graphics are totally different depending on the : BusinessID. : : I've got the database setup with the info needed, and I've been : trying to specify the BusinessID by putting it in the URL that I've : bookmarked on my production box. : : Example: : : http://localhost/cfdocs/rentalcompanies/index.cfm?BusinessID=1 : : Once the Application.cfm is accessed, the presence of URL.BusinessID : is checked, and if it's present, various site variables are setup for : graphics, : etc. : : It seems to work, sort of... : : When I first access a bookmarked URL, the Application.cfm is not accessed : unless I refresh index.cfm. Then everything on the site is properly setup : for the business according to the BusinessID in the URL. But if I don't : manually : refresh the page, when I click on the other pages in the site, : the graphics : from the : previous version of the site are still there. : : I thought that the Application.cfm was always accessed by .cfm : pages first. : ?? : That's not happening when I pull a bookmarked URL on using localhost : development. : Will it be different when the site is accessed via the Internet? : : I'm planning to setup several businesses to use the same dynamic site. : Is the approach I'm using appropriate? Is there a better way to establish : the : BusinessID? Will it work in a regular URL accessed via the Internet? : : Has anyone done something like this and have a solution? : : Rick : : : ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
RE: CFMX not compatible with Oracle 8.0.5
Jim, I am not a DBA either...Just Stay up a lot! Follow these steps and let me know..if you can connect first. 1. Get Oracle 8.0.5 Installation CD and install Oracle 8.0.5 Client. 2. Open up Net 8 Easy Config and Create and new Service 3. Test your connection. 4. Look in the orant\jdbc for classes111.zip or classes112.zip. 5. Put this in WEB-INF\classes directory. Now depending on what version of classes*.zip.. you have a different connection string/configuration. Post your classes*.zip file name. Joe Eugene Certified Advanced ColdFusion Developer On Mon, 2 Dec 2002 13:37:15 -0600 Jim Campbell <[EMAIL PROTECTED]> wrote: > Joe - > > Thanks - any advice will be appreciated. I'm > not an Oracle admin by any > means, but I'm willing to get under the hood. > > - Jim > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: Monday, December 02, 2002 1:02 PM > To: CF-Talk > Subject: Re: CFMX not compatible with Oracle > 8.0.5 > > > Yes.. CFMX Oracle driver will only work with > Oracle 8"I" and above. However > i > got CFMX working with Oracle 8.0.5 Using Oracle > Native Type IV drivers. The > setup is little Tricky but works!\ > > Let me know.. if you need help configuring > this. > > Joe > > On Mon, 2 Dec 2002 10:50:05 -0600 Jim Campbell > wrote: > > > This is interesting... > > > > According to MM tech support, CFMX's Type 4 > > JDBC driver will not connect > > with Oracle 8.0.5. Short of upgrading our > > instance of Oracle (which, yes, > > we should get around to one of these days), > has > > anyone had this problem and > > come up with a way of getting this to work? > > I'd prefer not to use the ODBC, > > but if it's a choice between that and no > > functionality at all, I'll go with > > that. > > > > Muchas gracias, > > > > - Jim > > > > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
One dynamic site for multiple indepentdent businesses
Hi, all. I'm trying to build a single site that will serve as a dynamic site whose content and graphics are totally different depending on the BusinessID. I've got the database setup with the info needed, and I've been trying to specify the BusinessID by putting it in the URL that I've bookmarked on my production box. Example: http://localhost/cfdocs/rentalcompanies/index.cfm?BusinessID=1 Once the Application.cfm is accessed, the presence of URL.BusinessID is checked, and if it's present, various site variables are setup for graphics, etc. It seems to work, sort of... When I first access a bookmarked URL, the Application.cfm is not accessed unless I refresh index.cfm. Then everything on the site is properly setup for the business according to the BusinessID in the URL. But if I don't manually refresh the page, when I click on the other pages in the site, the graphics from the previous version of the site are still there. I thought that the Application.cfm was always accessed by .cfm pages first. ?? That's not happening when I pull a bookmarked URL on using localhost development. Will it be different when the site is accessed via the Internet? I'm planning to setup several businesses to use the same dynamic site. Is the approach I'm using appropriate? Is there a better way to establish the BusinessID? Will it work in a regular URL accessed via the Internet? Has anyone done something like this and have a solution? Rick ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: Trying to dynamically populate IFrame content pages...somehow.
When I tried it with NN 6.2.2 the iLayer had scrollbars. Everything was the same as on IE 5.5... Rick -Original Message- From: Christian Cantrell [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:36 PM To: CF-Talk Subject: Re: Trying to dynamically populate IFrame content pages...somehow. Also, I don't think an ilayer will provide you with scrollbars like an iframe will. cantrell On Monday, December 2, 2002, at 11:01 AM, jon hall wrote: > It's very similar, but technically it's probably closer to the span > tag, with the addition of a src parameter. Being a layer tag, it's a > bit more flexible than an iframe, but it's a close to an iframe tag as > it gets in ns4. > > -- > jon > mailto:[EMAIL PROTECTED] > > Monday, December 2, 2002, 10:46:30 AM, you wrote: > RF> Perhaps coding both iFrames and iLayers wouldn't be > RF> too much to do to use the effect. > > RF> So iFrames and iLayers are really the same thing from a coding > RF> and output perspective? Same parameters, etc? > > RF> Rick > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CFMX not compatible with Oracle 8.0.5
Can you totally go into detail about this ... we are having 8.1.5 issues and need to identify how the JDBC driver connect to the Oracle RDBMS - is it through the listener, or are there specific drivers that are being made use of on the oracle side. If there are, what are the version numbers of those drivers and can I replace them ... trying to find a way of not upgrading oracle. TIA Kevin Bridges -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:13 PM To: CF-Talk Subject: Re: CFMX not compatible with Oracle 8.0.5 We had the same problem here. The production database was 8i and the test database was 8.0.5 and we could not get to the 8.0.5 database with the JDBC driver that came with ColdFusionMX. We ended up putting on the 8.0.5 client installer so that we could install an 8.0.5 type 4 JDBC driver for 8.0.5. We got it working. Chris White Yes.. CFMX Oracle driver will only work with Oracle 8"I" and above. However i got CFMX working with Oracle 8.0.5 Using Oracle Native Type IV drivers. The setup is little Tricky but works!\ Let me know.. if you need help configuring this. Joe On Mon, 2 Dec 2002 10:50:05 -0600 Jim Campbell <[EMAIL PROTECTED]> wrote: > This is interesting... > > According to MM tech support, CFMX's Type 4 > JDBC driver will not connect > with Oracle 8.0.5. Short of upgrading our > instance of Oracle (which, yes, > we should get around to one of these days), has > anyone had this problem and > come up with a way of getting this to work? > I'd prefer not to use the ODBC, > but if it's a choice between that and no > functionality at all, I'll go with > that. > > Muchas gracias, > > - Jim > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CFMX not compatible with Oracle 8.0.5
We had the same problem here. The production database was 8i and the test database was 8.0.5 and we could not get to the 8.0.5 database with the JDBC driver that came with ColdFusionMX. We ended up putting on the 8.0.5 client installer so that we could install an 8.0.5 type 4 JDBC driver for 8.0.5. We got it working. Chris White Yes.. CFMX Oracle driver will only work with Oracle 8"I" and above. However i got CFMX working with Oracle 8.0.5 Using Oracle Native Type IV drivers. The setup is little Tricky but works!\ Let me know.. if you need help configuring this. Joe On Mon, 2 Dec 2002 10:50:05 -0600 Jim Campbell <[EMAIL PROTECTED]> wrote: > This is interesting... > > According to MM tech support, CFMX's Type 4 > JDBC driver will not connect > with Oracle 8.0.5. Short of upgrading our > instance of Oracle (which, yes, > we should get around to one of these days), has > anyone had this problem and > come up with a way of getting this to work? > I'd prefer not to use the ODBC, > but if it's a choice between that and no > functionality at all, I'll go with > that. > > Muchas gracias, > > - Jim > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Studio 4.5 Search Results
Yes, click to the right of all the filenames returned by the search, then right-click and select "Open in Browser". Be sure no files are selected (which is why I click first) because that will actually run the file in the browser rather than displaying the name(s). Chris Norloff -- Original Message -- from: S. Isaac Dealey <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Sun, 1 Dec 2002 23:20:38 -0500 >Does anyone know if there's a way to export the search results list from a >multi-file search in CF Studio 4.5 to a text file or the like? I've got a >search that returned several hundred records and I'd like to be able to save >the search criteria, mark my place in the list and go back to it, so I don't >have to go through the entire list all in one sitting. > >s. isaac dealey954-776-0046 > >new epoch http://www.turnkey.to > >lead architect, tapestry cms http://products.turnkey.to > >certified advanced coldfusion 5 developer >http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: DTD/XML Schema Standards
Try some of these: http://www.xcbl.org http://www.ebxml.org http://www.cxml.org Erik Yowell [EMAIL PROTECTED] http://www.shortfusemedia.com -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:35 AM To: CF-Talk Subject: RE: DTD/XML Schema Standards Thanks. This will help with defining a person. Now if I can find standards for the other aspects. -Original Message- From: Svee, Eric [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:34 AM To: CF-Talk Subject: RE: DTD/XML Schema Standards Check out http://www.hr-xml.org/channels/projects_main.cfm You might find some useful stuff there. E -Original Message- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 7:26 AM To: CF-Talk Subject: OT: DTD/XML Schema Standards Are there standard DTD's or XML Schema's for Invoices, Purchase Orders, People, Products, etc? I looked at the W3C site and couldn't find any Andy ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT - SQL Help
ARGH! I figured it out...
*lowering head*
I forgot to change some code on an include page. DOH!
Sorry folks! Thanks to everyone who helped.
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:56 PM
To: CF-Talk
Subject: RE: OT - SQL Help
I just removed all the asp stuff and this is what gets sent.
SELECT * FROM SomeTable WHERE (Email = '[EMAIL PROTECTED]') OR (SEmail =
'[EMAIL PROTECTED]') AND (IsDeleted = 0) AND (Password = 'somepassword') AND
(Approved = 1) AND (Registered = 1)
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:48 PM
To: CF-Talk
Subject: RE: OT - SQL Help
You to see exactly what SQL Statement being sent to the db. How about
displaying the sql string before it is processed and send that to the
list.
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:38 PM
To: CF-Talk
Subject: RE: OT - SQL Help
Exactly!!! But it is not working that way. I just sent a previous email
explaining this.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:36 PM
To: CF-Talk
Subject: RE: OT - SQL Help
> 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.
You shouldn't be getting an error if the record doesn't match, you
should
just not get any records back if none match. Randall's suggestion about
using parentheses should take care of your stated problem (you want to
compare the value to both fields, and if it matches either, you want to
select the record, right?)
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=subscribe&forumid=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: CF Service Starting/Stopping
Jochem thanks for info -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 12:42 PM To: CF-Talk Subject: Re: CF Service Starting/Stopping Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
:)
SELECT * FROM SomeTable
WHERE (Email = '[EMAIL PROTECTED]' OR SEmail ='[EMAIL PROTECTED]')
AND IsDeleted = 0
AND Password = 'somepassword'
AND Approved = 1 AND Registered = 1
as I am sure everyone is going to say
Rob
http://treebeard.sourceforge.net
http://ruinworld.sourceforge.net
Scientia Est Potentia
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 11:56 AM
To: CF-Talk
Subject: RE: OT - SQL Help
I just removed all the asp stuff and this is what gets sent.
SELECT * FROM SomeTable WHERE (Email = '[EMAIL PROTECTED]') OR (SEmail =
'[EMAIL PROTECTED]') AND (IsDeleted = 0) AND (Password = 'somepassword') AND
(Approved = 1) AND (Registered = 1)
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:48 PM
To: CF-Talk
Subject: RE: OT - SQL Help
You to see exactly what SQL Statement being sent to the db. How about
displaying the sql string before it is processed and send that to the
list.
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:38 PM
To: CF-Talk
Subject: RE: OT - SQL Help
Exactly!!! But it is not working that way. I just sent a previous email
explaining this.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:36 PM
To: CF-Talk
Subject: RE: OT - SQL Help
> 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.
You shouldn't be getting an error if the record doesn't match, you
should
just not get any records back if none match. Randall's suggestion about
using parentheses should take care of your stated problem (you want to
compare the value to both fields, and if it matches either, you want to
select the record, right?)
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=subscribe&forumid=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: OT - SQL Help
It looks like you need parentheses around your OR statement rather than
individual qualifier statements.
SELECT * FROM SomeTable WHERE (Email = '[EMAIL PROTECTED]' OR SEmail =
'[EMAIL PROTECTED]') AND IsDeleted = 0 AND Password = 'somepassword' AND
Approved = 1 AND Registered = 1
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:56 PM
To: CF-Talk
Subject: RE: OT - SQL Help
I just removed all the asp stuff and this is what gets sent.
SELECT * FROM SomeTable WHERE (Email = '[EMAIL PROTECTED]') OR (SEmail =
'[EMAIL PROTECTED]') AND (IsDeleted = 0) AND (Password = 'somepassword') AND
(Approved = 1) AND (Registered = 1)
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:48 PM
To: CF-Talk
Subject: RE: OT - SQL Help
You to see exactly what SQL Statement being sent to the db. How about
displaying the sql string before it is processed and send that to the
list.
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:38 PM
To: CF-Talk
Subject: RE: OT - SQL Help
Exactly!!! But it is not working that way. I just sent a previous email
explaining this.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:36 PM
To: CF-Talk
Subject: RE: OT - SQL Help
> 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.
You shouldn't be getting an error if the record doesn't match, you
should
just not get any records back if none match. Randall's suggestion about
using parentheses should take care of your stated problem (you want to
compare the value to both fields, and if it matches either, you want to
select the record, right?)
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=subscribe&forumid=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
RE: OT - SQL Help
I just removed all the asp stuff and this is what gets sent.
SELECT * FROM SomeTable WHERE (Email = '[EMAIL PROTECTED]') OR (SEmail =
'[EMAIL PROTECTED]') AND (IsDeleted = 0) AND (Password = 'somepassword') AND
(Approved = 1) AND (Registered = 1)
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:48 PM
To: CF-Talk
Subject: RE: OT - SQL Help
You to see exactly what SQL Statement being sent to the db. How about
displaying the sql string before it is processed and send that to the
list.
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:38 PM
To: CF-Talk
Subject: RE: OT - SQL Help
Exactly!!! But it is not working that way. I just sent a previous email
explaining this.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:36 PM
To: CF-Talk
Subject: RE: OT - SQL Help
> 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.
You shouldn't be getting an error if the record doesn't match, you
should
just not get any records back if none match. Randall's suggestion about
using parentheses should take care of your stated problem (you want to
compare the value to both fields, and if it matches either, you want to
select the record, right?)
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=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT - SQL Help
You to see exactly what SQL Statement being sent to the db. How about
displaying the sql string before it is processed and send that to the
list.
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:38 PM
To: CF-Talk
Subject: RE: OT - SQL Help
Exactly!!! But it is not working that way. I just sent a previous email
explaining this.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:36 PM
To: CF-Talk
Subject: RE: OT - SQL Help
> 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.
You shouldn't be getting an error if the record doesn't match, you
should
just not get any records back if none match. Randall's suggestion about
using parentheses should take care of your stated problem (you want to
compare the value to both fields, and if it matches either, you want to
select the record, right?)
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=subscribe&forumid=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: OT - CFMX JRun Web Server
Really? Could have sworn I was told by someone at MM that it was a stripped down version of Apache...sorry for the confusion... Stace -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:34 PM To: CF-Talk Subject: RE: OT - CFMX JRun Web Server > > What kind of web server is included with CFMX? > > It's Apache...prob an earlier version of 1.3...not > recommended for prod stuff... Uh, I'm pretty sure that's not true. The CFMX built-in web server isn't Apache. It's written in Java, I think. 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=subscribe&forumid=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: CF Service Starting/Stopping
Bruce, Rodney S HQISEC/Veridian IT Services wrote: > > and many of the following "warnings" > "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom > tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file > 'e:\CFusion\CustomTags\ourtags\index.cfm'." > not all for same file. > > So for more questions: > > I don't see how missing form fields, could cause a restart. > What does the above warning mean? You have 2 identically named custom tags and the server had to choose one pretty much at random. > Is there anyway in CF admin to limit the size of the log file, so we don't > have the issue of a large file again? No. Write a scheduled job to rotate them (or better, rotate and parse for known errors). > Is there a way of opening the server.log (without buying a program), MSWord > is limited to 25mbs? Use some tail utility to pipe the last few thousand lines to another file (I doubt you mean you want to do a line by line analysis). Jochem ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Exactly!!! But it is not working that way. I just sent a previous email
explaining this.
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:36 PM
To: CF-Talk
Subject: RE: OT - SQL Help
> 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.
You shouldn't be getting an error if the record doesn't match, you should
just not get any records back if none match. Randall's suggestion about
using parentheses should take care of your stated problem (you want to
compare the value to both fields, and if it matches either, you want to
select the record, right?)
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=subscribe&forumid=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: OT - SQL Help
I guess I must have not been clear in my initial email. I am not getting an
error. The "problem" is I have 2 different email addresses that can be used
to log into an extranet. If the "primary" email doesn't match the "primary"
email address then it should check to see if it matches the "secondary"
email address and log in otherwise it is not found.
For example, let's say these fields are in the DB:
PEmail,SEmail
and let's say these are the email addresses respectively:
[EMAIL PROTECTED],[EMAIL PROTECTED]
And in the form I input [EMAIL PROTECTED] I should be able to log in but the
problem is that it only accepts the primary email address.
Hope this clears it up.
Thanks,
Tony
-Original Message-
From: Matthew Small [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:22 PM
To: CF-Talk
Subject: RE: OT - SQL Help
What error are you getting?
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:14 PM
To: CF-Talk
Subject: RE: OT - SQL Help
No it did not. It's very bizarre.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:04 PM
To: CF-Talk
Subject: 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=subscribe&forumid=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: CFMX not compatible with Oracle 8.0.5
Joe - Thanks - any advice will be appreciated. I'm not an Oracle admin by any means, but I'm willing to get under the hood. - Jim -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 1:02 PM To: CF-Talk Subject: Re: CFMX not compatible with Oracle 8.0.5 Yes.. CFMX Oracle driver will only work with Oracle 8"I" and above. However i got CFMX working with Oracle 8.0.5 Using Oracle Native Type IV drivers. The setup is little Tricky but works!\ Let me know.. if you need help configuring this. Joe On Mon, 2 Dec 2002 10:50:05 -0600 Jim Campbell <[EMAIL PROTECTED]> wrote: > This is interesting... > > According to MM tech support, CFMX's Type 4 > JDBC driver will not connect > with Oracle 8.0.5. Short of upgrading our > instance of Oracle (which, yes, > we should get around to one of these days), has > anyone had this problem and > come up with a way of getting this to work? > I'd prefer not to use the ODBC, > but if it's a choice between that and no > functionality at all, I'll go with > that. > > Muchas gracias, > > - Jim > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
[SOLVED] Re: Passing parameters
Dave (and all), I tried it passing through the URL, and though it wrote it to the html CFMX still did not parse the code. Instead I decided to pass it like so: Then in my call of the tag I used this: This worked beautifully to call the tag properly and parse it out. So, in the future if I pass the variable from another page like so: It will dynamically recall the tag correctly. Thank you all for your assistance. Cutter * Dave Watts wrote: >>>For rather odd reasons I am attempting to pass a parameter >>>that looks a little like this: >>> >>> >>> >>>and call it like: >>> >>>#variables.hpimage# >>> >>>Which gives me...nothing? When I try to call it: >>> >>>#evaluate(variables.hpimage)# >>> >>>I get the error: >>> >>>The CFML compiler was processing: >>> >>>< marks the beginning of a ColdFusion tag.Did you mean >>>LT or LTE? >>> >>>Is there a way to do this? I know it seems rather odd to >>>pass a tag as a >>> >>>parameter but >>> >>> >>It's not the browser that interprets that parameter string, >>but rather the CFMX server. This bit of syntax... >> >>>image='Dr_Andes_final.jpg' width='204' hieght='238' >>alt='Dr. Jon M. Andes and friends' caption='yes'> >> >>..on it's own calls a custom tag (hpimage.cfm) that writes >>some rather extensive code to the page. I was trying to >>find a way to pass it as one parameter to a page instead >>of as five parameters (without a db call). >> >> > >In general, you can't use a tag as an attribute value for another tag. You >could get where you're trying to go like this, I suppose: > > > > > > > >Of course, this would run the custom tag ui:hpimage whether you needed to >use it or not. You might want to look for an alternative approach. Is this >custom tag written in CFMX, or is it a JSP custom tag? If it's written in >CFMX, you might find the component model to be more suitable for what you're >trying to do (or you may not, actually). > >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=subscribe&forumid=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
> 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.
You shouldn't be getting an error if the record doesn't match, you should
just not get any records back if none match. Randall's suggestion about
using parentheses should take care of your stated problem (you want to
compare the value to both fields, and if it matches either, you want to
select the record, right?)
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=subscribe&forumid=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: Problem with CFMX server
hi Dave... obviusly... rush make simple issues to look like great truobles with the link you provided i solved my problem in one second... many thanks and sorry for bothered... i completely forgot to look in macromedia site many many thanks alex - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, December 02, 2002 8:25 PM Subject: RE: Problem with CFMX server > hi i'm setting up a webserver with a number of domains > with this structure: > > domain 1 (ip address 1) -> home dir= d:\home\site1 > domain 2 (ip address 2) -> home dir= d:\home\site2 > domain 3 (ip address 3) -> home dir= d:\home\site3 > > and the result is that every time i restart the CF service > and run a website it correctly run the template (it say > d:\home\site[n]) the first time and later on different web > it keep to run the template on the starting web until i > restart the service. > > where may the problem be? http://www.macromedia.com/v1/handlers/index.cfm?ID=23179&Method=Full This is clearly described in the setup documentation, I believe. 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=subscribe&forumid=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
What error are you getting?
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:14 PM
To: CF-Talk
Subject: RE: OT - SQL Help
No it did not. It's very bizarre.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:04 PM
To: CF-Talk
Subject: 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=subscribe&forumid=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
What error are you getting?
Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com
-Original Message-
From: Tony Carcieri [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 2:14 PM
To: CF-Talk
Subject: RE: OT - SQL Help
No it did not. It's very bizarre.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:04 PM
To: CF-Talk
Subject: 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=subscribe&forumid=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: Problem with CFMX server
> hi i'm setting up a webserver with a number of domains > with this structure: > > domain 1 (ip address 1) -> home dir= d:\home\site1 > domain 2 (ip address 2) -> home dir= d:\home\site2 > domain 3 (ip address 3) -> home dir= d:\home\site3 > > and the result is that every time i restart the CF service > and run a website it correctly run the template (it say > d:\home\site[n]) the first time and later on different web > it keep to run the template on the starting web until i > restart the service. > > where may the problem be? http://www.macromedia.com/v1/handlers/index.cfm?ID=23179&Method=Full This is clearly described in the setup documentation, I believe. 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=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT - SQL Help
No it did not. It's very bizarre.
-Original Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 1:04 PM
To: CF-Talk
Subject: 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=subscribe&forumid=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.
Problem with CFMX server
hi i'm setting up a webserver with a number of domains with this structure: domain 1 (ip address 1) -> home dir= d:\home\site1 domain 2 (ip address 2) -> home dir= d:\home\site2 domain 3 (ip address 3) -> home dir= d:\home\site3 and this works fine now i installed cf mx and i want every website can use it i inserted a simple html page with a form (one text box) and the action is a cfm page which take the value of the form and say "hallo #form.name# this is website number xxx" where xxx is the web site number (manually written in each cfm page). this is the problem.. the first web site i try it works fine.. (i.e. try web 3 i got "hi Alex this is website 3") then i try others website and i keep receiving same answer (i.e. website 2 give me "hi Alex this is website 3") and so on... ok now i restart CF Service and retry starting with web 1 (answer = "hi Alex this is website 1") cool it work... now try web 3 (answer = "hi Alex this is website 1") :-| damn a friend of mine added these lines to my pages #thisDirectory# and the result is that every time i restart the CF service and run a website it correctly run the template (it say d:\home\site[n]) the first time and later on different web it keep to run the template on the starting web until i restart the service. where may the problem be? anyone can help? hope to have explained enough the scenario. web server is Windows 2000 Server (IIS 5.0) multihoming server ip based cold fusion mx professional (purchased and licensed, in the demo version it say after 30 days it switch automatically to single ip mode) before doing this upgrade to cold fusion mx i used coldfusion 4.0 without any problems. many thanks in advance alex -- Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f Sponsor: Vai contro corrente! Inizia a mantenerti in forma da Natale: Oliviero Città dello Sport! Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=1074&d=2-12 ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF Service Starting/Stopping
Mike Thanks for the reply Unfortunately cant get the server.log open the file is 1.2GB in size. Got to the Application.log open(it was only 123mg), See errors of form fields missing/misspelled etc. (which were known and corrected) and many of the following "warnings" "Warning","1844","11/01/02","08:07:07",,"In a CF_TagName construct custom tag file 'e:\CFusion\CustomTags\index.cfm' will occlude custom tag file 'e:\CFusion\CustomTags\ourtags\index.cfm'." not all for same file. So for more questions: I don't see how missing form fields, could cause a restart. What does the above warning mean? Is there anyway in CF admin to limit the size of the log file, so we don't have the issue of a large file again? Is there a way of opening the server.log (without buying a program), MSWord is limited to 25mbs? Thanks Rodney -Original Message- From: Mike Brunt [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:42 AM To: CF-Talk Subject: RE: CF Service Starting/Stopping Rodney, take a look in the ColdFusion error logs, in particular Application and Server logs. If you go into ColdFusion Administrator then Tools-Log Files you can view the logs there. If you need further guidance please give us some examples of any error messages in there, particularly in the Application log file. Kind Regards - Mike Brunt, CTO Webapper Blog http://www.webapper.net Web site http://www.webapper.com Downey CA Office 562.243.6255 AIM - webappermb Web Application Specialists -Original Message- From: Bruce, Rodney S HQISEC/Veridian IT Services [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:20 AM To: CF-Talk Subject: CF Service Starting/Stopping Hello all Sorry I know it is probably in the archives, but my search logic is not working. We are having an issue with the ColdFusion Service Stopping and Starting. But the messages in the event logs don't give details, just say that the service has been stopped/Started. What should we be looking for on this issue? We are running: CF 5 WIN2K IIS5 Thanks for any insight Rodney ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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
Re: CFMX not compatible with Oracle 8.0.5
Yes.. CFMX Oracle driver will only work with Oracle 8"I" and above. However i got CFMX working with Oracle 8.0.5 Using Oracle Native Type IV drivers. The setup is little Tricky but works!\ Let me know.. if you need help configuring this. Joe On Mon, 2 Dec 2002 10:50:05 -0600 Jim Campbell <[EMAIL PROTECTED]> wrote: > This is interesting... > > According to MM tech support, CFMX's Type 4 > JDBC driver will not connect > with Oracle 8.0.5. Short of upgrading our > instance of Oracle (which, yes, > we should get around to one of these days), has > anyone had this problem and > come up with a way of getting this to work? > I'd prefer not to use the ODBC, > but if it's a choice between that and no > functionality at all, I'll go with > that. > > Muchas gracias, > > - Jim > > ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF-TALK / Usenet?
Uhm.. Just a guess.. but this is probabaly a bad thing, coming from the author's site: -- Error occurred in tag CFX_NNTP A valid news server was not specified The error occurred in F:\sites\www.fuseware.com\support\News\index.cfm: line 7 5 : 6 : 7 : 8 : 9 : -- | -Original Message- | From: Massimo, Tiziana e Federica [mailto:[EMAIL PROTECTED]] | Sent: Monday, December 02, 2002 10:40 AM | To: CF-Talk | Subject: Re: CF-TALK / Usenet? | | | > Just curious if Usenet will become an option at some point? | > | I am following the list using NNTP since years :-) | Just point your newsreader to news.fuseware.com | | Be aware that in order to post you need to be subscribed, I | am subscribed to the digest, this way I can post without | getting hundreds of emails | | Massimo | | ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: Stripping end of cfhttp.filecontent
Thanks! That did the trick! Cathy Date: 12/02/2002 12:03 PM Author: Steve Reich Try this ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
RE: OT - CFMX JRun Web Server
Ok, try typing telnet 127.0.0.1 8500 at a command prompt, then GET /blarg.cfm (that's 2 enters) then look at the header. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:55 AM To: CF-Talk Subject: RE: OT - CFMX JRun Web Server > try typing > > telnet 127.0.0.1 80 > > at a command prompt, then > > GET /blarg.cfm > > (that's 2 enters) > > then look at the header. That's fine, except the CFMX web server listens on port 8500 by default. 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=subscribe&forumid=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
RE: OT - CFMX JRun Web Server
> try typing > > telnet 127.0.0.1 80 > > at a command prompt, then > > GET /blarg.cfm > > (that's 2 enters) > > then look at the header. That's fine, except the CFMX web server listens on port 8500 by default. 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=subscribe&forumid=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
RE: OT - CFMX JRun Web Server
try typing telnet 127.0.0.1 80 at a command prompt, then GET /blarg.cfm (that's 2 enters) then look at the header. Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net Scientia Est Potentia -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 10:08 AM To: CF-Talk Subject: RE: OT - CFMX JRun Web Server Anybody got any ideas here? I have gone through all of the documentation I can find on Macromedia's web site with no avail. What kind of web server is included with CFMX? I have not even found a name of the server to go look up info separately. Any help would be appreciated. Thanks -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:42 AM To: CF-Talk Subject: RE: CFMX JRun Web Server Okay, in jrun-web.xml I see virtual mappings, but what I am looking for is additional sites. For example, going to http://www.siteone.com would point to siteone's home directory vs. pointing to sitetwo's url would go to sitetwo's home directory. I am not looking for http://server/siteone. Does this make any more sense? Thanks -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: Monday, December 02, 2002 9:24 AM To: CF-Talk Subject: RE: CFMX JRun Web Server You need to add then within the jrun-web.xml file held in the CFusionMX wwwroot. -Original Message- From: Jeff D. Chastain [mailto:[EMAIL PROTECTED]] Sent: 02 December 2002 15:12 To: CF-Talk Subject: OT: CFMX JRun Web Server I have a web server running IIS 5 and CF5. However, I now have a couple of apps that require CFMX, so I was attempting to install the stand-alone JRun server with CFMX (so I can run both CF5 and CFMX on the same box). My question is, how do I setup multiple sites/IPs in the JRun server? I have several different web sites on this server (each with a unique IP) that I need to have CFMX apps under. Thanks -- Jeff ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=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: CF-TALK / Usenet?
> Just curious if Usenet will become an option at some point? > I am following the list using NNTP since years :-) Just point your newsreader to news.fuseware.com Be aware that in order to post you need to be subscribed, I am subscribed to the digest, this way I can post without getting hundreds of emails Massimo ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com
