Re: How to protect PDF documents from direct access

2010-05-03 Thread Rick Colman
I am on a shared host, so moving outside the web directories is not practical. On 5/3/2010 4:09 PM, Dave Watts wrote: > >> Is there some easy way to protect PDF (and perhaps other kinds of documents) >> from sideaways access? >> >> In other words, after building login pages, protecting html

CF Builder Install Problem

2010-05-25 Thread Rick Colman
The trial version of CF Builder thinks I already have Eclipse installed, and is asking for the relevant directory. I can't recall such an install, but who knows. Any ideas appreciated. Rick. ~| Order the Adobe Coldfusion Anth

Problems with CF9 Web Server Install

2010-06-08 Thread Rick Colman
Trying to do a first-time install of CF9 on Windows Server 2008 using IIS. Unfortunately, when the installer asks you to select a web server, it just shows Apache and Sun web servers, NONE of which are installed on this machine. What gives? Please advise. TNX. Rick

Re: Problems with CF9 Web Server Install

2010-06-08 Thread Rick Colman
Actually, I was using the wrong login, which was causing the problem. However, here is another one. Trying to configure the web server, I get an error message while trying to add the IIS7 server: cannot find file \wsconfig\1\jrun_iis6_wildcard.dll problem is that: (1) there is no "1" fold

Re: Problems with CF9 Web Server Install

2010-06-08 Thread Rick Colman
It was a compatibility layer, and the video was very helpful. Why can't adobe do something like that ??? too simple, I guess. On 6/8/2010 4:48 PM, Dave Watts wrote: > >> Trying to configure the web server, I get an error message while trying >> to add the IIS7 server: >> >> cannot find file

Converting a trial version to standard

2010-06-30 Thread Rick Colman
I want to buy a license for CF9 to convert an installed trial version to a standard edition. I need a third-party to do it, who does not want me to get their credit-card info (bye-bye Las Vegas). What is the easiest way to buy and install the license? Rick. ~~

Re: Converting a trial version to standard

2010-06-30 Thread Rick Colman
easiest way to buy the license key ...??? On 6/30/2010 1:18 PM, Dorioo wrote: > I think you just enter the license key in the administrator. And > voila, trial becomes standard. > > - Gabriel > > On Wed, Jun 30, 2010 at 4:16 PM, Rick Colman wrote: > >> I want

Re: Converting a trial version to standard

2010-06-30 Thread Rick Colman
:18 PM, Dorioo wrote: > I think you just enter the license key in the administrator. And > voila, trial becomes standard. > > - Gabriel > > On Wed, Jun 30, 2010 at 4:16 PM, Rick Colman wrote: > >> I want to buy a license for CF9 to convert an installed trial version to

looping syntax inside a function?

2010-09-27 Thread Rick Colman
Do anyone know what the proper syntax is for adding a loop variable to a variable name, like the following, which is not working: ... etc. Invalid CFML construct found on line 47 at column 29. ColdFusion was looking at the following text: # The CFML compiler was processing: A cfset tag

arrays and looping around

2010-09-27 Thread Rick Colman
I can't seem to get this working, and it should not be that tough? Here what I am trying to do: * get the number of form variables coming in * loop through the number of variables coming in, and as each form variable comes in, do a query * store the results of the query in an another varia

Re: arrays and looping around

2010-09-28 Thread Rick Colman
so, do I need to declare an array in advance, or is this implicit. so, I guess this does not work either: On 9/27/2010 7:37 PM, Michael Grant wrote: >> #form['ExpOrg_ID_'& loopCount]# >> > A.K.A. "Array Notation" and can be applied to any variable scope, not > just the form scope, though th

looping through an insert statement

