iCal Standard - CF consumption

Hi there Currently reading RFC2245 for iCal and planning on implementing a app/cfc for creating/parsing iCal compliant files... Anybody else coded similar and can point to any good resources for it? Any better standards out there that I should be looking at? Any XML calendar standards out

RE: iCal Standard - CF consumption

I developed an iCal solution...its fairly straightforward, there a few pitfalls like the removal of Carriage Returns and Line feeds in the description. There are different implantations of iCal from diff versions of Office so be wary of that. Also be aware that other apps do not conform at all

RE: iCal Standard - CF consumption

there a few pitfalls like the removal of Carriage Returns and Line feeds in the description. Yeah that line folding looks a bit mad :) There are different implantations of iCal from diff versions of Office so be wary of that. Also be aware that other apps do not conform at all to the

RE: iCal Standard - CF consumption

I reckon vCal as it's the most widely used. -Original Message- From: COLLIE David [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 12:08 To: CF-Talk Subject: RE: iCal Standard - CF consumption there a few pitfalls like the removal of Carriage Returns and Line feeds in the

RE: iCal Standard - CF consumption

I reckon vCal as it's the most widely used. Cheers Neil :) Looked at vCal long time ago... More docs for lunchtime consumption then for a refresher :) -- dc ~| Special thanks to the CF Community Suite Gold Sponsor -

RE: iCal Standard - CF consumption

No problem...in fact have a look at this UDF...it may do the opposite of what you are trying to achieve but it will give you a start... Let me know if you need any more info/tips as the dev goes on. http://www.cflib.org/udf.cfm?ID=385 N -Original Message- From: COLLIE David

ODBC error I can't explain

I am reading an excel file with an ODBC query and I am getting the following error. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver] Too many fields defined. Can anyone explain this error, I am not sure why I am getting it. -- James Smith [EMAIL PROTECTED]

RE: iCal Standard - CF consumption

Let me know if you need any more info/tips as the dev goes on. Cheers Neil, will do :) -- dc ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message:

Re: ODBC error I can't explain

James Smith wrote: I am reading an excel file with an ODBC query and I am getting the following error. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Excel Driver] Too many fields defined. Can anyone explain this error, I am not sure why I am getting it. There is a limit

RE: ODBC error I can't explain

Should be fairly self explanatory...you are passing too much information to the Datasource - it is expecting say 10 fields of data and you are passing it 11. Perform a data mapping to see what you should be passing. -Original Message- From: James Smith [mailto:[EMAIL PROTECTED] Sent:

RE: iCal Standard - CF consumption

Was just going to suggest vCal too. That is what eBay use, for example, to add auction end times to your calendar. (Plus, I helped created the vCal spec many many years ago, not that that makes it better in any way, but it does explain why I may be biased g). -- Ben -Original

Re: ODBC error I can't explain

Robertson-Ravo, Neil (RX) wrote: Should be fairly self explanatory...you are passing too much information to the Datasource - it is expecting say 10 fields of data and you are passing it 11. Perform a data mapping to see what you should be passing. Wrong way around Neil. He's querying the

RE: ODBC error I can't explain

That would be my interpretation of the error as well, however the sheet only has 1 column and that column has only 2956 records. Any other ideas? -- Jay -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 12:56 To: CF-Talk Subject:

Re: List Contains

Stuart, I'm surprised no one has mentioned it yet, but I wouldn't recommend storing a list in your database. I'd recommend figuring out the normalized way to do it. I'm a bit confused as to what you're really storing. Is it that one article is related to other articles? Back to the question at

RE: iCal Standard - CF consumption

(Plus, I helped created the vCal spec many many years ago, not that that makes it better in any way, but it does explain why I may be biased g). All the more reason to use it :) Cheers Ben. -- dc ~| Special thanks to the

Re: ODBC error I can't explain

James Smith wrote: That would be my interpretation of the error as well, however the sheet only has 1 column and that column has only 2956 records. Any other ideas? Still sounds like that is the problem. Although when you look at the spreadsheet it only has one column with data in it,

