Re: CFTicket

2007-12-28 Thread Cedric Villat
Michael, If you are installing the trial, it doesn't work on CF8 as-is. The reason is that it was compiled under CF7, and it seems as though CF7 compiled files don't play well with CF8. A few other customers also had this issue, and we have a special CF8 trial version at: http://www.cornfeed.c

OT: Application Layout/design

2007-10-23 Thread Cedric Villat
Sorry for the OT topic, but I'm looking for someone who can do css-based web application layout/design. This is just a small contract job. I'm looking for something a bit Web2.0'ish (I know that is very generic). If you can help, or have someone you can recommend, please email off-list. Cedric

HOF digests not working?

2007-07-26 Thread Cedric Villat
I haven't gotten any of the CF-Talk digests for the past 2 days or so. Michael, any changes you made to HOF that would affect the digests going out? Anyone else seeing this issue, or are others still receiving the digests? Cedric ~

Re: cfmail message-id

2007-07-07 Thread Cedric Villat
Russ, Check out the following thread: http://www.coldfusionjedi.com/forums/messages.cfm?threadid=59AD010D-0ABA-C3A1-C2B63D5FCB8E3077 Seems there is a workaround. I have not tried it myself though. Cedric >I'm trying to set the message-id for the mail that I'm sending out from our >cf server,

Re: Help Desk / Trouble Ticket recommendation?

2007-03-19 Thread Cedric Villat
between the requester and the system, and you can set fairly granular >permissions for each queue, so if it's a sensitive issue, you could put the >ticket into a restricted queue to limit who can see the requesters personal >info, and none of the people managing tickets ever has to hav

Re: Help Desk / Trouble Ticket recommendation?

2007-03-17 Thread Cedric Villat
Andrew, We make CFTicket, which is written in ColdFusion and is open source (not free, but affordable). You can see it at www.cornfeed.com. It sounds like it does what you want, but you can check it out as there is an online demo you can play with. Cedric > >Why would it have to be ColdFusi

Re: multiple email addresses in cfmail TO attribute.

2006-08-17 Thread Cedric Villat
Andy, I've always used semi-colons, but I think comma's are the proper way. The reason I use semi-colons is because email addresses can be in the form of: "Blow, Joe" <[EMAIL PROTECTED]> Outlook does this all the time, and if you used a comma, I think things may not work correctly if you use a

Digests?

2006-07-27 Thread Cedric Villat
I haven't gotten the hourly digest of CF-Talk in the past day or two. Are other people getting the digest on schedule? Cedric ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion

Re: Changes to files not taking effect

2006-06-27 Thread Cedric Villat
So after a lot of googling and testing on my computer, I figured out the problem. It was my copy of ZoneAlarm which was updated and had a bug: http://download.zonelabs.com/bin/free/information/zap/releaseHistory.html#6.5.722.000 Apparently, it was preventing the Date Modified from being updated

Re: Changes to files not taking effect

2006-06-26 Thread Cedric Villat
on >control instead of working on a mapped drive, as an aside. > >Welp, if anything springs to mind, I'll holler, nutt'n so far really though. > >Force be with you, >:DeN > >On 6/26/06, Cedric Villat <[EMAIL PROTECTED]> wrote: >>

Re: Changes to files not taking effect

2006-06-26 Thread Cedric Villat
Well, I've had some luck in figuring this out. It seems that when I update the file on the mapped drive from my local computer with either Homesite or Eclipse, the actual timestamp for the file does not get updated, but the file contents are updated. I assume this is not triggering a File Change

Re: Changes to files not taking effect

2006-06-26 Thread Cedric Villat
Anyone? I've narrowed the problem down a bit. It is very similar to this thread from a couple weeks ago: http://www.houseoffusion.com/cf_lists/messages.cfm/forumid:4/threadid:46408#243849 . Basically, if I edit the file remotely from my machine and save it on the server (via a mapped drive), t

Changes to files not taking effect