2010-10-26 Thread Rick Colman
Is this the correct syntax for looping through an insert: Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '#thisprojectid#', '#form['ProteinSequence' & LoopCount]#', '#form['genename' & LoopCount]#', '#form['NoAminoAcids' & LoopCoun

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
that did not work. what is funny is that the debug sql statement looks ok : Insert into ProteinSequence (Project_ID, AA_Sequence, Gene_Name, Count) Values( '20', 'sdalifsdaifasifsadi', 'g1', '15' ) On 10/26/2010 10:40 AM, Michael Grant wrote: > Maybe try this instead: > > Values( > '#thisp

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
equence" & LoopCount]#', '#form["genename" & LoopCount]#', '#form["NoAminoAcids" & LoopCount]#' ) On 10/26/2010 10:51 AM, Michael Grant wrote: > Could you post your code? > If you only loop a single time do you still get th

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
sdafklfsaklfsdklaf On 10/26/2010 11:00 AM, Michael Grant wrote: > And Project_ID, AA_Sequence, Gene_Name and Count are all string fields? > > > On Tue, Oct 26, 2010 at 1:58 PM, Rick Colman wrote: > >> It seems to die on the first loop because nothing gets inserted

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
yes, thank you, the form variables are actually there. On 10/26/2010 11:05 AM, Greg Morphis wrote: > Those are all coming from a form so have you tried dumping the form scope? > Make sure proteinsequence exists in the form > On Oct 26, 2010 12:59 PM, "Rick Colman" wrote: &g

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
ckboxes, an unchecked on would cause some chaos for sure (as it would > be undefined) > > HTH > > Cheers > > On Tue, 2010-10-26 at 11:07 -0700, Rick Colman wrote: > >> actually, two are int, so revised, but still did not work: >> >> >>

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
here it is: struct COMMONNAME1 Bacillus subtilis EXPORG_ID1 314 FIELDNAMES NUM_GENES,PROJECTNAME,PURPOSE,GENENAME1,PROTEINSEQUENCE1,NOAMINOACIDS1,GENENAME2,PROTEINSEQUENCE2,NOAMINOACIDS2,EXPORG_ID1,COMMONNAME1,NOTES GENENAME1 g1 GENENAME2 g2 NOAMINOACIDS1 15 NOAMINOACID

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
sdalifsdaifasifsadi which is what it should be ... On 10/26/2010 11:55 AM, Michael Grant wrote: > #form['ProteinSequence'&1]# ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/d

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
le > > On Tue, 2010-10-26 at 11:24 -0700, Rick Colman wrote: > >> ok, maybe I am cross-eyed and (tried matching cases), but: >> >> PROTEINSEQUENCE1 sdalifsdaifasifsadi >> >> equals >> >> '#form['ProteinSequence'&Loo

Re: looping through an insert statement

2010-10-26 Thread Rick Colman
It is more than possible, it is likely ... typo ... SORRY On 10/26/2010 12:38 PM, Michael Grant wrote: > Is it at all possible you've got the table name incorrect? > > On Tue, Oct 26, 2010 at 2:24 PM, Rick Colman wrote: > >> ok, maybe I am cross-eyed and (tri

Getting Record Number within a Looping Query

2010-11-01 Thread Rick Colman
If I am looping over a query, how do I get the current record number for the loop? e.g. If I am looping for a fixed number of iterations, I can use an index="loopcount" and get the current loop number. How do I do this for a query? TNX. rick.

What is wrong with this loop update?

2010-11-02 Thread Rick Colman
I am trying to update multiple rows by looping through: (diagnostics) row: #GetExpOrg.currentrow# id: #GetExpOrg.ExpOrg_ID# update Project_ExpOrg set OrgValue=(select org_value from expressionorganism3 where exporg_id = #GetExpOrg.ExpOrg_ID#) where pr

Best Way to Trap SQL Error

2010-11-08 Thread Rick Colman
What is the best way to gracefully trap this sort of error ... Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1. The error occurred on line 3. TNX for any suggestions. Rick. ~~

Re: Best Way to Trap SQL Error

2010-11-08 Thread Rick Colman
This was a really good idea, and solved the problem. I validated for an integer, and the error went away. TNX. On 11/8/2010 7:49 AM, Michael Grant wrote: > The best way would be to validate the data before getting your database > involved. > > > On Mon, Nov 8, 2010 at 10:07

Countries Select Box

2010-11-11 Thread Rick Colman
I need to provide world-wide country postal abbreviations in a drop-down select box. there must be one of those out there, although I have searched. Anybody know where to get one. TNX. rick. ~| Order the Adobe Coldfusion Ant

Re: Countries Select Box

2010-11-11 Thread Rick Colman
that worked. write me if you want a copy ... On 11/11/2010 10:15 AM, John M Bliss wrote: > Little find-and-replace on this and you should be good to go: > http://snipplr.com/view/33790/form-country-code-select-with-if-selected-test/ > > On Thu, Nov 11, 2010 at 12:06 PM, Rick C

Homesite on Windows 7

2010-11-15 Thread Rick Colman
I STILL like homesite because it is file based - NOT projects. I don't do projects ... Anyways, did anyone ever solve the problem where HomeSite will not do a "save as" in Windows 7? I know there is a work around (file - create here - copy & paste - save) but it is still a pain. TNX. Rick.

Re: Homesite on Windows 7

2010-11-16 Thread Rick Colman
I am having the same problem trying to "save as" on my web directories on a remote server (CrystalTech). Could it be another dumb Vista/Windows 7 security hack? On 11/16/2010 8:04 AM, Michael Grant wrote: > This is how I have mine set up and I still can't create a new file (CTRL+N) > and then s

REGEX hell

2010-11-22 Thread Rick Colman
I am trying to replace two trailing parens )) with a single paren. here is a sample string: (K AAA) (N AAC) (E GAA) ) looks like there is a space in between the two )), so I tried: but this is not working. Any ideas as two what is wrong greatly appreciated. ~~~