RE: ODBC error I can't explain

That would be my interpretation of the error as well, however the sheet only has 1 column and that column has only 2956 records. Any other ideas? Still sounds like that is the problem. Although when you look at the spreadsheet it only has one column with data in it, excel has a

[ot] reading response headers with javascript

is this possible? -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ Single Dads ]-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://single-dads.us ]-= ~| Special thanks to the CF Community Suite Gold Sponsor -

Re: List Contains

Hi Deanna, This morning I just worked out what i had done wrong! It was that I had been putting the option value=#articleID# and not option value=#authorID# with my initial form. Each article when CREATED the user gets a chance to link to other related articles. Once these articles are

RE: Yellow fields

Do you have the Google Toolbar installed? I believe that is the culprit. ~Che -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, November 15, 2004 11:32 PM To: CF-Talk Subject: Re: Yellow fields Send a note to our pal Bill Gates. It's his work. It was part of

RE: iCal Standard - CF consumption

LOL! Yeah, but didn't you help create Spectra ;-) Only jesting... -Original Message- From: Ben Forta [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 13:01 To: CF-Talk Subject: RE: iCal Standard - CF consumption Was just going to suggest vCal too. That is what eBay use, for

Getting the Current Request Timeout

Hello, I'm looking for a way to determine the request timeout of the currently executing page. As a point of reference, the following code returns the request timeout configured in the ColdFusion administrator (30) rather than the request timeout set in the cfsetting tag (100): cfsetting

RE: [ot] reading response headers with javascript

Yes Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 AL Amersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 ~| Special thanks to the CF Community Suite Gold Sponsor -

Re: Yellow fields

Che Vilnonis wrote: Do you have the Google Toolbar installed? I believe that is the culprit. Interesting... I have the google toolbar and I also see the yellow fields... - Rick ~| Special thanks to the CF Community Suite

Re: [ot] reading response headers with javascript

and perhaps.. can you shed a little more light on the process... perhaps a point in the right direction.. an example.. something that would be a bit more valuable than your previous answer? On Tue, 16 Nov 2004 15:31:31 +0100, Micha Schopman [EMAIL PROTECTED] wrote: Yes Micha Schopman

Re: List Contains

Hm... I'd explore a recursive network data model. Essentialy, you'd have your articles table and another associated table (articlerelationship). In it, you'd store the pairs of related articles. The complicating factor here is that I don't actually know your business rules. The recusive network

RE: [ot] reading response headers with javascript

Yes Didn't find anything in first couple passes at googling apart from server side javascript reading em... Care to elaborate? Is that what you meant by yes? -- Dc ~| Special thanks to the CF Community Suite Gold Sponsor -

RE: Yellow fields

Poor ol' Bill. Even gets blamed for stuff he DIDN'T do now heh Turn off autofill in your Google toolbar Google toolbar has a list of common fields you can tell it to autofill by filling out the form under Autofill in the options. All the fields it can use that info to fill in, is highlighted in

Re: Yellow fields

thats the Autocomplete feature darn annoying for me as a web developer if I am doing fields. Darn handy if I have to test a form out. MD On Tue, 16 Nov 2004 09:32:09 -0500, Rick Root [EMAIL PROTECTED] wrote: Che Vilnonis wrote: Do you have the Google Toolbar installed? I believe that is the

Re: [ot] reading response headers with javascript

Critter wrote: and perhaps.. can you shed a little more light on the process... perhaps a point in the right direction.. an example.. something that would be a bit more valuable than your previous answer? Would you care to expand on exactly what it is that you are after, so that a more

Re: Yellow fields

thats the Autocomplete feature darn annoying for me as a web developer if I am doing fields. Google Bar has an option to keep auto fill functionality but to turn off yellow highlighting of form fields. - Regards, Bob Haroche O n P o i n t S o l u t i o n s www.OnPointSolutions.com

Re: List Contains

I'm surprised no one has mentioned it yet, but I wouldn't recommend storing a list in your database. This is absolutely true, at least in theory, I mean as a database issue only. But when the number of elements in the list is finite and reasonabily small, and every element in the list is also

