RE: CF form puzzler

2011-05-09 Thread Stephens, Larry V
No - standard text field. That doesn't mean they couldn't copy-and-paste from something else but, given the size of the answers (they are enteriing county names, one, maybe two), I find that very unlikely. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent:

Re: CF form puzzler

2011-05-09 Thread Claude Schnéegans
I keep seeing html charcters in the field and the latest entry has 300-400 lines of MS Word html code and, at the very end, the true entry Pierce amp; Madison Co.s Is it possible that you are having two fields using the same name in the form ?

Scripting of adding a Database - CF8

2011-05-09 Thread Matthew Friedman
Does anyone now of a library - tag or tutorial on how to script the process of adding a database to CF8. I am looking to streamline a process of on boarding new clients with out having to go into cfadmin site for each. Thanks in advance. Matt

Re: Scripting of adding a Database - CF8

2011-05-09 Thread Wil Genovese
Have you looked into the CFAdmin API? You can do all this from code using this API. Wil Genovese Sr. Web Application Developer/ Systems Administrator CF Webtools www.cfwebtools.com wilg...@trunkful.com www.trunkful.com On May 9, 2011, at 10:16 AM, Matthew Friedman wrote: Does anyone now

Re: Scripting of adding a Database - CF8

2011-05-09 Thread John M Bliss
Add database (SQL Server): SEE: http://msdn.microsoft.com/en-us/library/ms176061.aspx CREATE DATABASE [mydatabasename] Add datasource: SEE: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fcf.html On Mon, May 9, 2011 at 10:16 AM, Matthew Friedman

Re: Scripting of adding a Database - CF8

2011-05-09 Thread Gerald Guido
Have you looked into the CFAdmin API? You can do all this from code using this API. + 1. I have to code to do that sitting around here some where. Not production ready but it would give you a start in the right direction. G! On Mon, May 9, 2011 at 11:26 AM, Wil Genovese jugg...@trunkful.com

Re: Scripting of adding a Database - CF8

2011-05-09 Thread Russ Michaels
On Mon, May 9, 2011 at 4:47 PM, Gerald Guido gerald.gu...@gmail.com wrote: Have you looked into the CFAdmin API? You can do all this from code using this API. + 1. I have to code to do that sitting around here some where. Not production ready but it would give you a start in the right

Re: Scripting of adding a Database - CF8

2011-05-09 Thread Gerald Guido
Here it is My bad... http://cfmladminapi.riaforge.org/ HTH G! On Mon, May 9, 2011 at 11:47 AM, Gerald Guido gerald.gu...@gmail.comwrote: Have you looked into the CFAdmin API? You can do all this from code using this API. + 1. I have to code to do that sitting around here some

Re: Form Field Validation - codon boundaries

2011-05-09 Thread Rick Colman
I should have provided more detail. This has to do with nucleotide strings in DNA. for example, consider the follow string: 123 456 789 act gta ccc ... (spaces not in string, just for clarity) Any start position must begin at position 1,4,7, etc. Any end position must conclude at position

Re: Form Field Validation - codon boundaries

2011-05-09 Thread Ras Tafari
i dont know how, but im going to say some regex work here would do the trick. On Mon, May 9, 2011 at 1:51 PM, Rick Colman rcol...@cox.net wrote: I should have provided more detail. This has to do with nucleotide strings in DNA. for example, consider the follow string: 123 456 789 act  

cf_sql_timestamp

2011-05-09 Thread Dave Sueltenfuss
I've always used cf_sql_timestamp, in cfqueryparams, when using a value with a date and time. Comparing the online documentation, between CF8 and CF9, it looks like this datatype is now intended to map to the sql timetamp datatype in CF9.is this correct, or just mis-documentation?

Re: cf_sql_timestamp

2011-05-09 Thread Leigh
is this correct, or just mis-documentation? IMO it is an error. datetime and smalldatetime are valid types, yet they are missing entirely from the CF9/MSSQL column. My recollection is the ms sql timestamp type maps to cf_sql_binary, not cf_sql_timestamp, like in the CF8 documentation.

Re: Solr Errors

2011-05-09 Thread Raymond Camden
Just checking in Mary. Were you able to get past this? Have you considering contacting Adobe for official support? On Mon, Apr 11, 2011 at 2:41 PM, Mary Jo Sminkey mary...@cfwebstore.com wrote: What are you loading into your index (queries or documents)?  Can you provide a code snippet of

Re: Invalid Precision Value from SQL Server CF9

2011-05-09 Thread Nicki Tabb
yes, I could do it that way. However, all dates I try to insert are giving the error, not just ones I'm using the function #now()# in. Turns out the issue is my data source in CF. We have been using the ODBC socket to connect CF to the System DSN which uses the SQL Native driver. When I