Re: REGEX hell

2010-11-22 Thread Rick Colman
This worked!! TNX. On 11/22/2010 6:04 PM, Michael Dinowitz wrote: > Are you sure it's a space and not 2 spaces? Or a tab? Try using \s* to > indicate that there may be one or more space characters. > > \)\s*\) > > > > On Mon, Nov 22, 2010 at 8:48 PM, Rick Colma

How to Display "lined up" Output

2010-11-23 Thread Rick Colman
I have a lot of nucleotide data coming back from a query, that looks like: (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) (D GAT) (T ACT) (E GAA) (S TCT) (W TGG) (K AAA) (S TCT) (Y TAC) (Y TAC) (K AAA) (S TCT) (D GAT) (P CCA) (L CTG) (C TGC) (S TCT) (A GCT) (V

Re: How to Display "lined up" Output

2010-11-23 Thread Rick Colman
) (Y TAC) (Q CAG) (K AAG) (K AAA) (L CTG) (E GAA) (L TTG) (S TCT) (E GAA) etc. On 11/23/2010 10:18 AM, Rick Colman wrote: > I have a lot of nucleotide data coming back from a query, that looks like: > > (T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) > (I ATC) (D

Re: How to Display "lined up" Output

2010-11-23 Thread Rick Colman
I may need to "copy and paste" the text string into another form field. Putting in extra ascii characters (like a line break) may screw things up because of the way the text is later processed. apparently, does not work with ... On 11/23/2010 10:29 AM, Justin Scott wrote: >> It looks like on

Re: How to Display "lined up" Output

2010-11-23 Thread Rick Colman
by itself works great, but then I get one giant long 500 character text line ... On 11/23/2010 10:29 AM, Ian Skinner wrote: >If you don't want to use a table or grid, you may also want to try > then under utilized... tags that gives you old fashioned > character alignment, over riding the

moving data from sub-window into a form

2010-11-23 Thread Rick Colman
Here is what I am trying to do: a) open a form - several form fields will have an IMPORT button b) IMPORT button opens a sub-window (cfwindow) which runs a query and displays the query results in a table c) select one of the rows in the sub-window with another button. Take the data from the s

