Re: What can PHP do that CF can't?

2007-10-22 Thread Eric Haskins
I second that Eric! What is useless to one is useful to others and it just bothers me when there is one or two complaints/trolls that had nothing to contribute. They just make sure they express their displeasure. Eric Haskins

RE: Coldfusion 8 Adminapi Datasource problem

2007-10-22 Thread Hareni Venkatramanan
Hi John, In the function myObj.setMSSQL(), the values of timeout and interval are specified in seconds ( pl. refer cf_root/CFIDE/adminapi/datasource.cfc for APIs), whereas in admin, the interval and timeout values are displayed in mins. Therefore, in your example (20/60) is rounded off to

Call For Papers: webDU 2008

2007-10-22 Thread Geoff Bowers
Call For Papers: webDU 2008 === GO: http://www.webdu.com.au/go/call-for-papers And so it begins -- the sixth Asia-Pacific web developers conference, web DownUnder 2008! * Website: http://www.webdu.com.au/ * Conference Dates: 7-9 May 2008 * Conference Venue: Star City,

Re: Boomsocket Alpha Trial

2007-10-22 Thread Geoff Bowers
On 20/10/2007, jonese [EMAIL PROTECTED] wrote: Our office takes any comments to heart. Good and Bad! I'm glad you brought it up and the conversation / sign-ups it's spawned. Hopefully we'll get others involved and we'll have that MySQL / PostgreSQL sooner rather then later! How does

Re: #$^% Forms!

2007-10-22 Thread Geoff Bowers
On 25/09/2007, Michael David [EMAIL PROTECTED] wrote: Ok, I admit it; I hate developing forms! There's not one part of the process that I find even remotely interesting, enlightening, or fulfilling. Forms suck. Now that I got that off of my chest, does anyone know of some nifty-cool

Re: CFADmin: datasource - connect to Access DB on network drive

2007-10-22 Thread Tom Chiverton
On Friday 19 Oct 2007, [EMAIL PROTECTED] wrote: I need to connect to an Access database on a netowkr drive and the drives that show up in the Java file tree are only local drives. Is there another way to connect to an Access DB on a network drive? Type the path by hand ? -- Tom Chiverton.

Re: parsing problem

2007-10-22 Thread Seamus Campbell
Hi - thanks for that. I changed it to rereplace(web_export,([^,]*),(.*)\n(.*)\n[ ](.*)\n,line:\1|\2|\3,ALL) But got this: line:Abbott| John E-mail Address(es): [EMAIL PROTECTED] Abrahams, Fred E-mail Address(es): [EMAIL PROTECTED] Adams, Kerin E-mail Address(es): [EMAIL PROTECTED] Allen, Norman

Re: parsing problem

2007-10-22 Thread Azadi Saryev
try this one: rereplace(web_export, (.[^,]*),[[:space:]]+(.[^\n]*)(.[^\n]*)[[:space:]]*(.[^\n]*), \1|\2|\4br, ALL) i used the br in replaced string to visually separate lines on screen. change it to \n or whatever you need to. cheers, Azadi -- Azadi Saryev Sabai-dee.com

RE: File disappears after cffile rename

2007-10-22 Thread Manju Kiran P Pacchhipulusu
Hi Michael, Apparently on CF8, if the cffile.serverfile name and the newly assigned name var are the same, the file will get deleted when it fires the cffile rename. I tried this simple code and wasn't able to reproduce this issue. cffile action=RENAME source=C:\temp1.txt

RE: Catching referring domain in CF?

2007-10-22 Thread Manju Kiran P Pacchhipulusu
Did you try dumping the CGI scope? CGI.HTTP_HOST would give you the domain name. Thanx -Manjukiran Adobe ColdFusion Team ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today

RE: #$^% Forms!

2007-10-22 Thread Peterson, Chris
Check out this, makes it really easy and purdy =) http://www.cfcode.net/index.cfm/2007/9/21/The-search-for-a-dropin-form-s tyle-thats-bootyfull Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer -Original Message- From: Geoff Bowers [mailto:[EMAIL PROTECTED] Sent:

Re: Coldfusion 8 Adminapi Datasource problem

