Re: Validate Object's Component Type
On Wed, Apr 1, 2009 at 7:24 PM, Donnie Carvajal wrote: > 1. Does anyone know if there is built in functionality to ColdFusion that > will validate if a variable is an object of a certain CFC? isInstanceOff() Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321333 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replace()
You need to wrap the replace in #s Sent from my iPhone On Apr 4, 2009, at 4:41 PM, "BobSharp" wrote: > > Table has a Primary Key of DealerCode (UUID) > A form POSTs the required key ( form.txtDealer ) to be picked up > by the Details Update page. > > > My scripting for the Update Details page includes ... >#form.txtDealer# > > #matchDealer# > > Outputs from that are correct. > > > This query fails ... > >SELECT * >FROM Dealers d >WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#; > > > > Errors are ... > Error Executing Database Query. > You have an error in your SQL syntax; check the manual that > corresponds to your MySQL server version for the right syntax to use > near ''all')=4A1BC12D6C1D460FB50D7420A5BA306B' at line 3 > > The error occurred in /web/PurchaseOrders/update_Dealer.cfm: line 40 > 38 : SELECT * > 39 : FROM Dealers d > 40 : WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#; > 41 : > > SQLSELECT * FROM Dealers d WHERE > Replace(d.DealerCode,'-','','all')=4A1BC12D6C1D460FB50D7420A5BA306B; > > > -- > I am using the free version of SPAMfighter. > We are a community of 6 million users fighting spam. > SPAMfighter has removed 12892 of my spam emails to date. > Get the free SPAMfighter here: http://www.spamfighter.com/len > > The Professional version does not have this message > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321332 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replace()
Strings need single quotes in SQL: WHERE Replace(d.DealerCode,'-','','all') = '#matchDealer#' However, you must use cfqueryparam for any user provided input: WHERE Replace(d.DealerCode,'-','','all') = mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/4/5 BobSharp : > > Table has a Primary Key of DealerCode (UUID) > A form POSTs the required key ( form.txtDealer ) to be picked up by the > Details Update page. > > > My scripting for the Update Details page includes ... > #form.txtDealer# > > #matchDealer# > > Outputs from that are correct. > > > This query fails ... > > SELECT * > FROM Dealers d > WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#; > > > > Errors are ... > Error Executing Database Query. > You have an error in your SQL syntax; check the manual that corresponds to > your MySQL server version for the right syntax to use near > ''all')=4A1BC12D6C1D460FB50D7420A5BA306B' at line 3 > > The error occurred in /web/PurchaseOrders/update_Dealer.cfm: line 40 > 38 : SELECT * > 39 : FROM Dealers d > 40 : WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#; > 41 : > > SQL SELECT * FROM Dealers d WHERE > Replace(d.DealerCode,'-','','all')=4A1BC12D6C1D460FB50D7420A5BA306B; > > > -- > I am using the free version of SPAMfighter. > We are a community of 6 million users fighting spam. > SPAMfighter has removed 12892 of my spam emails to date. > Get the free SPAMfighter here: http://www.spamfighter.com/len > > The Professional version does not have this message > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replace()
And of course I just realized that the error your seeing is in the replace bit, so the other stuff was an error waiting to happen. Are you trying to use the MySQL replace function or the CF replace function? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/4/5 James Holmes : > Strings need single quotes in SQL: > > WHERE Replace(d.DealerCode,'-','','all') = '#matchDealer#' > > However, you must use cfqueryparam for any user provided input: > > WHERE Replace(d.DealerCode,'-','','all') = cfsqltype="cf_sql_varchar" value="#matchDealer#"> > > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com.au/blog/ > > > > 2009/4/5 BobSharp : >> >> Table has a Primary Key of DealerCode (UUID) >> A form POSTs the required key ( form.txtDealer ) to be picked up by the >> Details Update page. >> >> >> My scripting for the Update Details page includes ... >> #form.txtDealer# >> >> #matchDealer# >> >> Outputs from that are correct. >> >> >> This query fails ... >> >> SELECT * >> FROM Dealers d >> WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#; >> >> >> >> Errors are ... >> Error Executing Database Query. >> You have an error in your SQL syntax; check the manual that corresponds to >> your MySQL server version for the right syntax to use near >> ''all')=4A1BC12D6C1D460FB50D7420A5BA306B' at line 3 >> >> The error occurred in /web/PurchaseOrders/update_Dealer.cfm: line 40 >> 38 : SELECT * >> 39 : FROM Dealers d >> 40 : WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#; >> 41 : >> >> SQL SELECT * FROM Dealers d WHERE >> Replace(d.DealerCode,'-','','all')=4A1BC12D6C1D460FB50D7420A5BA306B; >> >> >> -- >> I am using the free version of SPAMfighter. >> We are a community of 6 million users fighting spam. >> SPAMfighter has removed 12892 of my spam emails to date. >> Get the free SPAMfighter here: http://www.spamfighter.com/len >> >> The Professional version does not have this message >> >> >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Replace()
Table has a Primary Key of DealerCode (UUID) A form POSTs the required key ( form.txtDealer ) to be picked up by the Details Update page. My scripting for the Update Details page includes ... #form.txtDealer# #matchDealer# Outputs from that are correct. This query fails ... SELECT * FROM Dealers d WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#; Errors are ... Error Executing Database Query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''all')=4A1BC12D6C1D460FB50D7420A5BA306B' at line 3 The error occurred in /web/PurchaseOrders/update_Dealer.cfm: line 40 38 : SELECT * 39 : FROM Dealers d 40 : WHERE Replace(d.DealerCode,'-','','all')=#matchDealer#; 41 : SQLSELECT * FROM Dealers d WHERE Replace(d.DealerCode,'-','','all')=4A1BC12D6C1D460FB50D7420A5BA306B; -- I am using the free version of SPAMfighter. We are a community of 6 million users fighting spam. SPAMfighter has removed 12892 of my spam emails to date. Get the free SPAMfighter here: http://www.spamfighter.com/len The Professional version does not have this message ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Get request using cfhttp...possible to see the actual URL sent?
IF I understand the question Firebug would allow you to view the traffic back and forth from Digg. G! On Sat, Apr 4, 2009 at 10:41 AM, Andy Matthews wrote: > > I'm working on adding in one of the Digg APIs into an app I'm writing and > I'm having problems with it. I was wondering if there was anything that I > could inspect which would detail the full URL sent to the API. > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321328 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: encrypt database column
>>1) seeing as this can be run on any column (even integer fields) is it possible to encrypt an integer and then place the resulting encrypted string back into the integer column of the database If the encrypted data is also an integer, then yes, but if is can be any string, forget it. Not even woth trying. >>2) as this function will run on any table/column how can i write an sql statement that just loops through the column encrypting the data? This depends on the database you're using. May be a stored procedure could do it. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321327 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Get request using cfhttp...possible to see the actual URL sent?
Not quite sure what you're after, but if you're using CFHTTP and trying to reconstruct a URL that gets generated from a request, like in the case of a redirect, try this: http://www.yourHTTPREquest.com/?blah=blah"; redirect="No"> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321325 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Get request using cfhttp...possible to see the actual URL sent?
I'm working on adding in one of the Digg APIs into an app I'm writing and I'm having problems with it. I was wondering if there was anything that I could inspect which would detail the full URL sent to the API. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321323 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cross browser CSS
Peter Boughton wrote: > And whether you count -moz-* or -webkit-* stuff too - since it's technically > engine-specific but of course doesn't apply if the browser doesn't support it. > One sheet for *good* browsers (gecko, webkit, presto etc), and one for the other beast (s). > But for Firefox/Mozilla, anything involving fieldset/legend layout tends to > need special treatment due to the idiotic restrictions placed on legends. Legends tend to be buggy in more than just that browser, so if pixel perfect precision is required it's better to use CSS: http://www.456bereastreet.com/lab/styling-form-controls-revisited/legend/ adieu Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321322 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cross browser CSS
>>First, start by writing standards compliant HTML with a valid Strict DOCTYPE - this is the best way to avoid most of the browser bugs in the first place. Of course, this will work... at least for all visitors having browsers supporting "Strict DOCTYPE" with no bug ;-) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321321 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4