RE: Scripting of adding a Database - CF8

2011-05-09 Thread Bobby Hartsfield
Everything you need is in the Admin API. Specifically... the datasource.cfc Here is a quick snippet for creating a SQL Server CF dsn. cfscript adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(arguments.cfadminpassword); dbObj =

Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Jenny Gavin-Wear
I'm interested in any info. Pit falls to avoid, best practises, etc. Many thanks, Jenny No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.900 / Virus Database: 271.1.1/3625 - Release Date: 05/08/11 19:34:00

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Russ Michaels
don't forget that MSSQL express is also free and more powerful than mysql community edition so there is no need to migrate to MySQL unless your also moving to Linux. There are however free migration tools on the mysql site that will do it for you. On Mon, May 9, 2011 at 11:29 PM, Jenny

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Jordan Michaels
I find the more powerful comment humorous. SQL Express limits are here: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx Migration from MS SQL to MySQL documentation is here: http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-mssql.html

(ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version

2011-05-09 Thread Gerald Guido
Quick question: Does the 64 bit Windows server 2k3 (and CF server 8.x 64 bit) use enough extra RAM than the 32 bit version for it to be significant? I am looking @ a Windows server 2k3 VPS with one gig of ram and was wondering if getting the 64 bit version would make any difference in terms of

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Gerald Guido
Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql Jordan Michaels jor...@viviotech.net wrote: I find the more powerful comment humorous. This should be fun to watch :) I am making some popcorn. Anyone want some? G! On Mon, May 9, 2011 at

Re: (ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version

2011-05-09 Thread Judah McAuley
64-bit OS only comes into play if you are going to be taking advantage of a lot of ram. If you are doing under 4 gigs for the box, there is no reason for a 64-bit OS, go with 32-bit. Judah On Mon, May 9, 2011 at 4:08 PM, Gerald Guido gerald.gu...@gmail.com wrote: Quick question: Does the 64

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Russ Michaels
Perhaps you tried to run MSSQL on linux Jordan, that would certainly be humorous I imagine :-) On Tue, May 10, 2011 at 12:12 AM, Gerald Guido gerald.gu...@gmail.comwrote: Russ Michaels wrote: don't forget that MSSQL express is also free and more powerful than mysql Jordan Michaels