2007-10-22 Thread Raymond Camden
This sounds like a bug in the admin then. If the back end supports 60 seconds, the admin should support it as well, right? On 10/22/07, Hareni Venkatramanan [EMAIL PROTECTED] wrote: Hi John, In the function myObj.setMSSQL(), the values of timeout and interval are specified in seconds (

RE: What can PHP do that CF can't?

2007-10-22 Thread Bobby Hartsfield
I have much more important things to complain about than something that may be off topic in a community. Apparently. ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Eric Roberts [mailto:[EMAIL PROTECTED] Sent: Monday, October

RE: cfimage generating a color pallette from an image

2007-10-22 Thread Andy Matthews
It sounds like you're wanting cfimage to generate a palette of every unique color in an image? That could offer up some cool possibilities. Let us know if you find anything like that. -Original Message- From: Matthew Friedman [mailto:[EMAIL PROTECTED] Sent: Sunday, October 21, 2007 10:50

RE: Anyone with ISAPI_rewrite experience?

2007-10-22 Thread Andy Matthews
I have no clue which version. Is there a way to check without having access to the OS? I tested it and it does work, but I have no clue what I'm doing. andy -Original Message- From: jonese [mailto:[EMAIL PROTECTED] Sent: Sunday, October 21, 2007 11:19 AM To: CF-Talk Subject: Re: Anyone

RE: Anyone with ISAPI_rewrite experience?

2007-10-22 Thread Andy Matthews
Eric... I guess what I want to do is to learn the basics. I've got a client site coming up soon that needs as much SEO help as it can get. My outputted HTML code is perfect, so I'm looking to improve links and meta data. What I'm looking to do is to turn cf pages into directories (and pass in

CFGRID row color

2007-10-22 Thread Asim Manzur
In the HTML CFGRID, is there a way to change the background color of a row dynamically? For example, if I had a list of tasks, I'd like to change the background color if the task is urgent... Urgent is a field in the query object returned by CFC ... Regards,

Re: Which query would be better?

2007-10-22 Thread Ben Doom
Offhand, I'd guess using the in syntax, if only because it makes your million-line query smaller. However, if you really want to know, write it each way, populate a db with a million rows of fake data, and time it. --BenD Will Tomlinson wrote: MySQL 5. Which would be the better choice

CFGRID row color

2007-10-22 Thread Asim .
In the HTML CFGRID, is there a way to change the background color of a row dynamically? For example, if I had a list of tasks, I'd like to change the background color if the task is urgent... Urgent is a field in the query object returned by CFC ... Regards,

Cflayout page return question

2007-10-22 Thread Eric Hoffman
We have a page that we are capturing data in using cflayout and it works wonderfully. Now our question is, I think I am missing something obvious? We want to submit the page and have it return to the tab we had open during the submission; alternately maybe another tab if we wanted them

Re: Which query would be better?

2007-10-22 Thread Dominic Watson
Also, regardless of the performance factors, I prefer the IN method as it is easier to upgrade. Dominic On 22/10/2007, Ben Doom [EMAIL PROTECTED] wrote: Offhand, I'd guess using the in syntax, if only because it makes your million-line query smaller. However, if you really want to know,

connection timeout/failure

2007-10-22 Thread Orlini, Robert
Is there anyway to hace CF send an email alert if a datasource connection does not respond within a certain amount of seconds? I have a query that loads an image from another server and I'm using a cfcatch, but it only reacts to a lost connection when the server fails. I would like it to

Re: Which query would be better?

2007-10-22 Thread Tom Chiverton
On Monday 22 Oct 2007, [EMAIL PROTECTED] wrote: Also, regardless of the performance factors, I prefer the IN method as it is easier to upgrade. Until one day you randomly hit the limit of things that can be in the IN clause. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows

RE: Which query would be better?

2007-10-22 Thread Robert Rawlins - Think Blue
Just as a note on performance, When thinking about using OR, you should consider splitting it into separate queries and using a UNION or UNION ALL to join them together. Rob -Original Message- From: Dominic Watson [mailto:[EMAIL PROTECTED] Sent: 22 October 2007 16:35 To: CF-Talk

Re: connection timeout/failure

2007-10-22 Thread Ian Skinner
I would think a combination of a timeout parameter on the query and cfcatch block for database exceptions around it should do the trick. ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active

Re: connection timeout/failure

2007-10-22 Thread Rick Root
cftry cfquery ... /cfquery cfcatch type=any cfmail ... cfabort (or cfthrow) or whatever) /cfcatch /cftry On 10/22/07, Orlini, Robert [EMAIL PROTECTED] wrote: Is there anyway to hace CF send an email alert if a datasource connection does not respond within a certain amount of

Re: connection timeout/failure

2007-10-22 Thread Tom Chiverton
On Monday 22 Oct 2007, [EMAIL PROTECTED] wrote: Is there anyway to hace CF send an email alert if a datasource connection does not respond within a certain amount of seconds? Scheduled task that checks seems the easiest way. -- Tom Chiverton. Are you a great ColdFusion programmer, who knows

Re: connection timeout/failure

2007-10-22 Thread Charlie Griefer
is the catch around the cfquery specifically? have you specified a type for the catch? On 10/22/07, Orlini, Robert [EMAIL PROTECTED] wrote: Is there anyway to hace CF send an email alert if a datasource connection does not respond within a certain amount of seconds? I have a query that

Re: Which query would be better?

2007-10-22 Thread Ben Doom
Which, according to the docs, is only limited by max_allowed_packet. The default is 1Mb, but it can be set arbitrarily up to the size of available RAM if that becomes a problem. --BenD Tom Chiverton wrote: On Monday 22 Oct 2007, [EMAIL PROTECTED] wrote: Also, regardless of the performance

UNZIP

2007-10-22 Thread Richard Colman
Can anyone recommend a tag for unzipping files programmatically? Rick Colman ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now

RE: connection timeout/failure

2007-10-22 Thread Orlini, Robert
yes to both. type is database. I would like it to alert via email when the connection is slow -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2007 12:01 PM To: CF-Talk Subject: Re: connection timeout/failure is the catch around the cfquery

RE: Which query would be better?

2007-10-22 Thread Dave Watts
Which, according to the docs, is only limited by max_allowed_packet. The default is 1Mb, but it can be set arbitrarily up to the size of available RAM if that becomes a problem. Databases generally have some limit on the number of items within an IN clause, which is completely separate from

Re: Which query would be better?

2007-10-22 Thread Dominic Watson
Until one day you randomly hit the limit of things that can be in the IN clause. Lol indeed, though I'd hate to see that SQL if it were multiple ORs ;) Dom ~| ColdFusion is delivering applications solutions at at top

Re: connection timeout/failure

2007-10-22 Thread Rick Root
I have a query that loads an image from another server and I'm using a cfcatch, but it only reacts to a lost connection when the server fails. I would like it to send an alert after a period of time when it does not connect using a cfquery. Sorry I think I misunderstood your question.

Re: connection timeout/failure

2007-10-22 Thread Charlie Griefer
ah... so just to clarify... you're not looking for an alert message/email on a connection/query failure... but when the connection/query succeeds and takes greater than (a specified period of time) to do so? On 10/22/07, Orlini, Robert [EMAIL PROTECTED] wrote: yes to both. type is database. I

Re: UNZIP

2007-10-22 Thread Ben Doom
cfzip? :-) --Ben Doom Richard Colman wrote: Can anyone recommend a tag for unzipping files programmatically? Rick Colman ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles

RE: Which query would be better?

2007-10-22 Thread Dave Francis
Ah, I see you remember Spectra :) -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2007 11:48 AM To: CF-Talk Subject: Re: Which query would be better? On Monday 22 Oct 2007, [EMAIL PROTECTED] wrote: Also, regardless of the performance factors,

