RE: Password in Image Technology
You can do all these things using ImageMagick (I think). For more info on images, google for captcha -- Hugo Ahlenius - Hugo AhleniusE-Mail: [EMAIL PROTECTED] Project Officer Phone:+46 8 230460 UNEP GRID-ArendalFax:+46 8 230441 Stockholm OfficeMobile:+46 733 467111 WWW: http://www.grida.no - | -Original Message- | From: Mark Drew [mailto:[EMAIL PROTECTED] | Sent: Saturday, June 05, 2004 10:38 | To: CF-Talk | Subject: Re: Password in Image Technology | | I think the question is more a how-to, I have been reading | the image functions in PHP for creatnig new images from PNG's | or simply from scratch. That is how a lot of sites do it by | adding an overlay and adding a filter to a set of | characters... so you could do the following in PGP: | Create image | add text | add overlay to confuse it | add a distortion filter to confuse OCR systems | | | I hope this helps (as you can run PGP and CF together on most | systems!) | | | Regards | | Mark Drew | | On Fri, 04 Jun 2004 15:02:48 -0400, Claude Schneegans | [EMAIL PROTECTED] wrote: | | the image is obscurred so OCR software can't read the | special code | | Exact, and some use similar character, like I and 1, Z and | 2, S and 5, etc. in order to goof the OCR systems even more. | | -- | ___ | REUSE CODE! Use custom tags; | See http://www.contentbox.com/claude/customtags/tagstore.cfm | (Please send any spam to this address: [EMAIL PROTECTED]) | Thanks. | | | | [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: connect to a network db, and log on account - XP
Are you in an NT/2000 Domain Environment? If so, you need to create an account in the domain and set the CF services to use that when they startup then configure that account to have read permissions on the resource you're trying to access on the domain. When CF is running it's running as it were this user account, to verify it can access the Db login as this new user and try and open the Db. In a non domain environment you'd need to create a local user on both the CF server and the resource provider - both username's and passwords need to match on both servers, configure the new account to have read permission on the Db and it should work just fine. Jb. -Original Message- From: stylo stylo [mailto:[EMAIL PROTECTED] Sent: 07 June 2004 06:03 To: CF-Talk Subject: Re: connect to a network db, and log on account - XP BTW, I just tried using the account name Guest and deleted the unknown password there. (With the unknown password still in it said it was an incorrect password.) When restarting the cf server it failed and said something bizarre like could not end the pipe, or smoked the pipe way too much. Had to reset to the Local System account button to get it to put down the pipe and start working again. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
QofQ problem - can you see what i've got wrong here please?
This Query of a Query is giving an error I've never seen before.Can anyone see what's causing it please? The QofQ is as follows: [quote] cfquery name=shortlist dbtype=query SELECT DISTINCT(email) FROM Thislist WHERE Newsletter = 1 ORDER BY email /cfquery [/quote] And I've checked, those fields exist in the query, and I can CFDUMP the query ThisList without problems.All the fields referred to in the QofQ exist in the first query and have values. The error I'm getting is: [quote] must be interprettable as a valid number in the current locale. Pointing to the line containing: cfquery name=shortlist dbtype=query [/quote] Cheers Mike Kear AFP Webworks Windsor, NSW, Australia http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem - can you see what i've got wrong here please?
I can't see anything wrong with the code. Are you sure there isn't an error in one of the previous lines. CF isn't always pointing at the line where the error actually occurred. Pascal -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: maandag 7 juni 2004 10:26 To: CF-Talk Subject: QofQ problem - can you see what i've got wrong here please? This Query of a Query is giving an error I've never seen before.Can anyone see what's causing it please? The QofQ is as follows: [quote] cfquery name=shortlist dbtype=query SELECT DISTINCT(email) FROM Thislist WHERE Newsletter = 1 ORDER BY email /cfquery [/quote] And I've checked, those fields exist in the query, and I can CFDUMP the query ThisList without problems.All the fields referred to in the QofQ exist in the first query and have values. The error I'm getting is: [quote] must be interprettable as a valid number in the current locale. Pointing to the line containing: cfquery name=shortlist dbtype=query [/quote] Cheers Mike Kear AFP Webworks Windsor, NSW, Australia http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem - can you see what i've got wrong here please?
Thanks for that Pascal.I've done some more work trying to eliminate possibilities, and I figure the problem might be something in the data itself, causing the QofQ to hiccup. Does anyone know what causes that error, must be interprettable as a valid number in the current locale? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Monday, 7 June 2004 6:35 PM To: CF-Talk Subject: RE: QofQ problem - can you see what i've got wrong here please? I can't see anything wrong with the code. Are you sure there isn't an error in one of the previous lines. CF isn't always pointing at the line where the error actually occurred. Pascal -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: maandag 7 juni 2004 10:26 To: CF-Talk Subject: QofQ problem - can you see what i've got wrong here please? This Query of a Query is giving an error I've never seen before.Can anyone see what's causing it please? The QofQ is as follows: [quote] cfquery name=shortlist dbtype=query SELECT DISTINCT(email) FROM Thislist WHERE Newsletter = 1 ORDER BY email /cfquery [/quote] And I've checked, those fields exist in the query, and I can CFDUMP the query ThisList without problems.All the fields referred to in the QofQ exist in the first query and have values. The error I'm getting is: [quote] must be interprettable as a valid number in the current locale. Pointing to the line containing: cfquery name=shortlist dbtype=query [/quote] Cheers Mike Kear AFP Webworks Windsor, NSW, Australia http://afpwebworks.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem - can you see what i've got wrong here please?
Have you tried... cfquery name=shortlist dbtype=query SELECT DISTINCT email, Newsletter FROM Thislist WHERE Newsletter = 1 ORDER BY email /cfquery We're on CF5 and QoQ and AFAIK it always chokes unless you explicity use all the columns that you reference. just a thought :-/ -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem - can you see what i've got wrong here please?
Thanks for that Pascal.I've done some more work trying to eliminate possibilities, and I figure the problem might be something in the data itself, causing the QofQ to hiccup. Does anyone know what causes that error, must be interprettable as a valid number in the current locale? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Monday, 7 June 2004 6:35 PM To: CF-Talk Subject: RE: QofQ problem - can you see what i've got wrong here please? I can't see anything wrong with the code. Are you sure there isn't an error in one of the previous lines. CF isn't always pointing at the line where the error actually occurred. Pascal [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem - can you see what i've got wrong here please?
Thanks dc.I hadn't tried that.I didn't know about that issue.However it didn't fix the problem. Cheers Mike Kear _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, 7 June 2004 7:48 PM To: CF-Talk Subject: RE: QofQ problem - can you see what i've got wrong here please? [snip] We're on CF5 and QoQ and AFAIK it always chokes unless you explicity use all the columns that you reference. just a thought :-/ -- dc [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem - can you see what i've got wrong here please?
So does anyone know what would be causing this error message?I'm not even sure what to be looking for.It seems to be complaining about a field with a series of semicolons (;) in it but there aren't any in the database, or in the code. Any hints about what it means? The error is: must be interprettable as a valid number in the current locale Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: saving files in homesite.... slooooow!
I had similar problem a few years ago - studio slow to save files on network, but other apps fine. I think i solved it by fiddling around in the registry and clearing up references to invalid drive mappings in the Studio bit. If it wasn't in the registry then it might have been in some Studio config file, but i'm pretty sure i was the registry. Sorry i can't be more specific - as i say it was a couple of years ago, but the symptoms sound similar. HTH Bert From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 07 June 2004 03:34 To: CF-Talk Subject: RE: saving files in homesite slow! wasn't on :( I guess its just that saving to a network drive is slow... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: saving files in homesite.... slooooow!
wow. now that helps :) I did some network browsing tweaks found on tweakxp.com that were, ok, I guess. but not sure they did anything? tw -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 7:43 AM To: CF-Talk Subject: RE: saving files in homesite slow! I had similar problem a few years ago - studio slow to save files on network, but other apps fine. I think i solved it by fiddling around in the registry and clearing up references to invalid drive mappings in the Studio bit. If it wasn't in the registry then it might have been in some Studio config file, but i'm pretty sure i was the registry. Sorry i can't be more specific - as i say it was a couple of years ago, but the symptoms sound similar. HTH Bert From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 07 June 2004 03:34 To: CF-Talk Subject: RE: saving files in homesite slow! wasn't on :( I guess its just that saving to a network drive is slow... [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem -closing in on the problem..
Ok I've narrowed the problem down a little.The error is generated by having non-numeric information in the 'postcode' field.(It's a varchar field in the database so there's no problem with that I think).I don't think we need to have the postcode restricted to numeric data at source - what if someone wants to put 'N/A' in the postcode field? Anyway, there are several queries on different tables and datasources, and the resulting queries are merged into one temporary query to be processed with a QofQ.The query is created with the following: [quote] cfset thislist = Querynew(email, firstname, lastname, StreetAddress, Suburb, Postcode, source, newsletter, emailsent) [/quote] Why would this query hiccup if non-numeric info is put into the 'postcode' field in the query?I thought ColdFusion was typeless?I would have thought a queryofquery wouldn't care if there was numericdata in the 'postcode' field or not. Am I wrong on that? And what do I do about it? Cheers Mike Kear _ From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Monday, 7 June 2004 8:22 PM To: CF-Talk Subject: RE: QofQ problem - can you see what i've got wrong here please? So does anyone know what would be causing this error message?I'm not even sure what to be looking for.It seems to be complaining about a field with a series of semicolons (;) in it but there aren't any in the database, or in the code. Any hints about what it means? The error is: must be interprettable as a valid number in the current locale Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: SQL date record retrevial problem
As Pascal said, use cfqueryparam because Access expects #'s around it's dates and SQL Server expects ODBC dates. Doug Eric Creese wrote: I am using the following to retreive records from a database. However I am not gettign any records and I should. Database is Access but will be moving to SQL for production cfset today365 = Now() +365 cfset today1 = Now() -1 cfquery name=getscheduledatasource=liberty SELECT EVENT_ID,EVENT_DATE,EVENT_NAME,EVENT_TIME,EVENT_LOC FROM schedule WHERE EVENT_DATE = #DATEFORMAT(today365, MM/DD/)# AND EVENT_DATE #DATEFORMAT(today1, MM/DD/)# AND display='yes' ORDER BY EVENT_DATE; /cfquery [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors
Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/large_record_sets_ oom.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: saving files in homesite.... slooooow!
I just want to +1 this, although for me, the issue was only for network shares. Norton would slow down saves so that they took 10-15 seconds each. I simply started disabling it. (But again, this wasn't a local drive.) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
help for the speed of this query?
SELECT DISTINCTsome fields from table A, B, C, D, E FROM A, B, C, D, E WHERE A.ID = B.ID AND A.ID = C.ID AND A.ID = D.ID AND A.ID = E.ID; ID is primary key for table A and are foreign keys for tables B, C, D, E. It is one to many relationship Each table has around 500 records. I do a query like above. It takes around 6 seconds. I try to create index for ID in table B, C, D and E. But it not help. Can someone show me anyway I can improve the speed for this query. I have SQL Server 2000. Thanks any help. __ Do you Yahoo!? Friends.Fun.Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
I don't even know what I need to be able to do this...[fdf/cf]
Here are the basic requirements: They (client) have a couple of hundred forms in PDF format that they want *their* clients to be able to fill out and submit. We have CF sitting on their server. On their (client's) end, they want to be able to save the same PDF form, but filled out, on their end. Likely scenario: The Client's client: I log in, click on a form, the PDF loads, I fill out the PDF, click a button on the PDF, some CF happens that I don't see. A thank you page is displayed, and I go about my business. (Upside, no form validation, they're going to be going over each form themselves on the back end) The Client: Some notification (Hey, a PDF was filled out!), log in to a back end, see a list of forms submitted, date submitted maybe, and by whom (based on above's loginID). Click on a link to the latest entry, the PDF loads (?) and it's filled in with the information from the previous submission (?), I click save (I have Acrobat Pro on my end, I'm The Client.) and it saves it maybe with the date/time added to the end of the file name... Now, I know about 50% of that, but I'm willing to jump in the direction of any CF based way of accomplishing that very scenario. Oh, and it's hosted on Crystal Tech, who (rightfully so) informed us that loading an application would require us to be on our own dedicated server (so, no beef there, legit, I get it and it just gives me my design parameters, I'm anything if not flexible and understanding), but a .dll could be done, so keep that in mind. Also, these forms are insurance-related, so they'll contain stuff like SSNs and other assorted goodies, so simply emailing them won't really work (unless encryption can be worked into that scenario). I was hoping to be able to write all this to happen behind an https://, to take care of that concern. Now, notice that, if the PDF was a form, it'd be an easy exercise, but I'm just not sure about the whole, inserting stuff into a PDF from a CFQUERY tag thing. But again, eager beaver... So my question, I guess is, how best to accomplish this, with the tools I've got? We can explore getting some possibly sub-grand cost PDF/FDF .dll stuff to assist, but can this be done with CF or running on a CF server? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help for the speed of this query?
From: John Ho SELECT DISTINCTsome fields from table A, B, C, D, E FROM A, B, C, D, E WHERE A.ID = B.ID AND A.ID = C.ID AND A.ID = D.ID AND A.ID = E.ID; ID is primary key for table A and are foreign keys for tables B, C, D, E. It is one to many relationship Each table has around 500 records. I do a query like above. It takes around 6 seconds. I try to create index for ID in table B, C, D and E. But it not help. Can someone show me anyway I can improve the speed for this query. I have SQL Server 2000. Use the JOIN statement rather than just doing it in the WHERE - it should speed up your query in one simple step [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors
debbie... you can now use... http://www.antiwrap.com to send messages like this...so that the url wont truncate. :) tony -Original Message- From: Debbie Dickerson [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 9:35 AM To: CF-Talk Subject: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/large_record_sets_ oom.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: saving files in homesite.... slooooow!
norton, on the server, or on your dev box? tony -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 9:36 AM To: CF-Talk Subject: RE: saving files in homesite slow! I just want to +1 this, although for me, the issue was only for network shares. Norton would slow down saves so that they took 10-15 seconds each. I simply started disabling it. (But again, this wasn't a local drive.) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help for the speed of this query?
To clarify... What usually happens when you do A,B,C,D,E is that the dbms creates a Cartesian Product which is of size size(a) x size(b) x size(C) x size(D) x size(E) and only then does it start restricting the results using the WHERE clause A Join, on the other hand works incrementally, 2 tables at a time, applying the WHERE/ON join restriction as it goes, and is thus significantly more efficient. -Dov _ From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 9:50 AM To: CF-Talk Subject: RE: help for the speed of this query? From: John Ho SELECT DISTINCTsome fields from table A, B, C, D, E FROM A, B, C, D, E WHERE A.ID = B.ID AND A.ID = C.ID AND A.ID = D.ID AND A.ID = E.ID; ID is primary key for table A and are foreign keys for tables B, C, D, E. It is one to many relationship Each table has around 500 records. I do a query like above. It takes around 6 seconds. I try to create index for ID in table B, C, D and E. But it not help. Can someone show me anyway I can improve the speed for this query. I have SQL Server 2000. Use the JOIN statement rather than just doing it in the WHERE - it should speed up your query in one simple step _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion TechNote Notification: Determining which class files are loaded by ColdFusion MX
Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/class_files_loaded .htm http://www.macromedia.com/support/coldfusion/ts/documents/class_files_loade d.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors
From: Tony Weeg debbie... you can now use... http://www.antiwrap.com to send messages like this...so that the url wont truncate. Or if you're signed in to the HoF site, then you can use http://www.houseoffusion.com/tinyurl.cfm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: saving files in homesite.... slooooow!
It was Norton _just_ on my dev box. Never did figure it out. Other apps had no issues w/ saving to a network share. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: saving files in homesite.... slooooow!
Further to this. Is it possible, as our hard-drives get larger, and our expectations similar we are asking for too much in too little a time? 9 years ago when CFML was first introduced things were VERY different indeed. However indeed now - BACK OFF - and give your PC a break. Play games? Running a SQL Server? Same box? No wonder! Heh! But I am doing that too! CFMX 6.1 - SQL Server 2000 SP3, BlueDragon, Norton Anti... And can still safely play Halo PC or Return to Castle Wolf online! -Original Message- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Monday, 7 June 2004 11:36 PM To: CF-Talk Subject: RE: saving files in homesite slow! I just want to +1 this, although for me, the issue was only for network shares. Norton would slow down saves so that they took 10-15 seconds each. I simply started disabling it. (But again, this wasn't a local drive.) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
AntiWrap.Com URL Email
Here is a link that, [EMAIL PROTECTED] has sent you, please click to view this website: http://www.antiwrap.com/?19 What is this? AntiWrap.Com helps people around the world send links to websites that are otherwise impossible to send via email.Have you ever recieved an email with a link and the website just didnt pop up?Well, this tool aims to end that problem.Please visit http://www.antiwrap.com to try it for yourself! Thanks. Team AntiWrap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem -closing in on the problem..
Mike, if using CF use the CFINPUT and use validatenumeric or at least integer. -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Monday, 7 June 2004 10:25 PM To: CF-Talk Subject: RE: QofQ problem -closing in on the problem.. Ok I've narrowed the problem down a little.The error is generated by having non-numeric information in the 'postcode' field.(It's a varchar field in the database so there's no problem with that I think).I don't think we need to have the postcode restricted to numeric data at source - what if someone wants to put 'N/A' in the postcode field? Anyway, there are several queries on different tables and datasources, and the resulting queries are merged into one temporary query to be processed with a QofQ.The query is created with the following: [quote] cfset thislist = Querynew(email, firstname, lastname, StreetAddress, Suburb, Postcode, source, newsletter, emailsent) [/quote] Why would this query hiccup if non-numeric info is put into the 'postcode' field in the query?I thought ColdFusion was typeless?I would have thought a queryofquery wouldn't care if there was numericdata in the 'postcode' field or not. Am I wrong on that? And what do I do about it? Cheers Mike Kear _ From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: Monday, 7 June 2004 8:22 PM To: CF-Talk Subject: RE: QofQ problem - can you see what i've got wrong here please? So does anyone know what would be causing this error message?I'm not even sure what to be looking for.It seems to be complaining about a field with a series of semicolons (;) in it but there aren't any in the database, or in the code. Any hints about what it means? The error is: must be interprettable as a valid number in the current locale Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: AntiWrap.Com URL Email
On Monday 07 Jun 2004 15:11 pm, [EMAIL PROTECTED] wrote: http://www.antiwrap.com/?19 Great, goats.ex, is it ? Seriously, I'm not going to click on a link without knowing what it's going to do. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I don't even know what I need to be able to do this...[fdf/cf]
Jeff, FDF files are just simple text files that are very easy to create with CF. Here's an example: cfoutput%FDF-1.2 % 1 0 obj /FDF /Fields [ /T(issuedate) /V(#dateformat(rs.cert_issue_dt,mm/dd/)# ) ] /F(http://#cgi.HTTP_HOST#/files/certificate.pdf) endobj trailer /Root 1 0 R %%EOF/cfoutput Just keep repeating the /T command which is the text box name in the pdf form and the /V command which is the value you want inserted. The /F command needs to point to the parent pdf file.I believe that Acrobat (not reader) will actually make the fdf file for you and then you'd just need to edit the file.On caveat, don't edit the file with notepad.Notepad doesn't correctly render the CR after the first line %FDF-1.2. I serve these on the fly using the cfcontent tag and so far, this has been a painless endeavor. -- Marlon Moyer, Sr. Internet Developer American Contractors Insurance Group phone: 972.687.9445 fax: 972.687.0607 mailto:[EMAIL PROTECTED] www.acig.com -Original Message- From: Jeff Small [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 8:43 AM To: CF-Talk Subject: I don't even know what I need to be able to do this...[fdf/cf] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors
They need to do something internally for this, it isn't a good idea PR-wise for a company that large to use an outside service for something so simple. On Jun 7, 2004, at 9:46 AM, Tony Weeg wrote: you can now use... http://www.antiwrap.com to send messages like this...so that the url wont truncate. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: AntiWrap.Com URL Email
From: Thomas Chiverton Great, goats.ex, is it ? Seriously, I'm not going to click on a link without knowing what it's going to do. This is why http://makeashorterlink.com is so much better - the delay before pushing on to the site means that you can see the link and decide if you REALLY want to go there [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors
Damien McKenna wrote: They need to do something internally for this Change to a decent email client that doesn't wrap halfway words? Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help for the speed of this query?
I change the above query to SELECT DISTINCTsome fields from table A, B, C, D, E FROM A JOINB ON A.ID = B.ID JOIN C ON A.ID = C.ID JOIN D ON A.ID = D.ID JOIN E ON A.ID = E.ID; BUT still run 6 second like old query. To clarify... What usually happens when you do A,B,C,D,E is that the dbms creates a Cartesian Product which is of size size(a) x size(b) x size(C) x size(D) x size(E) and only then does it start restricting the results using the WHERE clause A Join, on the other hand works incrementally, 2 tables at a time, applying the WHERE/ON join restriction as it goes, and is thus significantly more efficient. -Dov _ From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 9:50 AM To: CF-Talk Subject: RE: help for the speed of this query? Use the JOIN statement rather than just doing it in the WHERE - it should speed up your query in one simple step _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors
MM did have an internal rewrite on certain URLs but this may have been removed or just not known. To bring this over to a technical topic, this is why I reject the use of UUIDs as unique identifiers for data. A sequential number may get large (10) but it is almost always shorter than a UUID and better looking. They need to do something internally for this, it isn't a good idea PR-wise for a company that large to use an outside service for something so simple. On Jun 7, 2004, at 9:46 AM, Tony Weeg wrote: you can now use... http://www.antiwrap.com to send messages like this...so that the url wont truncate. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Writing new text file without the specific lines
I am writing a new text file, after submitting the form. I have a form field LineNo which I don't want to add in my new file that form var can be only 6 or can be 1,4,6 how can I stop adding those line in my writenow var the x is basically is containing the line # cfif IsDefined('form.submitpressed') AND #form.submitpressed# EQ 1 cfset writenow = CFSET crlf = Chr(13) Chr(10) cfset gotill = #Evaluate((StructCount(form))# cfloop from=1 to=#gotill# index=x cfset writenow = #writenow# #trim(form[title#x#])#|#trim(form[story#x#])#|#trim(form[link#x#])#|# trim(form[target#x#])# cfif #x# LT #gotill# cfset writenow = #writenow# #crlf# /cfif /cfloop !--- cfloop list=#form.lineNo# delimiters=, index=abc CFSET NewFile = ListDeleteAt(#writenow#,#x#) /cfloop --- cffile action="" file=C:\CFusionMX\wwwroot\dev\infiniti\news.txt output=#writenow# cfoutput#writenow#/cfoutput /cfif Thanks [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: I don't even know what I need to be able to do this...[fdf/cf]
- Original Message - From: Marlon Moyer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:27 AM Subject: RE: I don't even know what I need to be able to do this...[fdf/cf] Jeff, FDF files are just simple text files that are very easy to create with CF. Here's an example: [snip example] Just keep repeating the /T command which is the text box name in the pdf form and the /V command which is the value you want inserted. The /F command needs to point to the parent pdf file.I believe that Acrobat (not reader) will actually make the fdf file for you and then you'd just need to edit the file.On caveat, don't edit the file with notepad. Notepad doesn't correctly render the CR after the first line %FDF-1.2. I serve these on the fly using the cfcontent tag and so far, this has been a painless endeavor. Okay, so lemme get this straight. I could have the PDF data submitted to a CF page that could process it and enter it into a database table. Then, a CFQUERY tag could generate output that could be saved as an FDF, then point it to a Parent PDF File? How does the end user (the client) see the PDF File? Does she click on a CF link that does all the work? So she clicks on CreatePDF.cfm or whatever, and the result, is that a populated PDF form opens in her browser window? And if she has Acrobat Pro, she can just save it? Am I understanding it all? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: help for the speed of this query?
try this: select distinct myFields from (((A inner join B on B.ID=A.ID) inner join C on C.ID=A.ID) inner JOIN D on D.ID=A.ID) inner join E on E.ID=A.ID is this what your query looked like? If not, does this help it? -dov _ From: John Ho [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:44 AM To: CF-Talk Subject: Re: help for the speed of this query? I change the above query to SELECT DISTINCTsome fields from table A, B, C, D, E FROM A JOINB ON A.ID = B.ID JOIN C ON A.ID = C.ID JOIN D ON A.ID = D.ID JOIN E ON A.ID = E.ID; BUT still run 6 second like old query. To clarify... What usually happens when you do A,B,C,D,E is that the dbms creates a Cartesian Product which is of size size(a) x size(b) x size(C) x size(D) x size(E) and only then does it start restricting the results using the WHERE clause A Join, on the other hand works incrementally, 2 tables at a time, applying the WHERE/ON join restriction as it goes, and is thus significantly more efficient. -Dov _ From: Philip Arnold [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 9:50 AM To: CF-Talk Subject: RE: help for the speed of this query? Use the JOIN statement rather than just doing it in the WHERE - it should speed up your query in one simple step _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
OT: MacOSX email clients (was Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors)
On Jun 7, 2004, at 10:42 AM, Jochem van Dieten wrote: Change to a decent email client that doesn't wrap halfway words? I tried thunderbird for a month, or rather put up with the pile of steaming monkey code, but in the end wanted something that would actually _work_.The Linux and Windows builds are great, I use it at home, but for OSX they need to spend a few months fixing the major bugs to make it useable. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
SQL: Keyword Lookup
Hello, Have 3 tables. equities equityID symbol keywords keywordID keyword keyword_equity_join keID equityID keywordID The user selects from a dropdown list a keyword The user may then add another dropdown list to select another keyword. The user may add as many dropdown list as he or she wants. When the user clicks on the submit button I have a list of keywords. If the keywords happen to be: technology, consulting. I want the query to return only the symbols that have both technology and consulting as associated keywords. So far this is what I have (doing it in Query Analyzer before writing the code). select e.symbol, kej.keywordID, e.equityID from equities as e, keyword_equity_join as kej where e.equityID = kej.equityID and kej.keywordID in ( select k.keywordID from keywords k where (keyword = 'technology' OR keyword = 'consulting') ) select k.keywordID from keywords k where (keyword = 'technology' OR keyword = 'consulting') This returns the keywordID for the two keywords. select e.symbol, kej.keywordID, e.equityID from equities as e, keyword_equity_join as kej where e.equityID = kej.equityID and kej.keywordID in ( This returns all the symbols that are associated with either keywords. Results ABCO 355 11391 RADS 355 11138 XPRT 355 14160 RCMT 65 11022 ACLA 65 12237 ACN 355 13256 ACN 65 13256 ACOC 355 16491 I just want ACN. Anyone have experience with this? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Question about Licensing my CF Web Application
Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help for the speed of this query?
John Ho wrote: SELECT DISTINCTsome fields from table A, B, C, D, E FROM A, B, C, D, E WHERE A.ID = B.ID AND A.ID = C.ID AND A.ID = D.ID AND A.ID = E.ID; ID is primary key for table A and are foreign keys for tables B, C, D, E. It is one to many relationship Each table has around 500 records. I do a query like above. It takes around 6 seconds. I try to create index for ID in table B, C, D and E. But it not help. Please show us the query execution plan. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: help for the speed of this query?
yeah I use either join or innter join like you. And both has same speed 6second. try this: select distinct myFields from (((A inner join B on B.ID=A.ID) inner join C on C.ID=A.ID) inner JOIN D on D.ID=A.ID) inner join E on E.ID=A.ID is this what your query looked like? If not, does this help it? -dov _ From: John Ho [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:44 AM To: CF-Talk Subject: Re: help for the speed of this query? I change the above query to SELECT DISTINCTsome fields from table A, B, C, D, E FROM A JOINB ON A.ID = B.ID JOIN C ON A.ID = C.ID JOIN D ON A.ID = D.ID JOIN E ON A.ID = E.ID; BUT still run 6 second like old query. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
GET IT ALL IN WRITING. VERIFIED BY YOUR LAWYER, AND SIGNED WITH A NOTARY PUBLIC IN ATTENDANCE. if your comfortable, go with it. The RECURRING REVENUE MODEL is a great one. but BE SURE, 100% positive, you have EVERYTHING IN WRITING/SIGNED. tw -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem -closing in on the problem..
Thanks for your input Peter.This is not an input problem.Yes, they need to do better data validation and that's another task I'm going to suggest they need to do, but this is about queries notinput. I have 3 queries on SQLServer tables, and one on a Excel spreadsheet, each containing a field called Postcode which is a varchar field in the SQLServer, and has mostly numbers and some letters in the spreadsheet. I am combining the four queries by looping over them and writing the output to a query built by CFMX.Then I'm doing a query of a query to de-duplicate the records, and sort them. That's where the application gives an error when it encounters a postcode field with non-numeric content. I can't see why that should matter. I'm not doing math on the field, I'm not sorting on it.It's just a field, like name, suburb, country, email address .. all the others.I cant see why it matters whether the contents of the Postcode field are numbers or letters or dancing pigeons. At the point where it throws the error, it's not trying to insert into a database, or perform arithmetic, just SELECT in the Query of aQuery.But if there's a postcode field containing NA the whole thing hiccups. WTF?? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 June 2004 12:14 AM To: CF-Talk Subject: RE: QofQ problem -closing in on the problem.. Mike, if using CF use the CFINPUT and use validatenumeric or at least integer. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
Dave, If 30% is what they offered, I would definitely try for more. Maybe counter with 45%. Everything else sounds pretty sane. Good luck with it. Greg -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MacOSX email clients (was Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors)
I love Thunderbird on OSX, so I'm wondering what sort of issues you've had w/ this?? -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:01 AM To: CF-Talk Subject: OT: MacOSX email clients (was Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors) On Jun 7, 2004, at 10:42 AM, Jochem van Dieten wrote: Change to a decent email client that doesn't wrap halfway words? I tried thunderbird for a month, or rather put up with the pile of steaming monkey code, but in the end wanted something that would actually _work_.The Linux and Windows builds are great, I use it at home, but for OSX they need to spend a few months fixing the major bugs to make it useable. -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: MacOSX email clients (was Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors)
On Jun 7, 2004, at 11:13 AM, Josh Remus wrote: I love Thunderbird on OSX, so I'm wondering what sort of issues you've had w/ this?? _Constant_ crashes when sending email.99% of the time it would crash after writing an email.I couldn't live with that and shouldn't have put up with it for so long (a month) before dumping that zero and getting myself a, uh, Mail client ;) -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
1) Are they paying you enough up front to make you happy in the event they never sell it to anyone? 2) Are they paying you hourly for your support efforts or are you on the hook to train them indefinitely regardless of their sales volume? 3)Is the 30% on customization work over and above what you charge to do the work? Or do you just get 30% of whatever they choose to charge for customization? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Autoincrement feature with MySQL?
I am converting from MS Access to MySQL. Does anyone know how do you get the autoincrement feature with MySQL With MS Access that seemed to happen automatically with the INSERT INTO function. INSERT INTO gives a Duplicate entry with MySQL. Thanks, Nick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
need function available for CF and JS
I have a cold fusion function that is used by other CF functions. I've found that a JS function now needs it.Should I just duplicate it for JS or can it use the CF function?I'd hate to dup it cause it's the only place where ajs function needs it. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
Kenneth, 1 - There is nothing up front - this is a risk on my part as well, however, I developed the application for my own use within my own company, and so I never expected to have an opportunity to license it and sell subscriptions to it.I don't have the time, nor the desire, to do all the marketing, let alone end user support, so I'm pretty okay without getting anything up front as long as I'm getting a fair deal on the percentage. 2 - no hourly pay - I'm agreeing to keep the software up to date as part of the agreement, however, it would be for a specific period of time, not indefinitely. 3 - 30% on All Revenue of the company, period.so that would include any customization charges they pass on to their customer (or an increase in monthly subscription rate for that customization for example). Thanks for your input. Dave From: Kenneth Wilson [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:20 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application 1) Are they paying you enough up front to make you happy in the event they never sell it to anyone? 2) Are they paying you hourly for your support efforts or are you on the hook to train them indefinitely regardless of their sales volume? 3)Is the 30% on customization work over and above what you charge to do the work? Or do you just get 30% of whatever they choose to charge for customization? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: QofQ problem -closing in on the problem..
I'll put money on it that it's the Excel that's causing the problem Once had to do an app that was to use the client's existing Excel based inventory control (don't ask).Thing was, when I connected to the spreadsheet via a datasource it would randomly chuck away data and also had horrible problems with datatypes and database insertion.In end had to build an Access inventory control database for him to upload onto web server. Have you tried doing it without the Excel in the equation? Also, forcing all Postcodes to be Strings (even through CF's meant to be a typeless language) I'll bet you have tried all these before tho. soz, not got any more ideas -- dc -Original Message- From: Michael Kear [mailto:[EMAIL PROTECTED] Sent: 07 June 2004 16:12 To: CF-Talk Subject: RE: QofQ problem -closing in on the problem.. Thanks for your input Peter.This is not an input problem.Yes, they need to do better data validation and that's another task I'm going to suggest they need to do, but this is about queries notinput. I have 3 queries on SQLServer tables, and one on a Excel spreadsheet, each containing a field called Postcode which is a varchar field in the SQLServer, and has mostly numbers and some letters in the spreadsheet. I am combining the four queries by looping over them and writing the output to a query built by CFMX.Then I'm doing a query of a query to de-duplicate the records, and sort them. That's where the application gives an error when it encounters a postcode field with non-numeric content. I can't see why that should matter. I'm not doing math on the field, I'm not sorting on it.It's just a field, like name, suburb, country, email address .. all the others.I cant see why it matters whether the contents of the Postcode field are numbers or letters or dancing pigeons. At the point where it throws the error, it's not trying to insert into a database, or perform arithmetic, just SELECT in the Query of aQuery. But if there's a postcode field containing NA the whole thing hiccups. WTF?? Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com _ From: Peter Tilbrook [mailto:[EMAIL PROTECTED] Sent: Tuesday, 8 June 2004 12:14 AM To: CF-Talk Subject: RE: QofQ problem -closing in on the problem.. Mike, if using CF use the CFINPUT and use validatenumeric or at least integer. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: need function available for CF and JS
I have a cold fusion function that is used by other CF functions. I've found that a JS function now needs it. Should I just duplicate it for JS or can it use the CF function? I'd hate to dup it cause it's the only place where ajs function needs it. Client-side _javascript_ run within a browser cannot directly invoke a function written in CF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Autoincrement feature with MySQL?
Create the table as follows: CREATE TABLE my_table ( id int(6) NOT NULL auto_increment, ) What interface/client are you using for mysql? if you can install something that runs on PHP, I recomend http://www.phpmyadmin.net/home_page/ I know it is PHP and I shall be shunned upon by the list, but it is a great way to manage mySQL db's I hope that helps Does anyone know how do you get the autoincrement feature with MySQL -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: need function available for CF and JS
Client-side _javascript_ run within a browser cannot directly invoke a function written in CF. ah that makes total sense, said that way : ) And can I guess that the server-side CF, won't call a client-side JS function?I guess I can validate this form in CF, but I'd still like to have the JS alerts rather than go to another page, just to say hey fill in the header, guy!. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
I would suggest making sure you legally define what Support means very explicitly so it's not left up to them to define how much of your time is invested on an ongoing basis. Likewise, you might want to specify a minimum hourly rate for customization work so you can ensure that your 30% makes it worth the effort. While they will want to make as much as possible on customization, suppose they agree to a major undertaking for a client and specify $50/hour for the work. Are you happy making $15/hour for that effort? And who owns the rights to the new functionality? Can it then be resold to others? Ken -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:26 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application Kenneth, 1 - There is nothing up front - this is a risk on my part as well, however, I developed the application for my own use within my own company, and so I never expected to have an opportunity to license it and sell subscriptions to it.I don't have the time, nor the desire, to do all the marketing, let alone end user support, so I'm pretty okay without getting anything up front as long as I'm getting a fair deal on the percentage. 2 - no hourly pay - I'm agreeing to keep the software up to date as part of the agreement, however, it would be for a specific period of time, not indefinitely. 3 - 30% on All Revenue of the company, period.so that would include any customization charges they pass on to their customer (or an increase in monthly subscription rate for that customization for example). Thanks for your input. Dave From: Kenneth Wilson [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:20 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application 1) Are they paying you enough up front to make you happy in the event they never sell it to anyone? 2) Are they paying you hourly for your support efforts or are you on the hook to train them indefinitely regardless of their sales volume? 3)Is the 30% on customization work over and above what you charge to do the work? Or do you just get 30% of whatever they choose to charge for customization? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I don't even know what I need to be able to do this...[fdf/cf]
-Original Message- From: Jeff Small Sent: Monday, June 07, 2004 9:49 AM To: CF-Talk Subject: Re: I don't even know what I need to be able to do this...[fdf/cf] Okay, so lemme get this straight. I could have the PDF data submitted to a CF page that could process it and enter it into a database table. Then, a CFQUERY tag could generate output that could be saved as an FDF. I've never processed the acrobat form data, but from what I understand, they're just standard form fields How does the end user (the client) see the PDF File? Does she click on a CF link that does all the work? So she clicks on CreatePDF.cfm or whatever, and the result, is that a populated PDF form opens in her browser window? The client could see a link to a prepopulated fdf file, or they could see a link to cfm template that serves up the fdf file via cfcontent. Inside the fdf file is a link pointing back to the pdf file. And if she has Acrobat Pro, she can just save it? You can save the FDF file which when clicked will open acrobat and populate the remote pdf form with data.I don't know if you can save the pdf file with the data stored in it or not.I don't have acrobat here to test it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
which prog language would be the best choice for ...
What programming language would be best for this type of application? I'm looking at Visual Basic 6, VB.net, Java or C++ Requirements == Wide Distrubution ( ie. the most platforms possible ) Medium Learning Curve. End User ease of use. ( Good UI ) Desktop performance not a big issue as the application will be doing mostly online work. Must be able to access the desktop(s) printing features. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
You also need to get the term revenue defined.Generally, it is accepted to mean gross sales, but not always.As a matter of fact, I've been told that the US Accounting Standards defines revenue as commission on sales. A good example is that in the US: revenue = gross sales profit = gross sales - expenses But in the UK: turnover = gross sales revenue = gross sales - expenses This can be a BIG difference.I would think that a lawyer would bring this point up, but you never know. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:26 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application Kenneth, 1 - There is nothing up front - this is a risk on my part as well, however, I developed the application for my own use within my own company, and so I never expected to have an opportunity to license it and sell subscriptions to it.I don't have the time, nor the desire, to do all the marketing, let alone end user support, so I'm pretty okay without getting anything up front as long as I'm getting a fair deal on the percentage. 2 - no hourly pay - I'm agreeing to keep the software up to date as part of the agreement, however, it would be for a specific period of time, not indefinitely. 3 - 30% on All Revenue of the company, period.so that would include any customization charges they pass on to their customer (or an increase in monthly subscription rate for that customization for example). Thanks for your input. Dave From: Kenneth Wilson [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:20 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application 1) Are they paying you enough up front to make you happy in the event they never sell it to anyone? 2) Are they paying you hourly for your support efforts or are you on the hook to train them indefinitely regardless of their sales volume? 3)Is the 30% on customization work over and above what you charge to do the work? Or do you just get 30% of whatever they choose to charge for customization? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Keyword Lookup
Have the keywordId as value of your dropdown. This will give you a list of keywordID Dan use a loop in your sql cfset aKeyword = ListToArray(form.keywordID) cfset max = ArrayLen(aKeyword) cfquery name=qMyQuery datasource=#request.dsn# SELECT e.symbol, e.equityID FROM equities AS e cfloop from=1 to=#max# index=i INNER JOIN keyword_equity_join as kej#i# ON e.equityID = kej#i#.equityID /cfloop WHERE 0 = 0 cfloop from=1 to=#max# index=i AND kej#i#.keywordID = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#aKeyword[i]# /cfloop /cfquery OR cfquery name=qMyQuery datasource=#request.dsn# SELECT e.symbol, e.equityID FROM equities AS e WHERE e.equityID IN ( SELECT equityID, COUNT(equityID) FROM keyword_equity_join WHERE keywordID IN (cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#form.keywordID# list=Yes) GROUP BY equityID HAVING COUNT(equityID) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#ListLen(form.keywordID)# ) /cfquery (but you can't have duplicate keywordid in the last one) Pascal -Original Message- From: Won Lee [mailto:[EMAIL PROTECTED] Sent: maandag 7 juni 2004 17:05 To: CF-Talk Subject: SQL: Keyword Lookup Hello, Have 3 tables. equities equityID symbol keywords keywordID keyword keyword_equity_join keID equityID keywordID The user selects from a dropdown list a keyword The user may then add another dropdown list to select another keyword. The user may add as many dropdown list as he or she wants. When the user clicks on the submit button I have a list of keywords. If the keywords happen to be: technology, consulting. I want the query to return only the symbols that have both technology and consulting as associated keywords. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: need function available for CF and JS
Daniel, You will need to duplicate the functionality.CFML functions only execute on the server - building the page._javascript_ functions run in the browser once the page is built and sent to the client. Now depending upon your needs you can use CFML to build your JS function... rish -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:20 AM To: CF-Talk Subject: need function available for CF and JS I have a cold fusion function that is used by other CF functions. I've found that a JS function now needs it.Should I just duplicate it for JS or can it use the CF function?I'd hate to dup it cause it's the only place where ajs function needs it. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: need function available for CF and JS
You can't use a CF function in JS. Different syntax You have to duplicate it (and adapt it to JS). Pascal -Original Message- From: Daniel Kessler [mailto:[EMAIL PROTECTED] Sent: maandag 7 juni 2004 17:20 To: CF-Talk Subject: need function available for CF and JS I have a cold fusion function that is used by other CF functions. I've found that a JS function now needs it.Should I just duplicate it for JS or can it use the CF function?I'd hate to dup it cause it's the only place where ajs function needs it. thanks. -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD20742-2611 301-405-2545 Phone www.phi.umd.edu [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
ColdFusion TechNote Notification: Maximum JVM heap size greater than 1.8GB will prevent ColdFusion MX from starting
Check out the new TechNote at: http://www.macromedia.com/support/coldfusion/ts/documents/max_jvm_heap.htm [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: which prog language would be the best choice for ...
Java or C++.Either can run on any platform, although C++ will have to be compiled on the targeted platform before release.Java is easier to learn than C++, but there are some pretty good windowing libraries in C that will take a bit of the learning curve out of C++.You need to have a solid understanding of Object-Oriented Programming for either, though.The Java GUI libraries seem to run pretty slow and feel clunky unless you're experienced working with them. VB6 is pretty much right out of the question is platform portability is a requirement, but it's REALLY easy to learn.I generally use VB6 to prototype my C programs.It's great for that. -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:45 AM To: CF-Talk Subject: which prog language would be the best choice for ... What programming language would be best for this type of application? I'm looking at Visual Basic 6, VB.net, Java or C++ Requirements == Wide Distrubution ( ie. the most platforms possible ) Medium Learning Curve. End User ease of use. ( Good UI ) Desktop performance not a big issue as the application will be doing mostly online work. Must be able to access the desktop(s) printing features. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: I don't even know what I need to be able to do this...[fdf/cf]
I've never processed the acrobat form data, but from what I understand, they're just standard form fields Okay, that's easy enough to figure out. The client could see a link to a prepopulated fdf file, or they could see a link to cfm template that serves up the fdf file via cfcontent. Inside the fdf file is a link pointing back to the pdf file. Which, if I'm understanding you correctly, just opens the PDF that the FDF file points to, and in the person's browser window, they see the PDF with the populated form data. And if she has Acrobat Pro, she can just save it? You can save the FDF file which when clicked will open acrobat and populate the remote pdf form with data.I don't know if you can save the pdf file with the data stored in it or not.I don't have acrobat here to test it. I think *that's* the difference between Acrobat and Acrobat Reader. If you have Acrobat you can save the PDF with the form data intact, and rename it something else. If you have Reader, you can save the form, but when you open it up wherever you saved it, it doesn't retain the populated form data. Or at least that's been *my* experience. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Autoincrement feature with MySQL?
I'm pretty sure someone on this list has created a CFMyAdmin program... -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:32 AM To: CF-Talk Subject: Re: Autoincrement feature with MySQL? Create the table as follows: CREATE TABLE my_table ( id int(6) NOT NULL auto_increment, ) What interface/client are you using for mysql? if you can install something that runs on PHP, I recomend http://www.phpmyadmin.net/home_page/ I know it is PHP and I shall be shunned upon by the list, but it is a great way to manage mySQL db's I hope that helps Does anyone know how do you get the autoincrement feature with MySQL -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Keyword Lookup
Error in the 2nd option : SELECT equityID FROM keyword_equity_join -Original Message- From: Pascal Peters Sent: maandag 7 juni 2004 17:52 To: CF-Talk Subject: RE: Keyword Lookup cfquery name=qMyQuery datasource=#request.dsn# SELECT e.symbol, e.equityID FROM equities AS e WHERE e.equityID IN ( SELECT equityID, COUNT(equityID) FROM keyword_equity_join WHERE keywordID IN (cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#form.keywordID# list=Yes) GROUP BY equityID HAVING COUNT(equityID) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#ListLen(form.keywordID)# ) /cfquery (but you can't have duplicate keywordid in the last one) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: which prog language would be the best choice for ...
Thanks Ryan... - Original Message - From: Hagan, Ryan Mr (Contractor ACI) To: CF-Talk Sent: Monday, June 07, 2004 11:56 AM Subject: RE: which prog language would be the best choice for ... Java or C++.Either can run on any platform, although C++ will have to be compiled on the targeted platform before release.Java is easier to learn than C++, but there are some pretty good windowing libraries in C that will take a bit of the learning curve out of C++.You need to have a solid understanding of Object-Oriented Programming for either, though.The Java GUI libraries seem to run pretty slow and feel clunky unless you're experienced working with them. VB6 is pretty much right out of the question is platform portability is a requirement, but it's REALLY easy to learn.I generally use VB6 to prototype my C programs.It's great for that. -Original Message- From: Daniel Farmer [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:45 AM To: CF-Talk Subject: which prog language would be the best choice for ... What programming language would be best for this type of application? I'm looking at Visual Basic 6, VB.net, Java or C++ Requirements == Wide Distrubution ( ie. the most platforms possible ) Medium Learning Curve. End User ease of use. ( Good UI ) Desktop performance not a big issue as the application will be doing mostly online work. Must be able to access the desktop(s) printing features. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I don't even know what I need to be able to do this...[fdf/cf]
I think *that's* the difference between Acrobat and Acrobat Reader. If you have Acrobat you can save the PDF with the form data intact, and rename it something else. If you have Reader, you can save the form, but when you open it up wherever you saved it, it doesn't retain the populated form data. Or at least that's been *my* experience. There used to be an intermediate product circa 2000 that was between Acrobat Reader and the full Acrobat, that would allow a user to save and use the FDF forms, but did not have all the authoring tools of the full product to create new PDF documents.IIRC it was priced about $100 as opposed the $300 of the full Acrobat application. HTH -- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA C code. C code run. Run code run. Please! - Cynthia Dunning Confidentiality Notice:This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Autoincrement feature with MySQL?
And it would have been really nice of me to take a half-second to look that up before I hit send...sorry: http://www.cfmyadmin.com/ http://www.cfmyadmin.com/ -Original Message- From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:59 AM To: CF-Talk Subject: RE: Autoincrement feature with MySQL? I'm pretty sure someone on this list has created a CFMyAdmin program... -Original Message- From: Mark Drew [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:32 AM To: CF-Talk Subject: Re: Autoincrement feature with MySQL? Create the table as follows: CREATE TABLE my_table ( id int(6) NOT NULL auto_increment, ) What interface/client are you using for mysql? if you can install something that runs on PHP, I recomend http://www.phpmyadmin.net/home_page/ I know it is PHP and I shall be shunned upon by the list, but it is a great way to manage mySQL db's I hope that helps Does anyone know how do you get the autoincrement feature with MySQL -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] _ _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: I don't even know what I need to be able to do this...[fdf/cf]
-Original Message- From: Jeff Small Sent: Monday, June 07, 2004 10:58 AM To: CF-Talk Subject: Re: I don't even know what I need to be able to do this...[fdf/cf] The client could see a link to a prepopulated fdf file, or they could see a link to cfm template that serves up the fdf file via cfcontent. Inside the fdf file is a link pointing back to the pdf file. Which, if I'm understanding you correctly, just opens the PDF that the FDF file points to, and in the person's browser window, they see the PDF with the populated form data. Yes, this is correct [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Autoincrement feature with MySQL?
Hi there! Thanks for that, I shall check it out! I just wanted to mention that I use the phpmysqladmin a lot .. will let you know what I think of the CF version :) http://www.cfmyadmin.com/ http://www.cfmyadmin.com/ -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
I would suggest making sure the legal wording specifies a revenue sharing arrangement as opposed to 30% ownership of the company. Make the wording so that they paying you monthly. Also make sure that if the company is ever sold the successor must honor your agreement. You don't want to be strung along for months or years without seeing a dime because they weren't profitable. They may decide to spend a bunch of money setting up a new office causing their profit margin to drop. Just make sure that doesn't affect your payments. Steve Nelson _ From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
Thanks for the good points.Yes, I definitely want the US version of revenue.I'll make sure it's clear in the contract. Thanks, Dave From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:51 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application You also need to get the term revenue defined.Generally, it is accepted to mean gross sales, but not always.As a matter of fact, I've been told that the US Accounting Standards defines revenue as commission on sales. A good example is that in the US: revenue = gross sales profit = gross sales - expenses But in the UK: turnover = gross sales revenue = gross sales - expenses This can be a BIG difference.I would think that a lawyer would bring this point up, but you never know. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:26 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application Kenneth, 1 - There is nothing up front - this is a risk on my part as well, however, I developed the application for my own use within my own company, and so I never expected to have an opportunity to license it and sell subscriptions to it.I don't have the time, nor the desire, to do all the marketing, let alone end user support, so I'm pretty okay without getting anything up front as long as I'm getting a fair deal on the percentage. 2 - no hourly pay - I'm agreeing to keep the software up to date as part of the agreement, however, it would be for a specific period of time, not indefinitely. 3 - 30% on All Revenue of the company, period.so that would include any customization charges they pass on to their customer (or an increase in monthly subscription rate for that customization for example). Thanks for your input. Dave From: Kenneth Wilson [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:20 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application 1) Are they paying you enough up front to make you happy in the event they never sell it to anyone? 2) Are they paying you hourly for your support efforts or are you on the hook to train them indefinitely regardless of their sales volume? 3)Is the 30% on customization work over and above what you charge to do the work? Or do you just get 30% of whatever they choose to charge for customization? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Autoincrement feature with MySQL?
RE: CFMYADMIN I had a quick check and install (how quick was that?!!) only thing that it has missing which I LOVE in phpmyadmin is the ability to export (to XML, CSV, SQL including Structure and/or Data) But that is now off topic (and my last 2 cents/pennies) -- Mark Drew http://cybersonic.blogspot.com mailto:[EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MacOSX email clients (was Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors)
very strange.Experiences may vary I suppose.Only problem I have very occasionally is having to force it to quit.But that's like 1-2% of the time. -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:18 AM To: CF-Talk Subject: Re: MacOSX email clients (was Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors) On Jun 7, 2004, at 11:13 AM, Josh Remus wrote: I love Thunderbird on OSX, so I'm wondering what sort of issues you've had w/ this?? _Constant_ crashes when sending email.99% of the time it would crash after writing an email.I couldn't live with that and shouldn't have put up with it for so long (a month) before dumping that zero and getting myself a, uh, Mail client ;) -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: need function available for CF and JS
You can't use a CF function in JS. Different syntax You have to duplicate it (and adapt it to JS). that's not exactly what I meant.I meant to call the js function from cf, but others have told me that this isn't doable or practicle.Really I just wanted the js alerts. Still, duplicating the cf function in js is almost a drop'n'play.Since it's written in an ecma like script, all I really need to do is to change the EQ to == (and such) and adjust the names of any api calls - createDateTime() becomes Date(). thanks for answering Pascal, Dave and everyone. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Question about Licensing my CF Web Application
You may also want to make sure that you still retain ownership of the code or at least unrestricted rights to use the code if the company should fold up in a month or two and want to take the code with them. Mark W. Breneman -Cold Fusion Developer -Network Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 _ From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: Keyword Lookup
At 18:03 6/7/2004 +0200, you wrote: Error in the 2nd option : SELECT equityID FROM keyword_equity_join -Original Message- From: Pascal Peters Sent: maandag 7 juni 2004 17:52 To: CF-Talk Subject: RE: Keyword Lookup cfquery name=qMyQuery datasource=#request.dsn# SELECT e.symbol, e.equityID FROM equities AS e WHERE e.equityID IN ( SELECT equityID, COUNT(equityID) FROM keyword_equity_join WHERE keywordID IN (cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#form.keywordID# list=Yes) GROUP BY equityID HAVING COUNT(equityID) = cfqueryparam cfsqltype=CF_SQL_NUMERIC value=#ListLen(form.keywordID)# ) /cfquery Will have a look at this.Thanks for putting me on the right direction. =) [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: need function available for CF and JS
do you mean this. Pat cfoutput function new_fnc() { ..more _javascript_ code . ... alert('#cf_variable#'); return true; } // end of new_fnc. /cfoutput -Original Message- From: daniel kessler [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 12:32 PM To: CF-Talk Subject: Re: need function available for CF and JS You can't use a CF function in JS. Different syntax You have to duplicate it (and adapt it to JS). that's not exactly what I meant.I meant to call the js function from cf, but others have told me that this isn't doable or practicle.Really I just wanted the js alerts. Still, duplicating the cf function in js is almost a drop'n'play.Since it's written in an ecma like script, all I really need to do is to change the EQ to == (and such) and adjust the names of any api calls - createDateTime() becomes Date(). thanks for answering Pascal, Dave and everyone. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: MacOSX email clients (was Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors)
Weird.I switched to Thunderbird after Mail started crashing every time it filtered junk mail, and haven't had any problems.I even went back and tried Mail again a couple months ago, and same issue.To each his own, I guess. Cheers, barneyb -Original Message- From: Damien McKenna [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 8:18 AM To: CF-Talk Subject: Re: MacOSX email clients (was Re: ColdFusion TechNote Notification: ColdFusion MX: Returning large character data record sets causes server instability and Out of Memory e rrors) On Jun 7, 2004, at 11:13 AM, Josh Remus wrote: I love Thunderbird on OSX, so I'm wondering what sort of issues you've had w/ this?? _Constant_ crashes when sending email.99% of the time it would crash after writing an email.I couldn't live with that and shouldn't have put up with it for so long (a month) before dumping that zero and getting myself a, uh, Mail client ;) -- Damien McKenna - Web Developer - [EMAIL PROTECTED] The Limu Company - http://www.thelimucompany.com/ - 407-804-1014 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: need function available for CF and JS
And can I guess that the server-side CF, won't call a client-side JS function? That's correct. I guess I can validate this form in CF, but I'd still like to have the JS alerts rather than go to another page, just to say hey fill in the header, guy!. It sounds to me like you want to have _javascript_ form validation for user-friendliness and convenience, and server-side form validation for security and robustness. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: 202-797-5496 fax: 202-797-5444 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can anyone tell me what this error means?
whoops... sorry about that... when trying to set a variable: cfset variable.lt = ³³ I get this error: Detail: Problem occurred while parsing variables.lt = ³³ Extended Info: Encountered ³ltWas expecting one of: FLOATING_POINT_LITERAL ... STRING_LITERAL ... BOOLEAN_LITERAL ... IDENTIFIER ... ³(³ ... ³+² ... ³INTEGER_LITERAL I¹m running Blue Dragon Server 6.1 and MySQL on a linux box. Any ideas? BZaccheo On 6/4/04 5:32 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: an error huh? eenie meenie, minie moe, please describe the error so we all know.. ;)~ Hi all... I¹m trying to set-up a cold fusion application I purchased not to long ago... I¹m running Blue Dragon Server 6.1 and MySQL on a linux box. When I run the application I keep getting an error I¹m not familiar with. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: which prog language would be the best choice for ...
If you are planning on selling a significant number of the application, it may be possible to write it in CFML. 1) runs on any popular platform -- Win, 'Nix, Mac. 2) no learning curve (if you already know CFML) 3) Familiar UI -- the user's browser of choice 4) Good desktop performance -- good online performance interface capabilities 5) Can access desktop files/facilities with shell scripts, OSA Scripting, etc. via CFExecute. You can run a db server, web server, servlet engine, CF Application Server, CF Apps, -- in other words everything from a CD-ROM and/or on the desktop.I used BlueDragon J2ee but you should be able to use CFMX J2ee. or Ralio. I don't know if Macromedia is interested in distribution model, but NewAtlanta people have expressed a willingness to work with anyone interested in distributing applications this way. If you think this would apply to your needs, I'd sure like to hear about it! HTH Dick On Jun 7, 2004, at 8:45 AM, Daniel Farmer wrote: What programming language would be best for this type of application? I'm looking at Visual Basic 6, VB.net, Java or C++ Requirements == Wide Distrubution ( ie. the most platforms possible ) Medium Learning Curve. End User ease of use. ( Good UI ) Desktop performance not a big issue as the application will be doing mostly online work. Must be able to access the desktop(s) printing features. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question about Licensing my CF Web Application
What does this app do?What happens if this app was buggy somehow, and screws the client, and they lose $$.Who is at fault? - Original Message - From: Dave Phillips To: CF-Talk Sent: Monday, June 07, 2004 11:26 AM Subject: RE: Question about Licensing my CF Web Application Thanks for the good points.Yes, I definitely want the US version of revenue.I'll make sure it's clear in the contract. Thanks, Dave From: Hagan, Ryan Mr (Contractor ACI) [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:51 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application You also need to get the term revenue defined.Generally, it is accepted to mean gross sales, but not always.As a matter of fact, I've been told that the US Accounting Standards defines revenue as commission on sales. A good example is that in the US: revenue = gross sales profit = gross sales - expenses But in the UK: turnover = gross sales revenue = gross sales - expenses This can be a BIG difference.I would think that a lawyer would bring this point up, but you never know. -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:26 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application Kenneth, 1 - There is nothing up front - this is a risk on my part as well, however, I developed the application for my own use within my own company, and so I never expected to have an opportunity to license it and sell subscriptions to it.I don't have the time, nor the desire, to do all the marketing, let alone end user support, so I'm pretty okay without getting anything up front as long as I'm getting a fair deal on the percentage. 2 - no hourly pay - I'm agreeing to keep the software up to date as part of the agreement, however, it would be for a specific period of time, not indefinitely. 3 - 30% on All Revenue of the company, period.so that would include any customization charges they pass on to their customer (or an increase in monthly subscription rate for that customization for example). Thanks for your input. Dave From: Kenneth Wilson [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:20 AM To: CF-Talk Subject: RE: Question about Licensing my CF Web Application 1) Are they paying you enough up front to make you happy in the event they never sell it to anyone? 2) Are they paying you hourly for your support efforts or are you on the hook to train them indefinitely regardless of their sales volume? 3)Is the 30% on customization work over and above what you charge to do the work? Or do you just get 30% of whatever they choose to charge for customization? -Original Message- From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 11:05 AM To: CF-Talk Subject: Question about Licensing my CF Web Application Hi all, I have developed a web application and have found a company that is wanting an exclusive license to manage, market, and sell subscriptions to my web application for me.I'm comfortable with the arrangement, but I'm unsure as to what to charge as a license fee. I have gotten them to agree to allow me to earn a royalty based on a percentage of the revenue they charge for each subscription.The number that has been thrown out is 30%.So for example, if they sell a subscription for $10 per month, I get $3 per month and they get the rest. I do not have to put up any money.I will be continuing to develop and enhance the application as well as supporting it technically.However, I will not be providing END USER support.I will provide support to the company that is marketing it.They will deal with the end users. I will also make myself available to customize the application for any of their customers, however, I'm sure they will charge extra for this, so in essence, I will get extra since I would get 30% of the revenue. My questions are as follows: 1.Is 30% a fair amount?What's the standard? 2.Does it sound like a good deal to you?Is there anything I should be asking for that I haven't mentioned? 3.Any other comments/suggestions? Thanks for your input.I welcome it.This is the first time I've had the privelege to do this, so I'm very excited, but want to be sure I do it the right way. Sincerely, Dave Phillips [EMAIL PROTECTED] _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Question about Licensing my CF Web Application
I would want to put caps on the amount of support you have to provide (for free), even if it is as 160 hours a month.I would also want a cap on the amount of new development you are required to do the application. They want exclusive licensing rights which means you can't license this to anyone else.I would ask for 50% of all gross revenues. Realistically, though, in a book contract or music recording contract you'd be lucky to get 15% of gross revenues; however both of those contracts offer an advance.If you're not getting one there is nothing wrong w/ asking for more. When the agreement ends, make sure the code transfers back to you and they have no rights to re-license, etc.. If you have a 1 year contract, what happens when they go out of business in 3 months?Do you have the right to audit their books?I'd ask for it.It'd only be worth the expense if they were selling millions of subscriptions. As always, have a lawyer read over all documents.The person who said a notary public should witness the document signing has a very good point. At 01:03 PM 6/7/2004, you wrote: Subject: Question about Licensing my CF Web Application From: Dave Phillips [EMAIL PROTECTED] Date: Mon, 7 Jun 2004 11:26:03 -0400 Thread: http://www.houseoffusion.com/cf_lists/index.cfm/method=messagesthreadid=33023forumid=4#165663 Kenneth, 1 - There is nothing up front - this is a risk on my part as well, however, I developed the application for my own use within my own company, and so I never expected to have an opportunity to license it and sell subscriptions to it.I don't have the time, nor the desire, to do all the marketing, let alone end user support, so I'm pretty okay without getting anything up front as long as I'm getting a fair deal on the percentage. 2 - no hourly pay - I'm agreeing to keep the software up to date as part of the agreement, however, it would be for a specific period of time, not indefinitely. 3 - 30% on All Revenue of the company, period.so that would include any customization charges they pass on to their customer (or an increase in monthly subscription rate for that customization for example). Thanks for your input. Dave -- Jeffry Houser, Web Developer, Writer, Songwriter, Recording Engineer mailto:[EMAIL PROTECTED] -- AIM: Reboog711| Phone: 1-203-379-0773 -- My Books: http://www.instantcoldfusion.com Recording Music: http://www.fcfstudios.com Original Energetic Acoustic Rock: http://www.farcryfly.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
how to re-query a cfquery?
I have a query at the beginning of my CF page that gets the registration info of a certain user... cfoutput cfquery name=getreginfo datasource=#application.dns_name# dbtype=ODBC SELECT * FROM Users WHERE username = '#form.username#' /cfquery /cfoutput later on in the page, i use this statement to update the user's details, based on details they give upon renewing their subscription... cfupdate datasource=#application.dns_name# tablename=Users formfields=MonthsSubscribed,user_ID,pointsremaining, PointsExpireDate,subtype,accesslevel then i send out an email to admin telling the user details...problem is, i want it to give the NEW user details, as updated in the database above.it sends out an email with the OLD user data, before update.i guess since the query is done as soon as the page loads. is there a way i can re-query the user database just before i send out the admin email? does this make sense?ask me for more details if necessary. :) thanks! christy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: which prog language would be the best choice for ...
Dick, Actually I don't know why I didn't consider this option Thanks for you input. I may use CF on the desktop. ( Coral ) ? - Original Message - From: Dick Applebaum To: CF-Talk Sent: Monday, June 07, 2004 12:50 PM Subject: Re: which prog language would be the best choice for ... If you are planning on selling a significant number of the application, it may be possible to write it in CFML. 1) runs on any popular platform -- Win, 'Nix, Mac. 2) no learning curve (if you already know CFML) 3) Familiar UI -- the user's browser of choice 4) Good desktop performance -- good online performance interface capabilities 5) Can access desktop files/facilities with shell scripts, OSA Scripting, etc. via CFExecute. You can run a db server, web server, servlet engine, CF Application Server, CF Apps, -- in other words everything from a CD-ROM and/or on the desktop.I used BlueDragon J2ee but you should be able to use CFMX J2ee. or Ralio. I don't know if Macromedia is interested in distribution model, but NewAtlanta people have expressed a willingness to work with anyone interested in distributing applications this way. If you think this would apply to your needs, I'd sure like to hear about it! HTH Dick On Jun 7, 2004, at 8:45 AM, Daniel Farmer wrote: What programming language would be best for this type of application? I'm looking at Visual Basic 6, VB.net, Java or C++ Requirements == Wide Distrubution ( ie. the most platforms possible ) Medium Learning Curve. End User ease of use. ( Good UI ) Desktop performance not a big issue as the application will be doing mostly online work. Must be able to access the desktop(s) printing features. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: how to re-query a cfquery?
Simply do another Query to the DB for the new info -Original Message- From: Christy [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 12:55 PM To: CF-Talk Subject: how to re-query a cfquery? I have a query at the beginning of my CF page that gets the registration info of a certain user... cfoutput cfquery name=getreginfo datasource=#application.dns_name# dbtype=ODBC SELECT * FROM Users WHERE username = '#form.username#' /cfquery /cfoutput later on in the page, i use this statement to update the user's details, based on details they give upon renewing their subscription... cfupdate datasource=#application.dns_name# tablename=Users formfields=MonthsSubscribed,user_ID,pointsremaining, PointsExpireDate,subtype,accesslevel then i send out an email to admin telling the user details...problem is, i want it to give the NEW user details, as updated in the database above.it sends out an email with the OLD user data, before update.i guess since the query is done as soon as the page loads. is there a way i can re-query the user database just before i send out the admin email? does this make sense?ask me for more details if necessary. :) thanks! christy _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can anyone tell me what this error means?
Original Message: From: Butch Zaccheo cfset variable.lt = ³³ I get this error: Detail: Problem occurred while parsing variables.lt = ³³ It's trying to evaluate ³³ and it can't.If you want to set variable.lt to be the string ³³ then you need the quotes (cfset variable.lt = ³³ (Note, variable isn't a scope within CF. I think you want variables.lt) If you are trying to set variable.lt to actually evaluate ³³ andto be true then you could do: cfset variables.lt = Evaluate(³ LT ³) It kind of depends on what you're trying to do with the line: cfset variable.lt = ³³ --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: how to re-query a cfquery?
You can just rerun the query, after the update, so you get the new information.Though since you already have all the info in the request's FORM variables, why not just use those to build the notification email? Cheers, barneyb -Original Message- From: Christy [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 9:55 AM To: CF-Talk Subject: how to re-query a cfquery? I have a query at the beginning of my CF page that gets the registration info of a certain user... cfoutput cfquery name=getreginfo datasource=#application.dns_name# dbtype=ODBC SELECT * FROM Users WHERE username = '#form.username#' /cfquery /cfoutput later on in the page, i use this statement to update the user's details, based on details they give upon renewing their subscription... cfupdate datasource=#application.dns_name# tablename=Users formfields=MonthsSubscribed,user_ID,pointsremaining, PointsExpireDate,subtype,accesslevel then i send out an email to admin telling the user details...problem is, i want it to give the NEW user details, as updated in the database above.it sends out an email with the OLD user data, before update.i guess since the query is done as soon as the page loads. is there a way i can re-query the user database just before i send out the admin email? does this make sense?ask me for more details if necessary. :) thanks! christy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IsDefined(Array[element])
how to check is the array element is defined or not cfif IsDefined('lineout[#xyz#]') according to the coldfusion documentation it will always return false, no matter even the element has a value. what is the alternate value to see that the element has a value or undefined. thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IsDefined(Array[element])
how to check is the array element is defined or not cfif IsDefined('lineout[#xyz#]') according to the coldfusion documentation it will always return false, no matter even the element has a value. what is the alternate way to see that the element has a value or undefined. thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: how to re-query a cfquery?
thank you!good idea, barney. i'm a CF newbie - right now, just trying to fix the code of the person doing it before me.a, so much to learn :) thanks to everyone who answered my question - it works now! christy --- Barney Boisvert [EMAIL PROTECTED] wrote: You can just rerun the query, after the update, so you get the new information.Though since you already have all the info in the request's FORM variables, why not just use those to build the notification email? Cheers, barneyb -Original Message- From: Christy [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 9:55 AM To: CF-Talk Subject: how to re-query a cfquery? I have a query at the beginning of my CF page that gets the registration info of a certain user... cfoutput cfquery name=getreginfo datasource=#application.dns_name# dbtype=ODBC SELECT * FROM Users WHERE username = '#form.username#' /cfquery /cfoutput later on in the page, i use this statement to update the user's details, based on details they give upon renewing their subscription... cfupdate datasource=#application.dns_name# tablename=Users formfields=MonthsSubscribed,user_ID,pointsremaining, PointsExpireDate,subtype,accesslevel then i send out an email to admin telling the user details...problem is, i want it to give the NEW user details, as updated in the database above.it sends out an email with the OLD user data, before update.i guess since the query is done as soon as the page loads. is there a way i can re-query the user database just before i send out the admin email? does this make sense?ask me for more details if necessary. :) thanks! christy [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: which prog language would be the best choice for ...
-- Coral looks fine, except it is Win only -- BD 6.1 is very close to CFMX very nice on the Desktop easy install (unzip copy) no change to BD config to run on CD/Desktop fast -- apps complied to Java Byte code similar to CFMX 6.1 irreversible encryption small footprint -- 10 meg -- CFMX J2ee should work -- Have a look at Ralio-- I just started playing with it -- Java-Based. http://www.railo.ch/en/ If you can project enough unit sales to get the price per copy of BD or CFMX low enough it may be the best way for you to go --and you could (get NewAtlanta or Macromedia t0) open up the distribution model for the rest of us. If you use Jetty and an open source DB/Driver, the CF engine should be your only distro licensing cost. Dick On Jun 7, 2004, at 9:58 AM, Daniel Farmer wrote: Dick, Actually I don't know why I didn't consider this option Thanks for you input. I may use CF on the desktop. ( Coral ) ? - Original Message - From: Dick Applebaum To: CF-Talk Sent: Monday, June 07, 2004 12:50 PM Subject: Re: which prog language would be the best choice for ... If you are planning on selling a significant number of the application, it may be possible to write it in CFML. 1) runs on any popular platform -- Win, 'Nix, Mac. 2) no learning curve (if you already know CFML) 3) Familiar UI -- the user's browser of choice 4) Good desktop performance -- good online performance interface capabilities 5) Can access desktop files/facilities with shell scripts, OSA Scripting, etc. via CFExecute. You can run a db server, web server, servlet engine, CF Application Server, CF Apps, -- in other words everything from a CD-ROM and/or on the desktop. I used BlueDragon J2ee but you should be able to use CFMX J2ee. or Ralio. I don't know if Macromedia is interested in distribution model, but NewAtlanta people have expressed a willingness to work with anyone interested in distributing applications this way. If you think this would apply to your needs, I'd sure like to hear about it! HTH Dick On Jun 7, 2004, at 8:45 AM, Daniel Farmer wrote: What programming language would be best for this type of application? I'm looking at Visual Basic 6, VB.net, Java or C++ Requirements == Wide Distrubution ( ie. the most platforms possible ) Medium Learning Curve. End User ease of use. ( Good UI ) Desktop performance not a big issue as the application will be doing mostly online work. Must be able to access the desktop(s) printing features. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: IsDefined(Array[element])
Arrays are designed for sequential storage, with every item having a value. If you're going to have holes, you might consider a struct that just happens to have numeric keys.Then you can use structKeyExists. Short of that, I think you'd probably have to dereference the array index in a CFTRY..CFCATCH block, catch the error, and react to that.Wrap it in a function named 'isArrayElementDefined' or something, and you should be set. Cheers, barneyb -Original Message- From: Asim Manzur [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 10:12 AM To: CF-Talk Subject: IsDefined(Array[element]) how to check is the array element is defined or not cfif IsDefined('lineout[#xyz#]') according to the coldfusion documentation it will always return false, no matter even the element has a value. what is the alternate way to see that the element has a value or undefined. thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: Can anyone tell me what this error means?
Basically this variable is being written so I can create a right bracket for TAGS. This variable is used to create tags for a preference file. Does blue dragon have a problem with setting the character to a variable? Cold Fusion MX doesn¹t seem to have a problem with the same variable setting... BZaccheo On 6/7/04 10:02 AM, Scott Brady [EMAIL PROTECTED] wrote: Original Message: From: Butch Zaccheo cfset variable.lt = ³³ I get this error: Detail: Problem occurred while parsing variables.lt = ³³ It's trying to evaluate ³³ and it can't.If you want to set variable.lt to be the string ³³ then you need the quotes (cfset variable.lt = ³³ (Note, variable isn't a scope within CF. I think you want variables.lt) If you are trying to set variable.lt to actually evaluate ³³ andto be true then you could do: cfset variables.lt = Evaluate(³ LT ³) It kind of depends on what you're trying to do with the line: cfset variable.lt = ³³ --- Scott Brady http://www.scottbrady.net/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
Re: how to re-query a cfquery?
Well, sure. You can just code the query again after your update. But, you don't need to, as all your info is also available in your form scope. So, just use the form scope data in your cfmail tag. - Original Message - From: Christy is there a way i can re-query the user database just before i send out the admin email? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
IsDefined(Array[element])
how to check is the array element is defined or not cfif IsDefined('lineout[#xyz#]') according to the coldfusion documentation it will always return false, no matter even the element has a value. what is the alternate value to see that the element has a value or undefined. thanks. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: saving files in homesite.... slooooow!
did you look in the registry, under HKEY_CURRENT_USER\Software\Macromedia\HomeSite+? Did you find any references to invalid folders, drive mappings etc? Is it only studio thats affected, or is it anything you try and save over the network? Bert From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 07 June 2004 13:20 To: CF-Talk Subject: RE: saving files in homesite slow! wow. now that helps :) I did some network browsing tweaks found on tweakxp.com that were, ok, I guess. but not sure they did anything? tw -Original Message- From: Bert Dawson [mailto:[EMAIL PROTECTED] Sent: Monday, June 07, 2004 7:43 AM To: CF-Talk Subject: RE: saving files in homesite slow! I had similar problem a few years ago - studio slow to save files on network, but other apps fine. I think i solved it by fiddling around in the registry and clearing up references to invalid drive mappings in the Studio bit. If it wasn't in the registry then it might have been in some Studio config file, but i'm pretty sure i was the registry. Sorry i can't be more specific - as i say it was a couple of years ago, but the symptoms sound similar. HTH Bert [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]