Re: This is a good one - another Regex question

Thanks for your help Claude, it has really open my eyes to Regex. Not sure what it can't do as far as text manipulation goes :-) ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion

Re: How do I properly check for an empty string?

Janet, The problem is, it shouldn't even be *getting* to the second step - building the bad data query. I know I'm workin with a one row spreadsheet. How can 3 rows of empty strings get into the bad data query from that. It's likely some hidden ascii chars, but I haven't had time to test

Help with joins...

I have two tables. Animals - AnimalID AnimalNAME AnimalSEX Projects - ProjectID MaleID FemaleID Let's say Projects holds MaleID:1 and FemaleID:2 I need to write a query that joins these tables, and basically pulls back two sets of animal information per one record in the

Re: tricky sql to avoid loop

Hi Richard, this bit of SQL is a bit strange: WHERE PP.productID IN (cfqueryparam value=#productIDs# cfsqltype=cf_sql_integer list=true /) AND PP.productID 'cfqueryparam value=#i# cfsqltype=cf_sql_integer / Lets say your ids were 1,2,3,4,5,6. Translated in one step of the

Re: Installing Blog CFC

Hey Peter, I'm the author of BlogCFC. I wanted to address a few things. 1) I tried to make the docs as clear as possible, but if you find something not clear, please file a bug/enhancement request over at blogcfc.riaforge.org. 2) You don't have to know anything about CFCs to use BlogCFC. Now,

CF8 Error

I just installed CF8 to test with an application and received the error below, I've never seen this one before. Component cannot implement component. The com.jobscience.DataStruct ColdFusion component cannot implement the com.jobscience.Interface ColdFusion component. It can only implement

Re: Installing Blog CFC

Hello Raymond, I couldn't ask for better help than from the component's creator. I'll look at the documentation again and will contact you if I run in to problems. I see that the component includes a CAPTCHA. One enhancement I would suggest off-hand would be to permit one to use the

Re: CF8 Error

You have a CFC that is implementing another component. You can only implement an interface. On 7/21/07, Brian Peddle [EMAIL PROTECTED] wrote: I just installed CF8 to test with an application and received the error below, I've never seen this one before. Component cannot implement component.

Re: CF8 Error

7 didn't seem to care to I guess the rules tightened up in 8? Raymond Camden wrote: You have a CFC that is implementing another component. You can only implement an interface. On 7/21/07, Brian Peddle [EMAIL PROTECTED] wrote: I just installed CF8 to test with an application and received

Re: How do I properly check for an empty string?

The problem is, it shouldn't even be *getting* to the second step - building the bad data query. Yes, it should - if you consider there is difference between an empty and unmodified row. I suspect POI picks up rows that were modified, rather than rows that contain values. Can you imagine

Re: How do I properly check for an empty string?

cfif Len(instructorid) AND Len(lastname) AND Len(firstname) AND len(URL.EID) Add data to the db cfelse Build a query in cf memory of bad data /cfif Also your original logic says _all_ of the values must have a length 0. So if even one of those values is empty, it will always hit

Re: CF8 Error

This was CF7 code? What does your component look like? Does it have implements in the cfcomponent tag? If so, thats reserved now in CF8. On 7/21/07, Brian Peddle [EMAIL PROTECTED] wrote: 7 didn't seem to care to I guess the rules tightened up in 8? Raymond Camden wrote: You have a CFC that

Re: CF8 Error

There were no interfaces in CF7, so implementing was not an option. Cheers, Kris On 7/21/07, Brian Peddle [EMAIL PROTECTED] wrote: 7 didn't seem to care to I guess the rules tightened up in 8? ~| Upgrade to Adobe ColdFusion

Re: CF8 Error

But - you can put any attribute you want in a cfcomponent tag. So I could do this in CF7: cfcomponent implements=foo ray=1 that would work fine. CF7 would just ignore them (well, it doesn't ignore it, it adds them to the metadata). So he could have typed in a implements attribute and it would

Re: CF8 Error

Yes it was. This is the object that gets the error on the init. cfcomponent name=DataStruct implements=com.application.Interface hint=Data structure for passing and storing key/values cfproperty name=dataStruct type=struct default=structNew() cfset

Re: CF8 Error

I removed implements=com.application.Interface and it got past it. It didnt' like that. Brian Peddle wrote: Yes it was. This is the object that gets the error on the init. cfcomponent name=DataStruct implements=com.application.Interface hint=Data structure

Re: This is a good one - another Regex question

Not sure what it can't do as far as text manipulation goes Not really sure about something regexp can't do. The problem is generally to find the right one ;-) -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm

Re: Help with joins...

On 7/21/07, Crit wrote: Any suggestions? I am not even sure if this is the best way to setup the projects table.. so if it's not... let me know... I'd restructure your DB. Maybe use a join table instead? projectAnimals projectAnimalID projectID animalID Knowing nothing about what your

Re: CF8 Error

On 7/21/07, Brian Peddle [EMAIL PROTECTED] wrote: I removed implements=com.application.Interface and it got past it. It didnt' like that. Right, because in CF8 the implements= attribute on cfcomponent means something. -- Sean A Corfield -- (904) 302-SEAN An Architect's View --

mysql and media servers

Good evening everyone, I just finished creating the database and the DSN for Blog CFC. My first question is do I upload the mysql.sol to a folder on the server, or does this need to be imported in to the mysql Administrator to create the tables the Blog_CFC Database will use? I looked at the

Re: Help with joins...

I'm confused to your question. Based on the 2 tables you have listed, can you say what fields you want in the new table after the join? On 7/21/07, Mickael Pervinski [EMAIL PROTECTED] wrote: I have two tables. Animals - AnimalID AnimalNAME AnimalSEX Projects -

RE: CF8 Error

That is incorrect...MX7 (not sure about 6) had an implements attribute where you can have it implement another CFC. Eric -Original Message- From: Kris Jones [mailto:[EMAIL PROTECTED] Sent: Saturday, July 21, 2007 3:17 PM To: CF-Talk Subject: Re: CF8 Error There were no interfaces in

Re: Web Based Project Management Tool

Have you looked at our product, Vertabase Pro? www.vertabase.com Its a web-based project management application written in CF. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion

RE: CF8 Error

That is incorrect...MX7 (not sure about 6) had an implements attribute where you can have it implement another CFC. That's extends, not implements. Dave Watts, CTO, Fig Leaf Software This email has been processed by SmoothZap - www.smoothwall.net

General UI Question

I have a general question about how people are handling new records to select boxes. I mean if you have a form with a select box that displays values from a database but when the user is filling out the form they need to add a new record to that list. --Example-- Description: textbox Data:

RE: General UI Question

Normally, I take the easy route and write a separate tool to manage the companies where they can add/edit/delete the records that are displayed in the select. In the past, I've done a couple different things though. 1) Put a link next to the select that pops up a form to add new records to the

Re: General UI Question

I tend to just have a separate interface through their main menu that will let them add/edit/delete/update companies. I have on some projects had a button/link next to the select that when they clicked on would pop up with the form to add a company and once submitted it would go into the database