Re: moving data from sub-window into a form

2010-11-23 Thread Rick Colman
field. On 11/23/2010 5:41 PM, Rick Colman wrote: > Here is what I am trying to do: > > a) open a form - several form fields will have an IMPORT button > > b) IMPORT button opens a sub-window (cfwindow) which runs a query and > displays the query results in a table > > c) s

How to make a CFSELECT Required

2010-11-29 Thread Rick Colman
I want to force the user to select a country code when submitting a form. The select box looks like: selected>Please select selected >Australia etc. I do not want them to be able to select the "value=""" option. How to do this? Rick. ~

splitting a string into multiple sections

2010-12-03 Thread Rick Colman
If I have a long text string, and want to chop it up into sections and extract each section, like: (1 537 825) first section is position 1-536 second section is position 537 to 824 third section is 825-end can someone suggest a CF approach to do it? have not done it before. tnx if you can he

Monster Regex

2010-12-06 Thread Rick Colman
Been whacking at this one for a while, and it eludes me. ((T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) (I ATC) ;0-9 (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ;1210-1218) remove only single leading paren ( remove only trailing single pare

Re: Monster Regex

2010-12-06 Thread Rick Colman
this mostly worked, but did not remove one of the last trailing double )) results like: (T ACT) (N AAC) (D GAT) (T ACT) (A GCT) (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N AAC) (E GAA) ) On 12/6/2010 11:26 AM, Jason Fisher wrote: > clean = replaceList(reReplace(x, "\s*;\d+-\d+",

Re: Monster Regex

2010-12-06 Thread Rick Colman
on, Dec 6, 2010 at 12:03 PM, Rick Colman wrote: >> Been whacking at this one for a while, and it eludes me. >> >> ((T ACC) (I ATT) (T ACT) (P CCA) (E GAA) (T ACT) (S TCC) (R CGT) (P CCA) >> (I ATC) ;0-9 >> (T ACT) (M ATG) (D GAT) (H CAC) (L CTG) (E GAG) (K AAA) (N

Re: Monster Regex

2010-12-06 Thread Rick Colman
ot;, "all"), "((", > "(", "all"), ")\s*)", ")", "all") > > > > From: "Rick Colman" > Sent: Monday, December 06, 2010 3:28 PM > To: "cf-talk" > Subject: Re: Mo

Re: Monster Regex

2010-12-06 Thread Rick Colman
;), "((", > "(", "all"), "\)\s*\)", ")", "all") > > > > From: "Rick Colman" > Sent: Monday, December 06, 2010 3:55 PM > To: "cf-talk" > Subject: Re: Monster Regex > > getting malformed

Passing a Variable from within a loop to CFWINDOW

2010-12-14 Thread Rick Colman
I am looping to populate a form with a variable number of form fields, as needed. I am also trying to call a CFWINDOW from within a loop as follows: onClick="ColdFusion.Window.show('SelectConstruct')"> How do I pass a variable that shows the current loopcount to the CFWINDOW? I don't even kn

Exporting a Spreadsheet file

2010-12-20 Thread Rick Colman
This works fine in IE, etc. : However, in Google Chrome, it writes a file with a .CFM extension instead of a .XLS extension, causing problems for users. Anyone else seen this problem? Is the a CF workaround? Rick. ~| Order

Re: Exporting a Spreadsheet file

2010-12-20 Thread Rick Colman
This worked! TNX. On 12/20/2010 10:46 AM, Ian Skinner wrote: >On 12/20/2010 10:41 AM, Rick Colman wrote: >> This works fine in IE, etc. : >> >> > value="buylist_job_#session.projectid#.xls"> > This is the way I usually see and use that tag. > &g

Open source - No Mortgage