Re: Which query would be better?

2007-10-22 Thread Ben Doom
I assumed there would be as well, but when I looked it up, that's what the docs for MySQL 5 said. Specifically, I dug around until I found the limit on the IN clause. It said it was limited by max_allowed_packet, which I then looked up. Hence, according to the docs. --Ben Doom Dave Watts

RE: connection timeout/failure

2007-10-22 Thread Orlini, Robert
Yes...by the time if fails its a bit too late -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2007 12:23 PM To: CF-Talk Subject: Re: connection timeout/failure ah... so just to clarify... you're not looking for an alert message/email on a

Re: Coldfusion 8 Adminapi Datasource problem

2007-10-22 Thread John Elkins
Thanks, Hareni. That was the problem. I should have paid more attention to the api values. It worked perfectly. Thanks also Ray for responding to my question. Regards, John Hi John, In the function myObj.setMSSQL(), the values of timeout and interval are specified in seconds ( pl.

RE: UNZIP

2007-10-22 Thread Brad Wood
Are you on CF8? -Original Message- From: Richard Colman [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2007 11:13 AM To: CF-Talk Subject: UNZIP Can anyone recommend a tag for unzipping files programmatically? Rick Colman

Re: UNZIP

2007-10-22 Thread Alan Rother
If you are using CFMX or better, there is a great custom tag on the cflib for it. It's basically a hundred line java function. It's wicked fast and works great. =] On 10/22/07, Ben Doom [EMAIL PROTECTED] wrote: cfzip? :-) --Ben Doom Richard Colman wrote: Can anyone recommend a tag for