2006-06-24 Thread Cedric Villat
Hey everyone. On my development server, all of a sudden when I make a change to a file and save it, the changes are not reflected unless I stop and restart the ColdFusion service. I don't have trusted cache enabled, nor do I have Save Class files checked. I have tried different web browsers, di

Re: Regular Expressions - Strip HTML tags. Please help!!!

2006-04-13 Thread Cedric Villat
CFLib.org is your friend :) Check out the function called StripTags. It does exactly what you want. http://www.cflib.org/udf.cfm?ID=774 Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:237707 Archives: http://

Re: StripHtml function that allows some tags

2006-03-03 Thread Cedric Villat
Go look for a function called StripTags. It will do exactly what you want. You can either pass it a list of tags you want to keep, or to strip. It works great! Cedric ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:2

Re: cfchart problem

2006-02-28 Thread Cedric Villat
So it looks like the problem was because I had the rotated="true" attribute in the chart, and this was removed in CFMX7. Since the height was my previous width, the chart didn't show up. Does anyone know how I can get my bar chart to rotate 90% in CFMX7? I'm looking for a solution that works in

cfchart problem

2006-02-28 Thread Cedric Villat
I am seeing some problems with on CFMX7. I have a bar chart that shows up fine in CFMX6.1, but doesn't work in CFMX7. Here is my code: The Queues query looks like: QueueName TicketCount TestQueue8 The chart just doesn't show up in CFMX7.1. The correct

Re: [OT] Future CF Features

2006-02-14 Thread Cedric Villat
Adrian, I made a custom tag called cf_param that does exactly this. If the type of the variable does not match, such as your case, the default value is used. You can get the custom tag at http://www.cornfeed.com. It is a couple years old, but works just fine, as I use it all over the place. Ce

Re: Strip HTML and display

2006-01-30 Thread Cedric Villat
My desired output didn't show up quite right. Anyway, I'm not trying to get rid of CR's after tags. Basically, this text has already been wrapped at some length (65 chars). The problem is it was wrapped text was wrapped while taking into account the HTML. I'm trying to "unwrap" the text, then r

Re: Losing session vars

2005-11-14 Thread Cedric Villat
Thanks for the tip. I ended up using the Web Developer extension to just delete the session/domain cookies, then retried everything and it worked as expected. Thanks! Cedric >Tha should do it. > Any yes, you should be able to just dump the cookies, or if you have >firefox installed you can get

Re: Losing session vars

2005-11-14 Thread Cedric Villat
Alan, I have the setdomaincookies set to Yes, and even restarted the server in hopes it would take affect. Do I need to set this in conjunction with something else? I suppose I can dump the cookie for both www.mysite.com and secure.mysite.com and make sure that the cfid/cftoken are the same.

Re: Losing session vars

2005-11-14 Thread Cedric Villat
Tom, How would I go about checking that? Cedric >On Monday 14 November 2005 01:20, Cedric Villat wrote: >> their cart, etc. Short of adding the CFID and CFTOKEN to every link on the >> site, is there a way around this? I already have setDomainCookies set in my >> cfapp

Losing session vars

2005-11-13 Thread Cedric Villat
Hey all. I'm having an issue where visitors to my site are losing their session variables when I transfer them from www.mysite.com to secure.mysite.com. Basically, all of the session vars are lost, including the fact that they are logged in, items in their cart, etc. Short

Re: OT: text editor that allow a tab

2005-11-11 Thread Cedric Villat
How about inserting some code behind the scenes yourself? For example, when they hit the tab key (you can use javascript to catch the tab key), insert the code and then afterwards replacing each span with the tab id with a real tab? I assume these people are submitting the form to make sur

Re: Trouble Ticket Application

2005-10-24 Thread Cedric Villat
Chris, While not free, we sell CFTicket. It's a trouble ticket/help desk program. We offer a discount for non-profit organizations too. It is completely written in CF and is open-source. You can see a list of features and try out a demo if you want at www.cornfeed.com. Feel free to email me of

Re: Credit Card processing