Re: (ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version

2011-05-09 Thread Gerald Guido
Thanx Judah. This list = awesome! G! On Mon, May 9, 2011 at 7:15 PM, Judah McAuley ju...@wiredotter.com wrote: 64-bit OS only comes into play if you are going to be taking advantage of a lot of ram. If you are doing under 4 gigs for the box, there is no reason for a 64-bit OS, go with

Re: (ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version

2011-05-09 Thread Russ Michaels
It would depend what you want to achieve. on 32bit you can only give 1GB or so to CF, with 64bit you can give a lot more. But if you are only going to have 1GB RAM anyway then there is no point as you will only really be able to give 512mb to CF anyway. On Tue, May 10, 2011 at 12:15 AM, Judah

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Judah McAuley
Well, it is pretty damn funny. I've migrated from MS SQL to MySql before and it generally isn't too bad. There are various migration tools available, I like the ones from Red Gate. MySql has some funkiness that comes into play if you want to combine foreign keys and full text indexing from what

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Judah McAuley
Or possibly Jordan has needed a database that runs on more than 1 CPU, uses more than 1GB of RAM or has a db size of more than 10GB :) On Mon, May 9, 2011 at 4:20 PM, Russ Michaels r...@michaels.me.uk wrote: Perhaps you tried to run MSSQL on linux Jordan, that would certainly be humorous I

Re: (ot) Ram usage for 64 bit Windows server 2k3 VS the 32 bit version

2011-05-09 Thread Gerald Guido
Thanx Russ, It is just an el-cheapo VPS for my dev and hobby sites so it is no big deal. Thanx G! On Mon, May 9, 2011 at 7:23 PM, Russ Michaels r...@michaels.me.uk wrote: It would depend what you want to achieve. on 32bit you can only give 1GB or so to CF, with 64bit you can give a lot

Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-09 Thread Robert Rhodes
Hello again. Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition? Or do I need to buy Standard edition licenses? Also, so I still need to install the II6 compatibility extensions? Or has that all be sorted out now. RR

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Russ Michaels
Many people often wrongly assume that MySQL is simply FREE, which is not correct. Many people are also completely unaware that there is a FREE MSSQL Express edition. The FREE version is the community edition, which also has limitations, look them up, If you want enterprise features then you have

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-09 Thread Russ Michaels
yes it will run fine. The limitations of web edition are windows related, you cannot installed MSSQL for example, but it doesn;t stop you installing any 3rd party software. On Tue, May 10, 2011 at 12:55 AM, Robert Rhodes rrhode...@gmail.com wrote: Hello again. Just a quick question. Will

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-09 Thread Gerald Guido
It should run fine. I installed it no problem on the Web Server Edition. Web Server Edition is just a feature limited version of the Standard version. HTH G! On Mon, May 9, 2011 at 7:55 PM, Robert Rhodes rrhode...@gmail.com wrote: Hello again. Just a quick question. Will Coldfusion 9 run

ISP blocking port 25

2011-05-09 Thread Al Musella, DPM
Big problem.. I use verizon fios for my Internet connection. It is a business class - static IPs and specifically allows web and email servers. Was working really nice.. then today around 1pm, I couldn't send email. My mail server (smartermail) log said couldn't connect to server..

RE: ISP blocking port 25

2011-05-09 Thread Jenny Gavin-Wear
Hi Al, Do you route all of your out-going mail to one server? Because that's a horrible way to do it if you are sending out a lot of mail, exactly because of the experience you have now. Have they told you what port you can use? If so, you can change the port on Coldfusion in CF Admin: Server

RE: ISP blocking port 25

2011-05-09 Thread Al Musella, DPM
I can use any port except for 25 right now. Going from the coldfusion 7 server to the smartermail server (different boxes but within my local network) is no problem, so making a change in cf administrator won't help. The problem is a router between me and the rest of the internet that

Re: Help! Too much tracffic and too little time!

2011-05-09 Thread Brian Polackoff
So how did your first day go? Any load issues with the setup the good folks on this recommended? Brian Polackoff On May 8, 2011, at 9:46 AM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 8/05/2011 10:58 PM, Robert Rhodes wrote: I installed Win2K8 on one of the servers last night, and

Re: ISP blocking port 25

2011-05-09 Thread Ben Conner
Hi Al, If Verizon is blocking delivery from Smartermail outside their own network, there is nothing you can do. Port 25 is the only port for email to be delivered on. Verizon has violated their terms of service by denying you use of your connection. This is the classic definition of an

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-09 Thread Dave Watts
Just a quick question.  Will Coldfusion 9 run fine on Windows 2008 R2 Server Web Server Edition?  Or do I need to buy Standard edition licenses? Yes, you can install CF on any version of Windows Server 2008. Also, so I still need to install the II6 compatibility extensions? Or has that all

Re: ISP blocking port 25

2011-05-09 Thread Kym Kovan
On 10/05/2011 12:51, Ben Conner wrote: And you can't use a gateway server as that will be delivered on port 25 as well. How about port 587, the alternate port for authenticated mails, that should still be open. If not maybe a completely different port to a gateway where that is

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-09 Thread Robert Rhodes
I do use MSSQL, but never on server that is web-facing. So, that will not be a problem. On Mon, May 9, 2011 at 8:00 PM, Russ Michaels r...@michaels.me.uk wrote: yes it will run fine. The limitations of web edition are windows related, you cannot installed MSSQL for example, but it doesn;t

Re: Migrating a DB from MS SQL 2000 into MySQL latest release

2011-05-09 Thread Judah McAuley
MySql is free though licensing is a bit complicated because of a dual-license model. The community edition includes many enterprise sorts of features like replication and partitioning. If I recall, there are additional backup tools and monitoring in the paid enterprise edition. If you want to go

Re: ISP blocking port 25

2011-05-09 Thread Judah McAuley
If you have a VM or something outside of their network, then you could set up an SSH tunnel and do port forwarding, having your local port 25 get tunneled over to the remote machine and then sent out from there. Judah On Mon, May 9, 2011 at 5:36 PM, Al Musella, DPM muse...@virtualtrials.com

Re: Coldfusion 9 on Windows 2008 R2 Server Web Server Edition?

2011-05-09 Thread Robert Rhodes
Dave pardon the lame question, but which install option do I pick if not server configuration? And then how do I hook up to IIS after the fact? RR On Mon, May 9, 2011 at 10:56 PM, Dave Watts dwa...@figleaf.com wrote: Just a quick question. Will Coldfusion 9 run fine on Windows 2008 R2

Re: Help! Too much tracffic and too little time!

2011-05-09 Thread Robert Rhodes
I talked them into a few more days. Currently we are aiming for Friday. Phew! On Mon, May 9, 2011 at 10:26 PM, Brian Polackoff bpolack...@gmx.com wrote: So how did your first day go? Any load issues with the setup the good folks on this recommended? Brian Polackoff On May 8, 2011, at

Re: ISP blocking port 25

2011-05-09 Thread Azadi Saryev
in the meantime, try port 26 - it usually works fine (unless it is blocked). Azadi On 10/05/2011 08:36 , Al Musella, DPM wrote: So - anyone have any ideas on what I can do from now until it is fixed? I changed the retries on my mail server to 6,12,18,24 hours so hopefully the mail in the