RE: UNZIP

2007-10-22 Thread Richard Colman
DOH ... -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2007 9:29 AM To: CF-Talk Subject: Re: UNZIP cfzip? :-) --Ben Doom Richard Colman wrote: Can anyone recommend a tag for unzipping files programmatically? Rick Colman

Re: UNZIP

2007-10-22 Thread jonese
if you want the CFC route there is a great zip cfc on riaforge. http://zipcfc.riaforge.org/ jonese On 10/22/07, Richard Colman [EMAIL PROTECTED] wrote: Can anyone recommend a tag for unzipping files programmatically? Rick Colman

programmatically add functions to a CFC

2007-10-22 Thread Jonathon Stierman
Is it possible to programmatically add/update functions to an instantiated CFC? I've made one attempt to add one by calling the getMetaData function, but nothing I added to the meta data seemed to update the object's method list. Is there another way to go about doing this, or am I on the right

Re: Subversion appliance use attempt...

2007-10-22 Thread John Paul Ashenfelter
On 10/21/07, Rick Faircloth [EMAIL PROTECTED] wrote: Well... I've got TortoiseSVN installed and it seems to be working fine. I see the menu commands in Windows Explorer. I'm reading through the documentation now to figure out just what I'm supposed to do with this. Save yourself a *ton* of

Re: Subversion appliance use attempt...

2007-10-22 Thread John Paul Ashenfelter
On 10/22/07, John Paul Ashenfelter [EMAIL PROTECTED] wrote: On 10/21/07, Rick Faircloth [EMAIL PROTECTED] wrote: Well... I've got TortoiseSVN installed and it seems to be working fine. I see the menu commands in Windows Explorer. I'm reading through the documentation now to figure out

Re: programmatically add functions to a CFC

2007-10-22 Thread Dominic Watson
The meta data is just an interpretation of the component and not an interface to it. I'm not sure how you would achieve what you want, but that is definately not the right direction. Good luck, Dominic On 22/10/2007, Jonathon Stierman [EMAIL PROTECTED] wrote: Is it possible to

Re: programmatically add functions to a CFC

2007-10-22 Thread Jochem van Dieten
Jonathon Stierman wrote: Is it possible to programmatically add/update functions to an instantiated CFC? cffunction name=getX cfreturn variables.X /cffunction cfcomponent name=superSecret cfset variables.key = x /cfcomponent cfset obj = CreateObject(component, superSecret)

Re: programmatically add functions to a CFC

2007-10-22 Thread Nathan Strutz
Jonathon, You're on the right track, but it's much easier than that. Here's some play code I just whipped up: cfscript function getVariablesExternal() {return variables;} function methodToInject() {return This method was Injected;} myCFC = createObject(component,test).init(); // get

RE: Subversion appliance use attempt...