2011-01-13 Thread Rick Colman
I guess I am "old school" but I have car payments, a mortgage, etc. etc. All of this open source/freeware stuff leaves me a little mystified. I suppose that it is possible to make some money around the "edges" of these technologies, but, I have this vision of an army of "geeks" working on thes

will not export excel to excel

2011-04-20 Thread Rick Colman
I am trying to output the results of a query to Excel, but instead, it opens CF Builder. Please advise. TNX. select location,score from SPDOut where SPDINput_id=#url.id# order by location Location#chr(delim)#Score#chr(delim)# #chr(13)# #location##chr(delim)##score##chr(13)# ~~

Re: will not export query to excel

2011-04-20 Thread Rick Colman
this works: select location,score from SPDOut where SPDINput_id=#url.id# order by location On 4/20/2011 2:50 PM, Rick Colman wrote: > I am trying to output the results of a query to Excel, but instead, it > opens CF Builder. Please advise. TNX. > >

Re: will not export query to excel

2011-04-20 Thread Rick Colman
this works: select location,score from SPDOut where SPDINput_id=#url.id# order by location On 4/20/2011 2:50 PM, Rick Colman wrote: > I am trying to output the results of a query to Excel, but instead, it > opens CF Builder. Please advise. TNX. > >

Regex Question

2011-04-28 Thread Rick Colman
input looks like: (A XXX)(B YYY)(C ZZZ) I need to pull out: XXXYYYZZZ ... Can somebody help? TNX. Rick. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=h

Re: Regex Question

2011-04-28 Thread Rick Colman
racters)? >> >> -- >> Charlie Griefer >> http://charlie.griefer.com >> >> I have failed as much as I have succeeded. But I love my life. I love >> my wife. And I wish you my kind of success. >> On Thursday, April 28, 2011 at 10:10 AM, Rick Colman wro

converting sed to rereplace ...

2011-05-05 Thread Rick Colman
I am trying to convert strings: (A XXX)(B YYY)(C ZZZ) etc. to XXXYYYZZZ etc. This works in sed: echo "(A XXX)(B YYY)(C ZZZ)" | \ sed -n ' { s/([A-Z]* \([A-Z]*\))/\1/g p } ' but when I put it into rereplace, like: I am getting: \([A-Z]*\))//gp(\([A-Z]*\))//gp \([A-Z]*\))//gp)\([A-Z]*\

Re: converting sed to rereplace ...

2011-05-05 Thread Rick Colman
Eureka! TNX. On 5/5/2011 3:13 PM, Bobby Hartsfield wrote: > > > > .:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > http://cf4em.com > > > -Original Message- > From: Rick Colman [mailto:rcol...@cox.net] > Sent: Thursday

Form Field Validation

2011-05-06 Thread Rick Colman
I have the following: length: xxxstart [ ] end [ ] I would like to test for the following conditions: * must be an integer * start and end must be evenly divisible by 3 * end cannot exceed length CFINPUT works for type test, but not sure how to generate the javascript validati

Re: Form Field Validation - codon boundaries

2011-05-09 Thread Rick Colman
rger than Start."); > return false; > } else if (endVal> lengthVal) { > alert("End cannot be larger than Length."); > return false; > } > return true; > > You could put that into a function and call the function on the form > onsubmit

Re: Rick Colman...

2011-08-01 Thread Rick Colman
I am not doing anything ... so there may be a virus problem on my end. will fix. apologies. On 8/1/2011 2:39 PM, Bobby Hartsfield wrote: > Anyone else getting tons of empty emails from rick colman? Not to the list > but directly to my email address... If you sit next to rick pinch his

How to display LARGE amounts of Data in a Timely Fashion

2009-10-21 Thread Rick Colman
I need to query, retrieve and display a large amount of data; i.e. 4100 rows by 50 columns of numerics, to the browser screen. It is really slow, and after some testing, the bottleneck seems to be on the page that displays the data. The query is OK and connection is ok. But, the user has to wa