RE: Replacing Strings
Try: #REReplace('dill"s','"',"'","ALL")# Marius Milosav ScorpioSoft Corp. www.scorpiosoft.com -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: November 1, 2007 8:47 AM To: CF-Talk Subject: Replacing Strings Hey list, I'm trying to replace a double quote in a text field to a single quote. I've tried using ReReplace, but it still crashes the Cold Fusion server. What I've done is this: #REReplace("dill"s",""","'","ALL")# See, users tend to like using double quotes in a text field which breaks the SQL query. How can i check if there's a double quote in a #form.textfield# and remove it? Thanks in advance. Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Replacing Strings
use single quotes in your replace function (and you don't need REReplace just FYI). REReplace('dill"s','"',"'","ALL") -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Thursday, November 01, 2007 7:47 AM To: CF-Talk Subject: Replacing Strings Hey list, I'm trying to replace a double quote in a text field to a single quote. I've tried using ReReplace, but it still crashes the Cold Fusion server. What I've done is this: #REReplace("dill"s",""","'","ALL")# See, users tend to like using double quotes in a text field which breaks the SQL query. How can i check if there's a double quote in a #form.textfield# and remove it? Thanks in advance. Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292467 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replacing Strings
ReReplace is for using a regular expression. Try Replace. You'll also need to quadruple the double quotes, something like this should work: #Replace("dill""s", , "'", "ALL")# That is, the content of each expression is enclosed in double quotes in this example. When the expression itself contains a double-quote, you have to double-that up to escape it. Sometimes when I just don't want to deal with it, I'll enclose the expressions that contain double-quotes in single quotes to make it easier to read, something like: #Replace('dill"s', '"', "'", 'ALL")# If the only issue you face with the double-quotes is in queries, make sure to use cfqueryparam, which handles escaping the double quotes, single quotes, etc. If you need to capture the user input in another form field, you might want to try replacing with the html safe equivalent " #replace(mystring, , """, "ALL")# Hope that helps. Cheers, Kris > I'm trying to replace a double quote in a text field to a single quote. I've > tried using ReReplace, but it still crashes the Cold Fusion server. > > What I've done is this: > > #REReplace("dill"s",""","'","ALL")# > > See, users tend to like using double quotes in a text field which breaks the > SQL query. How can i check if there's a double quote in a #form.textfield# > and remove it? ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292463 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replacing Strings
are you using cfqueryparam's on your query? It should escape them on its own I would think. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292468 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replacing Strings
replace('dill"s', '"', "'", "all") In other words, where you are explicitly writing double-quotes (like for the find string) wrap in single quotes, and where you are explicitly writing single quotes (like the replace string) wrap in double quotes. --Ben Doom Rick Sanders wrote: > Hey list, > > > > I'm trying to replace a double quote in a text field to a single quote. I've > tried using ReReplace, but it still crashes the Cold Fusion server. > > What I've done is this: > > #REReplace("dill"s",""","'","ALL")# > > > > See, users tend to like using double quotes in a text field which breaks the > SQL query. How can i check if there's a double quote in a #form.textfield# > and remove it? > > > > Thanks in advance. > > > > Rick Sanders > > Webenergy > > Canada: 902-401-7689 > > USA: 919-799-9076 > > Canada: www.webenergy.ca > > USA: www.webenergyusa.com > > > > > > > > ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Replacing Strings
Didn't think of that, but it's less code to do a replace than the cfqueryparam. Rick Sanders Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Dana Kowalski [mailto:[EMAIL PROTECTED] Sent: November-01-07 11:42 AM To: CF-Talk Subject: Re: Replacing Strings are you using cfqueryparam's on your query? It should escape them on its own I would think. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292471 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Replacing Strings
Hi Andy, Thanks for your response. I can't believe I made the rookie mistake of not using single quotes instead of double quotes in the expression! Kind regards, Rick Sanders Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: November-01-07 10:46 AM To: CF-Talk Subject: RE: Replacing Strings use single quotes in your replace function (and you don't need REReplace just FYI). REReplace('dill"s','"',"'","ALL") -Original Message- From: Rick Sanders [mailto:[EMAIL PROTECTED] Sent: Thursday, November 01, 2007 7:47 AM To: CF-Talk Subject: Replacing Strings Hey list, I'm trying to replace a double quote in a text field to a single quote. I've tried using ReReplace, but it still crashes the Cold Fusion server. What I've done is this: #REReplace("dill"s",""","'","ALL")# See, users tend to like using double quotes in a text field which breaks the SQL query. How can i check if there's a double quote in a #form.textfield# and remove it? Thanks in advance. Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292470 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replacing Strings
Not to put too fine a point on it, but if this data is coming directly from an end user, it would probably be in your best interest to add the anyway. It does quite a bit more than just quote escaping. Definitely a best practice recommendation. --Ben Doom Rick Sanders wrote: > Didn't think of that, but it's less code to do a replace than the > cfqueryparam. > > > Rick Sanders > Canada: 902-401-7689 > USA: 919-799-9076 > Canada: www.webenergy.ca > USA: www.webenergyusa.com > > > -Original Message- > From: Dana Kowalski [mailto:[EMAIL PROTECTED] > Sent: November-01-07 11:42 AM > To: CF-Talk > Subject: Re: Replacing Strings > > are you using cfqueryparam's on your query? It should escape them on its own > I would think. > > > > > ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replacing Strings
On Nov 1, 2007 7:44 AM, Rick Sanders <[EMAIL PROTECTED]> wrote: > Didn't think of that, but it's less code to do a replace than the > cfqueryparam. the cfqueryparam buys you more. and you should be using it anyway. -- Charlie Griefer "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292473 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Replacing Strings
Thanks for your feedback, I'm an ASP.net & XML programmer and new to Cold Fusion. I'll definitely look into the cfqueryparam since it seems to be the best "Cold Fusion" way to control user input, and not have your queries break down. Kind regards, Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: November-01-07 12:10 PM To: CF-Talk Subject: Re: Replacing Strings Not to put too fine a point on it, but if this data is coming directly from an end user, it would probably be in your best interest to add the anyway. It does quite a bit more than just quote escaping. Definitely a best practice recommendation. --Ben Doom Rick Sanders wrote: > Didn't think of that, but it's less code to do a replace than the > cfqueryparam. > > > Rick Sanders > Canada: 902-401-7689 > USA: 919-799-9076 > Canada: www.webenergy.ca > USA: www.webenergyusa.com > > > -Original Message- > From: Dana Kowalski [mailto:[EMAIL PROTECTED] > Sent: November-01-07 11:42 AM > To: CF-Talk > Subject: Re: Replacing Strings > > are you using cfqueryparam's on your query? It should escape them on its own > I would think. > > > > > ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292474 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replacing Strings
Bigger rookie mistake is not using cfqueryparam. Adam Haskell http://cfrant.blogspot.com On 11/1/07, Rick Sanders <[EMAIL PROTECTED]> wrote: > > Hi Andy, > > Thanks for your response. I can't believe I made the rookie mistake of not > using single quotes instead of double quotes in the expression! > > Kind regards, > > Rick Sanders > Canada: 902-401-7689 > USA: 919-799-9076 > Canada: www.webenergy.ca > USA: www.webenergyusa.com > > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: November-01-07 10:46 AM > To: CF-Talk > Subject: RE: Replacing Strings > > use single quotes in your replace function (and you don't need REReplace > just FYI). > > REReplace('dill"s','"',"'","ALL") > > -Original Message- > From: Rick Sanders [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 01, 2007 7:47 AM > To: CF-Talk > Subject: Replacing Strings > > Hey list, > > > > I'm trying to replace a double quote in a text field to a single quote. > I've > tried using ReReplace, but it still crashes the Cold Fusion server. > > What I've done is this: > > #REReplace("dill"s",""","'","ALL")# > > > > See, users tend to like using double quotes in a text field which breaks > the > SQL query. How can i check if there's a double quote in a #form.textfield# > and remove it? > > > > Thanks in advance. > > > > Rick Sanders > > Webenergy > > Canada: 902-401-7689 > > USA: 919-799-9076 > > Canada: www.webenergy.ca > > USA: www.webenergyusa.com > > > > > > > > > > > > ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292475 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Replacing Strings
"You've just received a virtual raspberry!" Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: November-01-07 12:28 PM To: CF-Talk Subject: Re: Replacing Strings Bigger rookie mistake is not using cfqueryparam. Adam Haskell http://cfrant.blogspot.com On 11/1/07, Rick Sanders <[EMAIL PROTECTED]> wrote: > > Hi Andy, > > Thanks for your response. I can't believe I made the rookie mistake of not > using single quotes instead of double quotes in the expression! > > Kind regards, > > Rick Sanders > Canada: 902-401-7689 > USA: 919-799-9076 > Canada: www.webenergy.ca > USA: www.webenergyusa.com > > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: November-01-07 10:46 AM > To: CF-Talk > Subject: RE: Replacing Strings > > use single quotes in your replace function (and you don't need REReplace > just FYI). > > REReplace('dill"s','"',"'","ALL") > > -Original Message- > From: Rick Sanders [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 01, 2007 7:47 AM > To: CF-Talk > Subject: Replacing Strings > > Hey list, > > > > I'm trying to replace a double quote in a text field to a single quote. > I've > tried using ReReplace, but it still crashes the Cold Fusion server. > > What I've done is this: > > #REReplace("dill"s",""","'","ALL")# > > > > See, users tend to like using double quotes in a text field which breaks > the > SQL query. How can i check if there's a double quote in a #form.textfield# > and remove it? > > > > Thanks in advance. > > > > Rick Sanders > > Webenergy > > Canada: 902-401-7689 > > USA: 919-799-9076 > > Canada: www.webenergy.ca > > USA: www.webenergyusa.com > > > > > > > > > > > > ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292478 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Replacing Strings
Even bigger would be saying "Cold Fusion" not once... but twice. Definitely look into cfqeryparam if you aren't using it. If you accept info from end users to put into your database and don't use cfqeryparam... you are just asking for trouble. There are also other benefits. One would be... not having to replace any kind of quotes. :-) ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Adam Haskell [mailto:[EMAIL PROTECTED] Sent: Thursday, November 01, 2007 11:28 AM To: CF-Talk Subject: Re: Replacing Strings Bigger rookie mistake is not using cfqueryparam. Adam Haskell http://cfrant.blogspot.com On 11/1/07, Rick Sanders <[EMAIL PROTECTED]> wrote: > > Hi Andy, > > Thanks for your response. I can't believe I made the rookie mistake of not > using single quotes instead of double quotes in the expression! > > Kind regards, > > Rick Sanders > Canada: 902-401-7689 > USA: 919-799-9076 > Canada: www.webenergy.ca > USA: www.webenergyusa.com > > -Original Message- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: November-01-07 10:46 AM > To: CF-Talk > Subject: RE: Replacing Strings > > use single quotes in your replace function (and you don't need REReplace > just FYI). > > REReplace('dill"s','"',"'","ALL") > > -Original Message- > From: Rick Sanders [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 01, 2007 7:47 AM > To: CF-Talk > Subject: Replacing Strings > > Hey list, > > > > I'm trying to replace a double quote in a text field to a single quote. > I've > tried using ReReplace, but it still crashes the Cold Fusion server. > > What I've done is this: > > #REReplace("dill"s",""","'","ALL")# > > > > See, users tend to like using double quotes in a text field which breaks > the > SQL query. How can i check if there's a double quote in a #form.textfield# > and remove it? > > > > Thanks in advance. > > > > Rick Sanders > > Webenergy > > Canada: 902-401-7689 > > USA: 919-799-9076 > > Canada: www.webenergy.ca > > USA: www.webenergyusa.com > > > > > > > > > > > > ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292484 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replacing Strings
It's the ColdFusion version of the best way, in any programming language, to prevent SQL injection and ensure correct datatypes - bind parameters. You should have been using them in ASP.net too. On 11/2/07, Rick Sanders <[EMAIL PROTECTED]> wrote: > Thanks for your feedback, > > I'm an ASP.net & XML programmer and new to Cold Fusion. I'll definitely look > into the cfqueryparam since it seems to be the best "Cold Fusion" way to > control user input, and not have your queries break down. > > Kind regards, > > Rick Sanders > Webenergy > Canada: 902-401-7689 > USA: 919-799-9076 > Canada: www.webenergy.ca > USA: www.webenergyusa.com > > > -Original Message- > From: Ben Doom [mailto:[EMAIL PROTECTED] > Sent: November-01-07 12:10 PM > To: CF-Talk > Subject: Re: Replacing Strings > > Not to put too fine a point on it, but if this data is coming directly > from an end user, it would probably be in your best interest to add the > anyway. It does quite a bit more than just quote > escaping. Definitely a best practice recommendation. > > --Ben Doom > > Rick Sanders wrote: > > Didn't think of that, but it's less code to do a replace than the > > cfqueryparam. > > > > > > Rick Sanders > > Canada: 902-401-7689 > > USA: 919-799-9076 > > Canada: www.webenergy.ca > > USA: www.webenergyusa.com > > > > > > -Original Message- > > From: Dana Kowalski [mailto:[EMAIL PROTECTED] > > Sent: November-01-07 11:42 AM > > To: CF-Talk > > Subject: Re: Replacing Strings > > > > are you using cfqueryparam's on your query? It should escape them on its > own > > I would think. > > > > > > > > > > > > > > ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292523 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replacing strings as part of a query
What database are you using? This sounds like something that would be best handled at the database level, instead of running it through CF. - Original Message - From: "Richard Crawford" > Actually, my question about replacing special characters (thanks to all > who answered, by the way) was part of a larger question. What I really > need to do is select all rows of one table, modify the value of one > field, and insert all of the rows, with that one modified field, into > another table. > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Replacing strings as part of a query
Deanna Schneider wrote: > What database are you using? This sounds like something that would be best > handled at the database level, instead of running it through CF. Deanna, I'm using SQL Server 7. The problem is that the field with the characters to be replaced is a TEXT field, and you can't use the REPLACE function on a TEXT field. And, unfortunately, the data is too big in some of the records to CAST to VARCHAR. Here is the SQL that I've tried using: - select msgID, msgSent, msgFromType, msgFromID, msgSubject, REPLACE (CAST(msgMessage AS varchar(8000)), CHAR(13), '') AS newMessage, msgOriginal, attID into tblMessageNew from tblMessage -- In records where the value of msgMessage is greater than 8000 characters, the SQL bombs and no results are returned. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Replacing strings as part of a query
Don't know SQL Server. Sorry. But, as for your 500 error - make sure that "show friendly http errors is turned off in your IE preferences. Then, you should at least see more info. - Original Message - From: "Richard Crawford" > Deanna Schneider wrote: > > > What database are you using? This sounds like something that would be best > > handled at the database level, instead of running it through CF. > > Deanna, > > I'm using SQL Server 7. The problem is that the field with the > characters to be replaced is a TEXT field, and you can't use the REPLACE > function on a TEXT field. And, unfortunately, the data is too big in > some of the records to CAST to VARCHAR. > > Here is the SQL that I've tried using: > > - > > select > msgID, > msgSent, > msgFromType, > msgFromID, > msgSubject, > REPLACE (CAST(msgMessage AS varchar(8000)), CHAR(13), '') AS > newMessage, > msgOriginal, > attID > into tblMessageNew > from tblMessage > > -- > > In records where the value of msgMessage is greater than 8000 > characters, the SQL bombs and no results are returned. > > > > -- > Richard S. Crawford > Programmer III, > UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) > (916)327-7793 / [EMAIL PROTECTED] > > [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Replacing strings as part of a query
Deanna Schneider wrote: > Don't know SQL Server. Sorry. But, as for your 500 error - make sure that > "show friendly http errors is turned off in your IE preferences. Then, you > should at least see more info. That in itself isn't an issue (I don't use IE if I can possibly avoid it). I had hoped that I could find more information by checking the CF server log, but it was unrevealing. -- Richard S. Crawford Programmer III, UC Davis Extension Distance Learning Group (http://unexdlc.ucdavis.edu) (916)327-7793 / [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]