2007-10-22 Thread Rick Faircloth
Thanks for the tip, JP! Hope all goes well for you at CFUnited Express! Rick -Original Message- From: John Paul Ashenfelter [mailto:[EMAIL PROTECTED] Sent: Monday, October 22, 2007 1:51 PM To: CF-Talk Subject: Re: Subversion appliance use attempt... On 10/22/07, John Paul

Re: programmatically add functions to a CFC

2007-10-22 Thread henry ho
Look at some AOP framework for CF, and you'll find out. Coldspring - http://www.coldspringframework.org/ : From what I saw in the code, they use CFFILE to generate the cfm and CFINCLUDE it. They called it dynamic compilation -

Re: Boomsocket Alpha Trial

2007-10-22 Thread jonese
Geoff, You should be approved now. The group is closed so only those members who sign up can see it. Anyone else having an issue can email me directly and I'll force add them. how do we compare to FarCry? We'll besides the fact that both are CMS's i don't know if there is a lot of comparisons.

Re: Which query would be better?

2007-10-22 Thread Will Tomlinson
Thanks all! I went with the IN. :) Will ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive:

Re: programmatically add functions to a CFC

2007-10-22 Thread Dominic Watson
Nice On 22/10/2007, henry ho [EMAIL PROTECTED] wrote: Look at some AOP framework for CF, and you'll find out. Coldspring - http://www.coldspringframework.org/ : From what I saw in the code, they use CFFILE to generate the cfm and CFINCLUDE it. They called it dynamic compilation -

Have I found a CFFeed Bug?

2007-10-22 Thread Neil Middleton
I'm just doing a spot of feed-squirrel build work, and I think I've found a bug which I'm hoping someone else can verify (just to make sure I'm not losing it). Basically, if I CFFeed a URL that's valid RSS (for instance, http://samfarmer.instantspot.com/blog/rss.cfm?mode=full), I am getting the

Re: programmatically add functions to a CFC

2007-10-22 Thread Sean Corfield
Note that LightWire does not implement AOP so Peter's comparison is not entirely a fair one (and this is a common issue that crops up in comparisons between ColdSpring and LightWire - ColdSpring does a *lot* more than LightWire so it's pretty pointless trying to directly compare performance).

CFINVOKE wierdness

2007-10-22 Thread Bruce Sorge
So I am lazy and have been using CFINVOKE for my CFC's since DW has a nice drag and drop function for this. Lately, some of my CFINVOKE lines suddenly stopped working (they had been working for a few weeks prior). For instance, I have this: cfinvoke component=CFC.Schools

RE: Have I found a CFFeed Bug?

2007-10-22 Thread Jayesh Viradiya
HI Neiil, The link given by you works fine and I didn't see any error but an XML feed document. Is it that the case your browser is not able to parse it as a valid feed XML? I am using IE7 and didn't see any error. Jayesh Viradiya Adobe CF team -Original Message- From: Neil Middleton

RE: programmatically add functions to a CFC

2007-10-22 Thread Jonathon Stierman
That is the crucial key I needed! Much easier than what I had tried to do with the meta data too -- bonus! like a cfinclude file (even with a dynamic file name) from inside the CFC Is this to get around the inability to nest cffunction tags in CFC's? That's definitely a hurdle... any speculation

RE: programmatically add functions to a CFC

2007-10-22 Thread Jonathon Stierman
Peter's a smart guy! I'm a lurker of his blog -- very interesting stuff (and admittedly mostly over my head) on application generation, which is one of my favorite topics! I'll have to check out LightWire -- I hadn't heard of it before. Jonathon -Original Message- From: henry ho

Re: Have I found a CFFeed Bug?

2007-10-22 Thread Neil Middleton
The browser isn't the issue - it's when I wash the rss through CFfeed that problems appear. I'm trying to track down the issue - there's no guarantees it's a problem with CF, but I can't see where it's coming from. N On 10/22/07, Jayesh Viradiya [EMAIL PROTECTED] wrote: HI Neiil, The link

Re: Have I found a CFFeed Bug?

2007-10-22 Thread Raymond Camden
Worked for me on my Max box. On 10/22/07, Neil Middleton [EMAIL PROTECTED] wrote: I'm just doing a spot of feed-squirrel build work, and I think I've found a bug which I'm hoping someone else can verify (just to make sure I'm not losing it). Basically, if I CFFeed a URL that's valid RSS (for

Re: programmatically add functions to a CFC

