Re: SOT - farcry CMS
- Original Message - From: Marco Antonio C. Santos [EMAIL PROTECTED] sorry for SOT... Anybody know how to run multiple sites inside only one Farcry installation? Multiple sites for one farcry installation?This is the standard way FarCry works. Send an email to [EMAIL PROTECTED] to jump on the FarCry developers mailing list -- plenty of help to get you going there. -- geoff On the road via GMail. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
What's the best way to be changing the colours of the blocks, given that they're not rectangular and all different sizes? i'd suggest a simple GIS. it also allows users to interactively query a parcel, spatially search for parcels, etc. it can be as complicated or as simple as you need. How would you do it in flash without using remoting? well i'd be concerned at the effort getting the map into flash. especially if you want background features (streams, etc.). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
Your problem is with how cf treats lists. The delimiter can't be present in a value, or it will be treated as separate elements. You will need to use a proper csv parser that allows a text qualifier (). Have you considered CFHTTP to read the csv into a query object? In a recent tread, someone suggested a Java csv parser, but I don't remember which one. Pascal -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 05:55 To: CF-Talk Subject: RE: escaping character Actually - I have just found the issue. I am using the listfix udf :- http://www.cflib.org/udf.cfm/listfix The problem is that, the string I was trying to insert actually has a single comma in the csv file:- BLEOMYCIN (BL) INJ 15,000 i.u. Is there anyway to exclude listfix from picking this up as a separate field ?? My code is: cffile action="" file=#ExpandPath('/pharma/uploads')#/Book1.csv variable=csvData !--- cfset csvData = Replace(csvData, ,,, , ,, ALL) --- cfset csvData = #listfix(csvData)# Should I be using the commented code instead Thanks again The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
I am not too sure what a proper csv parser is ? I assumed that the code: cffile action="" file=#ExpandPath('/pharma/uploads')#/Book1.csv variable=csvData was properly parsing csv data ? I am also a bit shady on exactly what is a text qualifier. I will look into CFHTTP but I don't know what you mean by reading the csv as a query object ? I will Google on ! _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Monday, 6 September 2004 6:08 PM To: CF-Talk Subject: RE: escaping character Your problem is with how cf treats lists. The delimiter can't be present in a value, or it will be treated as separate elements. You will need to use a proper csv parser that allows a text qualifier (). Have you considered CFHTTP to read the csv into a query object? In a recent tread, someone suggested a Java csv parser, but I don't remember which one. Pascal -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 05:55 To: CF-Talk Subject: RE: escaping character Actually - I have just found the issue. I am using the listfix udf :- http://www.cflib.org/udf.cfm/listfix The problem is that, the string I was trying to insert actually has a single comma in the csv file:- BLEOMYCIN (BL) INJ 15,000 i.u. Is there anyway to exclude listfix from picking this up as a separate field ?? My code is: cffile action="" file=#ExpandPath('/pharma/uploads')#/Book1.csv variable=csvData !--- cfset csvData = Replace(csvData, ,,, , ,, ALL) --- cfset csvData = #listfix(csvData)# Should I be using the commented code instead Thanks again The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Date Records
I need to pull records out that have a date stamp of less than or equal to the past 30 days.My WHERE statement would be what? WHERE lastDateEdited= past 30 days (if LONGER than 30 days, I do not want to include this record into the resultset). Oh CFMX 6.1 and SQL 2000 Thanks in advance. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
I believe this is a multilanguage issue. Check on multilanguage settings in your CF Admin if you have access. I don't see a multilanguage setting anywhere in the CF Admin panel. We are using CFMX6.1 so I'm not sure if this setting is a pre-CFMX setting. If not, please let me know where it is. Thanks. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
text qualifier
Ok - I've Googled me a text qualifier definition, so I have that under control. Has anyone had experience with Flash Remoting ? Is it possible to start to learn the basics via web tutorials ??? Any book suggestions ? I am writing a small app to handle a group of doctors having to write scripts that they owe our pharmacys'. The reason for the app is that they can owe up to 200 scripts at any one time, and they just refuse to write them. I can get a list of the scripts via a CSV file, and my intention is to allow the pharmacy to upload the CSV file via a web/flash interface, write all delimited data to a db table, and allow the doctors to log in to a secure page and grab a list of their current outstanding scripts, tick them off and generate say a 200 page pdf print job via cfxpdf. I am just wondering is it would be beneficial to learn some flash remoting to write this app. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Date Records
cfset dateminus30 = dateAdd(d, -30, now()) then... WHERE lastDateEdited= #CreateODBCDate(dateminus30)# AND lastDateEdited= #CreateODBCDate(now())# Andrew. - Original Message - From: Paul Giesenhagen [EMAIL PROTECTED] Date: Mon, 6 Sep 2004 03:32:33 -0500 Subject: Date Records To: CF-Talk [EMAIL PROTECTED] I need to pull records out that have a date stamp of less than or equal to the past 30 days.My WHERE statement would be what? WHERE lastDateEdited= past 30 days (if LONGER than 30 days, I do not want to include this record into the resultset). Oh CFMX 6.1 and SQL 2000 Thanks in advance. Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RDS Server has stopped working...
Hi Everyone. Bit of a strange on this morning. Our RDS server on our local development server appears to have stopped working, but it only appear to be via Homesite+ or CFStudio. If we try to access datasources via Homesite+ or CFStudio we get the following error message: An error occurred accessing RDS server: Error -1 occured. The operation timed out. However, I go to Windows Explorer and select Macromedia FTP RDS and then double click the development server entry it works fine and displays a directory listing of the server. So I guess the RDS server is working ok. Any ideas what the problem is? Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
The cffile just reads the file, it doesn't parse anything. A text qualifier is a character you place around text in a csv (usually ). When you have a comma in the text (surrounded by quotes), it means it is just a comma, not a delimiter. A,B,C,D == 4 elements ABCD A,B,C,D == 3 elements AB,CD A query object in cf is what you would get as a result from a cfquery. Pascal -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 10:42 To: CF-Talk Subject: RE: escaping character I am not too sure what a proper csv parser is ? I assumed that the code: cffile action="" file=#ExpandPath('/pharma/uploads')#/Book1.csv variable=csvData was properly parsing csv data ? I am also a bit shady on exactly what is a text qualifier. I will look into CFHTTP but I don't know what you mean by reading the csv as a query object ? I will Google on ! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping character
Hi Brant, Is this a one-off import or will this be a regular part of the system? - Original Message - From: Brant Winter [EMAIL PROTECTED] Date: Mon, 6 Sep 2004 18:41:36 +1000 Subject: RE: escaping character To: CF-Talk [EMAIL PROTECTED] I am not too sure what a proper csv parser is ? I assumed that the code: cffile action="" file=#ExpandPath('/pharma/uploads')#/Book1.csv variable=csvData was properly parsing csv data ? I am also a bit shady on exactly what is a text qualifier. I will look into CFHTTP but I don't know what you mean by reading the csv as a query object ? I will Google on ! _ From: Pascal Peters [mailto:[EMAIL PROTECTED] Sent: Monday, 6 September 2004 6:08 PM To: CF-Talk Subject: RE: escaping character Your problem is with how cf treats lists. The delimiter can't be present in a value, or it will be treated as separate elements. You will need to use a proper csv parser that allows a text qualifier (). Have you considered CFHTTP to read the csv into a query object? In a recent tread, someone suggested a Java csv parser, but I don't remember which one. Pascal -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 05:55 To: CF-Talk Subject: RE: escaping character Actually - I have just found the issue. I am using the listfix udf :- http://www.cflib.org/udf.cfm/listfix The problem is that, the string I was trying to insert actually has a single comma in the csv file:- BLEOMYCIN (BL) INJ 15,000 i.u. Is there anyway to exclude listfix from picking this up as a separate field ?? My code is: cffile action="" file=#ExpandPath('/pharma/uploads')#/Book1.csv variable=csvData !--- cfset csvData = Replace(csvData, ,,, , ,, ALL) --- cfset csvData = #listfix(csvData)# Should I be using the commented code instead Thanks again The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
So when you say to read the csv as a query object what exactly do you mean ?Do you mean treat the data as if it came straight out of a cfquery statement ? I am confused ! The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping character
Brant Winter wrote: So when you say to read the csv as a query object what exactly do you mean ?Do you mean treat the data as if it came straight out of a cfquery statement ? I am confused ! Pascal made a minor typo. A query object in cf is what you would get as a result from a cfquery. should read A query object in cf is what you would get as a result from a cfhttp. CFFILE will read your file into a variable in one big block. If you use CFHTTP to read your file in, it is possible to put your CSV data straight into a cfquery object.You can then loop through your query object and insert the data into the database.You should find this easier than trying to parse your CSV file manually. Have a read up on CFHTTP and you should see what Pascal is trying to say to you. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
It will be a regular transfer, almost on a daily basis. I am not sure if I am going to be able to get the other party to supply the data with double quotes and commas as in a text qualifier. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Problem with accented character in file names and CFFILE
Ok. This is driving me mad now. It works fine (e.g. does replace the accented character) on our local development server with is running CFMX6.1 / RH7.2 / Apache 1.3.27, exactly the same as the online server ahhh Andrew. On Mon, 6 Sep 2004 09:39:53 +0100, Andrew Dixon [EMAIL PROTECTED] wrote: I believe this is a multilanguage issue. Check on multilanguage settings in your CF Admin if you have access. I don't see a multilanguage setting anywhere in the CF Admin panel. We are using CFMX6.1 so I'm not sure if this setting is a pre-CFMX setting. If not, please let me know where it is. Thanks. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
any issues with XP sp2 on your CF development machine?
so what is the consensus on this new update? I've configured my laptop perfectly for development testing. Should I upgrade to sp2? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
Yes, it would read the data as if it came from a database table using cfquery. cfhttp url="" name=qData columns=columns here if first line not column names textqualifier= delimiter=, resolveurl=no timeout=20 charset=charset of the page/cfhttp cfdump var=#qData# Replace the values with your own and test to see the result. The csv file must be accessible from the web (using a fully qualified url). Pascal -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 11:20 To: CF-Talk Subject: RE: escaping character So when you say to read the csv as a query object what exactly do you mean ?Do you mean treat the data as if it came straight out of a cfquery statement ? I am confused ! [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping character
A simple solution would be to see if your data supplier can use a different delimiter. Instead of a comma, if they can use a '|' (pipe symbol found to left of 'Z' on keyboard) or a ~ (tilda) character then these tend not to crop up in 'ordinary text'. You could 'parse' the data yourself.That is look for the text qualified using the find function, mark this character position as the start of a text field and look for the closing , mark this as the end, now for the characters within this region strip out any delimiter characters.Repeat for rest of string. - Original Message - From: Brant Winter [EMAIL PROTECTED] Date: Mon, 6 Sep 2004 19:31:09 +1000 Subject: RE: escaping character To: CF-Talk [EMAIL PROTECTED] It will be a regular transfer, almost on a daily basis. I am not sure if I am going to be able to get the other party to supply the data with double quotes and commas as in a text qualifier. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
OT: AV on Dev Machine
Quick question for all. We are sick of Norton using far too many system resources, AVG not cleaning files and PC Cillin not detecting viruses.I have had a bad experience with Panda before but if people say it is great I will try it again.So, the question... Q) What anti-virus software do you use on your development workstations and why? -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
Wo - why does that work ? I specify the delimiter only ( as the data didn't have a text qualifier ) and the query output is spot on now ??? cfhttp url="" name=qData delimiter=, resolveurl=no timeout=20/cfhttp The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
I think is the default qualifier. You can even drop the delimiter (I think , is the default). Pascal -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 12:53 To: CF-Talk Subject: RE: escaping character Wo - why does that work ? I specify the delimiter only ( as the data didn't have a text qualifier ) and the query output is spot on now ??? cfhttp url="" name=qData delimiter=, resolveurl=no timeout=20/cfhttp The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
What am i doing wrong here ? Sorry about the huge post, but I just cant see what I am missing now ? The error in line 57 refers to a different field than the exception message showing an address Syntax error (missing operator) in query _expression_ '2 HOLBOURN CRES'. Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query _expression_ '2 HOLBOURN CRES'. The error occurred in C:\Inetpub\wwwroot\HOCACF\pharma\test.cfm: line 57 55 : #qData.SAUTHORITY#, 56 : #qData.SSIGS#, 57 : #qData.SWARDNO# ) 58 : 59 : /cfquery cfhttp url="" name=qData delimiter=, resolveurl=no timeout=20/cfhttp !--- cfdump var=#qData# --- cfloop query=qData cfquery datasource=obscript INSERT INTO scripts ( SRXNO, SDISPDATE, PTITLE, PFIRSTNAME, PSURNAME, PADDRESS, PSUBURB, PPOSTCODE, PMEDICARE, PMEDICDATE, PCONCTYPE, PCONCNO, PCONCVDATE, PSAFENTNO, PREPATNO, SDOCPRESNO, SDOCNAME, SDRUGDESC, SALTDESC, SQTY, SAUTHORITY, SSIGS, SWARDNO ) VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#, #qData.PFIRSTNAME#, #qData.PSURNAME#, #qData.PADDRESS#, #qData.PSUBURB#, #qData.PPOSTCODE#, #qData.PMEDICARE#, #qData.PMEDICDATE#, #qData.PCONCTYPE#, #qData.PCONCNO#, #qData.PCONCVDATE#, #qData.PSAFENTNO#, #qData.PREPATNO#, #qData.SDOCPRESNO#, #qData.SDOCNAME#, #qData.SDRUGDESC#, #qData.SALTDESC#, #qData.SQTY#, #qData.SAUTHORITY#, #qData.SSIGS#, #qData.SWARDNO# ) /cfquery /cfloop The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping character
Brant Winter wrote: What am i doing wrong here ? Sorry about the huge post, but I just cant see what I am missing now ? The error in line 57 refers to a different field than the exception message showing an address Syntax error (missing operator) in query _expression_ '2 HOLBOURN CRES'. cfhttp url="" name=qData delimiter=, resolveurl=no timeout=20/cfhttp !--- cfdump var=#qData# --- cfloop query=qData cfquery datasource=obscript INSERT INTO scripts ( SRXNO, SDISPDATE, PTITLE, PFIRSTNAME, PSURNAME, PADDRESS, PSUBURB, PPOSTCODE, PMEDICARE, PMEDICDATE, PCONCTYPE, PCONCNO, PCONCVDATE, PSAFENTNO, PREPATNO, SDOCPRESNO, SDOCNAME, SDRUGDESC, SALTDESC, SQTY, SAUTHORITY, SSIGS, SWARDNO ) VALUES ( #qData.SRXNO#, #qData.SDISPDATE#, #qData.PTITLE#, #qData.PFIRSTNAME#, #qData.PSURNAME#, #qData.PADDRESS#, #qData.PSUBURB#, #qData.PPOSTCODE#, #qData.PMEDICARE#, #qData.PMEDICDATE#, #qData.PCONCTYPE#, #qData.PCONCNO#, #qData.PCONCVDATE#, #qData.PSAFENTNO#, #qData.PREPATNO#, #qData.SDOCPRESNO#, #qData.SDOCNAME#, #qData.SDRUGDESC#, #qData.SALTDESC#, #qData.SQTY#, #qData.SAUTHORITY#, #qData.SSIGS#, #qData.SWARDNO# ) /cfquery /cfloop You need single quotes around your text and dates must in an appropriate format for your database. You should look into using CFQueryParam and possibly CreateODBCDateTime et al. Stephen [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
Just for testing I made a simple access db and made all the fields text fields. I tried putting single quotes around all of the #qData.xxx# and all I ended up with was qData.xxx in the resulting error message. The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology Oncology Clinics of Australasia for any virus damage caused by this message. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: escaping character
Use CFQUERYPARAM !! put the #qData.xxx# in the value attribute and use the appropriate cfsqltype Pascal -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 13:26 To: CF-Talk Subject: RE: escaping character What am i doing wrong here ? Sorry about the huge post, but I just cant see what I am missing now ? The error in line 57 refers to a different field than the exception message showing an address Syntax error (missing operator) in query _expression_ '2 HOLBOURN CRES'. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping character
Brant Winter wrote: Just for testing I made a simple access db and made all the fields text fields. I tried putting single quotes around all of the #qData.xxx# and all I ended up with was qData.xxx in the resulting error message. If you choose to go the way of the single quotes, you should only add them around text fields, not around numbers and dates. However, it is *highly* recommended to use cfqueryparam. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping character
With regards to this thread, I am about to embark on doing alittle functionality to a site where people will be able to upload CSV files. There will be different CSV types for different data and I wondered if a) there are some good CSV functions out there for parsing into db or query (different delimiters, text qualifiers etc) b) if anyone has done a template to check a CSV against? What I mean is this CSV should have x number of columns and they are x, y, z etc Regards Mark Drew On Mon, 06 Sep 2004 13:47:39 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: Brant Winter wrote: Just for testing I made a simple access db and made all the fields text fields. I tried putting single quotes around all of the #qData.xxx# and all I ended up with was qData.xxx in the resulting error message. If you choose to go the way of the single quotes, you should only add them around text fields, not around numbers and dates. However, it is *highly* recommended to use cfqueryparam. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFHTTP - Thumbnail
I am looking for a cfx_tag which is able to create a thumbnail into jpg,gif,png etc. from cfhttp.filecontent? Does someone knows a supplier delivering such a tag? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: escaping character
Mark, Don't quote me on this, you'll have to double check, but in reference to item 'a' of your list I think I remember seeing a UDF function library at cflib.org for handling CSV files. If that wasn't it then I may have seen a CFC somewhere (cfczone.org maybe). There are resources out there... Cutter Mark Drew wrote: With regards to this thread, I am about to embark on doing alittle functionality to a site where people will be able to upload CSV files. There will be different CSV types for different data and I wondered if a) there are some good CSV functions out there for parsing into db or query (different delimiters, text qualifiers etc) b) if anyone has done a template to check a CSV against? What I mean is this CSV should have x number of columns and they are x, y, z etc Regards Mark Drew On Mon, 06 Sep 2004 13:47:39 +0200, Jochem van Dieten [EMAIL PROTECTED] wrote: Brant Winter wrote: Just for testing I made a simple access db and made all the fields text fields. I tried putting single quotes around all of the #qData.xxx# and all I ended up with was qData.xxx in the resulting error message. If you choose to go the way of the single quotes, you should only add them around text fields, not around numbers and dates. However, it is *highly* recommended to use cfqueryparam. Jochem [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Strange WS Behavior
Since yesterday I've noticed that I can't connect to any WebServices through Flash or ColdFusion (this is from both my dev server in-house, as well as my production server at my ISP). And some of the WebServices I am trying to connect to are not of my design but from the world at large (i.e.: a service I found at xmethods for pulling the current temperature). I'm not positive, but looking at some of the error codes from the CF side it almost looks like the soap definitions reference (which we have no way of controlling that I know of) has been moved on the apache.org site. Does anyone else see this behavior or could possibly test? Cutter [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CFHTTP - Thumbnail
There is one called cfx_url2bmp, search the MM Exchange for it, it is there, also it is freeware. Andrew. - Original Message - From: Micha Schopman [EMAIL PROTECTED] Date: Mon, 6 Sep 2004 14:26:20 +0200 Subject: CFHTTP - Thumbnail To: CF-Talk [EMAIL PROTECTED] I am looking for a cfx_tag which is able to create a thumbnail into jpg,gif,png etc. from cfhttp.filecontent? Does someone knows a supplier delivering such a tag? Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT - farcry CMS
Thanx Kevin and Geoff I'll be there... On Mon, 6 Sep 2004 16:09:18 +1000, Geoff Bowers [EMAIL PROTECTED] wrote: - Original Message - From: Marco Antonio C. Santos [EMAIL PROTECTED] sorry for SOT... Anybody know how to run multiple sites inside only one Farcry installation? Multiple sites for one farcry installation?This is the standard way FarCry works. Send an email to [EMAIL PROTECTED] to jump on the FarCry developers mailing list -- plenty of help to get you going there. -- geoff On the road via GMail. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
Hi, I have a custom tag (CFX_MapData) on the back burner that would do exactly this. It sets colors according to values from a databse on a gif file reprensing any map with a maximum of 250 areas. This tag is sort of a cousin of CFX_Mapclick tha you can see at the address below. If you are interested, let me set up a demo. -- ___ 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] [Donations and Support]
Re: Free for non-commercial usage? Donationware?
How would you enforce commercial users to actual pay for it? I know most companies are honest and would pay, but there are still many that would just go, well we have download it might as well us it. This is why I'm asking the question. I think that there is enough honesty that this would work out, but I'm interested in other people's experience with this concept. Is there really as much honesty as I'd like to believe there is out there? I'm actually thinking about this idea because I realized that since this is a side project, I'm as interested in the Amazon wishlist donations as I am in cash. Personally if I was going in this direction I would probably make two versions, a lite version and a pro version. Simply write you application as the pro version and then extract some the feature to create the lite version. Then you get the best of both world. Non-commercial and commercial people can use the lite version but if they want/need the extra functionality in the pro version then they have to pay. You would still get the feedback and hopefully earn some money from sales of the pro version. But that's not really what I'm trying to do. My hope is that: a) I get a pretty cool software out to the world and the non-commercial users have a viable product that is very cool to use. b) By seeing how cool this product is, they either donate as a thank you for the non-commercial or pay for the commercial version (presumably for work related projects). The point isas much to me to make a few extra bucks (and get a few things off my wishlist) as it is to create a product that becomes a de facto piece of code. Any other ideas/experiences? Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFHTTP - Thumbnail
I have already tried that one, but this tags seems to convert the results to fast. Often the thumbnail gives me half loaded pages, 60% images loaded etc. :-) Micha Schopman Software Engineer Modern Media, Databankweg 12 M, 3821 ALAmersfoort Tel 033-4535377, Fax 033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFHTTP - Thumbnail
I'd save the file, then create a thumbnail with either imagemagik or cfx_Image, 2 steps maybe, but much easier. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT: AV on Dev Machine
Sophos - cos it works! On Mon, 6 Sep 2004 11:38:59 +0100, James Smith [EMAIL PROTECTED] wrote: Quick question for all. We are sick of Norton using far too many system resources, AVG not cleaning files and PC Cillin not detecting viruses.I have had a bad experience with Panda before but if people say it is great I will try it again.So, the question... Q) What anti-virus software do you use on your development workstations and why? -- James Smith [EMAIL PROTECTED] [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
SOT: Unix, Linux, OS X scripting list
Anyone know of a good list that discusses 'Nix shell scripting -- that will be gentle with a novice? TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Unix, Linux, OS X scripting list
I got a very handy book on the subject from O'reilly http://www.oreilly.com/catalog/lunixpanther/ HTH MD On Mon, 6 Sep 2004 08:35:53 -0700, Dick Applebaum [EMAIL PROTECTED] wrote: Anyone know of a good list that discusses 'Nix shell scripting -- that will be gentle with a novice? TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Nix shell script to test if CF is running on port xxxx
On Saturday 04 Sep 2004 03:08 am, Dick Applebaum wrote: I want to write a 'Nix shell script to see if a cf server instance is running (accepting requests) an a given port - say 8101 netstat -alpn | grep 8101 then pipe to something like 'awk {print $8}' that will get you the process name, just grep for whatever your cf server shows up as when you run the script by hand. -- 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] [Donations and Support]
Re: OT: open url from script
On Thursday 02 Sep 2004 23:33 pm, Phil Cruz wrote: start http://google.com and it will launch the browser to that page.What is the equivalent script on Linux and/or Mac? Depends, what Linux versions will you be supporting ? What browsers ? -- 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] [Donations and Support]
Re: using udfs
On Wednesday 01 Sep 2004 14:52 pm, Brant Winter wrote: Hi - I am trying to use the listfix.cfm udf, and I am not quit sure how to use it. I have placed the udf in the customtags path under my cfusionmx UDF and Custom Tags are two different things. In general to use a UDF you need to cfinclude the file with it in. -- 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] [Donations and Support]
RE: SOT: Nix shell script to test if CF is running on port xxxx
Wookey Hole Road --- a place where Han Solo sometimes went? :OD -Original Message- From: Thomas Chiverton [mailto:[EMAIL PROTECTED] Sent: 06 September 2004 17:02 To: CF-Talk Subject: Re: SOT: Nix shell script to test if CF is running on port -- 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 [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
FW: ColdFusion MX Log Viewer
Resending again with hopes that this time I'll get some feedback. Thanks, Dave _ From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, September 04, 2004 1:25 PM To: CF-Talk Subject: ColdFusion MX Log Viewer Hi, Anyone know of a good replacement log viewer for CF MX ?All the ones I find are for older versions of CF and don't take into account the complexity of the exception.log. Thanks! Sincerely, Dave Phillips 94percent.com Co-Founder and Head Geek [EMAIL PROTECTED] 615-746-3851 Why do 100% of the work when we'll do 94% of it for you? - http://DavePhillips.Ninety-FourPercent.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: FW: ColdFusion MX Log Viewer
tail ? On Mon, 6 Sep 2004 11:48:07 -0500, Dave Phillips [EMAIL PROTECTED] wrote: Resending again with hopes that this time I'll get some feedback. Thanks, Dave _ From: Dave Phillips [mailto:[EMAIL PROTECTED] Sent: Saturday, September 04, 2004 1:25 PM To: CF-Talk Subject: ColdFusion MX Log Viewer Hi, Anyone know of a good replacement log viewer for CF MX ?All the ones I find are for older versions of CF and don't take into account the complexity of the exception.log. Thanks! Sincerely, Dave Phillips 94percent.com Co-Founder and Head Geek [EMAIL PROTECTED] 615-746-3851 Why do 100% of the work when we'll do 94% of it for you? - http://DavePhillips.Ninety-FourPercent.com _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMail Forwarding
I have a CFMail routine on a website which I host in which the mail server is at a separate location (the client's). When I want to have an email sent from, say [EMAIL PROTECTED] (as in an autoresponder form), do I set the CFMail Server attribute to their mail server, such as mail.myclientswebsite.com? On the remote mail server, do they need to open a relay based on the IP address of the website, which I host? Thanks, Mark [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Free for non-commercial usage? Donationware?
Donationware doesn't really work to any meaningful degree even if you have *really* large numbers.The sad fact is that far, far too many people in our line of work expect software they download for free is free for all uses. There are many individuals who will be the exception to this rule, but expect it to be a rule nonetheless. You won't need to dig far to discover this I'm afraid.The original developer of ASSP -- arguably the best server-side anti-spam product out there -- bailed when he couldn't get any monetary support, needed some and his appeals to the community fell on deaf ears.And that product saved its users -- many of them corporate -- zillions. FCKEditor was the 7th-most-active project at SourceForge a few days ago, and is used by boatloads of CF and other developers.Their donor list is... 2 developers long, and neither contributed over $20. The 'lite' and 'pro' ideas are the only things I have seen work well. I've only done them myself on two different items, and both have given satisfactory results.One has given VERY satisfactory results and only sells for US$10.Thats almost so cheap it seems not worth the trouble.But the thing is, its a lot easier to pry $10 out of a tight fist than it is to pry $100.And the number of $10 bills you'll get will **more** than make up for the few big scores you'll make with $100. Give away your 'lite' but don't cripple it.Make it a great product in its own right.Put in a 'non-commercial only' stipulation to cover that base and give yourself a small bump from an honest few... but expect it to be only a very, very few.Then bump up the functionality to a small but undeniably useful degree for your 'pro'.Go for legions of users who appreciate the free product and -- once hooked -- will want the added features that you are asking only a small sum for. -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Nix shell script to test if CF is running on port xxxx
On Sep 6, 2004, at 9:02 AM, Thomas Chiverton wrote: On Saturday 04 Sep 2004 03:08 am, Dick Applebaum wrote: I want to write a 'Nix shell script to see if a cf server instance is running (accepting requests) an a given port - say 8101 netstat -alpn | grep 8101 then pipe to something like 'awk {print $8}' that will get you the process name, just grep for whatever your cf server shows up as when you run the script by hand. On OS X, if I use the above I get: Richard:~ richard$ netstat -alpn | grep 8101 netstat: n: unknown or uninstrumented protocol Richard:~ richard$ So I try Richard:~ richard$ netstat -alp | grep 8101 netstat: option requires an argument -- p usage: netstat [-Aan] [-f address_family] [-M core] [-N system] netstat [-bdghimnrs] [-f address_family] [-M core] [-N system] netstat [-bdn] [-I interface] [-M core] [-N system] [-w wait] netstat -m [-M core] [-N system] Richard:~ richard$ So, I listed the protocols -- I don't know which one(s) to check for. What I am trying to do is write a script that automates CF startup, and sleeps (or loops) until CF is up and the port is accepting http requests. I have modified an example I found to do this by invoking a Perl script that, in turn, interacts with telnet( apparently shell scripts have difficulty interacting ). #!/usr/bin/perl use Net::Telnet; $telnet = new Net::Telnet ( Timeout=30, Port=8081, Errmode='die'); $telnet-open('localhost'); $telnet-waitfor('/220/'); $telnet-print('hello just-testing.org'); ($output)=$telnet-waitfor('/250/'); $telnet-print('quit'); I'd rather not use an additional Perl script if possible) I can brute force a delay using a long sleep, but this is not very elegent Maybe the expect command will allow me to script telnet interaction. If you could point me in the right direction, I will appreciate it. TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfx_getimage on CFMX / blob images with ASP
I can use the cfx_getimage tag just fine on CF 5.0. But no luck with it on CFMX. Anyone using this tag? As a backup plan I'm using ASP to retrieve and send to the browser but I cannot seem to get it to write the file to disk. Anybody with ASP experience that could help me out? FILE: show.asp img src=""> FILE: getimage.asp %@ LANGUAGE=VBSCRIPT % % ' Clear out the existing HTTP header information Response.Expires = 0 Response.Buffer = TRUE Response.Clear ' Change the HTTP header to reflect that an image is being passed. Response.ContentType = image/jpg Set cn = Server.CreateObject(ADODB.Connection) ' The following open line assumes you have set up a System DataSource ' by the name of myDSN. 'Remember to change the following connection string parameters to reflect the correct values 'for your SQL server. cn.Open DSN=idx_ds1;UID=isfdvee;PWD=sdfsfved;DATABASE=MLSNHSQL Set rs = cn.Execute(SELECT MEDIUM_PHOTO FROM dbo.idxmls Request.QueryString(tbID) WHERE ID= Request.QueryString(ID)) Response.BinaryWrite rs(MEDIUM_PHOTO) Response.End % [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Displaying a dynamic map - how?
You can use Remoting in CF 5.0 - but you'd have to buy it. I'm not even sure you can use it at all. If you don't have CFMX or JRun, you can buy either Flash Remoting for Java or for .NET, but you wouldn't be able to write CFCs to interact with it. 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] [Donations and Support]
Re: Free for non-commercial usage? Donationware?
Go for legions of users who appreciate the free product and -- once hooked -- will want the added features that you are asking only a small sum for. You sound like a drug dealer pleading his wares [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CMFX 6.1 Installation Problems
Ok. I have enver had installation issues with CF before that I could not figure out in a minute or two, but this one has me stumped. I had CFMX 6.1 installed and Blackstone Alpah. Both worked fine together as long as only one service was on at once... no big deal. I install the CFMX 6.1 updater and then neither work. So looking around I see that IIS keeps stopping the default website, odd. I mess around with it for a few minutes and notice that the local directory showing up in IIS for CFIDE is appearing as D:\\CFIDE (yes the double slash is there). Weird. Now I change it to D:\CFIDE and restart the website, and low and behold IIS stops the site again. In the event viewer I see a bunch of errors relating to: Volume Shadow Copy Service error: Unexpected error calling routine IEventSystem::Query.hr = 0x80040155. Application image dump failed. Server Application ID: {02D4B3F1-FD88-11D1-960D-00805FC79235} Server Application Instance ID: {EAA87F12-702C-4440-BA77-06AF6CA5F78A} Server Application Name: System Application Error Code = 0x80004005 : Unspecified error COM+ Services Internals Information: File: d:\qxp_slp\com\com1x\src\shared\util\svcerr.cpp, Line: 1259 Comsvcs.dll file version: ENU 2001.12.4414.258 shp I then uninstalled CFMX 6.1 and Blackstone Alpha and just reinstalled CFMX 6.1 and the same thing happens. The CFIDE is mapped to D:\\CFIDE and IIS keeps stopping the site and the above errors keep appearing in the event viewer. Anyone have any suggestions? OS: Windows XP Pro (SP2) CFMX 6.1 Developer Install (server installation) Blackstone Alpha Thanks, Mike [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Free for non-commercial usage? Donationware?
... okay ? Personally, I appreciated what Matt had to say. Unlike the comment below, I thought it was useful, experience-based, well-thought-out advice. Thanks Matt for sharing your wisdom with us! =) Warm regards, Jordan Michaels Vivio Technologies Andrew Dixon wrote: Go for legions of users who appreciate the free product and -- once hooked -- will want the added features that you are asking only a small sum for. You sound like a drug dealer pleading his wares [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Free for non-commercial usage? Donationware?
... okay ? He basically say them same as me, I was only making a small joke. Lighten up. Andrew. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Displaying a dynamic map - how?
Oops - thought I lost that mail. Anyway the second possibility with DHTML, if the areas are large, but slightly irregular, would be to set a grid of squares (or rectangles) under your display (using absolute positioning in a relatively positioned box) - as large as you could make them but small enough so that only one set of polygons is under each area.You can then use the transparency idea from the first item but instead of setting a single background color you'd set all of the background colors for that item's portion of the grid. When I did this the determination of the grid was very simplistic: I did it by eye then created a new property for each grid span which indicated what area it was under.Then I just looped through the span collection looking first of the existence of that property then for a match before changing color. It works, but depending on how irregular the objects are you can be dealing with very small grid cells. and Flash would probably be much, much easy in the long run. Jim Davis _ From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 1:40 AM To: CF-Talk Subject: RE: Displaying a dynamic map - how? You can use Remoting in CF 5.0 - but you'd have to buy it.There are also several other methods to transfer information to Flash - you can use loadvars, pass in information as URL variables or as attributes in the Flash call in your HTML. Depending how irregular the patterns are you might be able to get away with DHTML.I've done this two ways in the past: 1) Instead of changing the color of the whole shape just pick a highlight color (in this it might be the roads or the homes for example, not the whole block).You can then make that part of the image transparent and let a settable background color show through.This is nice if the shapes are regular enough to allow for things not to overlap much. From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 12:46 AM To: CF-Talk Subject: Displaying a dynamic map - how? I have a prospective client - a real estate developer who has a subdivision we're proposing a site for. He wants a map of his subdivision and wants to have the colours of the various blocks change depending on their sale status showing in a query when the page is called. (i.e. sold, available,on holding deposit etc). What's the best way to be changing the colours of the blocks, given that they're not rectangular and all different sizes? Before you yell FLASH REMOTING!it's CF5.0 only, not CFMX so flash remoting isn't an option. IS DHTML a way to go here, with layers changing colour based on the value of the 'status' field?or perhaps CSS? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Displaying a dynamic map - how?
Depending on the quality of the original map (digital would be much better than a scan) you should be able to use the trace applications that come with most vector drawing tools to get the map into Flash. I'm a huge fan of CorelDraw which comes with CorelTrace - it'll do the job nicely given decent input. Jim Davis From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 2:40 AM To: CF-Talk Subject: Re: Displaying a dynamic map - how? What's the best way to be changing the colours of the blocks, given that they're not rectangular and all different sizes? i'd suggest a simple GIS. it also allows users to interactively query a parcel, spatially search for parcels, etc. it can be as complicated or as simple as you need. How would you do it in flash without using remoting? well i'd be concerned at the effort getting the map into flash. especially if you want background features (streams, etc.). [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Displaying a dynamic map - how?
I assumed that you could use Remoting for ASP and interact with it using the COM interface. I could definitely be wrong tho'. Jim Davis From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 2:03 PM To: CF-Talk Subject: RE: Displaying a dynamic map - how? You can use Remoting in CF 5.0 - but you'd have to buy it. I'm not even sure you can use it at all. If you don't have CFMX or JRun, you can buy either Flash Remoting for Java or for .NET, but you wouldn't be able to write CFCs to interact with it. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Nix shell script to test if CF is running on port xxxx
Dick, use the man pages to see the options for netstat...I don't run OSX or I'd give you the fix. just type: man netstat HTH -Josh Dick Applebaum wrote: On Sep 6, 2004, at 9:02 AM, Thomas Chiverton wrote: On Saturday 04 Sep 2004 03:08 am, Dick Applebaum wrote: I want to write a 'Nix shell script to see if a cf server instance is running (accepting requests) an a given port - say 8101 netstat -alpn | grep 8101 then pipe to something like 'awk {print $8}' that will get you the process name, just grep for whatever your cf server shows up as when you run the script by hand. On OS X, if I use the above I get: Richard:~ richard$ netstat -alpn | grep 8101 netstat: n: unknown or uninstrumented protocol Richard:~ richard$ So I try Richard:~ richard$ netstat -alp | grep 8101 netstat: option requires an argument -- p usage: netstat [-Aan] [-f address_family] [-M core] [-N system] netstat [-bdghimnrs] [-f address_family] [-M core] [-N system] netstat [-bdn] [-I interface] [-M core] [-N system] [-w wait] netstat -m [-M core] [-N system] Richard:~ richard$ So, I listed the protocols -- I don't know which one(s) to check for. What I am trying to do is write a script that automates CF startup, and sleeps (or loops) until CF is up and the port is accepting http requests. I have modified an example I found to do this by invoking a Perl script that, in turn, interacts with telnet( apparently shell scripts have difficulty interacting ). #!/usr/bin/perl use Net::Telnet; $telnet = new Net::Telnet ( Timeout=30, Port=8081, Errmode='die'); $telnet-open('localhost'); $telnet-waitfor('/220/'); $telnet-print('hello just-testing.org'); ($output)=$telnet-waitfor('/250/'); $telnet-print('quit'); I'd rather not use an additional Perl script if possible) I can brute force a delay using a long sleep, but this is not very elegent Maybe the expect command will allow me to script telnet interaction. If you could point me in the right direction, I will appreciate it. TIA Dick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfloop / cfquery and displaying results
hi everyone. i have a question concerning cfloop, cfquery and how to display information most effectively on a page. here is the situation. i have two queries. the first query gets all my main topics. the second query gets all my sub topics. my where clause in my second query uses an IN statement and utilizes the valuelist of the results of the first query. in the past what i have done is just performed the first query, and then placed the second query within a cfloop of the results of the first one to display all the sub topics. this time around i want to build a result set on the fly without having to put the second query within my cfloop tag. any suggestions are greatly appreciated. thanks so much. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Free for non-commercial usage? Donationware?
No offense taken, guys. I think the only diff between what Andrew and I originally recommend is that I suggested making the 'lite' non-commercial only.I figure this may be a spur to some corporate types to pay up.I have no idea if that has added any sales its a fairly new idea for me. One thing about this lite vs. pro stuff:You'll add quite a bit to your dev time doing it.Depending on the complexity of the app it can be quite a pain to do updates, as what you wind up doing after the first hackfest is developing so much new code you have to start from scratch to come up with another lite version.Code reuse and some sort of framework (insert your favorite fw name here) helps a lot to minimize that. p.s. if you are in the U.S. and working take a break!Its a holiday already.I'm heading out for a trail ride in a bit.As soon as I finish this one last code bit... -- --Matt Robertson-- MSB Designs, Inc. mysecretbase.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Nix shell script to test if CF is running on port xxxx
Josh I've done that, here's the synopsis: NETSTAT(1) BSD General Commands Manual NETSTAT(1) NAME netstat - show network status SYNOPSIS netstat [-AaLlnW] [-f address_family | -p protocol] [-M core] [-N system] netstat [-gilns] [-f address_family] [-M core] [-N system] netstat -i | -I interface [-w wait] [-abdgt] [-M core] [-N system] netstat -s [-s] [-f address_family | -p protocol] [-M core] [-N system] netstat -i | -I interface -s [-f address_family | -p protocol] [-M core] [-N system] netstat -m [-M core] [-N system] netstat -r [-Aaln] [-f address_family] [-M core] [-N system] netstat -rs [-s] [-M core] [-N system] when i run netstat w/o any parms, it does not show some ports that I know are active (80, 9090, etc) lost? Dick Richard:~ richard$ netstat Active Internet connections Proto Recv-Q Send-QLocal Address Foreign Address (state) tcp4 0010.0.1.2.54157idisk.mac.com.http ESTABLISHED tcp4 0010.0.1.2.54156adsl-67-124-145-.hp-pd SYN_SENT tcp4 0010.0.1.2.53939mail.mac.com.imap ESTABLISHED tcp4 00localhost.ipp localhost.53844 ESTABLISHED tcp4 00localhost.53844localhost.ipp ESTABLISHED tcp4 00localhost.53843localhost.ipp CLOSE_WAIT tcp4 00localhost.53490localhost.51004 CLOSE_WAIT tcp4 00localhost.53489localhost.51004 CLOSE_WAIT tcp4 00localhost.53353localhost.51004 CLOSE_WAIT tcp4 00localhost.53352localhost.51004 CLOSE_WAIT tcp4 0010.0.1.2.62793idisk.mac.com.http CLOSE_WAIT tcp4 0010.0.1.2.61312mail.mac.com.imap ESTABLISHED tcp4 00localhost.59549localhost.ipp CLOSE_WAIT tcp4 00localhost.59548localhost.ipp CLOSE_WAIT tcp4 0010.0.1.2.49357mail.mac.com.imap ESTABLISHED tcp4 00localhost.netinfo-loca localhost.972 ESTABLISHED tcp4 00localhost.972 localhost.netinfo-loca ESTABLISHED udp4 00localhost.53331localhost.1023 udp4 00*.50421 *.* udp4 00*.**.* udp4 00*.svrloc*.* udp4 00*.**.* udp4 00*.**.* udp4 00localhost.49160localhost.1022 udp4 00localhost.49159localhost.1022 udp4 00localhost.1022*.* udp4 00localhost.1023*.* udp4 0010.0.1.2.ntp*.* udp4 00localhost.ntp *.* udp4 00*.ntp*.* udp4 00*.mdns*.* udp4 00*.ipp*.* udp4 00*.bootpc*.* udp4 00localhost.netinfo-loca *.* udp4 00*.syslog*.* udp6 00*.514*.* icm6 00*.**.* icm6 00*.**.* Active LOCAL (UNIX) domain sockets AddressTypeRecv-Q Send-Q InodeConnRefsNextref Addr 2f7fdc8 stream47810 2f7f5b0 stream00 2f7f9d8 stream0002f7f9a000 2f7f9a0 stream0002f7f9d800 2f7fe70 stream00 2f7f620 stream00 2f7fb60 stream00 1d69460 stream00 2f7fd58 stream00 2f7fd20 stream00 2f7f930 stream00 2f7fc78 stream00 2f7ffc0 stream00 1d69150 stream00 2f7fc40 stream00 2f7fa48 stream0002f7fce800 2f7fce8 stream0002f7fa4800 2f7fcb0 stream00 2f7fa10 stream0002f7fab800 2f7fab8 stream0002f7fa1000 2f7ff18 stream0001d6903800 1d69038 stream0002f7ff1800 1d69188 stream002b82bf /tmp/webdavDtD2qQ 2f7fd90 stream0001d6949800 /var/tmp/SCDynamicStoreNotifyFileDescriptor-19715 1d69498 stream0002f7fd9000 1d690e0 stream0002f7fe3800 2f7fe38 stream0001d690e000 2f7fb28 stream0002f7fbd000 2f7fbd0 stream0002f7fb2800 2f7fee0 stream0001d690a800 1d690a8 stream0002f7fee000 2f7ff50 stream00270b1e8000 /tmp/mysql.sock 1d691f8 stream0001d6923000 1d69230 stream0001d691f800 1d69268 stream0001d692a000 1d692a0 stream0001d6926800 1d692d8 stream0001d6931000 1d69310 stream0001d692d800 1d69348 stream0001d6938000 1d69380 stream0001d6934800 1d693b8 stream0026bc398000 /tmp/stuffit_avr_ipc 1d694d0 stream0001d6950800 /var/run/pppconfd 1d69508 stream0001d694d000 1d69540 stream0001d6957800 /var/run/pppconfd 1d69578 stream0001d6954000 1d69738 stream0001d695b000 /var/run/pppconfd 1d695b0 stream0001d6973800 1d69658 stream0001d6969000 /var/run/pppconfd 1d69690 stream0001d6965800 1d69700 stream002465988000 /tmp/slp_ipc 1d69818 stream0001d697e000 1d697e0 stream0001d6981800 1d69770 stream0001d6985000 1d69850 stream0001d6977000 1d698c0 stream0001d698f800 1d698f8 stream0001d698c000 1d69b60 stream0001d69af000 1d69af0 stream8192001d69b6000 1d69b98 stream0001d69b2800 1d69b28 stream721d69b9800 1d699a0 stream0001d6993000 1d69930 stream0001d699a000 1d699d8 stream0001d69a8000 1d69a80 stream0001d699d800 1d69bd0 stream0001d6996800 1d69968 stream0001d69bd000 1d69c40 stream002151c9 /var/run/mDNSResponder 1d69d58 stream0020d1ef8000 /var/run/pppconfd 2f7f968 dgram 0001d69fc002f7f700 2f7f7a8 dgram 0002f7f6902f7f6900 2f7f690 dgram 0002f7f7a82f7f7a80 2f7f700 dgram 0001d69fc002f7fea8 2f7fea8 dgram 0001d69fc001d691c0 1d69070 dgram 0001d691181d691180 1d69118 dgram 0001d690701d690700 1d691c0 dgram 0001d69fc001d697a8 1d693f0 dgram 0001d694281d694280 1d69428 dgram 0001d693f01d693f00 1d69620 dgram 0001d695e81d695e80 1d695e8 dgram 0001d696201d696200 1d697a8 dgram 0001d69fc001d69d90 1d69d90 dgram 0001d69fc001d696c8 1d696c8 dgram 0001d69fc001d69ea8 1d69ea8 dgram 0001d69fc001d69888 1d69888 dgram 0001d69fc001d69ce8 1d69ce8 dgram 0001d69fc001d69a10 1d69a10 dgram 0001d69fc001d69a48 1d69a48 dgram 0001d69fc001d69ab8 1d69ab8 dgram 0001d69fc001d69cb0 1d69cb0 dgram 0001d69fc001d69dc8
Re: cfloop / cfquery and displaying results
Hi. You could keep to pretty much the same, but instead of doing a database query inside the loop speed it up by doing a query of query. Outside the loop you will need an extra query to get all the data for the sub-query to use as the query you are going to query, but this will increase the execution time vastly and will mean only a small amount of coding changes. If you need any help with how to do this, then email me over your original code and I will make the adjustments for you, should only take a moment. Andrew. - Original Message - From: Wurst, Keith D. [EMAIL PROTECTED] Date: Mon, 6 Sep 2004 15:28:21 -0400 Subject: cfloop / cfquery and displaying results To: CF-Talk [EMAIL PROTECTED] hi everyone. i have a question concerning cfloop, cfquery and how to display information most effectively on a page. here is the situation. i have two queries. the first query gets all my main topics. the second query gets all my sub topics. my where clause in my second query uses an IN statement and utilizes the valuelist of the results of the first query. in the past what i have done is just performed the first query, and then placed the second query within a cfloop of the results of the first one to display all the sub topics. this time around i want to build a result set on the fly without having to put the second query within my cfloop tag. any suggestions are greatly appreciated. thanks so much. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: Displaying a dynamic map - how?
I assumed that you could use Remoting for ASP and interact with it using the COM interface. I don't think there is a Flash Remoting for ASP, just for .NET and Java. 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] [Donations and Support]
RE: CMFX 6.1 Installation Problems
I then uninstalled CFMX 6.1 and Blackstone Alpha and just reinstalled CFMX 6.1 and the same thing happens. The CFIDE is mapped to D:\\CFIDE and IIS keeps stopping the site and the above errors keep appearing in the event viewer. Anyone have any suggestions? I haven't run into this problem myself, but I recommend that you delete the IIS virtual server, create a new one, then run the web server configuration utility to connect CFMX to that server. 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] [Donations and Support]
RE: Displaying a dynamic map - how?
Sorry - my bad. Jim Davis From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 4:26 PM To: CF-Talk Subject: RE: Displaying a dynamic map - how? I assumed that you could use Remoting for ASP and interact with it using the COM interface. I don't think there is a Flash Remoting for ASP, just for .NET and Java. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: SOT: Nix shell script to test if CF is running on port xxxx
Dick Applebaum wrote: when i run netstat w/o any parms, it does not show some ports that I know are active (80, 9090, etc) lost? interesting...not sure why that would be. I run a farm of linux servers and the following worked fine for me on my systems: netstat -alpn | grep (my port here) so your main goal is just to see if the service is running? why not just run the cfstat utility?or are really trying to get the port too? you can also check the jrun.xml file to see what port it is setup to run on here: /opt/coldfusionmx/runtime/servers/default/SERVER-INF/jrun.xml Hope that helps! -Josh Dick Richard:~ richard$ netstat Active Internet connections Proto Recv-Q Send-QLocal Address Foreign Address (state) tcp4 0010.0.1.2.54157idisk.mac.com.http ESTABLISHED tcp4 0010.0.1.2.54156adsl-67-124-145-.hp-pd SYN_SENT tcp4 0010.0.1.2.53939mail.mac.com.imap ESTABLISHED tcp4 00localhost.ipp localhost.53844 ESTABLISHED tcp4 00localhost.53844localhost.ipp ESTABLISHED tcp4 00localhost.53843localhost.ipp CLOSE_WAIT tcp4 00localhost.53490localhost.51004 CLOSE_WAIT tcp4 00localhost.53489localhost.51004 CLOSE_WAIT tcp4 00localhost.53353localhost.51004 CLOSE_WAIT tcp4 00localhost.53352localhost.51004 CLOSE_WAIT tcp4 0010.0.1.2.62793idisk.mac.com.http CLOSE_WAIT tcp4 0010.0.1.2.61312mail.mac.com.imap ESTABLISHED tcp4 00localhost.59549localhost.ipp CLOSE_WAIT tcp4 00localhost.59548localhost.ipp CLOSE_WAIT tcp4 0010.0.1.2.49357mail.mac.com.imap ESTABLISHED tcp4 00localhost.netinfo-loca localhost.972 ESTABLISHED tcp4 00localhost.972 localhost.netinfo-loca ESTABLISHED udp4 00localhost.53331localhost.1023 udp4 00*.50421 *.* udp4 00*.**.* udp4 00*.svrloc*.* udp4 00*.**.* udp4 00*.**.* udp4 00localhost.49160localhost.1022 udp4 00localhost.49159localhost.1022 udp4 00localhost.1022*.* udp4 00localhost.1023*.* udp4 0010.0.1.2.ntp*.* udp4 00localhost.ntp *.* udp4 00*.ntp*.* udp4 00*.mdns*.* udp4 00*.ipp*.* udp4 00*.bootpc*.* udp4 00localhost.netinfo-loca *.* udp4 00*.syslog*.* udp6 00*.514*.* icm6 00*.**.* icm6 00*.**.* Active LOCAL (UNIX) domain sockets AddressTypeRecv-Q Send-Q InodeConnRefsNextref Addr 2f7fdc8 stream47810 2f7f5b0 stream00 2f7f9d8 stream0002f7f9a000 2f7f9a0 stream0002f7f9d800 2f7fe70 stream00 2f7f620 stream00 2f7fb60 stream00 1d69460 stream00 2f7fd58 stream00 2f7fd20 stream00 2f7f930 stream00 2f7fc78 stream00 2f7ffc0 stream00 1d69150 stream00 2f7fc40 stream00 2f7fa48 stream0002f7fce800 2f7fce8 stream0002f7fa4800 2f7fcb0 stream00 2f7fa10 stream0002f7fab800 2f7fab8 stream0002f7fa1000 2f7ff18 stream0001d6903800 1d69038 stream0002f7ff1800 1d69188 stream002b82bf /tmp/webdavDtD2qQ 2f7fd90 stream0001d6949800 /var/tmp/SCDynamicStoreNotifyFileDescriptor-19715 1d69498 stream0002f7fd9000 1d690e0 stream0002f7fe3800 2f7fe38 stream0001d690e000 2f7fb28 stream0002f7fbd000 2f7fbd0 stream0002f7fb2800 2f7fee0 stream0001d690a800 1d690a8 stream0002f7fee000 2f7ff50 stream00270b1e8000 /tmp/mysql.sock 1d691f8 stream0001d6923000 1d69230 stream0001d691f800 1d69268 stream0001d692a000 1d692a0 stream0001d6926800 1d692d8 stream0001d6931000 1d69310 stream0001d692d800 1d69348 stream0001d6938000 1d69380 stream0001d6934800 1d693b8 stream0026bc398000 /tmp/stuffit_avr_ipc 1d694d0 stream0001d6950800 /var/run/pppconfd 1d69508 stream0001d694d000 1d69540 stream0001d6957800 /var/run/pppconfd 1d69578 stream0001d6954000 1d69738 stream0001d695b000 /var/run/pppconfd 1d695b0 stream0001d6973800 1d69658 stream0001d6969000 /var/run/pppconfd 1d69690 stream0001d6965800 1d69700 stream002465988000 /tmp/slp_ipc 1d69818 stream0001d697e000 1d697e0 stream0001d6981800 1d69770 stream0001d6985000 1d69850 stream0001d6977000 1d698c0 stream0001d698f800 1d698f8 stream0001d698c000 1d69b60 stream0001d69af000 1d69af0 stream8192001d69b6000 1d69b98 stream0001d69b2800 1d69b28 stream721d69b9800 1d699a0 stream0001d6993000 1d69930 stream0001d699a000 1d699d8 stream0001d69a8000 1d69a80 stream0001d699d800 1d69bd0 stream0001d6996800 1d69968 stream0001d69bd000 1d69c40 stream002151c9 /var/run/mDNSResponder 1d69d58 stream0020d1ef8000 /var/run/pppconfd 2f7f968 dgram 0001d69fc002f7f700 2f7f7a8 dgram 0002f7f6902f7f6900 2f7f690 dgram 0002f7f7a82f7f7a80 2f7f700 dgram 0001d69fc002f7fea8 2f7fea8 dgram 0001d69fc001d691c0 1d69070 dgram 0001d691181d691180 1d69118 dgram 0001d690701d690700 1d691c0 dgram 0001d69fc001d697a8 1d693f0 dgram 0001d694281d694280 1d69428 dgram 0001d693f01d693f00 1d69620 dgram 0001d695e81d695e80 1d695e8 dgram 0001d696201d696200 1d697a8 dgram 0001d69fc001d69d90 1d69d90 dgram 0001d69fc001d696c8 1d696c8 dgram 0001d69fc001d69ea8 1d69ea8 dgram 0001d69fc001d69888 1d69888 dgram 0001d69fc001d69ce8 1d69ce8 dgram 0001d69fc001d69a10 1d69a10 dgram 0001d69fc001d69a48 1d69a48 dgram 0001d69fc001d69ab8 1d69ab8 dgram 0001d69fc001d69cb0 1d69cb0 dgram 0001d69fc001d69dc8 1d69c08 dgram 0001d69c781d69c780 1d69c78 dgram 0001d69c081d69c080 1d69dc8 dgram
CF French ressources
Hi, I remember someone looking for french ressources on CF... I don't think it's much but you may find something there : http://www.cfmfrance.com/ Pat [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF French ressources
Hi, I remember someone looking for french ressources on CF Prsent!!! Who, where, when? ;-) -- ___ 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] [Donations and Support]
Re: SOT: Nix shell script to test if CF is running on port xxxx
Josh Thanks for your help Based on what you posted, I did some experimenting and found something that appears to work --the first 2 tests were run after the server (9090 in this case) was started, but had not yet become ready.The 3rd test shows the server is ready. So it, appears that I have something that I can test for in a loop. Is there a best practices wway to test for something like this -- say with a sleep for a few seconds, and a max number of iterations so it doesn't loop for ever? Dick Richard:~ richard$ netstat -aln | grep 9090 Richard:~ richard$ netstat -aln | grep 9090 Richard:~ richard$ netstat -aln | grep 9090 tcp4600*.9090*.* LISTEN Richard:~ richard$ On Sep 6, 2004, at 1:57 PM, Josh wrote: when i run netstat w/o any parms, it does not show some ports that I know are active (80, 9090, etc) lost? interesting...not sure why that would be. I run a farm of linux servers and the following worked fine for me on my systems: netstat -alpn | grep (my port here) so your main goal is just to see if the service is running? why not just run the cfstat utility? or are really trying to get the port too? you can also check the jrun.xml file to see what port it is setup to run on here: /opt/coldfusionmx/runtime/servers/default/SERVER-INF/jrun.xml Hope that helps! -Josh [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CF5.0 - sending many emails
I seem to recall that in CF5.0 there was a problem that occasionally the server would send an email dozens, even hundreds of times to the same person if there was a hiccup between CFMAIL and the OS mail server.Does anyone remember this? We have this problem and need to find a solution.The client's saying we'll need to buy another mail server, but I think i recall that was one of the fixes that was incorporated in the 5.1update. Does anyone else remember? And is the CF5.1update still available? I'm sorry I dont remember myself.It's all so long ago. ah ... how time passes! -- Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: CF5.0 - sending many emails
Hey Mike, Here's the page with all the updaters for CF. http://www.macromedia.com/support/coldfusion/downloads_updates.html#up dater I don't see a CF5 updater (or 5.1 anywhere -- didn't remember there being a 5.1 release / update) but there's a link to the hotfix / security update page which does have a list of all the hotfixes for CF5. http://www.macromedia.com/support/coldfusion/ts/documents/tn17883.htm# 50 Unfortunately the cfmail issue you mentioned in particular doesn't ring any bells for me and I don't see anything comparable after a cursory glance at the hotfix list for CF5. s. isaac dealey954.927.5117 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.sys-con.com/story/?storyid=44477DE=1 http://www.sys-con.com/story/?storyid=45569DE=1 http://www.fusiontap.com [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
Ok, you can see a preview of the tag here: http://www.contentbox.com/claude/customtags/mapdata/mapdataDoc.cfm It should be available at tagStore in a couple of days, when the docs is completed. In your case, you would just need a table for all your blocs, each bloc should use a specific color in the palette and have the color index in a column, finally, each bloc could have all possible values in a status column, ie: 1 = sold, 2 = available 3 = on holding deposit, etc... Use a STEP of 1 -- ___ 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] [Donations and Support]
Re: Displaying a dynamic map - how?
Claude, this looks great.I think it'll do the job well.Our static map is at http://www.tallwoods.com.au/r_stages/r_stage6plan.html and as you can see it's got less than 100 lots to sell, so therere would be room for allocating that many colours to the tag.I guess one of the problems with this approach is if you have too many colours taken up for the tag to modify, you dont have anything left to draw the non-dynamic parts with.But in this case it looks like the approach will work. And it will get us around a problem the client dropped on us last night - it's a retirement village, and a lot of his prospective buyers have netscape4 browsers.So things like using CSS2 or flash arent goin to work.any browser should be able to display a gif though, and all the processing is done on the server.I like it. Please let me know when it's on the tag gallery. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: Claude Schneegans [EMAIL PROTECTED] Date: Mon, 06 Sep 2004 21:11:27 -0400 Subject: Re: Displaying a dynamic map - how? To: CF-Talk [EMAIL PROTECTED] Ok, you can see a preview of the tag here: http://www.contentbox.com/claude/customtags/mapdata/mapdataDoc.cfm It should be available at tagStore in a couple of days, when the docs is completed. In your case, you would just need a table for all your blocs, each bloc should use a specific color in the palette and have the color index in a column, finally, each bloc could have all possible values in a status column, ie: 1 = sold, 2 = available 3 = on holding deposit, etc... Use a STEP of 1 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: OT- netstat report
Not to sure exactly what it could bedid you have any luck with that problem? Yves - Original Message - From: Asim Manzur [EMAIL PROTECTED] Date: Sun, 05 Sep 2004 13:59:11 -0400 Subject: Re: OT- netstat report To: CF-Talk [EMAIL PROTECTED] You were right, none of those PC from internal network can access the website with domain. but if you are right about the another DNS server for internal requests, how it was working fine before. I never added the domains in the host file before. and as soon as website is up, it was opening from all the pcs on network, and there was no DNS that time either. thanks Can you use the domain names on other PCs on the network and see the sites properly? Here, we're behind a firewall using NAT... port forwarding... Presently, I cannot use domain nameswith other PCs on the network. If I do, I just get the firewall box. But the external world has access without trouble. (I'm waiting for this to be fixed) I was told we needed another DNS server to serve internal requests. As I am not the network admin, I have not resolved this problem. So, on the webserver here, I cannot access the site by domain name, even if I'm on the server (the actual box the request comes to) because of the NAT box. Just thought I would throw that out there... Yves - Original Message - From: Asim Manzur [EMAIL PROTECTED] Date: Fri, 03 Sep 2004 09:40:23 -0400 Subject: Re: OT- netstat report To: CF-Talk [EMAIL PROTECTED] Yes I ping the domain from the same machine, and got response. I ping the external static ip, got response. I ping the internal ip, got response. I ping the computer name, got response. infact I ping outside the network and got response as well. thanks On Friday 03 Sep 2004 13:10 pm, Asim Manzur wrote: If I open it as a localhost from the same machine, yes then the website opened, but if I open it with domain, the website is not getting open from this machine, and rest of the world can open. Check the DNS. Can this machine 'ping' it's own real world address (as both an IP and a name) ? -- 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] [Donations and Support]
Re: Free for non-commercial usage? Donationware?
No offense taken, guys. I think the only diff between what Andrew and I originally recommend is that I suggested making the 'lite' non-commercial only.I figure this may be a spur to some corporate types to pay up.I have no idea if that has added any sales its a fairly new idea for me. One thing about this lite vs. pro stuff:You'll add quite a bit to your dev time doing it.Depending on the complexity of the app it can be quite a pain to do updates, as what you wind up doing after the first hackfest is developing so much new code you have to start from scratch to come up with another lite version.Code reuse and some sort of framework (insert your favorite fw name here) helps a lot to minimize that. p.s. if you are in the U.S. and working take a break!Its a holiday already.I'm heading out for a trail ride in a bit.As soon as I finish this one last code bit... Thanks Matt, great thoughts. I'm not crazy about the idea of a lite version simply because I'm not into keeping up two versions (Remember, I'm doing this for fun :)), but it's still a great idea. I'm disappointed to hear that donationware doesn't work... I had hoped we as a community would be more respectful than that! Jake [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
Claude I get no images on any Mac browser Dick On Sep 6, 2004, at 6:11 PM, Claude Schneegans wrote: Ok, you can see a preview of the tag here: http://www.contentbox.com/claude/customtags/mapdata/mapdataDoc.cfm It should be available at tagStore in a couple of days, when the docs is completed. In your case, you would just need a table for all your blocs, each bloc should use a specific color in the palette and have the color index in a column, finally, each bloc could have all possible values in a status column, ie: 1 = sold, 2 = available 3 = on holding deposit, etc... Use a STEP of 1 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
Correction -- if I click on the Map icon I get the map (e.g. Maqp of France)-- just no detail images Dick Claude I get no images on any Mac browser Dick On Sep 6, 2004, at 6:11 PM, Claude Schneegans wrote: Ok, you can see a preview of the tag here: http://www.contentbox.com/claude/customtags/mapdata/mapdataDoc.cfm It should be available at tagStore in a couple of days, when the docs is completed. In your case, you would just need a table for all your blocs, each bloc should use a specific color in the palette and have the color index in a column, finally, each bloc could have all possible values in a status column, ie: 1 = sold, 2 = available 3 = on holding deposit, etc... Use a STEP of 1 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
Hey Claude Since you are building this tag as we speak -- I always thought the nest looking maps were the ones that had the edges (5-6 pixels) a slightly darker shade of the same color -- gives a 3-D effect! Dick Correction -- if I click on the Map icon I get the map (e.g. Maqp of France)-- just no detail images Dick Claude I get no images on any Mac browser Dick On Sep 6, 2004, at 6:11 PM, Claude Schneegans wrote: Ok, you can see a preview of the tag here: http://www.contentbox.com/claude/customtags/mapdata/mapdataDoc.cfm It should be available at tagStore in a couple of days, when the docs is completed. In your case, you would just need a table for all your blocs, each bloc should use a specific color in the palette and have the color index in a column, finally, each bloc could have all possible values in a status column, ie: 1 = sold, 2 = available 3 = on holding deposit, etc... Use a STEP of 1 -- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
cfquery error on new database
ok .. strange scenario. i have a script that is creating a mysql database on the fly. no login/password is required. i create the tables. i create a dsn on the fly as well. once the db is created i try to run a quick query on it but receive an error like: General error: Unknown database 'MYDATABASENAME' but, if i run the script w/o the query at the end, and create a link to another page that runs the same query i omitted it works fine. is there a time limit on how long i need to wait between creating a datbase and accessing it? i even tried to run a loop 1 through 1 between the steps, but no luck. any suggestions? thanks joe [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
Depending on the quality of the original map (digital would be much better than a scan) you should be able to use the trace applications that come with most vector drawing tools to get the map into Flash. well as you can see from the map in question most spatial data start life on paper. these have to be scanned vectorized--depending on the complexity quality of the source document can be like a trip thru hell's slums. think of something like a contour map (representing lines of elevation) in nepal. i've seen plenty of skanky flash maps, especially those representing spatial data with shared topology like polygons representing political boundaries (one boundary is shared among two polygons) where the polygons float around leaving ugly gaps when you symbolize them or dead areas that can't be identified/selected (the most frequently used GIS function is what the heck is that identification, point click on a spatial feature to find out what it is). i know it can be done well (i've some nice flash-based GIS apps, the ones that are produced by the oz antarctica folks like http://aadc-maps.aad.gov.au/atlas/ are sweet) but the effort to get something complex right isn't trivial. and the map in question is fairly complex. there's the lots, lot IDs, setbacks, roads, vegetation, etc. besides the bits of the golf course. and while that map might show lots' status, it's almost impossible to know the lot ids from that map. if i was a nosy so-and-so i'd like a lot near the entrance so i can watch comings goings, which exact lot is that? if i was a bit paranoid of terrible golfers, i might be worried about getting beaned by stray golfballs or having one come thru my living room window. which lots are in beaning distance of the fairway? I'm a huge fan of CorelDraw which comes with CorelTrace - it'll do the job nicely given decent input. when we did this for a living, i swore by r2v http://www.ablesw.com/ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
Claude, this looks great.I think it'll do the job well.Our static map is at http://www.tallwoods.com.au/r_stages/r_stage6plan.html and as you can see it's got less than 100 lots to sell, so therere would be room for allocating that many colours to the tag. Yes, I look at your image, and there will be some work to do on it, but not that much, The way to do it would be to lower the number of colors to about 50 or 60, which is quite enough to get the bacgrounds, the trees, etc. Then you should define about 60 new coulours in the palette, and paint each area with one of them. and save the file in gif format. A couple of hours of work. it's a retirement village, and a lot of his prospective buyers have netscape4 browsers.So things like using CSS2 or flash arent goin to work.any browser should be able to display a gif though, and all the processing is done on the server.I like it. I just checked it under Netscape 4, and the image does not show, but is is certainly a minor problem, probably the same kind of problem Dick has on his Mac. Please let me know when it's on the tag gallery. Ok, but don't expect it to be free, although really not expensive. -- ___ 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] [Donations and Support]
Re: Displaying a dynamic map - how?
I get no images on any Mac browser I don't get them under any version of Netscape either, it must be a problem with MIME types or so. The image is sent using a CFCONTENT TYPE=image/gif tag, but it probabily needs some more stuff added in the header, I'll check this tomorrow. -- ___ 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] [Donations and Support]
RE: Displaying a dynamic map - how?
You don't have to tell me how much of a pain the ass maps can be.;^) The New Year's Eve site I do (www.firstnight.org http://www.firstnight.org/ ) needs a fairly complex map of Boston with locations and special markers which of course change every year.I've been doing the site going on nine years and the map is always one of the most challenging aspects. If you do what to vectorize it then I would first try to eliminate as much detail as you can from the map.For the conversion process you don't need any of the text, doted lines or cars for example.You might then posterize the image to cut down on the number of colors (it'll make for a cleaner trace). This looks like a surveyors map - you might want to see if you can get a hold of the pure lot map without the trees - that would make things much simpler. In fact if you might see if there's a digital original.It doesn't look to me like this was hand-drawn - many of the features are exact clones of each other.(Of course I still want to date Jessica Rabbit so my grasp of what's real and what's generated is tenuous at best).At the very least see if you can snag a higher resolution version to do the trace. After the trace most programs offer a node reduction tool (hopefully automated) that will simplify the vector at the cost of some detail. Once you've got the trace you could just use the lot shapes as an overlay using the real map as the base layer.If you did go with Flash you could make some very nice transparency effects using them. It's tedious as hell, but do the kind of thing you're talking about you're going to have get into this map pretty deeply anyway and a lot of this stuff just needs to be done by hand. Jim Davis _ From: Paul Hastings [mailto:[EMAIL PROTECTED] Sent: Monday, September 06, 2004 11:40 PM To: CF-Talk Subject: Re: Displaying a dynamic map - how? Depending on the quality of the original map (digital would be much better than a scan) you should be able to use the trace applications that come with most vector drawing tools to get the map into Flash. well as you can see from the map in question most spatial data start life on paper. these have to be scanned vectorized--depending on the complexity quality of the source document can be like a trip thru hell's slums. think of something like a contour map (representing lines of elevation) in nepal. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
Re: Displaying a dynamic map - how?
Thanks for your advice Jim.I never cease to be amazed at the amount of knowledge on this list.Collectively, I think CF-Talk comprises all there is to know about ColdFusion and its applicatoins. Anyway, Jim, I spoke to the client today again and he has a vector version of the map graphic.It's either a Illustrator file or a Freehand file,either way I can import it into Freehand and then work on it from there.I think image files can go directly into Flash2004Pro from Freehand.Or if not, saving it to EPSformat will allow it to be imported into almost anything.But having a vectorised drawing will most definitely cut down the amount of work i have to do, and if i'm careful it'll make sure i dont have to verify the accuracy of every detail, because it's the client's work not mine. Cheers Mike Kear Windsor, NSW, Australia AFP Webworks http://afpwebworks.com .com,.net,.org domains from AUD$20/Year - Original Message - From: Jim Davis [EMAIL PROTECTED] Date: Tue, 7 Sep 2004 00:52:50 -0400 Subject: RE: Displaying a dynamic map - how? To: CF-Talk [EMAIL PROTECTED] You don't have to tell me how much of a pain the ass maps can be.;^) The New Year's Eve site I do (www.firstnight.org http://www.firstnight.org/ ) needs a fairly complex map of Boston with locations and special markers which of course change every year.I've been doing the site going on nine years and the map is always one of the most challenging aspects. If you do what to vectorize it then I would first try to eliminate as much detail as you can from the map.For the conversion process you don't need any of the text, doted lines or cars for example.You might then posterize the image to cut down on the number of colors (it'll make for a cleaner trace). This looks like a surveyors map - you might want to see if you can get a hold of the pure lot map without the trees - that would make things much simpler. In fact if you might see if there's a digital original.It doesn't look to me like this was hand-drawn - many of the features are exact clones of each other.(Of course I still want to date Jessica Rabbit so my grasp of what's real and what's generated is tenuous at best).At the very least see if you can snag a higher resolution version to do the trace. After the trace most programs offer a node reduction tool (hopefully automated) that will simplify the vector at the cost of some detail. Once you've got the trace you could just use the lot shapes as an overlay using the real map as the base layer.If you did go with Flash you could make some very nice transparency effects using them. It's tedious as hell, but do the kind of thing you're talking about you're going to have get into this map pretty deeply anyway and a lot of this stuff just needs to be done by hand. Jim Davis [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]