Re: [ot] reading response headers with javascript

am using cfheader to add some information to the headers passed back.. was looking for a way to retrieve that information clientside... w/o having to rely on IE as the browser.. (only examples i have stumbled upon mention IE 5+)... On Tue, 16 Nov 2004 14:42:34 +, Stephen Moretti (cfmaster)

Re: List Contains

My knowledge of databases isn't too deep. Am I right to say that i would have a table called articleRelationship and it would contain something like this: articleID - articleRelations 1 3,14,33 2 3,4,12 3 11,1,2 4 7,8,5 5 7,8 OR... would there be a separate row for

Re: List Contains

Version two is what I'm describing. But, as I was saying, it can be complicated depending on whether or not you need reciprocal relationships. As Claude said, in this case if your list of related ids is relatively small, and based on your comfort level with DBs, I'd say just do it the way

session variables

On my laptop, after logging in and getting a CFID and CFTOKEN I lose my session variables upon navigating to another page. On my production server it works properly. As far as I can tell, the CFAdmin settings are the same. The only differences are my laptop is running WinXP with the developer

Re: List Contains

articleID - articleRelations 1 3,14,33 2 3,4,12 3 11,1,2 4 7,8,5 5 7,8 The problem with this, is 1) that you're still storing a list, and 2) you will have either redundant or inconsistent information. Meaning, article 1 says it is related to 3, and 3 says it is

RE: [ot] reading response headers with javascript

am using cfheader to add some information to the headers passed back.. was looking for a way to retrieve that information clientside... w/o having to rely on IE as the browser.. (only examples i have stumbled upon mention IE 5+)... Can you provide a specific example? I don't think you can

Re: [ot] reading response headers with javascript

Server: Microsoft-IIS/5.0 Date: Tue, 16 Nov 2004 16:20:06 GMT Set-Cookie: CFID=56888;path=/ CFTOKEN=15399655;path=/ gplResponse: -117.769469|33.721224|-117.759359|33.730204|8 Content-Type: image/jpeg Connection: close was trying to access the gplResponse variable... On Tue, 16 Nov 2004 11:13:33

RE: [ot] reading response headers with javascript

No.. not crossbrowser, my answer was a little short with yes .. but I figured almost everyone knew it was possible so it should be fairly easy googable. IE5+ had certain vulnerabilities allowing javascript to access this information. I have used it a long time ago for a test case, but Microsoft

Re: CFC Objects in Drop Down

cfloop from=1 to=#ArrayLen(aryObjects).LEN index=i Are you missing a pound sign on this line? Dan ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message:

Using CF to create PCL files

I was wondering if anyone had any experience writing Printer Control (pcl) files in cold fusion. I am working on a project in which hundreds of pdf's and rtf's are created dynamically via our coldfusion app. I am looking for an efficient way to print all of these documents. Thanks, Ali

Use cftry/cfcatch to resume if error in a loop?

I have a fun maintenance project where I need to run thru a loop where I am dropping tables and sequences in an Oracle DB. There are dozens of them and I don't know if they exist or not. Some sequences exist without corresponding tables as well (the drop sequence stuff is not in the snippet

Re: Use cftry/cfcatch to resume if error in a loop?

just thinking out loud here... wouldn't the preferred way to do is is by using Oracle's tools instead? it seems to me that table maintenance, triggers, etc. should be best left to the database that handles it because they do it best as they say. just wondering... I'm probably not as enlightened

Re: Use cftry/cfcatch to resume if error in a loop?

just thinking out loud here... wouldn't the preferred way to do is is by using Oracle's tools instead? Well of course. I can do this in about a minute inside of Oracle itself. Trouble is I don't have access to them so I have to build my own. The fault of the server admins and not something I

Re: Use cftry/cfcatch to resume if error in a loop?

hmmm.. if you don't have access then how can you maintain the tables without the rights to alter them? [EMAIL PROTECTED] 11/16/2004 8:54:11 AM just thinking out loud here... wouldn't the preferred way to do is is by using Oracle's tools instead? Well of course. I can do this in about a