2007-10-22 Thread Nathan Strutz
Jonathon, PHP guy eh? In CF there's no way to have a function in a function. Same with Java. Generally speaking, make another object. Or there's always passing functions as arguments. See, what it sounds like is you're coming at the problem backwards, however, that's not necessarily a bad thing.

RE: programmatically add functions to a CFC

2007-10-22 Thread Jonathon Stierman
More of just a plain newbie than a PHP-developer ;) Got hooked on CF straight out of the university (Hey, this is *way* easier than JSP's!) and been developing in relative isolation for the past two years. This mailing list alone has shown me the light more often than the Bible ;) Anyway, back

Re: programmatically add functions to a CFC

2007-10-22 Thread Nathan Strutz
Well hey, your project fits the bill afaik for needing a mix-in of some sort. I guess Transfer and Reactor didn't fit the bill? It sounds like those are similar projects. Anyways, yes, a cfinclude will do it for ya. -- nathan strutz http://www.dopefly.com/ On 10/22/07, Jonathon Stierman [EMAIL

RE: programmatically add functions to a CFC

2007-10-22 Thread Jonathon Stierman
I looked into both Transfer and Reactor, and while they're awesome for DAO, they don't really give me all I'm looking for (*entire* -- or at least most of it -- application generation). I have been referencing Transfer for ideas when building my own CFC's -- so there's definitely more than a

Re: programmatically add functions to a CFC

2007-10-22 Thread henry ho
ColdSpring looks for the set**() method for any dependencies, so I need to make sure that function exists in my CFC! So you want to write something that will parse your existing CFCs to make sure Coldspring's Auto-wiring work?

Re: programmatically add functions to a CFC

2007-10-22 Thread henry ho
btw, since you're into code generation, have you checked this out? Illudium PU-36 Code Generator http://cfcgenerator.riaforge.org/ Highly customizable, and you can make your own template. Use of ORM is optional. ~| Check

Re: #$^% Forms!

2007-10-22 Thread Mike Kear
Chris I took a look at that - I think it would be relatively straightforward to automate the generation of those snippets from a database table introspection or in a CMS too. Interesting stuff. Thanks for bringing it to our attention. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified

Re: programmatically add functions to a CFC

2007-10-22 Thread Mark Mandel
Jonathan, What is it that Transfer doesn't provide for you, that you need in your application generation? Figured I would ask the question, as I'm always looking for areas in which Transfer canbe improved. Mark On 10/23/07, Jonathon Stierman [EMAIL PROTECTED] wrote: I looked into both

Re: CFGRID row color

2007-10-22 Thread Azadi Saryev
check out this Ray's blog post: http://www.coldfusionjedi.com/index.cfm/2007/8/20/Custom-grid-renderers-with-CFGRID Azadi Asim . wrote: In the HTML CFGRID, is there a way to change the background color of a row dynamically? For example, if I had a list of tasks, I'd like to change the

coldfusion query problem

2007-10-22 Thread erik tom
I have a input box wher I am getting the value for my where clause. INstead I am getting the error Error converting the varchar value to a column of data type int cfquery name=infoNote datasource=X SELECT apr.reqid, apr.requirement,

Re: programmatically add functions to a CFC

2007-10-22 Thread Sean Corfield
On 10/22/07, Nathan Strutz [EMAIL PROTECTED] wrote: How about some functional programming? Closures! :) http://cfclosures.riaforge.org/ This lets you create functions on the fly - and of course it does it under the hood by writing to a file and including it... -- Sean A Corfield -- (904)

Re: coldfusion query problem

2007-10-22 Thread Azadi Saryev
why do you need to use cast? can't you just use cfqueryparam cfsqltype=cf_sql_integer value=#form.test#? -- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~| Check out the new features and enhancements in the latest

RE: coldfusion query problem

2007-10-22 Thread jake
Instead of cast('#form.test#' as int(4)) I'd try #val(form.test)# and a cfqueryparam would probably help the situation as well Original Message --- I have a input box wher I am getting the value for my where clause. INstead I am getting the error Error converting the

Re: parsing problem

2007-10-22 Thread Seamus Campbell
Thanks heaps Azadi that worked well Seamus ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now