Re: verity & cfscript

2008-10-07 Thread Dave l
Yes and no dave.. I figured as much when I was doing it but if it does index the source code then why wouldn't it index all of the source code and not just whats inside a cfscript tag? Or why would it not index the source code when moved inside a cfset tag instead of cfscript? Or why would I ha

Re: strange (lt) behaviour

2008-10-07 Thread rex
All numeric data types in CF are typed as Java Strings. You must do a JavaCast() to type BigDecimal and do comparisons on that. Here is your modified code:

Re: Handling a VO parsed from Flex to CF

2008-10-07 Thread Brian Kotek
I just use Charles (I paid for it but the free version works just as well with some nag messages). Won't work with AIR (since it isn't browser based) but works great with Flex. On Tue, Oct 7, 2008 at 8:31 PM, Paul Kukiel <[EMAIL PROTECTED]> wrote: > This helps me alot when debugging cfc from a Fl

Re: verity & cfscript

2008-10-07 Thread Dave Watts
> I have a verity collection and it is picking up some cfm code. Now of course > i can take out > the .cfm & .cfml in the collection code but then it doesn't > index actual .cfm pages which is > needed (Like this-page.cfm) > > The only cfm code it seams to be picking up is inside of cfscript bloc

Re: Best free ColdFusion server?

2008-10-07 Thread Casey Dougall
On Tue, Oct 7, 2008 at 2:24 PM, Philip Kaplan <[EMAIL PROTECTED]> wrote: WASRailo vs BlueDragon vs Smith vs ?? > > http://www.smithproject.org/ > http://www.newatlanta.com/bluedragon/ > http://www.railo.ch/ > > Yet to hear anyone talk in depth about coral web builder... http://www.pcaonline.com/in

Re: verity & cfscript

2008-10-07 Thread Dave l
some pages have the exact same script and they don't show but other pages do.. very weird > No there is no cfsets in there. > Whats even weirder is that on some pages it indexes everything in the > top cfscript and other times it only indexes a part of it. > > Ok now the weirder part is that i

Re: Best free ColdFusion server?

2008-10-07 Thread Gerald Guido
I guess I will go first then. The answer is: "It depends". Like Adam pointed out both of them are mature and very capable engines. Both have their stronger/weaker points, it is just matters what you are looking for. My over all impression is that those more comfortable in a J2EE environment may f

RE: Handling a VO parsed from Flex to CF