Re: Use cftry/cfcatch to resume if error in a loop?

If statistics are maintained regularly for the DB, a quick query of the systables table could tell you if the table exists or not. If you don't find the table, skip the drop query. It would still be a good idea to use a try/catch block on your drop query though, as you are not gauranteed that

RE: [ot] reading response headers with javascript

Server: Microsoft-IIS/5.0 Date: Tue, 16 Nov 2004 16:20:06 GMT Set-Cookie: CFID=56888;path=/ CFTOKEN=15399655;path=/ gplResponse: -117.769469|33.721224|-117.759359|33.730204|8 Content-Type: image/jpeg Connection: close was trying to access the gplResponse variable... I don't think you're

Re: Use cftry/cfcatch to resume if error in a loop?

hmmm.. if you don't have access then how can you maintain the tables without the rights to alter them? I have the rights to alter them via ColdFusion. Only. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com

Re: Use cftry/cfcatch to resume if error in a loop?

I figured it out. Simple and obvious now that its done. This isn't the whole code of course but the essence is there. I have the full routine wrapped in a more thorough try/catch and I'll probably add cfrethrow into the inner one if I get ambitious. The cfoutputs inside of the loop aren't the

DTS Package From Cold Fusion

Hello, I have an access db that I want to import into SQL Server 2000. Normally I would just use enterprise manager to truncate the table and then import the new database, but I would like to create an application to make the end users self sufficient and allow them to upload an mdb file to the

Oracle CFQUERYPARAM error

All, Hi, there. Have a bit of a tricky one. Before starting, let me say that I know the real solution is to use CLOBs, but I need to make this work in the meantime. I have to put huge amounts of text into tables whose columns are already defined and whose setup may not be changed. Luckily, I

Re: [ot] reading response headers with javascript

Dave Watts wrote: Server: Microsoft-IIS/5.0 Date: Tue, 16 Nov 2004 16:20:06 GMT Set-Cookie: CFID=56888;path=/ CFTOKEN=15399655;path=/ gplResponse: -117.769469|33.721224|-117.759359|33.730204|8 Content-Type: image/jpeg Connection: close was trying to access the gplResponse variable... I

Call a cfc from a cfform

Hello, I was wondering if it was possible to call a cfc from a cffrom? If so how? Thanks, - Charles ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message:

RE: DTS Package From Cold Fusion

Kevin: Try this link: http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS Ricky -Original Message- From: Kevin Pechin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 11:32 AM To: CF-Talk Subject: DTS Package From Cold Fusion Hello, I have an access db that I

Re: Call a cfc from a cfform

Charles Heizer wrote: Hello, I was wondering if it was possible to call a cfc from a cffrom? If so how? What exactly do you mean by call a cfc from a cfform? Sure you can invoke a cfc object within a cfform just like you can at any other point on the page.. but I'm assuming that's not what

Re: Call a cfc from a cfform

Hey Charles, What exactly are you looking to do? Your question is a little vague... -joe On Tue, 16 Nov 2004 09:45:54 -0800, Charles Heizer [EMAIL PROTECTED] wrote: Hello, I was wondering if it was possible to call a cfc from a cffrom? If so how? Thanks, - Charles

image resizing

hello, I plan to build an app that would allow users to upload images to the server for review. Here are the routines I want to try and implement 1. check's the image dimension before its updated (either by cffile or ftp) 2. Once it's uploaded, I want to resize it smaller for faster download

Re: [ot] reading response headers with javascript

@ dave it's an api call.. @ stephen.. i'll have a gander. thanks On Tue, 16 Nov 2004 17:40:13 +, Stephen Moretti (cfmaster) [EMAIL PROTECTED] wrote: Dave Watts wrote: Server: Microsoft-IIS/5.0 Date: Tue, 16 Nov 2004 16:20:06 GMT Set-Cookie: CFID=56888;path=/

Re: DTS Package From Cold Fusion