2005-10-17 Thread Cedric Villat
John, You are paying less than that for both a gateway as well as a merchant account? If so, I'd be really interested in that deal, as that is by far the best I have seen so far. Cedric >That's very high. I'm at Max right now so I don't have it in front of me but >I can email exact pricing whe

Re: Credit Card processing

2005-10-17 Thread Cedric Villat
this part of our web >site and the processing will be done with ColdFusion. > >M!ke > >-Original Message- >From: Cedric Villat [mailto:[EMAIL PROTECTED] >Sent: Monday, October 17, 2005 5:18 PM >To: CF-Talk >Subject: Credit Card processing > >I'm looki

Credit Card processing

2005-10-17 Thread Cedric Villat
I'm looking for a credit card processing company. I know many of you have different companies, so I want to know what you use. The volume of sales for the site is fairly low (2-3 transactions per month). Anyone out there just charge a % of each transaction, vs. paying a monthly service fee + %

Re: CFPOP errors

2005-09-28 Thread Cedric Villat
Paul, I thought I was locking, but I just checked and it was commented out. Doh. I'll see if adding it back makes the RemovedException error go away. Any ideas on the encoding issue? Is there something to test with or debug on this one? Cedric >Are you using CFLOCK to make each account access

CFPOP errors

2005-09-28 Thread Cedric Villat
I am getting some errors when using CFPOP to retrieve email. The errors seem to happen even when I only get the headers. The errors are like: javax.mail.MessageRemovedException. or sun.io.ByteToCharBig5.getIndex1()[S I tried wrapping the CFPOP in a try/catch block in an attempt to find which

Re: OT: Mail server

2005-09-19 Thread Cedric Villat
irst place? > >Russ > >-Original Message- >From: Alan Rother [mailto:[EMAIL PROTECTED] >Sent: Monday, September 19, 2005 7:29 PM >To: CF-Talk >Subject: Re: OT: Mail server > >Smartermail. > http://www.smartertools.com/Products/SmarterMail/Default.aspx > It&#

OT: Mail server

2005-09-19 Thread Cedric Villat
What do you guys recommend as a good Windows-based mail server? Preferably open-source, but paid solution will work too. I checked on sourceforge, but really didn't have much luck finding a Windows server. I just need a basic mail server, that allows for multiple users and webmail, at a minimum.

Re: Mail Management Program

2005-09-12 Thread Cedric Villat
Rey, This sounds very similar to our product CFTicket. It has threading, keeps history of customer contacts, allows you to reply/delete/forward all emails from the server, etc. You can take a look at it at http://www.cornfeed.com. There is an online demo that you can try, as well as a trial

cfmail not sending messages

2005-08-31 Thread Cedric Villat
My server is acting strangely today. Whenever I use cfmail to send out some mail, it goes to the spool folder, but sits there for about 1 minutes and then goes to the undeliverable folder. I looked at the CF mail logs, and it showed that an error occured, but the reason for the error was blank

Re: Paging through records

2005-08-31 Thread Cedric Villat
Isaac, This won't work either, because it is possible that some of the ID's between 2 and 52 did not match your original WHERE clause in the first query. Say qry1.id[1] was 2 and qry1.id[50] was 10,000. Then in your second query, you are pulling almost 10,000 records, instead of the 50 that you

Re: Paging through records

2005-08-31 Thread Cedric Villat
Dave, This approach doesn't work if you have gaps in your keys, such as after you delete a row. For example, in my case, if your ID's were 1, 51, 101, etc. It would return the first 50 entries, regardless of what their ID's were. In your case, the COUNT doesn't tell you the ID's of the records

Re: Paging through records

2005-08-30 Thread Cedric Villat
What I do, and it seems to scale pretty well, is to run 2 queries. The first query simply pulls the ID's of the matching rows, and the second query pulls all of the data only for the ID's that were queried in the first query. Example: You want to get results 51-100 of your query: SELECT ID

Re: OT: Announce: Blogs onTap 2.0 Beta Released

2005-08-18 Thread Cedric Villat
Isaac, The actual download link returns a 404 error. Cedric >Hi all, > >After slightly more than a week of work I've published the first >release of Blogs onTap 2.0 Beta and would be grateful for any feedback >anyone would like to offer. I would like to get some comparison with >the other free b

Re: CFC's and limiting DB queries

2005-06-09 Thread Cedric Villat
Barney, This is pretty much what I was wanting to do. I think your first post was the most helpful. I suppose I will implement it right now so that all Person objects are initialized when the getTeamMembers method is called. If/when the bottleneck arises, it shouldn't be much more difficult to

CFC's and limiting DB queries

2005-06-09 Thread Cedric Villat
There was a post last week about limiting db queries when using CFC's that return array's of objects, or something to that affect. My question is, how feasible is this? For example, if I have a Team CFC, which has a method of getTeamMembers(). I want this method to return of Person objects. I c

Re: CF Tag for Next and Previous searching (like Google)

2005-05-23 Thread Cedric Villat
I made one quite a while back called CF_PageList. It behaves in much the same way as google by moving through the records and pages. You can see it in action and download it at http://www.cornfeed.com. Cedric > Subject: CF Tag for Next and Previous searching (like Google) > From: Stuart Kidd <[

Re: Case-sensitive Struct keys

2005-02-22 Thread Cedric Villat
Dave, Any ideas on how to do this? The reason I originally did it in a struct, was I could simply find the properties of a word, since it was the key. If I organize the data as an array of structs and have the word value be a key in my struct, wouldn't that require more overhead when searching

Re: Case-sensitive Struct keys

2005-02-21 Thread Cedric Villat
lues get overwritten. Vince's hashtable is really what I'm after. I guess either I can use the java hashtable as the solution, or do as Issac suggested and hash() the key names myself. Cedric >> From: Cedric Villat [mailto:[EMAIL PROTECTED] > >Why would you want to do this? Keys/

Case-sensitive Struct keys

2005-02-21 Thread Cedric Villat
So I guess CF doesn't support case-sensitive keys in a structure. For example, given the following code: test = StructNew(); test.a = 5; test.A = 10; I would have hoped that 2 keys would have been made, "a" and "A", but instead only 1 key is made, and has a value of 10. Is there anyway to have

Re: RegEx help - Solved

2005-02-21 Thread Cedric Villat
> > Not tested, YMMV, there are a lot of parens and it wouldn't surprise > > > me > > if I'm off somewhere, etc. But the basic idea is to check for > either > > a > > non-number before or after the dot. > > > > --B

Re: RegEx help

2005-02-21 Thread Cedric Villat
uot;\1\2", "all"); > > Not tested, YMMV, there are a lot of parens and it wouldn't surprise > me > if I'm off somewhere, etc. But the basic idea is to check for either > a > non-number before or after the dot. > > --Ben > > Cedric Villat w

Re: RegEx help

2005-02-21 Thread Cedric Villat
Pete, Thanks, that was the way I thought I would have to go. Just was hoping there was an easier way :) I'd still like to see if it can be done in 1 *line* :) Thanks. Cedric >Cedric Villat wrote: > > >I don't think there's any sane way to do this with a single POSI

Re: RegEx help

2005-02-21 Thread Cedric Villat
immediate characters around the period are not important. Thanks, Cedric >What about 10.24? Would that have the full stop(period) removed? > >Ade > >-Original Message- >From: Cedric Villat [mailto:[EMAIL PROTECTED] >Sent: 21 February 2005 01:15 >To: CF-Talk >S

RegEx help

2005-02-20 Thread Cedric Villat
I'm trying to create a regex that does the following, with little luck so far. I want to remove all periods ( . ) that do not appear between 2 numbers. For instance, I would want to keep this period: 5.5 But not these: www.domain.com I want the periods to be replaces with a space in the seco

Re: form action to CFC problems

2005-02-17 Thread Cedric Villat
I tried that originally, but then the CFC complained about not being able to find the other form fields. Strange but true :-/ Cedric >I would switch it back to post and just add ?method=methodName to the action >url. > >Example: > >CFC: bookstore >Method: getBook() > > > > >Mike ~~~

Re: form action to CFC problems

2005-02-17 Thread Cedric Villat
Michael, I changed the form method from "post" to "get" so that it passed the form fields via the URL and magically it started working. What is interesting is that I am still running this site on 6.1, but CFMX7 is installed on that machine on the built-in webserver. Does it make sense that the

form action to CFC problems

2005-02-17 Thread Cedric Villat
Something strange has just happened. I have a form where the action points directly to a CFC. This was working great until today. Now when I submit the form, the page gets redirected to the Component Browser Login page. The only thing I can think of is that I installed CFMX7. Has anyone seen thi

Re: CFTicket?

2005-02-17 Thread Cedric Villat
Rick, Sorry about our site being down. It should (hopefully) be up by the end of the week. If you have any questions or want me to setup a personal demo for you until the real demo comes back online, just let me know. Also, you should be able to log support calls by creating tickets manually fr

SQL - LIKE vs. =

2005-02-16 Thread Cedric Villat
Ok, so I'm seeing something interesting. I have a field in my MSSQL which is of type TEXT. I have a query that looks like: SELECT ThreadID FROM Threads WHERE Header LIKE This query will return 0 results. Now if I change the field in the DB to be of type VARCHAR and do something like: SELEC

Re: Sourceless deployment = EAR/WAR?

2005-02-12 Thread Cedric Villat
sion_Documentation&file=1762.htm#117147 > > > On Sat, 12 Feb 2005 17:03:31 -0800, Cedric Villat <[EMAIL PROTECTED] > com> wrote: > > Am I right to assume that when I hear abour sourceless deployment in > CFMX7, > > that that really means creating a EAR

Sourceless deployment = EAR/WAR?

2005-02-12 Thread Cedric Villat
Am I right to assume that when I hear abour sourceless deployment in CFMX7, that that really means creating a EAR/WAR package? The thing is I find it overkill to distribute an application with basically a fully functional CFAdmin, etc. Is there just a way to create a sourceless package that peop

Admin - Digest messages

2005-02-08 Thread Cedric Villat
Michael, I haven't gotten any digest posts since yesterday. Anyone else not getting the digest posts? Cedric ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com

Re: query paging UDF or CFC

2005-01-31 Thread Cedric Villat
I made one called CF_PageList which creates the Next/Previous links and the pages very much like Google. It'll move the page range as you go through the links. Check out www.cornfeed.com for a demo and the download. Thanks, Cedric >Hi, > >I usually add my custom code to CFML templates that retu

Not getting digest - Admin help

2005-01-12 Thread Cedric Villat
Anyone else not getting the Digest messages? I haven't gotten any of the digest posts today or yesterday. I logged in earlier and tried to update my subscription and it saved, but I still haven't gotten anything. I need my CF-Talk fix :) Thanks. Cedric ~

Re: Directory where Application.cfm resides

2004-11-28 Thread Cedric Villat
Wow, that was too easy. I could have sworn I tried that function :) Thanks Sean. Cedric >On Sun, 28 Nov 2004 18:33:11 -0800, Cedric Villat <[EMAIL PROTECTED]> wrote: >> In my Application.cfm file, before the cfapplication tag is defined, I'm >> trying to get the

Directory where Application.cfm resides

2004-11-28 Thread Cedric Villat
In my Application.cfm file, before the cfapplication tag is defined, I'm trying to get the absolute path of where the Application.cfm file sits. So far I've tried GetBaseTemplatePath, ExpandPath("."), and a few other tags to get the directory path. I can seem to get the right directory if the ca

Re: Name can't be empty error?

2004-10-07 Thread Cedric Villat
Bingo, that was it. Now to figure out *why* it became blank. Thanks Raymond. Cedric >It normally means the value you are using for datasource is empty. Ie, > >cfquery name="foo" datasource="#dsn#" > >and dsn is an empty string. > > >On Thu, 07 Oc

Re: Name can't be empty error?

2004-10-07 Thread Cedric Villat
Here is the function that the error is thrown in: <--- ERROR HAPPENS HERE EVEN IF I PUT A HERE. SELECT UserID AS ID, FirstName, LastName FROM #_application.config.TABLEPREFIX#SecurityUsers WHERE Username = AND Password = another query here. Only Username and a

Name can't be empty error?

2004-10-07 Thread Cedric Villat
This error has just popped up on a clients machine. They rebooted, and now when logging into their app, they get the following error: name can't be empty The error points to a query inside of a CFC. Though I noticed that if I put a right AFTER the arguments are defined but before the query, the

Re: Changing text in undelivrable .cfmail file and resending

2004-10-06 Thread Cedric Villat
ement. Cedric Villat http://www.cornfeed.com >Hello all, > >About 1000 emails (.cfmail) are sitting in my Undelivr folder because >I've got the wrong mail server set. With a simple change on the 2nd line >of every .CFMail file, these email files would be OK. Using code fro

Re: Coldfusion Helpdesk

2004-09-16 Thread Cedric Villat
Brant, We make a ColdFusion help desk called CFTicket. You can find out more about it at www.cornfeed.com. This is the second version we have released and should support most features you can think of. There is a demo on there too so you can play with it and see if it suits your needs. If you

Re: CFPOP streamlining

2004-06-21 Thread Cedric Villat
the offending email some other way. Due to this bug, all of our CFPOP apps now describe your method of retrieving the headers, and then downloading each piece of email one at a time. Cedric Villat http://www.cornfeed.com Creators of CFTicket - A customer support, trouble ticket application >

Re: Difficult SQL Question

2004-06-02 Thread Cedric Villat
;   AND Value = 'Hello' > ) > > I didn't want to type to much, so there are some modifications you > should make to the code: > - Use everywhere > - Don't use SELECT * but specify the columns you want > - In the group by example COUNT() has to be the number of

Difficult SQL Question

2004-06-01 Thread Cedric Villat
Ok, I have a bit of a problem with some SQL I'm trying to build. I have a table of Tickets, and then a table with a list of "fields" that are associated with tickets. Here are some values for the "fields" table: TicketID   FieldID   Value 1   1 Hello 1   2  

Remove multiple carriage returns

2004-05-27 Thread Cedric Villat
I have some text that I need to remove multiple line breaks from. For example, if my original text is like this: > Hello > My text > goes here I want the text to be replaced with > Hello > My text > goes here Basically I want to clean it up so there are no blank lines. Is there a simple regex

Re: Help Desk Software

2004-05-11 Thread Cedric Villat
Jeff, As Bruce said, CFTicket may fit your needs. You can see a demo of our new version at http://www.cornfeed.com. The demo should be fully functional for you to try. If you have any questions about the demo or the program itself, feel free to email me directly. Cedric Villat > Subject:

CFTicket 2 released

2004-05-10 Thread Cedric Villat
Just wanted to let everyone know that we have released CFTicket 2. I want to thank everyone on the list who helped us out in the beta testing. Because of all the great people, I am giving 20% off the current price as a thank you to everyone here. You can get more details at http://www.cornfeed.com

Re: Softball/Baseball db app? (Maybe OT)

2004-04-20 Thread Cedric Villat
Chris, I actually just finished doing something like this. It allows for different divisions (age groups) and then teams in every division. You can create divisions, teams, and then create games for those teams. You can re-schedule games, have field information, etc. It will also calculate standin

Re: CF-Talk: Digest every hour

2004-04-20 Thread Cedric Villat
Chris, I actually just finished doing something like this. It allows for different divisions (age groups) and then teams in every division. You can create divisions, teams, and then create games for those teams. You can re-schedule games, have field information, etc. It will also calculate standin

Re: Loops in Loops (let's go loopy)

2004-03-11 Thread Cedric Villat
Stuart, I made a custom tag a while back that did just this. Check out http://www.cornfeed.com/index.cfm?p=products&n=cfpagelist for a quick demo and a free download. Cedric Villat > Subject: Loops in Loops (let's go loopy) > From: "Stuart Kidd" <[EMAIL PROTECTED]&

Parsing HTML Email

2004-02-26 Thread Cedric Villat
So I'm using CFPOP to retrieve email messages and I'm storing the HTML version of the emails in the database. I'm then parsing the email on display, but I want to remove any sort of HTML formatting. I've tried 2 methods, and neither seem bulletproof. First try, I remove all HTML tags from the mess

OT: CFTicket 2.0 Beta Test

2004-02-25 Thread Cedric Villat
Hey Folks, We just released the first beta of CFTicket 2.0. For those who don't know, CFTicket is a customer support, trouble ticket application. This new version uses CFC's and therefore requires CFMX. We are having an open beta test for anyone who wishes to test. Just download, install, and pre

Re:Getting rid of subquery

2004-01-30 Thread Cedric Villat
group by statusName > >Steve > > >-----Original Message- >From: Cedric Villat [mailto:[EMAIL PROTECTED] >Sent: Friday, January 30, 2004 3:58 PM >To: CF-Talk >Subject: Getting rid of subquery > > >Can anyone help me with getting rid of this subquery? > > >SEL

Getting rid of subquery

2004-01-30 Thread Cedric Villat
Can anyone help me with getting rid of this subquery? SELECT  Count(t.Status) AS Count, StatusName FROM  TicketStatus s LEFT OUTER JOIN  (SELECT Status   FROM Tickets t   WHERE t.Owner = 2) t  ON t.Status = s.StatusID GROUP BY StatusName Right now, all of the StatusNames are

Odd cffile behavior

2004-01-16 Thread Cedric Villat
I'm using cfpop to check mail and download attachments. I'm saving the attachments cfpop gives me to the GetTempDirectory() value. I'm then trying to use cffile to move the file where I need it to be. The problem is that I keep getting this error:   Attribute validation error for tag CFFILE.  

Re: Session Variables Erroneously Timing Out

2004-01-02 Thread Cedric Villat
I had the same problem with disappearing session vars. Not sure if this applies to you or not, but I had this same thing happen to me when I had an tag with a blank src. Like: As soon as I put something in the src, my disappearing session variables went away. This may have been 6.0 only, not su

Re:Select Multiple and GET forms

2003-12-22 Thread Cedric Villat
ase > you were looking for that *one more* reason to upgrade)  : ) > > charlie >    > - Original Message -    > From: Cedric Villat    > To: CF-Talk    > Sent: Monday, December 22, 2003 3:06 PM    > Subject: Re: Select Multiple and GET forms > >    >

Re: Select Multiple and GET forms

2003-12-22 Thread Cedric Villat
nston ACT 2609 > > Tel: (02) 62115927 > > >         >   > "Cedric Villat"   >   

Re: Select Multiple and GET forms

2003-12-22 Thread Cedric Villat
nston ACT 2609 > > Tel: (02) 62115927 > > >         >   > "Cedric Villat"   >   

Select Multiple and GET forms

2003-12-22 Thread Cedric Villat
I have a form with a select box that can have multiple selected. The form method is GET. What is happening is if my select box looks like this: Pizza Burger Salad If I select Pizza and Burger and submit the form, the url has the following: foods=Pizza&foods=Burger If I try and then use #url.f

Re: SQL Server 2000 and Pagination

2003-12-22 Thread Cedric Villat
Calvin, I use a combination of 2 queries, which are VERY fast. SELECT t.TicketID   FROM Tickets t   WHERE 1 = 1 AND whateverelse then SELECT t.TicketID, etc. FROM Tickets t WHERE 1=1 AND same whatever else from above AND t.TicketID > #ID["TicketID"][Start]# AND    

Selecting consecutive records

2003-12-11 Thread Cedric Villat
In MySQL there is a LIMIT function when selecting records. This allows for an beginning row and then to select the next N rows. Is there an equivalent function for MSSQL or Access? It LIMIT a standard SQL function? If not, what is the best way to select, say 10 rows from the middle of a set of reco

Re:CFTicket

2003-12-05 Thread Cedric Villat
Stas, To address Tom's comments, CFTicket does not support attachments. We are working on version 2.0 right now which will allow both the sending and receiving of attachments. If you have any questions or concerns, feel free to contact me off-list. Cedric >I am looking for a trouble-ticket/cust

Re: JOIN help

2003-11-16 Thread Cedric Villat
Jochem, Thanks, that worked like a champ. I had a solution using 2 queries, but that wasn't really elegant. This should be much better. Thanks! Cedric > Subject: JOIN help > From: Jochem van Dieten <[EMAIL PROTECTED]> > Date: Sun, 16 Nov 2003 13:53:17 +0100 > Thread: http://www.houseoffusion.com

Re:JOIN help

2003-11-15 Thread Cedric Villat
No such luck. I had tried that earlier, but tried again just to make sure. A left and right join just return 1 row: UserID QueueID    AccessID 2  1  0 I never get the NULL row. Any more ideas? Cedric >A left outer join? > > -Oorspronkelijk bericht- >

JOIN help

2003-11-14 Thread Cedric Villat
Ok, I need some help with a join. I'm close to what I need, but its not exactly there. I have some a table called Queues which is basically an account. Then I have a Users table with my users. I then have a third table which allows for Users and Queues to be linked together. Here are sample tables:

SQL Help

2003-10-22 Thread Cedric Villat
I have a database where the day, month, and year are stored as ints. When I select these 3 columns, I want to make them into a date. Something along these lines: SELECT (m_day, m_month, m_year) AS m_date FROM myTable Obviously that doesn't work, but is there a way to concatenate the 3 ints to cre

Re: Legal?

2003-10-08 Thread Cedric Villat
Well, the domain name HE owns. He has since transferred it to a different host. The website I designed was actually online for a while, but he didn't pay the host so he was canceled. So all that I did was design the site, for free, provided I run the site. He is now threatening to sue me, but who k

OT: Legal?

2003-10-08 Thread Cedric Villat
Ok, a client of mine has gone nuts. He is an agent for a few celebrities, and I had offered to create a site for one of his clients free-of-charge provided I was the one running the site. He has now decided to go to another designer, and wants me to give him the site, which as I said he has not pai

Re:Multilingual site?

2003-09-23 Thread Cedric Villat
Paul, What is a resource bundle? I'm not familiar with them. Also, what is the best way to store all the strings needed to display for a particular language? Should I use a separate table for each language, or just flat text files (I would assume no, since accents and whatnot may not work)? Any

Multilingual site?

2003-09-23 Thread Cedric Villat
Ok, so I need to make a site that supports multiple languages. This means that the db information can be entered in English or French in my case. What do I need to do so that accents and whatnot are stored and displayed correctly? Also, I want to keep all the strings used to describe things on the

SOT: Homesite+ docs problem

2003-09-22 Thread Cedric Villat
So I completely re-did my machine this weekend. After reinstalling Homesite+ and updating to 5.2, my Homesite docs are all plain text. For example, if I go to Help->Open Help References the help files show up fine with the HTML all intact (Though I couldn't find CF help in there). But, if I go to a

Re:Recursion and Scope problem?

2003-09-18 Thread Cedric Villat
Bingo, worked like a champ. But I'm still wondering WHY the scopes be overwritten? I just don't get it Cedric >Try using the "var" keyword in your first four statements. > > > > >-----Original Message- >From: Cedric Villat [mailto:[EMAIL PROTE

Recursion and Scope problem?

2003-09-18 Thread Cedric Villat
Ok, I'm doing a bit of recursion, and my variables seem to be overwriting themselves, which makes no sense to me. Here is my code: In this example, the root_node is "Homer Simpson". He has 3 children Bart, Lisa, and Maggie. When the function is fi

Re: CF-Talk: Digest every hour

2003-09-17 Thread Cedric Villat
t; %children is an associative array (hash/struct) dereferenced using the syntax $children{key}. > > %line is also an associative array. > > $children{key}'s value is an array. > > In CF, %children is a struct that contains arrays for the value at each key. > > That

  1   2   >