2008-10-07 Thread Paul Kukiel
This helps me alot when debugging cfc from a Flex app At the top of the method being called. Paul. -Original Message- From: Simon Bailey [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 October 2008 10:41 PM To: cf-talk Subject: Re: Handling a VO parsed from Flex to CF Unable to invoke

Re: verity & cfscript

2008-10-07 Thread Dave l
No there is no cfsets in there. Whats even weirder is that on some pages it indexes everything in the top cfscript and other times it only indexes a part of it. Ok now the weirder part is that if I take out the cfscript and put the vars in cfsets it works fine. But of course that really isn't an

RE: Handling a VO parsed from Flex to CF

2008-10-07 Thread Paul Kukiel
This helps me alot when debugging cfc from a Flex app At the top of the method being called. Paul. -Original Message- From: Simon Bailey [mailto:[EMAIL PROTECTED] Sent: Tuesday, 7 October 2008 10:41 PM To: cf-talk Subject: Re: Handling a VO parsed from Flex to CF Unable to invo

RE: verity & cfscript

2008-10-07 Thread Adrian Lynch
I've got it to pull out CF tags before. Maybe it is but because you're viewing them on a web page you don't seem them because of the < and >. Try viewing the source when you search for cfif or cfset etc. Adrian -Original Message- From: Dave l Sent: 08 October 2008 00:31 To: cf-talk Subje

Re: verity & cfscript

2008-10-07 Thread Dave l
I have seen the vspider but there is too many ?'s and not enough time to figure out all i need for that. It's just seems odd that in all the books and examples that it doesn't mention this and the default files include .cfml & .cfm but who would actually want it to search the actually source co

RE: Passing a query to a CFML tag

2008-10-07 Thread Adrian Lynch
Probably a case of try it and see. Without seeing your code it's hard to know the answer to this and I'm to last person to scream about doing things "right", but custom tags don't strike me as being the sort of place to change data. Could maybe a function or CFC be a better fit? Adrian Building a

Re: Invitation to Test OpenBD Linux Installer

2008-10-07 Thread Jordan Michaels
Excellent! I'm really interested to hear how it goes. Thanks for the help Chris. =) Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open BlueDragon Steering Committee Adobe Solution Provider Chris Jordan wrote: > Jordan, > > Sorry it's taken me so long to get back t

RE: Sorta OT: Setting up CF on a MacBook

2008-10-07 Thread Tiffany Trott
Well before 1999 I was a complete and total MacHead...back then when I started CF dev it really only ran on windows so I slowly, begrudginly made the switch. Now with the chance to pick up a MB or MBP I was excited to see I could run CF and its goodies on it. Just need to know what I need to be loo

Re: 8.0.1 webservice compile errors

2008-10-07 Thread Dave Watts
> We're running a pair of CF 8 Standard Servers. Since installing the 8.0.1 > updater, > webservices have been giving me a headache. Did you flush the cfclasses directory? You should do that after upgrades. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides t

Re: Passing a query to a CFML tag

2008-10-07 Thread Dave Watts
> Are queries passed into CFML tags by reference or by value? Queries are passed by reference. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Balti

Re: Invitation to Test OpenBD Linux Installer

2008-10-07 Thread Chris Jordan
Jordan, Sorry it's taken me so long to get back to you. I really appreciate your responses. I'll will back things up prior to doing this install just in case, but it sounds like everything should go fine. I'll be giving the installation script a go this weekend (10/10 - 10/12). Thanks again! Chr

Re: Passing a query to a CFML tag

2008-10-07 Thread Jim McAtee
I want to modify the query within the tag. If the query were being passed by reference then I would think it wouldn't be necessary to reference it using the CALLER scope. - Original Message - From: "Adrian Lynch" <[EMAIL PROTECTED]> To: "cf-talk" Sent: Tuesday, October 07, 2008 3:24

RE: verity & cfscript

2008-10-07 Thread Adrian Lynch
If you tell verity to index .cfm files it'll read the source. As far as I know you can't stop that (I know less and less about Verity these day!). Look into using the vspider. Google will throw up some answers but the short of it is, it'll crawl your site via the web so you'll end up indexing it

RE: Passing a query to a CFML tag

2008-10-07 Thread Adrian Lynch
Nope, it's by reference. I'd only set it to CALLER if you were modifying it. Do you really mean that you want to just use the query in the tag? I pass it in as: and then use it with: Works nicely. Adrian Building a DB of errors at http://cferror.org/ -Original Message- From: Jim

Re: Best free ColdFusion server?

2008-10-07 Thread Jordan Michaels
lol Adam. What money? Last I checked both OpenBD was free. You been passing Alan some money on the side? BTW, URL for OpenBD is as follows (since it wasn't included in previous post): http://www.openbluedragon.org/ Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ Open B

Passing a query to a CFML tag

2008-10-07 Thread Jim McAtee
Are queries passed into CFML tags by reference or by value? From what I'm seeing, it looks like by value. If that's the case, is it necessary then to just pass the name of the query and then use "caller.attributes.query"?

Re: Best free ColdFusion server?

2008-10-07 Thread Peter Boughton
>They're also both forgien so either way your money if going over seas ;) Unless you happen to be half-Swiss half-Scottish. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Tria

Re: Sorta OT: Setting up CF on a MacBook

2008-10-07 Thread Dave l
If you will be working with photos then get the mbp for the extra horsepower & larger screens. I am very much not a windows fan so my opinion is biased but I don't think there is a better dev machine than a mbp, you can do everything from one machine. >I am in the market for a new laptop and

Re: timestamp/date error from mySQL

2008-10-07 Thread Mike Little
thanks azadi, that did indeed work. mike >before you start pestering your host to modify the jdbc connection >string, try this: > >SELECT customer_id, IF(ISNULL(STR_TO_DATE(LEFT(customer_dob, 10), >'%Y-%m-%d')), 'Not Defined', customer_dob) AS dob >FROM customer >WHERE 1=1 > >hth > >Azadi Saryev >

Re: Best free ColdFusion server?

2008-10-07 Thread Aaron Rouse
Where is OpenBD based out of? On Tue, Oct 7, 2008 at 3:32 PM, Adam Haskell <[EMAIL PROTECTED]> wrote: > Both are capable engines. Right now I'd say Railo has a better > compatibility > with ColdFusion 8.0 but OpenBD is improving in that area. They both take > different routes to deliver the engin

Re: Best free ColdFusion server?

2008-10-07 Thread Adam Haskell
Both are capable engines. Right now I'd say Railo has a better compatibility with ColdFusion 8.0 but OpenBD is improving in that area. They both take different routes to deliver the engines capabilities. Both are very capable engines with a wealth of support from inside and outside of the ColdFusio

Re: 8.0.1 webservice compile errors

2008-10-07 Thread Ben Doom
The refreshWSDL attribute didn't work. I cannot create the webservice in the Administrator, which is weird. I've also tried deleting the stubs and restarting the CF service. --Ben Doom >You might try restarting CF or try using cfinvoke with refreshWSDL="true". >It sounds like CF has cached th

Re: Best free ColdFusion server?

2008-10-07 Thread Peter Boughton
>Railo vs BlueDragon vs Smith vs ?? Smith doesn't have anywhere near enough compatibility with CF, nor any distinguishing features to set it apart - it would need a lot of work before I'd consider it worth considering/comparing. Railo vs OpenBD is probably going to end up in the same vein as t

Re: ColdFusion 8 with Oracle 10g R2 Issue

2008-10-07 Thread Boysie Tupaz
I just checked with our DBA and we have a dedicated connection. > It depends on your Database setup - it might be best to ask your DBA. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get t

verity & cfscript

2008-10-07 Thread Dave l
I have a verity collection and it is picking up some cfm code. Now of course i can take out the .cfm & .cfml in the collection code but then it doesn't index actual .cfm pages which is needed (Like this-page.cfm) The only cfm code it seams to be picking up is inside of cfscript blocks and so in

Sorta OT: Setting up CF on a MacBook

2008-10-07 Thread Tiffany Trott
I am in the market for a new laptop and am thinking abot grabbing a MacBook, more for my photography business and editing, than anything else. But Isaw the recommendation of a MacBook Pro for a development work station and was intrigued. I have been away from the development world for a while and a

Re: 8.0.1 webservice compile errors

2008-10-07 Thread Brian Kotek
You might try restarting CF or try using cfinvoke with refreshWSDL="true". It sounds like CF has cached the generated WSDL so you need to force it to regenerate that if you've changed anything. This is probably why changing the file names works. On Tue, Oct 7, 2008 at 2:31 PM, Ben Doom <[EMAIL PRO

Re: Best free ColdFusion server?

2008-10-07 Thread Philip Kaplan
Hehe. I figured this has been discussed to death on cf-talk, but not since I've been a subscriber. Can someone give me a Cliff's Notes version? On Tue, Oct 7, 2008 at 11:31 AM, Gerald Guido <[EMAIL PROTECTED]>wrote: > I am going to make some popcorn > > > On Tue, Oct 7, 2008 at 2:24 PM, Phi

Re: 8.0.1 webservice compile errors

2008-10-07 Thread Ben Doom
It appears that if I rename the cfc's, they then work. However, the files are not just used internally -- they are connected to by outside websites. Suggestions? --Ben Doom ~| Adobe® ColdFusion® 8 software 8 is the most impor

Re: Best free ColdFusion server?

2008-10-07 Thread Gerald Guido
I am going to make some popcorn On Tue, Oct 7, 2008 at 2:24 PM, Philip Kaplan <[EMAIL PROTECTED]> wrote: > Railo vs BlueDragon vs Smith vs ?? > > http://www.smithproject.org/ > http://www.newatlanta.com/bluedragon/ > http://www.railo.ch/ > > > ~~

Best free ColdFusion server?

2008-10-07 Thread Philip Kaplan
Railo vs BlueDragon vs Smith vs ?? http://www.smithproject.org/ http://www.newatlanta.com/bluedragon/ http://www.railo.ch/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

RE: ColdFusion 8 with Oracle 10g R2 Issue

2008-10-07 Thread Eric Roberts
We are using the thin client. I remember I had the same problem with this, but it was a code issue. Here is the code that I have that pulls both date and time from a date time field... I am not doing anything special in the query. Io4c_date is a date field that is coming from the query... #uca

Re: strange (lt) behaviour

2008-10-07 Thread Richard White
ok thanks adrian ill look into this some more richard >I'd guess it's a precision problem. Not sure what the fix would be. I'm >guessing that you'd run into similar problems with large integers. > >Adrian > >Building a DB of errors at http://cferror.org/ > >hi, > >i have a function that is passed

Re: float regex

2008-10-07 Thread Richard White
ok thanks tom will def do this thanks again for your help > On Tuesday 07 Oct 2008, Richard White wrote: > > i need it to validate the value based on the criteria: > > Err, right, so just return the result of rematch() ? You don't need > the actual > value itself. > Get a good regular expressi

Re: float regex

2008-10-07 Thread Tom Chiverton
On Tuesday 07 Oct 2008, Richard White wrote: > i need it to validate the value based on the criteria: Err, right, so just return the result of rematch() ? You don't need the actual value itself. Get a good regular expression editor - there are several online ones and I hear someone compiled kreg

Re: float regex

2008-10-07 Thread Richard White
> You mean once you've determined it's a valid string, you then want > that string > as a number ? > CF is typeless, so just use it as is. no, i mean i need to validate that the the value i pass in to that function is a valid float. e.g. 10.00 would pass but a2.00 would not pass: i need it to

Re: float regex

2008-10-07 Thread Tom Chiverton
On Tuesday 07 Oct 2008, Richard White wrote: > so i have changed it to the following but now it is throwing passing back a > value of 1, on the following regalar expression: > "^[\+|-]?[0-9][0-9]*(\.[0-9][0-9]*)$" You mean once you've determined it's a valid string, you then want that string as a

Re: float regex

2008-10-07 Thread Richard White
hi tom, i thought i needed to use the negative look ahead as otherwise it will pick up the first part that it does match but i want it to go through my entire value checking all values to see if they match, is this why it is getting stuck on 1? thanks > hi tom, yes thanks i didn't realise that

RE: strange (lt) behaviour

2008-10-07 Thread Adrian Lynch
I'd guess it's a precision problem. Not sure what the fix would be. I'm guessing that you'd run into similar problems with large integers. Adrian Building a DB of errors at http://cferror.org/ -Original Message- From: Richard White [mailto:[EMAIL PROTECTED] Sent: 07 October 2008 16:11 To

strange (lt) behaviour

2008-10-07 Thread Richard White
hi, i have a function that is passed a float value, a min float range, and a max float range and it compares whether the float is in the correct range and passes back true or an error: however, it all seems to work fine until i put in the following criteria: #

Re: float regex

2008-10-07 Thread Richard White
hi tom, yes thanks i didn't realise that!!! that is making it too complicated! so i have changed it to the following but now it is throwing passing back a value of 1, on the following regalar expression: "^[\+|-]?[0-9][0-9]*(\.[0-9][0-9]*)$" for the value 10.00 do you have any idea why it is d

Re: Export Cfgraph to excel

2008-10-07 Thread Tom Chiverton
On Tuesday 07 Oct 2008, krish P wrote: > Does any one know how to export cfgraph to excel? If you mean turn a query into a spread sheet, there are many query to CSV converters out there on Google, though we use Ben Nadel's POI based stuff to write actual .xls binary files. -- Tom Chiverton Hel

Re: float regex

2008-10-07 Thread Tom Chiverton
On Tuesday 07 Oct 2008, Richard White wrote: > i have used negative lookahead This makes things very complicated. > isnt part of the regular expression, and therefore have the following code > to test for an error: Why not use a simpler reg exp with out the look ahead (such as /[+-]?[0-9] [0-9]

float regex

2008-10-07 Thread Richard White
hi i am trying to create my own isValidFloat function using a regalar expression but it isnt behaving how i would like and cannot work out what the problem is: this is my float regaular expression i have used negative lookahead so that it will return me any point that isnt part of the regula

RE: Debugging Coldfusion and javascript

2008-10-07 Thread Jim Davis
> -Original Message- > From: Scott Stewart [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 07, 2008 8:03 AM > To: cf-talk > Subject: Re: Debugging Coldfusion and javascript > > Your only option, is Firebug, a plug in for Firefox. It's a great option but far from your only one. ;^) I s

Re: Invitation to Test OpenBD Linux Installer

2008-10-07 Thread Tom Chiverton
On Friday 03 Oct 2008, Jordan Michaels wrote: > The installer copies the mod_jk.so file to the Apache modules directory, > then "appends" the connector configuration information to the Apache > config file. Lots of distro's frown on this these days, I think, and expect a file to be dropped in to

Re: ColdFusion 8 with Oracle 10g R2 Issue

2008-10-07 Thread James Holmes
It depends on your Database setup - it might be best to ask your DBA. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/10/7 Boysie Tupaz <[EMAIL PROTECTED]> > > > Are you connecting to a shared or dedicated server process in Oracle? > Hmmm...I am not sure. How

Export Cfgraph to excel

2008-10-07 Thread krish P
Does any one know how to export cfgraph to excel? ~| 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.

Re: ColdFusion 8 with Oracle 10g R2 Issue

2008-10-07 Thread Boysie Tupaz
Are you running stored procedures or inline SQL? Both. Do you have maintain connections switched on for the datasources? Yes. Are you connecting to a shared or dedicated server process in Oracle? Hmmm...I am not sure. How can I check this? ~~~

Re: Debugging Coldfusion and javascript

2008-10-07 Thread Gerald Guido
Aptana has a debugger. Not really a CF tool per se but it is a great IDE for JS development. http://www.aptana.com/studio Debug bar for IE is pretty good http://www.my-debugbar.com/wiki/CompanionJS/HomePage + 1 billion for FireBug. It is an absolute God send. https://addons.mozilla.org/en-US/fire

Re: Handling a VO parsed from Flex to CF

2008-10-07 Thread Simon Bailey
Hi Tom, Ok I sussed it, I have discovered that arguments.aRecord.course_results[i] was not actually passing the Object, to be honest I have no idea what it was passing but whatever it was passing it was wrong. After some further debugging and dumping I have now found that the Object is re

Re: Debugging Coldfusion and javascript

2008-10-07 Thread Brian Kotek
Chrome actually has a pretty nice debugger within it, if you happen to be running Chrome. On Tue, Oct 7, 2008 at 8:02 AM, Scott Stewart <[EMAIL PROTECTED]>wrote: > Your only option, is Firebug, a plug in for Firefox. > > Anthony Doherty wrote: > > hi we are constantly using coldfusion with javasc

Re: Debugging Coldfusion and javascript

2008-10-07 Thread Scott Stewart
Your only option, is Firebug, a plug in for Firefox. Anthony Doherty wrote: > hi we are constantly using coldfusion with javascript and keep getting wierd > javascript error message when calling functions with cfc's. things like "an > object was expected" or my favourite "exception thrown but no

Re: Handling a VO parsed from Flex to CF

2008-10-07 Thread Tom Chiverton
On Tuesday 07 Oct 2008, Simon Bailey wrote: > Unable to invoke CFC - The value coldfusion.runtime.TemplateProxy > cannot be converted to a number. If you CFDUMP or debug just before the loop, what is the value of 'i', 'arguments.aRecord.course_results' and 'arguments.aRecord.course_results[i]' ?

Re: Processing variables from a Flash form?

2008-10-07 Thread Tom Chiverton
On Monday 06 Oct 2008, Mallory Woods wrote: > I am working with a flash developer who doesn't know that much about > ColdFusion He doesn't need to, just have him send a normal HTTP form POST. Your CFML page then sees stuff in the normal way. -- Tom Chiverton Helping to quickly strategize secon

Re: Handling a VO parsed from Flex to CF

2008-10-07 Thread Simon Bailey
Unable to invoke CFC - The value coldfusion.runtime.TemplateProxy cannot be converted to a number. However I am 100% that all the passed elements are of correct data types? Is this throwing the error up think i.e. aRecord is a VO and course_results is the array of VO's? #arguments.aRecord.

Re: ColdFusion 8 with Oracle 10g R2 Issue

2008-10-07 Thread Maureen Barger
I noticed differences when we moved as well. I am betting when you connected to non-RAC instances, you used the Oracle driver from the pulldown in the DSN section. When you connect to RAC instances, you have downloaded Oracle's thin client and are using Oracle jdbc string. You have 3 options in my

Re: ColdFusion 8 with Oracle 10g R2 Issue

2008-10-07 Thread James Holmes
Are you running stored procedures or inline SQL? Do you have maintain connections switched on for the datasources? Are you connecting to a shared or dedicated server process in Oracle? mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2008/10/7 Boysie Tupaz <[EMAI

Re: timestamp/date error from mySQL

2008-10-07 Thread Azadi Saryev
before you start pestering your host to modify the jdbc connection string, try this: SELECT customer_id, IF(ISNULL(STR_TO_DATE(LEFT(customer_dob, 10), '%Y-%m-%d')), 'Not Defined', customer_dob) AS dob FROM customer WHERE 1=1 hth Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Simon Baile

Re: timestamp/date error from mySQL

2008-10-07 Thread Mike Little
i have sent them an email to see if it something they have encountered before. i find it really weird though that i cannot have a null date/timestamp field being queried correctly?? i can achieve in both mssql and msaccess. (i am relatively new to mySQL if you have not guessed by the way!!) >

Re: timestamp/date error from mySQL

2008-10-07 Thread Simon Bailey
get them to do it, mine was also on a shared host :) On 7 Oct 2008, at 10:18, Mike Little wrote: zeroDateTimeBehavior - yes just saw this on the mysql forums. how do i action this though if i am using shared host? my datasource is setup by my host?? > http://www.nutrixinteractive.com/blog/?

Re: timestamp/date error from mySQL

2008-10-07 Thread Mike Little
zeroDateTimeBehavior - yes just saw this on the mysql forums. how do i action this though if i am using shared host? my datasource is setup by my host?? >http://www.nutrixinteractive.com/blog/?p=60 > >Check that out, I had a similar issue a while back and cracked it >using the technique I de

Re: timestamp/date error from mySQL

2008-10-07 Thread Mike Little
sorry my typo - it was IFNULL... >you should use IFNULL() instead of ISNULL(). i think that's what i >originally suggested, unless i made a typo... > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > > > >Mike Little wrote: >> ~

Re: timestamp/date error from mySQL

2008-10-07 Thread Azadi Saryev
you should use IFNULL() instead of ISNULL(). i think that's what i originally suggested, unless i made a typo... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mike Little wrote: > password="#variables.dbpassword#" username="#variables.dbusername#"> > SELECT customer.* > FROM customer >

Re: timestamp/date error from mySQL

2008-10-07 Thread Simon Bailey
http://www.nutrixinteractive.com/blog/?p=60 Check that out, I had a similar issue a while back and cracked it using the technique I details on that post. On 7 Oct 2008, at 04:08, Mike Little wrote: hi guys, i have a birthdate field in mySQL that is a date field (NULL). when querying the dat

Re: timestamp/date error from mySQL

2008-10-07 Thread Mike Little
SELECT customer.* FROM customer WHERE 1=1 also tried as a test... SELECT customer_id, ISNULL(customer_dob, 'Not Defined') AS dob FROM customer WHERE 1=1 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic

Re: timestamp/date error from mySQL

2008-10-07 Thread Azadi Saryev
it'll help to actually see your query Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mike Little wrote: > thanks guys, unfortunately i am getting the error... > > Cannot convert value '-00-00 00:00:00' from column 6 to TIMESTAMP. > > i have tried using the ISNULL in my query but t

RE: ReFind - finding too much :-(

2008-10-07 Thread Adrian Lynch
No probs. The [] are used to specify a set of characters. Your original version: [(0-9)4\-(0-9)2\-(0-9)2T(0-9)2:(0-9)2:(0-9)2] was saying look for any of: 0 to 9, 4, -, 0 to 9, 2, - etc. etc. Adrian Building a DB of errors at http://cferror.org/ -Original Message- From: AJ Mercer [mai

Re: timestamp/date error from mySQL

2008-10-07 Thread Mike Little
thanks guys, unfortunately i am getting the error... Cannot convert value '-00-00 00:00:00' from column 6 to TIMESTAMP. i have tried using the ISNULL in my query but to no avail. i basically wanted to make the date field optional for a record. mike

Re: ReFind - finding too much :-(

2008-10-07 Thread AJ Mercer
this is doing the trick Thanks for your assistance Adrian. On Tue, Oct 7, 2008 at 5:48 PM, AJ Mercer <[EMAIL PROTECTED]> wrote: > like this local.fieldValue)> > > or does it need the square brackets? > local.fieldValue)> > > > On Tue, Oct 7, 2008 at 5:40 PM, Adrian Lynch <[EMAIL PR

Re: ReFind - finding too much :-(

2008-10-07 Thread AJ Mercer
like this or does it need the square brackets? On Tue, Oct 7, 2008 at 5:40 PM, Adrian Lynch <[EMAIL PROTECTED]>wrote: > Does that date stamp exist in another string or on it's own? > > \d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2} > > Should do it but it won't stop invalid dates like > > 2008-99

RE: ReFind - finding too much :-(

2008-10-07 Thread Adrian Lynch
Does that date stamp exist in another string or on it's own? \d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2} Should do it but it won't stop invalid dates like 2008-99-99T99:99:99 Adrian Building a DB of errors at http://cferror.org/ -Original Message- From: AJ Mercer [mailto:[EMAIL PROTECTED] Sen

ReFind - finding too much :-(

2008-10-07 Thread AJ Mercer
I have a generic function that processes all sorts of data One in particular I want to identify and do a search and replace on sample data: 2008-10-07T16:21:17 I want to swap the T for a space But I only want to do it if the data is in this format I came up with this, but it is returning true

Re: Debugging Coldfusion and javascript

2008-10-07 Thread Azadi Saryev
what exactly do you mean by "when calling functions with cfc's"? which version of cf are you using? which OS? as for debugging tools, download and install FireBug extension for FF from addons.mozilla.org and then ColdFire from coldfire.riaforge.org. Azadi Saryev Sabai-dee.com http://www.sabai-dee

RE: Debugging Coldfusion and javascript

2008-10-07 Thread Adrian Lynch
If you don't get 10 more posts saying Firebug for Firefox I'd be highly suprised. Adrian Building a DB of errors at http://cferror.org/ -Original Message- From: Anthony Doherty [mailto:[EMAIL PROTECTED] Sent: 07 October 2008 09:01 To: cf-talk Subject: Debugging Coldfusion and javascript

Re: regex negative lookahead

2008-10-07 Thread Peter Boughton
>I'm not sure which regEx engine the example link uses, but the ColdFusion >regEx engine defines \w as matching alpha-numeric characters only. Well, most definitions of "alpha-numeric" include underscores. Anyway, run this: #i# #Chr(i)# You get much more than

Debugging Coldfusion and javascript

2008-10-07 Thread Anthony Doherty
hi we are constantly using coldfusion with javascript and keep getting wierd javascript error message when calling functions with cfc's. things like "an object was expected" or my favourite "exception thrown but not caught" (maybe adobe could give coldfusion a pair of gloves to help it catch the