Great find Ricky! Now I have one last question. I created my DTS package via enterprise manager and saved it as a Meta Data Service Package. Now I go into the design view of the package, and the source location of the mdb file is still my local hard drive. When I try to change it to a folder I

Re: image resizing

Hello Lawrence, I believe that tthere's a custom tag on the Macromedia Exchange that will do this for you. The tag was free when I downloaded it a while back. HTH, Jordan Lawrence Ng wrote: hello, I plan to build an app that would allow users to upload images to the server for review. Here

RE: Call a cfc from a cfform

Sure ... FORM ACTION=mycfc.cfc ... INPUT TYPE=hidden NAME=method VALUE=CFC method ... /FORM Assuming that what you want to do is submit a form to a CFC method, that is. --- Ben -Original Message- From: Charles Heizer [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 16, 2004 12:46

Re: image resizing

i'll see if I can find it.. thanks.. come to think of it, would simply resizing the image reduce download time? I mean it's the same file isn't it? h... [EMAIL PROTECTED] 11/16/2004 10:04:03 AM Hello Lawrence, I believe that tthere's a custom tag on the Macromedia Exchange that will do

Re: Call a cfc from a cfform

I was thinking that I could set the action to be my cfc action.cfc and set the cfinvokeargument to be form values and args. Basically using a cfform instead of using cfinoke. Thanks, - Charles On 11/16/04 9:50 AM, Rick Root [EMAIL PROTECTED] wrote: Charles Heizer wrote: Hello, I was

Re: image resizing

Hi, We've used CFX_ImageInfo which you can find: http://www.intrafoundation.com/cfx_imageinfo.asp and for mx at: http://www.intrafoundation.com/CFX_ImageInfoMX.asp It is a very simple tag that just returns the image information. -Kevin On Tue, 16 Nov 2004 10:04:03 -0800, Jordan Michaels

Re: Call a cfc from a cfform

Cool! This is just what I was looking for. Thanks, - Charles On 11/16/04 10:01 AM, Ben Forta [EMAIL PROTECTED] wrote: Sure ... FORM ACTION=mycfc.cfc ... INPUT TYPE=hidden NAME=method VALUE=CFC method ... /FORM Assuming that what you want to do is submit a form to a CFC method, that

Re: image resizing

I know how to check for file types sizes but its the dimension that I want to check as well. http://www.olimpo.ch/tmt/cfc/tmt_img Massimo Foti DW tools: http://www.massimocorner.com CF tools: http://www.olimpo.ch/tmt/

Re: image resizing

thanks Massimo this looks nice. [EMAIL PROTECTED] 11/16/2004 10:14:48 AM I know how to check for file types sizes but its the dimension that I want to check as well. http://www.olimpo.ch/tmt/cfc/tmt_img Massimo Foti DW tools: http://www.massimocorner.com

Re: image resizing

this is very useful to check the files I have in my directory ... thanks! [EMAIL PROTECTED] 11/16/2004 10:07:20 AM Hi, We've used CFX_ImageInfo which you can find: http://www.intrafoundation.com/cfx_imageinfo.asp and for mx at: http://www.intrafoundation.com/CFX_ImageInfoMX.asp It is a

Re: image resizing

Check for CFX_image. It is great to resize images, even conditional resizing and creating icons. Also have a look at CFX_pureimage at the address below. Many images produced by digital cameras add an extra bloc of information, sometimes up to 50 k, to the images, and this can take lots of space

Re: image resizing

will do.. thank you [EMAIL PROTECTED] 11/16/2004 10:20:24 AM Check for CFX_image. It is great to resize images, even conditional resizing and creating icons. Also have a look at CFX_pureimage at the address below. Many images produced by digital cameras add an extra bloc of information,

Re: image resizing

If you're on MX...here's a function for ya to drop in a CFC: !---(Function: ImageSize)-- Date Created: November 28, 2003 Author: Bryan Arguments: FileLoc - full path of image to get details for (string) required

Re: [ot] reading response headers with javascript

If you use the XMLHttpRequest object (which is in gecko and safari and there is a similar object in IE) you can get access to the headers. However, you'll have to make a request other then the current page request. Here is some info from the apple site, but like I said you can make it work in

RE: [ot] reading response headers with javascript

Having said that, a number of references to XMLHttpRequest hinted that maybe it is possible to access response headers from the client. Until I found this page (http://www.mozilla.org/xmlextras/) I thought it was all IE specific (and generally written using some server side code). The

Re: image resizing

We provide a native commercial product for doing these things. CFX ImageCR 3 : http://efflare.com/products/cfx_imagecr You can resize, convert, crop, etc. You can also retrieve image dimensions and more with the GETIMAGEINFO mode. Additionally, since someone mentioned it, you can also strip

Re: [ot] reading response headers with javascript

Yeah not from the previous thats true, you'd have to make another request On Tue, 16 Nov 2004 10:35:29 -0800, Rob [EMAIL PROTECTED] wrote: getResponseHeader(headerLabel)Returns the string value of a single header label On Tue, 16 Nov 2004 13:36:55 -0500, Dave Watts [EMAIL

Re: [ot] reading response headers with javascript

getResponseHeader(headerLabel)Returns the string value of a single header label On Tue, 16 Nov 2004 13:36:55 -0500, Dave Watts [EMAIL PROTECTED] wrote: Having said that, a number of references to XMLHttpRequest hinted that maybe it is possible to access response headers from the

Re: image resizing

thanks Bryan... I forgot that i could use java... silly me ... thanks everyone. L [EMAIL PROTECTED] 11/16/2004 10:24:52 AM If you're on MX...here's a function for ya to drop in a CFC: !---(Function: ImageSize)-- Date Created:

Re: image resizing

no prob...and hey...isn't free nice ;-) Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com

Regular expression changes in MX

In ColdFusion 5, the statements below were valid and returned a proper regular expression: replaceList(list_URLFragmentsToIgnore, $,[,],.,(,),{,},^,|,?,*,+,/ , \$,\[,\],\.,\(,\),\{,\},\^,\|,\?,\*,\+,[/\]) REFindNoCase(RE_URLFragmentsToIgnore,xx/system32/cmd.exe) In MX, the following error

Re: image resizing

free is always good... we should all live in a bartering system... money is the root of all evil; render unto Caesar what is Caesar's and what is God's God, you can server both God and money, etc. oh wait, that's for another thread .. hehehe thanks again everyone. [EMAIL PROTECTED]

WHERE LIKE

Hi guys, Thanks for the help on the List Contains stuff, once I get the rest of the app done I will try and make the separate Relations table. I'm having problems with the LIKE function in SQL. In my relatedArticles field I have numbers like 26,43,53 cfquery name=relatedArticles

Re: Call a cfc from a cfform

Charles Heizer wrote: I was thinking that I could set the action to be my cfc action.cfc and set the cfinvokeargument to be form values and args. Basically using a cfform instead of using cfinoke. Well, that's certainly possible I guess... although I can't imagine why you'd do that, since the

Re: WHERE LIKE

I think you want IN, not LIKE WHERE articleID IN (#getArticle.articleRelatedLinks#) will pull articles 26, 43, and 53. On Tue, 16 Nov 2004 19:07:29 +, Stuart Kidd [EMAIL PROTECTED] wrote: Hi guys, Thanks for the help on the List Contains stuff, once I get the rest of the app done I

RE: WHERE LIKE

WHERE articleID IN (cfqueryparam list=yes cfsqltype=cf_sql_numeric value=#GetArticle.articleRelatedLinks#) Pascal -Original Message- From: Stuart Kidd [mailto:[EMAIL PROTECTED] Sent: 16 November 2004 20:07 To: CF-Talk Subject: WHERE LIKE Hi guys, Thanks for the help on the

Re: WHERE LIKE

That's a singularly horrible way to store a relation. First, the LIKE clause needs to have % at the front and back so that it doesn't search for exactly the string, but rather for the string with optional stuff at either end. Second, if the numbers aren't in the order you provide them, or

Need Suggestions for Spreading Out Notification Mailings

Hi folks! I need your input on a task I've got to create that sends out a notification to everyone on our mailing list once daily. However, our list is quite large, so I don't want to send it at the same time every day as that's too much mail to go out at once. What I would like to do is

loop over form objects

I have a page with X number of check boxes on it. I have a query which generates these check boxes. The query also returns the min and max value of the ID for those check boxes. Basically creating r_23 r_24 r_25 r_26 ... and so forth. I'm trying to loop over these fields to check to see if none

Re: Need Suggestions for Spreading Out Notification Mailings

Break the alphabet up into 24 segments and run 24 separate jobs, where the last name starts with this hour's letter. Mightn't be exactly the same size for each segment but does that matter as long as they're bite-size chunks each hour? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks

Re: WHERE LIKE

Thanks Charlie and Pascal, both of yours worked. And thanks to Barney for your input too. Can someone just quickly tell me again why the cfqueryparam should be used. Also Barney, so are you saying that the way mine is at the moment, with this new code will it not work or will I come across some

Re: loop over form objects

form['r_' i] On Tue, 16 Nov 2004 13:34:00 -0600, Greg Morphis [EMAIL PROTECTED] wrote: I have a page with X number of check boxes on it. I have a query which generates these check boxes. The query also returns the min and max value of the ID for those check boxes. Basically creating r_23

Re: Need Suggestions for Spreading Out Notification Mailings

If you've got an integer primary key for the subscribers, use a MOD 24 selection routine to pick the subscribers to notify each hour. So a midnight, you notify everyone with PK MOD 24 = 0. At 1:00 am, you notify everyone with PK MOD 24 = 1. It won't be perfectly even, but the odds of clustering

Re: Need Suggestions for Spreading Out Notification Mailings

Easy like pie ;-) 1) schedule a task to run at the desired intervals 2) task checks for all members that haven't yet recieved todays mailing 3) send mail to the first X members that have yet to get todays mailing 4) update the flag for those getting sent the mailing 5) clear out all flags at

Re: WHERE LIKE

I totally misinterpreted what you're trying to do, becuase you used LIKE, where you wanted IN. I didn't look at the what the query was trying to do as a whole, and realize you're using the wrong operator like Charlie and Pascal did, I just saw the operator and used that as my basis for what you

apache and muliple CF instances

Ok, I got a box with CFMX installed on JRun, actually have 2 instances installed, say one is cfusionone and cfusiontwo. In IIS I know I can add a new site, via different port or host-headers, so that http://domain:80/ uses cfusionone and http://domain:88/ uses cfusiontwo. How to do this in

Re: JVM 1.5.0 - Anyone using it?

I haven't had any problems yet using 1.5 except, as Dave mentioned, Axis is borked so web services don't work. So, as of right now, it's obviously not worth upgrading. I look forward to official support for 1.5, but it doesn't seem that drastic of a change to warrant any rush. -Ryan On Tue, 16

RE: DTS Package From Cold Fusion

Kevin: I am really not quite sure how it would work. I haven't dabbled to far into CF and DTS, but over the next three months I am going to be playing in this area of development. I just had that bookmark for reference for my next project coming down the pipe. Experiment around with it and let

Re: image resizing

Check out New Atlanta's Blue Dragon Beta. They have a nice image tag in there I beleive. www.newatlanta.com http://www.newatlanta.com/c/products/bluedragon-beta/download/home Adam H On Tue, 16 Nov 2004 10:51:28 -0800, Lawrence Ng [EMAIL PROTECTED] wrote: free is always good... we should all

Re: Regular expression changes in MX

CFMX actually has more regex changes than you realize. The engine was rewritten to more closely match perl syntax. Personally, I use the livedocs as my only regex reference. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/regexp.htm#wp1100400 -nathan strutz http://www.dopefly.com/

Re: CFC Objects in Drop Down

Yes I am, but that wasn't the actual code I'm trying to run. I just wrote that in the posting text box. Since the objects that i want to select are already created and in memory, is there any I can just pass a pointer to the selected object to the form processing page so I can just

  1   2   >